Why are all my new constituents opted out of emails?
Options
Rookie question, probably.
I recently imported a list of 1200+ new constituent records into LO. It went fine, except that they all appear to have "Accept Email" = No, and they ought to be "Yes."
I've attempted to update this multiple times, basically attempting to over-write the No with a Yes, or a True, or a Y, but nothing appears to work.
We are itching to send these folks a welcome email, but we're kinda stuck until this is fixed.
Any thoughts? Is there a painfully obvious setting that I forgot about?
Thanks,
John G, DB Admin, NCTE.
I recently imported a list of 1200+ new constituent records into LO. It went fine, except that they all appear to have "Accept Email" = No, and they ought to be "Yes."
I've attempted to update this multiple times, basically attempting to over-write the No with a Yes, or a True, or a Y, but nothing appears to work.
We are itching to send these folks a welcome email, but we're kinda stuck until this is fixed.
Any thoughts? Is there a painfully obvious setting that I forgot about?
Thanks,
John G, DB Admin, NCTE.
Tagged:
0
Comments
-
Hey John,
You are not going to like this answer, but this is the answer I got from support many moons ago.There is no way to mass resubscribe opt-ed out users. You must manually change this. A constituent can opt back into email through the profile screen.
This is a an email protection, otherwise admins would be re-subscribing users all the time. To be in compliance with CAN-SPAM, you need some sort of authorization to opt users back in, be it in writing or an email.
Since you just had an import go haywire, I would contact support and see if they can help.
A good rule of thumb with imports is to import the first 5 records of your overall file first to make sure the import is doing what you want (check one of the constituents you did an import on to validate the correct action was taken). Then you can import the rest.
Bummer for sure.
Thanks,
Phil0 -
Custom Cons Import offers the Accept Email field.
There's even some specific help when that field is selected: "Luminate sets to Y if email is accepted or to N if not. Flip or reverse this value if your database sets N if email accepted and Y if not."
It sure leads you to believe it works. Does it just fail or not actually change?
BPM0 -
John, not sure this is within your capability however you can write some simple python web-scraping code to 'automate' (i.e. emulate the keystrokes) to change these back to 'accept mail'. It would be a huge time-saver plus position yourself should you ever need to redo it in the future.0
-
Or you could use the Cons API Update method and some JS or JQuery in a PageBuilder page to do them all.
I'd put all of the cons ids into an array, and then $.each through that to make each update.
Make that page Admin only, so the user has rights to update.
Or at the very least, you can use Excel with the concatenate and hyperlink formulas to add clickable links to each cons record in a Luminate Report. That will save you all the searching and opening of each record. Just click a link, check the box, and click save.
The URL to open a cons record in edit mode looks like this:
https://secure3.convio.net/ABC/admin/ConsProfileAdmin?op.editCons=&consID=12345678
So add a column to your list of bad users with a formula something like:
=HYPERLINK(CONCATENATE("https://secure3.convio.net/ABC/admin/ConsProfileAdmin?op.editCons=&consID=", C2), " Click Me")
I use this trick all the time with Luminate.
BPM2 -
John,
We had a similar situation this summer and Blackbaud was able to do the global opt in for us. There are a number of steps and it takes a bit of time but they successfully opted in a large group that had been erroneously opted out for us.
We just put in a case requesting their help and also, this KB article outlines what they'll do and what they'll need from you: https://kb.blackbaud.com/articles/Article/1107611 -
Ah that's marvelous information, Shannon, thanks a lot! (And thanks to everyone else who replied)0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board