I thought this was tedious and my hand was sore from doing repetitive things.So after some research I found out that we can use the Avaya objects from Excel to automate these reports.I was able to automate most of my daily, weekly and monthly reports and what used to take me hours to complete I can now finish in seconds with one click.
Over the last couple of years I was able to create all sort of automated dashboards to report on call statistics, service levels and staff KPIs. Avaya Cms Reporting Guide Software Will BeOf course Avaya has a custom reports capability but I was told I cant have access to this function as our company had an agreement with Avaya that they are the only people allowed to write custom reports otherwise the warranty on the software will be void. Avaya Cms Reporting Guide Code Sample IIn this code sample I will demonstrate how to automate the Avaya Call Management System software from Excel. I will give an example on how to obtain an Agent Trace report and paste it on the first sheet in an Excel application. This is a basic example but the logic can be followed for all other reports. It is also worth while looking inside the script that Avaya generates, open it with Notepad and have a look at the code it contains, it is written in Visual Basic. ![]() So lets get started, start the Visual Basic editor from Excel then copy the code below in a new module, give the user name, password, date and agent name valid values and run it. ![]() ![]() It will create a new folder for each day and saves each agent trace in a new a Excel file. Start the Visual Basic editor from Excel and add the Avaya objects references. You will need the Application Component, Connection Component, Report Component and Server Component. Dim cvsApp As New ACSUP.cvsApplication Dim cvsConn As New ACSCN.cvsConnection Dim cvsSrv As New ACSUPSRV.cvsServer Dim Rep As New ACSREP.cvsReport Dim Info As Object, Log As Object, b As Object The rest of the coding will be the same. When you are in a report if you click on the Report button in the menu and select script and save it you can then run the report by just double clicking on the scriptName.acsauto file. This will only run the one report. But did you know you can edit that file to make it run for multiple skills and saves each in a different file Here the code to get the summary interval reports for 15 skills and save them in a text file in one script. You can open the.acsauto file with notepad and edit it, this script will save on the C: drive in a directory called C:CMS Scripts, make sure you have it. One other question - do you know how you would refresh (or simulate a refresh) a historical report via VBA Similar to.RefreshInterval on a realtime report. It has a restart in the menu which is kind of what Im thinking, restart it, feed it the.SetProperty values again, etc.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |