"Blank ID" results for table entries
I'm trying to clean-up the table entries in my organization's "solicit code" table, but I can't delete some entries because they are still in use. When I query on the solicit codes, there are no results (even when including inactive and deceased records).
When I go to the table entry and select "view uses", it gives me a list of constituent IDs that are all "Blank ID". Does anyone know how I can track down which constituent records these solicit codes are in use on?
Answers
-
Have gotten this frequently. Love the clean up function but wish there was a direct click link to those records.
For some I did queries looking for that info piece on relationships or other places where that field might be. Found some but not all.
Was able to resolve some of them with support. Required sending FTP of db to them and they can find the use cases.
3 -
Why not just do a query where the Constituent is blank.
0 -
Thanks for this suggestion, Joe. I should have mentioned I tried that as well but it returned zero records.
0 -
What I was told by support is that it's somewhere on a record, just not a field on the constituent record. Some are relationships, some are inactive fields. Tend not to be in 'query-able' places. I have run into this with a variety of my clean up projects.
I have 4 instances of a gift sub-type that is I've tried to delete - no one here has any idea what it is about/when used or anything. Have not been able to find with a query. Nor could support suggest where else to query. Export option here doesn't provide any data other than what is seen here.
2 -
That's really helpful, thank you! I'll poke around in RE and see if I can find where these fields are hiding.
1 -
This is good to know about! Thanks for always providing such great responses here.
1 -
This is one of the banes of my database managing existence šI've had a few table entries over the years where I've never been able to figure out where they show up - not on a participant, not on a gift, not a constituent or relationshipā¦ a mystery!!
1 -
Solicit codes are only available on a constituent record though. The only other thing I can think of is that you have some that are mapped to Consent functionality, so although the solicit code doesn't appear on a constituent record, it might be within their Consent section. I'm willing to bet that's the issue.
2 -
It is possible that someone created a custom field/attribute (on any type of record) and attached the Solict Code table to that custom field. (Ask my how I know! š) But I agree that Consent could likely be the case here.
2 -
You can do that?? That sounds like dark magic.
0 -
Yup, it is quite useful. Any custom field using table data type can select any table as its selection. including default tables like campaign category, fund category, etc.
0 -
This might be a situation where those solicit codes existed on a record and that record was deleted, but the data was left behind in a junction table. This creates an orphaned, or "stale", record and breaks referential integrity in relational databases. It does not happen frequently but it does happen. In fact, we still have a 2 year old open case with Blackbaud where a deleted constituent record was still showing up on the soft-credit tab of gifts (btw, that soft-credit is still there after 2 years).
At my previous employer, when clients still hosted their own databases, you could use SQL Server Management Studio (SSMS) to find and clean this up.2 -
@Jenelle Murray do you have List Management with ImportOmatic or something similar? When I have had this issue it is usually because of non-constituent records, and for List Manager you will not see them in query results. Within List Manager you can create a list from a query that looks for the solicit codes you want to remove. Even though you won't see List Manager records in the query it will still pull them into the new list so you can clean them up there.
0
Categories
- All Categories
- New YourCause Community TEST
- New SKY Community TEST
- New Grantmaking TEST Community
- New Altru Test Community
- New bbcon Community - TEST
- 12 Blackbaud Agents for Goodā¢
- New Raiser's Edge NXT Community
- 7 Blackbaud Community Help
- 218 bbconĀ®
- 1.4K Blackbaud AltruĀ®
- 409 Blackbaud Award Managementā¢ and Blackbaud Stewardship Managementā¢
- 1.2K Blackbaud CRMā¢ and Blackbaud Internet Solutionsā¢
- 16 donorCentricsĀ®
- 361 Blackbaud eTapestryĀ®
- 2.7K Blackbaud Financial Edge NXTĀ®
- 681 Blackbaud Grantmakingā¢
- 599 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 952 Blackbaud Luminate OnlineĀ® and Blackbaud TeamRaiserĀ®
- 85 JustGivingĀ® from BlackbaudĀ®
- 7K Blackbaud Raiser's Edge NXTĀ®
- 3.9K SKY Developer
- 257 ResearchPointā¢
- 123 Blackbaud Tuition Managementā¢
- 165 Organizational Best Practices
- 247 Member Lounge (Just for Fun)
- 40 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 822 Community News
- 3.1K Jobs Board
- 57 Blackbaud SKYĀ® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)