Solved

Avaya CMS Supervisor Download to Oracle

Posted on 2010-09-22
6
1,821 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
  • 3
  • 2
6 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
Comment Utility
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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
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
Comment Utility
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 76

Expert Comment

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

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now