Fixing import errors
Prerequisites
- Access to the Spreadsheet import and integration > Import tracking (DI013) menu.
- Data import executed in the system.
Introduction
The Import tracking (DI013) menu gathers all imported records in the list shown on the main screen. If an error occurred during the import, it can be seen in the Error description column and diagnosed.
See how to correct records imported with errors:
Fixing import errors
1. Access the Spreadsheet import and integration > Import tracking (DI013) menu.
2. Use the Status filter in the search panel and check the Error option so that only the records with errors are shown. Use the other available filters if you wish to restrict the records with errors to be shown.
3. Click on the More toolbar option.
4. Click on the 
button. All records with errors displayed on the list will be exported.
5. Open the generated XLS file and correct the data, in accordance with the description of the error (for example: if the error indicated that the record exists already, edit the column that has the duplicated value). All values in the DSERROR column will be deleted, and all values in the FGIMPORT column will be changed to "1". Do not change the values in the CDINTERFACE, FGOPTION, and CDISOSYSTEM columns, as these values are used to find which record will be replaced in the interface table.
6. After performing the necessary corrections, save the spreadsheet and proceed with the import again.
• Refer to the Importing a DIINTERFACE spreadsheet article for more details on carrying out an import.
• Once the file is sent to the server, the edited records will be marked for import again and will be reimported, following the import scheduling configured on the server.
Conclusion
All done! Now you know how to fix possible errors when importing data into the system.