mssql

  1. Call Routing and Info from SQL Lookup

    Hello all, Hopefully I'm in the right area for this request as we're unable to use any of your existing CRM integrations, so trying to leverage SQL instead. The API for our aged CRM lacks a number lookup endpoint so the template generation approach didn't appear to be applicable either. For...
    • splt-jack
    • Thread
    • call flow designer incoming call information mssql
    • Replies: 3
    • Forum: Other

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

  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. MSSQL 2012 provider: TCP Provider, error: 35

    Hello, I have the same problem that was discussed in that thread. https://www.3cx.com/community/threads/mssql-2008-db-connection-error-tcp-provider-error-35.81855/ I am using MSSQL 2012 on a Windows Server 2012R2, is there the same problem with MSSQL2012 as it is with MSSQL2008 Full Error...

  5. Call Journal for Transferred Calls?

    Hello community, As per https://www.3cx.com/community/threads/transfered-calls-not-logged-in-mysql-call-journal.114821/ Just wondering if there is a way this information could be retrieved otherwise, if it is not available on the Call Journal? OP was referring to MySQL but I am referring to...
    • sagius-pingco
    • Thread
    • call journaling crm integration mssql
    • Replies: 8
    • Forum: Other

  6. Not able to pass EntityId and EntityType to SQL during Call Reporting #2

    Creating new thread for this issue since the old one was accidently closed. Old Thread: https://www.3cx.com/community/threads/not-able-to-pass-entityid-and-entitytype-to-sql-during-call-reporting.86233/#post-406638 Respond back to @edossantos "The call being recorded or not shouldn't make any...
    • LEAD
    • Thread
    • bug crm integration mssql
    • Replies: 2
    • Forum: Other

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

  8. Microsoft SQL Issue

    Hello all, I am having issue with Call Journalling on Microsoft SQL. I can Lookup by Number fine and it returns all of the correct results. It's just INSERT that seems to be having issues. My query is INSERT INTO sims.CallLog (contactnumber, calltype, calldirection, agentextension...
    • haroonbg
    • Thread
    • crm crm integration mssql
    • Replies: 1
    • Forum: Other

  9. Solved How to display contact name from MsSQL database?

    Good day! In Call Flow, I created a project of the type described in "Creating a Phone Support Portal" https://www.3cx.com/docs/cfd-creating-phone-support-portal-1/. Connection to MsSQL DB works :), implemented verification by client ID. Accordingly, I would like to continue to the employee who...

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

  11. Exclude CRM-added contacts from phones?

    Hi there, Is there a way to exclude the contacts from the CRM system that have been added to 3CX from the phones? Otherwise the device phonebooks would get too messy. If not, is it possible to avoid to the contact creation in 3cx completely and just match the number very time someone calls...
    • MeKoDo
    • Thread
    • crm mssql phone book
    • Replies: 6
    • Forum: Other

  12. 3CX CRM MSSQL integration works only from 2nd call onwards

    I have MSSQL integration generating CRM contacts, works fine. However, the Caller ID information is only shown from the second and subsequent call. Is there any way to make the CRM lookup happen prior to forwarding the first call to voicemail or extension, so that Caller ID information is...

  13. 3CX - MSSQL CRM - Call Journaling

    Hi, Every Time we get an Incoming Call on a Queue,the CRM Integration INSERT's the CALL for every Agent that is in the Queue (Not only the One that picked up). Is that Expected Behavior or is something Wrong there?

  14. connection to mssql

    i need to get a number from sql but could not manage instance name: SQLSERVER\INSTANCE database name: database1 table: customer user: username password: password i am trying to customernumberid from the table customer and from the database database1 with database instance SQLSERVER\INSTANCE...
3CX Logo Footer Copyright © Sitemap Privacy
Top Bottom