Blog3CX PBX integration with Dolibarr CRM - How to lookup incoming contacts | Exasys

15 Febbraio 2021
Using 3CX as your Cloud PBX ? Great !
Using Dolibarr as your Cloud CRM ? Great !
Needing them to talk each other ? Nothing on the web helping you.
But Wait ! Here we are to help you.
Here below we will show quick and easy steps to let 3CX lookup contacts in your Dolibarr and get customer cards during incoming calls.
What do you need ? Access on Dolibarr, 3CX and the 3CX template generator.
Let’s start !
https://exasys.it/wp-content/uploads/2021/02/3CX-crm-generator-wizard.jpg
First step is creating a user on Dolibarr, say it pbx_user, having access on Third Parties. It just needs to read and export.
Don’t forget to set a Key API and take note of it.
Next step is creating the CRM template descriptor using the right values and import in your 3CX.
The key is using the path described here:
https://[YOUR_DOLIBARR_DOMAIN]/api/index.php/thirdparties?DOLAPIKEY=[APIKEY]&sqlfilters=(t.phone:like:’%[Number]%’).
That’s all! Let’s go quickly throughout all the steps.
https://exasys.it/wp-content/uploads/2021/01/1.1.jpg
Create pbx_user
Dolibarr, create new user called pbx_user. Assign read and export permissions on Third Parties. Take note of the Key for API.
https://exasys.it/wp-content/uploads/2021/01/2.jpg
Generate CRM descriptor
As described here generate your CRM template descriptor.
https://exasys.it/wp-content/uploads/2021/02/3CX-crm-generator.jpg
Just run the executable and select File > New CRM Template Generator Wizard
You will be guided throughout the steps.
Set Authentication with API Key.
https://exasys.it/wp-content/uploads/2021/01/3.jpg
Set the API URL
Lookup needs to be set as follows https://[YOUR_DOLIBARR_DOMAIN]/api/index.php/thirdparties?DOLAPIKEY=[APIKEY]&sqlfilters=(t.phone:like:’%[Number]%’).
https://exasys.it/wp-content/uploads/2021/02/3CX-crm-generator-path.jpg
Just to be clear:
This is the API path to query Customer entries in Dolibarr
https://[YOUR_DOLIBARR_DOMAIN]/api/index.php/thirdparties
This will pass the APIKEY of the pbx_user
?DOLAPIKEY=[APIKEY]
And this will just fetch the incoming number
&sqlfilters=(t.phone:like:’%[Number]%’).
https://exasys.it/wp-content/uploads/2021/01/4.jpg
Save and Import
Go to 3CX “Management Console” > “Settings” > “CRM Integration” > “Server side” tab and click “Add” to upload your template to 3CX.
On incoming calls, the incoming caller ID number is queried against the Dolibarr CRM, and if a match is found, it is displayed in the 3CX Web Client.
https://exasys.it/wp-content/uploads/2020/06/logo-320x122.png
https://exasys.it/wp-content/uploads/2020/06/logo.png
Informazioni

Interessato ? Inserisci la tua email oppure il tuo numero di telefono. Ti contatteremo presto.

Presa visioneInformativa Privacy

Exasys S.r.l. via Fondicello, 46/48 – 70026 Modugno (Bari)
PI 07563240725. REA BA-566625. Registro imprese di Bari – Sezione ordinaria – Cap. Soc. € 50.000 i.v.