There may come a time when you have a need to parse details from the Halcyon Enterprise Console archive files into Excel.
Halcyon has created a query (HECArchive.odc) that allows you to do this, and this document explains the steps you need to take to achieve it.
Open the supplied query, and you will receive the following security notice:
You may then receive an error that a file cannot be located:
Once Excel has opened, use Data | Queries & Connections, and this will open up the Queries on the right hand side of the window.
Right-hand click on HECArchive, and select Edit to launch the “Power Query Editor”:
On the right-hand side of this panel there is an “APPLIED STEPS” window, use the scroll bar to scroll to the top of this window, and then click on the cog icon next to “Source”:
Browse to the location where your archive files reside, and then select the desired file:
And you will see the imported data in the spreadsheet.
Still have questions? We can help. Submit a case to Technical Support.