3CX MySQL Integration - Billing Codes

[Waldoppen]

Hi all,
We have a customer using the MySQL integration and whilst this does work - there doesn't appear to be a call journaling option to export the 'billing code':
https://www.3cx.com/docs/sql-database-pbx-integration/

The customer relies on billing codes to tag calls to certain projects. Now we can get the billing code exported in the CDR data, but that doesn't directly import into their database.

Does anyone know a way we can get the billing code exported to MySQL, or a clever way we could use the CDR output and automatically pull this into our database?

Thanks in advance

 

[Evolute IT]

Hi all,
We have a customer using the MySQL integration and whilst this does work - there doesn't appear to be a call journaling option to export the 'billing code':
https://www.3cx.com/docs/sql-database-pbx-integration/

The customer relies on billing codes to tag calls to certain projects. Now we can get the billing code exported in the CDR data, but that doesn't directly import into their database.

Does anyone know a way we can get the billing code exported to MySQL, or a clever way we could use the CDR output and automatically pull this into our database?

Thanks in advance

@VoIPTools

 

[edossantos]

You can create a program to automatically add the information from the CDRs generated in text file to a database.