|
Posted by Heelan on September 20, 2005, 9:52 am
If you were Registered and logged in, you could reply and use other advanced thread options
I am currently running Symposium Server 5. We are also using remedy
for ticket tracking. I have a VBS script that connects to the Remedy
Oracle Database and runs reports daily, but can not figure out how to
make the VBS script connect to the Symposium Database. Here is the VBS
script I am using for Remedy:
'<job id='CSVCommandLineScheduler'>
Option Explicit
Dim oApp
Set oApp = CreateObject("CrystalRuntime.Application")
Dim oRpt
Set oRpt =
oApp.OpenReport("C:\RemedyStats\Automation\CrystalVB\RITSD.rpt",1)
oRpt.DiscardSavedData
Dim Table
For Each Table in oRpt.Database.Tables
Table.SetLogonInfo "ARDBC","miaremedyapp01","RITSDRPT","XXXXXX"
Next
Dim FileSystemObject
Dim FolderPath2
DIM FolderPath1
Dim FolderObject
Set FileSystemObject = CreateObject("Scripting.FileSystemObject")
FolderPath2 = "H:\automation\"
FolderPath1 = "C:\RemedyStats\Automation\"
'Set FolderObject = FileSystemObject.CreateFolder(CStr(FolderPath2))
'Set FolderObject = FileSystemObject.CreateFolder(CStr(FolderPath1))
Dim ExportOptions
Set ExportOptions = oRpt.ExportOptions
ExportOptions.FormatType = 31
ExportOptions.DestinationType = 1
ExportOptions.DiskFileName = FolderPath2 & "RITSD.pdf"
ExportOptions.DiskFileName = FolderPath1 & "RITSD.pdf"
oRpt.Export False
'</script>
'</job>
Any assistance will be greatly appreciated.
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML site map