Use the Fixed option to import files in fixed column width and line. Selecting the Fixed option enables the Data in table format and Ignore first row in file checkboxes. EPX does not have the ability to parse files to determine the data structure. You must know the column and line locations of keys and data to import information from EPX.
Data in Table Format
Select this option to specify that the data in the fixed format file to be imported is in tabular form. If the data is not in tabular form and the Data in Table Format checkbox is not checked, the BIC processes the file as a semi-unstructured document (like an e-mail message).
With this option, all rows of the specified file are processed (i.e., the start and ending line numbers are ignored). It is also assumed that each line in the file represents a row of data (i.e., data cannot span more than one line).
Ignore First Row in File
Select this option to have the Import/Export BIC ignore the key name data contained in the first row of a file.
Decode Carriage Return/Line Feed Option
Click the Decode CRLF encoded as: option to enable the text box in which you can enter the symbols or characters to be decoded as carriage return/line feed.
Import Items
When you select the Fixed format option, the following columns are displayed in the Import Items box:
- Work Item Key – Enter the names for work item properties of the data to be imported.
- Start Line – Enter the line number in the file where the data to be imported into the work item property is located. The start line must be specified for each work item key to be imported.
- Start Column – Enter the numeric value for the column position of the first character of data to be imported into the work item property is located. The starting column must be specified for each work item key to be imported.
- End Line – Enter the numeric value for the line number when the BIC should stop reading import data.
- End Column – Enter the numeric value for the column position where the BIC must stop reading import data.
To add values in the appropriate text cells, click Add to enable text cells and enter data in the text cells. Click Remove to delete text cells.