OpenEMM Technical Support Forum

I'm not sure if this is a bug or if I'm just missing something.

I'm trying to import a list of emails addresses that need to be set to opt-out. the csv file has only the email address in it. when I import all looks like it goes well, it detects a couple of duplicates, but does not remove the subscription to the list I specify. it comes back with the following block of text, I have checked over everything multiple times and had no problem with the import, there are 1600+ email addresses in the list that we are trying to cleanup.

Errors in email addresses:2
Addresses on blacklist:0
Double records in the CSV file:9
Errors in numeric values:0
Errors in mail-type values:0
Errors in gender values:0
Errors in date fields:0
Errors in line structure (null):0
Recipients from CSV file already in DB:0
New recipients:0
Updated recipients:0
mailinglist:0 Recipients set to status 'Opt-Out'

When you define the inport profile you can select to set the recipients status to "opt-out". Thus addresses imported with this profle are set as opt-out.
Markus

yes, everything is set up correctly. my problem is that it comes back with:
mailinglist:0 Recipients set to status 'Opt-Out' from a list of 1600. it's like it is unable to match the addresses out when using the opt-out function.

Settings are:
Seperator , (only one field, but I set it to this anyway as I am using a csv)
Text Rec Char NONE (only email addresses, no special characters)
CharSet ISO-8859-1
dateformat dd.mm.yyyy HH:mm (no dates in data)
Mode: "Mark recipients as opt-out"
Ignore Null Values
key: email
Check for Dups: only within new data
default mail type: html
email addr: myemail@domain.com
Update All Dups CHECKED

when processing through I select mailinglist as the list to unsubscribe from.

results I get are as outlined in my previous message, no errors or warnings (there were a few invalid email address warnings, but I removed them from the data set.

Which version of OpenEMM do you use?

2011. fresh download and install as of arround March.

Could you provide a demo import file so that we can try to reproduce the problem?

I don't see a way to attach a file to the forum, but here is my most simplified version I used when trying to get it to work:


Email_Address
dchristenson@thedeltagroupllc.com
dchristenson@gmail.com

Ok, that's easy enough, we will look into that.

Sorry, this bug report has somehow slipped my mind! We could reproduce the bug and will provide a fix soon. Please follow us on Twitter to get notifications of the availability of new bugfixes, thanks!

Solution: Set "Check for duplicate records" from "only within new data" to "complete". Otherwise, the import can't find links between records in your CSV file and records in your database. Thus, no recipients are unsubscribed.