Data import field setup |
|
|
|
Data import field setup |
|
|
Data import field setup |
|
|
|
Data import field setup |
|
|
After specifying the delimiter characters for a delimited import file, XPAC will display the Database Import Template Setup - Step 3 dialog box, where you can change the field setup.
In the field setup box there are three columns of information. The first contains the Field Number within each record. The maximum field number is controlled by changing the Number of Fields per Record.
The second column contains the Field Type which can be selected from a drop down menu in each field. The third column contains the Field Attribute which can also be selected from a drop-down menu:
| • | If the Field Type is set to Ignore, then the field will not be written anywhere. |
| • | A Position in level (PIL) number field type is used to import a number signifying the record position in level at the database level defined in the Attribute. |
| • | A Record name field type is used to import a string of text signifying the record name at the database level defined in the Attribute. |
| • | If the field type is set to Data Field, the data will be written to the data field specified in the Attribute for the current record. The current record is defined by the record identifiers. |
In delimited import files, a specified number of fields are read as a single database record, regardless of whether they occur on the same or different lines in the file. Set the number of lines in the Number of lines per record field.
All fields that have been specified in the field setup can be cleared at any time by clicking Clear All.
At the top of the File Preview section there is a line which displays the name of the selected data import file. The File Preview section is used to display a sample of the import file. The lines of data for one record have a white background and the lines of data for the next record have a yellow background, and so on.
The current template can be saved or an existing template can be loaded from the field setup window.
If you need to return to the delimiters window in the Database Import Template, click Back.
When you have completed the field setup, click Finish to proceed with the data import.