<\/p>\n
Imports to Lists#<\/a><\/h2>\nThis option allows you to automatically update your subscriber lists by importing them from ftp or a file at regular intervals.<\/p>\n
The table under Imports to Lists<\/em> displays all of the scheduled imports to lists which are currently active, inactive, deleted or in draft.<\/p>\nTo schedule a new import to lists, click Import to subscribers list<\/strong> under Imports to list<\/em>:
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548154573823-tasks_import_to_list_button_EN.png\")
<\/p>\nYou will see a wizard consisting of 5 steps:<\/p>\n
#<\/a><\/h4>\nStep 1: Source#<\/a><\/h4>\nIn the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n
Uri: <\/strong>the address of the file on a FTP server in one of the following formats: <\/p>\n<\/a><\/span><\/p>\nftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u>\nftp:\/\/domain.com\/subscribers.csv<\/u><\/span><\/pre>\nWhere:<\/p>\n
\n- domain.com<\/em> is the user name<\/li>\n
- ftp.esv2.com<\/em> is the host name (optional)<\/li>\n
- subscribers.csv<\/em> is the name of the file in the CSV format<\/li>\n<\/ul>\n
Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\nPassword<\/strong>: the password for the FTP server<\/p>\nAuthentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\nUse active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/p>\nMask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n\nHow does the mask work?#<\/a><\/h2>\nFor example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\nIf you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\nDelete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary.<\/p>\n![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548162506887-tasks_s1_source_EN.png\")
<\/p>\n
After filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\nClick Next.<\/strong><\/p>\n<\/p>\n
Step 2: Target<\/strong>#<\/a><\/h4>\nEnter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the list of subscribers with which you want to integrate the data from the file. <\/p>\n
Click Next<\/strong>.<\/p>\n<\/p>\n
Step 3: Import setup#<\/a><\/h4>\nAt this step, all import settings need to be configured in the same way as in a standard import<\/a>. In the first box under Import settings<\/em> you will be able to specify what relation the imported data should have to the data already present on the list. When you are creating a brand new list, just leave the default options at the Import settings<\/strong> tab and click Next<\/strong>. Otherwise, you may decide if you want to add new subscribers to the list and\/or update or replace the data of subscribers who are already list members. Furthermore, if the imported file contains the data of subscribers who unsubscribed from the list or who were manually removed for some reason, specify if you want to import them again.<\/p>\nIn the window below, specify the delimiter (the character which separates fields in each row) used in the file. If the file contains quotes, escaped characters, or comments, you may also specify a quote, escape and comment character respectively. Select the character encoding used in the file and the line from which data import should start.<\/p>\n
\n\nFrom which line should I start?#<\/a><\/h3>\nNote that it is common in IT to start counting from 0, so the first line in a file has the number 0. However, the first line often contains headings, such as "Name", "Email" etc. You would not like the import mechanism to treat such a line as containing real subscriber data, and this is why you have the opportunity to start from line 1, or any other line in the file.<\/p>\n<\/div>\n<\/div>\n
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1545212846745-field_delimiter_EN.png\")
<\/p>\n
Below you will see a column preview with the data extracted from the updated file:
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548170154661-column_preview_EN.png\")
<\/p>\n
If the division into columns is correct, click Next<\/strong>.<\/p>\n<\/p>\n
Step 4: Map columns#<\/a><\/h4>\nIn step 4, choose the matching mode:<\/p>\n
\nMatching mode#<\/a><\/h2>\nIf you already have any other subscriber lists, it may be the case the subscriber you are adding is already a member of one of those lists. In such a case, all of the fields which were filled while adding the subscriber will be reused now and updated accordingly. Choose the Matching mode<\/strong>, i.e. the criterion which will be used for comparing subscribers across lists: Email<\/em>, Phone <\/em>or Custom subscriber ID<\/em>. It is important that all three parameters are unique within the whole business unit. Updating one of them will update the other two.<\/p>\n<\/div>\nIn the next box, map the columns from the file to the fields which will be stored in the database. For example, if the first column contains email addresses, import it as Email<\/em>. If another column contains the subscriber's first name, import the column as First name<\/strong>. You may choose not to import certain columns you deem unnecessary.<\/p>\n\n\nWarning#<\/a><\/h3>\nRemember that in order for the system to be able to properly import custom fields, they need to be created first! See Custom fields<\/a> for more details.<\/p>\n<\/div>\n<\/div>\n![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1545213174444-mapped_columns_EN.png\")
<\/p>\n
Click Next<\/strong>.<\/p>\n<\/p>\n
Step 5: Recurring#<\/a><\/h4>\nThe last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\nFor example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548237786444-tasks_import_to_list_recurring_EN.png\")
<\/p>\n
After you specify your time frame, the scheduled import will be put on the calendar displayed below:
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548237892700-tasks_import_to_list_calendar_EN.png\")
<\/p>\n<\/div>\n
\nImports to Suppression Lists#<\/a><\/h2>\nThis option allows you to automatically update your suppression lists by importing them from ftp or a file at regular intervals.<\/p>\n
The table under Imports to suppression lists<\/em> displays all of the scheduled imports to suppression lists which are currently active, inactive, deleted or in draft.<\/p>\nTo schedule a new import to lists, click Import to suppression list<\/strong> under Imports to suppression lists<\/em>:
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548239762934-tasks_import_to_suppr_list_EN.png\")
<\/p>\nYou will see a wizard consisting of 4 steps:<\/p>\n
#<\/a><\/h4>\nStep 1: Source#<\/a><\/h4>\nIn the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n
Uri: <\/strong>the address of the file on a FTP server in the following format: <\/p>\nftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u><\/pre>\nWhere:<\/p>\n
\n- domain.com<\/em> is the user name<\/li>\n
- ftp.esv2.com<\/em> is the host name<\/li>\n
- subscribers.csv<\/em> is the name of the file in the CSV format<\/li>\n<\/ul>\n
Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\nPassword<\/strong>: the password for the FTP server<\/p>\nAuthentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\nUse active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/span><\/p>\nMask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n\nHow does the mask work?#<\/a><\/h2>\nFor example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\nIf you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\nDelete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary.<\/p>\n![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548239922056-tasks_import_to_suppr_s1_EN.png\")
<\/p>\n
After filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\nClick Next.<\/strong><\/p>\n<\/p>\n
Step 2: Target<\/strong>#<\/a><\/h4>\nEnter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the list of subscribers with which you want to integrate the data from the file. <\/p>\n
Click Next<\/strong>.<\/p>\n<\/p>\n
Step 3: Import setup#<\/a><\/h4>\nIn the File settings<\/em> window, specify the delimiter (the character which separates fields in each row) used in the file. If the file contains quotes, escaped characters, or comments, you may also specify a quote, escape and comment character respectively. Select the character encoding used in the file and the line from which data import should start.<\/p>\n\n\nFrom which line should I start?#<\/a><\/h3>\nNote that it is common in IT to start counting from 0, so the first line in a file has the number 0. However, the first line often contains headings, such as "Name", "Email" etc. You would not like the import mechanism to treat such a line as containing real subscriber data, and this is why you have the opportunity to start from line 1, or any other line in the file.<\/p>\n<\/div>\n<\/div>\n
<\/p>\n
Below you will see a column preview with the data extracted from the updated file:
<\/p>\n
If the division into columns is correct, click Next<\/strong>.<\/p>\n<\/p>\n
Step 4: Recurring#<\/a><\/h4>\nThe last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\nFor example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548240720363-tasks_import_to_suppr_recurring_EN.png\")
<\/p>\n
After you specify your time frame, the scheduled import will be put on the calendar displayed below:
<\/p>\n<\/div>\n
\nImports to Blacklist#<\/a><\/h2>\nThis option allows you to automatically update your blacklists by importing them from ftp or a file at regular intervals.<\/p>\n
The table under Imports to blacklists<\/em> displays all of the scheduled imports to blacklists which are currently active, inactive, deleted or in draft.<\/p>\nTo schedule a new import to lists, click Import to blacklist<\/strong> under Imports to blacklist<\/em>:
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548322027163-tasks_import_to_blacklist_button_EN.png\")
<\/p>\nYou will see a wizard consisting of 3 steps:<\/p>\n
<\/p>\n
Step 1: Source#<\/a><\/h4>\nIn the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n
Uri: <\/strong>the address of the file on a FTP server in the following format: <\/p>\nftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u><\/pre>\nWhere:<\/p>\n
\n- domain.com<\/em> is the user name<\/li>\n
- ftp.esv2.com<\/em> is the host name<\/li>\n
- subscribers.csv<\/em> is the name of the file in the CSV format<\/li>\n<\/ul>\n
Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\nPassword<\/strong>: the password for the FTP server<\/p>\nAuthentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\nUse active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/p>\nMask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n\nHow does the mask work?#<\/a><\/h2>\nFor example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\nIf you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\nDelete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary.
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548322211654-tasks_import_to_bl_s1_EN.png\")
<\/p>\nAfter filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\nClick Next.<\/strong><\/p>\n<\/p>\n
Step 2: Target<\/strong>#<\/a><\/h4>\nEnter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the type of contact data which will be added to the blacklist: Email<\/strong>\/Domain<\/strong>\/Md5<\/strong>, Phone number<\/strong>, or Dialing prefix<\/strong>.<\/p>\n<\/p>\n
Step 3: Recurring#<\/a><\/h4>\nThe last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\nFor example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n
![](\"https:\/\/help.expertsender.com\/wp-content\/uploads\/2024\/03\/1548322660767-tasks_import_to_bl_recurring_EN.png\")
<\/p>\n
After you specify your time frame, the scheduled import will be put on the calendar displayed below:
<\/p>\n<\/div>\n
\nImports to Data Tables#<\/a><\/h2>\nThis option allows you to automatically update your
To schedule a new import to lists, click Import to subscribers list<\/strong> under Imports to list<\/em>: You will see a wizard consisting of 5 steps:<\/p>\n In the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n Uri: <\/strong>the address of the file on a FTP server in one of the following formats: <\/p>\n <\/a><\/span><\/p>\n Where:<\/p>\n Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\n Password<\/strong>: the password for the FTP server<\/p>\n Authentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\n Use active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/p>\n Mask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n For example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\n If you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\n Delete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary.<\/p>\n After filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\n Click Next.<\/strong><\/p>\n <\/p>\n Enter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the list of subscribers with which you want to integrate the data from the file. <\/p>\n Click Next<\/strong>.<\/p>\n <\/p>\n At this step, all import settings need to be configured in the same way as in a standard import<\/a>. In the first box under Import settings<\/em> you will be able to specify what relation the imported data should have to the data already present on the list. When you are creating a brand new list, just leave the default options at the Import settings<\/strong> tab and click Next<\/strong>. Otherwise, you may decide if you want to add new subscribers to the list and\/or update or replace the data of subscribers who are already list members. Furthermore, if the imported file contains the data of subscribers who unsubscribed from the list or who were manually removed for some reason, specify if you want to import them again.<\/p>\n In the window below, specify the delimiter (the character which separates fields in each row) used in the file. If the file contains quotes, escaped characters, or comments, you may also specify a quote, escape and comment character respectively. Select the character encoding used in the file and the line from which data import should start.<\/p>\n Note that it is common in IT to start counting from 0, so the first line in a file has the number 0. However, the first line often contains headings, such as "Name", "Email" etc. You would not like the import mechanism to treat such a line as containing real subscriber data, and this is why you have the opportunity to start from line 1, or any other line in the file.<\/p>\n<\/div>\n<\/div>\n Below you will see a column preview with the data extracted from the updated file: If the division into columns is correct, click Next<\/strong>.<\/p>\n <\/p>\n In step 4, choose the matching mode:<\/p>\n If you already have any other subscriber lists, it may be the case the subscriber you are adding is already a member of one of those lists. In such a case, all of the fields which were filled while adding the subscriber will be reused now and updated accordingly. Choose the Matching mode<\/strong>, i.e. the criterion which will be used for comparing subscribers across lists: Email<\/em>, Phone <\/em>or Custom subscriber ID<\/em>. It is important that all three parameters are unique within the whole business unit. Updating one of them will update the other two.<\/p>\n<\/div>\n In the next box, map the columns from the file to the fields which will be stored in the database. For example, if the first column contains email addresses, import it as Email<\/em>. If another column contains the subscriber's first name, import the column as First name<\/strong>. You may choose not to import certain columns you deem unnecessary.<\/p>\n Remember that in order for the system to be able to properly import custom fields, they need to be created first! See Custom fields<\/a> for more details.<\/p>\n<\/div>\n<\/div>\n Click Next<\/strong>.<\/p>\n <\/p>\n The last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\n For example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n After you specify your time frame, the scheduled import will be put on the calendar displayed below: This option allows you to automatically update your suppression lists by importing them from ftp or a file at regular intervals.<\/p>\n The table under Imports to suppression lists<\/em> displays all of the scheduled imports to suppression lists which are currently active, inactive, deleted or in draft.<\/p>\n To schedule a new import to lists, click Import to suppression list<\/strong> under Imports to suppression lists<\/em>: You will see a wizard consisting of 4 steps:<\/p>\n In the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n Uri: <\/strong>the address of the file on a FTP server in the following format: <\/p>\n Where:<\/p>\n Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\n Password<\/strong>: the password for the FTP server<\/p>\n Authentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\n Use active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/span><\/p>\n Mask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n For example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\n If you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\n Delete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary.<\/p>\n After filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\n Click Next.<\/strong><\/p>\n <\/p>\n Enter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the list of subscribers with which you want to integrate the data from the file. <\/p>\n Click Next<\/strong>.<\/p>\n <\/p>\n In the File settings<\/em> window, specify the delimiter (the character which separates fields in each row) used in the file. If the file contains quotes, escaped characters, or comments, you may also specify a quote, escape and comment character respectively. Select the character encoding used in the file and the line from which data import should start.<\/p>\n Note that it is common in IT to start counting from 0, so the first line in a file has the number 0. However, the first line often contains headings, such as "Name", "Email" etc. You would not like the import mechanism to treat such a line as containing real subscriber data, and this is why you have the opportunity to start from line 1, or any other line in the file.<\/p>\n<\/div>\n<\/div>\n Below you will see a column preview with the data extracted from the updated file: If the division into columns is correct, click Next<\/strong>.<\/p>\n <\/p>\n The last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\n For example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n After you specify your time frame, the scheduled import will be put on the calendar displayed below: This option allows you to automatically update your blacklists by importing them from ftp or a file at regular intervals.<\/p>\n The table under Imports to blacklists<\/em> displays all of the scheduled imports to blacklists which are currently active, inactive, deleted or in draft.<\/p>\n To schedule a new import to lists, click Import to blacklist<\/strong> under Imports to blacklist<\/em>: You will see a wizard consisting of 3 steps:<\/p>\n <\/p>\n In the first step, specify the address of the CSV file from which the data will be imported and provide the credentials necessary to access it:<\/p>\n Uri: <\/strong>the address of the file on a FTP server in the following format: <\/p>\n Where:<\/p>\n Login<\/strong>: the user name for the FTP server (the same as domain.com<\/em> in the Uri)<\/p>\n Password<\/strong>: the password for the FTP server<\/p>\n Authentication mode (only for FTP)<\/strong>: if the FTP server uses the TLS or SSL technology for authentication, you may specify it here. Otherwise, leave the (none) value.<\/p>\n Use active connection mode<\/strong>: if the FTP server allows you to connect using the passive connection mode, you may leave the checkbox unchecked. If it doesn't work, check it to try the active connection mode.<\/p>\n Mask for importing multiple files, e.g. *.csv (only for FTP\/SFTP)<\/strong>: Fill in this field only if you are importing more than one file at once. Mask <\/em>is a string of characters which reoccurs in the names of all files which should be imported. <\/p>\n For example, you have an FTP server which is replete with data and files. However, you do not want to import all of them, since only a couple are relevant to you. Then it is advisable to rename all relevant files by including a keyword in the name, e.g. import<\/em>: import_subscribers1.csv<\/em>, import_key_subscribers.csv<\/em> etc. Then, using the word import <\/em>as a mask <\/em>will help you target only these files which contain in their names.<\/p>\n If you are importing one specific file, leave this field blank.<\/span><\/p>\n<\/div>\n Delete file(s) from remote server after download (only for FTP\/SFTP)<\/strong>: when this checkbox is checked, the .csv file is deleted from the server after each import. Since ExpertSender will upload the file each time under the same name, then, in essence, the only difference is in how you will upload the file to FTP. If it is convenient for you to simply write the file, then set the checkbox for deletion. If you can overwrite the file located on FTP, then deletion is unnecessary. After filling in all fields, click Check file<\/strong>. If the access data are correct and the system finds the file, a pop-up message will inform you that the file is ready for download.<\/p>\n Click Next.<\/strong><\/p>\n <\/p>\n Enter the name of the task, which will be displayed on the list of scheduled tasks, as well as select the type of contact data which will be added to the blacklist: Email<\/strong>\/Domain<\/strong>\/Md5<\/strong>, Phone number<\/strong>, or Dialing prefix<\/strong>.<\/p>\n <\/p>\n The last step allows you to specify the interval at which the automatic import will be carried out. There are multiple options available which will let you indicate very precisely within what Date Range<\/strong> (e.g. Next 7 days<\/em>, Next Month<\/em>, All dates after<\/em>…, etc.) the imports will take place, at what time, and how often (e.g. Every day<\/em>, on the 8<\/em>th day of the month, on Monday<\/em>, etc.).<\/p>\n For example, in the following configuration the import will take place every day from 1\/31\/2019 onward, exactly at 3 P.M.:<\/p>\n After you specify your time frame, the scheduled import will be put on the calendar displayed below: This option allows you to automatically update your <\/p>\n#<\/a><\/h4>\n
Step 1: Source#<\/a><\/h4>\n
ftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u>\nftp:\/\/domain.com\/subscribers.csv<\/u><\/span><\/pre>\n\n
How does the mask work?#<\/a><\/h2>\n
<\/p>\nStep 2: Target<\/strong>#<\/a><\/h4>\n
Step 3: Import setup#<\/a><\/h4>\n
From which line should I start?#<\/a><\/h3>\n
<\/p>\n<\/p>\nStep 4: Map columns#<\/a><\/h4>\n
Matching mode#<\/a><\/h2>\n
Warning#<\/a><\/h3>\n
<\/p>\nStep 5: Recurring#<\/a><\/h4>\n
<\/p>\n<\/p>\n<\/div>\nImports to Suppression Lists#<\/a><\/h2>\n
<\/p>\n#<\/a><\/h4>\n
Step 1: Source#<\/a><\/h4>\n
ftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u><\/pre>\n
\n
How does the mask work?#<\/a><\/h2>\n
<\/p>\nStep 2: Target<\/strong>#<\/a><\/h4>\n
Step 3: Import setup#<\/a><\/h4>\n
From which line should I start?#<\/a><\/h3>\n
<\/p>\n<\/p>\nStep 4: Recurring#<\/a><\/h4>\n
<\/p>\n<\/p>\n<\/div>\nImports to Blacklist#<\/a><\/h2>\n
<\/p>\nStep 1: Source#<\/a><\/h4>\n
ftp:\/\/domain.com@ftp.esv2.com\/subscribers.csv<\/u><\/pre>\n
\n
How does the mask work?#<\/a><\/h2>\n
<\/p>\nStep 2: Target<\/strong>#<\/a><\/h4>\n
Step 3: Recurring#<\/a><\/h4>\n
<\/p>\n<\/p>\n<\/div>\nImports to Data Tables#<\/a><\/h2>\n