Vehicle PM Import and Export
This program exports your customer 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.
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
Field | Value | Type/Size |
|---|---|---|
| Vehicle Facility | Required | int(5) |
| Vehicle Number | Required | char(8) |
| PM Code | Required | int(5) |
| Include PM Code | A0 thru Z9 | char(1)Int(1) |
| Major VMRS | Required | int(3) |
| Intermediate VMRS | Required | int(3) |
Minor VMRS | Required | int(3) |
| Description | char(50) | |
| Template WO Facility | int(5) | |
| Template WO Number | char(7) | |
| Part Kit Facility | int(5) | |
| Part Kit Number | char(25) | |
| PM Enabled | Y = PM Enabled (Default) N = PM Not Enabled | char(1) |
| One Time PM | Y = One Time Use PM N = Recurring PM (Default) | char(1) |
| Inspection | char(15) | |
| Primary Meter | (Required) D = Days (Default) | char(1) |
| Lock Days/Months | P = interval is Months (uses CCYYMM from date posted) M = locked interval is Months (ignores date posted) D = locked interval is Days Space = Days meter is NOT locked (Default) | char(1) |
| Interval Days | int(6) | |
| Last Done Date | date | |
| Last Done Lock Date | date | |
| Lock Meter | Y = Meter interval locked N = Meter interval is NOT locked | char(1) |
| Interval Meter | int(6) | |
| Last Done Work Meter | decimal(8, 1) | |
| Last Done Life Meter | int(8) | |
| Last Done Lock Meter | int(8) | |
| Interval Gallons | int(6) | |
| Last Done Gallons | int(8) | |
| Interval Alt Meter 1 | Only valid if the alternate meter is in use | int(6) |
| Last Done Alt Meter 1 | Only valid if the alternate meter is in use | int(6) |
| Interval Alt Meter 2 | Only valid if the alternate meter is in use | int(6) |
| Last Done Alt Meter 2 | Only valid if the alternate meter is in use | int(6) |
| Interval Alt Meter 3 | Only valid if the alternate meter is in use | int(6) |
| Last Done Alt Meter 3 | Only valid if the alternate meter is in use | int(6) |
| Interval Alt Meter 4 | Only valid if the alternate meter is in use | int(6) |
| Last Done Alt Meter 4 | Only valid if the alternate meter is in use | int(6) |
| Current WO Facility | int(5) | |
| Current WO Number | char(7) | |
| Current WO Line | int(2) | |
| Last WO Facility | int(5) | |
| Last WO Number | char(7) | |
| Last WO Line | int2) | |
| Previous WO Facility | int(5) | |
| Previous WO Number | char(7) | |
| Previous WO Line | int(2) | |
| Sleep Mode Enabled | Y = Sleep enabled N = Sleep disabled | char(1) |
| Sleep Date | date | |
| Days Sleep | int(4) | |
| PM is Warranty | Y = PM is Warranty N = PM Not Warranty (Default) | char(1) |
| Warranty Major VMRS | int(3) | |
| Warranty Intermediate VMRS | int(3) | |
| Warranty Minor VMRS | int(3) |