Hello there, as title suggests, I'm trying to import a file into Neo4j for my thesis project. Skipping all tries I made, I came up this morning with this goal: importing a really basic csv file to isolate where errors live.
Here my config: Neo4j community edition 3.0.7 running on Docker A Pages file with 3 parameters: id, age, sex and just one row like above: pId;age;sex 70069886;84;M (https://www.dropbox.com/s/1ih0qu66v0030f8/provaFoglio.csv?dl=0) then file -> export as -> csv Double checked the csv file both with Atom and csvLint.io A second csv file with double quotes an commas like this: "pId","age","sex" "70069886","84","M" (https://www.dropbox.com/s/d31v82221sjxtgg/5838276a3730300004000037.csv?dl=0) And here my Cypher queries: 1) this statement creates 371 labels and nodes LOAD CSV WITH HEADERS FROM "https://www.dropbox.com/s/d31v82221sjxtgg/5838276a3730300004000037.csv?dl=0"; AS line CREATE (:Patient{ pID: line.pId, age: line.age, sex: line.sex }) 2) LOAD CSV WITH HEADERS FROM "https://www.dropbox.com/s/1ih0qu66v0030f8/provaFoglio.csv?dl=0"; AS line FIELDTERMINATOR ';' CREATE (:Patient{ pID: line.pId, age: line.age, sex: line.sex }) The second one gives me : At https://www.dropbox.com/s/1ih0qu66v0030f8/provaFoglio.csv?dl=0:198 - there's a field starting with a quote and whereas it ends that quote there seems to be characters in that field after that ending quote. That isn't supported. This is what I read: ' id="' Do you have any suggestions? Many thanks Alessandro -- 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.
