Exporting Tag Data

You will export tag information to a file that can be download to a bar code scanner for use there. This can be useful for performing a cycle count when all you want to know is the Tag (where its located), the part number and whether the part is serialized or not.

The format of the Data

All fields will be one of two types:

Text - A textual value. May contain any character, but if it contains a line break, comma or double quote, it must be wrapped with double quotes on both ends. If a field is wrapped, all text must be inside the double quotes. Double quotes in the text value must be doubled to import properly
Numeric - A decimal number greater than or equal to zero with up to four digits after the decimal point. The number must not have thousands' separators in it - 1234.56 is a valid number, while 1,234.56 is not.

CSV Fields Exported

Column Name	Type	Description
Tag	Numeric	The tag number of where inventory is located.
PartNum	Text	The part number to be received.
HasSerialNum	Text	If the part is serialized, then this value will be a "Y". Otherwise it will be "N".

Creating a CSV file

In order to import your data, you must first export it to a comma separated values (CSV) text file. All major spreadsheet programs can export data in this format. If you do not know how to export your data to a CSV file, please refer to the documentation of your spreadsheet program.

When exporting to CSV format, make sure to verify the following:

The data is formatted properly (see the first section)
The file must contain column names in the first row, using the column names in the table above.
Each bill of material item to be added or updated is on its own line
Commas are used to separate fields
Text values are surrounded by double quotes