On 10/05/11 6:28 AM, A E [Gmail] wrote:
Hi All,
new to the list. Wondering if anyone has / knows of, a good rate
importer tool that can be used to standardize and normalize the
ratesheets / rate decks etc. obtained from various carriers so they can
be analysed and imported into a DB or be saved as a CSV or something?
We've done it, but just for our ITSP platform.
Even then, it still can require tweaking.
We provide an Excel import field.
The system imports the Excel file and shows the fields on screen for the
first few rows.
It then asks you what field contains: Dest Name, Dest Number and Rate.
Once it's done that it asks you for any tweaking of the numbers required
from E164 formatting (i.e. some providers expect you to dial 00XX where
XX is the international code, others require 011XX etc etc.
It then asks you for an across the board markup on their rate and what
the currency is.
There is an option to update exchange rates.
It's a pretty complicated system but works.
We maintain buy and sell rates and there is an option to convert between
them when you import new buy rates - although the buy rate might change
because of route issues, the sell rate always stays the same. The sell
rate is different for different rate plans.
I'm not sure how useful our code would be for anyone else as it is just
formatting the data for use by our LCR + Weighting AGI scripts, but I'd
be happy to provide anyone else with assistance if they're looking at
writing one.
--
Cheers,
Matt Riddell
_______________________________________________
http://www.venturevoip.com/news.php (Daily Asterisk News)
http://www.venturevoip.com/exchange.php (Full ITSP Solution)
http://www.venturevoip.com/cc.php (Call Centre Solutions)
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-biz
