<div dir="ltr">Have a look at A2Billing.<br><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Nov 20, 2019 at 4:32 AM Olivier CALVANO <<a href="mailto:o.calvano@gmail.com">o.calvano@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><p class="MsoNormal"><span lang="EN-US">Hello, I
          need some advice:</span></p>
      <p class="MsoNormal"><span lang="EN-US">I use 2 different
          suppliers of trunk SIP in my infrastructure, both send me
          regularly prices in a
          .csv format.</span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="white-space:pre-wrap">So I have two SQL tables that contain the prefix and the
tariff.</span> </span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="background:rgb(248,249,250)"><span style="white-space:pre-wrap">For now, I generate a dialplan with a Perl script that allows
me to select the prefix trunk to use but the problem is that I change it
manually in some cases</span>.</span></span></p>
      <p class="MsoNormal"><span style="background:rgb(248,249,250)" lang="EN-US">For example</span><span lang="EN-US"></span></p>
      <p class="MsoNormal"><span lang="EN-US">Trunk A:<br>
              +355           
              0.1698€<br>
              +35521150     0.12815€<br>
              +35521151     0.12815€<br>
          <br>
          Trunk B:<br>
              +355           
              0.1144€</span></p>
      <p class="MsoNormal"><span lang="EN">Currently my script sees that +35521150 exists
          in Trunk A and will
          therefore use it while on the Trunk B it is less expensive but
          the prefix
          +35521150 is not directly indicated since it is covered by the
          +355</span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="background:rgb(248,249,250)"><span style="white-space:pre-wrap">I would like to change that, generate a unique table of
prefixes. </span></span><span style="background:rgb(248,249,250)">Someone would
            have
            done that already?</span></span><span lang="EN"></span></p>
      <p class="MsoNormal"><span lang="EN-US">Thank you,</span></p></div>
-- <br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
      <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wiki/display/AST/Getting+Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
   <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></blockquote></div>