H kamal thanks, that works too. i guess the original problem was due to the "call" statement being there .. removing that seems to work although i thought i tested that already .. it also needed small rewrite to SET the uuid property to avoid duplicate record conflicts
so for apoc functions no call stetement in front i guess thanks 2017-11-29 20:30 GMT+01:00 Kamal Murthy <ameyas...@gmail.com>: > Hi Koen, > > It is missing WITH line statement. Try this: > > USING PERIODIC COMMIT > LOAD CSV WITH HEADERS > FROM "file:///test.csv" AS line FIELDTERMINATOR ';' > *WITH line, * *apoc.create.uuid() as uid* > MERGE (server:Server { name: line.'Machine Name`, uuid: *uid* }) > > Or, > > USING PERIODIC COMMIT > LOAD CSV WITH HEADERS > FROM "file:///test.csv" AS line FIELDTERMINATOR ';' > *WITH line* > MERGE (server:Server { name: line.'Machine Name`, uuid: > *apoc.create.uuid()* }) > > I prefer the first one. > > -Kamal > > On Wednesday, November 29, 2017 at 10:45:42 AM UTC-8, koen wrote: >> >> Hi, when using the following simple cypher query with the apoc function >> apoc.create.uuid() >> >> USING PERIODIC COMMIT >> LOAD CSV WITH HEADERS >> FROM "file:///test.csv" AS line FIELDTERMINATOR ';' >> MERGE (server:Server { name: line.`Machine Name`, uuid: call >> apoc.create.uuid() }) >> >> I keep getting an error message like >> >> Invalid input 'p': expected 'n/N' (line 4, column 63 (offset: 158)) >> "MERGE (server:Server { name: line.`Machine Name`, uuid: call >> apoc.create.uuid() })" >> >> >> I am running latest version of desktop, all procedures and functions are >> active and show in the browser (when running the list procedutes / >> functions command) and without the -- uuid: call apoc.create.uuid() -- >> part the query works fine >> >> Do i have to do / configure something so that i can use apoc functions in >> queries ? Or is the query syntax not ok ? >> >> Thanks Koen >> >> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "Neo4j" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/neo4j/3OedUQ8P2i0/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Groeten / Best Regards, Koen -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.