Use this program to:

• Add new Model Codes records to the Model Codes file from data entered on an Excel spreadsheet.
• Update data on existing Model Codes records from data entered on an Excel spreadsheet.

I. CREATING THE SPREADSHEET

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

Click here to download a template file with the header row already completed.

B. Entering data in the spreadsheet

Although the link above provides a template, the columns for the spreadsheet do not need to be in any particular order, and all columns need not be present. For your own purposes, the spreadsheet can contain additional columns unknown to CARS+. What is required is that the columns that contain data to be merged MUST have the column header specified in the chart shown at the end of this chapter.

• Create a row for each Model Code record that should be imported or updated.
• Enter the data to be added or changed in the appropriate column(s). User tip for updates: Note that the data in the required fields cannot be changed via this program. In order to change other fields (fields not required) in the model code, the data in the required fields must be identical to the existing data in the model code record. (Also see the "User Tip" below regarding the date format.)
• A blank field in the spreadsheet will cause the corresponding field in CARS+ to be cleared. This means that when entering a record into the spreadsheet, the complete record needs to be entered, not just the fields that are being changed.

User tip: Date format can be either:

YYYYMMDD (Example: 20150927 for September 27, 2015)

The local date format of either: MM-DD-YY or DD-MM-YY (This is specified in Edit Misc Control Record.)

C. Naming the spreadsheet file.

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

• Maximum of 10 characters for example 20150930DC.csv for September 30, 2015, and MC for (M)odel (C)ode
• 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. The first row of column headers must be included.

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 Model Codes program, type IMPMDL (RET) at any menu "OPTION:" field or the appropriate line number on the Import Data sub-menu of the System Management 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 will then display:

OPTION: __ IMPORT MODEL CODES 1 Filename NOTE: DATE FORMATS HAVE CHANGED. ACCEPTABLE FORMATS ARE: MM-DD-YY YYYYMMDD 1DO IMPORT2 3ERASE 4UPLOAD 5BACKUP 6 7HELP 8

Enter data as follows:

1.FILE NAME

The file can be loaded for processing by either: a. typing the file name in this field - or b. searching for it. To search, press F6 from this field. A search window will appear on the lower half of the screen. An example is shown below. Select the appropriate file by typing the row number.

OPTION: __ IMPORT MODEL CODES 1. Filename Option: _ MODEL CODES FILE SEARCH F2=NEXT 8 F4=PREV 8 File Name Create Date 1 model-101112.csv Oct 11 12:00 2 model-100312.csv Oct 3 14:20 ** No More Records **

Press F1 to begin the import process.


A table listing the required column headers of the data in the spreadsheet is shown below.

Required Column Header	Field in EDITMDL	Notes
Mdl_code	Model	Required
Mdl_year	Year	Required
Mdl_class	Class	Required
Mdl_price_code	Pricing Code	Required
Mdl_post_code	Posting Code	Required
Mdl_desc	Description	Required
Mdl_tank_1	1st tank size	Required Unless fuel type "N" is used for trailers and any other rentable device that does not charge for fuel (fuel calculation is made inactive)
Mdl_est_mpg	EST MPG	Required Unless fuel type "N" is used for trailers and any other rentable device that does not charge for fuel (fuel calculation is made inactive)
Mdl_make	Make	Required
Mdl_graphic	Car Graphic
Mdl_Foreign	Foreign Mdl
Mdl_tank_2	2nd tank size
Mdl_doors	Doors
Mdl_group	Group
Mdl_eng_size	Eng Size
Mdl_surcharge	Surcharge
Mdl_type	Type
Mdl_vin_lst_8	Vin 1st 8
Mdl_options	Options
Mdl_fuel_type	Fuel Type
Mdl_svc_flags	Service Flags
Mdl_repl_cost	Replacement Cost
Mdl_tax_code	Tax Code
Mdl_phone_inc	Phone Incl
Mdl_annual_fee	Annual Fee
Mdl_fuel_code	Fuel Code
Mdl_fuel_rate	Fuel Card Rate
Mdl_mdl_option	Model Option
Mdl_mdl_opt_chg	Charge Option
Mdl_alt_mdl	Alt. Mdl
Mdl_warranty	RSA Warranty
Mdl_dmg_type	Damage Type
Mdl_inv_option	Inv Option
Mdl_inv_opt_chg	Inv Opt Chg
Mdl_alt_mdl2	Alt. Model2
Mdl_gnd_odom	Ground Odom
Mdl_carb_p_ml	Carbon/Km
Mdl_gnd_days	Grounding Days
Mdl_weight	Gross Weight
Mdl_ex_cdpid	Exempt CDPID
Mdl_ex_inc_rate	Exempt Incl Rates
Mdl_ex_voucher	Exempt Vouchers
Mdl_ex_1way	Exempt 1 Way
Mdl_blk_1way	Block 1 Way Close
Mdl_blk_exch	Block Exchange
Mdl_mgr_open	Req Manager Open
Mdl_mgr_close	Req Manager Close