Welcome! This forum has a treasure trove of great info – Scouters helping Scouters! Just a heads up, though - all content, information, and opinions shared on this forum are those of the author, not the BSA.
You need to compare names against common nick names! That would be a challenge! We have one Cub with the same dad connected twice and you found it. We are working to get one account deleted. In the troop, though, we have a Scout with one dad connected with a Rob account and the other is Robert. That would be quite the challenge.
Too bad there couldn’t be a check to see if my.scouting and Scoutbook match and call out the differences.
It did not catch Rob and Robert. One is say (fake last name) Rob Smith and the other is Robert Smith. Oh, I just thought maybe why not. I think the Robert Smith has a trailing space: “Robert Smith “ vs “Rob Smith”. I noticed it the other day, and due to how painful support is now (like getting rid of the extra Mr. Smith has take 2 weeks and counting), I moved on. I guess I should make that request as well.
@RonFedele Were you able to continue updating? The code is supposed to allow the rest of the member councils/districts to be updated.
Scoutbook provides the error if a profile update is attempted and it has the bad email associated. I’m not sure I should change the extension - all I could really do is skip trying to update those accounts.
What about checking “extra spaces”? There was my trailing space, for example. I wonder if there are extra spaces between first and last or a lead space as well.
In my code, I was already stripping space characters out so leading and trailing spaces would not be included in comparisons. If one account had extra spaces and another did not, in my compare it would look like two accounts with the same name.
I was thinking about reporting of extra spaces as another check to say “hey, you have a leading or trailing space that should be there. Fix it.” I assume trailing or leading spaces could lead to extra accounts like nicknames.