excerpt

When importing data into X Dispatch, 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.

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

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.

Excerpt

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

paste-code-macro

language	xml
title	Example

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

General Configuration Items

Paste code macro

language	xml

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 items are set using a Key=Value format, where key must be one of:

ConcurrentDataFiles: Optional (starting in version 1.2.0)

Expand

Note
If this value is NOT set, it will default to 1 to mimic current functionality.

Paste code macro

title	Example

ConcurrentDataFiles=-1

ConcurrentProcesses:

ExpandCan be set in the X Stream definition to run multiple XASN/XINI files

Configuration items are set using a Key=Value format.

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.

Note
If this value is NOT set, it will default to 1 to mimic current functionality.

Code Block

title	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

Expand

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.

paste-

Code Block

-macro

title	Example

DataMask=xml

DataPath

:

Required

Expand

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.

paste-

Code Block

-macro

title	Example

DataPath=c:\ximport\inbox

Inherit

:

Optional

expand

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

paste-

Code Block

-macro

title	Example

Inherit=1

Delimiter

:

Required

Expand

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.

Info
In versions prior to 1.4.3, the CSV file was limited to 201 columns. After 1.4.3, the CSV file can an unlimited number of columns.

Paste code macro

title	Example

Delimiter=XML

ErrPath: Required

Expand

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

Paste code macro

title	Example

ErrPath=c:\ximport\errors

NumLinesSkipped: Optional

Expand

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

Paste code macro

title	Example

NumLinesSkipped=

PreProcessor: Optional

Expand

Full path to the preprocessor executable.

Paste code macro

title	Example

PreProcessor=

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

Code Block

title	Example

Delimiter=XML

ErrPath

Required

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

Code Block

title	Example

ErrPath=c:\ximport\errors

NumLinesSkipped

Optional

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

Code Block

title	Example

NumLinesSkipped=1

PreProcessor

Optional

Full path to the preprocessor executable.

Code Block

title	Example

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

Note

If running the preprocessor from a batch file, you must include the full path to the specified preprocessor within the batch file and not use a referential path.

Example:

c:\ximport\plugins\eTracPreProcessor.exe

NoteIf running the preprocessor

- would run properly from a batch file

, you must include the full path to the specified preprocessor within the batch file and not use a referential path.

Example:

c:\ximport\plugins\

.\eTracPreProcessor.exe - would

run properly from a batch file.\eTracPreProcessor.exe - would

not run properly from a batch file

PreprocessorPassInstance

:

Optional in X Dispatch 19.2 or newer

expand

0/1 to enable/disable passing of the database instance to the pre-processor.

It defaults

Defaults to 0 to not pass the parameter so that it will not cause a regression for any existing preprocessors.

ProcPath

:

Required

Expand

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

paste-

Code Block

-macro

title	Example

ProcPath=c:\ximport\processed

Qualifier

:

Optional

expand

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.

paste-

Code Block

-macro

title	Example

Qualifier="

URL

:

Required

Expand

Full URL to the XMLListener.asp file.

paste-

Code Block

-macro

title	Example

URL=http://127.0.0.1/XMLListener.asp

BaseNode

: Optional;

Required only if using XML

and Routed Only Expand

for Routed

The XML node used to indicate the base node.

paste-

Code Block

-macro

title	Example

BaseNode=/OrdersXASN

OrderNode

: Optional;

Required only if using

XML only expand

XML

The XML node used to indicate orders.

If

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

paste-

Code Block

-macro

title	Example

OrderNode=/Orders/Order

ParcelNode

: Optional;

Required only if using

XML onlyexpand

XML

The XML node used to indicate parcels. See

DATA ITEMS

