Datetime fields must use the format “yyyyMMdd HHmm".

Before version 1.3.1, entries are case sensitive.  Make sure to enter these values as they appear.

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

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

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.

Can be used in both the XINI and XASN file types.

ConcurrentDataFiles=-1

Can be set in the X Stream definition to run multiple XASN/XINI files at the same time.

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.

DataMask=xml

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. 

DataPath=c:\ximport\inbox

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

Inherit=1

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"

  Info
  Starting version 1.3.0, the Delimiter value can be set to “Excel” to tell the import process to import Excel formatted files.  This process supports Excel 2003 and Excel 2007 or newer files (*.XLS, *.XLSX, *.XLSB and *.XLSM).

  
  

This functionality will require the installation of the 32 bit Microsoft Access Database Engine 2010 Redistributable. 

Delimiter=XML

The directory in which to store any error log files for the import.

ErrPath=c:\ximport\errors

Indicates how many lines to skip from the top on an imported flat file. This allows you to bypass header rows in data files. 

NumLinesSkipped=

Full path to the preprocessor executable. 

PreProcessor=c:\ximport\plugins\eTracPreProcessor.exe

0/1 to enable/disable passing of the database instance to the pre-processor. It defaults to 0 to not pass the parameter so that it will not cause a regression for any existing preprocessors.

The directory in which to store copies of original import file and the log of XML requests used to place an order.

ProcPath=c:\ximport\processed

Qualifier defaults to the double-quote character and should almost never be modified. The corner case where Qualifier may need to be specified is if the import file format is a hybrid CSV file where escaped data is surrounded with a character other than the double-quote. This case is exceedingly rare. 

Qualifier="

Full URL to the XMLListener.asp file. 

URL=http://127.0.0.1/XMLListener.asp

The XML node used to indicate the base node.  

BaseNode=/OrdersXASN

The XML node used to indicate orders.  If listed, relative to BaseNode.  Otherwise, it is an absolute path from the root of the document. See DATA ITEMS (XML) below. 

OrderNode=/Orders/Order

The XML node used to indicate parcels. See DATA ITEMS (XML) below. ParcelNode is relative to OrderNode if used in XINI or if BaseNode is specified in routed.  Otherwise, it is an absolute path from the root of the document.

If the XML file submitted is wrapped in leading characters, this will prevent X Import from processing the document.  This is because having leading characters is not valid XML. In order to modify the file into becoming valid XML, you can specify a mask of characters to strip out from the very beginning of the file if they are found.  Note that this could be more than one character. Also, note that this is not a dynamic field, so do not wrap the value in quotes or begin it with 0,. StripBeginningQualifier is available beginning in X Dispatch 12.1.3 X Import. 

StripBeginningQualifier=”

If the XML file submitted is wrapped in trailing characters, this will prevent X Import from processing the document.  This is because having trailing characters is not valid XML. In order to modify the file into becoming valid XML, you can specify a mask of characters to strip out from the very end of the file if they are found.  Note that this could be more than one character. Also, note that this is not a dynamic field, so do not wrap the value in quotes or begin it with 0,. StripBeginningQualifier is available beginning in X Dispatch 12.1.3 X Import. 

StripEndingQualifier=”

A regular expression is used to test each line to see if it should be processed.  If the regular expression matches the current line, it will be skipped and not be processed.  This is only processed for fixed width and delimited imports. It will not be considered in an XML import.  Available in XINI beginning with 12.1.4. Available in 12.0.0 for XASN. Here is a good reference for regular expressions: http://www.regular-expressions.info/reference.html

^[^"]

That regular expression matches any line that does not begin with a double quote (").  Therefore, any line beginning with something other than a double quote would not be processed by X Import.

The number of days to keep files that are in the ProcPath (.proc, .original) and ErrPath (.err) directories (EdiProcessedPath (.proc, .original) and EdiErrorsPath (.bad) for EDI).  If this setting is omitted from the configuration file the number of days to keep the files defaults to 90.  If the value in the configuration file cannot be parsed as an Integer the number of days to keep the files defaults to 90.  The minimum allowed value is 5. If the value in the configuration file is less than 5, only files older than 5 days will be deleted. 

LogRetentionDays=7

The number of times to attempt to re-import orders that failed the attempt. Omitting this item or setting it to 0 will have no change on import functionality.  Any numeric value higher than 0 will tell XImport to try X number of times to re-import the failed data before giving up.

This feature will only re-import failed orders/stops. Any successfully imported orders/stops will not be re-imported. 

MaxReimport=3

0/1 (disable/enable) this tells the Import process that the date/times are already localized to the stop location in the ASN file, and not to localize them against the server date/time. This value defaults to 0 (disabled) so that it works as it always has.

If the user specifies a date/time with a timezone offset, the system will make use of that offset for the timezone (e.g. "07/27/2018T00:00:00-04:00").

LocalizedDateTimes=1

Specifies how many times each line is attempted on an import before moving on and throwing an error.

Defaults to 1 if not set. 

Specifies how many lines in an import can fail to import before the remainder of the file is failed and set for reimport later.

If not set, the import process will continue and all of the failed entries will be put into a new file for reimport. 

For example, if a CSV file has 100 rows, it processes the first 25 successfully, the MaxFailed is set to 15, and the next 15 lines fail, the remaining 60 lines are failed as well. The new file for reimport attempt will have the remaining 75, including the 15 failed entries, and it will be attempted again based on the MaxReimport. 

Specifies an amount of time in milliseconds to wait in between failed attempts at importing a line from a file. This is the delay for attempting to process each data set. Delimited files would be the delay for processing each row, XML would be a delay for processing each node based on the Attempts value.

Defaults to 0 if not set.

PickupDate= NOW+360
DeliverDate=TODAY+2

PickupDate=NOW&09:01|DAYFLOOR

NOW is a macro that pulls the SERVER time, not the time local to the customer. The server time for Cloud customers is always AZT and the imported files will show the time local to the customer. In the example above, if the customer’s local time is EST you would need to add 3 hours to the syntax example: 

PickupDate=NOW&12:01|DAYFLOOR