Clearing Outbound Option Dialing list tables UCCE

Answered Question
Jun 4th, 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

Correct Answer by clarkjaso about 7 years 8 months 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

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

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

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

Actions

This Discussion