How to export Device Manager Hosts and import to Infrastructure Director

Document created by Gary Gustafson on Jun 2, 2015Last modified by Gary Gustafson on Jun 2, 2015
Version 2Show Document
  • View in full screen mode

This tool automates creation of HID CSV file from an existing DvM hosts file.

 

It takes two arguments :

 

GenerateHidHostsFromDvMHosts.exe [path to Dvm CSV file]  [path to the HID output CSV file]

 

Notables:

 

1.      After exporting the CSV from DvM, the file contains a lot of noise and extra double quotes.  This makes the file difficult to parse and process programmatically.  Before running the script, import to Excel using the import wizard and save again as CSV.  This will remove the extra quotes;

2.      Rows with blank WWN are not added to the HID CSV;

3.      Blank IP Addresses are not ignored.  These should be added manually before using the CSV to onboard to HID;

4.      Rows with OS Types which are not recognized by HID are not added to HID CSV;

Outcomes