ScoutsTracker

User Tools

Site Tools

Trace:
import_format

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
import_format [2023/09/28 18:01]
admin [Import Format] 		import_format [2024/06/18 19:46] (current)
admin
Line 11: Line 11:
  
 ^Column Label ^ Required? ^ Default Value ^ Description ^ ^Column Label ^ Required? ^ Default Value ^ Description ^
 +| Organization | Required | none | The name of your section (e.g., "1st Muddy Paw B Colony"). If members are active in multiple sections they'll need multiple rows in the spreadsheet |
 +| Organization Sub Type | Optional | Your Section level | The section this member should import into.  Only used when including multiple sections and doing group-wide imports.  Must be one of "Beaver Colony", "Cub Pack", "Scout Troop", "Venturer Company", "Rover Crew", or "Committee".  If members are active in multiple sections, they'll need multiple rows in the spreadsheet. |
 | Member Type | Required | none | Either "Volunteer" or "Participant" or "Non Member" (case insensitive) | | Member Type | Required | none | Either "Volunteer" or "Participant" or "Non Member" (case insensitive) |
 | First Name | Required | blank | The member's given name. | | First Name | Required | blank | The member's given name. |
Line 16: Line 18:
 | Display Name | Optional | blank | A nickname, or abbreviation (e.g., "Michael C") to display in lieu of ''First Name'' and ''Last Name''. | | Display Name | Optional | blank | A nickname, or abbreviation (e.g., "Michael C") to display in lieu of ''First Name'' and ''Last Name''. |
 | Member Number | Required | blank | A unique identifier (e.g., Scouts Canada member number).  This field prevents repeated imports from creating duplicate records. | | Member Number | Required | blank | A unique identifier (e.g., Scouts Canada member number).  This field prevents repeated imports from creating duplicate records. |
-| Scouting Role | Optional | "Scout" or "Scout Counsellor" | Volunteers: One of "Troop Scouter" or "Scout Counsellor" \\ Non Members: One of "Parent Overnight", "Parent Helper", "Adult Overnight", "Friend" | +| Scouting Role | Optional | "Scout" or "Scout Counsellor" | Participants: "Scout" (or other section specific name) \\ Volunteers: One of "Troop Scouter" or "Scout Counsellor" \\ Non Members: One of "Parent Overnight", "Parent Helper", "Adult Overnight", "Friend" | 
-| Status | Optional | active | Either "active" or "inactive" (case insensitive). |+| Status | Optional | active | Either "active" or "pending" or "inactive" (case insensitive).  For leaders, a value of either "pending" or "inactive" will immediately inactivate a scouter, but the list is scanned for multiple entries for the same member, and if there is an entry that is both "active" AND "pending" (as can happen if the report contains records for both this year and next year) the "pending" row will be skipped |
 | Email Address | Optional | blank | An email to use to automatically create a Login for this member. | | Email Address | Optional | blank | An email to use to automatically create a Login for this member. |
 | Birth Date | Optional | blank | Only applicable to youth.  Scouter's birthdates are ignored. | | Birth Date | Optional | blank | Only applicable to youth.  Scouter's birthdates are ignored. |
Line 36: Line 38:
 ^ ^ A ^ B ^ C ^ D ^ E | | ^ ^ A ^ B ^ C ^ D ^ E | |
 ^ 1 | **1st Newbury Pack** ||||| //<- Ignored row// | ^ 1 | **1st Newbury Pack** ||||| //<- Ignored row// |
-^ 2 | **Member Type** | **DISPLAY NAME** | **email address** | **Scouting Role** | **Allergies** | //<- Mandatory header row// | +^ 2 | **Member Type** | **FIRST NAME** | **lastname** | **email address** | **Scouting Role** | **Organization** | **Allergies** | //<- Mandatory header row// | 
-^ 3 | Volunteer | Scouter Dave (Akela) | scouter.dave@example.com | Troop Scouter | none | //<- Member records start here// | +^ 3 | Volunteer | Tony | Stark| scouter.tony@example.com | Troop Scouter | 1st Muddy Paw | none | //<- Member records start here// | 
-^ 4 | PARTICIPANT | Kylie | kylie@example.com | APL | none | | +^ 4 | PARTICIPANT | Kylie | Wylie | kylie@example.com | APL | 1st Muddy Paw | none | | 
-^ 5 | participant | Wei | | pl | none | | +^ 5 | participant | Wei | Xiang | | pl | 1st Muddy Paw | none | | 
-^ 6 | PaRtiCiPant | Marcus | | | peanuts, eggs | | +^ 6 | PaRtiCiPant | Marcus | Cassius | | | 1st Muddy Paw | peanuts, eggs | | 
-^ 7 | volunteer | Scouter Cynthia (Bagheera) | cynthia@example.com |  | none | | +^ 7 | volunteer | Cynthia | Wilson | cynthia@example.com |  | 1st Muddy Paw | none | | 
-^ 7 | PARENT | Mom Smith | mom@example.com |  | none | | +^ 8 | PARENT | Mom | Smith | mom@example.com |  | 1st Muddy Paw | none | | 
-^ 7 | adult | Trainer Joe | joe@example.com |  | none | | +^ 9 | adult | Joe | Trainer | joe@example.com |  | 1st Muddy Paw | none | | 
-| | | | | | %%^%% //ignored column// |+| | | | | | | | %%^%% //ignored column// |
  
import_format.1695924084.txt.gz · Last modified: 2023/09/28 18:01 by admin

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki