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

**URL:** <https://community.neo4j.com/t/preview-shows-nodes-as-expected-but-import-doesnt-create-nodes/59049>\
**Category:** Neo4j Graph Platform\
**Tags:** migrated\
**Created:** [November 23, 2022, 3:54am UTC](https://community.neo4j.com/t/preview-shows-nodes-as-expected-but-import-doesnt-create-nodes/59049 "2022-11-23T03:54:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![boris-abrega](https://avatars.discourse-cdn.com/v4/letter/b/a9a28c/32.png) [@boris-abrega](https://community.neo4j.com/u/boris-abrega)\
**Post date:** [November 23, 2022, 3:54am UTC](https://community.neo4j.com/t/preview-shows-nodes-as-expected-but-import-doesnt-create-nodes/59049/1 "2022-11-23T03:54:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![glilienfield](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/glilienfield/32/27534_2.png) [@glilienfield](https://community.neo4j.com/u/glilienfield)\
**Post date:** [November 23, 2022, 4:37am UTC](https://community.neo4j.com/t/preview-shows-nodes-as-expected-but-import-doesnt-create-nodes/59049/2 "2022-11-23T04:37:39Z")

</div>

What does your data model look like? Can you post a screenshot of it and the import settings for each node/relationship?

---

<div class="post-metadata">

**Author:** ![boris-abrega](https://avatars.discourse-cdn.com/v4/letter/b/a9a28c/32.png) [@boris-abrega](https://community.neo4j.com/u/boris-abrega)\
**Post date:** [November 23, 2022, 5:05am UTC](https://community.neo4j.com/t/preview-shows-nodes-as-expected-but-import-doesnt-create-nodes/59049/3 "2022-11-23T05:05:09Z")

</div>

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?

```auto
{
  "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](https://docs.google.com/spreadsheets/d/1xHzKDHoIabQRw7xtRCkFlj4YKCRRU52snaRZ6ryoVG8/edit?usp=sharing) exported to a CSV.