Uploading email contacts to newsletter DB

[mattmar]

Hello , I have a few files in .xls format including all of my former website DB it includes only email names i wanted to know how can i upload it to my new website DB so when i send out newsletters it will go them also.

 

Thanks !!

[npn2531]

Yes, you can upload only email addresses to the database and OSCommerce will mail to them along with the rest of your customers. First convert your xml to a simple text file. I am assuming this will result in your file then being nothing more that email addresses separated by either a space or preferably a comma.

 

Then 'simply' import that list into customers.customers_email_address. I use phpMyAdmin which is in my website control panel (not the OSCommerce admin). I don't do much importing and cannot quite remember the procedure. Normally I import into a table that has no data and that is easy, but I cannot remember how to use phpMyAdmin to 'append' data (add your emails to the emails that are there). But you are really doing something that is basic and done all the time. Perhaps someone else can pick it up from here.

[mattmar]

Thanks for your help i am also using cpanel , i know its pretty basic i just dont wanna take any chances with my DB.

Perhaps someone else can give me detail instructions ?

[mattmar]

Thanks for your help i am also using cpanel , i know its pretty basic i just dont wanna take any chances with my DB.

Perhaps someone else can give me detail instructions ?

 

any 1 ????????

[Xpajun]

Not sure on this one yes you can import the email addresses as above but the table will be looking for 10 other fields to be filled as well, so your query should look something like this:

 

INSERT INTO `customers` VALUES ('', '', '', '', '', '[email protected]', '', '', '', '', '');

 

But I'm not sure what effect just putting in a email will have on other related tables, and in addition if that email holder then tries to create an account or make a purchase they will have problems because their email is already listed

[npn2531]

Not sure on this one yes you can import the email addresses as above but the table will be looking for 10 other fields to be filled as well, so your query should look something like this:

 

INSERT INTO `customers` VALUES ('', '', '', '', '', '[email protected]', '', '', '', '', '');

 

But I'm not sure what effect just putting in a email will have on other related tables, and in addition if that email holder then tries to create an account or make a purchase they will have problems because their email is already listed

 

 

Xpagun, I'm not sure but I believe you can specify the field in the SQL query, which would avoid the awkward use of the empty single quotes. In any case I have a database with a few thousand normally entered names and a few thousand entries with nothing but an email.

 

Yes, if those folks tried to enter the email they would get an error msg that their email was already listed. However, the 'lost password' system will send them a password that will work- even when the database doesn't initially have a password for that email- and they can go to their account page, which will have nothing in it, but their email. When the try to click pass their account page, the account page gives them the error msgs that they are missing all that account info.

 

To make a long story short, it will technically work to enter only an email address.

[Xpajun]

Xpagun, I'm not sure but I believe you can specify the field in the SQL query, which would avoid the awkward use of the empty single quotes. In any case I have a database with a few thousand normally entered names and a few thousand entries with nothing but an email.

 

Yes, if those folks tried to enter the email they would get an error msg that their email was already listed. However, the 'lost password' system will send them a password that will work- even when the database doesn't initially have a password for that email- and they can go to their account page, which will have nothing in it, but their email. When the try to click pass their account page, the account page gives them the error msgs that they are missing all that account info.

 

To make a long story short, it will technically work to enter only an email address.

 

Actually you probably could but I'd have to play to find out :rolleyes: probably something alone the lines of:

INSERT INTO `customers,customers_email_address` VALUES ('[email protected]');

 

but I'm not really sure - you might also be able to do it so that you only have to have the csv emails and not the INSERT... on each one - google sql rules could give one the answer ;)

 

And thanks for clarifying the already registered bit