[Asterisk-biz] Call termination database

[Paul]

Alistair,

Origination/termination prices can change fast(almost like CPU and RAM 
pricing). Perhaps you can best solve this by having the lister provide 2 
URL's. The first would be a link to current pricing info for the product 
and that can point to anything he wants the end-user to see(html, xls, 
pdf, etc.). The optional second one would be a link to a file formatted 
in a way that you dictate. If the lister provides that file, you can use 
it to automatically update your database. That approach would allow 
canadians to list pricing on their own website in beads or whatever it 
is they use up thataways, but would also give them the option of 
providing pricing that shows up immediately when people do database 
searches.

Another convenience is that the listers don't have to do currency 
conversion. I'm sure there is a good source for daily update of 
conversion factors. You should always save the last pricing fetched from 
a lister in their currency choice. Reason for that is although they 
might not have changed it in weeks, the equivalent in other currencies 
might fluctuate a lot.

I take no credit for the idea. It is primarily based on my understanding 
of the way some shopping portal sites like pricewatch.com maintain their 
database.

Paul


Alistair Cunningham wrote:

> Linus,
>
> I agree that this would be useful. I've got a field in the database 
> for currency, but am not planning to use it for version 1. The problem 
> is not doing the currency conversions; these are easy. The problem 
> updating conversion rates. I really don't want to have to enter data 
> by hand every day.
>
> Does anyone know of a good source for daily automated downloads for 
> currency conversions? If I can get this sorted, multiple currencies 
> could go in version 1.1.
>
> Alistair Cunningham,
> Integrics Ltd,
> Telephony, Database, Unix consulting worldwide
> +44 (0)7870 699 479
> http://integrics.com/
>
>
> Linus Surguy wrote:
>
>>> Alistair Cunningham wrote:
>>>
>>>> Duane,
>>>>
>>>> Yes, this is exactly what I had in mind. I've made a start on this
>>>> today. So far so good, and the only gotcha so far is handling 
>>>> different
>>>> currencies. For version 1, there's probably only going to be one
>>>> currency, most likely USD.
>>>
>>>
>>>
>>> While most minor start-ups may only offer local currency, most
>>> transactions would be available in USD at a guess...
>>
>>
>>
>> That depends on their target market, we are switching large numbers 
>> of international minutes and trade only in GBP, others only in EUR - 
>> there may be quite a large North American bias, but it is not as all 
>> inclusive as you may think.
>>
>> However, if you reduce currency to USD, EUR and GBP you will have 99% 
>> of the providers covered, and then it would be an easy process to 
>> display any rate in all three currencies.
>>
>> Of course, to be truely meaningful for any carrier trying maintain 
>> quality, instead of just purchasing at the cheapest price you then 
>> start to need to classify routes by ASR, codecs, technology, IP 
>> distance etc. and the whole thing gets a lot more complicated!
>>
>> Linus
>>
>> _______________________________________________
>> Asterisk-Biz mailing list
>> Asterisk-Biz at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-biz
>>
>>
> _______________________________________________
> Asterisk-Biz mailing list
> Asterisk-Biz at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-biz