Solved

Avaya CMS reports automation

Posted on 2010-08-15
2
4,626 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 AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This is about my first experience with programming Arduino.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

803 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