User guide

How to Import into InventoryControl

InventoryControl contains an easy-to-use Import Wizard. This wizard will take

you step by step through the import process. You cannot use the import function

to edit data already in the database. Since importing adds information to the

existing database, make sure you do not import the same file twice. In addition,

make sure the data in your file does not already exist in the database.

From the Main Window,clickAdministration > Import. The wizard will take you

through a series of steps allowing you to select the file to import and the table to

which you want to add the data. (A table is simply the repository for the

information in the database). So, for example, if you are importing locations,

select Location from the Table drop down list.

Next you will specify the field Delimiter used in the file from which you are

importing data. Delimiters are used to separate the data items in a database (the

columns in the database table) when transporting the database to another

application. For example, a comma-separated values file (.csv file) is one in

which each value in the cells of a table row is delimited, or separated, from the

next value by a comma. The beginning of a row is indicated by a new line

character. For .csv files, you should always select Comma as your delimiter.

Any of the characters shown in the Delimiter drop down box can be selected for

.txt files.

Select the table to

which you want to

import.

Select your field

delimiter and check the

preview window to make

sure the data is

formatted correctly.

Change your delimiter, if

necessary.

Figure 20