?
Solved

Avaya CMS reports automation

Posted on 2010-08-15
2
Medium Priority
?
4,916 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

801 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