Import errors fall into two main categories:
Validation errors - Errors are displayed in the Import Preview window. You must resolve these errors before you can continue and complete the Import.
Import errors - Errors are displayed in a Summary window. The records containing the errors are ignored and the Import continues. You can either correct the errors in the import file and re-import or add/modify the form directly.
Validation errors result from invalid data formats in the Import Spreadsheet. To avoid validation errors, ensure that the entries for each cell in the Import Spreadsheet meet the requirements for valid data entries (numbers fall within an allowable range, numeric data are all digits, there are no illegal characters, etc.).
Validation errors are detected before the data is actually imported into the system database. The errors display in an Import Preview window.
If the system detects errors, the appearance of the Import Preview window changes:
No errors detected – displays all data records from the Import Spreadsheet.
Errors detected – displays an ERROR FOUND IN DATA message and records that contain data format errors. Fields with errors are highlighted.
The Error column may display error messages such as
Too many characters in name field
Too many digits in Directory Number
Validation errors must be resolved before you can proceed to import data.
To view and resolve validation errors, select
Previous – Returns you to the first page of the Import dialog box. You can then revise the import file entries, and begin the import process again by creating a corrected import file.
Show Only Errors/Show All Data – Shows records with errors, or shows all entries. By default, the Preview window shows only entries with errors, and the button reads Show All Data.
Print – Prints the Preview window so you can keep a record of the errors.
Cancel – Cancels the import and returns you to the form. After canceling, you can modify data in the import file, and import again by creating a corrected import file. Or, you can exit the form and try importing at a later date.
Note: You cannot import erroneous configuration data. You must resolve errors before retrying the import.
Import errors occur when data from the Import Spreadsheet form conflicts with existing system data. For example, you could import a user profile that has the same Directory Number as a profile that already exists in the system database. Alternately, you could import a user whose name is exactly the same as the name of an existing user. In both cases, the imported data conflicts with existing system data, so import errors occur.
Import errors are detected during
the import process
If the system detects errors, a Summary window displays:
No errors detected – displays all data records from the Import Spreadsheet.
Errors detected – displays an ERROR FOUND IN DATA message and records that contain data format errors. Fields with errors are bold..
The Error column may display error messages such as
Directory Number already exists
Name already exists
Import errors must be resolved after the import is complete.
To view the errors in the Summary window, you can select
Show Only Errors/Show All Data – Shows only records with errors, or shows all entries. If the system detects errors, the Preview window defaults to Show Only Errors, and the button reads Show All Data.
Print – Prints the Summary window so you can keep a record of the errors. You can print the Summary window only when you are viewing Only Errors (that is, when the Show All Data button is visible at the bottom of the window).
Done – Closes the Summary window, and returns you to the form where you can then resolve the import errors.
Resolve these errors in the form that is receiving the imported data.
