Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

An importing tool for uploading vehicle details/ registrations for multiple vehicles. 

Step-by-step

When you navigate from either Vehicle Configurations/ Permit Applications or Permit Actions (Amend), some Some vehicle types will require additional details to be entered . If you have a fleet of vehicles, you may wish to use the upload/ import function to save time in entering this data.When you import any of the following vehicle data into the Portalincluding:

  • VIN (required field for all imports)       
  • Registration number     number
  • Registration state           state
  • GVM (t)              
  • GTM (t)
  • GCM (t)
Note
titleImport feature
The Import button

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

Tip

The Import from CSV File button will only appear when the vehicle registration details are required/ mandatory fields.

Importing

Import from within Vehicle

configurationsIn Vehicle Configurations, click on the vehicle tab Image Removed.
Image Removed
If

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).
    Image Added
  6. Select Import from CSV File (only visible if it is mandatory for the selected vehicle to have additional information such as registration, the Import from CSV File button will display Image Removed
    Image Removed
    You can download the Excel (xls) import template from the Download Import Template link Image Removed and add your vehicle details Image Removed. Be sure to delete the sample data and then save the file onto your computer.
    Image Removed
    Review the template instructions, which are:
    TIPS FOR USING THIS TEMPLATE:).
  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.
    Image Added

Create a CSV File to Import 

  1. Select Download Import Template.
  2. Add vehicle details.

    Tip
    • 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.
    -----------------------------------------
    IMPORTING RULES: 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.

    Warning
    titleImporting 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.

     

    Once vehicle details are added and saved into the template, import the template into to the Portal via the Import from CSV File button Image Removed.  This will open a window in your system, select the template Image Removed and click Open to import into the Portal.. 

    Image Removed
    Image Removed

    Once the template is imported into the portal, a list of all vehicles attached to your account appears allowing you to view vehicle configurations and components Image Removed

    Image Removed
    note


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

Image Added


Warning
titleValidation of
vehicle data
Vehicle Data

When you upload your vehicle list under Vehicle Configurations, there will be no validation of vehicle details until you use those configurations in a permit application

.Select save to save your template in the portal Image Removed, a green box will appear advising you that the import was successful

.

 Image Removed