Comprehensive Guide to Using UPSTOP for School Transportation Optimization

1. Using UPSTOP A Substitute for Stop Optimization Pre Page Next Page Last Page First Page Use the buttons to move around the training package

2. Intro UPSTOP UP* Programs UPSTOP Uses BUILDTXT Overview: Using UPSTOP Example 1: Create Stops For Summer School III For Summer School Students Example 2: Creating Stops For One School From Another Example 3: Creating Stops For A New School Table of Contents Using UPSTOP - 2002

3. Introduction • UPSTOP • UP* Programs • Uses • BUILDTXT Using UPSTOP - 2002

4. UPSTOP • Creates stops from text file input • You are familiar with UPSTU • Creates student records from text file • Upstop does the same for stops! • One member of a family of programs Using UPSTOP - 2002

5. Transportation UP* Programs • Programs that create TIMS transportation data from text file input • Upstop: creates stops • Uprun: creates runs with no stops • Upruntrn: puts stops on runs • Upstopruntrn: creates stops and runs and places stops on runs Using UPSTOP - 2002

6. UPSTOP Uses • Create stops for students rising to a different school • Create stops for summer school • Create stops for a new school Using UPSTOP - 2002

7. BUILDTXT • UPSTOP requires use of BUILDTXT.EXE • A specialized, Edulog text editor • Produces specially formatted text files read by transportation UP* programs • Found in \elt\exe\report Using UPSTOP - 2002

8. BUILDTXT • Requires text input • Buildtxt can import: • TIMS stop or student reports • Other text files • List of summer school students with summer school code and student address Using UPSTOP - 2002

9. BUILDTXT • Buildtxt can also be used as a field-by-field text editor for manual data input or modification Using UPSTOP - 2002

10. Overview Using UPSTOP Using UPSTOP - 2002

11. Overview: Using UPSTOP • UPSTOP is run from a batch file • The batch file sets switches and defines the input file. • Switches: (0 = no, 1 = yes) • Permanent • Override address matching • Input file name format: logical directory:filename • Example – sta:upstop.dat Using UPSTOP - 2002

12. Overview: Using UPSTOP • Create a report containing stop information • Usually a TIMS stop or student report • Minimum info: school code and stop address/corner • Position of fields in record not important Using UPSTOP - 2002

13. Overview: Using UPSTOP • Open the report file in wordpad • Use wordpad to replace the school code • Search for: old school code<sp> <sp> <sp> • Replace with: new school code<sp> <sp> <sp> • Check “Match whole word only” Using UPSTOP - 2002

14. Overview: Using UPSTOP • Import file into BUILDTXT program • You define position of school code and address in input file when you import • Export file from BUILDTXT as upstop.dat • Run UPSTOP using upstop.dat as input Using UPSTOP - 2002

15. Overview: Using UPSTOP • Check error files • Located in \users\username\tmp • Upstp1.err: contains nature of error Line School Error Error • 330 Stop is not address matched Street one not matched OAKLAND AV EX & OLD SECREST AV • 330 Stop is not address matched Street two not matched SETTLEMYRE RD & ABEE ST DX • 330 Stop is not address matched Street two not matched HOLLAR ST & MOUNTAIN VI ST DX 59 330 Stop is not address matched Street one not matched POTEAT DR DX & WOODSIDE DR Using UPSTOP - 2002

16. Overview: Using UPSTOP • Upstp2.err: input file containing only errors • Fix errors and reuse for second run of UPSTOP 330 OAKLAND AV EX & OLD SECREST AV / / / / 330 SETTLEMYRE RD & ABEE ST DX / / / / 330 HOLLAR ST & MOUNTAIN VI ST DX / / / / 330 POTEAT DR DX & WOODSIDE DR / / / / Using UPSTOP - 2002

17. Overview: Using UPSTOP • Rebuild keys in EMU Using UPSTOP - 2002

18. Example 1 Create Stops For Summer School 111 For Summer School Students Using UPSTOP - 2002

19. Example 1 • Run Student Report for BUILDTXT input • Report Module, User Defined Reports • All Student and Transportation • Copy “Standard all Students” • Name “Student Locations for UPSTOP” • Select the new report Using UPSTOP - 2002

