IntelliTrack Inventory Management - Manual (Page 153)

Chapter 9
Import/Export
127
Import File
Type
Examples When you import files into IntelliTrack via the standard import function,
make sure that the file consistently follows the selected format. It is a good
idea to test your file format with a small file containing one or two lines
before importing a large amount of data; that way if you have any issues
with the file format, you can identify them and fix them. The sections that
follow discuss the four delimited text file types (comma delimited only,
quote comma quote delimited, semicolon delimited only, tab delimited
only) supported in a standard IntelliTrack import.
Note: IntelliTrack Inventory assumes the order of the fields are ITEM#
(required), QTY, DESC, UNIT COST, CATEGORY, MINIMUM
QTY, MAXIMUM QTY, REORDER QTY, ALT_NO. These fields can
only be imported in this order. If the fields are not in this order, choose
Custom Import and include field headings; Microsoft Access will rear-
range the field order.
Note: Field headings are not required for delimited files. IntelliTrack
Inventory assumes the order of the fields is ITEM#, QTY, DESC, as
defined in the Import Specifications table above. If the fields are not in this
order, or it is difficult to eliminate irrelevant fields, select Custom Import,
include the field headings and Microsoft Access will re-arrange the field
order.
Comma Delimited File Example
For CommaOnly, the delimited file will look something like this:
12345-1343,45,tape dispenser,8.00,Office Supplies,5,20,7,12345-1344
Quote Comma Quote Delimited File Example
For QuoteCommaQuote, the delimited file will look something like this:
"2345-6789","77","Paper Clips","0.50","Office Supplies",
"2","10","3","2345-6788"
Semicolon Delimited File Example
For SemicolonOnly, the delimited file will look something like this:
2287.book Page 127 Thursday, July 7, 2011 4:45 PM