Search

Vehicles Import and Export

This program exports your vehicle records into a 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.

When importing vehicles, it is important to note that best practice for Odometers is they SHOULD NOT be updated for existing vehicles through this module. Odometers / Alternate Meters should be updated through an EFI module / Quick Fuel Entry. If you specify an Alternate Meter on the import and use update existing, the value will be placed into the "current" reading, and the "Life" reading. The other Alternate Meter fields will remain untouched.

Import Options:

Create New
Checked - New records will be created
Unchecked - New Records WILL NOT be created

Update Existing
Checked - Existing records will be updated
Unchecked - Existing Records WILL NOT be updated

Import Field Definitions

Diff Factor 2

Field	Value	Type/Size
Facility	Required	int(5)
Vehicle	Required	char(8)
Year		int(4)
Make		char(15)
Model		char(15)
Serial Number		char(20)
License Plate		char(15)
Cross-Reference Number		char(8)
Class		char(15)
Department		char(10)
Customer Facility		int(5)
Customer Number		char(10)
Registration		char(20)
Purchase Date		date
Inservice Date		date
Vehicle Size	L = Light M = Medium H = Heavy T = Trailer O = Other	char(1)
Gross Vehicle Weight	Depending on switch SSM Misc 1 tab #29 alpha or numeric	Numeric int(7) Alpha char(10)
Rear End Capacity		int(7)
Mechanic Number		int(10)
Meter Units	Add only, update not allowed G = Gallons K = Kilometers U = Units M = Miles H = Hours N = None	char(1)
Current Odometer	Add only update not allowed	decimal(8,1)
Post Odometer Life/Period	P = Period L = Life	char(1)
Base Meter		decimal(8,1)+/-
Last Meter Date		date
Last Fuel Date		date
Begin Odometer Reading		decimal(7,1)
Meter Range		int(5)
Vehicle Location		char(20)
Vehicle Operator		char(20)
Inspection Type		char(20)
Inspection Period		int(2)
Inspection Period Count		int(2)
Inspection Position		int(2)
Tire Count	Add only Update not allowed	int(2)
Max Tire Count		int(2)
Usage Code		char(5)
PM Service Note 1		char(40)
PM Service Note 2		char(40)
PM Service Note 3		char(40)
Purchase Price		decimal(8,3)+/-
Insurance Per Year		decimal(8,3)+/-
License Per Year		decimal(8,3)+/-
License Period		int(2)
License Period Count		int(2)
License Position		int(2)
Leased Vehicle	Y = Is Leased N = Not Leased	char(1)
Outside Vehicle	Y = Outside N = Inside	char(1)
Fuel Type	Must match a Fuel type code under fuel types (MUF)	char(1)
Fuel Capacity		int(6)
Average MPG		decimal(3,3)
Highway Tax rate		decimal(1,4)
Fuel Taxable	Y = Taxable N = Not Taxable	char(1)
Split Fuel Facility		int(5)
Split Fuel Number		char(8)
Split Fuel Percentage	Cannot be greater than 1.0000 or less than -1.0000	decimal(1,4)+/-
Fuel Cross-Reference		char(8)
Oil Type		char(25)
Oil Capacity		decimal(4,1)
Transmission Fluid		char(25)
Transmission Capacity		decimal(4,1)
Anti-freeze		char(25)
Anti-freeze Capacity		decimal(4,1)
Gear Oil		char(25)
Gear Oil Capacity		decimal(4,1)
Hydraulic Fluid		char(25)
Hydraulic Capacity		decimal(4,1)
Freon		char(25)
Freon Capacity		decimal(4,1)
Alternate Meter 1	Must match Alternate Meter Type ID (MVA) Add only Update not allowed	int(2).
Alternate Meter 1 Odometer	Add only Update not allowed	decimal(7,2)
Alternate Meter 2	Must match Alternate Meter Type ID (MVA) Add only Update not allowed	int(2).
Alternate Meter 2 Odometer	Add only Update not allowed	decimal(7,2)
Alternate Meter 3	Must match Alternate Meter Type ID (MVA) Add only Update not allowed	int(2).
Alternate Meter 3 Odometer	Add only Update not allowed	decimal(7,2)
Alternate Meter 4	Must match Alternate Meter Type ID (MVA) Add only Update not allowed	int(2).
Alternate Meter 4 Odometer	Add only Update not allowed	decimal(7,2)
classinfo1		char(20)
classinfo2		char(20)
classinfo3		char(20)
classinfo4		char(20)
classinfo5		char(20)
classinfo6		char(20)
classinfo7		char(20)
classinfo8		char(20)
classinfo9		char(20)
classinfo10		char(20)
classinfo11		char(20)
classinfo12		char(20)
classinfo13		char(20)
classinfo14		char(20)
classinfo15		char(20)
classinfo16		char(20)
classinfo17		char(20)
classinfo18		char(20)
classinfo19		char(20)
classinfo20		char(20)
classinfo201		char(20)
classinfo22		char(20)
Definable Description 1		char(15)
Definable Value 1		char(20)
Definable Description 2		char(15)
Definable Value 2		char(20)
Definable Description 3		char(15)
Definable Value 3		char(20)
Definable Description 4		char(15)
Definable Value 4		char(20)
Definable Description 5		char(15)
Definable Value 5		char(20)
Definable Description 6		char(15)
Definable Value 6		char(20)
Definable Description 7		char(15)
Definable Value 7		char(20)
Definable Description 8		char(15)
Definable Value 8		char(20)
Definable Description 9		char(15)
Definable Value 9		char(20)
Definable Description 10		char(15)
Definable Value 10		char(20)
Definable Description 11		char(15)
Definable Value 11		char(20)
Definable Description 12		char(15)
Definable Value 12		char(20)
Definable Description 13		char(15)
Definable Value 13		char(20)
Definable Description 14		char(15)
Definable Value 14		char(20)
Definable Description 15		char(15)
Definable Value 15		char(20)
Definable Description 16		char(15)
Definable Value 16		char(20)
Definable Description 17		char(15)
Definable Value 17		char(20)
Definable Description 18		char(15)
Definable Value 18		char(20)
Definable Description 19		char(15)
Definable Value 19		char(20)
Definable Description 20		char(15)
Definable Value 20		char(20)
Diff Factor 1		int(1)
Diff Factor 2		int(1)
Diff Factor 3		int(1)
Diff Factor 4		int(1)
Diff Factor 5		int(1)
Diff Factor 6		int(1)
Diff Factor 7		int(1)
Diff Factor 8		int(1)
Diff Factor 9		int(1)
Diff Factor 10		int(1)