06-05-2014, 09:26 AM
That sounds complicated, it is much easier than that if you have a way to identify each contact in the CSV in the application.
Let's imagine that each of your contacts has a unique identifier (be it their name, some ID field, ...), you import the CSV again, possibly only with the identifier columns, mandatory fields and department.
On the import step you will find a "Duplicates" section, you open that and select the options to update, in the columns list box you select the columns that uniquely ifentify your contact, then in the field mapping you select the department field so that field gets updated.
In short: import again activating deduplication and update ONLY the department field.
We use this all the time to update product unit price, for example,...
Make a backup of the database first.
Let's imagine that each of your contacts has a unique identifier (be it their name, some ID field, ...), you import the CSV again, possibly only with the identifier columns, mandatory fields and department.
On the import step you will find a "Duplicates" section, you open that and select the options to update, in the columns list box you select the columns that uniquely ifentify your contact, then in the field mapping you select the department field so that field gets updated.
In short: import again activating deduplication and update ONLY the department field.
We use this all the time to update product unit price, for example,...
Make a backup of the database first.
Joe
TSolucio
TSolucio