cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

221
Views
0
Helpful
3
Replies
Highlighted
Beginner

BAT Import/Export to change Partition for Routing Patterns

Hi,

 

I'm using the Import/Export utility in BAT to change the partition on a large number of route patterns, but instead of just updating the existing route patterns, it's duplicating them.  I understand there may not be a unique ID for route patterns, and because same route patterns in different partition are an acceptable configuration, the system does not complain.  But is there a way to avoid adding the partition, and instead just udate the partition field only?  Thanx!

3 REPLIES 3
Highlighted
VIP Advisor

Re: BAT Import/Export to change Partition for Routing Patterns

Not using Import/Export. You need to use AXL for that.
Highlighted
Beginner

Re: BAT Import/Export to change Partition for Routing Patterns

Hi Mohammed,

 

I'm not a programmer, looked into AXL, seems great, but not something I can pickup in next day or so.  Is there a guide that explains how to use it for my specific purpose that you can reference?  Any guides or info on the matter would be greatly appreciated, thanx.

Highlighted
VIP Mentor

Re: BAT Import/Export to change Partition for Routing Patterns

If AXL is not looking like an option for you, you could try SQL on the CLI of the Publisher.

 

In this example, we're updating all 600X patterns in the Old-PT partition, to be in the New-PT partition.

 

run sql update numplan set fkroutepartition = (select pkid from routepartition where name = 'New-PT') where fkroutepartition = (select pkid from routepartition where name = 'Old-PT') and dnorpattern matches '600[0-9]'

Anthony Holloway
CreatePlease to create content
Content for Community-Ad
Future of Work Virtual Summit Day 5

Cisco COVID-19 Survey