Variable of newsletter subscribers

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
eggidea
Posts: 23
Joined: Fri 11. Jun 2004, 09:26

Variable of newsletter subscribers

Post by eggidea »

Hello Oliver,

It's me again :oops:

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.
User avatar
Oliver Georgi
Site Admin
Posts: 9936
Joined: Fri 3. Oct 2003, 22:22
Location: Dessau-Roßlau
Contact:

Post by 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
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn
eggidea
Posts: 23
Joined: Fri 11. Jun 2004, 09:26

Post by 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. :wink:
User avatar
Oliver Georgi
Site Admin
Posts: 9936
Joined: Fri 3. Oct 2003, 22:22
Location: Dessau-Roßlau
Contact:

Post by Oliver Georgi »

check your database - maybe wrong import.

Oliver
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn
aleggs
Posts: 34
Joined: Fri 28. May 2004, 12:30
Location: Bern, Switzerland
Contact:

Post by aleggs »

Oliver Georgi wrote: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
User avatar
Oliver Georgi
Site Admin
Posts: 9936
Joined: Fri 3. Oct 2003, 22:22
Location: Dessau-Roßlau
Contact:

Post by 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
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn
aleggs
Posts: 34
Joined: Fri 28. May 2004, 12:30
Location: Bern, Switzerland
Contact:

Post by aleggs »

big wave! grosse welle!!

thanks oliver - I'll try tonite ;-)

alex
aleggs
Posts: 34
Joined: Fri 28. May 2004, 12:30
Location: Bern, Switzerland
Contact:

Post by aleggs »

oakie: tested :arrow: implemented :arrow: works!

big thanks again Oliver! :P
User avatar
jsw_nz
Posts: 907
Joined: Fri 2. Apr 2004, 02:42
Location: New Zealand

Post by 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. :)
Post Reply