Wasp Barcode Inventory Control - Manual (Page 284)

InventoryControl Printable Help
16.4 Import Specifics
This topic lists all Field Names, Data Types and Sizes for the fields that can be imported.
The import wizard contained in this software can automatically map the columns in your import files to the
correct column in the database. To do this, however, the column header must match one that the wizard
is looking for and the data type must be correct. Below is the header and data type the import wizard is
expecting. Modify your .csv or .txt file with the correct column header to simply the import process. The
order in which your columns are arranged in your file does not matter. You can also find a .csv file with
the header and one row of sample data on the installation cd that came with this product.
The imported file formats discussed in this topic are:
Customer
Inventory
Item
Location
Manufacturer
Supplier
Data Type Definitions are listed after the Table Properties.
16.4.1 Customer Import Format:
Column Header Data Type Size (Precision,
Scale)
Cell No varchar 20
Company Name varchar 50
Custom Date 1 datetime 8
Custom Date 2 datetime 8
Custom Date 3 datetime 8
Custom Date 4 datetime 8
Custom Date 5 datetime 8
Custom Number 1 decimal 9(15,4)
Custom Number 2 decimal 9(15,4)
Custom Number 3 decimal 9(15,4)
Custom Number 4 decimal 9(15,4)
Custom Number 5 decimal 9(15,4)
Custom Text 1 varchar 100
Custom Text 2 varchar 100
Custom Text 3 varchar 100
269