SQL databases CRM integration | Guide

[KaterinaK_3CX]

Integrate your SQL databases CRM system with 3CX in order to:

• Create a new contact automatically when a call is made or received from/to an unknown number
• Have the customer record brought up to you automatically when you receive an inbound call
• Launch calls straight from SQL databases via 3CX, using the 3CX Click2Call Browser extensions

This guide takes you through the steps required to set up your Microsoft SQL Server, MySQL, MariaDB, and PostgreSQL databases with 3CX.

Read the guide.

 

[mryf]

There's no consistent call ID in 3CX. You need to do the matching using CallStart UTC and the agent + caller number.

Thanks for your help. I didn't recognize which field in the CDR file corresponds to the `Agent` field in Call Journaling. For better illustration I've created the following table.

Call Journaling	CDR Records
CallStartTimeUTC	time-start
Agent	?
Number	from-no

 

[Evolute IT]

Thanks for your help. I didn't recognize which field in the CDR file corresponds to the `Agent` field in Call Journaling. For better illustration I've created the following table.

Call Journaling	CDR Records
CallStartTimeUTC	time-start
Agent	?
Number	from-no

In the CDR, you need to compare the Agent to from-no or to-no, as those will depend on the direction of the call. You can use the CallDirection variable to check. Inbound would have the agent in to-no, and vice-versa.

 

[bn tag]

Please some help
I have a website built in PHP Laravel with MySQL Database
I want to add 3xc live chate in my website
and can rescieve and send messages from my web site and stored in the data base ؟؟؟

 

[bn tag]

Please some help
I have a website built in PHP Laravel with MySQL Database
I want to add 3xc live chate in my website
and can rescieve and send messages from my web site and stored in the data base