


The source of the pivot table should be the table that was created on the If that occurs convert the cells to text. If you have access to your license information on the Volume License Service Center (VLSC) portal, this information may be obtained by cutting and pasting the first 5 columns from the License Summary table.Įxcel may import the License Version column as numbers.

Worksheet, enter software license information as required. Worksheet, enter all software license data field names.Ĥ. Open Microsoft Office Excel and create a new spreadsheet. To Create a Microsoft License Import File Using Microsoft Office Excelġ. If you have a lot of data you may put the raw data on one worksheet and use the excel pivot tools to generate the pivot table on a different worksheet. Attached to this post is a small manual example of what the table should look like. The expected format of the rows is a pivot table. We have received a number of requests from customers who would like to create their own Microsoft License file for import, similar to the method used for the non-Microsoft License Import File.ĭisclaimer: While it is possible to produce the xml file manually, you should keep in mind that this was not the original intent or design of the feature so the parsing of the xml file may seem surprisingly picky about things that seem harmless.įor Microsoft License import, the Asset Intelligence License Import Wizard requires an xml file with the following columns in this order and with the specified data types. The path and file name of an existing deployable package zip file that the license files should be added to.First published on CLOUDBLOGS on Dec 16, 2009 For more information, see File matching patterns reference.įilename and path of the deployable package to update Alternatively, they can be downloaded or generated in an earlier step of the pipeline. To make the license files available on the build agent, you can add them to source control. Search pattern for license files to add to the packageĪ list of license files on the build agent, or a search pattern for files on the build agent. The following table describes the options that are available for this task.

To add the task to your build for the YML or Classic pipeline, search the task list for Add Licenses to Deployable Package. For more information about how to install an extension for an organization, see Install extensions. Before you can add these steps to a pipeline, the Dynamics 365 finance and operations Tools extension for Azure DevOps must be enabled and installed in the Azure DevOps account.
