Utility programs are designed to process or speed up tasks that aren't part of the normal daily, weekly, or monthly routine. Two utility programs are available for creating vehicle cross-reference numbers.

Anchor
_Toc151867357 _Toc151867357

Anchor
_Toc200860533 _Toc200860533

Anchor
_Toc237141081 _Toc237141081

Anchor
_Toc487792010 _Toc487792010

Create Fuel Cross-Reference

This program creates a vehicle cross-reference file using the Fuel cross reference field in the vehicle record (MVM, Fluids tab). The Fuel cross reference field is used when:

...

1. Select System > Utilities > Vehicles > Create Fuel Xref from the RTA main menu (STVX).
2. Read the message displayed and choose Yes to continue.
3. Select a radio button to specify whether to create the fuel cross-references by using the fuel cross-reference or the primary vehicle number. Choose Cross Reference Number to use the existing data in the Fuel xref field. Choose Vehicle Number to fill in the Fuel xref field with the primary vehicle number; when choosing this option, select Update vehicles to update all vehicles, leave it unmarked to update vehicles only when the Fuel xref field is empty, leaving any existing values intact.
4. Enter the starting and ending facility number(s) or press F1 to select the facility number(s) from the lookup list.
5. When the process is complete, review messages and/or reports generated.

Anchor
_Toc151867358 _Toc151867358

Anchor
_Toc200860534 _Toc200860534

Anchor
_Toc237141082 _Toc237141082

Anchor
_Toc487792011 _Toc487792011

Create Unit Cross-Reference

This program creates a vehicle cross-reference file using the Unit Xref field in the vehicle record (MVM, main window). The Unit Xref field is used when:

...

1. Select System > Utilities > Vehicles > Create Unit Xref from the RTA main menu (STVU).
2. Select a radio button to specify whether to create the unit cross-references by using the unit cross-reference or the primary vehicle number. Choose No to use the existing data in the Unit Xref field. Choose Yes to fill in the Unit Xref cross reference field with the primary vehicle number; when choosing this option, set Update vehicles to YES update all vehicles, set it to NO to update vehicles only when the Unit Xref field is empty, leaving any existing values intact.
3. If No was chosen at the "Create cross reference file…" prompt, you have the additional option of filling in the Unit Xref field with the primary vehicle number if that field is currently empty; choose Yes to fill in the field; choose No to leave the field blank.
4. When the process is complete, review messages and/or reports generated.

Anchor
_Toc151867359 _Toc151867359

Anchor
_Toc200860535 _Toc200860535

Anchor
_Toc237141083 _Toc237141083

Anchor
_Toc487792012 _Toc487792012

Resequence Vehicle History

This program cleans up the vehicle history data file by removing vehicle history for vehicles that have been deleted from the system and re-indexing the history for existing vehicles.

1. Select System > Utilities > Vehicles > Resequence History from the RTA main menu (STVH).
2. Read the message displayed and choose Yes to continue.
3. You'll have the choice of dropping history records for vehicles that have been deleted from the system; choose Yes or No according to preference and the process will start immediately thereafter; choose Cancel to exit the program.

Anchor
_Toc200860536 _Toc200860536

Anchor
OLE_LINK3 OLE_LINK3

Anchor
OLE_LINK4 OLE_LINK4

Anchor
_Toc237141084 _Toc237141084

Anchor
_Toc487792013 _Toc487792013

Export/Import Vehicle Records

This program exports your vehicle records into a tab delimited text file. This file can then be edited manually or via a spreadsheet program, and then re-imported into the RTA system to update any changes made.
Notes:
The utility creates a backup copy of the file with a .bak extension. This allows you to import the .bak file and restore to the original state should it be desired.
This utility prompts for system password level 3. This utility is considered a "power user" utility. As such, it is not restricted by user security settings within the RTA software. Therefore, it is necessary to protect access to the utility with the highest system password.

Exporting the Data

• From the main menu in RTA, select System > Utilities > Vehicle Export/Import (STVI).
• At the prompt screen, choose "Export" and select the facility or range of facilities you wish to export.
• Specify a file to create. Generally you should use a .txt extension (ex. Vehicles.txt)
• The utility will process your vehicles records and the file is created.

Editing the Data

Import the file (ex. Vehicles.txt) into your spreadsheet software for editing.Detailed instructions are included below for Microsoft Excel 2003. Special care is required to follow the steps exactly as outlined below. If the formatting is not done correctly, Excel may cause unintended changes to your data values.
Start Microsoft Excel.
Choose Data->Import External Data->Import Data.
Select the file that you exported from RTA (ex. Vehicles.txt)This initiates Excel's import wizard…
Wizard step 1: Choose delimited for the file type (this is the default) and click the 'Next' button.
Wizard step 2: Choose tab for the delimiter (this is the default) and change the text qualifier to {none}. Click the 'Next' button.
Wizard step 3: The first column is already highlighted. We need to select ALL of the columns. Do this by dragging the bottom scrollbar all the way to the right. Hold down the 'Shift' key and click on the word 'General' on that last column. This will highlight all of the columns. Now, change the 'Column Data Format' option to TEXT. Click the 'Finish' button.
The spreadsheet columns will now display your RTA vehicle data.
Once data is brought into a spreadsheet to be changed, the following rules apply:

• You may not remove or add columns to the file.
• The utility does not delete records, it will only update existing or add new records (if the add non-file option is selected).
• The first 2 columns may not be modified (facility and vehicle number).
• The column titles display the field name and the maximum length of the field, such as Vehicle (8). Filling in data that exceeds this size limit will be truncated when the data is re-imported back into the RTA system.
• The first row exported contains a legend describing each field's contents and size limits.

Saving the file

• Now that you're done editing the data in your spreadsheet program, you'll need to save the file so that it can be re-imported into RTA.
• It is imperative that you save the file as a TAB-DELIMITED ASCII TEXT file. Generally, this means maintaining a .txt file extension.
• Do not allow your spreadsheet software to convert the file into it's native format (such as .xls for Microsoft's Excel).

...

• From the main menu in RTA, select System > Utilities > Vehicle Export/Import (STVI).
• At the prompt screen, choose "Import".
• Specify the file you edited in your spreadsheet. (ex. Vehicles.txt)
• Check the Add Non-File box if you wish to add new vehicle records.
• The utility will process your vehicles records, applying any changes found and adding any new vehicle numbers found.
• When the import utility completes, an error file is created. The error file is named the same as your data file, with a .err extension (ex. Vehicles.err). This file should be reviewed for any possible exceptions during the import process.

Anchor
_Toc487792014 _Toc487792014

PM Date Maintenance

This program allows you to indicate specific days that vehicles are used and not used. PMs will only be tracked for the days that the vehicles are in use. For example, if your company is closed on weekends, you would indicate that only Monday through Friday should be counted towards the PM intervals. Another example, your company is closed from December 23^rd through January 2^nd for the holidays. You can block out this entire date range as "not used" and the PMs will not show up as due during those dates.

...