I am trying to import a large dataset consists of 8 CSV files using admin import but I am facing difficulty on how to create relationships among them.
Here is the explanation of the CSV files.
- Addresses.csv. consists of two columns
- users.csv addID, userID.
txID, blockID,n_inputs, n_outputs
- Incoiming Transaction.csv
txID, addID, value.
- Outcoming Transaction.csv
txId, addID, value.
- Hash Transaction.csv
- Transaction Time.
I want to create relationships among them based on the addID and txID exist in each file.
Note that, I create a header of each file in a separate CSV file. I was able to successfully create the addresses and users relationship using:
neo4j-admin import --id-type=STRING \ --nodes:User="import/users-header.csv,import/users.csv" \ --nodes:Address="import/addresses-header.csv,import/addresses.csv" \ --relationships:PARTOF="import/partof-header.csv,import/users.csv,import/addresses.csv" \ --ignore-missing-nodes=true \ --ignore-duplicate-nodes=true \ --high-io=true
and the partof-header.csv is as following:
the addresses-header is
and users-header is
but when it comes to other files, I faced difficulty to create the relationship.
Can anyone guide me on how to create relationships based on their IDs.
Does anyone have any suggestions on how I could do this more efficiently?