Question about custom crm integration

[MAHBV]

Hi Guys,

I've bin playing around for like a week now, and there is this one thing that's giving me a hard time.

Let me quickly explain the situation.

We're running a custom PHP / MariaDB (Centos7) CRM.

At this moment we're running 4PSA(Voipnow) and all calls are logged in our database.
When somebody calls a pop-up is showing in our CRM and when one of our agents hang up the phone, the pop-up also dissappear.

Here comes the issue:

I think i got like 90% ready of this custom integration. I've created a inbound callflow with CFD. So when someone is dialing our number it's getting reported to our database-> (result from client lookup) (caller) (called number)

The only thing i'm not getting is when a agent hangs up the phone, our database needs to be updated with the stop time of the call.


I know there is this CRM integration option to update MySQL, but because of the call-pop-ups it has to be inserted directly and not afterwards.

Are there any way to arrange that the inserted row from the CFD getting updated as soon as the agent hangs up the phone?

Thanks!

 

[edossantos]

From the CFD app you're transfering the call to the agent (or queue), so you lose control of the call when that happens. As a result, you can't do this from the CFD app.

Maybe you need a combination or CFD and CRM. You mark the call as started from the CFD app, and you mark the call as ended when using the Call Journaling feature of the CRM integration with databases:
https://www.3cx.com/docs/sql-database-pbx-integration/

Please note that Call Journaling with databases only works when the lookup resolves to a contact, so maybe you can use the technique mentioned here to force call journaling for every call:
https://www.3cx.com/community/threads/call-journaling-doesnt-work-in-sqlserver.65807/