[image] August 19, 2021 My.Scouting Change Log My Scouting Change Log Bug Fixes Merit Badge Counselor Listing from My.Scouting: The fix (for now) on exporting the complete list of Merit Badges has been put into production. What is displayed is there are colum…

James - you cannot. There is a character limit in a CSV file in Excel. So, that’s why they had to be separated. Considering no one has reported this issue in the last month since the fix was deployed, I am guessing you are the first to run into it! I will report the issue to BSA IT in the morning. …

Ronald, You absolutely, unquestionably, demonstrably CAN put the name of every merit badge (and much, much more) in a single field. You could put 10 copies of every merit badge in a field and be fine. “Total number of characters that a cell can contain: 32,767 characters” Excel specific…

Yup. Loaded fine for me. :^) If you use CSV, you end up with two cells: All Possible MBs and the pipe-separated list of all the MB names. I haven’t tried it in Google sheets yet, but I suspect it would work there, as well.

So they did have a different excuse. :slight_smile: This one at least makes some sense, although it’s still ridiculous. I say, drag them kicking and screaming into the 20th century (so they are only 20+ years behind)! How quickly can they fix their “off by one” error so at least the badge names are…

[image] JamesBrown13: I say, drag them kicking and screaming into the 20th century (so they are only 20+ years behind)! If I remember correctly, in a post about the plan to retire Scoutnet/PAS BSA was hoping that PAS would be tired by the end of this year (2021). This affects when Merit Badge…

[image] JamesBrown13: Anyone who has more than some limit of characters in their list of MBs gets split into multiple columns. They end up missing the first character in each of the additional columns. Dropping the first character in the second and following columns is strange. Breaking …

[image] CharleyHamilton: Yup. Loaded fine for me. :^) If you use CSV, you end up with two cells: All Possible MBs and the pipe-separated list of all the MB names. I haven’t tried it in Google sheets yet, but I suspect it would work there, as well. I assume you are using Excel which has a 25…

[image] Bill_W: Dropping the first character in the second and following columns is strange. That’s a typical “off by one” error. Programmers make that sort of “edge case” error all the time. Good programmers check their code for this type of error because it’s so common. [image] Bill_W: …

[image] Bill_W: I assume you are using Excel which has a 256 character cell width limit. No, it absolutely does not. Excel has a stated limit of 32767 characters per column / field (see discussion and links above). It works fine with data to this limit. I tested it myself. As a demonstration…

Latest update to merit badge list in my scouting tools is, once again, broken

My Scouting Tools

RonaldBlaisdell September 15, 2021, 1:25am 5

It is a limitation with the library supplied with the report writer software.

2 Likes

Topic		Replies	Views
MBC List Download in CSV format Truncates the MBs for Many Counselors My Scouting Tools	3	407	July 25, 2021
How do district and council volunteers get access to the merit badge counselor list in SB? Using Scoutbook & Scoutbook Plus	199	6213	May 21, 2022
Merit badge report from my.scouting is incomplete / incorrect and is missing important columns My Scouting Tools reports , merit-badges , merit-badge-counselo	78	2604	July 25, 2021
Merit Badge Counselors position not updated Scoutbook & Scoutbook Plus Bugs	43	3111	May 20, 2020
ScoutBook is duplicating Merit Badge counselors on Council Upload Scoutbook & Scoutbook Plus Bugs	86	5216	May 29, 2020

Latest update to merit badge list in my scouting tools is, once again, broken

Related topics