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] <javascript:>: >> >> 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] >> <http://gmail.com/> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout >> <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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.
