Page 1 of 1

How to un-ban a user?

Posted: Fri Oct 02, 2015 3:52 am
by ohho
In a new mailing, there are 12 recipients in the mailing list. However only 7 recipients are used when generating the email.

When I check the customer_1_binding_tbl in database, the missing 5 recipients are marked as

user_remark: bounce
exit_mailing_id: 1385

What is the proper way to reactive the 5 banned email addresses?

Re: How to un-ban a user?

Posted: Fri Oct 02, 2015 11:18 pm
by maschoff
A bounced and a banned (blacklisted) address are two different animals. The bounce is initiated by the receiving mail server and a ban is initiated by the EMM user who blacklists an address.

If you want to change the status of a bounced address you have to set the status of the address back to value 1 in table customer_1_tbl. If you need to know more about the database schema of OpenEMM, you will find a description in the Extension Development Guide.

Re: How to un-ban a user?

Posted: Mon Oct 05, 2015 8:00 am
by ohho
Thanks for reply.

I do not see a "status" field in customer_1_tbl. There is a "user_status" field in customer_1_binding_tbl. Did I miss somthing?

Version: OpenEMM 2013

Re: How to un-ban a user?

Posted: Mon Oct 05, 2015 8:23 am
by maschoff
Yes, you are right, the status field in die customer_1_binding_tbl provides the status of the bindings to the mailing lists.

Re: How to un-ban a user?

Posted: Mon Oct 05, 2015 8:47 am
by ohho
Thank you!