20. Example 1 • Remove existing filters • Add filter to include only students for desired school • Field = student School • Operator = exactly matches • Value = 111 • Remove existing output fields • Add “student School” and “student Residence” to output fields • Sort order not important Using UPSTOP - 2002

21. Example 1 • Pick output type: Text file with fixed record lengths • Define target directory and name for file • Name must begin with “QMF” • Maximum of 8 characters • No “.” • No extension (txt, dat, etc.) • Use: C:\QMF_<school #> (ex: C:\QMF_111) Using UPSTOP - 2002

22. Example 1 • Run query • View the file? Up to you. Using UPSTOP - 2002

23. Example 1 • BUILDTXT: Define position of school code and address in input file prior to importing • Use the following specs for this report Using UPSTOP - 2002

24. Example 1 • Import student report into BUILDTXT program • Modify/add/delete records as necessary • In this case, no modification needed. • Export file from BUILDTXT as STA:UPSTOP.DAT Using UPSTOP - 2002

25. Example 1 • Run UPSTOP • uses STA:UPSTOP.DAT as input • Run EMU batch #1 Rebuild Keys Using UPSTOP - 2002

26. Example 2 Creating Stops For One School From Another Using UPSTOP - 2002

27. Example 2 • Create stops for school 338 from school 320 stops Using UPSTOP - 2002

28. Example 2 • Run Stop Report for BUILDTXT input • Report Module, User Defined Reports • Stops/Runs/Routes • Copy “Standard Stop Report #1 PTSIII” • Name “Stop Report for UPSTOP” • Select the new report Using UPSTOP - 2002

29. Example 2 • Remove existing filters • Add filter to include only stops for desired school • Field = Stop Stop ID • Operator = begins with • Value = 320 • Remove existing output fields • Add “school School Code” and “stop Location” to output fields • Sort order not important Using UPSTOP - 2002

30. Example 2 • Pick output type: Text file with fixed record lengths • Define target directory and name for file • Name must begin with “QMF” • Maximum of 8 characters • No “.” • No extension (txt, dat, etc.) • Example: C:\QMF320 Using UPSTOP - 2002

31. Example 2 • Run query • View the file if you’d like to see it now. Using UPSTOP - 2002

32. Example 2 • 2. Use wordpad to replace the school code • Open wordpad • Open the report you just created • Check to make sure you have the right set of stops and the right fields Using UPSTOP - 2002

33. Example 2 • Edit • Replace • Find what?: old school code<sp> <sp> <sp> • Replace with: new school code<sp> <sp> <sp> • Check “Match whole word only” • Replace all Using UPSTOP - 2002

34. Example 2 • Define position of school code and address in input file prior to importing • Use the following specs for this report Using UPSTOP - 2002

35. Example 2 • Import report into BUILDTXT program • Modify/add/delete records as necessary • In this case, no modification needed. • Export file from BUILDTXT as STA:UPSTOP.DAT • Overwrite existing file Using UPSTOP - 2002

36. Example 2 • Run UPSTOP • uses STA:UPSTOP.DAT as input • Rebuild keys Using UPSTOP - 2002

37. Example 3 Creating Stops For A New School Using UPSTOP - 2002

38. Creating Stops for New School • Edulognt • Create list of stops belonging to contributing schools that fall in new school boundary • Load list Using UPSTOP - 2002

39. Creating Stops for New School • User-defined reports • Work lists update Using UPSTOP - 2002

40. Creating Stops for New School • User-defined Reports, Stops/Runs/Routes, Stop Report #1 • Set filter • All stops for schools contributing children that are within the new school’s boundary Using UPSTOP - 2002

41. Create file containing stop info: upstop.dat • 2. Use \elt\exe\report\buildtxt.exe • Start from windows explorer • Browse Using UPSTOP - 2002

42. Create upstop.dat • 3. Write upstop.dat to \elt\server\sta Using UPSTOP - 2002

43. Create upstop.dat • 4. Run \elt\exe\emu\upstop.exe Using UPSTOP - 2002

44. Using UPSTOP A Substitute for Stop Optimization This concludes the training session. Please do one of the following: • Go back and review areas that interest you. • Try the examples. • Exit the presentation. Using UPSTOP - 2002