Question Automated CMS Script TimeZone set up

Hi Roller,

Good Morning,

I have created an automated cms script however I am being challenged by getting the report run in the desired timezone and pull the data in "Asia/Tokyo" TimeZone specifically. I have applied same method I found in one of your posts here(Rep.TimeZone = "Asia/Tokyo") however the data generated is showing the same numbers/data pulled using "default" timezone

In this manner we get huge discrepancy and it makes the pulled data useless.

Shown below is the snapshot of the code;

'LANGUAGE=ENU
'SERVERNAME=*********
Public Sub Main()

'## cvs_cmd_begin
'## ID = *****
'## Description = "Report: Historical: Designer: JnJ Summary Interval, ASA/ABA Time F: Export Data"
'## Parameters.Add "Report: Historical: Designer: JnJ Summary Interval, ASA/ABA Time F: Export Data","_Desc"
'## Parameters.Add "Reports","_Catalog"
'## Parameters.Add "2","_Action"
'## Parameters.Add "1","_Quit"
'## Parameters.Add "Historical\Designer\JnJ Summary Interval, ASA/ABA Time F","_Report"
'## Parameters.Add "1","_ACD"
'## Parameters.Add "1440","_Top"
'## Parameters.Add "5115","_Left"
'## Parameters.Add "14685","_Width"
'## Parameters.Add "9420","_Height"
'## Parameters.Add "Asia/Tokyo","_TimeZone"
'## Parameters.Add "The report Historical\Designer\JnJ Summary Interval, ASA/ABA Time F was not found on ACD 1.","_ReportNotFound"
'## Parameters.Add "*","_BeginProperties"
'## Parameters.Add "1686","Splits/Skills"
'## Parameters.Add "-2.08333","Dates"
'## Parameters.Add "00:00-23:30","Times"
'## Parameters.Add "*","_EndProperties"
'## Parameters.Add "*","_BeginViews"
'## Parameters.Add "*","_EndViews"
'## Parameters.Add "C:\Users\********\Documents\CMS Data Files\JnJ Multi Skills-ASPAC.txt","_Output"
'## Parameters.Add "44","_FldSep"
'## Parameters.Add "0","_TextDelim"
'## Parameters.Add "True","_NullToZero"
'## Parameters.Add "True","_Labels"
'## Parameters.Add "True","_DurSecs"


On Error Resume Next

cvsSrv.Reports.ACD = 1
Set Info = cvsSrv.Reports.Reports("Historical\Designer\JnJ Summary Interval, ASA/ABA Time F")

If Info Is Nothing Then
If cvsSrv.Interactive Then
MsgBox "The report Historical\Designer\JnJ Summary Interval, ASA/ABA Time F was not found on ACD 1.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
Else
Set Log = CreateObject("ACSERR.cvsLog")
Log.AutoLogWrite "The report Historical\Designer\JnJ Summary Interval, ASA/ABA Time F was not found on ACD 1."
Set Log = Nothing
End If
Else

b = cvsSrv.Reports.CreateReport(Info,Rep)
If b Then


Rep.Window.Top = 1440
Rep.Window.Left = 5115
Rep.Window.Width = 14685
Rep.Window.Height = 9420

Rep.TimeZone = "Asia/Tokyo"

Rep.SetProperty "Splits/Skills","1686"

Rep.SetProperty "Dates","-2"

Rep.SetProperty "Times","00:00-23:30"



b = Rep.ExportData("C:\Users\*******\Documents\CMS Data Files\JnJ Multi Skills-ASPAC.txt", 44, 0, True, True, 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

I don't have Avaya with me right now and I never had to run in a different time zone but let me start by asking you is the above code what you see when you open the .acsauto script in a Notepad or is that your VBA code?

What you are seeing is a modified code based on the .acsauto script I opened in a Notepad.

These are the only lines I added into the script in my attempt to set TimeZone;

'## Parameters.Add "Asia/Tokyo","_TimeZone"

Rep.TimeZone = "Asia/Tokyo"

What version of avaya are you using? Can you generate the report with the Asia time zone correctly from the application without automation using manual method?

I am at work now and just had a look at our reports. Even though the Time Zone field appears at the top of some reports it is not available to be selected from the inputs.

Even if I edit an existing report to see where the data for time zone is coming from I get an error saying the field is not available.

I must say I don't know much about this field as I never used it but can it be a read only field that is set on the ACD - it is not something you can choose!