Import Tag Mapping Data into TagNet

RFID Tag Mapping data from an external Inventory or Asset management system can be imported into TagNet’s Object repository. The file format is a simple XLS or CSV flat file that is populated according to mapping standards provided below and an example can be found in the following TagNet Server directory or downloaded here. This could be a 'one time' import or done on a recurring basis.

C:\TagNet\rfid\import\TagNet_Asset_Data_Import_Example.xls

The first two (2) rows of the sheet define column names as well as detailed database information displayed in the comments as you mouse over a given column heading as shown below

This import facility supports the following scenarios:

1.Import Tag Mapping data from a external system

2.Import Tag Mapping data from a 3rd party Labelware package

3.Import Tag Mapping data from one TagNet system to another

When importing new data, use the ADD Action code (see column 1), when updating existing data use the UPD action code. When deleting data using the DLT action code. An audit report is generated after each import attempt indicating detailed success and/or error conditions. As with any implementation, you should consult your TagNet Project Manager prior to using this feature.

There are a number prerequisite steps than need to be performed as listed:

1. Creating a Data Import Binding profile

Ensure that the Data Import Binding is setup under Event Bindings

2. Executing the TagNet Import Job

Take the Import the TagNet Asset Mapping menu option that imports the data, validates and produces an audit file output. This method to import is typically done for infrequent imports or for first time initial loads to get experience. Once this becomes production ready use the schedule task feature below.

3. Check the results of Import log to verify

Check the Import audit file (CSV) in folder path D:\TagNet\rfid\import\Archive as shown below

Open the Import audit file (CSV) and review the log, an ERROR will be logged if the TagID already exists in TagNet when attempting an ADD. Where an OK is shown this indicates the add of the given TagID was successful. Make whatever corrections to the source Import XLS and resubmit the import.

4. Making the TagNet Import Job a Scheduled Task

Navigate to the Scheduled Task via below and follow the steps in the Scheduled Tasks topic that will import your data on a scheduled basis.