Here what i want to do in my windows environment:
// Load Entity1
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:/c:Desktop/Entities/ENTITY1.csv" AS row
CREATE (:Entity1 {entityName: row.entity1});
Here the error I received from the online sandbox:
Neo.ClientError.Statement.ExternalResourceFailed: Couldn't load the external resource at: file:/var/lib/neo4j/import/c:Desktop/Entities/ENTITY1.csv
My question:
Where is my error? Is there somewhere i have to put my file if I want to use this command?
Hi Gabriel,
One thing you can do is to put the csv file online, since you don't have access to the neo4j Sandbox directory in this case. See here: https://neo4j.com/developer/guide-import-csv/.
Web-hosted files can be referenced directly with their URL, like https://host/path/data.csv . However, permissions must be set so that an external source can read the file. For more information about access related to online file imports, see this knowledge base article.
Examples
Example 1 - website
LOAD CSV FROM 'https://neo4j.com/docs/cypher-manual/3.5/csv/artists.csv'
Example 2 - Google
LOAD CSV WITH HEADERS FROM 'https://docs.google.com/spreadsheets/d/<yourFilePath>'
this is what I received:
Neo.DatabaseError.General.UnknownError: At FAMILY.csv - Google Drive @ position 1730 - 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: 'docs-fwds":'
But...
I know that I have no quotes in my data and nothing like: docs-fwds. It is just a csv file that i upload in my googledocs.
Looks like the issue with google drive is: the link above is not the direct link to your .csv file, but it's a redirect to another page that will open the csv file in your browser, and that's why the docs-fwds error comes from. At the moment I couldn't find a way to resolve this issue with google drive either.
There is a solution proposed on stack overflow cypher - Neo4j Database error General Unknown Error - Stack Overflow but it doesn't work for me when I tested it on my sandbox either.
The only thing that works is when I upload it into my own server (like the Example 1).
I try to load a dataset on neo4j desktop from link on githup but it showed me this error
Couldn't load the external resource at: https://github.com/neo4j-graph-analytics/book/raw/master/datatransport-nodes.csv