User Tools

Site Tools


admin:spreadsheet_file_format

Differences

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

Link to this comparison view

admin:spreadsheet_file_format [2019/08/13 13:03] – [Bulk Loading] lillieadmin:spreadsheet_file_format [2024/03/05 13:13] (current) – external edit 127.0.0.1
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 user +  - LAST NAME [**required**] - Last name of account holder 
-  - FIRST NAME [//optional//] -  Legal first name of account user+  - FIRST NAME [//optional//] -  First name of account holder
   - USER ID [//optional//] -  User ID for account   - USER ID [//optional//] -  User ID for account
     * 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, then include this value.     * 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, then include this value.
     * 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 [//optional//] - Grade associated with the account user+  - GRADE [//optional//] - Grade associated with classroom accounts; has no relevance for other account types
     * Use a numeric value corresponding to the grade level: zero for "kindergarten", -1 for "4 year old pre-K", -2 for "3 year old pre-K", and -3 for "Other", such as mixed grade special education classroom teachers     * Use a numeric value corresponding to the grade level: zero for "kindergarten", -1 for "4 year old pre-K", -2 for "3 year old pre-K", and -3 for "Other", such as mixed grade special education classroom teachers
   - ACCOUNT TYPE [//optional//; defaults to classroom] - Type of user account (refer to list above)   - ACCOUNT TYPE [//optional//; defaults to classroom] - Type of user account (refer to list above)
Line 53: Line 53:
  
   - LAST NAME [**required**] - Student'​s legal last name in Title Case   - LAST NAME [**required**] - Student'​s legal last name in Title Case
-  - FIRST NAME [//​optional//​] - Student'​s legal first name in Title Case+  - FIRST NAME [**required**​] - Student'​s legal first name in Title Case
     * Strongly recommended to avoid confusion of students     * Strongly recommended to avoid confusion of students
-  - PICK-UP ID NUMBER [//​optional//​] - Numeric value from 1 to 4999 +  - PICK-UP ID NUMBER [**required**​] - Numeric value from 1 to 4999 
-    * Strongly recommended that all students be assigned a carpool ID +    * Strongly recommended that families share the same Pick Up ID # 
-  - GRADE [//​optional//​] - Numeric value from -3 to 12 +  - GRADE [**required**​] - Numeric value from -3 to 12; -3 is Other, -2 is 3PK, -1 is PK, 0 is Kindergarten 
-    * Strongly recommended to allows students to be directly loaded into grade rosters +  - [[admin:class_code|CLASS CODE]] [**required**​] - Numeric value that corresponds to a specific classroom.
-  - [[admin:class_code|CLASS CODE]] [//​optional//​] - Numeric value that corresponds to a specific classroom.+
     * This information can be located by clicking on **REPORTS** then under **DATA REVIEW** click **STAFF REFERENCE**. A reference list of staff and their classrooms should appear, and the class code will be present in the column farthest to the left.     * This information can be located by clicking on **REPORTS** then under **DATA REVIEW** click **STAFF REFERENCE**. A reference list of staff and their classrooms should appear, and the class code will be present in the column farthest to the left.
     * Strongly recommended to allow students to be directly loaded into classroom rosters     * Strongly recommended to allow students to be directly loaded into classroom rosters
-  - Student ID [//​optional//​] - Unique ID given to student+  - Student ID [**required**​] - Unique ID given to student
     * Recommended,​ however will be available for updates later     * Recommended,​ however will be available for updates later
  
Line 88: Line 87:
   - 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.1565715822.txt.gz · Last modified: 2024/03/05 12:58 (external edit)