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.