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.
I’ve been downloading from Scoutbook the report “Scouts BSA Individual Advancement Record” with the “All” option checked, as a CSV file, to get data I can explore with some Python scripts to generate useful reports for the troop.
There’s a bug in the report in that it only shows one leadership position, even if the scout has more than one.
Scoutbook+ does not have an equivalent report. The Scoutbook+ “Scouts BSA History Report” is similar but can only be done for one scout at a time - there is no All option. But it doesn’t have the bug with multiple leadership positions.
I can get most of the data using the Scoutbook+ Report Builder, but it doesn’t include leadership positions.
I’m worried that the report from Scoutbook will disappear in the transition to Scoutbook+ and it will be much harder to generate my custom reports.
Could we get an All option for the Scoutbook+ “Scouts BSA History Report”?
@MichaelKennard Use the Audit Log Report, set the date for 10 years and max records to 999999 and export that to csv. You get all kinds of goodies for advanced analytics in that data set
I looked at the Audit Log Report but it has so much data that I thought it would be a pain to parse through. But maybe I just need to up my data analytics skills.
Yeah. I am a Data Analytics Engineer by trade. So I have all kids of interactive charts and graphs and dashboards going on with the data in a tool called Power BI
