Use the file "ICv7-importing-into-the-database.pdf" as a guide for importing into the InventoryControl v7 database.
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:
- 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).
|Table||File Requires Fields||Required for Function|
|5||Sales Tax Code|
|9||Item Supplier||Supplier Code
|10||Sales Tax Item|