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]: > > 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] <javascript:>: >> >> 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 cdu8...@ <>gmail.com <http://gmail.com/>: >>> >>> 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] >>>> <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] <>. >>>> 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 neo4j+un...@ <>googlegroups.com <http://googlegroups.com/>. >>> 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] <javascript:>. >> 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] > <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.
