First of all, you must already to have created and configured dialer task. Now, open menu Integrations and press Import members SQL:

General

• Name - Any name for this task
• Delete all members before import - enable this if you wish to purge all members before adding the new members.
• Web service URL - URL to the SQL4Dialer Service 
• Token - You domain token
• Expire after - If you wish to stop making calls after sometimes, please, add this here. Can be: m - for minutes, h - for hours and d - for days.
• Cron Job -  If you wish to schedule executing this action, please, use crontab format.

SQL

All SQL connection and database parameters are here:

• Connection string - the connection string to the MS SQL
• Table name - the table name with the dialer members
• Primary column - the primary column in the dialer member's table
• DataTime column - the DateTime column in the dialer member's table. The Webitel will update this column after posting the member into the dialer.
• Custom filter - some additional SQL filters. If you don't know, leave it empty.
• 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

Fields mapping must be done here:

Test settings

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

Upload preconfigured settings

You can use our preconfigured settings for Luxbase: Import Members from Luxbase.json