Global Vehicle Change

NOTE: This utility program requires the use of the Report Writer program.
This time saving utility program allows a field in the vehicle record to be changed in multiple vehicle records. Global Vehicle Change is actually a two-part process. The first part is performed entirely through a Report Writer program, to create an ASCII file containing a list of vehicle numbers to change, the ID code for the field to change, and the new data value. The second part, performed through the Global Vehicle Change utility, processes the ASCII file and updates the vehicles listed with the new data.

Part 1: Creating the ASCII Input File

The first part in using the Global Vehicle Change utility is creating the ASCII file. The ASCII file can be created with the Crystal Report Writer program or another method as long as the output contains the file layout shown.

Columns

Size

Description

1

1

Filler (space)

2 – 5

4

Vehicle Facility Number

6 – 13

8

Vehicle Number

14 – 17

4

Field ID Code

18 – 37

20

New Value


The ASCII file provides the list of vehicles to change, the field ID code, and the new data value for that field. Most of the fields in the vehicle record can be changed. There are some fields, however, that cannot be changed globally using this utility but may be changed through other utilities. For example, the vehicle PM information cannot be modified through this utility but can be modified by using the Set PM utility from the Utilities 1 Package.
The following data fields cannot be changed globally using the Global Vehicle Change utility.

Field Description

Field Description

Field Description

Alternate Meters

Registration Number

Depreciation Periods

Alternate Meter Readings

Serial Number

Insurance Cost

Average M.P.G.

Split Fuel Vehicle Number

Licensing Cost

EFI Cross Reference

Split Fuel Percentage

Highway Tax

License Number

Transmission Make

Leased Vehicle Flag

License Expiration Period

Transmission Model

Outside Vehicle Flag

License Expiration Interval

Purchase Price

Fuel Taxable Flag

Meter readings

Trade In Value

 

PM Information

Current Value

 

The following data fields can be changed using the Global Vehicle Change utility. Refer to the chart for the field ID code. For example, to change the data in the department field, an ID code of A012 would be used in the ASCII input file.

Field Description

Code

Field Description

Code

Field Description

Code

Alternator Make

A251

Location

A061

Special Body Make

A281

Alternator Amps

A252

Lugs

A211

Special Body Model

A291

ATF Part Number

B231

Make

A022

Special Equipment

A301

ATF Capacity

B232

Meter Type

A091

Steering

A271

Brakes

A261

Miscellaneous Field 1

B261

Tire: Currently Mounted

B251

Class

A042

Miscellaneous Field 2

B271

Tire: Max. Mountable

B252

Customer Facility Number

B351

Model

A031

Tire: Ply

A201

Customer Number

B352

Oil Part Number

B211

Tire: PSI

A202

Department

A012

Oil Capacity

B221

Tire: Size

A191

Engine Make

A111

Operator

A071

Unit Cross Reference

B361

Engine Model

A112

Purchase Date

A101

User-Definable Description

B011-

Front Axle

A171

Rear End Capacity

A161

(ends with 1)

B201

Fuel Capacity

B311

Rear End Make

A151

User-Definable Value

B012-

Fuel Type

A092

Service Notes, Line 1

B281

(ends with 2)

B202

G.V.W.

A231

Service Notes, Line 2

B291

Wheel Base

A241

In Service Date

A102

Service Notes, Line 3

B301

Wheel Size

A181

Inspection State/Type

A221

Size

A032

Year

A021


An ASCII text file named VTREC.PRT will need to be created containing the data changes desired, and then provided to the Global Vehicle Change utility. A sample ASCII file is shown below.

0001

1807

A012

FIRE

0001

1808

A012

FIRE

0002

1825

A012

FIRE

0003

TL228561

A012

FIRE

If the sample file above was processed by the Global Vehicle Change utility, the value of FIRE would be pushed into the department field for vehicle numbers 1807 and 1808 in facility 1, vehicle number 1825 in facility 2, and vehicle number TL228561 in facility 3, regardless of what value may have been in the department field previously.
Once the ASCII file has been created, refer to the next section to run the Global Vehicle Change utility program.

Part 2: Running the Utility Program

  1. Select System > Custom Utilities II > Vehicles > Global Vehicle Change from the RTA main menu (SIVG).
  2. Read the message displayed and then choose Yes to continue.
  3. When prompted for the input file name, press Enter to accept the default file shown (vtrec.prt) or enter the name of the input file to process. Any filename is valid as long as the file layout is correct.
  4. Choose OK to continue.
  5. Choose Yes to confirm and start the process.

Undoing the Global Changes

Each time the Global Vehicle Change utility is run, the system creates a backup file (undofile.und) just in case you need to undo the changes. This file is of the same format as the input file, except that the new value field actually contains the old data value that was stored in that field prior to the change. The undofile.und file is overwritten each time the Global Vehicle Change utility is processed, so you should verify the most recent change that was processed prior to processing the next change (i.e. you can only undo the last change). To undo the last global vehicle change processed, simply repeat steps 1 – 5 listed in "Part 2: Running the Utility Program"-except, when prompted for the filename, enter undofile.und as the file to process.
TIP: If you want to keep all the undo files as a backup, simply rename the undofile.und file after each run (deptchg.und, classchg.und, and so forth).