using upstop l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Using UPSTOP PowerPoint Presentation
Download Presentation
Using UPSTOP

Loading in 2 Seconds...

play fullscreen
1 / 44

Using UPSTOP - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Using UPSTOP' - mariel


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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

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

Table of Contents

Using UPSTOP - 2002

introduction
Introduction
  • UPSTOP
  • UP* Programs
  • Uses
  • BUILDTXT

Using UPSTOP - 2002

upstop
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

transportation up programs
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

upstop uses
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

buildtxt
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

buildtxt8
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

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

Using UPSTOP - 2002

overview
Overview

Using UPSTOP

Using UPSTOP - 2002

overview using upstop
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

overview using upstop12
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

overview using upstop13
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

overview using upstop14
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

overview using upstop15
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

overview using upstop16
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

overview using upstop17
Overview: Using UPSTOP
  • Rebuild keys in EMU

Using UPSTOP - 2002

example 1
Example 1

Create Stops For Summer School 111 For Summer School Students

Using UPSTOP - 2002

example 119
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

example 120
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

example 121
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

example 122
Example 1
  • Run query
  • View the file? Up to you.

Using UPSTOP - 2002

example 123
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

example 124
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

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

Using UPSTOP - 2002

slide26

Example 2

Creating Stops For One School From Another

Using UPSTOP - 2002

example 2
Example 2
  • Create stops for school 338 from school 320 stops

Using UPSTOP - 2002

example 228
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

example 229
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

example 230
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

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

Using UPSTOP - 2002

example 232
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

example 233
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

example 234
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

example 235
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

example 236
Example 2
  • Run UPSTOP
    • uses STA:UPSTOP.DAT as input
  • Rebuild keys

Using UPSTOP - 2002

example 3
Example 3

Creating Stops For A New School

Using UPSTOP - 2002

creating stops for new school
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

creating stops for new school39
Creating Stops for New School
  • User-defined reports
    • Work lists update

Using UPSTOP - 2002

creating stops for new school40
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

create file containing stop info upstop dat
Create file containing stop info: upstop.dat
  • 2. Use \elt\exe\report\buildtxt.exe
    • Start from windows explorer
    • Browse

Using UPSTOP - 2002

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

Using UPSTOP - 2002

create upstop dat43
Create upstop.dat
  • 4. Run \elt\exe\emu\upstop.exe

Using UPSTOP - 2002

using upstop44
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