Process to import Company and Contact CSV
Hi. I would like to understand how to import a CSV that has Company and Contact details in each row. I have two tables in my database; Company and Contacts. In the contacts table there is a look up to which company the contacts work for. So in the company table I have only one copy of the company. Question is how do I import multiple employees that work for one company. Eg.
Ninox John Smith
Ninox Tony Winter
Ninox Max Verstappen
Ninox Nikko Hulkenburg
When I import this I want to end up with one new Company "Ninox" record and four Contact records.
The underlying reason I want this is that I have companies that have maybe 100 Contacts which I need to import but I need a database where I can change the Company name or address only once so I don't have to update 100 contacts. However, can't see how to import these records.
2 replies
-
Read here about Importing Linked Data
https://ninoxdb.de/en/manual/import-and-export/importing-linked-data
-
Thank you, I had searched but completely missed this. It is exactly what I was looking for.
Content aside
- 4 yrs agoLast active
- 2Replies
- 1106Views