database

  1. CFD contact lookup with internal database

    Hello Community, i'am new to the 3CX Call Flow Designer and would like to ask if it is possible to lookup the incoming ani with the local (contact) database. So i can send an email with the contact data and not just the number (ani) Maybe i just overlooked the option, unfortunately i didn't...
  2. GoDaddy MySQL Database Connectivity

    Hello everyone, I'm a little new to all this but I was hoping to see if anyone happened to know or have tried connecting their CFD to a GoDaddy MySQL database with the Database Access component. I don't believe its been connecting for me. If anyone happens to know please let me know and thank...
  3. Modify MailTemplates from files

    Hi all, ;) I've modified our MailTemplates by the 3CX web interface of our server and I would like to push the modifications to all our servers. We have something like 20 3cx servers all on cloud and hosted by OVH. Like I've found a file named...
  4. Documentation 3CX Database

    Hi All, Is there any documentation about the setup of the 3CX database. I am trying to figure out what the retrieved data from the database is for visualisation purposes. I have tables like cl_calls, cl_segments, cl_participants. Is there any documentation (with descriptions about the data...
  5. Gunes Erdemi

    myphone callhistory V14 table

    Hello, We analyze 3cx Postgresql Database, We understand if myphone callhistory V14.calltype is 2; it means inbound. if it is 3 outbound. What does it mean if it is 1?
  6. Access to calls database or API access to logs?

    Hello, Is there are way to access the call logs via API or any other means that does not involve logging into the admin dashboard? The aim is to generate reports on our own intranet website. Thus a file download/email is not suitable.
  7. Missing caller name via ODBC on first call

    Just configured contacts via odbc. This works so far, when a call comes in, the database is queried and a contract is generated. The problem is only, on the first call of this number, only the contact is generated but the caller id name is not shown on the phones, only the caller id number...
  8. CDR to MYSql Database

    is it possible to add cdr call logs to a mysql database . i need to show these call logs on my webpage.But we cant put it in a local textfile since the company we do a project for can't do it that way or doesn't want it that way
  9. CDR to database ?

    I have already posted a thread asking about how to get call logs out of 3cx. As answer i got ' have you tried cdr ' . I don't understand this very good but is it only possible to get the call logs on a textfile ? We need to make a webpage that shows these call logs averages per week plus show...
  10. 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...
  11. Access Voicemail Database on Linux

    All, I'm trying to build my own voicemail manager on Linux for easy web access similar to what voiptools has (too bad it's only for windows). What is the best way to access the voicemail database?
  12. Table cl_participants

    Hi all, Does anyone know the meaning of the different values of field failure_reason in table cl_particpants? Or even better, an explanation of the database layout? We're running version 15.5 Thank you in advance Wout
  13. Eder Pardeiro

    How to conect and return data in 3cx database?

    Hi, 3CX default reports don't meet all the need's. Then I think consult database and return data. How connect? I need a string of connection. Do you have any samples of query his I use to this?