Modifying Calling list format and Filters - OCS

[cavagnaro]

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

[René]

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.

[cavagnaro]

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

[René]

You're right. My previous advice was useless...

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.

[cavagnaro]

hum yeah! that can help! Thanks René