Updating and Importing Bus Assignments for Students

This article will explain the various ways you can update student bus assignments in the system.

TABLE OF CONTENTS

• Manually Adjusting an Individual Student’s Bus Assignment
• Mass Updating Student Records with a Daily Interface/Integration
• Mass Updating Student Records with an Excel File Through Core>Import

Manually Adjusting an Individual Student’s Bus Assignment

You can make changes to an individual student’s bus record via Student Data>Modify Student>Bus.

When you navigate to the student's Bus tab, you can add/modify/delete AM and PM bus records and fields (such as Bus Stop, Pick Up Comments etc) as needed:

Mass Updating Student Records with a Daily Interface/Integration

We have a Student Bus Import interface that you can request to enable for your district. There is a quote to enable this task. Enter a ticket with the help desk to request this interface.

It can work with various transportation interfaces and formats to bring in students’ bus data. Our list of 3rd part interfaces are listed here for review.

Mass Updating Student Records with an Excel File Through Core>Import

If you need to mass update student records, you can create/compile an Excel file with student bus assignment info and perform an import via Core>Import.  If you've never used Core>Import before, review our documentation on the tab HERE.

To download the proper template, the Group to select would be STUDENT-DATA and the Table would be StudentBusAssignment.

Steps to Import the Excel Template via Core>Import

1. Navigate to Core>Import.
2. Select STUDENT-DATA as the Group and StudentBusAssignment as the Table.
3. Download the excel template with the “Click here to download template XLS” button.
   
4. After downloading the template, you would have to then update the excel file with the student bus assignment that you have for your district. For example, if you have an excel of information already, you can drop the info into the excel template DOWNLOADED from the Core>Import tab into the proper columns etc.  You have to compile this excel and it must match the Column heads on the downloaded StudentBusAssignment Template to work successfully.
   • You can review the Column Headers, Primary Key columns (which are required to be on the file) and the other columns that you have information for.
   • Remove any column from the excel entirely that you are NOT using. (Never remove the Primary Key columns.)
   • "Primary Key" columns for the StudentBusAssignment template are:
     • SCHOOL_YEAR – the format is 202X-2X. So, if you're uploading 2025-26 data, you'd enter 2025-26.
     • STUDENT_ID – this is the student’s Local ID in Genesis
     • AMPM – this is to indicate if the bus info is an AM or PM record because you can have both AM and PM records for a student, if applicable
     • ENTRY_ID – this is a required field - it just has to have a number in it. For example, just enter 1.
   • These are the other columns you may be looking to update with this template (but are not required necessarily):
     • WALKS_TO_SCHOOL – this is a Boolean field so you’d enter Y or N
     • WALKS_HOME_FROM_SCHOOL – this is a Boolean field so you’d enter Y or N
     • BUS_STOP_CODE – enter a value here for their stop. Max characters = 150
     • BUS_ROUTE – enter a value here for their bus route. Max characters = 50
     • BUS_DESTINATION_CODE - enter a value for their bus destination code. Max characters = 50
     • BUS_SEAT - enter a value for their bus seat. Max characters = 50
     • MONDAY - this is a Boolean field so you’d enter Y or N
     • TUESDAY - this is a Boolean field so you’d enter Y or N
     • WEDNESDAY - this is a Boolean field so you’d enter Y or N
     • THURSDAY - this is a Boolean field so you’d enter Y or N
     • FRIDAY - this is a Boolean field so you’d enter Y or N
     • AIDE_IN_LIEU - this is a Boolean field so you’d enter Y or N
     • COMMENTS – this would update the ‘comments’ field on the Student’s Bus tab. Max characters = 255
     • BUS_STOP_TIME - enter a value here for their Bus Stop Time. Max characters = 8
     • MILES
     • BUS_NUMBER - enter a value here for their Bus Number. Max characters = 50
     • DO_NOT_ROLLOVER - this is a Boolean field so you’d enter Y or N
     • START_DATE – start date of the record
     • END_DATE – end date of the record
     • BUS_COMPANY - enter a value here for their bus company. Max characters = 150.
     • BUS_CONTACT_NUMBER - enter a value here for their Bus Contact Number. Max characters = 150
   • Enter info into the columns as needed for the students. Remove any columns that are NOT the Primary Key columns from the excel file if you are NOT using them.
5. When the excel file is ready, navigate back to Core>Import and select STUDENT-DATA as the Group and StudentBusAssignment as the Table once more.
6. Review the options in step 5:
   
7. Select your newly updated excel file with the “Choose File” button.
   
8. Click “Upload File” to upload the excel file.