Internet Advancement File Format (for National BSA site)
Posted 26 June 2013 - 08:41 AM
Posted 26 June 2013 - 11:39 AM
Posted 28 August 2014 - 04:02 PM
Posted 28 August 2014 - 05:08 PM
Posted 17 April 2017 - 10:49 PM
But if you know what the BSA required specifications for the CSV format is, you can simply have your data in a excel or other spreadsheet file, export it to a CSV format file (microsoft excel, google sheets, or any other spreadsheet program will let you do this) and upload it via internet advancment on scoutnet.scouting.org that is what everyone asking here is wanting to know, what are the specification requirements for the SCV file format specified by BSA????? can someone either post them, or tell where BSA has them spelled out???
Posted 18 April 2017 - 10:33 AM
I hope there is someone to help you, but in general BSA has been ignorant of open standards for databases. Thus we have reason for you to despair.
The logical location would be a page linked from the upload page by an info button. But, providing such specifications may be a violation of agreements with software companies that track scout advancements.
Developers of such software are welcome to prove us wrong by providing the location of your software's specs for portable files.
Posted 18 April 2017 - 11:20 AM
The easiest way to determine the CSV file data format is to contact TroopMaster or ScoutBook to see what their export CSV file for Internet Advancement looks like. CubMaster, TroopMaster and ScoutBook all port CSV files for input in to Internet Advancement.
Posted 18 April 2017 - 10:51 PM
Well first they say if you make the csv file out of troop master or troop web host or whatever,
they tell you do not open it, cause when you open it, that changes the file somehow so it won't upload properly.
So that's not helpful at all if the format is changed by opening and viewing it.
The problem is there are some fields that make no sense. They are numbers that mean nothing when you look at unit number, Internet advancement/unit ;log in number, or anything that makes it seem to be reproducible without knowing some secret BSA codes.
If you could get the gobbledygook numbers figured out the rest is sort of
header for unit id/scoutmaster info/date the unit recharters, district in two rows.
then list by row for each rank or mb
with random number, count of what row you are on, then scout name, first, middle, last, date of birth, date of advancement earned and the code for the merit badge or rank
But the bsa codes at the top and several other places are unexplainable.
it won't let me upload this type of file to the message board.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users