Import Variables

The following common variables may be accessed within Kourier Integrator while working with Import Specifications. Typically you will access these variables while either writing an Import Event Handler or when writing a formula for a particular field.

Record and File Variables

These are the primary variables for working with files and records within Kourier Integrator during import processing.

Variable	Description - Usage - Notes
FILENAME$	Import (target) file name
F.FILENAME$	File pointer to the import file
IMPORTSUB$	Import subroutine name
RECISNEW$	True if record is not read from disk
RECISLOCKED$	Set if records was locked
RID$	Record item-id
XID$	External item-id
IUD$	File Action (I)nsert,(U)pdate or (D)elete
RECORD$	Current Record
OLDRECORD$	Old record as read from disk
XMLTRANS$	XML transaction or flat-file that is being processed
XMLRECORD$	XML or flat-file record that is being processed
MSGHDRS$	Message headers
SKIP$	Skip the next logic step. If this variable is set to 1, make sure that the following variables have been assigned a value: FILENAME$, RID$, XID$, and IUD$
INTGID$	Integration ID
TRANSID$	Transaction ID
ISATEST$	Import is running in TEST mode w/o write to disk

Error Variables

These variables are used to communicate errors between user-written code and the Kourier import engine. There are two types of errors:

FATAL errors will stop processing by the import engine immediately.

Examples of fatal errors are files not opening, parsing errors, etc.
APPLICATION errors allow the import engine to continue processing so that all application errors can be displayed at one time.

Examples of application errors are invalid codes, non-numeric data, etc.

If any FATAL or APPLICATION error is returned, the transaction will be flagged as not loaded and will be treated as an exception.

Variable	Description - Usage - Notes
FATAL.ERR$	Fatal Error code (must be in KORE-MESSAGES)
FATAL.PARMS$	Fatal Error message parameters
APP.ERR$	Application Error message (text)
APP.ERR.CNT$	Number of applications errors

Field Level Validation Variables

These variables have context when accessed from field level validation code

Variable	Description - Usage - Notes
NAME$	Field name
ANO$	Attribute number
VNO$	Value number
SVNO$	Sub-value number
MIN$	Minimum field length (0 = not required)
MAX$	Maximum field length (0 = unlimited)
EDITS$	Validation edits and transformations
FIELD$	Current field value