Urgency: low
Impact to fundraiser: extra work for Caitlin in Silverpop, opens up opportunity for user error & bad donor experience.
This is a follow up on card #1341, in which I asked for all NULL values to be removed from the first name and last name columns in our Silverpop import. Garfield was a recipient of one of our emails on Friday, and was addressed, “Dear NULL”, which is what made us realize there are still 275 contacts in the database with NULL first names — and some of these, unlike Garfield, actually have donated.
We have a workaround in Silverpop, but it’s a manual process, so it would be nice if we could ensure once and for all that empty fields are simply blank instead of NULL.