[solved] Other ways to mark all users to receive HTML emails

Solutions for other phpList version 2 users
Forum rules
Please do not ask questions here, this is for Solutions you have discovered or come across.

[solved] Other ways to mark all users to receive HTML emails

Postby hitec555 » 10:11pm, Tue 24 Oct, 2006

I have just upgraded to the new version and now all my users and getting text only emails.

I look at any user at random and next to HTML email there is a blank box. I have added 1 to my user and this works fine.

Only thing is when using:

Mark all users to receive html

It does not change any users, I have also tried changing them all to text and back again still no change.

Sort of changing every user one by one I am really stuck!

Thanks for any help!
hitec555
phpLister
 
Posts: 5
Joined: 10:05pm, Tue 24 Oct, 2006

Postby H2B2 » 10:23pm, Tue 24 Oct, 2006

That is a strange one. I can't reproduce this on my 2.10.3 install, i.e. both reconcile users functions referred to in your post work fine.

Are all users members of an active list? Does your subscribe page allow for a choice between html or text messages?
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Postby hitec555 » 11:13pm, Tue 24 Oct, 2006

Hi,

no my subscribe page looks like this:

http://php.hitec-systems.co.uk/lists/

I have even started from a fresh install with a blank database then just used the CSV file I downloaded form the old list and imported into the new (test phplist) list still the same problem all users get text email and not html ones.

All users are within a list called 'intense'.

Really strange because when I change all to text I get a 3705 users changed. Then change back to html again 3705 users changed but then when I look at any user from random there is no tick within 'send html email to user'

I will just have to go back to the old version me thinks!
hitec555
phpLister
 
Posts: 5
Joined: 10:05pm, Tue 24 Oct, 2006

Postby hitec555 » 11:21pm, Tue 24 Oct, 2006

Unless any one has a mysql script to change all my users to html?

:lol:
hitec555
phpLister
 
Posts: 5
Joined: 10:05pm, Tue 24 Oct, 2006

Postby hitec555 » 12:43am, Thu 26 Oct, 2006

I am now getting 2 email's for every user.

1 x text
1 x html

per email address.


What has happend, this software was doing the job so well I cant say how happy we are with it. With out it is killing http://www.intenserecords.co.uk


cheers

paul
hitec555
phpLister
 
Posts: 5
Joined: 10:05pm, Tue 24 Oct, 2006

Postby H2B2 » 12:57am, Thu 26 Oct, 2006

hitec555 wrote:Really strange because when I change all to text I get a 3705 users changed. Then change back to html again 3705 users changed but then when I look at any user from random there is no tick within 'send html email to user'

Does the same thing happen when you subscribe test users through the subscribe page? If not, than something may have gone wrong during importing.

Did you check the user database table using phpmyadmin and/or the database checkup function of phplist?
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Postby H2B2 » 6:11am, Thu 26 Oct, 2006

You could also try importing with all users already marked to receive html in the csv file, like in this example:

first name,last name,city,street,email,Send this user HTML emails,phone
Joe,Doe,Santa Barbara,5 Lincoln Avenue,me@myhome.xyz,1,800-34565
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Postby hitec555 » 11:32am, Thu 26 Oct, 2006

Hay thanks for all your help. I will try this today!


:wink:
hitec555
phpLister
 
Posts: 5
Joined: 10:05pm, Tue 24 Oct, 2006

Great solution

Postby zoinksgraphics » 1:26am, Wed 01 Nov, 2006

I was racking my brains trying to figure how to set a batch of imported addresses to all receive HTML e-mails rather than the default of text e-mails. After failing miserably with hard-coding "commonlib/pages/importcsv.php" to do it, I came across this thread with the answer that did the trick.

Now the following format works like a charm when I import from a text file...

Firstname, Lastname, Email, Send this user HTML emails
Joe, Smith, joe@smith.com, 1

(Just be sure to change "Field delimiter" to ", ")

Thanks so much!! :D
zoinksgraphics
phpList newbie
 
Posts: 1
Joined: 1:16am, Wed 01 Nov, 2006

Postby sing1ejack » 2:03pm, Tue 19 Dec, 2006

So PHPlist recognizes the column name 'Send this user HTML emails' as one that corresponds the field 'htmlemail' in the mysql table 'user', right?

Does PHPlist recognize other column names as ones that relate to other database fields? Example: I would like to import a list of users that have already opted out. Could I name a field in the CSV file something that tell PHPlist to save the record as a blacklisted user?

name;email;blacklisted user;date
stan;a@b.c;1;1981-02-05
sing1ejack
PL Nut
 
Posts: 15
Joined: 2:04pm, Wed 22 Nov, 2006

An sql workaround

Postby Martin_bou » 8:29pm, Wed 02 May, 2007

I was having the same issue, and I ran the following command on my mysql database, from within php MyAdmin.

Note that your table name may differ, but the table is indeed user_user, mine has a prefix

UPDATE `phplist_user_user` SET `htmlemail`=1 WHERE `htmlemail`=0
Martin_bou
phpLister
 
Posts: 5
Joined: 3:10pm, Wed 08 Jun, 2005
Location: Montreal

SQL for changing the default HTML e-mail setting

Postby mat0ng » 12:27pm, Wed 02 Apr, 2008

If you want set HTML enabled by default for new users (manual add or CSV import) execute the following SQL on your phplist database:

Code: Select all
ALTER TABLE `phplist_user_user` CHANGE `htmlemail` `htmlemail` TINYINT( 4 ) NULL DEFAULT '1'
mat0ng
phpList newbie
 
Posts: 1
Joined: 12:25pm, Wed 02 Apr, 2008

Re: An sql workaround

Postby mhellenm » 7:53am, Fri 18 Jul, 2008

Martin_bou wrote:I was having the same issue, and I ran the following command on my mysql database, from within php MyAdmin.

Note that your table name may differ, but the table is indeed user_user, mine has a prefix

UPDATE `phplist_user_user` SET `htmlemail`=1 WHERE `htmlemail`=0


I tried the method, it works really fast and all email now receives Html.
mhellenm
phpList newbie
 
Posts: 3
Joined: 8:25am, Wed 16 Jul, 2008

Postby Guest » 8:47am, Wed 03 Sep, 2008

Thanks so much for all the help on this topic.

Quick and easy results.

Iain

I used this method...
Martin_bou wrote:
I was having the same issue, and I ran the following command on my mysql database, from within php MyAdmin.

Note that your table name may differ, but the table is indeed user_user, mine has a prefix

UPDATE `phplist_user_user` SET `htmlemail`=1 WHERE `htmlemail`=0
Guest
 

mark all users to receive html in one click

Postby Guest » 6:30am, Tue 23 Dec, 2008

I'm new to phplist and downloaded just a few nights ago, so this is possibly a completely new feature.

Manage Users >> Reconcile Users, there is new link:
mark all users to receive html

I've not clicked it, but looks like it will do the trick as advertised..

cheers
-bronius
Guest
 

Next

Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest