Manual

INTELLITRACK CHECK IN-OUT V8.1
User Manual
228
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
Tab le 7,
“Import-Export Fields,” on page 228 are optional. The fields should meet
the following requirements:
TABLE 6. 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.
TABLE 7. Import-Export Fields
Field
Order
Field
Name Required
Data
Type
Field
Size Description
1 ITEM# Yes Text 25 Item Number
2 QTY No Currency 8 Qty On Hand
(total all sites)
3 DESC No Text 32 Description
4UNIT
COST
No Currency 8 Cost Per Unit
5CATE-
GORY
No Text 15 Category
2283.book Page 228 Thursday, July 7, 2011 2:29 PM