Licenses CSV files

Understand the correct structure for a CSV file that contains license data.

Table 1. Basic structure for a CSV file to import licenses
Attribute 1	Attribute 2	Attribute 3	Attribute 4
`SRM_SaaS_ES`	`TLSMLICES`	Use `AddChange` by default. `Add` and `Change` are also supported.	`EN`
License attribute 1	License attribute 2	License attribute 3	License attribute 4...
Data for license attribute 1	Data for license attribute 2	Data for license attribute 3	Data for license attribute 4...

If you use a spreadsheet program such as Microsoft Excel to create your CSV file, the program adds a comma for each blank cell. To avoid errors when importing the data, use a text editor to delete the extra commas in the first row of the CSV file.

Required attributes

Table 2. Required attributes
Attribute	Description
LICENSE_CAPACITY	Capacity
CAPACITYUNIT	Capacity Unit
COMPANY	Vendor
CREATEDATE	Create Date
ISSUBCAP	Is Sub-Capacity
LICENSENUM	License
LICSCOPE	Scope
LICTERM	License Term
LICTYPE	Type
ORGID	Organization ID
PLATFORMBASE	Platform
STARTDATE	Start Date
STATUS	Status
TLOAMLICSWID	Unique Id
KEYTYPE	Key Type
KEYVALUE	Key Value
TARGETOBJECT	Target

Optional attributes

Table 3. Optional attributes
Attribute	Description
ALLOCATEDCAPACITY	Allocated Capacity
AVAILABLECAPACITY	Available Capacity
CHANGEDATE	Change Date
COMPPERIOD	License Charge Period
COREMULTIGROUPID	Core Multiplier Group ID
COST	License Cost
LICENSE_DESCRIPTION	Description
LICENSE_GLACCOUNT	GL Account
LICENSENAME	License Name
MTMID	Provider Name
RESPPARTY	Responsible Party
SERIALNUMBER	Serial Number
STATUSDATE	Status Date
TERMINATEDATE	Terminate Date
SWMANUFACTURER	Software manufacturer
SWNAME	Software name
SWRELEASE	Software release
SWVERSION	Software version
ADMIN	Administrator
EXPIRATIONDATE	Expiration Date
INSTALLER	Installer
VENDORCONTACT	Vendor Contact
ASSETSERIALNUM	Asset serial number
ALLOC_CAPACITY	Capacity
ALLOC_GLACCOUNT	GL Account
LOCATION	Location
PERSONDISPLAYNAME	Person display name
SITEID	Site
USERNAME	User Name