09-29-2011 11:16 AM - edited 03-14-2019 08:38 AM
Hi,
Can I schedule a report in CUIC and I want that report to dumped in a specific location. Is this possible ?
I know the other options are to email the scheduled reports or to make it available in the dashboard. But, I do not need them. I need the scheduled reports to be dumped ina specific location.
09-30-2011 07:55 AM
Hi Arun,
Can you explain in detail what do you mean by 'dumping the scheduled report in a specific location' ?
Do you mean putting the scheduled report to a shared filer location?
Thanks
Venkat
09-30-2011 09:48 AM
Hi Venkat,
Exactly, I need to schedule the reports and save it a specific location (ex : my desktop or any other server) and not on the CUIC server itself. When I run the scheduler the options that I have got is to email or to make it available in the dashboard. I don't see an option change the destination of where the reports are going to be saved.
Cheers
Arjun
10-11-2011 05:38 AM
We are looking for this feature too. In Webview, the job scheduler allowed us to export reports to a file location in which we could select a drive and also a file format (ex. CSV, HTML, etc). We've installed CUIC in our lab to test and the new scheduler function doesn't seem to have this ability. I hope I'm missing something and this isn't a loss in functionality as we really need this.
Does anyone know how to schedule a report to export to a network location?
10-11-2011 11:27 AM
Hi Cindy,
CUIC doesn't have this functionality currently to support scheduling reporrs to a remote shared location.This was actually not there even in CUIS 7.x versions.
Having said that, we do have this feature as part of our current CUIC product backlog.
Thanks
Venkat
10-12-2011 07:06 AM
Glad it wasn't something obvious we missed. Thanks for the information.
12-01-2011 12:17 PM
We actually use a vbs script to move the "scheduled" report to a network share location. Set the .vbs to run using Task Schedule. Here is one of the scripts we use:
dim dtmToday, dtmFileDate
dtmToday = Date
On Error Resume Next
Set FSO = CreateObject("Scripting.FileSystemObject")
Set LogFile = FSO.OpenTextFile("C:\DonnaLogs.txt",8,TRUE)
Set objFOlder = FSO.GetFOlder("C:\Documents and Settings\ciscouccxreport\Desktop\Donna Reports")
Set datafiles = objFOlder.Files
NumberofFiles = DataFiles.count
If NumberofFiles < 8 Then
Dim objMessage
Dim strTextBody
Dim strEmailTo
Dim intInstance
Dim strEnableCount
Dim DiffTime
'Initialize the objects
'*****************************************************************************************
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Donnas Reports failed"
objMessage.From = "fpalmore@edpstech.com"
objMessage.To = "fpalmore@edpstech.com;tcairns@edpstech.com;tholland@estes-express.com"
'*****************************************************************************************
objMessage.TextBody = "Donnas Reports failed today" & VBCRLF & VBCRLF
'Set email TextBody
'*****************************************************************************************
'objMessage.TextBody = strTextBody
'*****************************************************************************************
'Set email TextBody
'*****************************************************************************************
'objMessage.TextBody = strTextBody
'*****************************************************************************************
'*****************************************************************************************
'==This section provides the configuration information for the remote SMTP server.
'*****************************************************************************************
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of Remote SMTP Server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail65002.edps.dom"
'Type of authentication, NONE, Basic (Base64 encoded), NTLM
'objMessage.Configuration.Fields.Item _
'("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic
'Server port (typically 25)
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'Use SSL for the connection (False or True)
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False
'Connection Timeout in seconds (the maximum time CDO will try to establish a connection to the SMTP server)
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
objMessage.Configuration.Fields.Update
'==End remote SMTP server configuration section==
'*****************************************************************************************
'Send the email
'*****************************************************************************************
objMessage.Send
'*****************************************************************************************
'Destroy the object
'*****************************************************************************************
Set objMessage = Nothing
'*****************************************************************************************
End if
LogFile.WriteBlankLines(1)
LogFile.WriteLine("[CHECKING DONNA'S REPORT STATUS " & NOW & "]" )
For Each objFile in objFolder.Files
dtmFileDate = objFile.DateLastModified
intDaysDifference = DateDiff("d", dtmFileDate, dtmToday)
If intDaysDifference < 2 Then
Err.clear
FSO.CopyFile objFile.Path, "\\deptpublic\deptpublic\HR\Phone Reports\Monthly Reports\"
If Err = 0 then
LogFile.WriteLine(" COPIED " & objFile.Path & " to \\deptpublic\deptpublic\HR\Phone Reports\Monthly Reports\")
Else
LogFile.WriteLine(" **ERROR " & Err.Number & " copying " & objFile.Path & " to \\deptpublic\deptpublic\HR\Phone Reports\Monthly Reports\")
LogFile.WriteLine(" ******* " & Err.Description)
Err.clear
End If
Else
If intDaysDifference > 2 Then
Err.clear
FilePath = objFile.Path
If objFile.DELETE = 0 Then
LogFile.WriteLine(" DELETED " & FilePath)
Else
LogFile.WriteLine(" **ERROR " & Err.Number & " DELETING " & objFile.Path)
LogFile.WriteLine(" ******* " & Err.Description)
Err.clear
End If
End If
End If
Next
LogFile.WriteLine("[COMPLETING DONNA'S UPDATE " & NOW & "]" )
LogFile.Close
12-01-2011 08:47 PM
In the upcoming CUIC release 8.5(4) [To be shipped by Dec 14, 2011], we are including this feature of scheduling a CUIC report as a PDF file .
We have also included the support of storing this scheduled report as a csv file in a shared filer that supports SFTP.
This means, you can schedule a CUIC report and can specify the SFTP location where you want CUIC to deposit this scheduled report in a CSV format.
12-02-2011 05:28 AM
That good news...will Historical Reports still need to be run on a client
machine rather than the server?
Tracy Holland
Network Voice Engineer
Estes Express Lines
tholland@estes-express.com
(804) 353-1900 x2436
From:
venr
To:
Tracy Holland
Date:
12/01/2011 11:47 PM
Subject:
- Re: Scheduling a report in CUIC
Home
Re: Scheduling a report in CUIC
created by Venkataramanan R in Contact Center - View the full discussion
In the upcoming CUIC release 8.5(4) , we
are including this feature of scheduling a CUIC report as a PDF file .
We have also included the support of storing this scheduled report as a
csv file in a shared filer that supports SFTP.
This means, you can schedule a CUIC report and can specify the SFTP
location where you want CUIC to deposit this scheduled report in a CSV
format.
Reply to this message by going to Home
Start a new discussion in Contact Center at Home
For 80 Years — Delivering Solutions that Exceed Expectations.
This communication and any transmitted documents are intended to be
confidential. If there is a problem with this transmission, please contact
the sender. If the reader of this message is not the intended recipient,
or the employee or agent responsible to deliver it to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide