Uploading transportation requests.

Door To Door Transportation Only

When uploading transportation requests, there are some strict formatting requirements, each listed below.

• The upload file format must be excel. This can be any version of excel including .xls and .xlsx.
• The columns must be in the correct order. For example, school year must be in the first column. Status type must be in the second column, etc...
• The correct column order is:
  1. School Year
     Required
     Acceptable values are:
     • 2018
     • 2019
  2. Status Type
     Required
     Acceptable values are:
     • Add
     • Cancel
     • Change
     • Other
  3. Sending District
     Required
  4. Billing District
     Required
  5. Door To Door Transportation
     Required
     Acceptable values are:
     • Special Ed
     • In District
     • Tech Academy
     • Summer
  6. Student Last Name
     Required
  7. Student First Name
     Required
  8. Student Date Of Birth
  9. Sex
     Acceptable values are: (M, m, F, f)
  10. Student Address
      Required
  11. Student City
      Required
  12. Student State
      Required
  13. Student Zip
      Required
  14. Student Home Phone
      Required
  15. Student Emergency Phone
      Required
  16. School Name
      Required
  17. Classification
  18. Student Start Date
      This value must be formatted as month/day/year (ex: 4/24/2017)
  19. Student Termination Date
      This value must be formatted as month/day/year (ex: 4/24/2017)
  20. School Address
      Required
  21. School City
      Required
  22. School Start Time
      Required
      This must be a valid time in the format hh:mm AM/PM (Ex: 08:30 AM).
  23. School End Time
      Required
      This must be a valid time in the format hh:mm AM/PM (Ex: 03:15 PM).
  24. One To One Aide
      Required
      A value is Y or y, indicates this is required. Any other value (N, n, or blank) indicate not required.
  25. Wheelchair
      Required
      Acceptable values are (Y, y, N, n, or blank)
  26. CarSeat
      Required
      Acceptable values are (Y, y, N, n, or blank)
  27. Booster
      Required
      Acceptable values are (Y, y, N, n, or blank)
  28. Harness
      Required
      Acceptable values are (Y, y, N, n, or blank)
  29. Monday
      Acceptable values are (Y, y, N, n, or blank)
  30. Tuesday
      Acceptable values are (Y, y, N, n, or blank)
  31. Wednesday
      Acceptable values are (Y, y, N, n, or blank)
  32. Thursday
      Acceptable values are (Y, y, N, n, or blank)
  33. Friday
      Acceptable values are (Y, y, N, n, or blank)
  34. Additional Instructions
  35. Case Manager
  36. Form Completed By
      Required
  37. Completed By Phone
      Required

After uploading your excel file, the data within it will be validated for errors. If there are any errors, they will be highlighted and must be fixed prior to completing the upload process.