Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: abudwill on October 05, 2015, 11:47:46 PM
-
Hi folks,
In the UCS database there are custom columns named StrAttribute1 - StrAttribute10.
Documentation tells me that I can map Business Attributes / Contact Attributes to these custom StrAttribute columns in the database by placing KVPs on the Annex of the business attribute (settings -> is-sortable = true, settings -> is-searchable=true). I have done this and it works great (useful for being able to search for a contact based on one of these custom values).
Does anyone know how Genesys decides which StrAttribute# column to choose when it maps one of the contact attributes?
Example - lets say I have a FirstName and LastName contact attribute, both with the settings -> is-sortable = true, settings -> is-searchable = true. In my prod environment these might map to StrAttribute2 and StrAttribute3. However in my dev environment these might be mapped to StrAttribute5 and StrAttribute7. How is Genesys deciding which column to map these to? Additionally, is it possible for me to change the StrAttribute# column that these are mapped to?
Regards,
Andrew
-
Well, for reference I made this work in a round about way. I will describe below. Am still interested to see if there are answers to my original questions.
I needed the StrAttribute columns in my prod and dev environments to match. This is the reason for my question. To make this happen, I re-initialized the UCS DB in my dev environment. I then added in my Contact Attributes one at a time in the order I needed them. I add the first one, wait a minute, it gets assigned to StrAttribute1, I add the second, wait a minute, it gets assigned to StrAttribute2, etc...
Again, still interested to know if it is possible to change these mappings after the fact.
Regards,
Andrew
-
If you need remap the StrAttributeX attributes, you can achieve it within UCS DB directly, through the Interaction/ContactAttributeMetaData tables (I do not remember the exactly names of these tables). Of course, this must be made while the UCS is stopped.
-
Thanks Kubig. That is the table name. I did see that but wasn't sure if it was safe to modify directly. Thanks for the tip, it will come in helpful in the future!
Regards,
Andrew