File format for IT asset disposal import files

The file that you use to import IT asset disposal data must use the format required by the integration framework.

The IT asset disposal integration is designed to import a flat file, such as a comma separated value (CSV) file. The file has a header row that specifies the external system, enterprise service, action, and language to use in the import. The second row specifies the attributes to be imported. The following rows contain the data to import.

Example

The following example illustrates a data file in comma separated values (CSV) format.

Figure 1. Data file in CSV format

TAMITEXTSYS,ITASSETDISPOSALInterface,Change,EN

ASSETNUM,SITEID,STATUS,TLOAMDISPCHARGE,TLOAMDISPDATE,TLOAMDISPRECIPIENT,TLOAMDISPREMARK,
TLOAMDISPREQ,TLOAMDISPTYPE,TLOAMDISPVALUE

1001,BEDFORD,DECOMMISSIONED,90,2009-12-21T00:00:00-04:00,,Not found in physical inventory,SR00184,Lost,10
1002,BEDFORD,DECOMMISSIONED,0,2009-12-21T00:00:00-04:00,Joe Wilson,Auctioned 10/3/2009,,Take Home,110

File header

Line one of the file specifies the file header. Table 1 describes the elements of the file header.

Table 1. File header for asset disposal import files
Header reference	Value	Comment
External system	TAMITEXTSYS	Name of the external system used for IT asset disposal integration.
Enterprise service name	ITASSETDISPOSALInterface	Name of the enterprise service used for IT asset disposal integration.
Action	Change	Use the Change action to ensure that errors are generated if assets to be disposed of do not already exist. This parameter is case-sensitive.
Language	EN	Use the appropriate language code for your system and entries.

Data attributes

Line two of the file specifies the attributes for the data that you want to import. Table 2 describes the asset disposal attributes available for import.

Table 2. Asset disposal data attributes to import
Attribute	Field label	Values permitted	Comment
ASSETNUM	Asset Number	UPPER(12)	Asset number. Make sure that leading zeroes are preserved when editing asset numbers in spreadsheet programs.
SITEID	Site ID	UPPER(8)	Site identifier
STATUS	Asset Status	NOT READY OPERATING PENDING DISPOSAL DECOMMISSIONED DISPOSED	Status of the asset. In the Disposed and Decommissioned statuses the asset is no longer available for service and cannot be selected for work orders, etc. These values should be entered as they appear in the LOCASSETSTATUS synonym domain. The values are case-sensitive.
TLOAMDISPCHARGE	Charge	AMOUNT	Indicates any charge or fee required to dispose of the asset at end of life.
TLOAMDISPDATE	Date Disposed	DATE	The date that an IT asset was disposed of or reached end of life. This date should be provided only when moving to Decommissioned or Disposed status.
TLOAMDISPRECIPIENT	Recipient	UPPER(30)	Indicates the person or organization that took possession of the asset at the end of life. This is free-form text, which can be a name or person ID.
TLOAMDISPREMARK	Disposal Remarks	ALN(80)	Remarks or comments about the disposal of the IT asset.
TLOAMDISPREQ	Disposal Request ID	ALN(32)	The disposal request identifier that was used during the end of life process for IT asset disposal. This attribute can be used to identify the approved request that initiates the disposal of the IT assets. There is no validation against the Maximo® database service request object because some customers might use external request fulfillment systems for disposal.
TLOAMDISPTYPE	Type of Disposal	Destroyed Donated Lost Retired Returned Sold Stolen Take Home	Specifies how the IT asset was disposed of or decommissioned. When using a case-sensitive database, these values must be entered exactly as shown.
TLOAMDISPVALUE	Price/Value	AMOUNT	Indicates any cash value received for the asset at end of life. This is different from Net Book Value, which should be calculated from the fixed asset register.