06-04-2009 05:40 AM - edited 03-14-2019 04:10 AM
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
Solved! Go to Solution.
06-04-2009 08:01 AM
Yes this approach would also allow updating the master database with the results of the campaign if necessary.
06-04-2009 07:50 AM
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.
06-04-2009 07:52 AM
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.
06-04-2009 08:01 AM
Yes this approach would also allow updating the master database with the results of the campaign if necessary.
06-04-2009 08:03 AM
Thanks, that seems like a good solution!
11-12-2020 05:15 AM
can u say what is that sql query to clear the dialing list?
11-12-2020 05:26 AM
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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: