Smart VIN number conversion

Batch conversion VIN - FIN

A batch program has been created to convert the MCC VIN numbers to MCC FIN numbers. All tables in Autoline in which e.g. the Vehicle Marketing records and so on are stored, are searched and if a VIN number is found it is converted to a FIN number and the record is saved again.

Module	Table	Description
Marketing	vehic	Vehicle record
	dinvs	Dealer invoices
	vregn	Vehicle Registration details
Manufacturer Systems	vegah	Vega claim header
	vregn	Vehicle Registration details
	apveh	Vehicle Appraisal
	rtsra	Labour rate differentation
	vsgfg	VSB export to GFG
Point of Sale	dordh	Dealer Order Headers
	headr	WIP header details
	loghd	Log file WIP header details
Showroom	partx	Part exchange details
Vehicle Stockbook	newst	New vehicle stock
	newar	New Vehicle Archive
	usdst	Used Vehicle Stock
	usdar	Used Vehicle Archive
	recpt	Receipted Vehicles

To access the Batch Conversion program, you must:

Select from the Main menu the Manufacturer Systems option, combined with company MB.
Select from the Mercedes-Benz Main menu, the Menu-Service option.
Select from the Mercedes-Benz Service menu the Menu - Standard Files option.
Select from the Mercedes-Benz Standard files menu the Convert MCC VIN numbers option.
The Convert MCC VIN numbers form is displayed.

If the program is entered it searches what live companies are set up on the system for every module and subsequently a check is made whether the applicable Autoline table exists.

The shadow files on the system, which are a kind of system back up are converted as well. These shadow files can be recognised by the '*.sh' extention, also is the line in the grid for these files greyed out.

Note: Since not all tables have to exist on a system and the table on the previous page contains all files (until now) that contain the chassis number, it is possible that one or more Autoline tables do not appear in the conversion grid.

If the table contains more than one record, the table is automatically select for conversion in the grid. It is possible to manually exclude a file for conversion by ticking off the Convert column for that line.

To start the conversion, select the Convert button.

During the conversion the program will keep the user informed of the progress of the conversion.

After the conversion has finished, a message is given.

During the conversion a log file is created, which gives information on the numbers of converted records. To view the log file, select the View log file button.