WebSphere brand IBM WebSphere Sensor Events, Version 6.2

Configuration file for importing assets

Use this topic as a reference when creating a configuration file for importing assets.

These are properties that can be used when creating the import asset configuration file. All properties should be listed, including optional properties, but you can leave properties with empty values when they are not required.

Table 1. Import configuration properties
Property Value
itemType This is the asset type name. It must match the item type selected on the screen.
ignoredLines The number of lines to be ignored before parsing begins.
maxErrors Number of errors the parsing should accumulate before reporting these to display. All errors will be reported by end of the process.
columnByName Boolean value (true or false).

If set to false, then no header column is required and ignoredLines can be set to 0, assuming you do not choose to add a header column anyway, such as for clarification in the example CSV file.

If the value is set to true, then you must have a header column, and ignoredLines should be set to 1 so that the header column is ignored.

parentItem This is an optional value.

This is the column number where the primary key identifier for the parent item is located in the CSV file. If no value is given, no parent item will be associated.

This property should match the parent item type selected in the Asset Inventory Management Services for WebSphere® Sensor Events console.

Note: All position values (column numbers) start from zero.
tagId This is an optional value.

This is the column number where tag IDs are located. Each item may have more than one tag mapped. Use a comma to separate the position of each tag ID.

If you do not using the tagId column as part of the CSV file, then tag IDs will automatically be generated based on the EPC configuration of the asset type. This will occur for every asset as part of the import process.

zoneId This is an optional value.

The CSV file column name containing the zone ID to which the asset will be assigned.

Either use the zoneID column in the CSV file or use the Zone Name field in the server console. If you use the zoneID column, then you must specify a zone ID for each asset within the CSV file. You cannot leave the zoneID column blank in the CSV file and have the one selected in the console applied.

itemDescription This is an optional value.

This is the column number where the item description is located. If no value is given, no description is loaded.

columnCounts This is the number of columns mapped to item properties. You may not wish to import all columns from the CSV file.
com.ibm.rfid.import.mapping.n, where n is an integer beginning at 1 A value pair x,y where the left hand side (x) represents either the column position in the CSV file (if the columnByName value is false) or the column name in the CSV file (if the columnByName value is true). The right hand side (y) represents the actual property name for the configured asset type as setup in the Asset Inventory Management Services for WebSphere Sensor Events database. See the following example configuration file.

Example configuration file

The following is an example of a configuration file for the asset type, Computer.

itemType=Computer 
ignoredLines=1 
maxErrors=1 

columnByName=false 

parentItem= 
tagId=5 
zoneId=4 
itemDescription=3 

columnCounts=3 

com.ibm.rfid.import.mapping.1=0,ID 
com.ibm.rfid.import.mapping.2=1,MACHINE TYPE 
com.ibm.rfid.import.mapping.3=2,ASSET SERIAL

This is an example of the corresponding CSV file.

PrimaryIdentifier, MachineType, AssetSerial, Description, ZoneId, TagId 
2007-L3D7072,2007,L3D7072,THINKPAD T60P,21,3428499602FB00000000032A 
6223-KQDKW5G,6223,KQDKW5G,DESKTOP COMPUTER,21,3428499602FB00000000032B 
7977-KQCGAVV,7977,KQCGAVV,IntelliStation Z Pro,21,3428499602FB00000000032C

Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2009. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.