[OpenSIPS-Users] CDRtool loading data from Asterisk and multiple profiles

[Adrian Georgescu]

I tried to understand what you ask but I could not.

Nevertheless, the rating logic is described here in detail if you care about reading:

http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/RATING.txt

Adrian

On Nov 8, 2012, at 10:18 AM, Adria Vidal wrote:

> I'm performing some CDR rating with CDRtool, and would like to have multiple ratings depending on domain or customer.
> 
> customers table
> 
> id reseller_id gateway domain subscriber profile_name1 profile_name1_alt profile_name2 profile_name2_alt timezone increment min_duration
> 11 0 domainA.net domainA_default grn_premium domainA_default grn_premium Europe/Amsterdam 0 0
> 18 0 domainB.net grn_premium grn_premium Europe/Amsterdam 0 0
> 17 0 62890009 at domainA.net linea900_profile grn_premium linea900_profile grn_premium Europe/Amsterdam 0 0
> 
> 
> asterisk_cdr table
> 
> id src dst calldate clid dcontext channel dstchannel lastapp lastdata duration billsec disposition amaflags accountcode uniqueid userfield DestinationId Rate Price Normalized
> 41800 62890000 34699980125 2012-10-01 17:27:47 62890000 0 373 0 0 0 346 Duration: 373 s
>         
> Only using domainA.net at dcontext i get correct rating, everything else is rated as Default with 
> 
> ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346 default Profile=linea900_profile Period=weekday Rate=linea900 Interval=0-24 Cost=0.4568/60 Price=2.8398 PriceIn=0.0000
>  
>  
>  after putting in dcontext domainA.net i get
>  
>  ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346 domain=domainA.net Profile=domainA_default Period=weekday Rate=domainA_default Interval=0-24 Cost=0.0900/60 Price=0.5595 PriceIn=0.0000
>  
>  
>  and trying with the secondary domain domainB it's ignored and rated as domainA.net
>  
>  ConnectFee=0.0000 CallId=41800 Span=1 Duration=373 DestId=346 domain=domainA.net Profile=domainA_default Period=weekday Rate=domainA_default Interval=0-24 Cost=0.0900/60 Price=0.5595 PriceIn=0.0000
>  
>  Tried too using domain at src user@
>  
>  
>  There is some way to get diferent rates from these data?
> 
> --
> 
> Adrià Vidal Romero
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121108/a48ae005/attachment.htm>