Download Spreadsheet Manual - Motor Data Solutions

Contents
Contents ...................................................................................................................................................2
1
Introduction......................................................................................................................................3
2
Gaining Access ...............................................................................................................................4
2.1 Method ........................................................................................................................................4
2.2 Downloading a template .............................................................................................................4
3
Process............................................................................................................................................5
3.1 Introduction .................................................................................................................................5
3.2 Steps ...........................................................................................................................................5
3.3 Messages you may receive ........................................................................................................7
4
Format for Vehicle Data Uploads ....................................................................................................8
4.1 Overview .....................................................................................................................................8
4.2 Commonly Asked Questions.......................................................................................................8
4.3 Record Format ..........................................................................................................................10
4.4 Valid VRN formats.....................................................................................................................10
4.5 Valid Vehicle Types ..................................................................................................................10
4.6 Make and Model validation .......................................................................................................11
4.7 Validation of Engine Size, Derivative and Seats.......................................................................11
4.8 Gross Laden Weight (GVW) Validation ....................................................................................11
4.9 Cover On and Cover Off ...........................................................................................................11
4.10
FRI (Foreign Registration Indicator) .....................................................................................11
4.11
File Format............................................................................................................................12
4.12
Multiple Policyholders / Multiple Policies ..............................................................................12
4.13
Change of VRM ....................................................................................................................12