Clearing Outbound Option Dialing list tables UCCE

Answered Question
Jun 4th, 2009
User Badges:
  • Silver, 250 points or more

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

Correct Answer by clarkjaso about 8 years 3 weeks ago

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
clarkjaso Thu, 06/04/2009 - 07:50
User Badges:

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 Thu, 06/04/2009 - 07:52
User Badges:
  • Silver, 250 points or more

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.

Correct Answer
clarkjaso Thu, 06/04/2009 - 08:01
User Badges:

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

brian1mcc Thu, 06/04/2009 - 08:03
User Badges:
  • Silver, 250 points or more

Thanks, that seems like a good solution!

Actions

This Discussion