I have a problem while importing .csv file to Neo4j. My neo4j is on docker, when trying to import the csv using express, I get an error:
Neo4jError: Couldn't load the external resource at: file:/organizations.csv
I followed this: Neo4j LOAD CSV Error: unknown protocol: c, so I changed my neo4j.conf file, but it didn't resolve my problem, I still get the error. The path is 100% fine, because my .js file is where the .csv file is.
LOAD CSV FROM 'file:///organizacje.csv' AS line
MERGE (o: Organization {organizationNr: toInteger(line[0]),name: line[1]})
RETURN o
What is wrong here?
By default, importing csv files into neo4j requires the files to be located on this configuration setting found in the local disk (in your DOCKER)
dbms.directories.import=<NEO4J_HOME>/import/
If you cannot put the file in that local disk, I recommend you to put it in amazon web service or google cloud or microsoft azure. Then use http to access your csv. See example in link below.
https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/#load-csv-import-data-from-a-remote-csv-file
Example:
LOAD CSV FROM 'http://<aws S3 dir>/organizacje.csv' AS line
MERGE (o: Organization {organizationNr: toInteger(line[0]),name: line[1]})
RETURN o