Excel VBA to Create Skilling Script in AVAYA CMS

Hi,

I would like to seek help regarding creating scripts in AVAYA CMS for agent skilling.

I have this task that in a weekly basis I would manually create skilling scripts in CMS for different group of agents with different skill sets.

My logic is since there are agent movements weekly, a excel macro that creates scripts in CMS (interactive script) that would take into consideration the number of agents (since capacity of CMS skilling is only a max of 50 agents), Skill, Skill Priority and also the field in which you wish to mirror other CMS ids. I can't seem to figure out how to start about it.

Any information would be much appreciated. The creation of scripts takes too much time

Here's a sample of the script that I am doing. I don't not have any excel file tho as I'm not sure where to start in this. I want to create something like this using parameters like CMS ID, Skill, Skill Level

'LANGUAGE=ENU
'SERVERNAME=<CMS Server>
Public Sub Main()

'## cvs_cmd_begin
'## ID = 8001
'## Description = "Acd Administration, Change Agent Skills 68544 - Abringe, Kenneth Car"
'## Parameters.Add "Acd Administration","SubSystem"
'## Parameters.Add "Change Agent Skills 68544 - Abringe, Kenneth Car","FormName"
'## Parameters.Add "-1","DummyType"
'## Parameters.Add "-1","DummyAcd"
'## Parameters.Add "1","Action"
'## Parameters.Add "1","SetSk_Acd"
'## Parameters.Add "68544;68611;68616;68624;68524;68547;68534;68571;68572;68575;68597;68600;68577;68602;68604;68588;68567;68589;68591;68574;68596;68599;68581;68610;68582;68607;68608;68586;68604;68567;68589;68591;68581;68597","SetSk_AgentID"
'## Parameters.Add "1","SetSk_CallHandPref"
'## Parameters.Add "0","SetSk_DirectSkill"
'## Parameters.Add "0","SetSk_DirectFirst"
'## Parameters.Add "0","SetSk_ServiceObjective"
'## Parameters.Add "5","SetSk_NumofSkills"
'## Parameters.Add "14","BeginSetSkills"
'## Parameters.Add "682",""
'## Parameters.Add "1",""
'## Parameters.Add "0",""
'## Parameters.Add "0",""
'## Parameters.Add "668",""
'## Parameters.Add "1",""
'## Parameters.Add "0",""
'## Parameters.Add "0",""
'## Parameters.Add "669",""
'## Parameters.Add "3",""
'## Parameters.Add "0",""
'## Parameters.Add "0",""
'## Parameters.Add "663",""
'## Parameters.Add "1",""
'## Parameters.Add "0",""
'## Parameters.Add "0",""
'## Parameters.Add "889",""
'## Parameters.Add "1",""
'## Parameters.Add "0",""
'## Parameters.Add "0",""
'## Parameters.Add "","SetSk_Warning"



On Error Resume Next

set AgMngObj = cvsSrv.AgentMgmt
ReDim SetArr (5,4)
SetArr(1,1)= 682
SetArr(1,2)= 1
SetArr(1,3)= 0
SetArr(1,4)= 0
SetArr(2,1)= 668
SetArr(2,2)= 1
SetArr(2,3)= 0
SetArr(2,4)= 0
SetArr(3,1)= 669
SetArr(3,2)= 3
SetArr(3,3)= 0
SetArr(3,4)= 0
SetArr(4,1)= 663
SetArr(4,2)= 1
SetArr(4,3)= 0
SetArr(4,4)= 0
SetArr(5,1)= 889
SetArr(5,2)= 1
SetArr(5,3)= 0
SetArr(5,4)= 0


AgMngObj.AcdStartUp -1, "", cvsSrv.ServerKey, -1
AgMngObj.OleAgentSetSkill_R16_1 1, "68544;68611;68616;68624;68524;68547;68534;68571;68572;68575;68597;68600;68577;68602;68604;68588;68567;68589;68591;68574;68596;68599;68581;68610;68582;68607;68608;68586;68604;68567;68589;68591;68581;68597",1, 0,0, 0, 5,SetArr, ""


'## cvs_cmd_end

End Sub

@tehneXus

Thank you for your reply.

I get them weekly from another file. But I can easily put them in another file though. The data that the CMS IDs and skills comes from a weekly file being sent to us that comes with a different filename every week. It changes the week date on the file name tho.

I would like to enter them manually tho like in an excel sheet or something.

Hi a_nika,

Please check below two links, may be this is helpful for you.

http://fracta.net/fracta/index.php/f...rvisor-reports

http://www.knowexcel.com/view/132686...excel-vba.html

Long time back I used to work in a call center where I create automated scripts in AVAYA which generate reports in excel format. However, now, I forget all those things as I am not using AVAYA system anymore. But, if you can post screen shot of the AVAYA steps-by-steps procedure then may be I can remember those thing and help you more.


regards
taps

Hi taps,

Here is the screenshot on how I do the scripts manually. I will arrange the skill of the agent then I will click on script and save the .acsup file in a folder.

AVAYA.jpg

I think it would be best to like create an excel file wherein we will input one CMS ID then a range wherein we will put the skills then skill priority and also at the bottom part additional agents that should have the same skills with a maximum of 50 agents. Ideally we only put 30 agents so that the scripts doesn't take too long to run. We don't want the scripts to run automatically but only the creation of the scripts. Do you think it's possible?

Hi a_nika

Thanks for posting screen shot. I can remember few things after looking picture.
We used to generate Real time report and Historical report. From there we generate reorts in Excel format.

Can you please show me the screen shot inside the Script... (Agent Administration).
I hope (as I can remember) there is an option to generate macro like things by giving user id and password and then it will create a short cut like things, where we used to click and get excel report instantly.

regards
taps