Hi Michael, Here is the result int attachment. It looks fine.
Best regards, Fred Le mardi 19 mai 2015 01:26:40 UTC+2, Michael Hunger a écrit : > > try this: > > LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row >> FIELDTERMINATOR ';' >> return row limit 5 >> > > and look at the data. Are there spaces around you'r 'x' ? > > > Am 19.05.2015 um 01:23 schrieb [email protected] <javascript:>: > > No error this time, but it doesn't work since when i do a match n return > n, it returns 0 rows. > > Le mardi 19 mai 2015 00:17:20 UTC+2, Michael Hunger a écrit : >> >> LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row >> FIELDTERMINATOR ';' >> with row >> where row.Lundi = "x" >> match (d:Day {name:"Lundi"}) >> with d,row.Serveur as serverName, collect(row.Script) as scripts >> match (s:Server {name:serverName}) >> merge (d)-[:PROCESS]->(s) >> with s,head(scripts) as first, scripts >> match (scr1:Script {name: first}) >> create (s)-[:EXECUTION]->(scr1) >> with scripts >> unwind range(0,size(scripts)-2) as idx >> MATCH (a:Script {name:scripts[idx]}) >> MATCH (b:Script {name:scripts[idx+1]}) >> CREATE (a)-[:PUIS]->(b) >> >> >> Am 18.05.2015 um 23:32 schrieb [email protected]: >> >> Michael, >> >> Thanks and sorry for that again, i'm lost with that : >> >> WITH is required between CREATE and UNWIND (line 14, column 1 (offset: 386)) >> "unwind range(0,size(scripts)-2) as idx" >> >> Best Regards, >> >> Fred >> >> >> >> Le lundi 18 mai 2015 23:20:27 UTC+2, Michael Hunger a écrit : >>> >>> Sorry, forgot a WITH row >>> >>> LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row >>> FIELDTERMINATOR ';' >>> >>> WITH row >>> >>> where row.Lundi = "x" >>> >>> ... >>> >>> Am 18.05.2015 um 22:20 schrieb [email protected]: >>> >>> Hi Michael, >>> >>> It should be nearly good but it isn't. >>> >>> LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row >>> FIELDTERMINATOR ';' >>> where row.Lundi = "x" >>> match (d:Day {name:"Lundi"}) >>> with d,row.Serveur as serverName, collect(row.Script) as scripts >>> match (s:Server {name:serverName}) >>> merge (d)-[:PROCESS]->(s) >>> with s,head(scripts) as first, scripts >>> match (scr1:Script {name: first}) >>> create (s)-[:EXECUTION]->(scr1) >>> unwind range(0,size(scripts)-2) as idx >>> MATCH (a:Script {name:scripts[idx]}) >>> MATCH (b:Script {name:scripts[idx+1]}) >>> CREATE (a)-[:PUIS]->(b) >>> >>> I've got the following error : >>> >>> Invalid input 'h': expected 'i/I' (line 2, column 2 (offset: 93)) >>> "where row.Lundi = "x"" >>> >>> Thanks a lot for your help. >>> >>> Best Regards, >>> >>> Fred >>> >>> >>> >>> Le samedi 16 mai 2015 23:44:02 UTC+2, Michael Hunger a écrit : >>>> >>>> you need to have the nodes for days, servers, scripts etc. before >>>> otherwise use merge >>>> >>>> Am 16.05.2015 um 23:21 schrieb [email protected]: >>>> >>>> Hi Michael, >>>> >>>> Thanks for your answer, i tried to followyour solution but without >>>> success. >>>> >>>> LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row >>>> FIELDTERMINATOR ';' >>>> merge (d:Day {name:"Lundi"}) >>>> where row.Lundi = "x" >>>> with d,row.Serveur as serverName, collect(row.Script) as scripts >>>> merge (s:Serveur {name:serverName}) >>>> merge (d)-[:PROCESS]->(s) >>>> with s, scripts, size(scripts) as size >>>> merge (scr1:Script {name: scripts[0]}) >>>> create (s)-[:EXECUTION]->(scr1) >>>> FOREACH (idx in range(0,size-2) | >>>> MERGE (s1:Script {name:scripts[idx]}) >>>> MERGE (s2:Script {name:scripts[idx+1]}) >>>> CREATE (s1)-[:AFTER]->(s2)) >>>> WITH scripts, s >>>> >>>> When i do a match n return n it returns nothing. >>>> >>>> Thanks for your help. >>>> >>>> Best regards, >>>> >>>> Fred >>>> >>>> Le vendredi 15 mai 2015 11:49:23 UTC+2, [email protected] a écrit : >>>>> >>>>> Hi all, >>>>> >>>>> I've got .csv file with servers and scripts and days >>>>> >>>>> Serveur Script Lundi Mardi Samedi >>>>> AALTO Script1 x x x >>>>> AALTO Script2 x x >>>>> AALTO Script3 x >>>>> AALTO Script4 x >>>>> ABBOTT Script5 x x >>>>> ABBOTT Script6 x >>>>> ABBOTT Script7 x >>>>> ABBOUD Script8 x x >>>>> ABBOUD Script9 x x >>>>> ABBOUD Script10 x x >>>>> ABBOUD Script11 x x >>>>> ABBOUD Script12 x x >>>>> >>>>> And i'd like to create following relationships : >>>>> >>>>> >>>>> Lundi-[:Process]->(AALTO)-[:Execution]->(Script1)-[:Puis]->(Script2)-[:Puis]->(Script4) >>>>> Lundi-[:Process]->(ABBOTT)-[:Execution]->(Script6) >>>>> >>>>> Lundi-[:Process]->(ABBOUD)-[:Execution]->(Script8)-[:Puis]->(Script9)-[:Puis]->(Script10) >>>>> >>>>> And so on for Mardi and Samedi >>>>> >>>>> Thanks a lot for your help. >>>>> >>>>> Fred >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Neo4j" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> <cgp2.csv> >>>> >>>> >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Neo4j" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> >> >> > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
