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).

Part 1: Creating the ASCII Input File

Field Description

Field Description

Part 2: Running the Utility Program

Undoing the Global Changes

Browser not supported