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.
Related Articles
Data Platform v5 extractor support in Flexera One: Fields mapping and descriptions 7Number of Views Installing Data Platform Extractor to upload Data to IT Visibility 63Number of Views Deduplication Rules in Data Platform Normalize 8Number of Views Security Credentials Storage and Encryption in Data Platform 5Number of Views Mashup fields in SCCM do not appear in Flexera Data Platform 6Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
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