How do you create a CSV (comma separated value) file from DMA HTML Reports? (NETIQKB1419)

  • 7701419
  • 02-Feb-2007
  • 30-Jul-2012

Environment

fact Domain Migration Administrator 6.0
fact Domain Migration Administrator 6.1 
fact Domain Migration Administrator 6.2 
fact Domain Migration Administrator 6.3 
fact Domain Migration Administrator 7.0 
fact Domain Migration Administrator 8.x

Situation


How do you create a CSV (comma separated value) file from DMA HTML Reports?

Resolution



To create a CSV file from the DMA HTML reports, simply open the HTML report, located in C:\Program Files\NetIQ\DMA\Projects\'project_name'\Reports directory, with Microsoft Excel. Next, save the report as a .csv file and reopen it. There may be some cleaning up to do such as removing headers, etc. but now the file can be opened with Microsoft Excel, Notepad, etc. 
TIP: If the HTML report is extensive, containing multiple HTML files, use the file titled reportname_All.html.  

Additional Information

Formerly known as NETIQKB1419