CODEWITHSUNDEEP
csvneo4jload
KGarg
KGarg

Reputation: 23

Import csv file in neo4j from local disk

I am facing difficulty in importing a csv file in neo4j. I am working on Windows I have been trying this:

      LOAD CSV WITH HEADERS FROM "file:c:/path/to/data.csv" as submissions create (a1:Submission {preview: submissions.preview, secure_media_embed: submissions.secure_media_embed, media: submissions.media, secure_media: submissions.secure_media, media_embed: submissions.media_embed})

Getting error: 

    URI is not hierarchical

Any suggestion on what I am doing wrong here, I have been following blogs and all suggests this

Upvotes: 0

Views: 2448

Answers (1)

Jobin Mathew
Jobin Mathew

Reputation: 483

Edit the neo4j conf file (/etc/neo4j/neo4j.conf)

change the below line

dbms.directories.import=import

to

dbms.directories.import=/home/suyati/Downloads/

for loading a file from downloads.

In neo4j browser:

load csv with headers from "file:///1.csv" as row

(Your file should be there like /home/suyati/Downloads/1.csv)

Its will works fine.

Upvotes: 3

Related Questions