Vehicles Import/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) |