Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: water235 on February 16, 2017, 05:46:33 PM

Title: Skill Import in Genesys
Post by: water235 on February 16, 2017, 05:46:33 PM

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

Title: Re: Skill Import in Genesys
Post by: cavagnaro on February 16, 2017, 06:01:21 PM

What do you exactly mean or trying to do?

Enviado de meu E6633 usando Tapatalk

Title: Re: Skill Import in Genesys
Post by: water235 on February 16, 2017, 06:54:12 PM

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.

Title: Re: Skill Import in Genesys
Post by: cavagnaro on February 16, 2017, 07:18:33 PM

??? ??? 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????

Title: Re: Skill Import in Genesys
Post by: abudwill on February 16, 2017, 07:22:48 PM

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.

Title: Re: Skill Import in Genesys
Post by: n3vek7 on February 17, 2017, 12:28:24 AM

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

Title: Re: Skill Import in Genesys
Post by: nonny on February 17, 2017, 06:23:59 AM

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

Sent from my SM-N9005 using Tapatalk

Title: Re: Skill Import in Genesys
Post by: Adam G on February 17, 2017, 01:39:45 PM

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

Title: Re: Skill Import in Genesys
Post by: water235 on February 17, 2017, 05:31:03 PM

can you please elaborate more on this pls

Title: Re: Skill Import in Genesys
Post by: cavagnaro on February 17, 2017, 07:06:03 PM

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

Enviado de meu E6633 usando Tapatalk

Title: Re: Skill Import in Genesys
Post by: Adam G on February 17, 2017, 07:11:57 PM

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

Title: Re: Skill Import in Genesys
Post by: RobertH on March 02, 2017, 06:58:23 AM

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