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 ./neo4j-admin import –database=hr.db –nodes:Staff hr.csv Neo4j version: 3.3.0 Importing the contents… Read more →

Explore:  


Properly escaping input data for neo4j-import

neo4j-import is intended to populate a new, empty database. It cannot be used to import into an existing database. 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… Read more →

Explore:  


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: load csv from “file:///test copy.csv” as row return row Error: java.net.URISyntaxException: Illegal character in path… Read more →

Explore:  


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 the CSV must have an :ID, which can be in… Read more →

Explore: