asterisk users - Nov 2019 - Low cost routing

Hello, I need some advice:

I use 2 different suppliers of trunk SIP in my infrastructure, both send me
regularly prices in a .csv format.

So I have two SQL tables that contain the prefix and the tariff.

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.

For example

Trunk A:
    +355                0.1698€
    +35521150     0.12815€
    +35521151     0.12815€

Trunk B:
    +355                0.1144€

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

I would like to change that, generate a unique table of prefixes. Someone
would have done that already?

Thank you,
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20191120/c41e0958/attachment.html>

Have a look at A2Billing.


On Wed, Nov 20, 2019 at 4:32 AM Olivier CALVANO <o.calvano at gmail.com>
wrote:
> Hello, I need some advice:
>
> I use 2 different suppliers of trunk SIP in my infrastructure, both send
> me regularly prices in a .csv format.
>
> So I have two SQL tables that contain the prefix and the tariff.
>
> 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.
>
> For example
>
> Trunk A:
>     +355                0.1698€
>     +35521150     0.12815€
>     +35521151     0.12815€
>
> Trunk B:
>     +355                0.1144€
>
> 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
>
> I would like to change that, generate a unique table of prefixes. Someone
> would have done that already?
>
> Thank you,
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20191120/ee609349/attachment.html>