Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • InventoryControl
  • Version 7
  • Importing Into the InventoryControl v7 Database
Subscribe Download PDF

Importing Into the InventoryControl v7 Database

Sicaro Burnett
2021-06-22
in Version 7

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
 

Rate the quality of this page

This page was helpful :) :( This page was not helpful

15 of 50 people found this page helpful

Related Pages

  • InventoryControl: How do I import the information for the Manage Suppliers tab?
  • InventoryControl - How to: When Importing Item records, what data values must be mapped to which fields to indicate that one or more specific Items should be Tracked By Lot and/or Pallet?
  • What happens if a required field is not supplied when Importing data into a table?
  • InventoryControl - What happens when one attempts to Import records with negative quantities into the Inventory table?

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro