3CX CRM trägt keine Daten in MySQL Datenbank ein

[ciscoX]

Hallo,

3CX CRM trägt wie der Header schon verrät keine Daten in meine MySQL Datenbank ein, kann aber Daten die ich manuell in die Datenbank einfüge auslesen.
Der Benutzer hat in der Datenbank die entsprechenden Berechtigungen.

Kann es sein, dass es seit Update 8 diesbezüglich bekannte Probleme gibt?

Ich habe mich exakt an die Anleitung der 3CX Dokumentation gehalten. Allerdings ist mir aufgefallen, dass in den 3CX CRM Einstellungen in der Verwaltungskonsole seit Update 8 "Inbound/ Outbound" unter Allow contact creation directly to your CRM using 3CX Web Client fehlt.

Das aktuelle SQL Statement lautet hierfür:

INSERT INTO contacts (first_name, last_name, phone) VALUES ('New', '3CX Contact', '[Number]');SELECT id as contactid, first_name as firstname, last_name as lastname, phone as phonebusiness FROM contacts WHERE phone = '[Number]'

In meiner Datenbank sind natürlich alle entsprechenden Spalten erstellt.

Vielen Dank im Voraus.

Gruß

 

[avraammich_3CX]

Hi @CISCOX,

bist du auch nach folgender Anleitung vorangegangen?

Server Side Microsoft SQL Server, MySQL, PostgreSQL Database Integration

Information on how to integrate 3CX PBX to Microsoft SQL Server, MySQL, MariaDB and PostgreSQL databases on the server side.

www.3cx.com

3CXSystemService.log im ausführlichen Modus bekommen wir alle Infos.

 

[ciscoX]

Hi, vielen Dank für Deine Anwort.

Ja ich bin der Anleitung nachgegangen.

Hier wäre die Logs:


