cancel
Showing results for 
Search instead for 
Did you mean: 

Preview shows nodes as expected, but import doesn't create nodes

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.

2 REPLIES 2

glilienfield
Ninja
Ninja

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.