Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: databit on July 01, 2009, 10:55:58 PM

Title: Call flow documentation
Post by: databit on July 01, 2009, 10:55:58 PM

First I'll start out apologizing for not searching thoroughly for an answer...
Problem is I have no idea what to search for, I'm an Aspect guy not a Genesys guy.
So here is what I'm trying to do, I need to build a document that has the following:
TFN, DNIS, CCT, Welcome Greeting, Queue announcements, Closed announcement, Meeting announcement and Holiday Announcement
I can pull TFN, DNIS, CCT from the Aspect ACD's back end database pretty easily. But the rest is controlled by Genesys. The Genesys admins here gave me access to Config manager but that is such a tedious process. Tools -> Find -> DN ->enter cct number. Double click routing -> click Annex -> double click _ROUTER_ -> Re type everything under name/value because I can't copy out and paste into excel.
It's even tedious to type the process :)
So they gave me the TNS entry and login for the back end oracle database. They didn't know the answer and looking through the schema I can't find it but here is the question.
Is there a SELECT query that I can run that will pull DN, everything in the Annex section of the config manager. Preferably all in 1 record but if each DN has to have a record for each seperate annex entry then I can handle that as well.

One would hope this would be easy but I dunno where to start :-/

Title: Re: Call flow documentation
Post by: mark on July 02, 2009, 09:18:56 AM

I am sure it is possible, I did something similar (with help from here) in Brio. Pulled back the config tables and found the DN table, linked it to the config_options and pulled back the router section.
I'll see if i can find some more information than that for you!

Also, you should be able to export from the DN in CME. Export to a cfg file, open and copy contents to excel :]

Title: Re: Call flow documentation
Post by: databit on July 02, 2009, 04:20:23 PM

Ya I saw an option to export for individual DNs last night. But even at that 4 or 500 becomes a hassle.

I was browsing through the schema and I found the CFG_DN table but couldn't find a config_options table anywhere.

Title: Re: Call flow documentation
Post by: databit on July 02, 2009, 05:39:44 PM

I just found this with searching http://www.sggu.com/smf/index.php/topic,565.0.html

Is there a CME Export wizard that does the same thing just in reverse?

Title: Re: Call flow documentation
Post by: René on July 02, 2009, 06:18:10 PM

Hi,

Below is SQL code that allows you to retrieve list of all options stored on Annex tab in the section "__ROUTER__". Format of the output is:

  <Routing Point Number> | <Property Name> | <Property Value>

[code]SELECT dn.number_ AS DN,flex2.prop_name,flex2.prop_value
FROM CFG_DN dn
LEFT JOIN CFG_FLEX_PROP flex1 ON flex1.object_dbid = dn.dbid
LEFT JOIN CFG_FLEX_PROP flex2 ON flex2.parent_dbid = flex1.dbid
WHERE dn.TYPE=4 AND flex1.prop_name = '__ROUTER__'
ORDER BY DN,flex2.PROP_NAME[/code]

Hope it helps you :)

R.

Title: Re: Call flow documentation
Post by: databit on July 02, 2009, 06:53:20 PM

René...I love you... :)

I just ran it and it looks like it saved me a few days of work. Much much help

Title: Re: Call flow documentation
Post by: cavagnaro on July 02, 2009, 08:24:14 PM

Woo...love is in the air

Title: Re: Call flow documentation
Post by: Fra on July 03, 2009, 09:43:17 AM

lol

great and very useful code.

Fra