Page History

Import of subscribers 

If you already have information about your subscribers or customers, BACKCLICK lets you import this data into the database. 

Image Added 

Abb. 7.4 - Abonnenten - Verwaltung 

To import your customer data (i.e., customer base) in BACKCLICK, you must compile this data into an ASCII-file. Every data set of your customer has to be written in one line, with the data fields separated by a tab. Please enter the data field name (such as TITLE, LASTNAME) in capital letters in the first line of your document. This import data are is very important for the allocation of customers to your newsletters. You therefore define the data field “Newsletter,” and this will be the last column of your import data. 

The import is based on the data fields of your subscriber's database which you have built with the database designer. You may define data fields for the base data of your subscriber (e.g., NAME, ADDRESS) or for the social demographic data of your subscriber (e.g. AGE, FAMILY). These are field names. It is only possible to enter the existing data fields into your Import file. This also applies for the IDs of your mailing lists. You are only able to subscribe customers on a mailing list if the mailing list ID already exists. PLEASE NOTE: EMAIL and NEWSLETTER are required fields, and must be written in capital letters. You may use Excel® for building your file. As shown in the figure, the field names are to be written into the first line of the file, and you are then able to relate the value in the subscriber's line. If you want to define more than one value for one subscriber, please separate them with (for example) “;” or “-”. Do not use dots or commas, because these will cause system error. You may now save the file in Excel as “text (tab separated)” and give it a name.Now, click on “subscriber management” in your Main Menu, and choose “subscriber import” in the submenu. By using the “Search” button, you may now search for your file. With a click on the Image Added-button, the file will be listed in your import file list. 

Image Added 

Abb. 7.4.1 - Abonnenten importieren 

If you now want to start the import of your file, please click on the “Import” button in the corresponding column of your table (see end of Part 2). You will see the progress of your import in a separate browser window which that will be opened by BACKCLICK. You will get information about invalid subscribers, new subscribers, and subscribers who were in the system before, and are being updated simultaneously. 

The following functions are available while importing: 

Configure default values 

If you want to import subscriber's data that may be incomplete, you may define standard values for empty fields. 

Clicking on this Image Addedsymbol will open the following interface: 

Image Added 

If you have an import file where no value is related to a field name, this empty field will be filled with the defined standard value. 

Anti-SPAM:

If you activate this function, no subscriber who checked out from a mailing list will be able to subscribe to this mailing list again. BACKCLICK observes every checkout and saves it in its database. Even in the event of a complete loss of e-mail addresses in the database, BACKCLICK will still refer to the checkout and consider it if there is to be a new import. 

eMail-Check:

The import routine is able to check every e-mail address as to its syntactical accuracy, considering the RFC rules. Invalid e-mail addresses will not be imported — they will be excluded from import. If you deactivate this function, every address, even if incorrect (e.g., testperson@test.aolaolaol) will be imported by BACKCLICK. These e-mail addresses with a syntactical error will be sorted out after one of your next mailings, using the Bounce Filter (IMF-Filter). 

Activate MX-Lookup

If you activate this function, BACKCLICK will initiate a domain check that will read the domain endings, compare them to common domain endings, and sort out the incorrect ones. 

Activate removement

You may decide here what BACKCLICK should do with these incorrect e-mail addresses while importing. If there are any empty fields in your import file and the subscriber already gave you the information required, BACKCLICK may either erase the information or ignore the empty field (default: information in the subscriber’s database will never be erased). In that case, the import is additive. Information which that has not been in your subscriber's database will then be added to the subscriber's profile. 

Number of data sets 

You may decide here how many data sets should be edited at once. BACKCLICK will put all your subscribers into n blocks (e.g., 10,000 subscribers/1,000 = 10 blocks/update per loop). PLEASE NOTE: If the chosen value is too big and the progress update is done too often, the system might not be as stable as before, but the speed of the import may be increased. Values you may choose are between 100 and 10,000. Default value: 1,000. 

Image Added 

Abb. 7.4.2 - Abonnenten importieren 

Send welcome e-mail 

This lets you activate the automatic sending of a welcome e-mail to new subscribers on a mailing list. You have already set this welcome e-mail in your mailing-list configuration. 

Mailing lists 

The customers may be subscribed the lists shown here. PLEASE NOTE: If you choose a mailing list here, the values of your import file will be ignored. The data field NEWSLETTER must therefore not exist in your import file. 

All of your files ready for import will be shown in a table at the end of all these setting possibilities. To start the import, please click on the --Button. You will get the following information in a separate browser window: 

Image Added 

The number of imported subscribers will be shown here, along with whether or not the import was successful. Clicking on the 

(Image Added) will open another browser window that shows you the textual analysis of the import: 

Image Added 

Description of the analysis: 

• Name of import list: name of the just imported file/list.
• Number of subscribers: number of all he the subscribers on the just-imported list. Invalid: the number of invalid subscribers/e-mail addresses is shown here (e.g., 0 of 20 imported subscribers).
• Double: The number of subscribers/e-mail addresses which that already existed in BACKCLICK (e.g., 0 of 20 subscribers).
• Robinson
• blocked: the number of blocked subscribers/e-mail addresses is shown here. These subscribers/e-mail addresses are on the Robinson
• list, and cannot be imported because the user (subscriber)
• has forbidden the use of his or her e-mail address for any newsletter mailing from anyone (e.g., 0 of 20 subscribers).
• Antispam blocked: If this function is activated, no subscriber who has once checked out from a mailing list may ever be imported over the import routine
• again (e.g., None of the subscribers).
• MX-Lookup blocked: The import routine may start a an MX-Lookup for every subscriber, to check
• whether or not the domain of the e-mail address exists. Invalid e-mail addresses may be filtered out while importing (e.g., none of the subscribers). Number of subscriber's updates: the number of subscribers who had already been in the system before the import is shown here. The new import
• causes an update of these subscribers (e.g., 3 of 20 subscribers have been updated here).
• Number of new subscribers: the number of the newly imported subscribers is shown here (e.g., 17 of 20 subscribers are new).

If you want to delete an import list from your table, you need to mark it in the box behind the list and click on the 

Image Added-button. The file will be erased without further notice from the system. You cannot import this file again until you 

upload it once more. If you have completed your imports, click on the Image Added-button to get back to the Subscriber 

Management menu.