The 5.5.66 Data Platform patch release includes an Excel extractor that can extract data from a predefined input spreadsheet and convert it into a BDNA consumable zip file.
IMPORTANT: If the running platform is missing Microsoft Office, the 64-bit Microsoft Access Database Engine driver must be installed on the machine before running this extractor. You can download the driver here: Microsoft Access Database Engine 2016 Redistributable.
Entering your data into Input_Spreadsheet.xlsx
Download the Excel Extractor ZIP file (ExcelExtractor-Document.zip) attached to this article, and extract the Excel spreadsheet included in that ZIP file. Then, use the spreadsheet (Input_Spreadsheet.xlsx) to add your raw data dollowing these rules:
- Do not change the sheet and column names. The predefined sheet names are System-OS, Software, and Hardware.
- There should not be blank rows between rows containing data.
- The mandatory attribute for all predefined sheets is Resource ID.
The table below provides additional guidance:
|
|
System-OS |
Software |
Hardware |
|
Required data |
|
|
|
|
Recommended attributes |
|
|
|
|
Resource IDs |
Must not have duplicate Resource IDs |
The same as those in System-OS |
The same as those in System-OS |
|
Other |
System-OS should not be empty At minimum, the Resource ID column should be populated
|
If Software is empty, then no software data will be published
|
If Hardware is empty, then no hardware data will be published
|
After entering your data into the spreadsheet, follow the steps below to run the Excel Extractor.
Running the Excel Extractor in Admin Console
- Click Create Process on the top right of the UI.
- Click IT Discovery Tool, then select Next.
- Click Other: Normalize Zip File, then click Next.
- Click UPLOAD ZIP to select your edited Input_Spreadsheet.xlsx file.
- Click Next to complete the upload.
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago