Importing Customer Nodes
You imported Product nodes in the previous lesson. Now import Customer nodes using the same workflow.
The customers.csv file is already loaded in your Import tool from when you uploaded all files.
Map the Customer node
In the Data Modeling tab:
-
Click the + Node Label button to add a new node
-
Set the label: Under Definition, set the label to
Customer -
Select the table: Under Table, select
customers.csv
Configure properties
Use the Map from table button and select these columns:
| Column | Type | Rename To |
|---|---|---|
customerID |
String |
id |
companyName |
String |
name |
contactName |
String |
|
country |
String |
|
city |
String |
ID Property
Verify the ID property is set to id and update if necessary.
Run the import
Click the Run Import button. You should see confirmation that 91 Customer nodes were created.
Validate Import
Once you have imported the Customer nodes, click the Check Database button to verify that the task is complete.
Hint
Follow the same steps as the previous lesson where you imported Product nodes.
Make sure to:
-
Set the label to
Customer -
Map from
customers.csv -
Set
idas the ID property (renamed from customerID) -
Click Preview to review
-
Click Run Import
Solution
The Customer node should be configured with:
-
Label:
Customer -
File: customers.csv
-
ID property: id
-
Key properties: name, country, city
After running the import, you should have 91 Customer nodes in your graph.
Download Solution
If you are having trouble, you can download the solution model and open it using the Open model (with data) option.
-
Download 5-import-customers.zip
-
In the Import tool, click the 3-dot menu (…) and select Open model (with data)
-
Select the downloaded zip file
Summary
You imported Customer nodes into your graph:
-
Created 91 Customer nodes
-
Renamed
customerIDtoidandcompanyNametoname
Next, import Order nodes using the same process.