Mailing List Update / CSV Upload

Author	« Topic »
RJB Ecommerce Template Expert United Kingdom 789 Posts	Posted - 01/09/2018 : 10:53:01 Hi, I have around 12000 emails in my mailing list which have built up over several years and now I need to remove some of the old addresses which are no longer valid. I downloaded the mailing list to a csv file and have had the list validated and I need to remove around 1500 addresses. I have done this in the csv file, but it doesn't appear to be possible to upload it. Is there any way to upload the csv file to replace my existing mailing list? Richard.
Sinbad ECT Moderator USA 65937 Posts	Posted - 01/09/2018 : 11:05:35 Hi Richard, it would require accessing the database to import the list, we have a list of developers here that can quote you for that https://www.ecommercetemplates.com/developers.asp I would try bettapages as he has done this type of thing in the past. Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
Andy ECT Moderator 95440 Posts	Posted - 01/09/2018 : 11:09:25 Hi You can import the mailing list via the css upload page https://www.ecommercetemplates.com/help/mailing-list.asp#mailinglist4 Andy Please feel free to review / rate our software
RJB Ecommerce Template Expert United Kingdom 789 Posts	Posted - 01/09/2018 : 11:40:45 Thanks, I didn't realise the csv upload also worked for the mailing list. I'm not sure if this would work though as I want to upload the csv file with the invalid email addresses removed, but I don't think the 'add' or 'update' options would remove these addresses from the database ..would they? In that case I will have to ask if Phil can help. Richard.
Sinbad ECT Moderator USA 65937 Posts	Posted - 01/09/2018 : 12:44:20 Hi Richard, no they won't remove the deleted entries that is why I mentioned contacting Phil for the task. Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
RJB Ecommerce Template Expert United Kingdom 789 Posts	Posted - 01/10/2018 : 02:35:41 Hi, Another quick mailing list question ...When I select the email addresses to send from the mailing list I can set the sort order i.e. 'date descending'. Does this set the order in which the emails are actually sent? ..If not what order are they sent in and can this be set? The reason I ask is that I understand when sending a large volume of emails they are sometimes blocked so it would probably be best to send to the more recent subscribers first. Richard.
Andy ECT Moderator 95440 Posts	Posted - 01/10/2018 : 03:03:56 Hi Richard The emails are sent in email alphabetical order - I just tested here and the sort order makes no difference to the order they are sent I'm afraid. Andy Please feel free to review / rate our software
RJB Ecommerce Template Expert United Kingdom 789 Posts	Posted - 01/10/2018 : 03:32:22 Ok, thanks Andy. Richard.
John Nolan Advanced Member Canada 409 Posts Pre-sales questions only (More Details...)	Posted - 01/10/2018 : 06:12:14 Can't one use phpMyAdmin to manage the mailing list? It's all in one table, isn't it?
Andy ECT Moderator 95440 Posts	Posted - 01/10/2018 : 06:24:26 It is possible to use phpMyAdmin with care. Andy Please feel free to review / rate our software
Phil ECT Moderator United Kingdom 7680 Posts	Posted - 01/10/2018 : 07:26:31 Hi Richard, If you send me the csv file containing only the emails you require in your mailing list I'll import it for you so you only have those listed. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
insight ECT Moderator USA 4479 Posts	Posted - 01/10/2018 : 10:01:23 quote: The reason I ask is that I understand when sending a large volume of emails they are sometimes blocked so it would probably be best to send to the more recent subscribers first. I don't think that would make any difference really, the bigger hazard is when you send a bunch to a single mail provider all at once, you'll likely get rate limited or blocked for a while. So if they go alphabetically by user name they should be fine. I don't think many hosts would be excited about you dumping 12000 messages in the mail spool all at once, mind you. Peter ServeLink Professional ecommerce web hosting for ASP & PHP https://servelink.com Take a look at our image upload/resize tool for the ASP cart https://servelink.com/clients/cart?gid=7
RJB Ecommerce Template Expert United Kingdom 789 Posts	Posted - 01/11/2018 : 11:35:38 Hi, Thanks to all for replies on this subject. In particular, thank you Phil for offering to update my database ..I was going to ask you but thought I'd try doing it myself first. It wasn't as straight forward as I expected, but I managed it in the end. Now the mailing list is cleaned up I'll try sending the emails in small batches spread over several days and see how it goes. Richard.
	« Topic »