Fleetrun
Hecterra
NimBus
Other apps
Wialon for Android/iOS
Logistics
Wialon Local
Wialon Hosting
WiaTag
Configurator
LeaseControl
en
Contents
Importing vehicles in bulk

You can register several vehicles at once using the Import feature. It allows you to import vehicles in bulk from a CSV or XLSX file.

  Prerequisites

You must have a previously saved CSV or XLSX file with information about vehicles.

The import process consists of the following steps:

Read more about each step below.

Uploading the file

  Prerequisites

The size of the uploaded file must not exceed 64 MB.

The file table must have at least 12 columns. Mandatory columns are marked with an asterisk in the section Vehicle import table.

To upload the file from which you want to import data, follow the steps below:

  1. In the table of customers, click on the row of the customer for whom you want to register the vehicle.

  2. Go to the Vehicle tab. 

  3. Click Import.
  4. Click on the Browse button and select the file you want to upload. 

  5. Click Upload.

  6. For a CSV file, specify the separator: comma, semicolon, colon, or tab.
  7. Click Next.

Preparing the table for import

To prepare the uploaded data for import, follow the instructions below.

  1. Specify the headings of the columns. To do this, you can apply a previously saved template or select headings from the drop-down lists above the columns. Mandatory headings are marked with an asterisk (*). For a description of all available columns, see the section Vehicle import table.

    If no name is selected for a column, its contents are not imported into the system.
  2. If needed, delete the unnecessary lines. To do this, point to the line and click on the icon at the end of the line.

  3. Make sure the table shows valid data. To do this, select Invalid in the filter. If nothing is found by the filter, all rows are valid. If invalid data is found, edit it.

  4. If necessary, save the template so that you can immediately apply the same column order the next time you import data.

 Vehicle import table

In the table for importing units, you can select the columns listed below. Here you can find their description and the requirements that must be met so that the data in these columns is considered valid.

Mandatory columns are marked with an asterisk (*).


Column

Description

Requirements

Vehicle

The name of the vehicle.

The vehicle name must match the name of the unit available to the user.

IMEI number

The IMEI number of the device installed on the vehicle.

The value must consist of 15 to 16 numbers.

Sequence number

The sequence number of the vehicle. It is a serial number, usually consisting of 8 to 9 digits, indicated in the lower-right corner of the vehicle licence card.

The value must contain only numbers and be no more than 100 characters long.

Plate type

The plate type of the vehicle.

The allowed plate types are as follows:

  • Private car;
  • Public transport;
  • Private transport;
  • Public minibus;
  • Private minibus;
  • Taxi;
  • Heavy equipment;
  • Export;
  • Diplomatic;
  • Motorcycle;
  • Temporary.

Vehicle plate number

The number of the vehicle plate. 

As a rule, the vehicle plate consists of a four-digit number followed by the left, middle, and right letters.

In this column, specify only the number of the plate.

The value must contain only numbers and be no more than 100 characters long.

Vehicle plate left letter

The left letter of the vehicle plate.

The value must consist of one letter.

Vehicle plate middle letter

The middle letter of the vehicle plate.

The value must consist of one letter.

Vehicle plate right letter

The right letter of the vehicle plate.

The value must consist of one letter.

Engine sensor

The sensor of the Engine ignition sensor type.

The name of the sensor must match the one specified in the unit properties.

Movement sensor

The sensor of the Real-time motion sensor type.

The name of the sensor must match the one specified in the unit properties.

Power cut-off sensor

The sensor of the Custom digital sensor type used for detecting external power cut-offs.

The name of the sensor must match the one specified in the unit properties.

Crash sensor

The sensor of the Custom digital sensor type used for detecting  traffic accidents.

The name of the sensor must match the one specified in the unit properties.

Weight sensor

The sensor of the Weight sensor type.

The name of the sensor must match the one specified in the unit properties.

Temperature sensor

The sensor of the Temperature sensor type.

The name of the sensor must match the one specified in the unit properties.

Humidity sensor

The sensor of the Custom sensor type used for measuring humidity.

The name of the sensor must match the one specified in the unit properties.

Completing the import and checking the results

To complete the import, click ОК

Importing multiple vehicles may take some time.

If the import of at least one vehicle is successful, the pop-up message Import completed is shown. In the opposite case, you can see the message that the data couldn't be imported. When importing vehicles, this message also contains a file with information about the errors that occurred. You can download it.

As a result of successful import, the vehicle is registered and saved to the table of vehicles. A record of the registration is shown in the log.



If you find a mistake in the text, please select it and press Ctrl+Enter.
Thank you for your feedback!
Report a mistake
Text with the mistake Comment
Maximum 500 characters