Differences

This shows you the differences between two versions of the page.

--- nomenclatures:vehicles:import_vehicles [2022/09/26 15:28] – florentinagurgu
+++ nomenclatures:vehicles:import_vehicles [2022/12/13 10:45] (current) – florentinagurgu
@@ Line 1: / Line 1: @@
 ====== Import vehicles ======
-You can easily add new vehicles using a csv file.
+⇒ You can easily add new vehicles using a XLSX file.\\
-Just download the CSV file template, fill in the vehicle data and upload the completed file.
+Just download the XLSX file template, fill in the vehicle data and upload the completed file.
 **Step 1.** \\
-**Download the import model** from the area marked on the screen with the mention "**from here**".\\
+**Download the import model** from the area marked on the screen with the mention "**format**".\\
+{{ :nomenclatures:vehicles:vehicles_import.png |}}
-{{ :nomenclatoare:utilizatori:import_users.png |}}
 **Step 2.** \\
-**Complete and then save the csv file. ** \\
+**Complete and then save the XLSX file. ** \\
-Choose vehicle features, and attributes:
+Add the registration number, mileage and attributes of the truck: emission class, number of axles, height, width, length, tank size, consumption.
-{{ :nomenclatures:vehicles:import_vehicle.png |}}
+{{ :ro:nomenclatures:vehicles:import_vehicule3.png |}}
-  * reg_number
-  * vin_number
-  * mileage
-  * truck_type
-  * trailer_type
-  * trailers_count
-  * vehicle_number_axles
-  * trailer_number_axles
-  * hybrid
-  * emission_type
-  * height
-  * trailer_height
-  * vehicle_weight
-  * limited_weight
-  * disabled_equipped
-  * passengers
-  * tires_count
-  * commercial
-  * shipped_hazardous_goods
-  * height_above_1st_axle
-  * width
-  * length
-  * weight_per_axle
-  * fuel_tank_capacity
-  * fuel_tank_reserve
-  * median_consumption
-  * median_consumption_multiplier_per_ton
 **Step 3.** \\
@@ Line 46: / Line 19: @@
   * "Choose file" to load the completed file in Kopilot and to create the vehicles;
   * "Import vehicles" to receive confirmation of their addition.
-{{ :nomenclatures:vehicles:vehicle_import_2.png |}}
+{{ :nomenclatures:vehicles:vehicles_import2.png |}}
-**Step 4.** \\
+**Pas 4.** \\
-**Verify in the received csv file if all the vehicles have been created successfully.**\\
+**Check the import status in Job Status column and if all vehicles have been created successfully.**\\
-If they are not created, the "Invalid Data" mention will appear in the Status column and the reason in the Comments!
+  * In **Total Rows** are the no of vehicles from your xlsx file.
+  * **Inserted** displays the number of vehicles created by import.
+  * **Skipped** displays the number of vehicles that could not be created.
+:!: To see the import status for each vehicle, download the response files received in the **Action** column:
+  * {{:ro:nomenclatures:users:descarca_fisier.png|}} download the imported file.
+  * {{:ro:nomenclatures:users:descarca_fisier_sarite.png|}} view the vehicles that were not created and the reason why
+  * {{:ro:nomenclatures:users:descarca_fisier_rezultate.png|}} view the created vehicles
-:!: It is recommended to use csv file import, when the dispatcher has several vehicles since it is easier than to manually add each one.