Load CSV file from Dropbox for Neo4j

Question

I saved my CSV file on dropbox and I want to Load them on Neo4j.

The link for the shared Users Node csv file: https://www.dropbox.com/s/6kibjeea5e4cks1/users.csv?dl=0

This is the cypher

USING PERIODIC COMMIT 100
        
LOAD CSV WITH HEADERS FROM "https://www.dropbox.com/s/6kibjeea5e4cks1/users.csv?dl=0" AS line
        
CREATE(u:User{userId: toInt(line.Id), username: line.UserName, fullname: line.FullName})

The Neo4j version I am using is Neo4j Enterprise version 3.0.9.

The result showed that it successfully created the Users Node but it created over 300 Nodes with no user name and full name. Even though there are 9 nodes with a user name and full name on the CSV file. What am I missing?

I tried to change the URL from the shared link to the download link but the error Couldn't load the external resource showed up.

Answer 1

If you switch from dropbox to gDrive the issue seems to not be an issue. I dropped your csv in my drive account and it seems to work.

USING PERIODIC COMMIT 100
LOAD CSV WITH HEADERS FROM "https://docs.google.com/spreadsheets/d/e/2PACX-1vRANVgt-GZf0Un8dyrf7YPITDgAIBzTwjTcqOu_G7mBhGKOEZskf6Mt2oTdInyQ-wLPE0aOzsW6lVD_/pub?gid=5399540&single=true&output=csv" AS line
CREATE(u:User{userId: toInt(line.Id), username: line.UserName, fullname: line.FullName})

File > Publish to the web

1. Pick the tab you want
2. Select csv as the published format
3. Click Publish

And you will get back a public url to the csv

Answer 2

The link you are using is not the file by itself, but the dropbox page to see the file :

$ curl -i --raw https://www.dropbox.com/s/6kibjeea5e4cks1/users.csv?dl=0
HTTP/2 302
server: nginx
date: Mon, 24 Jul 2017 14:46:44 GMT
content-type: text/html; charset=utf-8
content-length: 0
location: https://dl.dropboxusercontent.com/content_link/Z2KG0dzjBlHuMnIXyApZvBZFICVBXnLErAeLwlrkH46xnjg5yfd59ZfboKUpCNdo/file

You should try with the file direct link :

$ curl -i --raw https://dl.dropboxusercontent.com/content_link/Z2KG0dzjBlHuMnIXyApZvBZFICVBXnLErAeLwlrkH46xnjg5yfd59ZfboKUpCNdo/file
HTTP/2 200
server: nginx
date: Mon, 24 Jul 2017 14:47:46 GMT
content-type: text/csv; charset=utf-8
content-length: 231