How To Send Personalized Serial Mails (With Variables)
Personalized Serial Mails In Six Steps
Is your u5CMS installation up-to-date and ready for this functionality?×
For the functionality described on the page at hand, make sure you are using a current u5CMS version. You'll find the version number by surfing to your website and switching your browser to show the HTML source code. At the very bottom of the source code you'll find a line like this:
<!-- This site runs with u5CMS version 12.4.3 from https://yuba.ch/u5cms -->If there is no such line or no version number or one lower than V8.3.3, see the following instructions:
u5CMS — How to update an existing installation (version 4 and above)
A) If the layout does not look right after having done step 7, go to https://urltoyouru5cmsfrontend/u5admin and open a css-object (e. g. csslayout) in PIDVESA's S special function's code (htmltemplate & css) section and safe it!
B) If your navigation does not look well, copy this code to cssnavleft in PIDVESA's→S→Code and this code to cssnavleftsubtop in PIDVESA's→S→Code and this code to cssnavtop in PIDVESA's→S→Code
×
These update instructions are for u5CMS versions 4 and above. For versions below 4 read this!
- On your server, go to the files of your old (current) u5CMS installation and copy config.php to config.old.php
- Download the ZIP-File , unzip it and delete the file favicon.ico
- Further, delete all contents in folder r EXCEPT runonce.php
- Transfer the remaining files and folders from the ZIP file over the existing installation (FTP upload)
- Now, on your server, copy the database connection parameters $host $username $password $db from config.old.php to config.php If there are other dedicated settings in config.old.php, set the same in config.php (compare parameter by parameter)
- You must now log in to the backend of your (now updated) u5CMS installation via https://urltoyouru5cmsfrontend/u5admin and open a css-object (e. g. csslayout) in PIDVESA's S code section, for your site to work correctly again.×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
- You must now log in to the backend of your (now updated) u5CMS installation via https://urltoyouru5cmsfrontend/u5admin for that the database will be updated too
A) If the layout does not look right after having done step 7, go to https://urltoyouru5cmsfrontend/u5admin and open a css-object (e. g. csslayout) in PIDVESA
×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
B) If your navigation does not look well, copy this code to cssnavleft in PIDVESA
×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
C) If after A) and B) the layout still does not look right, change the doctype <!DOCTYPE html> to the old one
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
This feature is bug free since u5CMS version 5.1.6. Please update if necessary.
1. Surf to the formdata page http://yourdomain/u5admin/formdata.php. You can find the formdata page in the CMS backend too, in PIDVESA
×
- PIDVESA: The very right column of your u5CMS backend is your repository. PIDVESA stands for Pages, Images, Documents, Videos, External Links, Special Functions, and Account. Find these things by clicking the respective radios P I D V E S or A in the top right corner of your backend screen; cf short reference (pdf)
2. There, click the "mail"-link of an existing dataset or import data from Excel (the columns in your spreadsheet must have headers. Choose "1st row..." in the header-import-dialogue).
3. Make sure that all e-mail addresses are structurally valid, meaning having the @-character, and at least one valid character on its left, and at least 3 valid characters on its right whereas one must be a full stop (but not the first nor the last one, and never two full stops directly following each other, and of course no whitespace, no commas, colons, semicolons a.s.o.).
3. Now you see your data (or an extract of it) formatted as an HTML-table.
4. At the bottom of the page you'll find the link Send serial mails to the above data selection. Click it.
5. Now you see the mail editor. Click the new mailjob-button there and enter a subject.
6. Write the e-mail now. Variables referencing to your data table column-names have to be written in square brackets. Please read the text "Available variables (Instructions)"; you'll find this link in the upper left corner of the mailing area.
How many mails can be sent?
Your provider usually is limiting the number of mails sent, e.g. 250 mails per hour. If you have to send more mails than the limit allows, set $serialmailmethod=1; in your u5CMS's config.php (works bug free since u5CMS 5.1.6). If your project contains more than 4000 recipients, split it.Legal notice
Do not send spam with the serial mail functionality of u5CMS. Send only (serial) mails to recipients who want/need to receive these mails (opt-in).Example
From: Xavier Yaonden <xavier.yalonden@alphauniversity.edu>
To: [nameoftheemailcolumn]
Cc:
Bcc:
Subject: Your abstract [?ID] has been accepted
Message:
Dear [sex|1|Mr][sex|2|Ms] [name*]
We are glad to inform you that your abstract
[?ID] [title*]
has been accepted as [presentationformat].
[presentationformat|fullpaper|Your presentation consists of 20 minutes speech and 10 minutes discussion.]
[presentationformat|poster|The postersessions take place on Monday, August 1 2016 2pm-4pm in Hall 1.]
Regards,
Dr. Xavier Yalonden
Congress Administrator
Notice
Some providers (e. g. green.ch) are picky when it is about sending e-mail with PHP. If e-mails are not sent, configure SMTP* in your u5CMS's config.php !*bug free since u5CMS version 5.1.6
