Use this program to:

• Export customer data to a csv file. Data is selected for customers who had a minimum number of rentals opening during a date range entered.

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

OPTION: __ CUSTOMER ADDRESS OUTPUT 1 Start Rental Date 2 End Rental Date 3 Times Rented 4 Ouput Device 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START RENTAL DATE	This field and the next one are used to define a date range during which RAs opened. Customer data for those RAs will be included. Note that this refers to the opening date of the RA; not the opening DBR date. Enter a starting date. EXAMPLE: Type 040117 (RET)
2. END RENTAL DATE	This field and the previous one are used to define a date range during which RAs opened. Customer data for those RAs will be included. Note that this refers to the opening date of the RA; not the opening DBR date. Enter an ending date. EXAMPLE: Type 063017 (RET)
3. TIMES RENTED	Enter a minimum number of times rented. (Customers who have rented during the date range less than the number entered will not be included.) EXAMPLE: Type 3 (RET)
4. OUTPUT DEVICE	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 EDITOR (RET)

The screen will then display:

OPTION: __ CUSTOMER ADDRESS OUTPUT 1 Start Rental Date 04-01-17 2 End Rental Date 06-30-17 3 Times Rented 3 4 Ouput Device EDITOR 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

In the example above, the data requested is for customers who rented a minimum of 3 times with pick up dates between April 1 and June 30.
P
RESS F1 TO BEGIN.

The headers for the csv file are:

Last Name
First Name
Address 1
Address 2
City
State
Zip Code
Country
Times Rented

Customer records are listed in numerical order.