Wasp Barcode Inventory Control - Manual (Page 275)

InventoryControl Printable Help
0 1
These values are case-insensitive, but they are the only values allowed. Anything else will be
rejected by Import. The default value is False.
The Map To fields, to which data columns containing these True/False values can be mapped, are
named as follows in the Map To drop list:
 Date Code (Track by?)
 Lot (Track by?)
 Pallet (Track by?)
 Serial Number (Track by?)
 Customer (Required ?)
 PO (Required ?)
 Supplier (Required ?)
If, for example, you wanted every item being imported to be tracked by Serial Number, you could create
a new column in your source data that contains the word "yes" in every cell of that column. If you chose
to name this column TrackSer in your source data, you would then map from the TrackSer column to the
Serial Number (Track by?) field.
You could just as easily edit this TrackSer column to turn on Serial Number tracking for some items and
not others, by specifying values of "yes" or "no", as necessary. In either case, when you import the items,
mapping your TrackSer column to the Serial Number (Track by?) field will correctly set the Tracked By
Serial Number option for each item being imported. This negates the need to manually edit each
imported item's Item To Be Tracked By Serial Number option after importing the items.
True/False, T/F, Yes/No or 0/1 columns can be added to your source data for any or all of the seven Map
To fields shown above, so that the Tracked By and Required options are set for each item at the time of
import.
Each record added to an
Auto Generated Number field takes the maximum number present in its
column and increments this value by 1. For an import, if the Employee table already has an ID field value
that is equal to 100 and the Import Wizard recognized that your import file contains a value in a mapped
column that is equal to or less than 100, it will present you with a Default Value of the first import record.
All subsequent imported records will increment this value by 1. If this condition does not exist, the import
will proceed with the values included in the import delimited text file.
7. Click Finish when you are done mapping all the desired fields to the table. A confirmation screen
will appear that the data has been imported. You can verify the import by going to the List screen
(Main Screen > Lists) and viewing the list for that type of information. For example, if you just
imported Locations, view the Locations List to verify the new information is there.
260