Dear Michael, I don't know how to express my gratitude. I'm going to work on a thesis discussing surgery outcomes on elderly patients and I proposed to explore a new approach with Neo4j. The team asked me a demo and I was at a point to quit because of this Dropbox behavior....Thank you! (importing and querying was just a breeze) Kind regards Alessandro
Il giorno venerdì 25 novembre 2016 15:15:00 UTC+1, Michael Hunger ha scritto: > > 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] <javascript:>> 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] <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.
