I think it's a problem with dropbox returning something which is not an csv file
There is at least one redirect and also some cookie thingy going on. I had good experience with public dropbox files. Michael On Fri, Nov 25, 2016 at 1:16 PM, <[email protected]> wrote: > 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. > -- 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.
