Import Tag Inventory Data into TagNet

RFID Inventory 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 Location data from a external system

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

3.Import Tag Location 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 Inventory Location 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 Tag Location already exists in TagNet when attempting an ADD. Where an OK is shown this indicates the add of the given Tag Inventory 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.