Skip to main content

Importing Into the InventoryControl v7 Database - Knowledgebase / Discontinued Products / InventoryControl / Version 7 - Wasp Helpdesk

Importing Into the InventoryControl v7 Database

Authors list

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
Location Location
Site
adding inventory 
Supplier Supplier Code  
Manufacturer Name  
5 Sales Tax Code    
Customer Customer Number  
Item Item Number
Item Type
adding inventory
Item Location    
9 Item Supplier Supplier Code
Supplier SKU
  
10 Sales Tax Item    
11 Inventory Item Number
Quantity
Site
Location
 
Helpful Unhelpful

15 of 50 people found this page helpful