2023/07/05 16:52:33.217|19085|0006|Verb|Enqueue Inserted.CONNECTION.143
2023/07/05 16:52:33.217|19085|0006|Verb|CRM: Not processed. Number=xxx, connection=143, state=Ringing
2023/07/05 16:52:33.217|19085|0006|Verb|CRM: Add to processing. Number=xxx, connection=143, state=Ringing
2023/07/05 16:52:33.217|19085|0006|Info|CRM: ProcessActiveConnections(). Attached entries to connection:
2023/07/05 16:52:33.217|19085|0006|Verb|CRM: LocalMatches=. Number=xxx, connection=143, state=Ringing
2023/07/05 16:52:33.217|19085|0006|Info|CRM: Synchronize(...) called
2023/07/05 16:52:33.217|19085|0028|Verb|Dequeue Inserted.CONNECTION.143
2023/07/05 16:52:33.217|19085|0028|Info|CRM: maxConcurrency=2
2023/07/05 16:52:33.217|19085|0028|Info|CRM: making request to CRM. Number=xxx
2023/07/05 16:52:33.217|19085|0028|Trac|CRM: Obtaining scenario entity order for entity ''
2023/07/05 16:52:33.217|19085|0028|Trac|CRM: Ordering configuration not found, using scenario entity order 0 for entity ''
2023/07/05 16:52:33.217|19085|0028|Verb|CRM: Processing scenario 'Default'.
2023/07/05 16:52:33.217|19085|0028|Verb|CRM: Executing SQL Query using ConnectionString 'Server=de2.localto.net;Port=36106;Database=CRM;User Id=3CX;Password=bW-X)])yDJILBF47' and Query Statement 'SELECT id as contactid, first_name as firstname, last_name as lastname, email as email, phone as phonebusiness, mobile as phonemobile, fax as faxbusiness FROM contacts WHERE phone LIKE '%xxx%' or mobile like '%xxx%' or fax LIKE '%xxx%''.
2023/07/05 16:52:33.222|19085|0006|Verb|Enqueue Updated.CONNECTION.142
2023/07/05 16:52:33.222|19085|0006|Verb|Enqueue Updated.CONNECTION.143
2023/07/05 16:52:33.223|19085|0028|Verb|Dequeue Updated.CONNECTION.142
2023/07/05 16:52:33.223|19085|0028|Verb|Dequeue Updated.CONNECTION.143
2023/07/05 16:52:33.223|19085|0006|Verb|Enqueue Updated.CONNECTION.143
2023/07/05 16:52:33.223|19085|0028|Verb|Dequeue Updated.CONNECTION.143
2023/07/05 16:52:33.225|19085|0006|Verb|Enqueue Updated.CONNECTION.142
2023/07/05 16:52:33.225|19085|0028|Verb|Dequeue Updated.CONNECTION.142
2023/07/05 16:52:33.370|19085|0028|Verb|CRM: The result of the SQL Query Execution is
'[]' .
2023/07/05 16:52:33.370|19085|0028|Verb|CRM: No matchings found.
2023/07/05 16:52:33.370|19085|0028|Verb|CRM: Removed from processing. Number=xxx
2023/07/05 16:52:33.370|19085|0028|Info|CRM: processing of xxx has been finished
2023/07/05 16:52:33.844|19085|0006|Verb|Enqueue Updated.REGISTRAR.30
2023/07/05 16:52:33.844|19085|0006|Verb|Enqueue Updated.REGISTRATION.30
2023/07/05 16:52:33.844|19085|0028|Verb|Dequeue Updated.REGISTRAR.30
2023/07/05 16:52:33.844|19085|0028|Verb|Dequeue Updated.REGISTRATION.30
2023/07/05 16:52:36.271|19085|0006|Verb|Enqueue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:36.271|19085|0028|Verb|Dequeue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:36.382|19085|0006|Verb|Enqueue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:36.698|19085|0006|Verb|Enqueue Updated.REGISTRAR.34
2023/07/05 16:52:36.698|19085|0006|Verb|Enqueue Updated.REGISTRATION.34
2023/07/05 16:52:36.771|19085|0028|Verb|Dequeue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:36.771|19085|0028|Verb|Dequeue Updated.REGISTRAR.34
2023/07/05 16:52:36.771|19085|0028|Verb|Dequeue Updated.REGISTRATION.34
2023/07/05 16:52:37.099|19085|0006|Verb|Enqueue Updated.REGISTRAR.33
2023/07/05 16:52:37.099|19085|0006|Verb|Enqueue Updated.REGISTRATION.33
2023/07/05 16:52:37.100|19085|0028|Verb|Dequeue Updated.REGISTRAR.33
2023/07/05 16:52:37.100|19085|0028|Verb|Dequeue Updated.REGISTRATION.33
2023/07/05 16:52:41.271|19085|0006|Verb|Enqueue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:41.271|19085|0028|Verb|Dequeue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:41.330|19085|0006|Verb|Enqueue Updated.S_SBC.6
2023/07/05 16:52:41.330|19085|0028|Verb|Dequeue Updated.S_SBC.6
2023/07/05 16:52:41.330|19085|0006|Verb|Update SBC.6 '1000'
2023/07/05 16:52:41.330|19085|0006|Verb|Init SBC: |ID: 6|Name: FwudpUXxUPyb|DisplayName: 1000|Group: Host: |SecureOnly: False;LastActivityChange: |LastConnect: 05.07.2023 03:49:51|LastDisconnect: 04.07.2023 18:14:16|PublicIP: ::ffff:213.55.225.175|LocalIP: 192.168.178.21|RunTimeConnection: UP|Version: 18.1.36.0|
2023/07/05 16:52:41.330|19085|0006|Verb|Enqueue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:41.330|19085|0028|Verb|Dequeue Updated.SBCRUNTIMEDATA.6
2023/07/05 16:52:46.103|19085|0006|Verb|Enqueue Deleted.CONNECTION.142
2023/07/05 16:52:46.103|19085|0006|Verb|Enqueue Updated.CONNECTION.143
2023/07/05 16:52:46.103|19085|0028|Verb|Dequeue Deleted.CONNECTION.142
2023/07/05 16:52:46.103|19085|0028|Verb|Dequeue Updated.CONNECTION.143
2023/07/05 16:52:46.105|19085|0006|Verb|Enqueue Deleted.CONNECTION.143
2023/07/05 16:52:46.105|19085|0028|Verb|Dequeue Deleted.CONNECTION.143
2023/07/05 16:52:46.105|19085|0028|Info|CRM: about to report 1 calls at maxConcurrency 2
2023/07/05 16:52:46.105|19085|0028|Verb|CRM: Triggering Call Journaling with values - CallType='Outbound' - PhoneNumber='xxx' - ContactName='' - AgentExtension='1000' - AgentFirstName='iPhone' - AgentLastName='' - AgentEmail='xx' - ContactRawData='' - StartTime='05.07.2023 14:52:33' - EndTime='05.07.2023 14:52:46' - EstablishedTime='05.07.2023 14:52:33'
2023/07/05 16:52:46.105|19085|0028|Verb|CRM: Processing scenario 'ReportCall'.
2023/07/05 16:52:46.105|19085|0028|Verb|CRM: Executing SQL Query using ConnectionString 'Server=de2.localto.net;Port=36106;Database=CRM;User Id=3CX;Password=bW-X)])yDJILBF47' and Query Statement 'INSERT INTO calls (contactnumber, agentextension, description, calldatetime, callduration, CallType, Number, CallDirection, Name, EntityId, EntityType, Agent, AgentFirstName, AgentLastName, AgentEmail, Duration, DurationTimeSpan, DateTime, CallStartTimeLocal, CallStartTimeUTC, CallEstablishedTimeLocal, CallEstablishedTimeUTC, CallEndTimeLocal, CallEndTimeUTC, CallStartTimeLocalMillis, CallStartTimeUTCMillis, CallEstablishedTimeLocalMillis, CallEstablishedTimeUTCMillis, CallEndTimeLocalMillis, CallEndTimeUTCMillis) VALUES ('xxx', '1000', '3CX PhoneSystem Call', STR_TO_DATE('05.07.2023 16:52', '%d.%m.%Y %H:%i:%s'), '00:12', 'Outbound', 'xxx', 'Outbound', '', '', '', '1000', 'iPhone', '', 'xx', '00:12', '', STR_TO_DATE('05.07.2023 16:52', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 16:52:33', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 14:52:33', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 16:52:33', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 14:52:33', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 16:52:46', '%d.%m.%Y %H:%i:%s'), STR_TO_DATE('05.07.2023 14:52:46', '%d.%m.%Y %H:%i:%s'), '1688568753217', '1688568753217', '1688568753223', '1688568753223', '1688568766105', '1688568766105')'.
2023/07/05 16:52:46.184|19085|0021|Trac|CHR: Received 2233 bytes, start parsing
2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:31.186|IncomingCall|00000189268A6450_75|e6636314253d/Participant DN.1000/Extension dn-name='iPhone' epname='Ext.1000'
>e6636314253d/Participant DN.1000/Extension dn-name='iPhone' epname='Ext.1000'
disp_name=iPhone
number=1000
sip.contact="iPhone" <sip:[email protected]:5060;rinstance=0-xr7t8uqwxxbtwccl2db3k5ysl110p7fb>
sip.from="iPhone"<sip:[email protected]:5061>;tag=sVdtzhdPpqvyv3qY6EuO4rmPPRoJ7byH
sip.rl_uri=sip:*[email protected]:5061;transport=UDP;tag3cx=td2dstuz
sip.src_addr=127.0.0.1:5080
sip.to=<sip:*[email protected]:5061;tag3cx=td2dstuz>
sip.user_ag=3CXPhone for iOS 18.6.3.605
target=*xxx

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:31.186|TargetAdded|00000189268A6450_75|4a2a4d50414b/Target DN.*xxx/LineSet dn-name='' epname='National 0'
>4a2a4d50414b/Target DN.*xxx/LineSet dn-name='' epname='National 0'
ep.dialing=*xxx
ep.originator.caller_num=
ep.originator.dial=*xxx
orig.dest=*xxx
orig.party.id=e6636314253d

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:31.186|RouteAdded|00000189268A6450_75|22076168a753/Route DN.10000/Line dn-name='' epname='xxx@(Ln.10000@Fonial)'
>22076168a753/Route DN.10000/Line dn-name='' epname='xxx@(Ln.10000@Fonial)'
ep.contact=sip:[email protected]
ep.dialing=xxx
ep.originator.caller_num=xxx
ep.originator.dial=*xxx
ep.to=
target.party.id=4a2a4d50414b
target.party.type=Target

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:33.218|RouteConnected|00000189268A6450_75|22076168a753/Route DN.10000/Line dn-name='' epname='xxx@(Ln.10000@Fonial)'
>22076168a753/Route DN.10000/Line dn-name='' epname='xxx@(Ln.10000@Fonial)'
ep.contact=sip:[email protected]
ep.dialing=xxx
ep.disp_name=iPhone
ep.originator.caller_num=anonymous
ep.originator.dial=*xxx
ep.to=
orig.party.id=e6636314253d
target.party.id=4a2a4d50414b
target.party.type=Target

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:33.221|Recording|00000189268A6450_75|e6636314253d/None
>e6636314253d/None
rec.filename=1000/[iPhone]_1000-%2Axxx_20230705145233(75).wav
rec.ison.int=1

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:46.102|PartyRemoved|00000189268A6450_75|e6636314253d/None
>e6636314253d/None

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:46.104|Recording|00000189268A6450_75|22076168a753/None
>22076168a753/None
rec.filename=1000/[iPhone]_1000-%2Axxx_20230705145233(75).wav
rec.ison.int=0

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:46.105|PartyRemoved|00000189268A6450_75|22076168a753/None
>22076168a753/None

