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

[sherri_matis-mi]

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?

[changhwan_lee]

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

[ameyasoft]

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

[jackh8071]

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

[jackh8071]

I have solved this problem.