1 / 44

Using UPSTOP

Using UPSTOP. A Substitute for Stop Optimization. Pre Page. Next Page. Last Page. First Page. Use the buttons to move around the training package. Intro UPSTOP UP* Programs UPSTOP Uses BUILDTXT Overview: Using UPSTOP.

arnold
Download Presentation

Using UPSTOP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related