×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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

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

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.

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

(OP)
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 smile

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

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.

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

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!

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

(OP)
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

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

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close