Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Spok

Create an Excel Spreadsheet from an XML File Generated in Smart Center Reports(Edge workaround)

Overview

This guide will detail how to create a spreadsheet in Excel from a .xml file generated in the Smart Center Reporting tool in Microsoft Edge, IE, or Firefox

Goal

After completing these steps you will be able to save data in an Excel spreadsheet which may be more useful for certain circumstances than the typical PDF reporting done in Smart Center.

First Step

 

Log into Smart Center as the user needed to generate the report you want to create. Navigate to the desired report then copy and paste the page URL from the default browser into a Edge, IE, or Firefox browser and choose the report parameters.

 

clipboard_e7aad249dc7df7058081adcbb2aef162e.png

 

***Important***

Internet Explorer must be running in compatibility mode for the web server hostname prior to using the report URL. To do so navigate to the Compatibility View settings under the sprocket in the upper right hand corner of IE

Example URL:

mypagingserver.com/reports/rwservlet/getjobid123?server=amcom_reports

 

Change made to the compatibility view settings:

clipboard_eb74654de67e7bfd7e61c9187761d13c8.png

Once the site is added IE will be able to download the complete XML file without issue.

 

Second Step

Next input the criteria of your report and choose 'XML' as the Report Format. Then click Submit Query.

clipboard_e7a4c02dd12598e8bf7dbfe0e0ea1beb2.png

Once the report is generated it will open a web page with this at the top and your data in an .xml format

Microsoft Edge Workaround

 

Because of recent security changes to Microsoft Edge the following workaround needs to be performed if using this browser

 

  1. Copy the contents of the .xml format report generated on the web page by using ctrl+a to select all and ctrl+c to copy.
  2. Open any text editor like Notepad or Wordpad and paste the report into a blank document using ctrl+v
  3. Remove the top portion of the report similar to the image below. Delete everything before the first line of the report, in this example <PAGELOG>. Save the file using a .xml file extension.
  4. Skip to the fourth step.

 

clipboard_e84bf13aac19d0c8fa4c2634ccd4cc06a.png

Third Step

Do a Ctrl+S to bring up the Save as.. menu and give the report a name. Make sure you do not change the .xml extension of the file and save it in a location you can find later.

 

clipboard_e51d55e900916d87c8b2cab571a845750.png

 

Fourth Step

Open Excel and select a blank workbook. Once open navigate to File/Open then select Folders.

Excel_1.png

 

Excel_2.png

 

Find your file and open it by bypassing the schema warning and leaving the formatting as default by clicking OK.

 

clipboard_ec8e2a16137672c2bfbb1ac93bd61b000.png

Excel_3.png

clipboard_ec293fbc8f6887bb068e8259381561618.png

 

 

The report will now load as a spreadsheet in Excel and can be saved and worked with accordingly.

What's Next

This guide excludes creating a report in Google Chrome. New security protocols make it difficult to download an XML file and generate a report with it.