The mapping feature is used if there is a CSV file already prepared for import, but it doesn’t match the required format in terms of column headings, etc. This allows you to create a one-time mapping that can be selected and re-used for convenience.
Task Mapping
To map your Task imports, navigate to Tasks ⇒ Import ⇒ Mapping.
Importing through CSV
Importing can be done by clicking Select CSV file, which, when added, will then show all the column names from the file on the left and the fields you can match values with on the right side. The CSV file does not need to contain any data, just the headers are enough.
Once the CSV has been imported, you will notice 3 fields:
Imported columns - These are the column headers from your CSV file.
Columns to map - Field names in eLogii. Here, you can choose which fields to map the columns to.
Default values - In this field, you can specify a default value for the selected field, which will be automatically populated each time a CSV file containing that field is imported.
Mapping fields manually
Users can also create new fields manually without importing a CSV file with header names, or add missing fields that are not included in the original CSV file.
To do this, click the + Add column button to create a new field that can then be configured and used as needed.
Users can add as many fields as they want.
Saving the Mapping preset
After all the columns have been assigned, write a name for your mapping preset and select Save mapping.
When importing files in the future, there is the option of choosing between importing regularly or using the mapping previously created.
Driver Mapping
To map your Driver imports, navigate to Drivers ⇒ Import ⇒ Mapping and upload a CSV file you wish to base your mapping on.
The interface is identical to the one showcased in the Task mapping section.
Once you're satisfied with your mapping, write a name for your mapping configuration and select Save mapping.
Vehicle Mapping
Mapping Vehicle imports can be done in Vehicles ⇒ Import ⇒ Mapping.
The interface is identical to the one showcased in the Task mapping section.
Before you save your mapping, make sure to title it and select Save mapping.
Mapping custom data fields
To map custom data fields to the correct CSV columns for any of the entities above, select the customData field in the Columns to map section and specify it using the format:
customData.<Custom Field Name>
For example, if you have a custom field named Additional information, the corresponding mapping field would be:
customData.Additional information
It is important that the <Custom Field Name> matches the original field name in eLogii exactly, including capitalization, spaces, numbers, and any special characters.
Locating, Editing and Deleting Mapping Presets
All saved mapping presets can be found at the top of the Mapping section during entity import. Under Saved mappings, you can view and access all previously saved mapping presets.
To review a mapping without making any changes, click the Show button to display how the data points are connected. A pop-up will appear, showing the current mapping configuration and how the data has been mapped.
Deleting the preset can be done by clicking the Remove button. This will completely delete the preset from your account.
To make changes to the preset, click the Edit button and you will be able to edit the preset.
Once you're done editing you can either Update the existing preset (the one you were editing), or Save as new (the original preset you were editing will be unaffected).