3CX CDR issue with roommaster

[ATS_Tao]

hi

we have got a set up: 3CX has hotel module enabled, and is passing on cost information to roommaster. current CDR output config is: from-dn, duration, bill-rate, bill-cost, dial-no.
it works 90% of the time, but when a "invalid" number is dialled, the text string passed from 3CX to roommaster becomes:
Call 821,00:00:49,,,32632325855589980

where the 3rd (bill-rate) and 4th (bill-cost) section is just blank.
I understand this is because the call won't be passed on to the SIP trunk as the number is incorrect (the outbound rule is 11 digit , dial 9 first).

this create a problem for Roommaster where it is not able to skip the blanks and reading part of the "dialled number" as "cost". In the above example, the cost is read as £3232.00

Does anyone know how I can get 3CX to change the output to
Call 821,00:00:49,0.50,0,32632325855589980

where 0.50 is rate and 0 is cost.

 

[Cjay]

I am not aware of any way that you could get 3CX to assign bill rate/cost to an outbound call that has essentially failed (probably with termination reason=NoRouteExists, though did your example call really last 49 seconds...?).

On the assumption that you are using an IP connection for CDRs between 3CX and Roommaster, then one possible solution would be be to deploy some 'middleware' that would massage CDRs on the fly to do necessary format conversion. The downside of this is the additional complexity of having another device in the middle, but it works fine and can actually offer more functionality than 3CX alone. I've done this for another hotel and they like the additional charging flexibility and ability to only pass guest room calls on to their PMS.

 

[ATS_Tao]

thanks for helping . yes the example call was indeed 49 seconds. I think there was a toddler in the room and he/she found a new toy! the 49 seconds would just be the PBX saying the number you dialed is not recognized, probably...

Back to the problem itself, I've a support ticket open with roommaster and lets see what they say.

Middleware would be nice but I think the customer has had enough with roommaster and this may just be the last straw