Skill Import in Genesys

[water235]

is there a way to import all the skill from Genesys to  a cfg format file, that i can use to re-import ? psdk or something... ?  any pointers pls...

[cavagnaro]

What do you exactly mean or trying to do?

Enviado de meu E6633 usando Tapatalk

[water235]

want to get an export of all the skill(say env1 and put it to env 2)
we are just setting up and we have build our lower lane - so getting to add all the skills manually is way too much. SO just wanted to understand if i can get an import for skills and export them. Like we are able to do for VQ/AG.
Thanks.

[cavagnaro]

Only can think on some SQL script or export to XML using the CC Wizard maybe...but that exports the whole Cfg DB. How you do it with VQ and AG?

[abudwill]

I have written PSDK apps to export/import many types of objects, including skills.

Poor mans easy way to do this is get a reference to the object in question and write its XML to a file.  Then you can copy saved XML file and use your PSDK program to form a new object based on XML and save it in new environment.  Note there are certain items that would need to be scrubbed such as DBID.

[n3vek7]

I recently looked at it and CC Wizard won't be able to export / import a list of skill. You need a custom script.
For VQ and AG, you can import / export a csv file via GA (not 100% sure for CME and GAX).

[nonny]

There are third party (paid) apps that can do it.

Sent from my SM-N9005 using Tapatalk

[Adam G]

This Thread: http://www.sggu.com/smf/index.php/topic,9724.msg44061.html#msg44061

[color=red]***WARNING: NEVER "WRITE" DATA VIA PLSQL TO THE GENESYS CONFIGURATION DATABASE!***[/color]

CREATE VIEW dbo.CFG_AGENT_SKILLS_AND_LEVELS AS
SELECT CFG_PERSON.FIRST_NAME,
  CFG_PERSON.LAST_NAME,
  CFG_PERSON.USER_NAME,
  CFG_PERSON.EMPLOYEE_ID,
  CFG_SKILL.NAME,
  CFG_SKILL_LEVEL.LEVEL_
FROM CFG_PERSON
INNER JOIN CFG_SKILL_LEVEL
ON CFG_PERSON.DBID = CFG_SKILL_LEVEL.PERSON_DBID
INNER JOIN CFG_SKILL
ON CFG_SKILL_LEVEL.SKILL_DBID = CFG_SKILL.DBID

[water235]

can you please elaborate more on this pls

[cavagnaro]

Ermmm
Export data as sql then create a sql routine to import

Enviado de meu E6633 usando Tapatalk

[Adam G]

[quote author=water235 link=topic=10148.msg46015#msg46015 date=1487352663]
can you please elaborate more on this pls
[/quote]

The Oracle PLSQL shown will extract all Skills and Skill Levels to a Database View, when it's run against the cfg database.  If you remove the first line, it will list the same in the Results window, which you can export.

I would not advise using the same method to Import - but at least it's a start.

[RobertH]

Use psdk to do it. Check for option to get object using filters. It is documented in psdk docu. You can easily open connection, get all objects of defined object type. All can be done asynchronously.

Odoslané z D5803 pomocou Tapatalku