IntelliTrack Inventory Management - Manual (Page 151)

Chapter 9
Import/Export
125
Warning: DO NOT IMPORT data that contains special characters or
quotes with the exception of dashes, dots, and spaces. Except for dashes,
dots, and spaces, if your data contains special characters or quotes, the
database will become corrupted. For more information, please refer to
“Precautions When Entering Data” on page 42 .
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 file requirements are explained in this sec-
tion.
Import File
Type Options The Access Import/Export file type options are explained in the table
below.
Import File
Requirements You may import existing inventory item or part number data into the
Inventory database. Data contained in the imported file must be in the fol-
lowing order:
• Item#
TABLE 5. 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 (“,”)
Delimited A delimited file (.txt) with each text field enclosed in
double quotation marks and each field separated by
comma only
Fixed Width A very specific and less flexible file; it is for systems
that can only provide fixed width output; each field
must be the same width in every record.
2287.book Page 125 Thursday, July 7, 2011 4:45 PM