Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't get an Avaya CMS Supervisor V17.0 report to run as automatic script. Any suggestions?

Status
Not open for further replies.

tektip011266

Technical User
Sep 18, 2015
3
US
Hello All,

I'm new to the boards and very light with my understanding of Avaya CMS Supervisor, please pardon my ignorance as I muddle through this problem.

The problem is we can MANUALLY run this new report and produce a text file with no issues BUT when we try to create a 'Automatic script (*.acsauto') it won't work. You can open or double click on this Automatic script but nothing much happens and of course we don't have a text file created. We do have 3 automatic scripts that have worked off this Avaya switch and with upgraded versions and have for years but anytime we try to create a new script from a new report we can't get them to run automatically. Ultimately we'll place these jobs in a scheduler. FYI, we left the original reports alone in Avaya that do work but we tried to clone them and add additional fields as needed but this hasn't worked. Additionally we've try to clone the scripts that have worked for years and just substitute the report names as needed, this hasn't worked either.

If it's off any value below is the code with-in this script that won't work, the skill range isn't an issues and they work with other automated jobs:

'LANGUAGE=ENU
'SERVERNAME=t-###-cms2
Public Sub Main()

'## cvs_cmd_begin
'## ID = 2001
'## Description = "Report: Historical: Designer: ###CMD *** Daily Dashboard Data V5: Export Data"
'## Parameters.Add "Report: Historical: Designer: ###CMD *** Daily Dashboard Data V5: Export Data","_Desc"
'## Parameters.Add "Reports","_Catalog"
'## Parameters.Add "2","_Action"
'## Parameters.Add "1","_Quit"
'## Parameters.Add "Historical\Designer\###CMD *** Daily Dashboard Data V5","_Report"
'## Parameters.Add "1","_ACD"
'## Parameters.Add "780","_Top"
'## Parameters.Add "2145","_Left"
'## Parameters.Add "23910","_Width"
'## Parameters.Add "11175","_Height"
'## Parameters.Add "default","_TimeZone"
'## Parameters.Add "The report Historical\Designer\###CMD *** Daily Dashboard Data V5 was not found on ACD 1.","_ReportNotFound"
'## Parameters.Add "*","_BeginProperties"
'## Parameters.Add "1-900","Splitt(s)"
'## Parameters.Add "-1","Date(s);"
'## Parameters.Add "*","_EndProperties"
'## Parameters.Add "*","_BeginViews"
'## Parameters.Add "*","_EndViews"
'## Parameters.Add "K:\%%%\Short_Calls\xx_DTC_***.txt","_Output"
'## Parameters.Add "9","_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\###CMD *** Daily Dashboard Data V5")

If Info Is Nothing Then
If cvsSrv.Interactive Then
MsgBox "The report Historical\Designer\###CMD *** Daily Dashboard Data V5 was not found on ACD 1.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
Else
Set Log = CreateObject("ACSERR.cvsLog")
Log.AutoLogWrite "The report Historical\Designer\###CMD *** Daily Dashboard Data V5 was not found on ACD 1."
Set Log = Nothing
End If
Else

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

Rep.Window.Top = 780
Rep.Window.Left = 2145
Rep.Window.Width = 23910
Rep.Window.Height = 11175


Rep.TimeZone = "default"



Rep.SetProperty "Splitt(s)","1-900"

Rep.SetProperty "Date(s);","-1"




