CMS schedule daily report dump.

[jerrygiberti]

I have set up scheduled reports in past via CMS time tables to print reports to supervisors printers each morning however this is time the task is a bit different. I am trying to set up a couple automated reports to run daily to a shared folder on the network where they will be pulled by another database. So basically I just need to run a report to file in either a *.txt or *.htm format. I am running the latest CMS latest release (13.1). Would the time table still be my best or option or? Has anyone done this?

Phontechie

 

[jfh9219]

Are you using CentreVu Supervisor? Have it available?

Simple to script the desired report. You can use Windows Task Scheduler to execute it or you can get real clever and have a program that interfaces with CMS server via COM and run any reports you want. I collect Call Records & Agent Trace info via this mechanism. Poor man's ECHI.

 

[jerrygiberti]

Thanks for the reply. Correct me if I'm wrong but I percieve the concept as you are creating a script(s) to run the report and then sceduling the script to run via windows scheduler which executes the CMS CentreVu client then auto generates log in and auto runs script per schedule configuration. Guiness! So anyone have any pointers on writing a good script that will make this work. Thanks for your help guys..

Phonetechie

 

[smurfyIAG]

Jerry, CMS Supervisor client does it all for you. Either HTML or TXT
Run the report with the desired parameters, then Report>Export to HTML>Script
or
Action>ExportTable data to file>Script (command may be worded slightly differently - I'm not in front of my CMS at the moment).

Personally I utilise my own VBa application and back-door ODBC access rather than using that method, but either one works. Depending on your database application, you may be better off getting the ODBC licence and pulling the data rather than relying on the push from a CMS supervisor client PC.

Sean Murphy
Call Centre Analyst
IAG New Zealand

 

[whatsanavaya]

just run the report using CMS supervisor then select the script button to save it as a autoscript. Also set up the user for the scripts on Tools-Options menu so that it will login automatically to run the report. Finally just use windows task scheduler to run script.

I installed CMS Supervisor on a 24x7 server just to run scripts, run then at night so not to use up a license when normal users work.

 

[jerrygiberti]

Excellent advice guys, Thank You! One more question if I want to run an all agents daily each evening using a scheduled autospcript how will the script update the date automatically each day? Automatically? That would be ideal..or??

 

[Tolson]

Instead of using an actual date such as 07/24/06 for yesterday enter a -1 to goto the previous day.

 

[jerrygiberti]

Thanks Tolson!