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 77

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 77

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 77

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Read XML values 8 42
oracle forms question 22 42
DataGridView / get bound table name? 8 28
making a message body variable from an oracle select statement 4 25
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

830 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