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.
We imported merit badge data from a summer camp .csv export file and found that even though we had scouts that completed all the requirements for Archery, Environmental Science, Automotive Maintenance and Law, and the requirements were correctly imported into scoutbook, the percent complete calculation shows more work to do and the merit badge does not show up as complete. When you look at the requirements, all the boxes are blue or grey which indicates that all the necessary requirements are done.
It looks as if the complete calculation is expecting every option to be done, even though the actual portion with the individual requirements thinks it is done (all complete and/or grey). Is there any way to correct this or do we manually have to override and say the merit badge is complete?
Maybe there is a format issue? I opened the csv file and saved it as an excel file. Here is a screenshot of the lines saying it should have been approved:
I should note that it has the columns for the Unit, BSA Member ID, and names. I just didn’t include them in the screenshot. I did not edit anything in the csv, and they were imported from the csv. But making an excel copy makes verifying a lot easier.
If it was missing the approval entry, I’m still not sure why it wouldn’t calculate 100% but then say it wasn’t approved? That seems like the most logical thing since all items were complete.
So where it has approved as a 1 change the 1’s to QE? The ones that worked had a 1 in that column too. I probably don’t have enough samples to say, but either a merit badge worked or it didn’t. These ones calculated correctly and approved:
no @CmtMbr - “1” means YES - so it was marked APPROVED - use Quickentry where Advancement Type=Merit Badge (that means the whole Merit Badge - not Merit Badge Requirement) and it is marked “1” - that means the whole MB was marked approved. Use the Scoutbook Quickentry system to mark them approved.
Thank you! I understand what you are saying now. I’m new to this, do you know if there is a way to report this so they get the calculation corrected? Not being able to trust the import means a lot of auditing. I’m not sure who to talk to.
For now though, I will do as you suggest and do the quick entry to get the approvals in.
Thank you. Can someone check scoutbook as well? This happened to a couple items when I entered manually in cub scouts. One I think was the outdoor award for one of the ranks. But I didn’t write it down. Just want to make sure we find the real root cause. On the surface it seems like the approval was blocked because it wasn’t 100% complete.
So even though it doesn’t say 100% it is still complete, you just need to approve it? It gets confusing because I kept looking at the requirements wondering what still needed to be done since everything else goes to 100%.
So I found something. It may be Scoutbook. I tried the incomplete merit badge report, and it says that archery has missing requirements, and lists 5A, even though you only need A OR B, and says 5B even though under 5(B)(f) you only need one option.