I want to start using OpenEMM and have a blacklist filie of email addresses from another application - about 600 addresses.
Is there anyway to import this dircetly into OpenEMM?
Blacklist - bulk load
Moderator: moderator
-
phillmelon
- Posts: 1
- Joined: Fri Feb 25, 2011 2:14 am
Re: Blacklist - bulk load
In fact the manual explains how to add individual emails or patterns of emails. To do bulk upload emails to the blacklist there is no indication in the *ˆ$% manual...
I have a txt file with a lot of emails to add to blacklist. I use navicat mysql to import the email addresses into table cust_ban_tbl. I put them into cust_ban_tbl.email.
After the import process I noted that those new addresses does not show up in the programs. So I realised that I forgot to set up the company_id field. I did it later with the following command:
update cust_ban_tbl set company_id = 1 where 1=1
I have a txt file with a lot of emails to add to blacklist. I use navicat mysql to import the email addresses into table cust_ban_tbl. I put them into cust_ban_tbl.email.
After the import process I noted that those new addresses does not show up in the programs. So I realised that I forgot to set up the company_id field. I did it later with the following command:
update cust_ban_tbl set company_id = 1 where 1=1