Using UPSTOP - PowerPoint PPT Presentation

Using UPSTOP

A Substitute for Stop Optimization

Pre Page

Next Page

Last Page

First Page

Use the buttons to move around the training package

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

Using UPSTOP - 2002

• UPSTOP
• UP* Programs
• Uses
• BUILDTXT

Using UPSTOP - 2002

• 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

• 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

• Create stops for students rising to a different school
• Create stops for summer school
• Create stops for a new school

Using UPSTOP - 2002

• 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

• 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

• Buildtxt can also be used as a field-by-field text editor for manual data input or modification

Using UPSTOP - 2002

Using UPSTOP

Using UPSTOP - 2002

• 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

• 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

• 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

• 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

• 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

• 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

• Rebuild keys in EMU

Using UPSTOP - 2002

Create Stops For Summer School 111 For Summer School Students

Using UPSTOP - 2002

• 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

• 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

• 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

• Run query
• View the file? Up to you.

Using UPSTOP - 2002

• BUILDTXT: Define position of school code and address in input file prior to importing
• Use the following specs for this report

Using UPSTOP - 2002

• 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

• Run UPSTOP
• uses STA:UPSTOP.DAT as input
• Run EMU batch #1 Rebuild Keys

Using UPSTOP - 2002

Example 2

Creating Stops For One School From Another

Using UPSTOP - 2002

• Create stops for school 338 from school 320 stops

Using UPSTOP - 2002

• 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

• 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

• 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

• Run query
• View the file if you’d like to see it now.

Using UPSTOP - 2002

• 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

• 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

• Define position of school code and address in input file prior to importing
• Use the following specs for this report

Using UPSTOP - 2002

• 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

• Run UPSTOP
• uses STA:UPSTOP.DAT as input
• Rebuild keys

Using UPSTOP - 2002

Creating Stops For A New School

Using UPSTOP - 2002

• Edulognt
• Create list of stops belonging to contributing schools that fall in new school boundary
• Load list

Using UPSTOP - 2002

• User-defined reports
• Work lists update

Using UPSTOP - 2002

• 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

• 2. Use \elt\exe\report\buildtxt.exe
• Start from windows explorer
• Browse

Using UPSTOP - 2002

• 3. Write upstop.dat to \elt\server\sta

Using UPSTOP - 2002

• 4. Run \elt\exe\emu\upstop.exe

Using UPSTOP - 2002

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