Solved

Avaya CMS Supervisor Download to Oracle

Posted on 2010-09-22
6
1,832 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)
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 76

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 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.
0

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

Suggested Solutions

Title # Comments Views Activity
data lookup in Oracle - need suggestions 55 101
Make all values in arrayist to titlecase+vb.net 23 27
Problem to With line 4 37
Allow User To Arrange Columns At Datagridview 3 19
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

932 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

15 Experts available now in Live!

Get 1:1 Help Now