Page 1 of 1
Blacklist - bulk load
Posted: Mon May 17, 2010 12:02 pm
by kevster
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?
Posted: Mon May 17, 2010 2:30 pm
by kevster
Whoops.... RTFM
Found the answer
Re: Blacklist - bulk load
Posted: Fri Feb 25, 2011 5:02 am
by phillmelon
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