[Spce-user] Upload Fees as CSV

[Barry Flanagan]

On 22 November 2013 12:10, Marc Storck <mstorck at voipgate.com> wrote:

> > here an example:
> >
> >
> > ".","^35542.*$",out,"ALBANIA
> TIRANE","-",5.22,60,5.22,60,5.22,60,5.22,60,0
> >
> >
> > Please be careful:
> >
> > 1. use comma (,) as separator
> > 2. check out double quotes (" ") where there's no need.
> >
> >
> > In attached also a csv example.
>
> I've got this working correctly now.
>
> However somehow my CDRs are rates ~60x higher than expected.
>
>
Rates are per second.....

-Barry Flanagan



> Example:
>
> '655','2013-11-22
> 12:51:23','bd61da3f-ce23-4916-93d7-0eacfa0a11fc','1','','13','','5','vgtest01','sw1.ngn.local','35220123456','0','1.2.3.4','0','2','','','','0','352661123456','mgc.local','352661123456','sw1.ngn.local','661123456','','','call','ok','200','2013-11-22
> 12:49:05.174','2013-11-22
> 12:49:18.760','118.900','b2448f52b369-mqlyiz2zi3oa','ok','2013-11-22
> 12:51:23','0.00','1612.80','Free Default Zone','EU
> -LU-MOB','All Destinations','Luxembourg mobile Orange Luxembourg
> S.A.','0','0','0.00','0.00','','','','','0','0','0.00','','','0','0.00','','','0'
>
> This is my corresponding rate line:
>
> ".*","^352661.*","out","EU-LU-MOB","Luxembourg mobile Orange Luxembourg
> S.A.","13.44","60","13.44","60","13.44","60","13.44","60","0"
>
> As you can see the rate should be 13.44 EURcent. A call of a duration of
> 118.9 seconds should there cost 26.6336 EURcent. Rate-O-Mat says 1612.80,
> which is ~60x off.
>
> What am I doing wrong?
>
> Regards,
>
> Marc
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20131122/14b364a4/attachment-0001.html>