Cleaning a Mailinglist with MLM and MaxBulkPro?

[nicolasbulb]

I'm cleaning a mailinglist of more than 3200 emails and I've set up a MLM unsubscribe command and asked my customers to click on that link in order to unsubscribe. The MLM SQL database script seems to work pretty good so far but…
I'm receiving like more than 300 "Mailer-Daemon" that indicate me that these emails are no longer available.
How can I work with these emails to easily clean their emails from the initial list? I don't want to do it manually, that's not the point.

How can I put a efficient email workflow to keep my SQL mailinglist easily up-to-date with these unsubscribing, mailerdaemon and other returning email errors? and to have my local MaxBulkMailer list synchronized with it?

Thanks in advance for your advice,

 

[stanbusk]

If you are using phpMyAdmin you can run a SQL query directly. It is something like

DELETE FROM `YOUR_TABLE` WHERE `fld_email` = 'EMAIL_ADDR_1'
OR `fld_email ` = 'MAIL_ADDR_2'
OR `fld_email ` = 'MAIL_ADDR_3'
OR `fld_email ` = 'MAIL_ADDR_4'
...

I will take note of your request anyway.

 

[nicolasbulb]

Mmh. Thanks for the query.

By the way, if I can your new Remote list function to work, will I be able to drop a "DELETE" in the lists and let MaxBulkPro delete automatically all the emails contained into the "DELETE" list for me, like it does in local?

If not, then you should add it to your next update. Without it, it's not really useful.

Can we work with "Unsubscribe" list via the Remote List and a SQL database?

 

[stanbusk]

Batch processes are currently all local. I will see if I can add a new form like the 'Upload' one, to clean remote lists.

I don't understand you last question.

 

[nicolasbulb]

In Version 5, you add the option to unsubscribe someone without deleting the contact. But in the remote list if someone wants to unsubscribe the form delete the contact right?

I'm just trying to find the best solution to handle subscriptions and unsubscriptions via the MLM scripts and the MaxBulkPro application.

 

[stanbusk]

Yes, in MLM the address is simply deleted.

 

[nicolasbulb]

So that means the functions built in MaxBulkPro and the MLM doesn't really match. Too bad. It's good but the sync between the 2 could really be improved.

 

[stanbusk]

They will in a future in the case you use mySQL. In fact we have already added the proper DB fields to handle that.

 

[nicolasbulb]

How do we get the new version?

 

[stanbusk]

This new version doesn't exist yet.

 

[benjiew]

Syncing unsubs.

Tighter integration with lists would be a Godsend. In fact, I've wondered why list management isn't a separate program. List cleaning is where I find most of my problems.

I appreciate your work and look forward to the new version.

P.S. I'm in a situation, because of PCI requirements https://www.pcisecuritystandards.org/ where I can't allow remote access to the database. If the queries are coming from the script, no problem.