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
2
votes
2 answers

Neo4j function "load csv with headers" does not load properties

I try to load the following nodes into Neo4j using load CSV with headers command: id label name 0 Person Dave 1 Person Boris 2 Person Rita 3 Person Daniel 4 Person Papa 5 Person Mama I save the Excel-Sheet as: CSV UTF-8 (Comma…
Grapheneer
  • 897
  • 8
  • 25
2
votes
0 answers

LOAD CSV from url

I am using the LOAD CSV statement to access a csv file from a public url. It works fine whenever I am not behind the proxy of my company. As soon as the proxy is active, the file can no longer be accessed with the statement. The error message is…
idleherb
  • 1,072
  • 11
  • 23
2
votes
1 answer

How to handle transaction rollback in Neo4j while Loading large data from csv using periodic commit

I am trying to import a large amount of data from csv to neo4j using neo4j-rest java api. To avoid out of memory exceptions , I am using periodic commit , so a sample java code would be : // just to let you know what classes I am using import…
Lina
  • 1,217
  • 1
  • 15
  • 28
2
votes
2 answers

In Cypher, How to modify valid URL protocols for LOAD CSV command

This question has two parts: By default, what URL protocols are considered valid for specifying resources to Cypher's LOAD CSV command? So far, I've successfully loaded CSV files into Neo4j using http and file protocols. A comment on this…
smartcaveman
  • 41,281
  • 29
  • 127
  • 212
2
votes
2 answers

Load CSV Fails in Cypher + Neo4j "LoadExternalResourceException: Couldn't load the external resource at:"

I have a fresh install of Neo4j 2.1.4 open source on a corporate cloud server running Ubuntu 14.04. I am importing a CSV file into the database. The path to my file is '/home/username/data-neo4j/node.csv' Below is my command, which I run from the…
sheldonkreger
  • 858
  • 1
  • 9
  • 25
1
vote
1 answer

In Neo4j Cypher, How to iterate using LOAD CSV, UNWIND/FOREACH and WITH clauses?

In Neo4j, using Cypher, I want to run the below query for numbers 1 through 14 (i.e., quantity1 to quantity14): LOAD CSV WITH HEADERS FROM '' AS row WITH row WHERE row.quantity1 IS NOT NULL MATCH (m:main {main_id: row.main}) MERGE…
kumarais
  • 11
  • 1
1
vote
1 answer

redisgraph-bulk-loader returns with IndexError

I am trying to use the redisgraph-bulk-loader to load the dataset into the RedisGraph instance running in a docker container. However, it returns with IndexError: list index out of range which I do not understand. I have read the documentation and…
Raj
  • 85
  • 8
1
vote
1 answer

redisgraph-bulk-loader issues with huge data in csv file

Below are the few issues I am getting when I am trying to upload a file with around one million records. Help me on resolving the issues. When I am try to find the solution in blogs, all are suggesting to modify some logic. But I am using…
Jagadeesh Urlana
  • 87
  • 9
1
vote
2 answers

Efficient way to import multiple csv's in neo4j

I am working on creating a graph database in neo4j for a CALL dataset. The dataset is stored in csv file with following columns: Source, Target, Timestamp, Duration. Here Source and Target are Person id's (numeric), Timestamp is datetime and…
kinger
  • 33
  • 7
1
vote
1 answer

converting a value to datetime in load csv in cypher

I'm trying to load csv file into neo4j using this query: :auto USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM 'file:///test.csv' AS row MERGE (news:newsID {newsID: row.id}) ON CREATE SET news.title = row.title, news.creation_date =…
Ariyan
  • 14,760
  • 31
  • 112
  • 175
1
vote
0 answers

Azure Neo4j v4 LOAD CSV with URL not recognizing file

I'm using Neo4j v 4.0.3 on Azure. Python code is used to load the database. Standard cypher create queries work as expected: Create (n:xxx{name:'xxx'}) However, this does not work: LOAD CSV With HEADERS FROM…
David A Stumpf
  • 753
  • 5
  • 13
1
vote
1 answer

Error when importing csv using import tool

I'm trying to load a graph with two nodes (Autor,Paper) and a relation with the import tool, right now I have this two files, which, as far as I understand, they must be: authors.csv: :Author(Autor) :Adscription(Autor) :PMID(Paper) Author1 …
José Angel Neria Pérez
  • 111
  • 1
  • 2
  • 7
1
vote
1 answer

error in unwind command "Neo.ClientError.Statement.SyntaxError: Invalid input 'p': expected whitespace"

While loading data from csv file to neo4j, I am using below cypher query. Load csv from "file:///resume" AS row FIELDTERMINATOR '\u0001' WITH row, split(row[4], "|") AS pskills , split(row[5], "|") As frameworks, split(row[6],…
jyoti
  • 31
  • 1
  • 7
1
vote
1 answer

Neo4j Database error General Unknown Error

Load csv with headers from "https://drive.google.com/open?id=1pyWY81bKzcCF7T-i_-MyhY2kJ4Z8NYP8" as row with row return row this is my code I am trying to access the csv file with 1 million records from my drive using load csv It is giving me…
Aarti Shelukar
  • 60
  • 1
  • 6
1
vote
1 answer

Neo4j Cypher queries EXPLAINed identically but warnings are generated just for one

I have csv file containing a one-to-many relation where each element of type A is composed by one or more elements of type B but each element of B refers to only one element of type A. An example: A | B ------------- a1 | b1 a1 | …
roschach
  • 8,390
  • 14
  • 74
  • 124
1
2
3 4 5 6