How do I write a program to pull reports from Avaya CMS Supervisor R17 and puts them in excel?

5 pts.
Tags:
Big Data Analysts
call monitoring
excel
My company wants me to build an excel dashboard that tracks their call center and they use Avaya CMS.
The difficulty I am having is that it would take weeks to pull Split/Skill Summary Interval reports and then copy, paste, and format it in excel. I'd be doing this every day to build a historical record to track it.
How can I automate this free of charge? I have very little knowledge of VBA, python, or perl and cannot find anything in the avaya documentation to help me find the best path.
If someone could walk me through approaching this correctly and help me learn the technical aspect, I would be thrilled.
Thanks


Software/Hardware used:
Avaya CMS
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    You should not need to export the data from the reports to get it into Excel.

    The Avaya software must be storing its data in a database, so, if you are able to get the necessary details to make a connection to that database, you might be able to read the data directly from the tables, and then export it into a CSV or some other format readable by Excel, by means of some simple script.
    85,865 pointsBadges:
    report
  • Subhendu Sen
    Is there no Help Menu in Avaya CMS? Please link here, https://downloads.avaya.com/css/P8/documents/100170092
    142,210 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: