Chat Journal And Chat Log Not Working.

[LRSpartan]

I have been working on a mySQL CRM integration and having trouble with the chat journal integration and while troubleshooting discovered chat log isn't working either. I have 'Chat Log' enabled on the admin console dashboard. Both Call Journaling and Contact Creation Directly to CRM are working per https://www.3cx.com/docs/sql-database-pbx-integration/.

I am using a very basic INSERT statement as a start but still no entries. INSERT INTO chat_journal (number, name, email, chat_message) VALUES (@number, @Name, @Email, @ChatMessages);
What is odd is the statement isn't showing up in the mySQL logs. The call journal and contact creation do. I have the two contacts both email and mobile that I am testing on in the contacts table. My method of testing is via SMS. I am able to text between the two contacts. Calls between the two contacts show up in the call journal. I am not sure what I am doing wrong and would appreciate any help! I suspect the chat log might be part of the problem too.

I am a 3CX novice...actually my job is marketing but I know a little about technology...I think.

Thank you,
John

 

[Evolute IT]

What is the type of field for the chat_message?

 

[LRSpartan]

What is the type of field for the chat_message?

I have it set to text. There are no not null or other constraints on the table at this time. Just want to get a first record inserted then adjust.

 

[LRSpartan]

So I figured out the issue. I had to mark the chat as 'Dealt with'. For compliance purposes, we are needing the entries to flow through without the end-user intervention. Is there a way to get around this limitation?

 

[Evolute IT]

So I figured out the issue. I had to mark the chat as 'Dealt with'. For compliance purposes, we are needing the entries to flow through without the end-user intervention. Is there a way to get around this limitation?

Nope

 

[edossantos_sipcaller]

So I figured out the issue. I had to mark the chat as 'Dealt with'. For compliance purposes, we are needing the entries to flow through without the end-user intervention. Is there a way to get around this limitation?

No, chat journaling is only triggered when the chat is dealt with.

 

[Evolute IT]

No, chat journaling is only triggered when the chat is dealt with.

Can they use the auto-close feature for this? Does it mark as dealth with or only archive?

 

[LRSpartan]

Is there any way to export all chats say daily? Automatically preferred.

 

[LRSpartan]

Can they use the auto-close feature for this? Does it mark as dealth with or only archive?

Interesting idea!

 

[edossantos_sipcaller]

Can they use the auto-close feature for this? Does it mark as dealth with or only archive?

No, only "Dealt with" triggers the chat journaling. The auto close just closed the conversation, but it will not be logged in that case.

 

[edossantos_sipcaller]

Is there any way to export all chats say daily? Automatically preferred.

No, and chats are not available through the Call Control API either, so there is no way to export them. They're in the 3CX database, but accessing it is not allowed and not recommended.

 

[LRSpartan]

Thank you for your help!

 

[Evolute IT]

Is there any way to export all chats say daily? Automatically preferred.

You could use the XAPI ReportChatLogs endpoint (the one used in the Reports > Chat Log page.)

 

[dkrilcic]

@LRSpartan - if you still need this functionality, you should try what ConceptsWeb suggested. I did not yet try that endpoint, but you can find a very similar PowerShell example here:

https://github.com/luxzg/3CX-XAPI_examples

I got really nice call report logs with it, might help in your case as well.