Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: bounty on June 30, 2010, 04:14:34 PM

Title: Interaction Server 7.6.1 : predefined fields
Post by: bounty on June 30, 2010, 04:14:34 PM

Hello,

We are trying to migrate from 7.6.0 to 7.6.1.
Can someone explain me the sentence that I found in the SQL update script : isdb_mssql_7.6-7.6.1.sql

I applied this script ! now I am not able to see some fields in Genesys Desktop for old interactions. New interactions are OK and have all the field filled !

I really don't understand what I have to [u]uncomment[/u] ! If I uncomment some lines, the SQL script is not valid anymore...
What happens with old interactions ?

Thanks

[code]
...

-- REMOVED fields
-- 7.6.1 - Attention! since 7.6.1 there is an ability to add custom fields to the table
-- so these predefined fields are not necessary unless really used in workflow definition
-- please review and uncomment only definitions for fields that are needed, then
-- create definition of custom properties in InteractionCustomProperties enumerator
-- if the field is not created, correspondent interaction property will be saved in
-- the 'flexible_properties' filed

-- contact_id varchar(16),
-- customer_segment varchar(64),
-- service_type varchar(64),
-- category varchar(64),
-- case_id varchar(64),
-- reason_code varchar(32),
-- disposition_code varchar(32),
-- from_personal varchar(256),
-- from_address varchar(256),
-- mailbox varchar(256),
-- subject varchar(512),
--
-- custom properties; translated according to tenant defined dictionary
-- custom_1s varchar(256),
-- custom_2s varchar(256),
-- custom_3s varchar(256),
-- custom_4s varchar(64),
-- custom_5s varchar(64),
-- custom_6s varchar(64),
-- custom_7s varchar(64),
-- custom_1n numeric(28),
-- custom_2n numeric(28),
-- custom_3n numeric(28),
--

[/code]

Title: Re: Interaction Server 7.6.1 : predefined fields
Post by: YevgeniyP on July 08, 2010, 05:31:18 AM

This fragment is a copy from initialization script. So here it's for information only. Nothing to uncomment.
To see old interactions you probably need to configure mapping of columns excluded from 7.6.1 by default onto user data in IxnServer configuration. See docs for details.

YP