Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Silver

Clearing Outbound Option Dialing list tables UCCE

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

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Re: Clearing Outbound Option Dialing list tables UCCE

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

4 REPLIES
New Member

Re: Clearing Outbound Option Dialing list tables UCCE

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.

Silver

Re: Clearing Outbound Option Dialing list tables UCCE

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.

New Member

Re: Clearing Outbound Option Dialing list tables UCCE

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

Silver

Re: Clearing Outbound Option Dialing list tables UCCE

Thanks, that seems like a good solution!

338
Views
0
Helpful
4
Replies
CreatePlease login to create content