Importing contacts linked with vehicles

In order to load in the customers and their matching vehicles, please follow below…...

Note

You need to upload the vehicles and customers separately.

The Vehicle file needs to be first, followed by Customer’s file, both files as CSV format. NOT other way around!

Vehicle Import:

Prepare your Vehicle file. Click here to download an example file, listing all fields (in columns) that CarVue can map. You can import large number of information or you can leave some columns blank but you need to have the following compulsory data:

Registration
VIN

You need to make sure that your data has a header row (row1).

Also Date Format must be in your local format (e.g. DD/MM/YYYY), for when you fill in a date for Reg Date, Annual Check Due Date, Service Due Date and Warranty Ends (please note dates are optional imports).

Go to Settings > Import vehicles (or Customers & vehicles > Vehicles > Import Vehicles). Click Select File to upload your CSV file and click Start Import to move onto the next step.
CarVue uses smart matching to help match up the fields, so any we pick up automatically will be indicated with ticks. Use the drop down boxes to map the rest of your fields against CarVue fields and select which columns to import. Any fields you don't want to import simply select on the drop down 'Don't Import'. Ensure you have mapped a field against Registration and VIN (this is required for the import) before you click Save And Continue.
Select your default Odometer Reading - Miles (default) or Kilometers. This will be used across CarVue and can be edited on an individual basis for each contact if you want to change it at a later date. You can also review the field mappings you chose in the stage before at this time. Once you have made your selection move onto the final stage by clicking Save And Continue.
Our Import process will now take a quick look at your data and let you know if there are any issues. If there are, we'll show them to you at this point. Review any rows that are not going to be imported due to invalid data. Click Complete Import to finish the process.

Contact Import:

Prepare your contact file.

Note

In order to match already loaded vehicles with their owners, you need to include the registration of the vehicle in the contact import file.

The rules for file format are the same as for Vehicle file format – it needs to be CSV and the file have to have a header. Click here to download an example file, listing all fields (in columns) that CarVue can map, including the column for registration number. If the vehicle already exists and registration column is mapped, the vehicle and contact will be linked.

Go to Settings > Import contacts (or Customers & vehicles > Customers > Import Contacts). Click Select File to upload your CSV file and click Start Import to move onto the next step.
Ensure you have mapped a field against Last Name (this is required for the import) before you click Save And Continue.
Select the contact's country from the drop-down list and how you would like your contacts to be displayed at key places in CarVue. You can choose either First Name Last Name (Company), or simply Company. This will be used across CarVue and can be edited on an individual basis for each contact if you want to change it at a later date. You can also review the field mappings you chose in the stage before at this time. Once you have made your selection move onto the final stage by clicking Save And Continue.
Our Import process will now take a quick look at your data and let you know if there are any issues. If there are, we'll show them to you at this point. Review any rows that are not going to be imported due to invalid data.

Click Complete Import to finish the process. If you are importing a large amount of data, please note this can take a few minutes to load.