using C# to run Avaya CMS reports

[RickoT]

OK well I resolved the issue that I was having by making the Export go to a file which didnt quite have the delay I expected, byt now about every 40 seconds I lose connection and the login state becomes "cpWaiting" any suggestions?

[RickoT]

OK well I resolved the issue that I was having by making the Export go to a file which didnt quite have the delay I expected, byt now about every 40 seconds I lose connection and the ConnectionStatus becomes "cpWaiting" any suggestions?

[gkrishs]

Thanks corcoranp, I was able to phrase my javascript code based on the C# code you mentioned earlier.

But I am not able to link the connection to the report.
Following step fails to execute.
cvsSrv.Reports.CreateReport(Info,Rep)

Please suggest.

[mac_see]

Hi! corcoranp and all the Experts out here.

Can anybody reply to my post "Sub: Using Excel VBA to run Avaya CMS reports"?

[rhorc]

Originally Posted by SRGR

.... Currently I have automatic scripts scheduled they create flat files and I have VB program which extracts the data from flat files and send to SQL Server. .....

I have created a .NET application that moves all new CMS data to a SQL Server. The idea is that all reporting can now be done thru the SQL Server and we will be able to retain data for many years to see year to year trends.

Does anyone know how to point the CMS Supervisor reporting tool to a SQL Server?

[rhorc]

Originally Posted by SRGR

.... Currently I have automatic scripts scheduled they create flat files and I have VB program which extracts the data from flat files and send to SQL Server. .....

I have created a .NET application that moves all new CMS data to a SQL Server. The idea is that all reporting can now be done thru the SQL Server and we will be able to retain data for many years to see year to year trends.

Does anyone know how to point the CMS Supervisor reporting tool to a SQL Server?

[aduljr]

I went about getting data from the cms supervisor in a more round about fashion.

I have a php script checks to see if the CMS autoscript is running within windows and. If it is running, it then checks against the DB for when it was last launch. If a certain threshold is exceeded, it runs another script to kill all processes and launches a new instance of the avayascript.

All data is written into a csv file. This file is then read by another looping script that lives for 3 minutes as well. It parses the data and writes it into a DB. There are a couple of different tables I use as one to archive and another to feed the data to the agents. I can run these set of scripts on a few boxes to get more frequent updates and ensure I always get data. Though I limit updates to the archive table to twice a minute. I then use this data in the db for reporting.

[nickd87]

Originally Posted by madhombre

I have been going round and around on this, hopefully someone can help me.

I have this VB code...

Dim cvsApp = CreateObject("cvsup.cvsApplication")
Dim cvsConn = CreateObject("CVSCN.cvsConnection")
Dim cvsSrv = CreateObject("CVSUPSRV.cvsServer")
Dim Rep = CreateObject("CVSREP.cvsReport")
Dim Info As Object, b As Object

If cvsApp.CreateServer("******", "", "", "******", False, "ENU", cvsSrv, cvsConn) Then
If cvsConn.Login("******", "******", "******", "ENU") Then
'On Error Resume Next
cvsSrv.Reports.ACD = 1
Info = cvsSrv.Reports.Reports(reportName)
b = cvsSrv.Reports.CreateReport(Info, Rep)
If b Then
Rep.SetProperty(prop1, prop2)
b = Rep.ExportData(destFile, 9, 0, True, False, True)
Rep.Quit()
Rep = Nothing
End If
End If
End If
Info = Nothing

runs perfectly, no issues, all good.

Hi everyone, hoping I can resurrect this thread.

I am copying the code above but when I get to "Info = cvsSrv.Reports.Reports(reportName)" I get the dreaded "Object variable or With block not set" error.

Any pointers as to what I'm doing wrong?

Thanks

Nick

[corcoranp]

You'll want to double check your reportName variable to ensure that you are using a good report name.

Also, since this is only a snippet of code I don't see where you've declared the reportName, so just make sure you are doing that too.

On a side note, since my last posts I've made great strides in how I'm collecting data from CMS. I've got a report server running as a windows service that I can connect to over HTTP using .NET Remoting (an IReportBuilder interface so NO Avaya dlls needed in new projects that require CMS data!). Plus a generic report object that returns the raw report output & the report in a .Net DataTable. Plus the Avaya componenets don't start until the a call is made to the service, and then stay alive until the service is stopped. So no more having to wait on logins, or connections, or having to have CMS Supervisior installed on the machine you're running your app from! Plus you can use it with ASP.NET!

[nickd87]

Originally Posted by corcoranp

You'll want to double check your reportName variable to ensure that you are using a good report name.

Also, since this is only a snippet of code I don't see where you've declared the reportName, so just make sure you are doing that too.

On a side note, since my last posts I've made great strides in how I'm collecting data from CMS. I've got a report server running as a windows service that I can connect to over HTTP using .NET Remoting (an IReportBuilder interface so NO Avaya dlls needed in new projects that require CMS data!). Plus a generic report object that returns the raw report output & the report in a .Net DataTable. Plus the Avaya componenets don't start until the a call is made to the service, and then stay alive until the service is stopped. So no more having to wait on logins, or connections, or having to have CMS Supervisior installed on the machine you're running your app from! Plus you can use it with ASP.NET!

Thanks for your reply. Seems to be working now.

Your progress sounds amazing! I am still working on some way (using vb6) of not having to write out the report to a text file and having to read it back in. Not having much luck so far - damn Avaya dll's!

[Firemaple]

What all dlls must be added in order to access these classes?

I can't seem to find that in the forum.


thanks in advance!

[Firemaple]

Hey all, I found the proper references... but i have a new question.

I am able to connect and login. However I can't get the Report info for a specific report. It is located in "Historical", "Designer", and the report is called "MetricsAutomationSystem - AHT".

In the VB Examples it says this:
###Set Info = cvsSrv.Reports.Reports("Historical\Designer\HD MetricsAutomationSystem - AHT")

However, I am not sure how to get the ReportInfo with C#.

Anyone have any ideas??

thanks!!

[patricker]

I have posted a follow-up thread to this one, as I didn't want to resurrect this existing one: Avaya CMS 11 Reports in C#.