05-09-2023 10:22 AM
I have a user that would like to use Power BI "to automate the phone data visualization reports for the office". Because the report is delivered as a .zip file, it is being extracted from the email manually, then processed. Is there a way to email the report without it first being zipped?
I appreciate any insight.
~David
05-09-2023 01:42 PM
When you schedule a report in CUIC, you have the option of checking several types of formats. Here's the link from one of the guides and apologies if you're referring to something else.
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/intelligence_suite/intelligence_suite_1201/user/guide/cuic_b_user-guide-1201/cuic_b_user-guide-1107_chapter_0101.html#task_0E26769A88E2BD45790F64E8075CFEDB
05-09-2023 03:32 PM
05-09-2023 05:27 PM
05-10-2023 08:00 AM
05-09-2023 07:45 PM
Can you walk through the steps of what you're doing? Like you run the report and it has X rows, you click on this button and select Z, etc? Just wondering if you're running a large report or you're export the report definition itself or something.
05-10-2023 08:02 AM
05-10-2023 06:21 PM
I poked around in UCCX and I don't see a way to do this. One option would be to have a directly ODBC connection to the DB and bypass the scheduled report. The much harder approach is to have script which downloads the email from your server and unzips it for you, but I would go with the DB connection first.
david
05-11-2023 07:33 AM
Are they able to consume the data if you schedule it in another format other than XLS?
Also, you might want to submit this as an enhancement request to Cisco, as it makes sense to me.
https://ciscocollabcustomer.ideas.aha.io/
05-11-2023 09:57 AM
05-11-2023 02:56 PM
Have you tried the SFTP option to see if that sends it as XML vs. .zip?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide