Category: Newsletters

« Add unsubscribe instructions to each newsletter » fonction in newletter.

When you clic « unsubscribe from this newsletter » in newletter mail, tiki suppress the wrong adress.

For exemple, y try to suppress yan.turgeon@cipuf.org and tiki suppress marianne.laroche@cipuf.org.

UPDATE: It's not a regression, sorry for the noise (I was confused). {sign user="xavi" datetime="2013-11-18T13:09:45+00:00"}

Usability improvement: nl1 missing in route.php for newsletter1

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

The use of an outside mail-list system is not unusual.

I'm using [http://feedblitz.com|FeedBlitz.com] to get newsletters to users.

It would be nice to have the FeedBlitz system integrated with the Tiki registration module.

Here is what their Knowledge base says about integrating this kind of requirement.

I'm testing a tiki replacement for our old CMS Made Simple CMS. I'm using the Fivealive Theme and I've set read permissions for anonymous visitors to view newsletter archives though they have to subscribe. In that window to subscribe there's a CaptCha code but there isn't a dialogue box for entering an email address to subscribe. However, when I enter the code, I get the following response:

"Newsletters Help

Thanks for your subscription. You will receive an email soon to confirm your subscription. No newsletters will be sent to you until the subscription is confirmed."

Obviously, that can't happen without having an email address to send the confirmation to.

I've tested this in Konqueror, Chromium and Firefox in an Ubuntu environment; Chrome, IE9 & Firefox in Win 7 Ultimate environment; and Firefox and IE8 in an XP Pro environment. All with the same interface results.

{syntax type="tiki" editor="plain"}
In these last month of june or july 2011, some regression seems to have been introduced in proposals/6x, which produces that maketoc create the output twice, when sending a newsletter from a wiki page template.

{syntax type="tiki" editor="plain"}
I created a test newsletter on a new tiki 4.x (using recent svn, similar to tiki4rc1)

* Switched editor to wysiwyg
* copied some content from this page: http://en.wikipedia.org/wiki/Paul_R._Ehrlich (from the title "Paul R. Ehrlich" until the title "other activites" (so that, it's including also a few images available on the internet, in case it matters)
* cliked on the switch editor button (to go back to a normal editor showing wiki syntax)
* a blank page is produced, after 10-15 seconds.

{syntax type="tiki" editor="plain"}
There is already an option to add an unsubscribe link to the bottom of each Newsletter sent out, but this is a new request to be able to add that unsubscribe link to the email's headers.

Here are two articles that go into more detail about what is needed:

[https://digitalmarketinginstitute.com/blog/google-yahoo-email-changes-what-do-they-mean-for-marketers|Google & Yahoo Email Changes 2024: What Do They Mean for Marketers?]

[https://postmarkapp.com/blog/list-unsubscribe-header|List-unsubscribe headers: Here’s everything you need to know]

I copied, and redacted, this from an email header that complies:
{INDENT()}
Subject: *** *** ***
From: "***.com" <***@***.com>
Reply-To: =?utf-8?Q?***.***?= <***@***.com>
To: <***@***.com>
Date: Wed, 10 Jul 2024 18:12:15 +0000
Message-ID: &lt;0c5fce4d5ca3d085d.5d6f829.202120.027e2fd.f6a2d6@***.net&gt;
List-Unsubscribe: &lt;https://***.us11.list-manage.com/unsubscribe?u=0c5fce45a13d85d&id=a2fc1a946&t=h&e=25df82c19&c=024d72f&gt;, &lt;mailto:unsubscribe-***0a64a13dd.02fd-282c19@unsubscribe.***.net?subject=unsubscribe&gt;
List-Unsubscribe-Post: List-Unsubscribe=One-Click
Content-Type: multipart/alternative; boundary="_----------=_MCPart_1392722314"
X-IncomingHeaderCount: 25
Return-Path:
{INDENT}

add antibot captcha for anons to newsletters, calendars and tracker item comments

Add ip to syslog and/or action log, so that when anons (at least) are allowed to add content and it's spam (robots seem to be able to post with our current antibot captcha), there is way to identify the ip of the spammer.

So far, antibot captcha is added (in trunk, at least) to:
* wiki edit
* wiki page comments
* forum posts
* tracker item comments
* freetags
* calendar items
* newsletter subscription

The action of adding content on those features should be logged in syslog and/or action log and IP recorded.

Currently, an administrator of a Tikiwiki installation has to hunt for upgrades, updates, and security related information of his installation. It is often cumbersome and sometimes dangerous, think of the delay in fixing a crucial vulnerability, it has happened elsewhere before. It might also be nice to know that ppl are using current and feature complete software.

This is flagged as a regression but it is in both 12.x and 13.x so may be an old bug ....

... but when a newsletter previously created with the wysiwyg editor (ie it has had the various HTML flags set), it shows the raw html when it is retrieved from the archive for simple viewing - but it is OK if retrieved for immediate resending

.. just to confirm that this is still a bug in Aug '15 at r 55993

{syntax type="tiki" editor="plain"}
I just sent a newsletter to 26 users using Tiki29.

While sending I received messages that the Newsletter was succefully sent.
One row per email + a counter so if I believe Tiki feedback.
26 emails received 26 newsletter.

BUT one the address was one I control at Gmail and I didn't received the newsletter.
It was not in the spam.
I didn't received an error on my sending email.

That a terrible failure because now I don't if ANY of my newsletter was really sent and I have no real course of action.
I'm against sending the newsletter several times as this is not professional + can lead to blacklist my email.

Feedback tool MUST be reliable.

This was working quite well in 9.x: images from article topics, and tracker images were shown in the emails sent by tiki newsletters. In Tiki12, they are not shown anymore (links to the images miss the domain name in the url.

Example of url from a missing image (from a tracker item image) in the email:
http://img/trackers/cbc123f5818f99ffa55c3befd01d1a65

Images from rticle topics are not included in the email either, it seems.

---
Images broken also even if I enable the setting "Add BASE tag in the page HEAD" (in Admin home > Look & feel > Miscellaneous". {sign user="xavi" datetime="2014-03-05T13:11:24+00:00"}
---

u: admin
p: 12345

To reproduce:
* Add your email in the recipients of the newsletter 1
+ http://xavi-9794-5162.show.tikiwiki.org/tiki-admin_newsletter_subscriptions.php?nlId=1
* Go to send newsletter 1:
+ http://xavi-9794-5162.show.tikiwiki.org/tiki-send_newsletters.php?nlId=1
* Add a title and select the "Newsletter template 1" in the dropdown of "Apply content template"
** You will that the homepaeg is shown in the newsletter, with some images.
* Click at the button below "Send Newsletter" & "Send"
* You will be missing images from article topics and tracker images (image field and file field)
** the only shown image is hte one with a manual inclusion with img src= and absolute url. (the tiki logo in red)

On the "Send Newsletters" page, click on "To add a file, click here". Nothing happens. In IE, the message "Error on page" appears in the browser status line.

possibilities:
http://phpmailer.codeworxtech.com/
http://www.swiftmailer.org/
http://framework.zend.com/manual/en/zend.mail.html


Related:
SMTP Configuration from inside Admin Interface
http://dev.tikiwiki.org/wish1711

Since this is vast project, we'll use a wiki page: ((CRM))

[Edit, 2 April 2016, Torsten]
The bug seems to be fixed by rjsmelo r58016 - ( thx Nelson for emailing me).
Before I close, I want to do a more in-depth test later to night or so, but it really seems to work (did resend out a wikisyntax-wysiwyg html+ txt version newsletter, that previously caused false encoding when received and today it was sent and received smoothly and intact).

Before I describe in detail, I`ll setup a show instance.

This is error message:

Context:
File /tiki-newsletters.php
Url /tiki-newsletters.php
Query:
insert into `tiki_newsletter_subscriptions`(`nlId`,`email`,`code`,`valid`,`subscribed`,`isUser`) values(?,?,?,?,?,?)
Values:
0 16
1 marclaporte
2 f5c1651f42442974d3114db487c55be4
3 n
4 1142651354
5 y
Message:
Error Message Duplicate entry '16-marclaporte-y' for key 1

When newsletters are edited using the wysiwyg-html edit, extra lines are added.
Tested on Tiki 12.4svn

Will setup a show instance.

Tiki14 has the same problem. I haven't tested other version.
This problem makes it impossible to work with newsletters in html.

I will paste long test results that i posted in forum at the end.

Simple explanation is that my HTML email that i send as newsletter gets corrupted by my MTA. Pretty sure this is a Tiki issue since i get 100's of correctly formatted html email every day.

------------

Been pulling my hair out for hours trying to figure this out; decided to try searching forum (will someone with admin please enable full text search on this site???). Came across this post that sounds much like my problem. Doubt anyone still watching this post but maybe Sylvie is still keeping an eye on it.

I have authored a very lovely, very html rich newsletter. Thought it would be very cool to use TW to send this as an email (ala TW Newsletter). But my email seems to be getting corrupted in numerous very confusing manners. Like I said I have run about 50 tests so far and results are a bit sporadic… so just a few of the results:

- the html file I am trying to use as content for my newsletter can be seen (perfectly I might add) I a browser at [http://www.ottawavolleyball.com/newsletters/nl_0505.htm]


- nl preview almost always looks correct – but not always (can’t handle background style color setting for example – but no big deal)
- I am using a few different mail programs and different mail servers
o mozilla mail, Outlook, and webmail
o my ISP mail account and the mail server that run myself

- basic issue is that when I look at the email – it is messed up
- looking at the html source that my email program spits out I see 3 basic types of corruption:
o characters being lost (ex. link to gif is http://domain/ball.gif and it ends up as http://domain/bll.gif)
 this of course shows up when viewing the email as a missing graphic
o characters are being inserted
 the “=” character is being thrown in all a lot ; and sometimes the character string “3D” – which amazingly enough is ASCII for .. you guessed it – the “=” character
 this of course has a similar effect to characters being lost

the REALLY messed up part of this problem is what is consistent and what isn’t:

- my ISP mail account generally works better
- errors are repeatable – sending same email over and over will always same corruption
- that corruption is mostly repeatable between Outlook and Mozilla – but not completely

Like I said I have far more details test results – but I figure if someone knows the answer to my problem – they likely already know it from what I have reported so far.

My final test was to simply scrap the whole formatted html newsletter idea and just send a text email giving link to see html nl in browser. My simple one liner with a link also gets corrupted but only when going through my email server (my ISPs works fine).

Any thoughts would really save me a lot of hair…

cheers,
peter….

{syntax type="tiki" editor="plain"}
When Gzip output is enabled under Admin | Spped & Performance, it is not possible to send out newsletters greater than 100 in number, if at all. When attempting to send newsletters, it shows a 'Cannot load page' message in the frame where the log of email addresses normally appears.

A user registered himself, and chooses as login a name with uppercases (Stephane).

Two newsletter are created, with different subscriptions:
1) group subscription, including the aforementioned user
2) user self subscribe

When sending newsletter 1, the email is sent to the user.
When sending newsletter 2, the email address of the user is not found in the database and cannot be sent (despite finding the correct number of subscribers)

I traced it to two libraries:
first in ./lib/newsletter/nllib.php, in the function get_all_subscriber, we can see in the first part of the function how the email adresses are collected based on the subscribed groups. The select is mostly direct, and gets the correct information.
Later in the function (line 215 and following), individual users are added to the list of emails. Line 218, the "email" from the table tiki_newsletter_subscriptions (which is the login for registered users) is brought to lower case. (Note: I'm not sure, but it could be that the subscription module also puts the login in lower case in that table...)
Finally, line 232, the function get_user_email uses as parameter this lowercase login name to find out the actual email address.

This function is defined in the library ./lib/userlibs.php on line 5581.
This function compares the login passed as parameter to the login in the users_users table, but with a "binary" comparison, i.e. case sensitive! Removing the binary keyword lets the newsletter module find the correct user, and then its email.

{syntax type="tiki" editor="plain"}
To reproduce

# Install a fresh Tiki
# Create some usernames as usual
# Set "Use email as username" feature to yes
# Create more users (this time, username will be the email)
# Create a newsletter
# Subscribe the Registered group to the newsletter
# Send a newsletter

The system will crash and be unable to send the newsletter because some users don't have valid emails. If you error reporting is activated, you will get a message like this:

{CODE()}
System error.

The following error message was returned:

Duplicate entry '3-mcradmin-g' for key 'PRIMARY'
The query was:

INSERT INTO `tiki_newsletter_subscriptions` (`nlId`,`email`,`code`,`valid`,`subscribed`,`isUser`,`included`) VALUES (?,?,?,?,?,?,?)
Values:

3
mcradmin
6b78cc21c16e768dd8fbb6b538c6bf78
y
1339700591
g
n
The built query was likely:

INSERT INTO `tiki_newsletter_subscriptions` (`nlId`,`email`,`code`,`valid`,`subscribed`,`isUser`,`included`) VALUES ('3','mcradmin','6b78cc21c16e768dd8fbb6b538c6bf78','y','1339700591','g','n')
Things to check:

Is your database up and running?
Is your database corrupt? Please see how to repair your database
Are your database credentials accurate? (username, database name, etc in db/local.php)
Did you complete the Tiki Installer?
Please see the documentation for more information.
{CODE}

Hi,

as written to the dev list, I had the problem to restrict access to some newsletters but not to all. I found a solution, but I am not sure, if this breaks nothing else. Here is the problem:

I want to set up some newsletters: One with access from anybody (anonymous users can subscribe and view the archive) and some others with access only for special groups of users.

On global permission page I set 'tiki_p_list_newsletters' and 'tiki_p_subscribe_email' for anonymous users (this permissions are not available on the object permission page).

On the object permission page for the single newsletter (accessible through /tiki-admin_newsletters.php and the key icon of every newsletter) I activate 'tiki_p_subscribe_newsletters' and 'tiki_p_view_newsletter' for the group of users with permissions on this newsletter.

With this settings I would expect, that an anonymous user browsing page tiki-newsletters.php would see the list of newsletters, in this case showing only the public newsletter. But in this case there is an error (You are not logged in). As a privileged user (allowed to see all newsletters) the page is accessible but empty, not showing any newsletter.