mssql integration

  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. CRM Integration: Database MSSQL: Call Journalling

    I use an insert statement for call journalling. I see the statement is invoked with all necessary parameters: 2025/10/01 18:17:47.804|0025|Debg| [Integration.Crm.CallProcessingService] CRM: Triggering Call Journaling with values - CallType='Inbound' - PhoneNumber='0763xxx' - ContactName='31o...
    • londonpapakura
    • Thread
    • call journalling crm integration mssql integration
    • Replies: 2
    • Forum: Other

  3. MSSQL Integration - Call Journaling not working

    Hello, i'm trying set up the CRM integration with MSSQL. I inserted the queries for Search by Name, Number and Email. And it works. Now, I want to set up Call Journaling. I inserted the query but it doesn't log any call. No errors in the logs, but if i execute the same query directly from the...

  4. MsSQL: Problem with query and variable

    Hello everyone, I would like to modify the default query but if I use multiple time the variable in the WHERE clause, query does not work anymore. EXAMPLE: - This query work: S_ELECT contactid, firstname, lastname, email, phonebusiness, phonemobile, faxbusiness F_ROM MyDBname.dbo.CRM3CX...
    • BEHD
    • Thread
    • mssql integration
    • Replies: 2
    • Forum: Other

  5. CRM Lookup By Number Successful, but does not show if not Added to 3CX company phonebook

    Hi, We wanted CRM Lookup By Numbers to always take place, and didn't want to store the results in the 3CX company phonebook. When we switch off the "Add CRM contacts to 3CX company phonebook when a call or message is sent or received." setting, we can see a lookup occurring when a phone call...
    • shak
    • Thread
    • caller id lookup crm contacts mssql integration
    • Replies: 31
    • Forum: Other

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

  7. [MSSQL]Conversation time variable

    Hi. I'm using 3CX CRM Integration for MS SQL and I wonder how can I find conversation time variable. I already read official doc. As an example: Screen above shows what I get in my DB. [CallStartTimeLocal] and [CallEstablishedTimeLocal] are identical but I spent about 55 seconds waiting in a...
    • RafalR
    • Thread
    • mssql integration
    • Replies: 5
    • Forum: Other

  8. Advanced Cfd - Creation of an automatic appointment management service

    Good morning, last night, checking the forum, I was looking for how to create a cfd that, based on a database, performs the search, control and eventual insertion of an appointment with keyboard choices. As I had thought it, the customer calls, we record the entry session.ani, upon selecting...

  9. Option to Open local contact by custom field on incoming call

    Hello, this basic feature is important and there is no way how to argue to clients why so effective and good solution what 3CX is missed this basic feature. Just to open contact on incoming call. To show Company info and in next level - some note about this company. If you use for example SQL...

  10. Not able to pass EntityId and EntityType to SQL during Call Reporting

    When trying to report the call I am unable to pass the EntityId and EntityType variables into my query. When doing the test query it is successfully pulling all necessary information However, once it comes to Reporting the Call, EntityId and EntityType are not being passed. Having same...
    • LEAD
    • Thread
    • crm integration mssql mssql integration
    • Replies: 9
    • Forum: Other

  11. Contact URL for MsSQL integration.

    My requirement is to synchronize the FirstName, Lastname, CompanyName, Email, Mobile Number, Fax, ProfileImage with 3CX I have configured General Configuration and Call Journaling but without the Option Contact URL Prefix. I went through this point (The Contact URL is considered the key for the...
    • Abdullah Karadia
    • Thread
    • 3cx integration contacturl crm integration mssql integration
    • Replies: 3
    • Forum: Other

  12. MVC.Net with Angular 7

    I need the help of Integrating 3CX application with .NET MVC + Angular 7 to get call history, extension, user status and also would able to make calls, Chat, Video, Web Meeting, etc I have used MsSQL server-side integration but not getting what I am expecting. Please help.
    • Abdullah Karadia
    • Thread
    • .net mvc 3cx integration angular 7 crm integration mssql integration
    • Replies: 1
    • Forum: Other
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom