Articles tagged as import-export
Importing Data to Neo4j in the Cloud
Loading data in a Neo4j instance that is in the cloud is very similar to running Neo4j using any other method. However, there are a few small things to look…
Executing Neo4j ETL from an RDBMS database running on Docker
Following provides some examples of importing a test csv data into Neo4j, using the Neo4j ETL tool’s command line interface with the source RDBMS database running on docker. Examples herein…
Export a (sub)graph to Cypher script and import it again
Oftentimes you want to export a full (or partial) database to a file and import it again without copying the actual database files. If you want to do the latter,…
How do I specify the field and array delimiter to neo4j-import as a ASCII character
neo4j-import allows one to initially load a graph.db via CSV files. There may be times when using a ',' as a field or array delimiter is not appropriate as your…
How do I use Cypher to connect to a RDBMS using JDBC
With the inclusion of java stored procedures in Neo4j 3.x, one can run Cypher to connect to a RDBMS using JDBC. To do so one needs to download and install…
How do I use LOAD CSV to update/set properties of existing nodes
One can use LOAD CSV to perform a bulk update to existing nodes, and create new nodes, as follows. If we have a .csv called Movies.csv and its content is: and…
How do I use LOAD CSV with data including quotes
When using LOAD CSV to read a file which includes data with double quote characters ("), the quotes need to be escaped as 2 double quote characters For example if…
Importing CSV Files: Neo4j Aura, Desktop and Sandbox
Loading various kinds of files into Neo4j requires different locations depending on the tool you are using. Import methods we will cover: Remote: Neo4j Aura and Neo4j Sandbox Local: Neo4j…
Load CSV data in Neo4j from CSV files on Amazon S3 Bucket
Neo4j provides LOAD CSV cypher command to load data from CSV files into Neo4j or access CSV files via HTTPS, HTTP and FTP. But how do you load data from…
Parsing of quotes for LOAD CSV and/or Import
When using LOAD CSV or neo4j-admin import if your data contains quotes they must be properly escaped to be imported otherwise one might encounter the error neo4j-admin import error LOAD…
Properly escaping input data for neo4j-import
When importing data using neo4j-import, make sure to review the required CSV file structure and considerations before moving on. http://neo4j.com/docs/stable/import-tool.html Escaping commas within the CSV: Consider the following string: Use…
How to import a file with LOAD CSV that has a space in file name?
When you try to import data from a file using LOAD CSV where the filename containing spaces for example you get the following error: Statement: Error: To allow for a…
Using apoc.load.jsonParams to load data from Zendesk into Neo4j to learn about article subscribers
The following document describes how to utilize the Zendesk API to load data from Zendesk into Neo4j, specifically data about users who have chosen to subscribe/follow Knowledge Base section(s). This…
Using APOC to parse JSON results from Trello API
Prior to Neo4j 3.0, if you wanted to parse the JSON results from a call to a Web API, it would require you use one of the database drivers to…
Using the ACTUAL data type with neo4j-import
When importing data using neo4j-admin import, make sure to review the required CSV file structure and considerations before moving on. https://neo4j.com/docs/operations-manual/current/tools/import/ ACTUAL vs. String (default) or Integer: Each node in…