" /> Interaction Server 7.6.1 : predefined fields - Genesys CTI User Forum

Author Topic: Interaction Server 7.6.1 : predefined fields  (Read 2180 times)

Offline bounty

  • Jr. Member
  • **
  • Posts: 51
  • Karma: 0
Interaction Server 7.6.1 : predefined fields
« on: June 30, 2010, 04:14:34 PM »
Advertisement
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]

Offline YevgeniyP

  • Jr. Member
  • **
  • Posts: 70
  • Karma: 0
Re: Interaction Server 7.6.1 : predefined fields
« Reply #1 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