Import Your Training Instantly


#1

Upload files for this importer like this.


We recently made a Training importer! You can now send us a .csv of your training records and we can import them for you.

The spreadsheet should follow this pattern:

Required Columns:

  • Last Name
  • First Name
  • Youth or Adult
  • Training

Optional Columns:

  • Completed On
  • Goal On

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.

We try to find users by first name, last name, and whether they’re a youth or adult, so be consistent in your naming. For example, if TroopTrack thinks John Smith Jr.'s first name is Johnny, use Johnny in the spreadsheet, or Johnny won’t get his training.

If the spreadsheet doesn’t contain all the required columns, we won’t be able to import your training records. Also, if any rows in your spreadsheet are missing any required fields (for example, a row is missing the Training entry), we won’t be able to perform the import.

Example:

+-----------+------------+----------------+------------------------+--------------+
| Last Name | First Name | Youth or adult | Training               | Completed On |
+-----------+------------+----------------+------------------------+--------------+
| Smith     | John       | Adult          | KEYS to Child's Safety | 22/08/2017   |
+-----------+------------+----------------+------------------------+--------------+
| Bob       | Greybeard  | Adult          | Archery Instructor     | 18/1/2017    |
+-----------+------------+----------------+------------------------+--------------+
| Sam       | Gamgee     | youth          | Knife Training         |              |
+-----------+------------+----------------+------------------------+--------------+

Upload files for this importer like this.


Import Your training Link is Missing
#2

Can I add a column for “Expires On” in my spreadsheet or is that automatically calculated?

And is there a way to do this for Troop Equipment?? That would be pretty awesome! :wink:


#3

The “Expires On” values are automatically calculated based on the specific training type.

We have an equipment importer, too. :slight_smile:


#4

AWESOME SAUCE!!! Thanks! The equipment importer will be my next thing to get done!