IntelliTrack Check In/Out - Manual (Page 259)

Chapter 11
Import-Export
229
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 Check In-Out 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; MS Access will rearrange the
field order.
Note: Field headings are not required for delimited files. IntelliTrack
Check In-Out 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.
6 MINIMUM
QTY No Currency 8 Minimum
Quantity on
Hand
7 MAXIMUM
QTY No Currency 8 Maximum
Quantity on
Hand
8 REORDER
QTY No Currency 8 Reorder Quan-
tity
9 ALT_NO No Text 25 Alternate Part
Number
TABLE 7. Import-Export Fields (Continued)
Field
Order
Field
Name Required
Data
Type
Field
Size Description
2283.book Page 229 Thursday, July 7, 2011 2:29 PM