Use the file "ICv7-importing-into-the-database.pdf" as a guide for importing into the InventoryControl v7 database.
https://dl.waspbarcode.com/kb/ic/v7/ICv7-importing-into-the-database.pdf
Sample import files are located in C:\Program Files (x86)\Wasp Technologies\InventoryControl\Import Samples on the client machines after installation. If needed, this download has unaltered import sample files:
https://dl.waspbarcode.com/kb/ic/v7/ICv7-import-samples.zip
Importing tips
- While learning the process, it is common for the import to not work right on the first few tries, so it is recommended that you make a database backup before attempting each import step, so in case of problems, you can restore back to a good dataset to try again.
- Importing is a multistep process; some later steps rely on certain prerequisite data imported/entered in earlier steps (see table below).
- Each import step must be done with its own CSV file; the process will not work using a single master CSV file.
- It isn't strictly necessary to perform an import at each step; alternately you can manually enter data for one or more steps (such as when there are only a few entries to be made).
- When you do perform an import step, the prerequisite field values must already be in the database; if not, you'll receive errors. For example, if you start with a later import step like Inventory, the prerequisite Item numbers are not in the database, so you'll receive the error "invalid item number".
- Numeric fields cannot import commas as thousands separators, or currency symbols, including (but not limited to) these examples: $, ¢ , ¥, £, §, or ¤
- Commas are permissible in text fields only when residing within a pair of double quotes, which will cause them to be treated as normal text, not as field delimiters.
-
When importing inventory, specified quantities are always added to the existing quantities (i.e., they don't replace the existing values).
Import
Order |
Table | File Requires Fields | Required for Function |
1 | Site | Site | adding inventory |
2 | Location | Location
Site |
adding inventory |
3 | Supplier | Supplier Code | |
4 | Manufacturer | Name | |
5 | Sales Tax Code | ||
6 | Customer | Customer Number | |
7 | Item | Item Number
Item Type |
adding inventory |
8 | Item Location | ||
9 | Item Supplier | Supplier Code
Supplier SKU |
|
10 | Sales Tax Item | ||
11 | Inventory | Item Number
Quantity Site Location |