At this step it is required to enter a name of report file on import (see chapter 61 “General characteristic of import/export operations”, subsection “Report file”). IMT extension is usually used for report files on import from text format.
In table 73-2 a list of messages about errors and other messages placed by the system in report file is given. These messages contain information about results of performing import operations.
Message | Explanation |
Total records: … | Total number of records read from import file. |
Total loaded records: … | Number of records of import file loaded to the table. |
Unexpected end of text file | Import file is empty. |
Record: … - Loading error | Error when adding a record to the table. Loading of record is not performed. Clarifying information is located in next line. |
Inappropriate data format | Specified field type of import file does not correspond to data in the field of import file. |
Inappropriate empty value (140) Field: … | Clarifying information to the message “Loading error”. Table field has the attribute “Not Empty” and the corresponding record field of import file contains empty value. |
Duplicated unique indexed value (260) Field: … | Clarifying information to the message “Loading error”. In import mode to the existing table this message denotes that table field has the attribute “Unique” and the corresponding record field of import file contains the value which already exists in the table. In import mode with updating table appearance of this message is possible if the table has more than one unique field and the import file contains the record which conflicts with more than one table record by different unique fields. |
Table 73-2. Messages in report file on import from text file
Messages “Record: …” (record number in import file instead of dots) is accompanied by the corresponding rejected record of import file.