UCCE 7.5.10 - Modify Agent Skill Groups via Database instead of Config or Re-Skill tool?

[RaymonKhan]

Background - We would like to bulk modify agent skill groups on a weekly basis, but have over 400 agents, 3 teams and over 5 skill groups per agent. We are hoping to build a query to modify the tables required to skill an agent properly. We would problably use a .csv file from our fiance dept. to determine skill groups per agent.

Has anyone been successful or know what tables must be updated/inserted to change an agent's skill groups? Is there a hack/workaround to do it using POST/URL in the Cisco Reskill Tool?

Thanks,

Ray Khan

[Gergely Szabo]

Hi,

first of all, don't directly modify the SQL tables, unless you really, really want Cisco stop talking to you.

The only supported way is the bulk edit/insert tool in Configuration Manager.

There is a configuration API (CONAPI) but it's not public anymore. Many good people have been asking Cisco to make it public again or to create a decent API á la AXL - but it seems their position is final.

G.

[david.macias]

I think your best bet is to build agents with specific configurations and then have a reference sheet of what agent to use.  For example, agents that start with 111 are configured as Sales.  Agents that start with 222 are all Support, etc.  Not perfect and the reporting would be messy, but not horrible and less work than what you're trying to accomplish given the current tools we have available.

david

[daniel_downey]

It is about time for Cisco to realize that this is something that their biggest contact center competitor, Avaya offers as a standard feature, out of the box (I'm sure they know it without me pointing it out). This is "old" technology for Avaya.

We are doing this now in our Avaya contact center with a VB Script and scheduled tasks in Windows. Needless to say, it didn't take a developer to set it up. The scheduled tasks run twice per day to "reset" the agents' skills to pre-determined default values. This allows us the spend less time worrying about intraday skill changes, and whether or not any additional skills were removed from an agent's profile. We know that they'll be changed back twice per day.

We essentially have three different configurations based on time of day and day of week: Monday through Friday, 6:00am to 6:00 pm (Business Hours); Saturday and Sunday 6:00am to 6:00pm (Weekend Daytime); and Sunday through Saturday, 6:00pm to 6:00am (Overnights). We would have to have three UCCX skills with time of day routing to every one Avaya skill achieve this in UCCX.

Also, this capability enables us to re-skill our entire call center, or any subset thereof to a predetermined skill-set with a single mouse click.

I'd love to see Cisco allow and support this or similar functionality.




Sent from Cisco Technical Support iPhone App

[jpsweeney77]

Are you still looking for a solution to this problem by chance?