Excel VBA to Create Skilling Script in AVAYA CMS

[a_nika]

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

[tehneXus]

Hi a_nika,

welcome to the forums.

Could you please provide an example excel workbook containing your source data and an example CMS script, at least I have no clue how those scripts look like. Additionally it would be great, if not obvious by the files, you could describe which fields exactly have to be written into the script.

Please remove any confidential information before uploading files here.

Regards

[a_nika]

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]

Hi,

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.

Ok you want to create those scripts.

using parameters like CMS ID, Skill, Skill Level

Where do you get the data from, another file? a piece of paper and you want to enter it manually? random?

Regards

[a_nika]

@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.

[taps]

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

[a_nika]

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?

[taps]

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

[sudhakara]

Hi

we have 10 different skills ,but we dont have any option to give multiple skill in call profile daily report.

I need a help form any one to run the CMS Scrip using only one script by editing the below and add next 10 skill one below the other and we can scheule only one script at time in scheduler

Please Login or Register  to view this content.

[abousetta]

Hello and welcome to the forum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[arlu1201]

Thanks Abousetta.

Also, Sudhakara,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.