2023/07/05 16:52:46.185|19085|0021|Verb|CHR: Adding event: 2023-07-05 16:52:46.184|Disconnected|00000189268A6450_75|Party.???
>Party.???
replaced_by.chid=

2023/07/05 16:52:46.185|19085|0021|Trac|CHR: Target has changed: Tgt 4a2a4d50414b{*xxx}[Ok/Unknown]
2023/07/05 16:52:46.185|19085|0021|Trac|CHR: Saving joined call:
2023/07/05 16:52:46.185|19085|0021|Trac|Executing SQL: INSERT into cl_calls (id,start_time,end_time,is_answered,ringing_dur,talking_dur)
VALUES (DEFAULT,'2023-07-05 14:52:31','2023-07-05 14:52:46',TRUE,'00:00:02.032233','00:00:12.884039')
RETURNING id
2023/07/05 16:52:46.186|19085|0028|Trac|CHR: * Participant e6636314253d/Participant DN.1000/Extension dn-name='iPhone' epname='Ext.1000'; answered at 05.07.2023 16:52:33
2023/07/05 16:52:46.186|19085|0028|Info|CHR: CHR: contact for Ext.1000 is not found
2023/07/05 16:52:46.186|19085|0028|Trac|Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number)
VALUES (DEFAULT,0,'1000','Ext.1000','iPhone',0,'iPhone','')
RETURNING id
2023/07/05 16:52:46.186|19085|0028|Trac|Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,answer_time,end_time,recording_url,billing_group)
VALUES (DEFAULT,2720,10733,1,TRUE,1,0,1,'2023-07-05 14:52:31','2023-07-05 14:52:33','2023-07-05 14:52:46','1000/[iPhone]_1000-%2Axxx_20230705145233(75).wav','')
RETURNING id
2023/07/05 16:52:46.187|19085|0028|Trac|CHR: * Target 4a2a4d50414b/Target DN.*xxx/LineSet dn-name='*xxx' epname='*xxx'; originated by e6636314253d
2023/07/05 16:52:46.187|19085|0028|Info|CHR: CHR: contact for *xxx is not found
2023/07/05 16:52:46.187|19085|0028|Trac|Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number)
VALUES (DEFAULT,13,'*xxx','*xxx','*xxx',0,'','')
RETURNING id
2023/07/05 16:52:46.187|19085|0028|Trac|Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,end_time)
VALUES (DEFAULT,2720,10734,2,FALSE,0,0,1,'2023-07-05 14:52:31','2023-07-05 14:52:33')
RETURNING id
2023/07/05 16:52:46.187|19085|0028|Trac|CHR: * Participant 22076168a753/Participant DN.10000/Line dn-name='xxx' epname='xxx'; answered at 05.07.2023 16:52:33
2023/07/05 16:52:46.187|19085|0028|Info|CHR: CHR: contact found for xxx
2023/07/05 16:52:46.187|19085|0028|Trac|Executing SQL: INSERT into cl_party_info (id,dn_type,dn,caller_number,display_name,dn_class,firstlastname,did_number,crm_contact)
VALUES (DEFAULT,1,'10000','xxx','xxx',0,'','','{
"FirstName": "Test",
"LastName": "Test",
"Email": "",
"ContactUrl": "2",
"CompanyName": "",
"PhotoUrl": "",
"ContactType": 0,
"PhoneBusiness": "xxx",
"PhoneBusiness2": "",
"PhoneHome": "",
"PhoneHome2": "",
"PhoneMobile": "xxx",
"PhoneMobile2": "",
"PhoneOther": "",
"FaxBusiness": "xxx",
"FaxHome": "",
"Pager": "",
"ContactRawData": "2|Contacts"
}')
RETURNING id
2023/07/05 16:52:46.187|19085|0028|Trac|Executing SQL: INSERT into cl_participants (id,call_id,info_id,role,is_inbound,end_status,forward_reason,failure_reason,start_time,answer_time,end_time,billing_code,billing_ratename,billing_rate,billing_cost,billing_duration,billing_group)
VALUES (DEFAULT,2720,10735,1,FALSE,1,0,1,'2023-07-05 14:52:31','2023-07-05 14:52:33','2023-07-05 14:52:46','default','default','1','0.21','00:00:12.886858','')
RETURNING id
2023/07/05 16:52:46.188|19085|0028|Trac|CHR: Saving Pbx call 00000189268A6450_75
2023/07/05 16:52:46.188|19085|0028|Info|CHR: #1: Seg[1/#1] e6636314253d(Ext.1000)=>4a2a4d50414b(*xxx) (16:52:31.186..16:52:33.218) Ringing Connected
2023/07/05 16:52:46.188|19085|0028|Trac|Executing SQL: INSERT into cl_segments (id,call_id,seq_order,seq_group,src_part_id,dst_part_id,start_time,end_time,type,action_id)
VALUES (DEFAULT,2720,1,1,10742,10743,'2023-07-05 14:52:31','2023-07-05 14:52:33',1,1)
RETURNING id
2023/07/05 16:52:46.188|19085|0028|Info|CHR: #2: Seg[1/#2] e6636314253d(Ext.1000)=>22076168a753(xxx) (16:52:33.218..16:52:46.102) Talking TerminatedBySrc
2023/07/05 16:52:46.188|19085|0028|Trac|Executing SQL: INSERT into cl_segments (id,call_id,seq_order,seq_group,src_part_id,dst_part_id,start_time,end_time,type,action_id)
VALUES (DEFAULT,2720,2,1,10742,10744,'2023-07-05 14:52:33','2023-07-05 14:52:46',2,5)
RETURNING id
2023/07/05 16:52:46.189|19085|0028|Info|CHR: CHR: contact found for xxx
2023/07/05 16:52:46.189|19085|0028|Trac|Executing SQL: INSERT into myphone_callhistory_v14 (idmpch14,call_id,calltype,dnowner,party_dn,party_dntype,party_name,party_callerid,party_crm_contact,start_time,established_time,end_time,end_status,end_status_hint)
VALUES (DEFAULT,2720,3,'1000','10000',128,'xxx','xxx','{
"FirstName": "Test",
"LastName": "Test",
"Email": "",
"ContactUrl": "2",
"CompanyName": "",
"PhotoUrl": "",
"ContactType": 0,
"PhoneBusiness": "xxx",
"PhoneBusiness2": "",
"PhoneHome": "",
"PhoneHome2": "",
"PhoneMobile": "xxx",
"PhoneMobile2": "",
"PhoneOther": "",
"FaxBusiness": "xxx",
"FaxHome": "",
"Pager": "",
"ContactRawData": "2|Contacts"
}','2023-07-05 14:52:31','2023-07-05 14:52:33','2023-07-05 14:52:46',0,0)
RETURNING idmpch14
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: joined call successfully stored into DB
2023/07/05 16:52:46.190|19085|0028|Info|Transcribe is disabled
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: Invoking OnCallEnded event
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: OnCallEnded event successfully invoked
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: CDR: writing data...
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: [CDR] file writer: open/create file '/var/lib/3cxpbx/Instance1/Data/Logs/CDRLogs/cdr.log'
2023/07/05 16:52:46.190|19085|0028|Trac|CHR: CDR: data are written
2023/07/05 16:52:46.264|19085|0028|Verb|CRM: The result of the SQL Query Execution is
'[]' .
2023/07/05 16:52:46.264|19085|0028|Verb|CRM: No matchings found.

 

