Error: Neo.ClientError.Statement.ExternalResourceFailed

Hello guys,
I have an issue to my Neo4j-Desktop-Version.
I am trying to load some data from csv-files with the query:
[ load csv with headers from 'file:///Adresse.csv' as row merge ....]
and I got the Error-Message:
[ Couldn't load the external resource at: file:/C:/.../Data/dbmss/dbms-6511ab10-5cf0-4410-9dfb-39f38e329978/import/Adresse.csv ]
The path to my csv-file is right and my csv-file is also in the import-order.
In the neo4j.conf -file I have the line dbms.directories.import=import activated.
My NEO4J_HOME variable is also on the path:
[ C:/.../Data/dbmss/dbms-6511ab10-5cf0-4410-9dfb-39f38e329978 ]
I dont know what to do next ... Maybe some folder-right checks ?!?

Did you select a non-default location for your application data?

The paths should be full paths and not relative (that is, is the ... in your Neo4j_HOME value?

Elaine

My exactly NEO4J_HOME-Path is absolute, so: C:\Users\dioni\AppData\Local\Neo4j\Relate\Data\dbmss\dbms-6511ab10-5cf0-4410-9dfb-39f38e329978 What exactly do you mean with application data? My .Neo4jDesktop folder?

Can you send the complete Cypher statement you are trying to execute?

Elaine

My statement is:
load csv with headers from 'file:///Adresse.csv' as row merge (adr:Adresse {aid:apoc.create.uuid()}) on create set adr.ort= row.ort, adr.plz = toInteger(row.plz), adr.hausnummer= row.hausnummer, adr.strasse = row.strasse;
The columns ort, plz, hausnummer, strasse exists in my csv-file Adresse.csv, but I dont get it, why I am getting this Error.

What do you see when you execute:

load csv with headers from 'file:///Adresse.csv' as row
return row.ort, row.plz, row.hausnummer, row.strasse limit 3

Can you provide a screen shot of what you see in either cypher-shell or Neo4j Browser. We need to first figure out why you cannot access the file. Is the file spelled exactly as you have it here?

Elaine

I got the same Error-Message. Yes the file-Name is correct and in my import-folder.

It seems like the problem is not with accessing the file, but what is in the file? What kind of data is in the file? Is it comma separated strings or numbers?

Elaine

1 Like

Ok, I got the problem. My csv-file was wrong formated. Very unlucky... Thank you.