admin:spreadsheet_file_format
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
admin:spreadsheet_file_format [2019/08/13 13:03] – [Bulk Loading] lillie | admin:spreadsheet_file_format [2020/08/10 09:21] – [Format (Syntax)] lillie | ||
---|---|---|---|
Line 22: | Line 22: | ||
To maintain syntax structure, it is critical to include blank cells in your spreadsheet where information has been omitted (i.e. if first name is not included, leave that space blank and do not delete it from the spreadsheet). The following information should be entered into your spreadsheet as columns in corresponding sequence, with the relevant data entered into the next row: | To maintain syntax structure, it is critical to include blank cells in your spreadsheet where information has been omitted (i.e. if first name is not included, leave that space blank and do not delete it from the spreadsheet). The following information should be entered into your spreadsheet as columns in corresponding sequence, with the relevant data entered into the next row: | ||
- | - LAST NAME [**required**] - Legal last name of account | + | - LAST NAME [**required**] - Last name of account |
- | - FIRST NAME [// | + | - FIRST NAME [// |
- USER ID [// | - USER ID [// | ||
* By default, Silent Dismissal will create accounts with user IDs comprised of the first initial and the last name. If there is a special format desired for the user IDs, such as last.first@email.com, | * By default, Silent Dismissal will create accounts with user IDs comprised of the first initial and the last name. If there is a special format desired for the user IDs, such as last.first@email.com, | ||
* If more than one person exists with the same first initial and the same last name, then one of those persons must be explicitly given an alternate user ID. **User IDs must be unique across all new and current accounts.** | * If more than one person exists with the same first initial and the same last name, then one of those persons must be explicitly given an alternate user ID. **User IDs must be unique across all new and current accounts.** | ||
- | - GRADE [// | + | - GRADE [// |
* Use a numeric value corresponding to the grade level: zero for " | * Use a numeric value corresponding to the grade level: zero for " | ||
- ACCOUNT TYPE [// | - ACCOUNT TYPE [// | ||
Line 56: | Line 56: | ||
* Strongly recommended to avoid confusion of students | * Strongly recommended to avoid confusion of students | ||
- PICK-UP ID NUMBER [// | - PICK-UP ID NUMBER [// | ||
- | * Strongly recommended that all students be assigned a carpool | + | * Strongly recommended that families share the same Pick Up ID # |
- GRADE [// | - GRADE [// | ||
* Strongly recommended to allows students to be directly loaded into grade rosters | * Strongly recommended to allows students to be directly loaded into grade rosters | ||
Line 88: | Line 88: | ||
- GROUP NAME [**required**] - Name of Group or Location; Body of Message | - GROUP NAME [**required**] - Name of Group or Location; Body of Message | ||
- | ^ Figure 1. __Group Type Codes__ | + | ^ Figure 1. __Group Type Codes__ |
- | | **p** - Carpool | **c** - Club | **d** - Date | | + | | **p** - Carpool | **c** - Club | **d** - Date | **a** - After Care | |
- | | **i** - Immediate | **b** - Bus | **v** - Daycare Van| | + | | **i** - Immediate | **b** - Bus | **v** - Daycare Van| **s** - Sports |
- | | **w** - Walking | **t** - Tutoring | **o** - Other | | + | | **w** - Walking | **t** - Tutoring | **o** - Other | | |
- | | **m** - Message | **l** - Location | **z** - Zone Location | | + | | **m** - Message | **l** - Location | **z** - Zone Location |
==== Bulk Loading ==== | ==== Bulk Loading ==== |
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1