Scheduling a report in CUIC

arjunkumar.r · ‎09-29-2011

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.

venr · ‎09-30-2011

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

arjunkumar.r · ‎09-30-2011

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

CindyHill · ‎10-11-2011

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?

venr · ‎10-11-2011

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

CindyHill · ‎10-12-2011

Glad it wasn't something obvious we missed. Thanks for the information.

tholland3 · ‎12-01-2011

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

venr · ‎12-01-2011

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.

tholland3 · ‎12-02-2011

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.