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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide