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
- Select System > Custom Utilities II > Vehicles > Global Vehicle Change from the RTA main menu (SIVG).
- Read the message displayed and then choose Yes to continue.
- 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.
- Choose OK to continue.
- 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).