After deploying UCCX 11.0 and working on setting thresholds in some live reports in CUIC I found that reports exported to Excel couldn't be opened. When attempting to open the XLS file, Excel itself would open but not the report. Excel would sit open, idle, returning no dialog box or even a blank default workbook. It would simply be an idle instance of Excel displaying no information.
Bug CSCux50551 indicates there is a known issue with exporting the Abandoned Call Detail Activity Report but my issue was the same regardless of what report was exported.
I also found that the exported report could be opened in a text editor and that some data could be gleaned between markup tags. If I opened the exported report in a browser, it could be viewed in a rather crude format.
Ultimately I discovered a security feature of either my laptop's Windows implementation or my Excel installation was preventing the file from being accessed on my laptop. Unfortunately there was no dialog box indicating that was the case so it took a bit to decipher.
Right-click your exported report XLS file to view the properties. Look for a Security reference. The description on mine was "This file came from another computer and might be blocked to help protect the computer." Simply hitting the Unblock button and Apply fixed my glitch.
Here's a screen shot of my blank Excel instance and the file property page:
For reference, I'm using Office Professional Plus 2010 on Windows 7 Professional on a domain different that the UCCX servers.
Monday, August 01, 2016
To add thresholds to existing reports:
- Copy existing stock report into new folder.
- Right click report and choose Edit.
- Click Edit View button.
- Choose view radio button (ie snapshot, since midnight, etc.) and Edit button
- Right click the field to set threshold against and choose Thresholds.
|Selecting "Waiting Calls" variable and adding "Greater than 1" threshold|
|Setting text of variable to white on red when threshold met|