MSSQL integration - internal calls logging

[alex.filip]

Hi, I need help regarding call forwarding to MSSQL database. The insert from the official 3CX documentation works, but internal calls are not being inserted, e.g., 000 -> 001. Only external calls (073664632@Number -> 001@Agent) are being inserted. Is there any variable for the internal number (the one making the call)?

Also, is there a variable for the name of the attachment being sent?

Thanks!

 

[Evolute IT]

Internal calls are not included in the CRM integration. There's no way to change that.

 

[VoIPTools]

You would need to create a custom integration. If you don't need to perform screen pops, then this could be a server-side service using the Call Control API.

 

[alex.filip]

Thank you for your response! I don't need to perform screen pops, just logging internal calls. Based on that we can do some other integrations for other systems.

 

[Evolute IT]

You may want to use the reports or something like that, or the CDR, to read call data directly. @VoIPTools has an excellent Relay module for that.

 

[thpan]

How 3cx can insert to a (crm) mssql database?

 

[Evolute IT]

How 3cx can insert to a (crm) mssql database?

You can use the CRM database integrations to send the call report to a db.

 

[edossantos_sipcaller]

Here you have the guide:
https://www.3cx.com/docs/sql-database-pbx-integration/