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/07/29 10:45] lillieadmin:spreadsheet_file_format [2019/08/13 13:03] – [Bulk Loading] lillie
Line 65: Line 65:
     * Recommended,​ however will be available for updates later     * Recommended,​ however will be available for updates later
  
-FIXME [[admin:load_data#​students|More details]] on how to generate carpool IDs and the class codes. If you don't have carpool pick up ID numbers assigned, then use your student information system to export the street address in place of the class code listed above.+[[admin:load_data#​students|More details]] on how to generate carpool IDs and the class codes. If you don't have carpool pick up ID numbers assigned, then use your student information system to export the street address in place of the class code listed above.
  
 ==== 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