IntelliTrack Check In/Out - Manual (Page 215)

Chapter 10
Import-Export
187
Additional Importing Information
To use the standard IntelliTrack import feature for importing item data, you
must use a delimited or fixed width file, which must include a specific for-
mat. The file type options and the file requirements are explained in this
section.
Import File
Type Options
The Access Import/Export file type options are explained in the table
below.
Note: If the descriptions have commas, use the QuoteCommaQuote
delimited import method.
Import File
Requirements Item is a required field for Import to work. Description should always be
included in the imported file. Quantity and other fields listed in
Table 8,
“Import-Export Fields,” on page 188 are optional. The fields should meet
the following requirements:
TABLE 7. Import File Type Options
File Type Description
Comma Only (,)
Delimited Expects a delimited file (.txt) with each field sepa-
rated (delimited) by comma only.
Tab Delimited Expects a delimited file (.txt) with each field sepa-
rated by tabs only.
Semicolon Only (;)
Delimited Expects a delimited file (.txt) with each field sepa-
rated by semicolons only.
QuoteComma-
Quote (“,”) Delim-
ited A delimited file (.txt) with each text field enclosed in
double quotation marks and each field separated
by comma only.
FixedWidth A very specific and less flexible file; it is for sys-
tems that can only provide fixed width output; each
field must be the same width in every record.
2283.book Page 187 Thursday, July 9, 2009 11:26 AM