Modifying Calling list format and Filters - OCS

Hi guys,
I need some advice here, I have a customer who has several calling lists and many dialing filters. Now he is requering to add two new fields to this format and so in order to do that I have to delete calling lists, table accesses and dialing filters, everything is ok but this customer has like 50 dialing filters…so it would be a pain and a waste of time deleting all of them and recreating again. I thought on maybe backup the SQL data and then reimport however does any have another idea or maybe some problem with my idea? I’d appreciate any input.
Thanks

Hi Cavagnaro,

These kind of changes are usually painful ;). I have one idea:

  1. Create new Table Access (=different name) using new Format but having the same database table name as old one
  2. Modify calling list object to use new Table Access

It think it should work… but it will necessary to delete old calling list tables in the database.

R.

2 Likes

Will try, calling lists are not the problem but dialing filters are… have counted and are like almost 100 :o I don’t want to waste a complete day on something like this!

You’re right. My previous advice was useless… :frowning:

I’m not a fan of such modification but it should be possible to change calling list assigned to a filter directly in configuration database. Such change will require restart of Configuration Server.

Look at the table “cfg_filter” in configuration db. It contains column “format_dbid” that holds DBID of particular Format object (see table “cfg_format”).

Hope it helps you
R.

1 Like

hum yeah! that can help! Thanks René ;D