Import queue

Imports > Import queue

This form displays both imports and reports that have been processed or scheduled by the current user.

Once this form is opened, observe the information of your import: the template’s name, the time it was queued at, status, amongst others. The Status column, indicates whether the import is finished or not. With a newly imported data file, the Status is shown as Pending. Wait for a few seconds, and click the Refresh icon now and then, to check whether the operation is finished.

Show or hide the colums you wish by clicking the NDMEhiddenSettings icon placed at the top left corner of this form. Filters may be applied per column, and then saved all together with the Filters button.

When the import is finished, Status changes to either Finished (if the operation was completely successful), Finished with remarks (if the error log contains any entry), or Failed (if a major error occurred).

In case of remarks or failure, inspect the log of the import operation by clicking the icon in the Template column. Correct the issues pointed out by the remarks and upload the file again in the Prepare import run form.

If a data file needs to be uploaded more than once due to remarks, make sure to edit the Template type to a better option. For instance, Insert or update.
Most common remarks in the import log

  1. Data in Excel cells do not match with the type of field in the IS Tools application. For instance, a cell containing text that is meant to be imported into a number field, which is not supported in order to keep the integrity of the information ('Cannot read number'). Or a value that has not been defined in the list of a drop-down is tried to be imported into the drop-down field ('Drop-down value not found').

  2. 'Record already exists. This is not an UPDATE import'. An Insert only import has found an existing record name in the data file.

  3. 'Record does not exist. This is not an INSERT import'. An Update only import has found an non-existing record name in the data file.

  4. The data file contains formulas, formatting, macros or data is located in other sheets instead of in the first sheet only.

  5. 'B2: No value existed in record "R1" for "Field1", nothing to delete'. Cells of the Excel file are empty and the Skip empty cells setting is not ticked (in the Prepare import run form).

  6. 'Could not insert value because of unique constraint'. A cell of the Excel file contains a non-unique value, that fails to be inserted into a field set as Unique.

  7. 'Mandatory field values cannot be deleted: Row skipped!'. A cell of the Excel file contains an empty value, that fails to be inserted into a field set as Mandatory, in combination with the Skip empty cells setting unticked (in the Prepare import run form).

  8. 'Some mandatory fields are missing values: Row skipped!'. A cell of the Excel file contains an empty value, that fails to be inserted into a field set as Mandatory.

  9. 'Rule invocation nested too deep'. The row in consideration will be skipped (i.e., not imported) due to field(s) that attempted to be triggered by recursing rules.

  10. 'Validation error, column(s): B. Not a valid e-mail address. Row skipped!'. A cell of the Excel file contains an invalid value, that fails to be inserted into a field used in a validation rule; e.g., the field "E-mail address" should validate the format john.smith@company.com.

  11. 'Validation error, column(s): B. Describe reason cannot be empty. Row skipped!'. A validation rule using the Is empty function is active.

Delete/Cancel and Terminate icons. Imports can be deleted only if its execution has not started or has already finished (i.e., the Status indicates that it is still Waiting in queue or that is Finished, respectively) by ticking the corresponding checkbox in the leftmost column and clicking the Delete button. But if an import is already running (i.e., the Status indicates Started or any percentage done), it can be terminated by clicking on the Terminate icon (if form rights set).

Caution must be taken with the termination of an import, since this action does not undo the changes made on records before the Terminate button was clicked. In other words, it is possible that records were already inserted, updated or deleted (depending on the import type) even if the termination action was performed.