Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Luk on April 22, 2008, 10:32:28 AM

Title: Outbound 7.5 gsw_request_log table
Post by: Luk on April 22, 2008, 10:32:28 AM

Hello gurus ;),

Does any of you know if it is ok to delete records from the table specified in gsw_request_log? For example to delete do not call requests.

Cheers

Title: Re: Outbound 7.5 gsw_request_log table
Post by: victor on April 23, 2008, 12:10:11 PM

I do not see a reason why it should not be OK as long as you do not do some stupid thing with the unique keys. And if you are doing it on a LIVE environment, pay close attention to timestamps and stay away from something that still can be in the system.

Title: Re: Outbound 7.5 gsw_request_log table
Post by: luk on April 23, 2008, 12:43:20 PM

Well, the purpose would be to delete Do Not Call requests that were submitted during a campaign. Those records would be deleted  when campaigns are not running (or even OCS stopped) in order to enable Genesys Outbound to contact the telephone numbers again in new campaigns. Would it be OK this way?
With the timestamp I could delete only records that are older than 1 day for instance (assuming that they are no longer in the system then)...

Will the deletion of records in this table actually enable the phone numbers again??

Cheers

Title: Re: Outbound 7.5 gsw_request_log table
Post by: cavagnaro on April 23, 2008, 12:52:17 PM

Yes it will, OCS before dialing compares the phone numbers with those on that list, if found a match (according to your configuration) it will not dial it, so if you delete it from that list it will be available again for dialing.

Title: Re: Outbound 7.5 gsw_request_log table
Post by: Luk on April 24, 2008, 07:43:59 AM

OK, thank you for your answers guys!!  :)