Neo4j csv cypher import

Question

Im trying to import csv files from disk with cypher commands as shown in the tutorial, but Im getting "Couldn't load the external resourse at: externalResourceFailure. Is there any "roadmap" for importing csv in windows from files? Thank you in advance!

Solution 1

it will work if path like this "file:///C:/myfile.csv"

Solution 2

take alook at SyntaxException with Neo4j LOAD command

in the question, step 3, please check if you path to the file is correct on your operating system:

the syntax for accessing a local file on windows is simply "file:c:/nosql/test/unclaimed.csv" and not file:// as might be inferred from examples on ...

Solution 3

You have to put the files into the import directory in neo4j.

Solution 4

The Windows and Linux file systems require different file URI schemes for streaming over HTTP. Neo4j's LOAD CSV Cypher clause makes an HTTP web request to the URI of a file and not the file system path.

For more information on file URI schemes on Windows please take a look at: http://en.wikipedia.org/wiki/File_URI_scheme#Windows_2

Solution 5

You can also create a folder import into your neo4j installation folder and run a cipher like this

LOAD CSV WITH HEADERS FROM "file:///yourcsvfile.csv" AS row

View more solutions

Comments

[Nektarios Kyriakou]

Thank you ulkas! Seems that it doesnt work - strange thing - but ill try again. The 3 slash syntax, as shown above work fine on the other side....