Closed Stell0 closed 2 years ago
in 7.9.2009/nethesis-testing
:
Backend test case:
/etc/phonebook/sources.d/custom_<NUMBER>.json
where NUMBER is a progressive number and this content:
{"custom_<NUMBER>":{"driver":"MSSQL","host":"localhost","port":"1433","user":"sa","password":"<PASSWORD>","dbname":"<ODBC NAME>","query":"SELECT * FROM phonebook\n","mapping":{"number":"workphone","name":"name"},"dbtype":"mssql","interval":"1440","type":"phonebook3","enabled":true}}
/usr/share/phonebooks/phonebook-import -lv -v /etc/phonebook/sources.d/custom_2.json
NOTE: After those test, this issue can be released without waiting for frontend
It is possible to populate the centralized phonebook using a MySQL database or a CSV file, but a lot of customer phonebooks are stored into MSSQL databases.
We can connect to a MSSQL database using ODBC