Use this program to:

• Import SIXT rate plan records from an Excel spreadsheet.

I. CREATING THE SPREADSHEET

A. Create the spreadsheet on a PC or computer that is also used to access CARS+.

B. Entering data in the spreadsheet
No column headings are needed and the columns must be in this order:

Rate Code, Rate Plan, CARS+ Rate Product, Source Code

Create a row for each Sixt Rate Plan that should be imported or updated.

C. Naming the spreadsheet file.

When saving the spreadsheet, the name assigned to it should follow Unix file name conventions which are:

• Maximum of 30 characters
• No spaces or slashes in the name

D. Saving the spreadsheet.

First save it in your spreadsheet program's native format (for example if using Microsoft's Excel program, save it as .xls).

Re-save a copy in .csv format.

If an error in the data is discovered by the merge program, go back to the file in the native format and easily make any corrections. Then re-save it again as a comma delimited file (.csv format).

It is the copy saved in .csv format that will be used for the import.

II. UPLOADING THE FILE FROM THE PC TO CARS+

Create the spreadsheet on a PC or computer that is also used to access CARS+. Once the spreadsheet is saved in the csv format, sign into CARS+ using the same computer.

To access the Import SIXT Rate Plans program, type IMPSIXT (RET) at any menu "OPTION:" field or the appropriate line number on the SIXT Programs Menu.

• With the cursor at the "OPTION" field, press F4 to upload the file.
• A browser window will appear. Select the csv file from your PC and click "Send".

III. RUNNING THE IMPORT PROGRAM

The screen for Import Sixt Rates Plans will display as shown below:

OPTION: IMPORT SIXT RATE PLANS 1 File Name 1BEGIN 2 3 4UPLOAD 5 6 7 8

Enter data as follows:

1. FILE NAME

To load the file for processing: a. Type the file name in this field - or b. Press F6 from this field. A search window will appear on the lower half of the screen. Select the appropriate file by typing the row number. An example is shown below.

OPTION: __ IMPORT SIXT RATE PLANS 1. File name Option: _ UPLOAD FILE SEARCH F2=NEXT 8 F4=PREV 8 File Name Create Date 1 rate-plans-101015.csv Oct 10 2015 2 rate-plans-150915.csv Sep 15 2015 ** No More Records **

Select the appropriate file by typing the row number.

PRESS "F1" AT "OPTION:" TO BEGIN .