database

  1. SQL Server Export Error Event ID 50032

    I am receiving the following error when exporting to SQL Server. Data transferring to sql server failed due to the following reason: Failed to export `public_cdroutput`: Exception while reading from stream I have attempted to purge call records to see if that would resolve the issue, but...

  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. Copy Agent Status history to another database

    Hi all! I am trying to copy the agent status history to another database, like Postgres. I will use this for my custom report purposes in our call centre. I already have the integration for copying the CDR output table every 15 minutes from 3CX to Postgres, but this integration does not have...

  4. 3CX Hosted + Call Scripts + Database connection

    Hi, i have 3CX hosted Version 20.0 Update 6 (Build 708) ENTERPRISE 8SC Call flow designer 20.2.84.0 I modified the survey demo project with my database credentials (PostgreSQL) and built the app without compile errors. I uploaded the zip file from integrations >> call scripts. I am able to...

  5. 3CX Database Encryption

    Hi, we are undergoing a security audit, and they wanted to know what type of database encryption is being used by 3CX. Does anyone know about this? We are running in 3CX V20 hosted in Digital Ocean using Debian 12.

  6. Database issue

    I have an on-prem 18.0.8.935 and since we had a lot of turnover lately the extensions have been reassigned. However when receiving calls from them both the softphone clients and the desk phones will display the former employees name on the caller id. This is also sometimes happening for the...

  7. Database connection error with using Parallel ?

    When database function error like insert error, the all call flow stopped. We use the parallel fuction to solve the problem , but is it the best way?

  8. Alternative methods of pulling backup of current config

    Background: I have a client whose 3CX on-prem server did an automatic update on or about 9:18am 2/8/2023. From that point forward, services and applications depending on .NET libraries in the "C:\Program Files\3CX Phone System\Bin" directories failed to start including the management console and...
    • VIQ
    • Thread
    • binaries database repair resolved solved update
    • Replies: 2
    • Forum: Phone System / PBX

  9. How does myphone_callhistory_v14 link to callcent_queuecalls

    We are working on an integration to pull call logs, however I can't find a column that contains a unique identifier that exists in both callcent_queuecalls and myphone_callhistory_v14. Call Logs have call_id which is a sequential number but queuecalls have a call_history_id, how do I get the...

  10. 3CX call history / database restore.

    Hi, I have a problem with database corruption in a 3CX self-hosted debian instance. The new calls are not being logged and reports cannot be issued anymore since the corruption of database a couple of weeks ago. The customer wants to rescue / save all call reports and records in the database up...

  11. Best CDR Central server in order to receive the CDR ?

    Hello 3CX guys, 3CX CDR can send call data records to a CDR Central server. At my compagny, we search the best CDR Central server in order to receive call data records from 3CX server. Please, could you advise us ? I thank you in advance. Regards,
    • gcf
    • Thread
    • cdr cdr - call data records cdr server data export database
    • Replies: 3
    • Forum: Phone System / PBX

  12. Example to Call Flow to collect the call details at the end of the call and send to database or webservice

    Any Example to Call Flow to collect the call details at the end of the call and send them to a database or web service I know there are components for both database and web service in the Call Flow Designer. What I don't know is what are the possible fields related to the call are available...

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

  14. Extract call logs via SQL query or API

    Dear All, I need to extract all the call logs (outgoing, incoming, losed, ...) from my 3CX. I have already read from other threads that it's not allowed to access to 3CX database. There are other ways to get the information I need? I need to create a custom report with Power Bi and for the...
    • fabio.abbiati
    • Thread
    • api call database logs report schedule
    • Replies: 2
    • Forum: Other
  15. g.fiszt

    Unsupported Database issue after upgrade to V18

    Hello everyone! I've made the upgrade from V16 to V18 and it's completed smoothly. We have a slave PostgreSQL database that we make queries and the results are displayed in some custom dashboards that we created on Google DataStudio. After upgrading to V18, the databases were out of sync, then...

  16. 3CX integrated with database

    Hello everyone 1. I see 3CX can be integrated with PostgreSQL database, But I would like to ask how to add contactid when Contact Creation In the article, I only saw this paragraph of SQL Statement, but did not see how to add contactid "INSERT INTO contacts (first_name, last_name, phone)...
    • Alex.Hu
    • Thread
    • database postgresql
    • Replies: 2
    • 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. g.fiszt

    Survey results to database

    How can I save the results of a survey component to a database instead of a CSV file? Also, is there a way to configure the call to automatic transfer to the survey when the agent disconnects it? Or the agent has to manually transfer the calls to the survey? Thanks is advance

  19. Copying Call Logs/Data to A Different 3CX Server

    We are trying to access the 3CX’s Postgres database, using pgAdmin on a free licensed test server we have in Google Cloud. We want to test out this process before we attempt anything in production. Our test server doesn't have much call data at all and we would like to copy some call data from...

  20. Searching for table with option "Do not show extension in 3CX company phonebook"

    Hi all, we are running own bash scripts for creating all our phonebooks for different models and ran into a small problem. Our scripts do not check for the option “Do not show extension in 3CX company phonebook” and so all numbers are in the phonebooks, no matter if this option is activated. I...
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom