Support Article
Importing records to data type adds more rows
SA-74459
Summary
Data type import adds double the number of records after upload.
Error Messages
Not Applicable
Steps to Reproduce
- Export data type records.
- Add new records.
- Import the file with the Purpose set as 'Add or Update'.
Root Cause
The data type has multiple keys defined in its class definition. It is determined that the order of the keys on the Mapping screen during upload is different from the order of the keys in the class definition. Therefore, during the import, multiple new records are uploaded.
Resolution
Perform the following local-change:
- On the Import Mapping screen, change the order of the keys to match the order defined in the class definition.
- Swap the necessary columns in the CSV to match the order of the keys on the Mapping screen.
Published August 19, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.