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

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
admin:spreadsheet_file_format [2019/08/09 10:46] – [Format (Syntax)] lillieadmin:spreadsheet_file_format [2019/08/13 13:46] – [Format (Syntax)] lillie
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 ====
Line 113: Line 113:
  
 ==== Bulk Loading ==== ==== Bulk Loading ====
-  - From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Next, click on **BUS**. This will direct you to a webpage that looks like the screenshots below.+  - From an administrator account, click on **GROUPS** at the top of the page. You should see a dropdown menu. Next, click on **BUS**. From the table of buses, click the value of the bus you would like to edit under the "Stops" column. This will direct you to a webpage that looks like the screenshots below.
   - Using your spreadsheet containing account data, select the columns & rows for each student that must be created, including columns that were left blank during data input as they will serve as a placeholder.   - Using your spreadsheet containing account data, select the columns & rows for each student that must be created, including columns that were left blank during data input as they will serve as a placeholder.
   - Copy & paste your selection from the spreadsheet into the textbox on the page. Remember to review your entry to avoid errors in transfer.   - Copy & paste your selection from the spreadsheet into the textbox on the page. Remember to review your entry to avoid errors in transfer.
   - After verifying this data is correct, click on the “Submit” button below the textbox.   - After verifying this data is correct, click on the “Submit” button below the textbox.
 {{:lillie:bus-stop-loading-1.png?600|}} {{:lillie:bus-stop-loading-2.png?600|}} {{:lillie:bus-stop-loading-1.png?600|}} {{:lillie:bus-stop-loading-2.png?600|}}
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1