mysql

  1. MySQL PowerBI Reporting

    Hi all, We have quite a few customers running v20 update 8. We want to provide many of them with PowerBI reporting, but we want the data to be offset in MySQL for technical reasons not relevant here. The PowerBI reports that have been provided so far relate to Microsoft SQL. Our question is...

  2. Setup Database to make a direct call to extension

    I want to set up the following configuration: When one of the extensions calls a client, at the moment the call is made, I need that number that the extension called to be saved in a database, so that when the number calls the landline it is directed straight to the extension that made the...

  3. Chat Journal And Chat Log Not Working.

    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...
    • LRSpartan
    • Thread
    • chat journaling chat logs mysql
    • Replies: 13
    • Forum: Other

  4. Call Journaling to mysql in v20

    Hello, We have been using call journaling to MySQL in v18 and after we upgraded to v20, it doesn't work anymore. The MySQL connection is working and we can search the contact using Select statement however, Insert into statement for call journaling is not working anymore. Are there any changes...
  5. erpardeiro

    Solved How to specify the field in a select statement that retrieves multiple fields?

    Hi guys! I'm running a select query on a database that retrieves 3 fields (idContato, NumeroContato, and StatusContato). Within the CallFlow, I need to retrieve the information for each field, but I'm unsure how to do that. Here's the table: Now, let's take a look at the objects in the...
  6. CISCOX

    CRM: Contact Creation Error MySQL DB

    Hello, I'm having an issue with 3CX CRM and my external SQL database. I can perform queries using the "Test" button and receive a result when manually inserting it into my MySQL database. Call journaling is working fine. Now, onto my problem: Unfortunately, I'm unable to add contacts to my...
    • CISCOX
    • Thread
    • contact creation crm error mysql
    • Replies: 33
    • Forum: Other

  7. How to get the number the client called?

    We have a corporate CMS and 12 different phone numbers that connect via a SIP trunk in 3cx. Numbers are needed to track the advertising channel. We want to receive the following parameters in the CRM database: 1) The number from which the client called 2) The number the customer called (SIP) 3)...
    • Paul03
    • Thread
    • crm integration mysql
    • Replies: 3
    • Forum: Other

  8. Get waiting time on call queue

    How can we get waiting time with call queues? We really need it :-(. Before v18, it worked with MYSQL CRM integrations (like said in another post, we lost several things with the last 3CX version). Like here (waiting time : 4s) : Not anymore, the call is considered picked up as soon as it...
    • MG_VOIP
    • Thread
    • mysql waiting time
    • Replies: 1
    • Forum: Other

  9. CRM MySQL : no more Missed call

    Hi, I have another regression since the June version, on the integration of call journaling in MySQL. Before, we have Inbound, Outbound, Missed and Notanswered in CallType field. Now, we just have Inbound and Outbound. Documentation always indicate having all value for this field...
    • MG_VOIP
    • Thread
    • call journaling crm integration mysql
    • Replies: 12
    • Forum: Other

  10. Call journaling : [Name] empty since july

    Hi, We record the calls in a mysql database, via call journaling. Request : It was working fine but since July the Name field is empty. All calls are well recorded. Before, we had the number or Anonymous, or File+number, etc. Why not anymore? Any idea? Any changein 3CX? Thank you Log ...
    • MG_VOIP
    • Thread
    • call journaling mysql
    • Replies: 16
    • Forum: Other

  11. CRM Integration broken

    Hello everyone o/ Lately my company has updated its 3CX System from V16 to V18. Since that day, 3CX is unable to push data to our MySQL Database (V5.7.26). Testing the connection between those both results in an "SSL Authentication Error". From what I was able to get out of this, I think the...
    • Jadion
    • Thread
    • crm crm integration mysql tls
    • Replies: 1
    • Forum: Other

  12. CDR records into MySQL

    I've seen a few people trying to get their CDR records into a MySQL database. We were looking to do the same so I've knocked-up and open sourced a simple node.js application to do just that. It's my first node.js application so if you know how to do it better than I do then I'd love your...
    • Webslave
    • Thread
    • cdr database mysql sql
    • Replies: 9
    • Forum: Other

  13. CDR / Power BI / MYSQL or PostgreSQL

    Hi all, Needing some help here. Im looking to build dashboards for my clients using Power BI and need the CDR sent to my SQL server as the first step. I’ve tried setting this up via CDR and sending to my database but whatever i do, I can’t get the active connection working. Environment setup...
    • Nikala
    • Thread
    • cdr cdr logs mysql postgresql sql v18
    • Replies: 1
    • Forum: Other

  14. Lost connection to mysql database

    I have CRM integration based on mysql driver. This integration has been working well for v16 for a long time. After updating 3CX to v18, the connection to the database is lost. At the same time, voice applications that use this database stop working. MYSQL database not supported in v18? (sorry...
    • celling
    • Thread
    • crm mysql not working update v18
    • Replies: 30
    • Forum: Other

  15. MySQL Integration - Customer Lookup

    Hi All, I'm attempting to integrate my customer CRM (MySQL) with 3CX so customer names appears on handsets when inbound calls are received. I've managed to connect 3CX to the database and when I perform a test "SELECT" query customer details are found however, 3CX returns an error " CRM...

  16. Problem generating call journey

    Hi, I'm having a little problem creating in the template generator the call journey events are not doing anything. I followed all the material on the site and without success. my generator and the 2.0.14.0 of 2020. my sql script -> INSERT INTO calls...
    • Tiago Lino
    • Thread
    • crm template wizard mysql
    • Replies: 3
    • Forum: Other
  17. g.fiszt

    Save NULL to a database when there's no value inside a variable

    Hello everyone, I have a Survey that stores the answers in a MySQL database and it works most of the times. I store the caller number, the transfering extension and the result of the survey. The problem is that in some situations, I don't have the transfering extension, because the call came...

  18. Access denied for user (using password: YES) - When trying to connect with Database MySQL

    Hi, I am trying to integrate 3CX with Database MYSQL. But it says Access denied for user. I tried creating a new user and then assign it to the database, But still i get the same error. Can someone help me on this! Thanks in advance
    • Jijo_Raj
    • Thread
    • crm integration mysql
    • Replies: 10
    • Forum: Other

  19. Call journaling

    Hi, I am currently integrating the MySQL integration. Everything is working as expected. When a call is finished the call is being inserted into the table 'calls', showing the duration of the call etc. However, if the duration of a call is an hour or more, the call is not being inserted. Below...
    • taco2
    • Thread
    • crm integration mysql
    • Replies: 3
    • Forum: Other

  20. No transfer after readout MySQL query

    For our Support department, I want a service technician to be called on the basis of a date when a customer calls the fault number. In the MySQL, 3cx already selects the number and displays the correct result, but the call is not transferred. Is there anyone who can help me further
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom