Solved

Avaya CMS reports automation

Posted on 2010-08-15
2
4,520 Views
Last Modified: 2013-11-10
Hello,

I am currently using Avaya CMS reports  and there is a task that I would like to automate.  The task is to run a report on 5 users and have it export the findngs into excel.  Can I write a script in CMS or should I write a script in EXCEL/VBA to open up a session od CMS and use send keys to do all the work?  

If someon can provide an example script to get this to work I would gladly appreciate it.
Not sure how in Excel to create a macro to open up a CMS session.  

Thanks so much guys!
0
Comment
Question by:Maliki Hassani
2 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
ID: 33449205
Hi Lance,
It was one of the prime reason for which i joined EE and this is what my findings is the best way to run your reports if you want to do it from excel and assuming you dont have a sysbase which is a odbc connector of CMS is then saved the script of the report which you are running assuming if its a daily script where you enter a date then try to save that report of that script by -1 and save the script where you export the data as when you export the data after you have run the report it gives you an option to save the script of the same.
Once you have saved the script then through system scheduler schedule that script to be run on a particular time and once you have run the script it will by deffault create a excel file. and then write a sample excel code in which on workbook open it opens up that workbook and copies the data in your report.
Saurabh...
0
 

Author Closing Comment

by:Maliki Hassani
ID: 33493982
THANK YOU!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now