b = Rep.ExportData("K:\%%%\Short_Calls\xx_DTC_***.txt", 9, 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

Any help or suggestions that anyone could offer would be appreciated. My telecom folks are trying to work with Avaya directly on this issue and I've been ask to find other avenues of help.

Thank you.


 

Are you running the automatic script with CMS already open and logged in on the PC and it won't work, or with the CMS application not open?

If you're trying to launch it while CMS is closed, is this a new newly installed copy of CMS Supervisor on this PC?

If it's a new install, did you change the automatic login option in the CMS Application to store the user name and password to run scripts when CMS is not logged into?

I've also run into issues with Windows 7 not launching the automatic scripts when you use Windows scheduler and had to create a .bat file to launch the CMS script and use Windows scheduler to launch the .bat file instead of the automatic script.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius
 
I have the exact same problem, when I double click on the (*.acsauto'), I just get a cmd screen with prompts for terminal and warning for backup, so three times ''ENTER'' then the report goes to the printer??

How can I skip those ''ENTER'' and which line I should add in the script to save the report in a network folder.


Scheduler with .bat works fine, thanks.


Don't follow the cows
 
Ok

I change the printer for a xls file:)

I replace the b=...printer for b = Rep.ExportData("C:\test.xls", 9, 0, True, False, True)

Only one thing left, is to automated the three ''enter'' when the scrip start.

Don't follow the cows
 

Just map the network drive on the pc/server that you are running CMS on and enter the following line after your print line:


b = Rep.ExportData("Driveleter:\Path to directory\reportname.csv", 9, 1, True, False, True)


If you don't have one already, put in the following after this line so it doesn't open a new report over and over and over.

Rep.Quit


If just adding another b= line doesn't work, just copy everything you have from the line cvsSrv.Reports.ACD = 1 to Set Info = Nothing, paste it after the existing Set Info = Nothing line, then change your b= line.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius
 
Both xls and csv work, almost..

In both file, the colum title is missing, I can see all stats with totals but no titles at the botom of each colum.

Idea?

thanksh

Don't follow the cows
 
One of the options to export includes headers, it might be the False in your export True, False, True and you need to change it to True.

You can see what these settings are if you run a report, then run a script output and see what it shows.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius
 
This new script won't run regardless if I'm logged into Avaya on this PC or I'm not logged into Avaya on this PC. Other Avaya scripts (the same switch/Avaya login) on this PC continue to run fine as they have for years.

Below is an example of a slightly different script THAT WILL RUN ON THIS SWITCH, aside from report names and a few other things I can't find any subtle differences from the above problem script:

'LANGUAGE=ENU
'SERVERNAME=t-###-cms2
Public Sub Main()

'## cvs_cmd_begin
'## ID = 2001
'## Description = "Report: Historical: Designer: ###CMD *** Daily Dashboard Data: Export Data"
'## Parameters.Add "Report: Historical: Designer: ###CMD *** Daily Dashboard Data: Export Data","_Desc"
'## Parameters.Add "Reports","_Catalog"
'## Parameters.Add "2","_Action"
'## Parameters.Add "1","_Quit"
'## Parameters.Add "Historical\Designer\###CMD *** Daily Dashboard Data","_Report"
'## Parameters.Add "1","_ACD"
'## Parameters.Add "615","_Top"
'## Parameters.Add "3540","_Left"
'## Parameters.Add "26910","_Width"
'## Parameters.Add "18000","_Height"
'## Parameters.Add "default","_TimeZone"
'## Parameters.Add "The report Historical\Designer\###CMD *** Daily Dashboard Data was not found on ACD 1.","_ReportNotFound"
'## Parameters.Add "*","_BeginProperties"
'## Parameters.Add "1-900","Splits/Skills"
'## Parameters.Add "-1","Dates"
'## Parameters.Add "*","_EndProperties"
'## Parameters.Add "*","_BeginViews"
'## Parameters.Add "*","_EndViews"
'## Parameters.Add "K:\%%%\Short_Calls\DTC_***.txt","_Output"
'## Parameters.Add "9","_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\###CMD *** Daily Dashboard Data")

If Info Is Nothing Then
If cvsSrv.Interactive Then
MsgBox "The report Historical\Designer\###CMD *** Daily Dashboard Data was not found on ACD 1.", vbCritical Or vbOKOnly, "Avaya CMS Supervisor"
Else
Set Log = CreateObject("ACSERR.cvsLog")
Log.AutoLogWrite "The report Historical\Designer\###CMD *** Daily Dashboard Data was not found on ACD 1."
Set Log = Nothing
End If
Else

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

Rep.Window.Top = 615
Rep.Window.Left = 3540
Rep.Window.Width = 26910
Rep.Window.Height = 18000


Rep.TimeZone = "default"



Rep.SetProperty "Splits/Skills","1-900"

Rep.SetProperty "Dates","-1"




b = Rep.ExportData("K:\%%%\Short_Calls\DTC_***.txt", 9, 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

Thanks again.


 
Stinney on your question "If it's a new install, did you change the automatic login option in the CMS Application to store the user name and password to run scripts when CMS is not logged into?"

Is this an issue if all the other scripts for this session already run without any problems? Do I have to continue to code user name and password for every new script I build, shouldn't this be stored when I login to Avaya and created new scripts?

The older scripts have been running fine before we installed V17.0 and continue to run fine. This new script was built under the new install of V17.0... maybe this is the issue?

Thanks


 

Thought I answered this last night, guess it didn't post.

You don't need to set it for every report, if it's set in the instance of CMS Supervisor you're using, you should be fine. I was just asking for clarification of your initial post.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top