Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: edobellamy on February 15, 2013, 06:25:48 PM

Title: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: edobellamy on February 15, 2013, 06:25:48 PM

Hi Has any body done PLSQL to parse UData info?
I know I have in the past but I cannot find them,

If you have some it would be greatly apraciated...

regard,

E

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: Kubig on February 18, 2013, 08:36:25 AM

It depends on UData format,but I do not think that anybody from this forum want write SQL code for your proposal and for you. So,try to put a little bit effort

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: edobellamy on February 18, 2013, 08:47:30 AM

Kubig, the posting asked if somebody has code, not if somebody could write, so put a little effort to read the question before posting.

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: Kubig on February 18, 2013, 08:59:38 AM

Ok,in this way I would say "yes"

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: cavagnaro on February 18, 2013, 02:39:19 PM

hahahaha, yes, me too.
Now edobellamy put an little effort on your side and do it too

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: edobellamy on February 18, 2013, 05:53:31 PM

Why reinvent the wheel ???

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: Kubig on February 19, 2013, 09:08:31 AM

Reinvent wheel?! The SQL script which is formating the User datas it's not possible to write in general form,because each environment and related UserData is in different format. Such a script would be so unreasonably robust and in most cases completely useless - logical.

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: edobellamy on February 19, 2013, 09:29:17 AM

The code only needs to to extract the keys and the values from a string, or the value for a key, or return nothing if nothing.
very simple, and I done it before many times. Even from blobs and clobs,  No biggie. Only I don't know what I did with my kv sps.
Thanks anyway.    :)

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: Kubig on February 19, 2013, 09:47:35 AM

You are not right. How would you write general SQL script for KVP pairing,if you did not write from which source/database? KVPs can be stored in a lot of format type and in lot of source (database,WS,file,etc.) . Each point can change dependencies and format of final SQL script.

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: edobellamy on February 19, 2013, 09:56:10 AM

You can get inspired in EVDATA from Call Concentrator, check the BLOB form UCS, cheers

Title: Re: Store procedure or queries to parse KV Pairs list in key1:Value1|... format
Post by: Kubig on February 19, 2013, 10:00:27 AM

I do not want inspiration,I do not need anything,you need it :-) I know,how to format KVP for my customers and needs. I'm done with this pointless debate that leads nowhere.