Using UPSTOP

1
Using UPSTOP

• A Substitute for Stop Optimization

Pre Page
First Page
Next Page
Last Page
Use the buttons to move around the training
package
2
Table of Contents

• 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

3
Introduction

• UPSTOP
• UP Programs
• Uses
• BUILDTXT

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

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

6
UPSTOP Uses

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

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

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

9
BUILDTXT

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

10
Overview
Using UPSTOP
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
  directoryfilename
• Example staupstop.dat

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

13
Overview Using UPSTOP

• Open the report file in wordpad
• Use wordpad to replace the school code
• Search for old school code ltspgt ltspgt ltspgt
• Replace with new school code ltspgt ltspgt ltspgt
• Check Match whole word only

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

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

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
  / / / /
  
  
  
  

17
Overview Using UPSTOP

1. Rebuild keys in EMU

18
Example 1

• Create Stops For Summer School 111 For Summer
  School Students

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

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

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_ltschool gt (ex C\QMF_111)

22
Example 1

1. Run query
2. View the file? Up to you.

23
Example 1

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

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 STAUPSTOP.DAT

25
Example 1

• Run UPSTOP
• uses STAUPSTOP.DAT as input
• Run EMU batch 1 Rebuild Keys

26
Example 2
Creating Stops For One School From Another
27
Example 2

• Create stops for school 338 from school 320 stops

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

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

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

31
Example 2

1. Run query
2. View the file if youd like to see it now.

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

33
Example 2

• Edit
• Replace
• Find what? old school code ltspgt ltspgt ltspgt
• Replace with new school code ltspgt ltspgt ltspgt
• Check Match whole word only
• Replace all

34
Example 2

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

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 STAUPSTOP.DAT
• Overwrite existing file

36
Example 2

• Run UPSTOP
• uses STAUPSTOP.DAT as input
• Rebuild keys

37
Example 3
Creating Stops For A New School
38
Creating Stops for New School

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

39
Creating Stops for New School

• User-defined reports
• Work lists update

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 schools boundary

41
Create file containing stop info upstop.dat

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

42
Create upstop.dat

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

43
Create upstop.dat

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

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.