I am getting started with neo4j and set up an AuraDB instance. I built some simple CSV data to import, and it all maps in a sane way, and the import "works" but no nodes are created. At the same time, when I hit the Preview button, it shows the nodes correctly connected to one another. Any insight in what I am doing wrong?
Apologies if this is the wrong section of the community.
What does your data model look like? Can you post a screenshot of it and the import settings for each node/relationship?
I can only attach 1 file per reply, so I feel like screenshots may be a pain to parse here. Maybe the importer json definition will suffice?
{
"version": "0.7.0-beta.0",
"graph": {
"nodes": [
{
"id": "n1",
"position": {
"x": -597.921974147393,
"y": -489
},
"caption": "Entity"
},
{
"id": "n2",
"position": {
"x": -268.30007883985706,
"y": -489
},
"caption": "Relationship"
}
],
"relationships": [
{
"id": "n1",
"type": "PROVIDES_DATA",
"fromId": "n1",
"toId": "n2"
},
{
"id": "n3",
"type": "PROCESSES_DATA",
"fromId": "n1",
"toId": "n2"
}
]
},
"dataModel": {
"fileModel": {
"fileSchemas": {
"simplified neo4j import data - entities.csv": {
"expanded": true,
"fields": [
{
"name": "entity:ID(Entity)",
"type": "integer",
"sample": "1",
"include": true
},
{
"name": "name",
"type": "string",
"sample": "Google Cloud Platform",
"include": true
},
{
"name": "service",
"type": "string",
"sample": "Firebase Services",
"include": true
}
]
},
"simplified neo4j import data - PROCESSES_DATA.csv": {
"expanded": true,
"fields": [
{
"name": ":START_ID(Entity)",
"type": "integer",
"sample": "2",
"include": true
},
{
"name": ":END_ID(Relationship)",
"type": "boolean",
"sample": "1",
"include": true
}
]
},
"simplified neo4j import data - PROVIDES_DATA.csv": {
"expanded": true,
"fields": [
{
"name": ":START_ID(Entity)",
"type": "boolean",
"sample": "1",
"include": true
},
{
"name": ":END_ID(Relationship)",
"type": "boolean",
"sample": "1",
"include": true
}
]
},
"simplified neo4j import data - relationship.csv": {
"expanded": true,
"fields": [
{
"name": "relationshipId:ID(Relationship)",
"type": "boolean",
"sample": "1",
"include": true
},
{
"name": "name",
"type": "string",
"sample": "Google Cloud Platform - Accenture",
"include": true
},
{
"name": "type",
"type": "string",
"sample": "Third-Party Subprocessor",
"include": true
},
{
"name": "processing_activity",
"type": "string",
"sample": "Technical Support",
"include": true
},
{
"name": "processing_country",
"type": "string",
"sample": "Philippines",
"include": true
},
{
"name": "processing_start_date",
"type": "string",
"sample": "4/20/20",
"include": true
},
{
"name": "processing_end_date",
"type": "string",
"sample": "11/22/22",
"include": true
},
{
"name": "notes",
"type": "string",
"sample": "Applicable Cloud Region(s): All",
"include": true
}
]
}
}
},
"graphModel": {
"nodeSchemas": {
"n1": {
"label": "Entity",
"additionLabels": [],
"labelProperties": [],
"properties": [
{
"property": "name",
"type": "string",
"identifier": "HVaagUC27Um-kL87t2vLU"
},
{
"property": "service",
"type": "string",
"identifier": "ClFM9ZElt0ZB3Qf7h2sBa"
},
{
"property": "id",
"type": "float",
"identifier": "TyvILjRlJyjftHbeO1_-3"
}
],
"key": {
"properties": [
"TyvILjRlJyjftHbeO1_-3"
]
}
},
"n2": {
"label": "Relationship",
"additionLabels": [],
"labelProperties": [],
"properties": [
{
"property": "relationship_type",
"type": "string",
"identifier": "vhl_bpYXtiMahoZ8paW2q"
},
{
"property": "processing_activity",
"type": "string",
"identifier": "FqWEixZ-ycnhpCsjYYthB"
},
{
"property": "processing_country",
"type": "string",
"identifier": "0eSy_svpAnaeN8r9LE7EV"
},
{
"property": "processing_start_date",
"type": "datetime",
"identifier": "jMuiuu5t_jefpDiF83Fca"
},
{
"property": "processing_end_date",
"type": "datetime",
"identifier": "JIG-BJFSzMZvNJ3nicVpi"
},
{
"property": "notes",
"type": "string",
"identifier": "GfBMkwAG1dO4nEi002sU3"
},
{
"property": "id",
"type": "float",
"identifier": "mZPpiVt_KTi599acMBVYd"
},
{
"property": "name",
"type": "string",
"identifier": "-QPJ7BhI85vJXkR2wsIIA"
}
],
"key": {
"properties": [
"mZPpiVt_KTi599acMBVYd"
]
}
}
},
"relationshipSchemas": {
"n1": {
"type": "PROVIDES_DATA",
"sourceNodeSchema": "n1",
"targetNodeSchema": "n2",
"properties": []
},
"n3": {
"type": "PROCESSES_DATA",
"sourceNodeSchema": "n1",
"targetNodeSchema": "n2",
"properties": []
}
}
},
"mappingModel": {
"nodeMappings": {
"n1": {
"nodeSchema": "n1",
"fileSchema": "simplified neo4j import data - entities.csv",
"mappings": [
{
"field": "name"
},
{
"field": "service"
},
{
"field": "entity:ID(Entity)"
}
]
},
"n2": {
"nodeSchema": "n2",
"fileSchema": "simplified neo4j import data - relationship.csv",
"mappings": [
{
"field": "type"
},
{
"field": "processing_activity"
},
{
"field": "processing_country"
},
{
"field": "processing_start_date"
},
{
"field": "processing_end_date"
},
{
"field": "notes"
},
{
"field": "relationshipId:ID(Relationship)"
},
{
"field": "name"
}
]
}
},
"relationshipMappings": {
"n1": {
"relationshipSchema": "n1",
"mappings": [],
"sourceMappings": [
{
"field": ":START_ID(Entity)"
}
],
"targetMappings": [
{
"field": ":END_ID(Relationship)"
}
],
"fileSchema": "simplified neo4j import data - PROVIDES_DATA.csv"
},
"n3": {
"relationshipSchema": "n3",
"mappings": [],
"sourceMappings": [
{
"field": ":START_ID(Entity)"
}
],
"targetMappings": [
{
"field": ":END_ID(Relationship)"
}
],
"fileSchema": "simplified neo4j import data - PROCESSES_DATA.csv"
}
}
},
"configurations": {
"idsToIgnore": []
}
}
}
And then the source files are each of the tabs at https://docs.google.com/spreadsheets/d/1xHzKDHoIabQRw7xtRCkFlj4YKCRRU52snaRZ6ryoVG8/edit?usp=sharing exported to a CSV.