Neo.ClientError.Statement.ExternalResourceFailed

Question

load csv with headers from 'file:///C:/Users/user/Desktop/Neo4J'
as row 
Create (:State_Code {state_cd:row.st_cd})

I have tried this code and it is throwing an error as:

Neo.ClientError.Statement.ExternalResourceFailed: Couldn't load the external resource at: file:/C:/Users/ssarse/Desktop/Neo4J

Can anyone help me out with this?

Rajendra Kadam · Accepted Answer · 2019-06-13T06:56:09.960

7

By default, Neo4j doesn't allow loading data from file URLs. And if allowed it reads files from the import directory only.

If you want to load files from other directories, you have to allow that in neo4j.conf

You can easily configure this:

Find the neo4j.conf file for your Neo4j installation. Read here about file locations.
Comment this line(By adding # in the start):
```
dbms.directories.import=import
```
Uncomment this line to allow CSV import from file URL:
```
#dbms.security.allow_csv_import_from_file_urls=true
```
Restart Neo4j

edited Jun 13 '19 at 06:56

answered Jun 13 '19 at 05:19

Rajendra Kadam

1

Did that still the file is not accessable – Vaidehi Shejwalkar Jun 13 '19 at 05:57

score 0 · Answer 2 · edited Apr 30 '22 at 09:36

0

Make sure the file is clean and that you don't use the wrong extention; because in my experience not doing that can cause it to not be imported.

edited Apr 30 '22 at 09:36

Yunnosch

answered Feb 16 '22 at 23:53

2

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Feb 17 '22 at 19:18

2 Answers2