Hello everyone,
I've been looking at importing data via CSV files, for my use case of creating a personal CRM. I want to import data from various old sources into my database. To start, I have an excel file containing names, email addresses, etc. The first time I import this list, each item gets created and assigned an Item ID. So far so good. Now I want to import additional data to these items, and that's where I'm getting stuck.
If I have a second list containing other or updated information related to the same names, I want to be able to assign them to the right Item IDs. I can get the right Item IDs by exporting the InfoQube grid, so I know which ID matches which name, and get the information properly lined up inside excel and the CSV file. However, the import CSV function will not allow me to add/update existing information having IDItem as one of the import fields.