Variable of newsletter subscribers

[eggidea]

Hello Oliver,

It's me again

I read thru the threads about newsletter subscribers, it seem not possible to import the list, right?

I knew this for the sake of anti-spam, but I already have my member database, and I will help my company to send out newsletter monthly, and I would like to ask if there a tricky way to import the list without verification?

i tried to add email to database directly, but fail, it's not response, and I would like to ask what's variable address_key for? is it a unique variable?


Thanks a lot.

[Oliver Georgi]

You can import directly into the database by using phpMyAdmin which is able to import CSV data.

should be formatted like this:

Code: Select all

address_email;address_name;address_verified
info@phpwcms.de;Oli;1

Oliver

[eggidea]

Dear Oliver,

in fact, I tried to insert 3 emails, but when i tried to send out the newsletter, only 1 of 3 email receive that newsletter, do u know why?

Thanks.

[Oliver Georgi]

check your database - maybe wrong import.

Oliver

[aleggs]

You can import directly into the database by using phpMyAdmin which is able to import CSV data.

Morning! I am using PHPMyadmin 2.0.5 with MySQL V 3.23.46. OK, old PHPMyAdmin Version ..

I see that I could Run SQL query/queries within my PHPMyadmin panel. so .. anyone have an idea how to set up such a query with included e-mail addresses?

Thanks for any help!
Alex

[Oliver Georgi]

OK, I have created an EXCEL file that will build the list you need.
http://www.phpwcms.de/support/BuildImpo ... essSQL.xls

Fill in the address in column A and - optional - the name in column B. After that copy and paste complete column C into a seperate SQL file or paste column C into phpMyAdmin SQL field.

And this is the working INSERT query:

Code: Select all

INSERT INTO phpwcms_address (address_key, address_email, address_name, address_verified) 
VALUES 
(PASSWORD('slackero@hotmail.com'), 'slackero@hotmail.com', 'Oliver', '1');

If you have used a prefix for the table name add it in front of 'phpwcms_address' like 'myprefix_phpwcms_address'. Don't forget the underscore.

Oliver

[aleggs]

big wave! grosse welle!!

thanks oliver - I'll try tonite

alex

[aleggs]

oakie: tested implemented works!

big thanks again Oliver!

[jsw_nz]

Thanks for the pointers...the provided xls did wonders in sorting this out...
Just used it to import 258 new subscribers.

Applied to dev 119

Now hoping that all subscribers get it delivered to email bin...
(Did read about timeout issues on server)
If any problems will post.

Thanks Oliver.