XML_CDR

[jdumais]

Hey Guys,

First time poster, thanks for having me... I am wondering if anyone knows where the XML_CDR is generated and if it's possible to add a rate column to the database to be determined as the call begins, perhaps the outbound dialplan ?

Thanks for any help,

James

 

[pbxgeek]

Freeswitch generates XML files, and then a PHP script pulls them into the database. The software is open source, so you can make any modifications you like as long as you know what you are doing.

 

[Adrian Fretwell]

You could set a channel variable in the outbound route. You can see all the channel variables listed in the json field of the xml_cdr. If you are not using the accountcode variable for anything else you could set that in the OB route, accountcode is an actual field in the v_xml_cdr table. Another option would be to generate an event and then capture that event somewhere to log the rate.

 

[whut]

CDR page already has accommodations for custom fields. What is your definition of "rate"? It could be many