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 [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] <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.
