Navigation:  Integration via database >

Diagnosis and Correction of Errors During the Import Process

During the import process of the data contained in the interface table, there may be errors that usually occur due to the existence of records with the same data in the database, or due to the absence of some data required for that type of record.

If any error of this type has occurred, its verification may be performed through the Import tracking screen, located in the SE Configuration component (Configuration Tool Import Tracking). On this screen, it is possible to view the records that were or were not executed successfully. It is possible to use the Filter by status to filter the records and display only the ones with errors. The reason of the error is displayed in the "Error description" column, making it possible to diagnose the problem and then fix it.

Data correction and reimport

After verifying the description of the error and filtering the desired records, it is then possible to use the "Export spreadsheet" button, located on the toolbar, to export the data set again and fix it.

To correct them, open the generated XLS and correct the data according to the description of the error (e.g.: if the error indicated that the record already exists, change the column that has the duplicated values). All values in the DSERROR column will be deleted, and the ones in the FGIMPORT column will be updated to “1”. Keep the values in the OIDINTERFACE, FGOPTION, and CDISOSYSTEM columns the same, since they are used to find the record to be replaced in the interface table.

After correcting the XLS, just use the "Import spreadsheet" button to replace the data in the DIINTERFACE table. Note that after the file is sent to the server, the records that were updated will again be marked for import and will be re-imported according to the Import scheduling set on the server.