3cx sql creation tables

[Paolo Demaria]

goodafternoon, , i don't know How to create sql table in order to permit 3cx server to write contacts.

 

[Evolute IT]

You need to figure that out on your own. 3CX doesn't provide any structure of database. It's up to you to set it up according to your DB structure and needs.

If you really dont' know SQL, then you'll need to ask on MySQL/MSSQL/Postgres forums.

 

[Paolo Demaria]

thank you for the reply, but the DB structure is created by step by step guide.
https://www.3cx.com/docs/sql-database-pbx-integration/
i'm stuck on point 3 i dont know how 3cx want sql table
Enter the Lookup By Number SQL Statement. This will be used when doing the lookup for calls or chat interactions through SMS. This must be a SELECT statement returning the following case-sensitive columns:
contactid, firstname, lastname, companyname, email, phonemobile, phonemobile2, phonehome, phonehome2, phonebusiness, phonebusiness2, phoneother, faxbusiness, faxhome, pager, photourl.

 

[edossantos]

thank you for the reply, but the DB structure is created by step by step guide.
https://www.3cx.com/docs/sql-database-pbx-integration/
i'm stuck on point 3 i dont know how 3cx want sql table
Enter the Lookup By Number SQL Statement. This will be used when doing the lookup for calls or chat interactions through SMS. This must be a SELECT statement returning the following case-sensitive columns:
contactid, firstname, lastname, companyname, email, phonemobile, phonemobile2, phonehome, phonehome2, phonebusiness, phonebusiness2, phoneother, faxbusiness, faxhome, pager, photourl.

Looks like you're SQL query is wrong. It should start with "select", but in your case it starts enumerating the table columns... You should run your query using MySQL Workbench before, so you're sure that the query works as you need.

 

[Paolo Demaria]

thank you i've insert SELECT and now communicate.
unfortunately 3cx not sync contact on db.
my intention was to export extentions and contacts of 3cx on sql table in order to create a internal webpage that can be used to search our contacts.
there are any way to do this automatically without export csv manually or install 3rd part app inside 3cx server?
thank you @edossantos

 

[edossantos]

No, the CRM integration will not do that, and actually there is no way to achieve that in an automated way. You will need to export the data, and add it to the database.

 

[Paolo Demaria]

Sad news, thank you in advance.