# Relationships not appearing in Aura after csv import (Neo4j Data Importer) while following the "Building Knowledge Graphs A Practitioner's Guide" Chapter 4 instructions

**URL:** <https://community.neo4j.com/t/relationships-not-appearing-in-aura-after-csv-import-neo4j-data-importer-while-following-the-building-knowledge-graphs-a-practitioners-guide-chapter-4-instructions/65349>\
**Category:** Cypher\
**Tags:** browser, cypher, import\
**Created:** [December 14, 2023, 12:01am UTC](https://community.neo4j.com/t/relationships-not-appearing-in-aura-after-csv-import-neo4j-data-importer-while-following-the-building-knowledge-graphs-a-practitioners-guide-chapter-4-instructions/65349 "2023-12-14T00:01:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![abpod](https://avatars.discourse-cdn.com/v4/letter/a/b5e925/32.png) [@abpod](https://community.neo4j.com/u/abpod)\
**Post date:** [December 14, 2023, 12:01am UTC](https://community.neo4j.com/t/relationships-not-appearing-in-aura-after-csv-import-neo4j-data-importer-while-following-the-building-knowledge-graphs-a-practitioners-guide-chapter-4-instructions/65349/1 "2023-12-14T00:01:31Z")

</div>

Hi all! Newbie here.  
I'm using Aura and the Neo4j Data Importer interfaces for this issue. I am also following the O'Reilly Building Knowledge Graphs A Practitioner's Guide compliments of neo4j. I am currently in Chapter 4 Loading Knowledge Graph Data. I get all the way through the import of the four CSVs (1/friends.csv 2/lives\_in.csv 3/people.csv 4/places.csv). In fact, the Import report shows everything as green and successful.

However, when I log into my Aura database instance, the Relationships are completely missing (i.e., LIVES\_IN and FRIENDS).

Here is a simple example of the csv contents and Cypher for FRIENDS Relationship  
Here's an example of the FRIENDS relationship csv  
:START\_ID(Person),:END\_ID(Person)  
23,42  
42,23  
42,55  
55,42  
Here's the corresponding Person.csv  
:ID(Person),name  
23,Rosa  
42,Karl  
55,Fred

And here is the Cypher

```auto
UNWIND $relRecords AS relRecord
MATCH (source: `Person` { `:ID(Person)`: toInteger(trim(relRecord.`:START_ID(Person)`)) })
MATCH (target: `Person` { `:ID(Person)`: toInteger(trim(relRecord.`:END_ID(Person)`)) })
MERGE (source)-[r: `FRIEND`]->(target)
SET r.`:START_ID(Person)` = toInteger(trim(relRecord.`:START_ID(Person)`))
SET r.`:END_ID(Person)` = toInteger(trim(relRecord.`:END_ID(Person)`));

```

Does anyone know why the import did not create both the FRIEND and LIVES\_IN relationships on the Aura side?

---

<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:** [December 14, 2023, 10:58am UTC](https://community.neo4j.com/t/relationships-not-appearing-in-aura-after-csv-import-neo4j-data-importer-while-following-the-building-knowledge-graphs-a-practitioners-guide-chapter-4-instructions/65349/2 "2023-12-14T10:58:23Z")

</div>

Is `:ID(Person)`the property name of the id field that was used when creating the Person nodes?

You should fix your imports to use simple property names.