Since I use Neo4j 3.0.1, this cypher query:
USING PERIODIC COMMIT 500
LOAD CSV WITH HEADERS
FROM >"file:///home/user/Documents/links.csv" AS csvLine
...
returns
Couldn't load the external resource at: file:/home/user/Documents/neo4j-community-3.0.1/import/home/user/Documents/links.csv
Neo4j is located on my machine (Ubuntu 14.04), in the "Documents" folder, as the "links.csv" file.
(with a 2.xx version of neo4j this exact query was working perfectly)
I don't undersand why neo4j3.0 try to rebuild the csv file path in the "import" folder...
Uploading the file on ftp to query neo4j through http protocol works, so it's not about access permissions of the "import "folder". My "links.csv" file permission is 664.
Any idea ?
This is a security that has been integrated in neo4j 3.0 in order to prevent scripts to load sources from an unwanted directory (like /etc/password
for example.
You can add the following setting in conf/neo4j.conf
in order to bypass this :
dbms.security.allow_csv_import_from_file_urls=true
Or just put your csv files in the import directory.
You should comment out this line from the neo4j.conf line:
dbms.directories.import=import
or set the files at the import
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With