Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

For delimited files, data is referenced by the 1-based field index position.

Given the data:

CXT Software,3030 N. Central Ave.,Ste 708,Phoenix,AZ,85012,...

You would configure X Import as follows: 

Paste code macro
OriginName=1
OriginAddress=2
OriginSuite=3
OriginCity=4
OriginState=5
OriginZip=6

If the field value may contain the same character as your delimiter, the value must be surrounded with the Qualifier character (double-quote by default).

Fields may also be concatenated by separating the fields with a comma. Static text can be included by surrounding it with double-quotes.

Given the data:

1038,9784,CXT Software,...

X Import can be setup to include the Route and Stop IDs in the order's

Reference1 field: 

Paste code macro
Reference1="RouteID: ",1,", StopID: ",2
Starting in X Dispatch 11.2.21, you

You can concatenate a comma into a concatenated string.  This can be done using “,” or {COMMA} as the element to concatenate.

Given the date:

FirstName,LastName

Setting Referene1=2,”,”,1 or 2,{COMMA},1 will result in: “LastName, Firstname” in the refernece reference 1 field

On This Page:

Table of ContentsmaxLevel3

Related Articles:

Child pages (Children Display)
pageX Import

Search related import documentation

Live Search
sizelarge
labelsx-import-doc