Stack Overflow
Stack Overflow

Questions tagged [load-csv]

Tag for Neo4j questions related to the LOAD CSV command.

LOAD CSV is a file import / data ingestion clause for 's , which imports data from files.

Example of use

LOAD CSV FROM 'http://neo4j.com/docs/2.3.2/csv/artists.csv' AS line
CREATE (:Artist { name: line[1], year: toInt(line[2])})

References

90 questions
10
votes
5 answers

Neo4j Cypher - creating nodes and setting labels with LOAD CSV

I’m trying to use LOAD CSV to create nodes with the labels being set to values from the CSV. Is that possible? I’m trying something like: LOAD CSV WITH HEADERS FROM 'file:///testfile.csv' AS line CREATE (x:line.label) ...but I get an invalid syntax…
bicpence
  • 167
  • 3
  • 9
5
votes
2 answers

Neo.ClientError.Statement.ExternalResourceFailed

load csv with headers from 'file:///C:/Users/user/Desktop/Neo4J' as row Create (:State_Code {state_cd:row.st_cd}) I have tried this code and it is throwing an error as: Neo.ClientError.Statement.ExternalResourceFailed: Couldn't load the external…
Vaidehi Shejwalkar
  • 75
  • 2
  • 6
5
votes
1 answer

Remove EAGER from Cypher LOAD CSV with only MATCH & CREATE relationship

neo4j version 2.3.1 Indexes exist on Stoptime.stop_sequence and Stoptime.key. Stoptime.stop_sequence is numeric. Graph: (Stoptime)-[:PART_OF]->(Trip) Statement: //USING PERIODIC COMMIT 1000 PROFILE load csv with headers from "file:///path/to/csv" as…
changingrainbows
  • 2,551
  • 1
  • 28
  • 35
4
votes
1 answer

Liquibase CSV loadData fails with quoted string containing a comma

I am trying to load CSV file into SQLserver table using Liquibase change log set. When saved XLSX file as CSV file, column containing comma saved in double quotes (please see 3rd value below), this is fine as per standards but liquibase is ignoring…
SKARVA Bodavula
  • 903
  • 11
  • 17
4
votes
4 answers

neo4j specify data-type during import from csv

is there a way to tell the neo4j the type of the value when importing? for example, does the neo4j knows if "2015-0104T10:33:44" is a date or string? thanks!
Lior Goldemberg
  • 866
  • 13
  • 26
4
votes
2 answers

neo4j: Cypher LOAD CSV with uuid

I am starting to work with LOAD CSV of Cypher for Neo4J to import larger csv-files into my DB. I would like to add to each imported node a unique ID (uuid) as a property. My try was: LOAD CSV FROM "file:..." AS csvLine CREATE (c:Customer { uuid:…
Balael
  • 401
  • 5
  • 18
3
votes
1 answer

cypher statement returns (no changes, no rows)

I've watched Nicole White's awesome youtube “Using LOAD CSV in the Real World” and decided to re-create the neo4j data using the same method. I’ve cloned her git repo on this subject and have been working this example on the community version of…
Timothy Lombard
  • 917
  • 1
  • 11
  • 31
3
votes
5 answers

Neo4j LOAD CSV with Custom IDs

I'm using Neo4j 2.2.3 and have tried to import a CSV file with Cypher's LOAD CSV that looks like this: PRODUCT_ID,PRODUCT_DESC,PRODUCT_TYPE 99,"A","X" 999,"B","X" 9999,"C","Y" 99999,"D","Y" However, I'm having difficulty with the custom ID. Neo4j…
Ian
  • 1,294
  • 3
  • 17
  • 39
2
votes
2 answers

Neo4j LOAD CSV..when CSV columns contains a list of properties

This is regarding neo4j csv import using LOAD csv. Suppose my csv file format is as following. Id, OID, name, address, Parents , Children 1, mid1, ratta, hello@aa, ["mid250","mid251","mid253"], ["mid60","mid65"] 2, mid2, butta, ado@bb,…
Nirmana
  • 33
  • 3
2
votes
1 answer

Loading CSV with Cypher with certain column names as properties

I have a CSV like this with the first row being header (H1, H2, H3,...) - H1,H2,H3,H4,H5,... a1,a2,a3,a4,a5,... b1,b2,b3,b4,b5,... I already have a neo4j database in which I use the first column (H1) to merge the nodes and use the rows of H2 and H3…
user2167741
  • 277
  • 1
  • 10
2
votes
1 answer

loading csv file from S3 in neo4j graphdb

I am seeking some suggestion about loading csv files from s3 bucket to neo4j graphdb. In S3 bucket the files are in csv.gz format. I need to import them into my neo4j graph db which is in ec2 instance. 1. Is there any direct way to load csv.gz…
Kalyan
  • 1,880
  • 11
  • 35
  • 62
2
votes
1 answer

How to update existing specific node in graphdb by loading updated CSV file in neo4J apoc

I am facing problem updating node by loading recently updated csv file in. neo4j. since it is a large file I think apoc procedure is need to be used. I have updated existing node by loading external updated file without apoc. but problem is I…
Kalyan
  • 1,880
  • 11
  • 35
  • 62
2
votes
1 answer

Neo4J ClientError.Statement.SyntaxError

I am getting Neo.ClientError.Statement.SyntaxError while loading data from CSV file. Neo.ClientError.Statement.SyntaxError: Invalid input 'h': expected 'i/I' (line 5, column 3 (offset: 189)) "Merge (Zip_Code:Zip_Code {code:…
Vaidehi Shejwalkar
  • 75
  • 2
  • 6
2
votes
1 answer

Load a large csv file into neo4j

I want to load a csv that contains relationships between Wikipedia categories rels.csv (4 million of relations between categories). I tried to modify the setting file by changing the following parameter values: dbms.memory.heap.initial_size=8G…
Mabrouk
  • 83
  • 4
2
votes
2 answers

Neo4j LOAD CSV Error: unknown protocol: c

LOAD CSV FROM "file:/C:/Users/abcd/Desktop/Neo4J/fileName.csv" AS row WITH row RETURN row This is my code for importing this csv to my database but it is giving me error as Neo.ClientError.Statement.ExternalResourceFailed: Invalid URL …
Aarti Shelukar
  • 60
  • 1
  • 6
1
2 3 4 5 6