Loading sensitive data in ,csv file from a local windows file system

General Newbie Questions
1

I am running Neo4j 3.5.2 on a windows machine and trying to load a .CSV file file from a local directory. I am still getting and error using this load statement:

LOAD CSV With HEADERS FROM "file:///C:Users/DoeJ/Documents/febdata/top_10_short.csv" AS row

The error message is:

Neo.ClientError.Statement.ExternalResourceFailed: Couldn't load the external resource at: file:/C:/Users/Doej/Documents/Neo4j/neo4jDatabases/database-9d04bc30-9376-4755-a1d5-7880d125ba43/installation-3.5.2/import/Users/Doej/Documents/febdata/top_10_short.csv

Anyway to do this without modifying the .conf file?

2

Hi there

Please save top_10_short.csv under your-neo4j-install-directory\import.

cd your-neo4j-install-directory
dir /ad /b
bin
certificates
conf
data
import
lib
logs
plugins
reports
run

as follows:

your-neo4j-install-directory/import/top_10_short.csv

Then rewrite it as follows.

LOAD CSV With HEADERS FROM "file:///top_10_short.csv" AS row

You should be able to load it without changing neo4j.conf.

Regards

3

If the file is in import folder, then there is only one '/' before the file name:

LOAD CSV With HEADERS FROM "file:/top_10_short.csv" AS row

1 Like
4

Sorry, I am mistaken for the file format. It has changed now, but another problem has arisen. Neo.ClientError.Statement.TypeError

5

I have solved this problem.