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

[hitec555]

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!

[H2B2]

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?

[hitec555]

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]

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

[hitec555]

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

[H2B2]

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]

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

[hitec555]

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

[zoinksgraphics]

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!!

[sing1ejack]

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

[Martin_bou]

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

[mat0ng]

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'

[mhellenm]

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.

[Guest]

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]

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