System Manager - Export & Import Dial Patterns and Adaptations xml files

[AuraPS]

Hi,

I have a large number of adaptations to add to system manager for our incoming DDI digit translations on the SIP trunk entity.
I have exported all the routing tables and can see the xml files when I unzip the exported data folder (NRPExportData)

How can I get these xml files in a table format (ie. excel) to add additional adaptation digit translation entries and then save in the correct xml format to import back to SMGR please

Many thanks

 

[bignose21]

Its easy enough to view them in excel but i haven't found a way to get them back.

All I did in the past was write a basic script in Zoc REXX to take values from a CSV and produce the new xml. We had a similar thing where we had to produce a fairly complex dialplan that had hundreds of digit patterns.

 

[AuraPS]

Same result, I can view the adaptations but can't figure a way to save the excel table in the correct xml format. I'm trying to get the table... Or just the digit fields.., out to notepad in the correct xml format so I can copy/paste the text to the adminAdaptation.xml file.

If you have any scripting tools or files your willing to share. It would be much appreciated

Many thanks

 

[bignose21]

So for a terminal program I tend to use ZOC hence writing in Zoc REXX if you have a copy of ZOC I could certainly write a script.

 

[kyle555]

Have you tried sublime text? It's pretty awesome.

Imagine a notepad that lets you put multiple cursors - one on every line, or even more.

So, say I take a list of phone numbers without hyphens in them. Say they all start with 212.

ctrl+f 212, click 'find all'. now you got a cursor on every line. key right 3 times, press hyphen, key right 3 times, press hyphen again, and now you've formatted phone numbers.

I am so bad at programming that I use sublime text to avoid having to learn how to iterate through a loop of script for "every" item in a list of IPs. I just bang out a one liner and let sublime text fill in the blanks on many lines

Get your list of patterns raw, one per line, put a cursor at the start of every line, and just type out the XML syntax by hand once and watch magic happen!

 

[AuraPS]

I ended up extracting the data from the table in excel in to new tabs and then arranging it in to the correct format so I could copy and paste the info needed straight in to the AdminAdaptation.xml file

There seems to be no Avaya instruction or excel template for the 'routing' section in System Manager, like they do for the 'Users' section
It's a bit frustrating as raw xml is no good for adding/amending data and the web interface can be just too cumbersome when there are a few thousands entries to map.

This stuff should be easily importable


Thanks for your replies, much appreciated

 

[jimbojimbo]

You may want to look at the Routing Services API if you program. You might also want to google how to apply an XML schema to Excel or how to convert Excel to XML file/XML Schema.

Took me about 20min to figure out how to connect to the Web Services using VB.net.