System and Network Management

 View Only
  • 1.  System Manager Bulk Import Reliability

    Posted 02-26-2019 03:41 PM
    I'd like to poll the group on their experiences using System Manager Bulk Import for Routing information. 

    We're approaching a multi-quarter activity onboarding existing locations to SIP trunk due to XO retiring ISDN-PRI service in January of 2020.  It will involve the migration of Incoming Trunk Handling Treatment entries from hundreds of trunk groups to Session Manager Dial Pattern and Adaptions.

    Due to the manner in which System Manager handles bulk import, we're required to export existing contents of the adaptation being modified and then add the new entries before we re-import the entire batch.  As time goes on, the size of the import job will be growing larger and larger.

    What has been your experience using Bulk XML Import?

    Has it worked reliably?

    Did you encounter any surprises?  Any Disasters?

    I assume by Version 7.1 it's a mature feature and as long as we don't do silly things like try to upload large files over a glitchy VPN connection things should go well.  Please correct me if I'm wrong!

    Thanks in advance for sharing.

    Tom Lynn

    ------------------------------
    Tom Lynn
    Principal Engineer
    Nordstrom, Inc.
    206-233-5870
    ------------------------------


  • 2.  RE: System Manager Bulk Import Reliability

    Posted 02-27-2019 08:54 AM
    Tom,

    We've used the import tool for routes a few times in the past.  It works.  The issue is always working with the XML data.  There aren't good tools to work with XML (let alone, manipulating it).  Using tools such as IntelliJ or Microsoft Visual Studio Code help, but are still pretty poor at doing large amounts of manipulation.  We ended up having to write a script to work with the data.  

    -Nick

    ------------------------------
    Nick Kwiatkowski
    Director of Design and Engineering
    Michigan State University
    15174322528
    ------------------------------



  • 3.  RE: System Manager Bulk Import Reliability

    Posted 02-27-2019 06:25 PM
    In general, did your script consume the existing XML to some tabular format or database allowing additions, and then issue XML on the resulting set?

    ------------------------------
    Tom Lynn
    Principal Engineer
    Nordstrom, Inc.
    206-233-5870
    ------------------------------



  • 4.  RE: System Manager Bulk Import Reliability

    Posted 02-28-2019 05:44 AM
    Pretty much, yes.  The thing to note though, is our script only took the parts that were important to us, did the manipulation, then pushed it back it (we used the Web Services module in SMGR for automation, instead of uploading a file, which I talked about in my session at IAUG).  Building an XML document in Java (or in our case, ColdFusion) is pretty easy -- but it does bring along the complexity of having to build a script/app to do the work.

    ------------------------------
    Nick Kwiatkowski
    Director of Design and Engineering
    Michigan State University
    15174322528
    ------------------------------



  • 5.  RE: System Manager Bulk Import Reliability

    Posted 03-01-2019 05:33 PM
    Nick, 
    Did you ever post your examples from your 603 session to GitHub?







  • 6.  RE: System Manager Bulk Import Reliability

    Posted 03-03-2019 10:28 AM
    We're going to use Postman to run these dial patterns and adaptations into System Manager.  It can take a CSV file and run  a Post transaction for each line.  Tests can verify that a 200 response is received for each request.  I'm trying to determine if the entity IDs that identify the specific adaptation can change or not?  If it's not a reliable value, then there's some extra checking that needs to be done before each batch.





  • 7.  RE: System Manager Bulk Import Reliability

    Posted 03-11-2019 06:22 PM
    As a follow up, Postman worked very well for this job, which is high volume addition of egress adaptations due to repeated site conversions to SIP.

    It also works well with the AES SMS SOAP API.

    Tom

    ------------------------------
    Tom Lynn
    Principal Engineer
    Nordstrom, Inc.
    206-233-5870
    ------------------------------