cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Included in the 5.5.66 Data Platform patch release is a 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 Microsoft Access Database Engine driver must be installed on the machine before running this extractor. This driver can be downloaded here. (Install 64-bit)

 
Use the attached spreadsheet to dump raw data, following 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.
  •  

     Populating Sheets

    •  
    •  
    •  
    •  
    •  
    •  

     

    System-OS

    Software

    Hardware

    Required data

      • System data
      • Operating system data
      • Add/remove data
      • Computer system data
      • CPU data

    Recommended attributes

      • Host name
      • Operating System Name
      • Operating System Caption
      • Display Name
      • Publisher
      • Device Manufacturer
      • Device Model

    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.

     

     

    Run the Excel Extractor in Admin Console

    1. Click Create Process on the top right of the UI.
      1-1.png
Was this article helpful? Yes No
No ratings
Comments
goody612
By
Level 8

Is there an excel template that goes along with this?  I see the document references one, but didn't see it within the zip file.

JdeGuzman
By Level 3 Flexeran
Level 3 Flexeran

Hi @goody612,

We do apologize about the confusion there if it was a little bit unclear. However, when we mentioned a "predefined input spreadsheet", I have confirmed that this is actually a spreadsheet that Customers have to create on their own.

If you do need some guidance, I believe there is details about the requirements within the Word document attached to the Knowledge Base article.

Many thanks,
Andrew

JdeGuzman
By Level 3 Flexeran
Level 3 Flexeran

Hi @goody612,

Our Knowledge Base article has now been updated.

This should now have the input spreadsheet attached to it.

Apologies for the confusion!

Many thanks,
Andrew

juanr1vargas
By
Level 5

Hello, 

Which template should we use for a csv file ?

Thank you.

DSood1
By Level 5 Flexeran
Level 5 Flexeran

@juanr1vargas  please use the Input_Spreadsheet file in the attached zip as a template.

juanr1vargas
By
Level 5

Thank you @DSood1,.

I just wanted to be clear since the KB title reference support for CSV extractor, but the template is an excel spreadsheet. The excel spreadsheet contain multiple sheets which it is not possible with a csv file so it may be misleading to say there's support for CSV when that may not be the case. 

Can you clarify for me?

Thank you.

GopalRaghvani
By
Level 6

Hello @JdeGuzman 

 This is a great feature. I use this to import Network devices in Data Platform.

How can I update field "Is Active?" i.e. when a Network device has been decommissioned

Thanks

 

Version history
Last update:
‎Jan 02, 2024 01:24 PM
Updated by: