Import for Manufacturer – how to not allow overwrite of existing data on relationship tab
Hi,
Is there a way to not allow Import to overwrite existing data on the relationships tab of a manufacturer?
For example, we have many manufacturers where we want to add a Document to the relationships tab but we don’t want to wipe out any other items or changes listed there already.
I can’t seem to find a preference, smartrule, etc that will leave existing data there.
Only way I thought of to do it would be to export the Manufacturers with the data on the relationship tab, add the new Document reference for the Manufacturers to the spreadsheet and import it back again. The problem is, Agile doesn’t let you choose anything from the Relationship tab in formatting the values for searches or reports.
Any other ideas on how to automatically add a document number to 300 Manufacturers relationships tab?
Thank you,
Laura
Have you tried setting the “Multi Row Update Mode” Import preference to “Add/Update Only”. As far as I know, this works for all the “tables” you can import to.