Licenses CSV files
Understand the correct structure for a CSV file that contains license data.
| 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
| 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
| 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 |