Glad it worked out, looking forward to your thesis results and any intermediary publications.
Good luck with the work. Best to join neo4j.com/slack and ask there if you have further questions. Michael On Sun, Nov 27, 2016 at 11:15 AM, <[email protected]> wrote: > 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]> 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/5838276a373030000 >>> 4000037.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/d31 >>> v82221sjxtgg/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/1ih >>> 0qu66v0030f8/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. > -- 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.
