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/09 10:46] – [Format (Syntax)] lillie | admin: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 " |
- 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. | ||
{{: | {{: |
admin/spreadsheet_file_format.txt · Last modified: 2024/03/05 13:13 by 127.0.0.1