Use this program to convert the ADF file from the New South Wales Transportation Roads and Maritime Department into the format that can be read by Import Toll Charges.

I. SET-UP STEPS

A. A vendor record must be set up for the New South Wales Transportation Roads and Maritime System. The record must be set up as follows:

  1. Vendor # must be RMS.
  2. Vendor Charge Code must reference a code in Edit Ticket Charge Codes that has the correct GST percent in Field 24.

B. A comma delimited text file needs to be manually set up that will translate the toll description fields to a description that will print on the Toll invoice. The file must be set up as follows:

1. File name = TOLLS.txt

2. Record layout =

Foreign Operator ID (3 characters) - use trailing spaces if the code is not 3 characters long

Plaza ID (3 characters) - use trailing spaces if the code is not 3 characters long

Description = 30 characters

3. Example:

100,1 ,SYDNEY BAY BRIDGE

II. SPREADSHEET FORMAT

The following table shows the record layout that is created by this program.


Required Column Header
Format
Notes
Date
DDMMYY
date the toll was received by the rental company
Vendor-no
8 character Vendor number
"RMS" (this is the Vendor number of the toll issuer)
Offense-type
2 character code
Leave this column blank. The Ticket Charge Code record that is to be used for the admin fee and taxes charged comes from the Charge Code on the Vendor in the previous field will be used.
Citation
up to 20 characters alphanumeric
Toll citation number
Amount
nnnnnn.nn
The amount of the toll charge without any administration fees
License
11 character vehicle license number
License plate number of the vehicle involved
Ticket-date
DDMMYY
Date the toll occurred
Ticket-time
HHMM (using a 24 hour clock [2pm = 1400))
Time the toll occurred
Description
30 characters
A description of the toll road or bridge from the file TOLLS.txt


III. TRANSMITTING THE FILE FROM A PC TO THE CARS+ SERVER

Create the spreadsheet on a PC or computer that is also used to access CARS+. Once the spreadsheet is done, save it in the csv format. Then on the same computer, sign into and access CARS+. Go to the Batch Ticket Processing Report program and 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".


IV. RUNNING THE PROGRAM


To access this program: To access the Convert ADF File program, type CNVADF (RET) at any menu "OPTION:" field or the appropriate line number on the Hertz Australia Sub-Menu of the Hertz Brand Menu. The screen will then display:

OPTION: ____ ADF FILE CONVERSION

1 ADF Filename






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

Enter data as follows:

1. ADF FILENAME

Enter the name of the ascii comma delimited file containing the toll data.


Press F1 to begin processing the records.