sql

  1. SQL INTEGRATION - unanswered outgoing calls

    Good morning everyone, I have an installation that has CRM integration to MySQL active that I use to send data via api from the call log. All calls are correctly sent to the database EXCEPT the unanswered outgoing calls. Why? This is the query I use in the Call Journaling SQL Statement INSERT...
  2. cantvchicago

    Database Access Tool for SQL integration

    Hi All, Attempting to output CallerInput.Buffer to a new record in a table in my SQL back end... with NO luck. My flow ends with a WebService REST POST of the data to another server for further processing which works great. My problem starts with the Database Access Tool... It just does...

  3. automatic and periodic contacts import from mssql database

    Hello Everyone, I have some confusion on how 3CX Sql integration works: I have been told that in 3CX it's purpose is for adding contacts in a SQL db when receiving the call. But all I want is to let the customer search on his Own DB I have red this guide...
    • tecnotel1
    • Thread
    • mssql mssql integration sql
    • Replies: 5
    • Forum: Other

  4. Custom Integration Call Type Values not correct

    Hello, I have implemented a custom integration to report calls, using the provided XML template and SQL Statement. However, calls which should have had CallType = 'Unanswered' or 'Missed', seem not to be logged. Any idea what is happening? Template: <?xml version="1.0" encoding="utf-8"?>...

  5. 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

  6. 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

  7. CFD SQL communication

    Hello, I'm in troubles because I will make a call flow but the communication to SQL server will not work, I think. For information: I will make a call flow for our hotline, so at office hours the call will forwared to our main number. At Out-Of-Office-Hours the customer should type his...

  8. CRM Integration - Import all Contacts from SQL

    I'm using the (My)SQL CRM integration to synchronize contacts between an ERP and 3CX. But contacts are only imported to 3CX once they call in. Is there any way to import all contacts from the SQL DB? My users would like to find all contacts via 3CX to call them, not just ones who already called in.
    • SKDamon
    • Thread
    • contact crm sql
    • Replies: 5
    • Forum: Other

  9. Call Journaling x SQL Integration

    Hi There, I´m trying to setup the call journaling send to SQL the Calls but it dont create any register into SQL. I made the same setup to contacts and it´s working properly. I know that the contact number must be a CRM a CRM Contact But it dont go. I have checked in SQL and thereisnt any...
    • MiltonGuimaraes
    • Thread
    • call journaling contacts crm integration sql
    • Replies: 4
    • Forum: Other

  10. How lookup inbound caller ID in Database

    Hi, I\m making a project on CFD and I want to lookup any inbound calls that I get on sql server database and I want to make sure if the inbound number is listed in database, route the call to VIP Menu, if not listed in database, then route the call to Customers Menu . I attached the project and...
  11. Eder Pardeiro

    SQLServer: How to connect and use?

    Hi, I'm trying connect and execute (INSERT, DELETE and UPDATE), but don't have success. The project compiles without any errors, so I upload to the queue, when I call the queue everything works fine, but nothing happens in the database. See an example of SQL Statement and print running an...

  12. Recording Path Location In Database sometimes null postgresql

    Hello I am using 3CX system at work to get the recording path of the file that is being recorded. I have managed to find one source of the recording path where the file name is being stored. This is located in the cl_participants table. However this field sometimes comes null for certain record...
  13. Anderson Echeverri

    Call Flow Designer SQL Connection

    Hello, I am trying to connect the results of a request for numbers in a SQL database but this database has a different port published on the internet, when performing the insert in the DB I get the following error: 7/17/14 19: 42: 41.112 | 100030 | Err | 10 | 0014 |: PlugIn [Survey - Callflow -...
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom