Skip to main content
Matrix42 Self-Service Help Center

Standard Template for License Import

This article applies to Software Asset Management 9.0 Update 1 and earlier

Introduction

In License Management there is the option to import purchased licenses using a standard template using the Import action. The template can be downloaded on the second page of the import wizard.

License Import Wizard p2 - UUX.jpg

Store the file locally and open it with Microsoft Excel.

Template Columns

The template has following columns:

Template column
Target Attribute
Data Type
Key
Comment
Order Number
SPSAssetClassOrder.OrderNumber
alphanumeric
Yes
Mandatory, key for import
Order Position
SPSAssetClassOrder.OrderPosition
alphanumeric
Yes
Mandatory, key for import
Total Amount
SPSAssetClassLicense.PurchasedCount*
decimal value
 
Mandatory (means: amount of purchased items)
SKU
SPSAssetClassOrder.ManufacturerPartNumber
alphanumeric
 
Recommended, if recognition by LIS is desired
See footnote of this article for details.
Supplier
SPSAssetClassBase.Supplier.ShortName
relation to supplier
 
Recommended,  if validation should be based on supplier + order/invoice number instead of assigned contract
Description
SPSAssetClassBase.Description
alphanumeric
 
Highly Recommended
Language
SPSAssetClassLicense.Language.Value
relation to language pickup
 
 
License Type
SPSAssetClassLicense.Type.Value
relation to license type pickup
 
Recommended
Usage Rights
SPSAssetClassLicense.PurchasedCount*
numeric
 
Mandatory (means: lot size or purchased item)
Unlimited
SPSAssetClassLicense.PurchasedCountInfinite
1 = yes, 0 = no
 
Mandatory
Downgrades
SPSAssetClassLicense.AllowDowngrades
1 = yes, 0 = no
 
Recommended
License Model
SPSAssetClassLicense.LicenseModel.Name
relation to license model
 
Recommended
Order Date
SPSAssetClassOrder.OrderDate
datetime
 
Recommended,  if validation should be based on supplier + order/invoice number instead of assigned contract
Invoice Number
SPSAssetClassOrder.InvoiceNumber
alphanumeric
 
Recommended,  if validation should be based on supplier + order/invoice number instead of assigned contract
Comments
SPSAssetClassOrder.Description
alphanumeric
 
 
Valid From
SPSCommonClassBase.ValidFrom
datetime
 
Recommended, if License Type  requires this information for successful validation
Valid Until
SPSCommonClassBase.ValidUntil
datetime
 
Recommended, if License Type  requires this information for successful validation
Volume Points
SPSAssetClassLicense.PointSpent
numeric
 
 
Contract
SPSAssetClassLicense.LicenseContract.ContractNumber
relation to license agreement
 
Recommended, if validation should be based on assigned contract instead of supplier + order/invoice number
Ownership OrgUnit
SPSCommonClassBase.OU.IDName
relation to org. unit
 
Recommended, if empty "Global" is assumed
Ownership Cost Center
SPSCommonClassBase.CostCenter.IDNumber
relation to cost center
 
Recommended, if empty "Global" is assumed
Ownership Location
SPSCommonClassBase.Location.IDName
relation to location
 
Recommended, if empty "Global" is assumed
License Pool OrgUnit
SPSCommonClassBase.OU.IDName
relation to org. unit
 
Mandatory
License Pool Cost Center
SPSCommonClassBase.CostCenter.IDNumber
relation to cost center
 
Mandatory
License Pool Location
SPSCommonClassBase.Location.IDName
relation to location
 
Mandatory
Maintenance End
SPSAssetClassLicenseMaintenance.ValidUntil
datetime
 
Recommended, if License Type  requires this information for successful validation

The import will multiply "Total Amount" with "Usage Rights" to calculate the amount of purchased usage rights.  

If you import licenses with SKU the corresponding Software Product is not assigned during the import. This is done in "License Management - Data Batch Processing".  If you do license imports regularly, you may consider creating an activation of the engine "License Manager Imported Licenses Processor" which then can run in a higher frequency. This engine tries to find the SKU stored with imported licenses in the License Intelligence Service data and assign the corresponding Software Product.

  • Was this article helpful?