Preparing files for import

Edit online

Before you import a file into Maximo IT, review the file that you plan to import and check that the file format is correct and that all the required information is present.

When you import data, some fields are required in order to create license records. The fields listed in the following TLOAMLICENSE section are the required fields for creating license records. When you configure your integration, you can also include other fields into which you want to import data.

In the TLOAMLICENSE section, provide values for the following fields:

Organization (ORGID)
Vendor (COMPANY )
Scope (LICSCOPE )
License Term (LICTERM )
Type (LICTYPE )
Platform (PLATFORMBASE)
Capacity (CAPACITY)
Capacity Unit (CAPACITYUNIT)

In the TLOAMLICENSE section, you can also provide a value for the Source field, which specifies the source of the license data that was imported. This field is optional.

If you want to import allocation data, in the TLOAMLICINTDIST section, provide a value for TARGETOBJECT and its corresponding field. For example, use the following values for TARGETOBJECT:

"GLACCOUNT" – if the allocation is to a GL account
"USER" – if the allocation is to a user
"PARTITION" – if the allocation is to a partition
"ASSET" – if the allocation is to an asset
"LOCATION" – if the allocation is to a location

Use these values or any synonym domains that have been added to your installation.

Table 1 describes some of the values required, depending on the value for the TARGETOBJECT field.

Table 1. Required target object values for allocations
If the TARGETOBJECT is...	the following value is required.
GLACCOUNT	GLACCOUNT
USER	PERSONDISPLAYNAME that matches a record in the PERSON table
PARTITION or ASSET	ASSETSERIALNUM that matches a record in the ASSET table
LOCATION	LOCATION

If you want to create license cost records, in the TLOAMLICTRANS section, provide values for the following field:

Transaction Date (TRANSDATE)

If you want to create related software records, in the TLOAMLICSW section, provide values for the following fields:

Software Name (SWNAME)
Software Release (SWRELEASE)
Software Manufacturer (SWMANUFACTURER)
Software Version (SWVERSION)

You must have enough data to retrieve a unique TLOAMSOFTWARE record.

If you want to create a software key, in the TLOAMLICKEY section, provide the following values for TLOAMLICSW:

KEYTYPE
KEYVALUE

Example

An example of an XML import file follows.

<?xml version="1.0" encoding="utf-8" ?> 
<SyncMXLICENSE xmlns="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" creationDateTime="2010-01-14T15:55:09-06:00" transLanguage="EN" baseLanguage="EN" messageID="1263505968149603880" maximoVersion="7 1 20091202-1105 V7116-173" event="0">
<MXLICENSESet>
<TLOAMLICENSE>
  <COMPANY>UPS-1</COMPANY> 
  <LICSCOPE>COMPUTER</LICSCOPE> 
  <LICTERM>EXECUTED</LICTERM> 
  <LICTYPE>ICA</LICTYPE> 
  <PLATFORMBASE>MAINFRAME</PLATFORMBASE> 
  <ORGID>EAGLENA</ORGID>
  <CAPACITY>50</CAPACITY>
  <CAPACITYUNIT>INSTINST</CAPACITYUNIT>
  <SOURCE>PPA-Passport Advantage<SOURCE>
  
  <TLOAMLICINTDIST>
  	<TARGETOBJECT>LOCATION</TARGETOBJECT>
  	<LOCATION>TUMBLE</LOCATION>
  </TLOAMLICINTDIST>
  
  <TLOAMLICINTDIST>
    	<TARGETOBJECT>GLACCOUNT</TARGETOBJECT>
    	<GLACCOUNT>6110-400-000</GLACCOUNT>
  </TLOAMLICINTDIST>
  
  <TLOAMLICINTDIST>
    	<TARGETOBJECT>ASSET</TARGETOBJECT>
    	<ASSETSERIALNUM>A6387683888</ASSETSERIALNUM>
  </TLOAMLICINTDIST>
  
  <TLOAMLICINTDIST>
    	<TARGETOBJECT>USER</TARGETOBJECT>
    	<PERSONDISPLAYNAME>Jenny Baxter</PERSONDISPLAYNAME>
  </TLOAMLICINTDIST>
  
  <TLOAMLICTRANS>
  	<TRANSDATE>2010-01-04T15:18:21-06:00</TRANSDATE>
  </TLOAMLICTRANS>

  <TLOAMLICSW>
  	<SWMANUFACTURER>Microsoft Corporation</SWMANUFACTURER>
  	<SWNAME>3D Pinball 5</SWNAME>
  	<SWRELEASE></SWRELEASE>
  	<SWVERSION>5.1.2600.0</SWVERSION>
  	
  	<TLOAMLICKEY>
  		<KEYTYPE>TEMPORARY</KEYTYPE>
  		<KEYVALUE>JUHYG7865-KJYKKJH-765HYUJ</KEYVALUE>
  	</TLOAMLICKEY>
  
  </TLOAMLICSW>  


</TLOAMLICENSE>
  
  </MXLICENSESet>
  </SyncMXLICENSE>