EXT: Newsletter Subscription Module¶

Adding additional fields to the form¶

When a user subscribes to the newsletter you might already know things like his name or email address since a login user is required! But if you need to collect further information you can add additional fields to the subscription form. For that purpose you can enter FORM- configuration code into the field User Information Form. Use the formwizard if you like.

Clicking the wizard button will bring you this interface for adding, deleting and moving the form fields around. Dont use the types for fileupload, hidden value and submit button. They make no sense in this context.

Creating categories¶

Now, create some categories on the page where the plugin is inserted:

You can enter a description for each.

Basically thatis it! On the webpage you should now see something like this:

The actual look depends fully on your specific website. This is just an example.

Using the subscription form¶

Notice that the above screenshot shows no form for entering data or selecting newsletters! You will have to log in first (as the message in the bottom states as well). If you think you need to tell this louder and clearer to your visitors, just add another content element on the page explaining any detail you like about the newsletter subscription.

So after a successful login the newsletter form will look like this:

A better method¶

There is a more advanced approach where you can make very precise selections of subscribers. First select the menu item "Subscriber list" in the function menu:

In the screen you can select subscribers based on which list(s) their are or are not subscribed to (1). Further you can select subscribers based on their user data or email address (3). You can even select subscribers based on criteria from the ad-hoc form with user data entered during subscription (4). In both cases criterias can be combined by AND or OR clauses (5). For the output (6) you can also select which information to list in the CSV-list by checking of the fields you want (2).

Combining subscribers across newsletters¶

The first thing you'll have to do in the process of getting a list of subscribers is to make a combination of the newsletters. You have the following options:

The actual selection is explained just beneath the selectors, so the best thing you can do basically is to experiment a little on your own. Notice how this works on this picture:

So by these selections you will get all subscribers from the "Powertools" as long as they are also represented either "Foor news" or "News movies".

Here is another example:

Now subscribers must have subscribed to both "Food news" and "Powertools" categories. However if the user is also subscribed to "News movies" he will be excluded from the selection.

By default all subscribers to any newsletter will be selected if none of the selector boxes are set. That would yield the same result as if you set all selectors to "OR subscribed..."

Selecting on user data¶

Not only can you select subscribers based on their selection of newsletters. You can also limit the result set based on information in their user-records (fe_users) if they are logged in. If you have non- users in you subscription list you can only select on the email address. (By default you can only select on the email address anyways!)

This is the options for selection:

The selection is done by the SQL-query. The string matching is case- insensitive and the less than/greater than options will also work for strings, since MySQL supports this.

Selecting based on the local user data¶

The newsletter subscription has a great feature which is to allow ad- hoc fields in the subscription form. Because you can add any number of fields of any kind you cannot see them in the TYPO3 backend as usual. They are stored internally in the subscription database table. But you can extract them and select on them as with user data fields like username etc.

In this example we select all subscribers that has entered a name which contains the string "kasper" (whether upper, lower or mixed case - that doesn't matter). Further the subscriber must have either brown or blond hair color. And they must NOT like pizza! (The NOT flag is set)

In the result we will see the name, hair color and pizza-flag included:

Notice: The clause "less than" and "greater than" cannot select on strings in this case! It will work only with integers or double values.

Output format¶

There are two formats to choose from at this time:

"Simple email list" will produce a result like this:

If you set the flag "Guarantee unique email addresses" you will see no duplicates:

The more advanced format - which can be imported into a spreadsheet like Excel - is the CSV list:

If you set the "Download result as file" and press the button again you'll be able to store the result as a file:

You can open the file in a spreadsheet. This is how OpenOffice Calc handles the import process:

... and the result after clicking OK is:

Storing and loading presets¶

Most likely you want to do the same extract of subscribers again and again. For instance you want to mail a weekly letter to all subscribers of "Powertools" and "Food news" who lives in zip-code from 1200-1400. So you set up these criteria:

After having set the criteria, store the settings by entering a name in the bottom of the page and press "Save current query as:".

After that you will see the preset in the preset box and you can load it again next time. Just select it and press "Load preset":

menu.function.1¶

menu.function.2¶

fe_users_fieldList¶

[page:mod.web_txdanewslettersubscriptionM1; beuser:mod.web_txdanewslettersubscriptionM1]

((generated))¶

mod.web_txdanewslettersubscriptionM1.fe_users_fieldList = username, email, zip

sorting_field¶

sorting_desc¶

mode¶

mode.noAuthEmail¶

mode.sendNotificationWhenEmailMode¶

[tsref:plugin.tx_danewslettersubscription_pi1]

EXT: Newsletter Subscription Module - 19