Upload / import a vehicle list

Some vehicle types will require additional details to be entered including:

• VIN (required field for all imports)
• Registration number
• Registration state
• GVM (t)
• GTM (t)
• GCM (t)

 If you have a fleet of vehicles, you may wish to use the upload / import function to save time.

Import from within Vehicle Configurations 

1. Navigate to Access Permits> Vehicle Configurations.
2. All saved vehicle configurations for the active account will be listed.
3. Scroll through the list or use the drop-down filters to find the vehicle configuration required.
4. Select the required vehicle.
5. On the configuration screen, navigate to a component tab (to the right of the Overall tab).
   
6. Select Import from CSV File (only visible if it is mandatory for the selected vehicle to have additional information such as registration).
7. Select CSV file from your folders. Click Open to import into Portal.
8. Click Save.

9. A list of all vehicle components attached to your account will appear under Vehicle List.
   

Create a CSV File to Import 

1. Select Download Import Template.

2. Add vehicle details.

   • If any data starts with zero, use a single quote before the zero - eg. '007LHT. This will stop excel automatically changing the format.
   • The VIN field must contain data, if left blank the entire row of data will be skipped on import.
   • For ease of use, create a new vehicle list for each component being imported.
3. Delete sample data.
4. Save file as.csv.
5. Select Import from CSV File (only visible if it is mandatory for the selected vehicle to have additional information such as registration).
6. Select CSV file from your folders. Click Open to import into Portal.

7. Click Save to save your template in the NHVR Portal.

   Importing Rules

   When you import a new CSV file, the existing vehicle information will be cleared to avoid duplication.
   The NHVR Portal will automatically select and import only the required data:
   ~ Data in the GVM(t), GTM(t), GCM(t) fields will only be imported if it is a required field for that vehicle component type. 
   ~ Data in the Component type/ Add or remove fields will only be imported for Amend application types.

8. A list of all vehicle components attached to your account will appear under Vehicle List.