IntelliTrack Check In/Out - Manual (Page 261)

Chapter 11
Import-Export
231
AB3135332423,,,,TA-987,2
3. Place a comma separator in the fields where there is no data to maintain
the integrity of the import file data structure.
Importing Data to Setup your System
Import existing item information into the application with a delimited text
file.
Note: The imported file must comply with the field order and specifica-
tions defined in
“Import File Type Options” on page 228 and Table 7,
“Import-Export Fields,” on page 228 .
If you are setting up your system and are planning to import the entire set
of items, follow these steps. If you have already set up your system and
need to import additional information, which will be integrated with your
existing data, please refer to
“Importing Additional Data into the System” on
page 234 .
Importing
Item Data You can import existing item data into a Check In-Out database. Enter the
site, location and quantity data manually.
Important: The following section covers only importing existing inventory
data into a clean (purged) Check In-Out database. For information on
general importing and exporting, refer to
“Additional Importing Information”
on page 227 . Furthermore, only Runtime Access Import using Import/
Append is covered in this section.
Note: Data must be in the following order: Item#, Qty, Description,
Unit Cost, Category, Minimum Qty, Maximum Qty, Reorder Qty, and
Alt_No. If the Item number already exists, it will be updated.
Note: The imported file must comply with the field order and specifica-
tions defined in
Table 7, “Import-Export Fields,” on page 228 . Refer to
2283.book Page 231 Thursday, July 7, 2011 2:29 PM