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] <javascript:>: > > 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] <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.
