Database synchronization setup

A database synchronization feature in TotalSend is a one-way synchronization of subscribers in a list from an external MySQL database. To set this feature up in your account, follow these few steps:   While logged into your TotalSend account. Navigate to your lists by clicking on the [LISTS] menu button at the top of the page. image003 Now you should see all the lists in your account. image002 Click on the name of the list that you would like the MySQL database to synchronize with. image005 You will now be taken to that list’s overview page. image006 Click on the “Synchronization” menu option on the left hand side of the screen under the “LIST OPTIONS” menu. image005 You will now see the settings for the list’s synchronization. You will see 3 options available to you. They are as follows: Status – This is the setting that controls whether the synchronization is enabled or disabled. (If this is set to enabled, more options will appear to set up the sync with your MySQL database) Frequency – This setting controls how frequently your TotalSend account will fetch and update the list with the data from the MySQL database. Send me a report every time my data is synchronized – This setting controls whether or not you would like to receive an email notification each time a synchronisation occurs. (The notification will be sent to the email address you signed up with) image006 The first thing to do to activate the synchronization is to change the status from “Disabled” to “Enabled”. This reveals the “MySQL Database Information” section of the settings. image007 You will need to fill in all the fields to successfully set up database synchronisation on your account. They are explained below.   Host Address – This is the IP address that your MySQL database is hosted on. Port – This is the port that your MySQL uses. Username – This is the user name that you use in your log in details to access your MySQL database. Password – This is the password that you use in your log in details to access your MySQL database. Database – This is to specify the database you wish to use on your MySQL server. Sql Query – The Query you wish to use to define which data you want to pull from your MySQL database.   Once you have finished filling in the settings, you can click “Save & Map Database Fields” and you will be taken to the mapping stage where you need to tell TotalSend which data from the MySQL database needs to be mapped to the corresponding custom field in your list.