Solved: Clearing Outbound Option Dialing list tables UCCE

brian1mcc · ‎06-04-2009

Hi,

I want to clear all records from the dialing list tables that were imported prior to a certain date. Has anyone tried this before? What is the easiest way to do this?

Will running a sql query on these tables updating all records CallStatusZOne1 and CallStatusZone2 feilds to 'C' (closed) do the job?

Thanks,

Brian

clarkjaso · ‎06-04-2009

Yes this approach would also allow updating the master database with the results of the campaign if necessary.

View solution in original post

clarkjaso · ‎06-04-2009

I would probably perform a query on the database I was getting the dialing list from to narrow the results, then load the list the same each time into the campaign.

brian1mcc · ‎06-04-2009

Ah ... good thinking. So you're suggesting I query the database for the entries i want to keep. Put these in a csv file, then load them overwriting all the existing entries?

A bit of work involved but it looks like a safe option.

clarkjaso · ‎06-04-2009

Yes this approach would also allow updating the master database with the results of the campaign if necessary.

brian1mcc · ‎06-04-2009

Thanks, that seems like a good solution!

Sabiya Tabasum · ‎11-12-2020

can u say what is that sql query to clear the dialing list?

bill.king1 · ‎11-12-2020

Hi, it isn't really a SQL query, but you importing an empty list and then forcing the system to rebuild the list.

Here's a discussion on it here with a link to the Cisco steps that you have to do to set up the purge.

https://community.cisco.com/t5/contact-center/how-to-purge-a-active-accounts-from-the-cisco-dialer/td-p/3084056