View Source

First, you must already to have created and configured dialer task. Now, open menu Integrations and press Export statistics SQL:

Webitel: Knowledge Base > Export dialer logs > export_add.png

General

Webitel: Knowledge Base > Export dialer logs > export_general.png

Name - Any name for this task
Web service URL - URL to the SQL4Dialer Service
Token - You domain token
Run import after export - If you wish to run Import members after the export is done, please, select it here.
Cron Job - If you wish to schedule executing this action, please, use crontab format.

Webitel: Knowledge Base > Export dialer logs > export_sql.png

Connection string - the connection string to the MS SQL
Table name - the table name with the dialer members
PRE EXECUTE - SQL Stored Procedures executed before SELECT. If you don't know, leave it empty.
POST EXECUTE - SQL Stored Procedures executed after SELECT. If you don't know, leave it empty.

Fields mapping must be done here:

Webitel: Knowledge Base > Export dialer logs > export_fields.png

Save your setting and save your dailer. Now, you can manually run and see the log:

Webitel: Knowledge Base > Export dialer logs > export_run.png

You can use our preconfigured settings for Luxbase: export into Luxbase.json

Webitel: Knowledge Base > Import members > integration_import.png