Call Journaling x SQL Integration

[MiltonGuimaraes]

Hi There,

I´m trying to setup the call journaling send to SQL the Calls but it dont create any register into SQL.
I made the same setup to contacts and it´s working properly. I know that the contact number must be a CRM a CRM Contact But it dont go.

I have checked in SQL and thereisnt any call from 3cx server. like 3cx dont sent the request.

 

[edossantos]

Hello @MiltonGuimaraes,

You should enable verbose logs from the 3CX Console > Dashboard > Activity Log > Settings. Then make a test call, and finally check the 3cxSystemService.log. Any error will be visible there.

Also, please note that you need a matched contact first during contact lookup, otherwise the call journaling is skipped.

Kind regards.

 

[MiltonGuimaraes]

I made all setup based on the manual.

https://www.3cx.com/docs/sql-database-pbx-integration/

I have also tried

Hello @MiltonGuimaraes,

You should enable verbose logs from the 3CX Console > Dashboard > Activity Log > Settings. Then make a test call, and finally check the 3cxSystemService.log. Any error will be visible there.

Also, please note that you need a matched contact first during contact lookup, otherwise the call journaling is skipped.

Kind regards.

There is no errors on 3cxSystemService.log, I have checked, trying to seach the contact, and it´s there with correct match.

 

[MiltonGuimaraes]

Hello @MiltonGuimaraes,

You should enable verbose logs from the 3CX Console > Dashboard > Activity Log > Settings. Then make a test call, and finally check the 3cxSystemService.log. Any error will be visible there.

Also, please note that you need a matched contact first during contact lookup, otherwise the call journaling is skipped.

Kind regards.

Hi @edossantos , I got it, now is working. were a error on the variable "DurationTimeSpan" must be "DurationTimespan". and the contact number was missing 2 digits.

Now I need register all calls not only calls of CRM contacts, I saw some think about change template.

How I could do it ?

Thanks in advance.

Milton

 

[edossantos]

Now I need register all calls not only calls of CRM contacts, I saw some think about change template.

How I could do it ?

The CRM engine only reports calls for existing contacts. So, in order to achieve this, you just need to ensure that the database returns data for all the lookups, or you should enable the contact creation so a contact is created in the database when not found.