Use this program to: To access the Export Vehicle File Records program, type EXPVEH (RET) at any menu "OPTION:" field or the appropriate line number on the Import/Export Data sub-menu of the System Management menu. The screen will display as follows:

OPTION: __ EXPORT VEHICLE RECORDS TO CSV

1 Owning Location ALL
2 Start In-service Date EARLIEST
3 End In-service Date LATEST
4 Include Sold Units N
 5 Start Sale Date
6 Output Printer









1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8



Enter data as follows:

1. OWNING LOCATION

Enter up to 6 alphanumeric characters to indicate the vehicles' owning Location. Enter:

  1. Up to 6 alphanumeric characters to select vehicles currently at a single location.
  2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups).
  3. Press RETURN to default to ALL locations.

EXAMPLE: Type TUS (RET)

2. START IN-SERVICE DATE

This field and the next one are used to define an in-service date range for the vehicle data that will be exported. This refers to the "In Service Date" field in the Vehicle Inventory record. Enter a starting date.

EXAMPLE: TYPE 010114 (RET)
3. END IN-SERVICE DATE

This field and the previous one are used to define an in-service date range for the vehicle data that will be exported. Enter an ending date.

EXAMPLE: Press (RET)
4. INCLUDE SOLD UNITS
 Enter:
Y = vehicles in status "S" (sold) will be included in the sale date in the Vehicle Inventory record is the same as or later than the date entered in the next field.

N = do not include sold vehicles.
EXAMPLE: Type Y (RET)
5. START
SALE DATE
 If the previous field is set to "Y", enter a starting date for the sale date. Vehicles in status "S" (sold) with a sale date of this date or later will be included.

EXAMPLE: Type 010115 (RET)
6. OUTPUT PRINTER In order to get the CSV file, enter a printer name that causes the output to be opened or saved as a file. For most users, the value of CSV or EDITOR will work for this purpose. Please refer to the chapter for Edit Terminal Records or Change User Environment for more information on setting up printing to a file and/or opening a file in the default program for that file.

EXAMPLE: Type CSV (RET)

The headers for the csv file are the same as those used by the Import Vehicle File Records program. Refer to that chapter for a detailed table listing the headers.

Additionally, any Hold Codes on the vehicle are included at the end of each record.


PRESS F1 TO BEGIN.