CSV Import File Format
The file via which licenses can be imported is a simple CSV file listing all fields and their data that are to be imported. It must contain the comma separated list of field names in the first line and one line per licensed software to be added/updated with the comma separated list of values. The list must not necessarily contain all available values.
To view the CSV sample file
- Go to Application Management > Software License Management.
- Click Edit and select Import License Data. The Import License Data window is displayed.
- Click the Sample Import File with Instructions hyperlink displayed on the Import License Data window.
The CSV sample file is downloaded.
The file shows you via its two tabs the required content of the CSV file and its format as well as an example on how this could look.
- How To
- Data
How To
The How To tab provides you with some general explanations and the list of all fields that exist for licensed software:
Column | Description |
|---|---|
Column Name | This column lists all field names that are used for the licensed software items. You can use these names for your columns or chose your own names with the exception of the the first field name, LicensedApplicationsName , which must always be called that and is mapped to the Name field. If you are using the default names shown here, they will be automatically mapped to their target fields in the import. |
Description | The fields of this column provides some explanation on the respective field content to simplify their mapping. |
Type | These fields show the datatype that is expected in the respective field. |
Expected Values | These fields provide more information about the expected values, such as their expected format (date format) or which possible values are available for a specific field, and so on, where applicable. |
Data
The Data tab provides you with an example of how the csv file might look when opened in MS Excel.