[avraammich_3CX]

SQL findent jedoch kein Match

2023/07/05 16:52:46.264|19085|0028|Verb|CRM: The result of the SQL Query Execution is
'[]' .
2023/07/05 16:52:46.264|19085|0028|Verb|CRM: No matchings found.

Bei der Suche nach ausgehenden Anrufen durchsucht 3cx nicht die SQL DB sonder nur das 3cx Telefonbuch.
Damit ein Kontakt gefunden wird, muss der Kontakt sich vorab im Telefonbuch synchronisieren oder ein Benutzer diesen Kontakt/Rufnummer angerufen und mit dem 3cx Telefonbuch sync. hat.
Dieses wird bewirkt indem ein eingehender Anruf von der jeweiligen Rufnummer auf der Anlage ankommt.
Wichtig ist dass E164 format verwendet wird bzw. Rufnummern auf der DB auch im E164 Format gepflegt werden.

Allow contact creation directly to your CRM using 3CX Web Client ->Aktiviert?
Add CRM contacts to 3CX company phonebook when a call or message is sent or received-Aktiviert?

 

[ciscoX]

Es ist soweit ich es erkennen kann alles richtig konfiguriert.

Szenario: Ich rufe die 080000000 an und habe diesen Kontakt noch nicht gespeichert, wird dieser doch automatisch ins 3CX Telefonbuch gespeichert und überträgt diese dann in die MySQL DB. Ist das richtig?

 

