Import from CSV/XLSX

The Import from CSV/XLSX feature allows you to import fuel fillings and drivers in bulk from CSV and XLSX files into the system.

The import process consists of the following steps:

• uploading the required file;
• preparing a table with data to be imported;
• adding a template (optional);
• completing the import and checking the results.

Read more about each step below.

Uploading the file

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

Depending on the type of items you want to import, the file table must have at least two in case of drivers or four columns fuel fillings. Mandatory columns are marked with an asterisk in the sections Driver import table, Fuel filling import table.

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

1. In the user menu, select Import/Export and then select Import from CSV/XLSX.
2. Click on the Browse button and select the file you want to upload.
3. Click Upload.
4. Select the date and time format used in the file.
5. For a CSV file, specify the separator: comma, semicolon, colon, or tab.
6. Click Next.

The data from the file is then shown as a table which you should prepare for import.

Preparing the table for import

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

1. Select the type of items you want to import: units, drivers or fuel fillings.
2. 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 sections Unit import table, Driver import table, Fuel filling import table.

3. If necessary, delete the first line and other unnecessary lines. To do this, point to the line and click on the icon X at the end of the line.
4. 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.
5. If necessary, save the template so that you can immediately apply the same column order the next time you import data.

Driver import table

Fuel filling import table

In the table for importing fuel fillings, you can select up to 6 columns. 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 (*).

Searching and filtering data

You can search the data in the table and filter it by validity.

To find a specific item in the table, use the dynamic search. You can search for units and drivers by name, and for fuel fillings by unit name. If the Unit name or Driver name columns are not selected in the table, the search is not available.

To the left of the search bar, there is a filter that allows you to choose which rows you want to see in the table: all, valid, or invalid. By default, all rows are shown. To the right of the All option, you can see the total number of rows in the table.

If a number other than zero is shown in brackets to the right of the Invalid option, select this option and edit the found rows. Otherwise, they will not be imported.

Editing data

Cells with invalid data are highlighted in red color in the table. It is impossible to import items with such cells.

You can correct invalid data as follows:

1. Click on a red cell.

2. Read the tooltip to find out why the error occurred.

3. Enter the correct data.

4. Click outside the cell to save the changes.

Adding a template

Once you have selected the column headings, you can add a template, that is, save the order of the table columns. This is not a mandatory step, but it will save you time during your next import. Instead of selecting column headings manually, you will be able to select the template and the saved column order will be automatically applied to the table.

To add the template, follow the steps below.

1. Click Add.

2. Specify the template name (max. 50 characters).

3. Click Save.

The added template is shown in the list of templates.

To delete a template, hover over its name in the list and click on the icon X

Completing the import and checking the results

To complete the import, click ОК.

Importing a large number of items may take some time.

If the import of at least one item 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.

You can see the imported drivers on the Drivers tab of the monitoring system.

To see the imported fuel fillings, run a report with the Fuel fillings and battery charges table for the required time period. You can see the Cost column only in the Utilization cost table.

Updated on: 17/03/2025