AHA!! So THAT's what I was missing!!<br><br>Thanks a lot Adrian!<br><br>d<br><br><div class="gmail_quote">On Wed, Jun 18, 2008 at 2:14 AM, Adrian Georgescu <<a href="mailto:ag@ag-projects.com">ag@ag-projects.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">David,<br>
<br>
When $RatingEngine['split_rating_table'] setting is true, after<br>
changing the rates<br>
in the web interface or by importing them, you must run the script from<br>
scripts/splitRatingTables.php to split the central billing_rates table<br>
into<br>
individual tables for each rate id. You do not need this feature if<br>
you have<br>
less than 100K rates in your system.<br>
<br>
Adrian<br>
<br>
On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <ibc at<br>
<a href="http://in.ilimit.es" target="_blank">in.ilimit.es</a>><br>
wrote:<br>
<br>
> El Monday 16 June 2008 17:44:56 David Villasmil escribió:<br>
><br>
> > But as it happens, when you specify a profile like I did: billing<br>
profile<br>
> > is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED<br>
> > "BILLING_RATES_1", I don't know if cdrtool is supposed to create<br>
it but<br>
> > didn't do it for me. I had to manually create the table:<br>
><br>
> What about if you don't use numeric values as Rate Id?<br>
> I use Rate id with textual value ("Reducida", "Normal"...) and had<br>
not your<br>
> problem.<br>
><br>
<br>
At least in my case, it doesn't find the rate... Same thing, I had to<br>
create<br>
the table...<br>
<br>
without creating the table:<br>
<br>
Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for<br>
callid=<br>
00808260004800068104000005E9 at <a href="http://82.144.106.187" target="_blank">82.144.106.187</a>, billing party=user at<br>
<a href="http://1.2.3.4" target="_blank">1.2.3.4</a>,<br>
customer gateway=<a href="http://1.2.3.4" target="_blank">1.2.3.4</a>, gateway=<a href="http://1.2.3.4" target="_blank">1.2.3.4</a>, destination=1,<br>
profile=Normal,<br>
app=audio<br>
<br>
and then, having created the billing_rates_reducida table:<br>
<br>
Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1<br>
Duration=6<br>
DestId=1 gateway=<a href="http://1.2.3.4" target="_blank">1.2.3.4</a> Profile=Normal Period=weekday Rate=reducida<br>
Interval=0-24 Cost=0.0500/60 Price=0.0050<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.openser.org">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br>