Avaya CMS Supervisor Download to Oracle

Posted on 2010-09-22
Last Modified: 2013-12-20
I have a script created from a standard Avaya CMS Supervisor report.  The script will either print the report to my printer, or if I add an export statement, will export the data to a file such as Excel.  That works fine.  What I need to do is to somehow export this data directly into an Oracle field.  I have created the report to retrieve only one data value, and I would like to do an INSERT to put that value into a table, but I don't know how to do that, and I can't find any documentation for it on the web.  I don't want to export the data to an Excel file then rely on another process to read that file and upload it to the database, which is what I'm looking at doing now.  If there is any way possible, I would like to do this within the same script.

This is my script as of now:

Public Sub Main()

'## cvs_cmd_begin
'## ID = 2001
'## Description = "Report: Integrated: Designer: Comparison Report: Export Data"
'## Parameters.Add "Report: Integrated: Designer: Comparison Report: Export Data","_Desc"
'## Parameters.Add "Reports","_Catalog"
'## Parameters.Add "2","_Action"
'## Parameters.Add "1","_Quit"
'## Parameters.Add "Integrated\Designer\Comparison Report","_Report"
'## Parameters.Add "1","_ACD"
'## Parameters.Add "3015","_Top"
'## Parameters.Add "3630","_Left"
'## Parameters.Add "12105","_Width"
'## Parameters.Add "9480","_Height"
'## Parameters.Add "The report Integrated\Designer\Comparison Report was not found on ACD 1.","_ReportNotFound"
'## Parameters.Add "*","_BeginProperties"
'## Parameters.Add "251","Splits/Skills"
'## Parameters.Add "*","_EndProperties"
'## Parameters.Add "*","_BeginViews"
'## Parameters.Add "G0,0,0;-1,2,0","TABLE0"
'## Parameters.Add "*","_EndViews"
'## Parameters.Add "C:\Avaya\Avaya.xls","_Output"
'## Parameters.Add "9","_FldSep"
'## Parameters.Add "0","_TextDelim"
'## Parameters.Add "False","_NullToZero"
'## Parameters.Add "False","_Labels"
'## Parameters.Add "True","_DurSecs"

   On Error Resume Next

   cvsSrv.Reports.ACD = 1
   Set Info = cvsSrv.Reports.Reports("Integrated\Designer\Comparison Report")

   If Info Is Nothing Then
        If cvsSrv.Interactive Then
              MsgBox "The report Integrated\Designer\Comparison Report was not found on ACD 1.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
                 Set Log = CreateObject("ACSERR.cvsLog")
              Log.AutoLogWrite "The report Integrated\Designer\Comparison Report was not found on ACD 1."
              Set Log = Nothing
        End If

         b = cvsSrv.Reports.CreateReport(Info,Rep)
         If b Then
            Rep.Window.Top = 3015
            Rep.Window.Left = 3630
            Rep.Window.Width = 12105
            Rep.Window.Height = 9480        
            Rep.SetProperty "Splits/Skills","251"
            Rep.ReportView.Add "G0,0,0;-1,2,0","TABLE0"
            b = Rep.ExportData("C:\Avaya\Avaya.xls", 9, 0, False, False, True)



              If Not cvsSrv.Interactive Then cvsSrv.ActiveTasks.Remove Rep.TaskID
            Set Rep = Nothing
         End If

   End If
   Set Info = Nothing
'## cvs_cmd_end

End Sub

Thanks for any help you can provide!
Question by:UPRRDevelopers
  • 3
  • 2
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33738181
I have no idea about avaya but that looks a lot like VB.  Is that their own 'flavor' of VB of do you know the flavor (VBA/VB.Net/VB6)???

Do you have the report API calls(please don't post copies of the docs here.  They are probably copyrighted)?  If you can find one that will allow you to loop through the records we can probably help with the Oracle connection code.

Let me know the flavor of VB and I'll add a few more Zones to this question to get some VB Experts involved.


Author Comment

ID: 33738678
Its VBA, according to the limited documentation that I have found.  I've been looking for the APIs as well, but I have found nothing.  From the lack of similar issues I've found online, I assume no one else has tried to do this, or it's simply not possible.
LVL 76

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 33743333
Can you contact the vendor for documentation?  Even if you can get their VBA to connect to Oracle you'll need some object that will let you look through the output or let you save the report into an object Oracle will recognize.  XML would be perfect!

Then you'll need some Oracle client.  The Instant client is the smallest/easiest to set up and allows for ODBC (and other) connections.  You will need the 'Basic' then whatever other options you wish.

An alternative 'might' be the ODAC (I use this with VB.Net.  Haven't tried with VBA).

Links to download these are below.  There are TONS of links out there on using ADO and Oracle ODBC.  While you wait for the vendor to get back to you you might try a simple database connection/insert of static data from the code just to see if it is possible once you figure out how to access the report contents.
Instant Client Package - Basic Lite
Instant Client Package - ODBC
Oracle 11g Release 2 ODAC with Xcopy Deployment

Author Comment

ID: 33755286
As it turns out, Avaya has a product to handle this, but they charge for it.  It just came out in June.  I'll have to see if management wants me to purchase it.  Thanks for the help!
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33755303
Keep in mind:  You might still be able to work with what you have available without violating any license agreement.

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

777 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