Download CSV file from Dropbox for Neo4j

Question

Download CSV file from Dropbox for Neo4j

I saved the csv file to Dropbox and I want to upload them to Neo4j.

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

This is 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 version of Neo4j that I am using is Neo4j Enterprise version 3.0.9.

The result showed that he successfully created Node users, but created more than 300 nodes with no username and full name, although these are 9 nodes with a username and full name in the CSV file. What am I missing?

I tried to change the URL from the shared link to the download link , but the error Failed to load an external resource .

+4

neo4j dropbox cypher

ash Jul 24 '17 at 14:11

4

- , Dropbox :

$ 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

:

$ 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

+3

Gabriel Bleu 24 . '17 14:55

, https://www.dropbox.com/s/6kibjeea5e4cks1/users.csv?dl=0 HTML- CSV .

Cypher:

LOAD CSV WITH HEADERS FROM "https://www.dropbox.com/s/6kibjeea5e4cks1/users.csv?dl=0" AS line
RETURN line LIMIT 3

:

╒══════════════════════════════════════════════════════════════════════╕
│"line"                                                                │
╞══════════════════════════════════════════════════════════════════════╡
│{"<!DOCTYPE html><html lang=\"en\" xmlns:fb=\"http://ogp.me/ns/fb#\" x│
│ml:lang=\"en\" class=\"maestro\" xmlns=\"http://www.w3.org/1999/xhtml\│
│">":"<head><link href=\"https://cfl.dropboxstatic.com/static/css/accou│
│nt/emails-vflCV9b0W.css\" type=\"text/css\" crossorigin=\"anonymous\" │
│rel=\"stylesheet\" />"}                                               │
├──────────────────────────────────────────────────────────────────────┤
│{"<!DOCTYPE html><html lang=\"en\" xmlns:fb=\"http://ogp.me/ns/fb#\" x│
│ml:lang=\"en\" class=\"maestro\" xmlns=\"http://www.w3.org/1999/xhtml\│
│">":"<link href=\"https://cfl.dropboxstatic.com/static/css/deprecated/│
│components/multiaccount_login_modal-vflNhUM8J.css\" type=\"text/css\" │
│crossorigin=\"anonymous\" rel=\"stylesheet\" />"}                     │
├──────────────────────────────────────────────────────────────────────┤
│{"<!DOCTYPE html><html lang=\"en\" xmlns:fb=\"http://ogp.me/ns/fb#\" x│
│ml:lang=\"en\" class=\"maestro\" xmlns=\"http://www.w3.org/1999/xhtml\│
│">":"<link href=\"https://cfl.dropboxstatic.com/static/css/font_paper_│
│atlas_grotesk-vflEbKJso.css\" type=\"text/css\" crossorigin=\"anonymou│
│s\" rel=\"stylesheet\" />"}                                           │
└──────────────────────────────────────────────────────────────────────┘

, DropBox ( ) .

+3

Bruno Peres 24 . '17 14:58

Want to download a CSV file from Dropbox for Neo4j. You can also do this using Google Drive, and you can also create direct links to download many files with a simple trick . Check this out: How to create or generate a direct link to Google Drive using the link generator .

0

Harish kardam Jun 23 '19 at 13:07

source share

Dave Bennett · Accepted Answer · 2017-07-24T14:53:55+0000

dropbox gDrive, , , . csv , , .

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})

>

csv
""

url csv

Download CSV file from Dropbox for Neo4j

More articles: