Import Your Ranks Instantly


#1

Upload files for this importer like this.


We recently made a Rank Importer! You can now send us a .csv spreadsheet of your achievement records and we can import them for you.

This importer only applies to BSA Scout rank advancement. For other achievements, see “Import Your Achievements Instantly.”

The spreadsheet should follow this pattern:

Required Columns:

  • Last Name
  • First Name
  • Rank Advancement
  • Completed On (DD/MM/YYYY)

Optional Columns:

  • BSA ID Number
  • Awarded on (DD/MM/YYYY) [If this column is not included, it defaults to the Completed On date]
  • Reported on (DD/MM/YYYY)
  • Note
  • Recognized (True/False) [Defaults to True]
  • Purchased (True/False) [Defaults to True]
  • Version (2015 or 2016)

Importer Info

The order of the headers doesn’t matter. Also, headers are case-insensitive (so you can use First Name or first name or FIRST NAME). Dates should be in DD/MM/YYYY format. Only scouts (youth) are considered, so no youth or adult column is necessary like for other importers.

We try to find users by BSA ID first, then by first and last name. However, the BSA ID is optional, so be consistent in your naming. For example, if TroopTrack thinks John Smith Jr.'s first name is Johnny, use Johnny in the spreadsheet.

If the spreadsheet doesn’t contain all the required columns, we won’t be able to import your ranks. Also, if any rows in your spreadsheet are missing any required fields (for example, no Completed On is listed for a rank), we won’t be able to perform the import.

Important Columns

Rank Advancement

The Rank Advancement column is used to identify the rank or rank requirement you want to import. You can import completion data about ranks as a whole or about the rank requirements.

To import rank information, enter the name of the rank here, eg. Tenderfoot. To import requirement data, enter the name of the rank and the number of the requirement separated by #, as in Tenderfoot#1 or First Class#2b. If we can’t find the requirement you entered, we’ll show you available requirements for that rank in an error message.

Version

The Version is an optional column that can help you make sure you don’t accidentally import a 2016 requirement into a 2015 rank (or vice versa). If a summer camp completes the 2016 requirements, but a scout is still using the 2015 requirements in TroopTrack, this option would prevent the 2016 requirements from being imported as 2015 requirements.

Enter the version of the requirement that was completed (2015 or 2016) into this column, and the importer will check that the scout has the same version. If the scout has the wrong version, the importer will let you know so the problem can be fixed.

Awarded On

If you leave out the Awarded On column, then each achievemnt defaults to be being awarded on the same date it was completed. If the Awarded On column is present, we import it exactly, blanks and all (which is how you would import an achievement which has been completed but not awarded).

Example:

+------------+-----------+--------------+------------------+---------+
| First Name | last name | Completed On | Rank Advancement | Version |
+------------+-----------+--------------+------------------+---------+
| Johnny     | Smith     | 29/08/2016   | Tenderfoot#1     | 2015    |
+------------+-----------+--------------+------------------+---------+
| Bobby      | Granger   | 13/02/2017   | Tenderfoot#1a    | 2016    |
+------------+-----------+--------------+------------------+---------+
| Dean       | Thomas    | 02/02/2017   | Scout#1b         |         |
+------------+-----------+--------------+------------------+---------+
| Sam        | Gamgee    | 31/12/2016   | Scout#2a         | 2016    |
+------------+-----------+--------------+------------------+---------+
| Sam        | Gamgee    | 19/11/2016   | Scout#2b         | 2016    |
+------------+-----------+--------------+------------------+---------+

Easier Transition from huge Excel spreadsheet to Troop Track