Click the Done icon in the toolbar to save the current line item and return to the import specifications main page.

Click the Add icon in the toolbar to save the current line item, clear all fields and keep the window open so that you can add another line item, which will be the last line number available.

Click the Remove icon in the toolbar to delete the current line item, close the window and return to the import specifications page.

Click the Up icon in the toolbar to move the line item up in the line item list relative to the other line items, thereby decreasing the current line item number. Click Done or Add to save your change.

Click the Down icon in the toolbar to move the line item down in line item list relative to the other line items, thereby increasing the current line item number. Click Done or Add to save your change.

Click the Help balloon to open the help for this page.

Field Name

Description - Usage - Notes

Line

The order sequence this field should appear in the import.

Name

Enter the name of the target field

Column

For delimited imports (CSV, TAB, TILDE or PIPE), enter a valid column number or a literal string.

For fixed imports, enter a characters starting position, a coma, and the number of characters to read or a literal string.  For example, a column specification of 17,10 will read the first 10 characters of the row starting at character position 17.

You may use substitution parameters in a literal string.

This field is required.

Position

The attribute number of the field that you are mapping to in the Target file. Format is: Attribute, Value, Subvalue. Where Attribute = 0-nn; Value = > 0 or -1; SubValue => 0 or -1

When mapping to multi-part keys use Attribute 0, separator character,  integer specifying the position of the data value within the key (or -1 to add a new value or SubValue). 

Examples:

• 1
• 1,1
• 1,-1
• 1,1,-1
• 0*1
• 0*2 
   

Transaction Key

Select this checkbox if this field should be part of the transaction key. This is important if you are processing multiple transactions as part of your import file.

Minimum Length

Enter a 1 if this field is required, otherwise leave blank. 

Maximum Length

Enter a 0 (zero) if there is no maximum length, otherwise enter the maximum number of characters. 

Before Validation

If you want to do extensive validation, transformation or other processing of the data you may enter a valid UniBASIC expression or code segment here. You may also reference specific Kourier import common variables within your validation code.

You may also use Import Conversion and Validation in this field or within the UniBASIC code.

Edits

For standard import edit conversion and validation, use the Import Conversion and Validation to convert a data value, such as a date or time, into the internal U2 representation of the data value or to validate that a data value meets a specified import edit. If the data value does not conform to the import edit, an application error will be returned. 

These conversions and validations are processed after any Before Validation processing, unless the SKIP$ variable has been set to 1. 

You may specify one or more conversion codes by separating each conversion code by the pipe (|) character. If you use multiple conversion codes, the codes are applied from left to right, so that the leftmost code is applied to the original value, then the next conversion code to the right is applied to the result of the first conversion, and so on. 

Comments

Enter any comments you wish to describe or document this import field. A note icon will be displayed in the list view if there is a formula defined for a field. Hover your mouse over the icon to see the note.