Importing inventory data, Additional importing information, Importing inventory data” on – IntelliTrack Check In/Out User Manual

Page 257

Advertising

Chapter 11

Import-Export

227

Importing Inventory Data

Data import capabilities in IntelliTrack Check In-Out are affected by
whether the user is running the full version of Microsoft Access or the
runtime version of Microsoft Access.

•

The runtime version of Access contains limited import capabilities.
Item definitions can be imported. Site, location, and quantity informa-
tion must be manually assigned. For more information about assigning
this information, please refer to the steps found in

“Edit Existing/Incom-

plete Item Data” on page 161

•

With a full version of Microsoft Access and familiarity with its import-
ing functions, the user can import a complete, existing inventory data-
base from a wide variety of sources, including spreadsheets and
databases.

Only the runtime Access Import using Import/Append is covered in this
section.

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.

•

Import File Type Options: You must use a supported file type for data
import; please refer to

“Import File Type Options” on page 228

•

Import File Requirements: You must include specific fields in a spe-
cific order in the data import file; please refer to

“Import File Require-

ments” on page 228

;

“Import File Type Examples” on page 229

, and

“Import File Structure Integrity” on page 230

for details.