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 query

Open the supplied query, and you will receive the following security notice:

Click Enable.

You may then receive an error that a file cannot be located:

Click OK.

Locate the archive file

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:

  1. Click OK.
  2. Click on “Close & Load” (top left), and you will be returned back to the Excel Book.
  3. Finally click on Data | Refresh All.

And you will see the imported data in the spreadsheet.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: January 27, 2021