To get the file format, simply do an export from Scoutbook and look at columns A thru J. The Black Pug file has one additional column at the beginning called Unit. The contents of that column must include the unit number on each line (there can be additional text, the import just looks for a numeric unit number and discards any extraneous text)
Column names are Unit, BSA Member ID, First Name, Middle Name, Last Name, Advancement Type, Advancement, Version, Date Completed, Approved , Awarded.
Each line in the file is either a completed requirement or a completed badge.
For completed Merit badges, the Advancement Type is “Merit Badge” , Advancement is the full name of the badge, e.g. “Water Sports”, the version is the version year, e.g. “2017” (as it appears in the “Enter Merit Badge Req.” Quick Entry), date completed is a date, e.g. “8/5/2020”
For Merit Badge Requirements, the Advancement Type is “Merit Badge Requirement”
The tougher part to spec is the value for the Advancement field. The values should match the requirement numbers exactly as they appear in the “Enter Merit Badge Req.” Quick Entry. For example, Animation has a " Animation #3a" and personal Fitness has
“Personal Fitness #6c Body”. Version and date are the same formats.
The Approved field value should be set to 1. Awarded is ignored but the column must be present.
The extension does not require values for BSA Member ID - it will attempt to match names and query the person doing the import on mismatches.