Solved

Avaya CMS Supervisor Download to Oracle

Posted on 2010-09-22
6
1,863 Views
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:

'LANGUAGE=ENU
'SERVERNAME=xxxxxxxx
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"
        Else
                 Set Log = CreateObject("ACSERR.cvsLog")
              Log.AutoLogWrite "The report Integrated\Designer\Comparison Report was not found on ACD 1."
              Set Log = Nothing
        End If
   Else

         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)

            Rep.Quit

      

              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!
0
Comment
Question by:UPRRDevelopers
[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
  • 3
  • 2
6 Comments
 
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.

0
 

Author Comment

by:UPRRDevelopers
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.
0
 
LVL 77

Accepted Solution

by:
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.

http://www.oracle.com/technetwork/topics/winsoft-085727.html
Instant Client Package - Basic Lite
Instant Client Package - ODBC

http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html
Oracle 11g Release 2 ODAC 11.2.0.1.2 with Xcopy Deployment
0
 

Author Comment

by:UPRRDevelopers
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!
0
 
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

734 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