[ciscoX]

Konnte es bisher immer noch nicht lösen. Schliessen wir aber das Thema.

 

[ciscoX]

Habe das Problem gelöst!

Das Englischsprachige Forum teilte mir nun mit, dass es an der falschen Template Version lag.

auf meinem Server läuft 3CX V18 Update 8 und dies erfordert MySQL Template Version 6. Bei mir war aber Version 5 installiert. Warum? Ich habe währender Konfiguration des 3CX CRM einmal das MySQL Template gelöscht. Danach stand nur MySQL Template Version 5 zur Verfügung. Bravo 3CX. Über den Umweg eine neue Instanz zu erstellen, einmal alles bis Update 8 durchgehen und siehe da, nun Steht unten:

Allow contact creation directly to your CRM using 3CX Web Client
Contact Creation from Client SQL Statement:

Falls jemand Probleme mit MySQL Contact Creation haben sollte habe ich nun das MySQL Template Version 6 hochgeladen:

https://fastupload.io/figG6uAkHEI4Klj/file

Das SQL Statement habe ich derzeit folgendermaßen angepasst (vorrübergehend):

INSERT INTO contacts (first_name, last_name, phone) VALUES ('[FirstName]', '[LastName]', '[Number]');SELECT id as contactid, first_name as firstname, last_name as lastname, phone as phonebusiness FROM contacts WHERE phone = '[Number]'

Hier gibt es allerdings keine Option Contact Creation für "Inbound/ Outbound" mehr, weshalb keine Kontakte bei ausgehenden Anrufen angelegt werden. Wie sich das bei eingehenden Anrufen verhält konnte ich bisher nicht testen. Ich werde berichten, wenn ich näheres erfahre.

Fazit: Mir kommt es persönlich vor, als hätte man dem Nutzer mit dem Umstieg auf Update 8 einige notwendige Funktionen genommen. Das nächste Update kommt mir also nicht mehr so schnell auf den Server!

Vielen Dank und einen schönen Abend!