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”). IMD extension is usually used for report files on import from DBF format.
In table 69-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 DBF file. |
Total marked as deleted: … | Number of records of DBF file marked as deleted. |
Total loaded records: … | Number of records of DBF file loaded to the table. |
The memo file not found | There is no memo file for DBF file. Loading of data is not performed. The message appears only in the case if import of memo field of DBF file is enabled. |
Invalid correspondence of fields | Field types of DBF file and of the table do not correspond. Loading of data is not performed. When such an error appears it is recommended not to use the existing settings file and perform the setting anew. |
Record: …- Marked as deleted | Record of DBF file is marked as deleted. Loading of record is not performed. |
Record: …- Loading error | Error when adding a record to the table. Loading of record is not performed. Next line contains clarifying information. |
Inappropriate empty value (140) Field: … | Clarifying information to the message: “Loading error”. Table field has the attribute “Not Empty”, and the record field of DBF file corresponding to it contains an empty value. |
Duplicated unique indexed value (260) Field: … | Clarifying information to the message “Loading error”. In import mode to existing table this message denotes that table field has the attribute “Unique”, and the record field of DBF file corresponding to it contains the value which is already present in the table. In import mode with updating table this message can appear, if the table includes more than one unique field and DBF file has the record conflicting with more than one table record by different unique fields. |
Table 69-2. Messages in report file on import from DBF file
Messages “Record: …” (record number in import file instead of dots) are accompanied by displaying the corresponding record of DBF file which was not loaded.
 |  |
