Solved

Avaya CMS reports automation

Posted on 2010-08-15
2
4,548 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A short article about a problem I had getting the GPS LocationListener working.
This is about my first experience with programming Arduino.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

939 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

11 Experts available now in Live!

Get 1:1 Help Now