Data Item Types (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.

Info

This node supports XPath statements. These statements are a powerful method to extend the capability of returning data.

Example:

if you wanted the ParcelNode to find all subnodes that start with “D_87”, you could use an XPath statement such as this:

S_MAN[D_88_1="W"]/*[contains(local-name(),'D_87')]

This statement only looks at S_MAN nodes that have a D_88_1 node that is set to “W” and then returns all sub nodes that start with “D_87”.

StripBeginningQualifier

: Optional;

Optional

Info
Used in XML only

expand

.

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

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

This could be more than one character

. Also, note that this

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

paste-

Code Block

-macro

title	Example

StripBeginningQualifier=”

StripEndingQualifier

: Optional;

Required only if using

XML only

XML

Expand

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

This could be more than one character

. Also, note that this

and 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. Paste code macrotitle

Code Block

title	Example

StripEndingQualifier=”

SkipLinesIfBeginsWith

: Optionalexpand

Optional

Info
This is only processed for fixed width and delimited imports. It will not be considered in an XML import.

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

Here is a good reference for regular expressions: http://www.regular-expressions.info/reference.html

paste-

Code Block

-macro

title	Example

^[^"]

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.

LogRetentionDays

: Required, best practice to set

Required

Tip

title	Best Practice

Set between 3 and 7 days with the max set to 7 days for Cloud

, except Amazon

.

Expand

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

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.

paste-

Code Block

-macro

title	Example

LogRetentionDays=7

MaxReimport: Required with X Dispatch 14.2.4 or newer

Expand

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.

Paste code macro

title	Example

MaxReimport=3

LocalizedDateTimes: Optional in X Dispatch 18.1 or newer

Expand

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.

Info
This allows the user to let the import plugin know that the date/time stamp they are passing in (e.g. "07/27/2018 00:00:00") has already been localized.

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

Paste code macro

title	Example

LocalizedDateTimes=1

Attempts: Optional in X Dispatch 19.2 or newer

Expand

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

Defaults to 1 if not set.

Note
If not managed correctly, it could potentially cause substantial processing delays. Before implementing ensure that you fully understand how the element works with the MaxFailed and RetryDelay(ms) to prevent issues with integration processing times.

MaxFailed: Optional in X Dispatch 19.2 or newer

Expand

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

ReImport

Optional

Used to reimport the processing of a file in the processed directory that does not have a .proc file.

Code Block

title	Example

ReImport=1  # Default is 0 ( no reimport ).

ReportEmail

Optional

The e-mail address to which X Import will send a report about the import process for the current input file. Multiple email addresses should be comma separated. This works for both On Demand and Routed.

Code Block

title	Example

ReportEmail=text@cxtsoftware.com

ReportEmail is not stored with the Order, but is used to create an email to be sent. It could be found tblMailLog, tblMailOutbox, or tblMailOutboxHistoric, depending on the time that has passed since the import and the status of email.

MaxReimport

Required

The number of times to attempt to re-import failed imports. Omitting this item or setting it to 0 will have no change on import functionality. Any numeric value higher than 0 will tell X Import to try the configured number of times to re-import the failed data.

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

Info

If an import fails due to a bad parcel, X Stream will not create the stop or any parcels associated to the stop (even good parcels). A re-import file is generated (regardless to the MaxReimport setting) containing the stop information and only the "good" parcel to re-import (this helps avoid future duplicates if consolidation logic is not used). If the key ReportEmail is in the file, it will trigger an email with the failing reason.

Code Block

title	Example

MaxReimport=3

LocalizedDateTimes

Optional

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.

Defaults to 0 (disabled) so that it works as it always has.

Info
This allows the user to let the import plugin know that the date/time stamp they are passing in (e.g. "07/27/2018 00:00:00") has already been localized.

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

Code Block

title	Example

LocalizedDateTimes=1

_{Possible version compatibility issue. See Changelog below.}

Attempts

Optional

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

Defaults to 1 if not set.

Note
If not managed correctly, it could potentially cause substantial processing delays. Before implementing ensure that you fully understand how the element works with the

Attempts and RetryDelay

MaxFailed and RetryDelay(ms) to prevent issues with integration processing times.

RetryDelay(ms): Optional in X Dispatch 19.2 or newer

Expand

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.

_{Possible version compatibility issue. See Changelog below.}

MaxFailed

Optional

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.

Note
If not managed correctly, it could potentially cause substantial processing delays. Before implementing ensure that you fully understand how the element works with

the Attempts and MaxFailed to

the Attempts and RetryDelay(ms) to prevent issues with integration processing times.

XSLTTranslator: Optional

Expand
Contains the file name of the XSLT file to use for translation (e.g. C:\IMPORT\TEST.XSLT). The XSLT file can be used to modify the incoming data before it is processed by the Import plugin.

XSLTDataPath: Optional

Expand
Contains the directory location where to write the XSLT translation output data. This is primarily used for debugging purposes. It allows the user to see the data that was created by the XSLT transformation.

XmlDataPath: Optional

Expand
Contains the directory location where to write the output that the Import plugin sent to the back end. This is primarily used for debugging purposes. It allows the user to see what data is being sent to the back end server.

XmlPostAlso: Optional

Expand

Contains a 1 or 0 to enable or disable sending requests to the back end. This value is used in conjunction with XmlDataPath.

Note
This must be set to 1 for the Import plugin to properly process requests and send them to the back end. It is set to 0 only for debugging the Import process without sending the request to the back end server.

QueueBatchConfigType: Optional in X Dispatch 21.0 or newer

Expand

Set to the config type from tblQueue_Batch that will denote import data to processes.

How it is configured:

CXT Software deploys the CXT: Save Web Service String Data plugin. This plugin creates a web based endpoint that writes whatever is sent to it to the tblQueue_Batch table. This plugin is configured to specify the config type, which will be used in the XASN file.
In the XINI/XASN, set the QueueBatchConfigType key to the same config type as configured in the previous step.

How it works:

A web service calls the endpoint set up above

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.

_{Possible version compatibility issue. See Changelog below.}

RetryDelay(ms)

Optional

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.

Note
If not managed correctly, it could potentially cause substantial processing delays. Before implementing ensure that you fully understand how the element works with the Attempts and MaxFailed to prevent issues with integration processing times.

_{Possible version compatibility issue. See Changelog below.}

XSLTTranslator

Optional

Contains the file name of the XSLT file to use for translation (e.g. C:\IMPORT\TEST.XSLT). The XSLT file can be used to modify the incoming data before it is processed by the Import plugin.

XSLTDataPath

Optional

Contains the directory location where to write the XSLT translation output data. This is primarily used for debugging purposes. It allows the user to see the data that was created by the XSLT transformation.

XmlDataPath

Optional

Contains the directory location where to write the output that the Import plugin sent to the back end. This is primarily used for debugging purposes. It allows the user to see what data is being sent to the back end server.

XmlPostAlso

Optional

Contains a 1 or 0 to enable or disable sending requests to the back end.

This value is used in conjunction with XmlDataPath.

Note
This must be set to 1 for the Import plugin to properly process requests and send them to the back end. It is set to 0 only for debugging the Import process without sending the request to the back end server.

QueueBatchConfigType

Optional

Set to the config type from tblQueue_Batch that will denote import data to processes.

How it is configured:

CXT Software deploys the CXT: Save Web Service String Data plugin. This plugin creates a web based endpoint that writes whatever is sent to it to the tblQueue_Batch table. This plugin is configured to specify the config type, which will be used in the XASN file.
In the XINI/XASN, set the QueueBatchConfigType key to the same config type as configured in the previous step.

How it works:

A web service calls the endpoint set up above and sends data as part of the body of the request. This data can be XML, JSON, TAB delimited or FIXED length - EXCEL format is NOT supported. The plugin will store the request in tblQueue_Batch

using the specified config type.

The import plugin is run and will scan tblQueue_Batch for any records with the given config type. If found, the data from those records will be written to a file in the folder specified by the DataPath parameter. Once all of the records have been written out, the import plugin will process the files as normal.

Data Items

There are three types of Data Items

using the specified config type.
The import plugin is run and will scan tblQueue_Batch for any records with the given config type. If found, the data from those records will be written to a file in the folder specified by the DataPath parameter. Once all of the records have been written out, the import plugin will process the files as normal.

_{Possible version compatibility issue. See Changelog below.}

DelayImport

Optional

Used to delay the processing of a file by a set number of seconds.

Code Block

title	Example

DelayImport=180  # This is for 3 minutes  60*3 = 180

NameSpacePrefix

Optional

Required in some XML inbound documents or if NameSpaceUri is used.

Code Block

title	Example

NameSpacePrefix =ns2  # This data would be found at the root element in the xml doc

NameSpaceUri

Optional

Required in some XML inbound documents or if NameSpacePrefix is used.

Code Block

title	Example

NameSpaceUri =http://internal.amazon.com/TrailerInfo  # This data would be found at the root element in the xml doc

ReplaceContent

Optional

Used to replace content in the document with the matching value with an empty string.

Code Block

title	Example

ReplaceContent =:TrailerInfo xmlns:“http://www.schema.com”  # This will remove any match for this string to be set to the empty string “”

ReportEmail

Optional

The e-mail address to which X Import will send a report about the import process for the current input file. Multiple email addresses should be comma separated. This works for both On Demand and Routed.

Expand

title	Example

ReportEmail=text@cxtsoftware.com

Data: ReportEmail is not stored with the Order, but is used to create an email to be sent. It could be found tblMailLog, tblMailOutbox, or tblMailOutboxHistoric, depending on the time that has passed since the import and the status of email.

File Failures

The import plugin will move any failing data files to the ERRORS folder.

_{Possible version compatibility issue. See Changelog below.}

Configuration Item

Description

FailureEmailFromAddress

Optional

FailureEmailFromAddress is a parameter for a return email address for failure emails. This parameter and FailureEmailFromName must be set the same as the setting in the email account. For example, if the email account has the email as email@cxtsoftware.com and the name as John Doe, the FailureEmailFromAddress must be "email@cxtsoftware.com" and the FailureEmailFrom Name must be "John Doe".

The best practice is to use the same email address as the one set in the active Mail Manager profile.

Info

FailureEmailToAddress must be set.

The failure emails will be sent if the import fails to pre-process or translate using XSLT the inbound data file. The email will be sent with the data file attached along with the failure message.

FailureEmailFromName

Optional

FailureEmailFromName is a parameter for a return email name for the failure emails. This parameter and FailureEmailFromAddress must be set the same as the setting in the email account. For example, if the email account has the email as email@cxtsoftware.com and the name as John Doe, the FailureEmailFromAddress must be "email@cxtsoftware.com" and the FailureEmailFrom Name must be "John Doe".

The best practice is to use the same email address as the one set in the active Mail Manager profile.

Info

FailureEmailToAddress must be set.

The failure emails will be sent if the import fails to pre-process or translate using XSLT the inbound data file. The email will be sent with the data file attached along with the failure message.

FailureEmailToAddress

Optional

FailureEmailToAddress is a parameter for a valid email address where the failure email should be sent.

Info
The failure emails will be sent if the import fails to pre-process or translate using XSLT the inbound data file. The email will be sent with the data file attached along with the failure message.

Example

Code Block

language	xml
title	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

Data Item Types

There are three types of data items: static, dynamic, and macro.

Static Data Items

Static data items allow you to populate fields with known values. For example, if all of the deliveries sent in on an ASN will be assigned the same order type, origin address, etc. Static data items can be set by prepending the argument with “0,” followed by the static value.

EX: UserID=0,ximport-mckesson

Dynamic Data Items

Dynamic data items allow you to set an item’s value based upon the type of input file.

Data Items (Delimited)

Data Items (Fixed-Width)

Macro Data Items

Macro data items allow you to populate fields with certain pre-defined macros. Currently, the only supported macros are the following:

NOW will return the current timestamp at the time of processing

Code Block

title	Example

UserID=0,ximport-mckesson

Dynamic Data Items

Dynamic data items allow you to set an item’s value based upon the type of input file.

Macro Data Items

Macro data items allow you to populate fields with certain pre-defined macros. Currently, the only supported macros are the following:

NOW

Returns the current timestamp at the time of processing, e.g. “04/20/2008 11:11” AKA "Server Time" This would be the time of the server on which X Import is running.

Time may be added and subtracted in minute increments by appending the appropriate math after the “NOW” route keyword.

“NOW+30” in the example above would be “04/20/2008 11:41”
“NOW-30” in the example above would be “04/20/2008 10:41"

TODAY

Returns the current date at the time of processing with the time set to 12:00 AM, e.g. “04/20/2008

11

00:

11”

00” AKA "

Server

X Dispatch Time"

This would be

This is the time

of the server on which X Import is running. Expand

in X Dispatch via dbo.GETCXTDate().

Time may be added and subtracted in

minute

day (whole or fractional) increments by appending the appropriate math after the

“NOW” route

“TODAY” keyword

. “NOW-30” in the example above would be

“NOW+30” in the example above would be “04/20/2008 11:41”

“TODAY+2” would evaluate to “04/22/2008 00:00”
“TODAY-2” would evaluate to “04/18/2008 00:00”
“TODAY+0.5” would evaluate to “04/20/2008

10:41”

TODAY will return the current date at the time of processing with the time set to 12:00 AM, e.g. “04/20/2008 00:00” AKA "X Dispatch Time" This is the time in X Dispatch via dbo.GETCXTDate().

Expand

Time may be added and subtracted in day (whole or fractional) increments by appending the appropriate math after the “TODAY” keyword

“TODAY+2” would evaluate to “04/22/2008 00:00”
“TODAY-2” would evaluate to “04/18/2008 00:00”
“TODAY+0.5” would evaluate to “04/20/2008 12:00”

CXTNOW will return the current date at the time of processing within cxtAsp.

Expand

This would be useful if the time zone of the system running X Import does not line up with the time zone of X Dispatch. For example, if a customer on Cloud is set for Eastern time but the server running their instance is set to Pacific or Central time.

Info
Use of modifiers for this function like with NOW added in X Dispatch 11.2.6.

Applies to the following XINI fields:

ReadyTimeFrom
ReadyTimeTo
PickupTime
RequestDeliverTime

Applies to the Following XASN Fields:

PostDate
StopTime
StopTimeMin
StopTimeMax

If CXTNOW is used in a field outside of what is outlined above, the field will contain the results of NOW instead.

Info
There was an issue discovered that prevented CXTNOW from being passed to the system for these fields. This issue was resolved in the import plugin version 1.4.5.

Example

Paste code macro
PickupDate= NOW+360 DeliverDate=TODAY+2

Macro data items can also be manipulated to add time offsets. For example, if you receive an ASN for same day delivery and the file comes in at inconsistent times (11 PM one day and 1 AM the next), using the above macros may not be sufficient. For these cases, it is possible to add a time offset and then apply a date transformation.

If you want to accept a same day ASN before 3 PM, but roll everything after 3 PM to the next day, you could do the following:

Paste code macro
PickupDate=NOW&09:01\|DAYFLOOR

The syntax for this type of macro manipulation is in the following form: Item=Macro&[OffsetHours:]OffsetMinutes|Transformation

Where:

Item is a valid Data Item for the configuration file.
Macro must be one of: NOW (see NOTE below) or TODAY.
OffsetHours specifies the number of hours to add to the evaluated macro (required)
OffsetMinutes specifies the number of minutes to add to the evaluated macro (required)
Transformation is one of:
- DAYFLOOR: Set the resulting time to 00:00
- DAYUPPER: Set the resulting time to 00:00 and adds one day
- WEEKDAYFLOOR: Behaves similarly to DAYFLOOR. If the time, after adding the OffsetHours and OffsetMinutes, is on a Saturday or Sunday, it will be pushed to the following Monday and then set the resulting time to 00:00

Note

NOW is a macro that pulls the SERVER time, not the time local to the customer. The server time for Cloud customers is always UTC 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 4 hours to the syntax example:

Paste code macro

title	Example

PickupDate=NOW&13:01|DAYFLOOR

12:00"

CXTNOW

Returns the current date at the time of processing within cxtAsp.

This would be useful if the time zone of the system running X Import does not line up with the time zone of X Dispatch. For example, if a customer on Cloud is set for Eastern time but the server running their instance is set to Pacific or Central time.

ReadyTimeFromApplies to the following XINI fields:

ReadyTimeTo
PickupTime
RequestDeliverTime

Applies to the Following XASN Fields:

PostDate
StopTime
StopTimeMin
StopTimeMax

If CXTNOW is used in a field outside of what is outlined above, the field will contain the results of NOW instead.

Example

Code Block
PickupDate= NOW+360 DeliverDate=TODAY+2

Macro data items can also be manipulated to add time offsets. For example, if you receive an ASN for same day delivery and the file comes in at inconsistent times (11 PM one day and 1 AM the next), using the above macros may not be sufficient. For these cases, it is possible to add a time offset and then apply a date transformation.

If you want to accept a same day ASN before 3 PM, but roll everything after 3 PM to the next day, you could do the following:

Code Block
PickupDate=NOW&09:01\|DAYFLOOR

The syntax for this type of macro manipulation is in the following form: Item=Macro&[OffsetHours:]OffsetMinutes|Transformation

Where:

Item is a valid Data Item for the configuration file.
Macro must be one of: NOW (see NOTE below) or TODAY.
OffsetHours specifies the number of hours to add to the evaluated macro (required)
OffsetMinutes specifies the number of minutes to add to the evaluated macro (required)
Transformation is one of:
- DAYFLOOR: Set the resulting time to 00:00
- DAYUPPER: Set the resulting time to 00:00 and adds one day
- WEEKDAYFLOOR: Behaves similarly to DAYFLOOR. If the time, after adding the OffsetHours and OffsetMinutes, is on a Saturday or Sunday, it will be pushed to the following Monday and then set the resulting time to 00:00

Note

NOW is a macro that pulls the SERVER time, not the time local to the customer. The server time for Cloud customers is always UTC 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 4 hours to the syntax example:

Code Block

title	Example

PickupDate=NOW&13:01|DAYFLOOR

Anchor
changelog
changelog
Changelog

Expand

X Dispatch 21.0

QueueBatchConfigType
File Failures - The import plugin will move any failing data files to the ERRORS folder. Previously any data files that failed to preprocess (via preprocessor or XSLT) would have been left in the inbound folder. This caused the import plugin to retry that data file over and over throwing errors while not processing that data file.
- FailureEmailFromAddress
- FailureEmailFromName
- FailureEmailToAddress

X Dispatch 19.2

Attempts
MaxFailed
RetryDelsy(ms)

X Dispatch 18.1

LocalizedDateTimes

X Dispatch 14.2.4

MaxReimport

X Dispatch 12.1.4

SkipLinesIfBeginsWith available in XINI

X Dispatch 12.1.3

StripBeginningQualifier
StripBeginningQualifier

X Dispatch 12.0.0

SkipLinesIfBeginsWith is available in XASN

X Dispatch 11.2.6

Added use of modifiers for CXTNOW like with NOW

Version 1.4.5

Resolved an issue that prevented CXTNOW from being passed to the system for these fields.

Version 1.4.3

Delimiter - The CSV file can an unlimited number of columns. Prior versions was limited to 201 columns.

Version 1.3.0

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

Version 1.2.0

ConcurrentDataaFiles

Search related import documentation

Live Search

size	large
labels	x-import-doc

Versions Compared

Old Version 19

New Version 20

Key

Comments

General Configuration Items

Data Items

File Failures

Example

Data Item Types

Static Data Items

Dynamic Data Items

Macro Data Items

Dynamic Data Items

Macro Data Items

Example

Example

Anchor
changelog
changelog
Changelog

On This Page:

Related Articles:

Search related import documentation

Page Comparison

Versions Compared

Old Version 19

New Version 20

Key

Comments

General Configuration Items

Data Items

File Failures

Example

Data Item Types

Static Data Items

Dynamic Data Items

Macro Data Items

Dynamic Data Items

Macro Data Items

Example

Example

AnchorchangelogchangelogChangelog

On This Page:

Related Articles:

Search related import documentation

Anchor
changelog
changelog
Changelog