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 export.

Name

Enter the name of the field, this will be used for display purposes in error messages.

XPath

Enter a valid Import XML XPath Expressions, a literal string, or a valid sting containing one more substitution parameters. This field is required.

Field Type

Select a field type from the Field Type drop-down menu. A detailed list of Field Types and their example usage can be found here.

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. 

Examples:

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

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 note for a field you can hover your mouse over the icon to see the note.