File Format (General)

When importing data, it is important to know the structure of an X Import configuration file. There are two types of files, which can be distinguished by their file extension.

XINI files are on demand configurations.
XASN files are routed configurations.

Imports can use XSLT on an Excel file. Make sure that the XSLT file is in a folder location that is accessible by the import process or by putting the XSLT file as an attachment and putting the attachment is in the import file (XINI/XASN).

The following is for both XINI and XASN file types unless otherwise noted.

Datetime fields must use the format “yyyyMMdd HHmm".

Comments

Comments are indicated by the '#' character and continue to the end of the line and can be at the beginning of a line, or at the end.

Example

# This is a comment
OriginName=0,CXT Software # This is also a comment

General Configuration Items

Configuration items are set using a Key=Value format.

Example

DataPath=C:\ximport\inbox # example comment
DataMask=XML
Inherit=0
ProcPath=C:\ximport\Processed
ErrPath=C:\ximport\Errors
# another comment
URL=http://127.0.0.1/SampleWeb/XMLListener.asp
Delimiter=XML

Configuration Item	Description
ConcurrentDataFiles	Optional This value is set to the number of concurrent data files to be processed and will tell the system how many parallel processes to attempt to create. If this value is set to -1 it will tell the system to create as many as it can. If this value is NOT set, it will default to 1 to mimic current functionality. Example `ConcurrentDataFiles=-1`
ConcurrentProcesses	Optional Can be set in the X Stream definition to run multiple XASN/XINI files at the same time.
DataMask	Required Specifies the extension of the import files (e.g., xml, txt, ). To disregard the file extension, you may use '', however, the DataMask item should be set whenever possible to prevent the processing of unintended files. Many times, third-party companies sending the import files will upload the file with a ".tmp" extension and rename the file to the correct extension only once the upload has been completed. If the DataMask is set to '' these temporary files may be processed before they have been completely transferred. Example*
DataPath	Required Directory to monitor for incoming files. If the directory is not on the local machine, the fully qualified URI (\\server1\customer1\inbox) must be used. Example
Inherit	Optional Specifies whether files moved to the “ProcPath” directory should inherit the permissions of that directory when moved. A value of “1” indicates files should inherit permissions, while a value of “0” indicates the file should retain its current permissions (default behavior). Example
Delimiter	Required This specifies the type of file to be processed and must be one of: “XML”: The input file is an XML formatted document “0”: The input file is a fixed-width file “TAB”: The input file is tab delimited “,”: The input file is in standard CSV format (See also: "Qualifier" item) Any other character: The input file will be split on this character. "Excel": This functionality will require the installation of the 32 bit Microsoft Access Database Engine 2010 Redistributable. Example
ErrPath	Required The directory in which to store any error log files for the import. Example