Differences

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

--- nomenclatures:vehicles:import_vehicles [2022/09/26 15:25] – 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.** \\
 **Upload the completed file.** \\
 Select and load the completed file in Kopilot.
-  * "Choose file" to load the completed file in Kopilot and to create users;
+  * "Choose file" to load the completed file in Kopilot and to create the vehicles;
-  * "Import users" to receive confirmation of their addition.
+  * "Import vehicles" to receive confirmation of their addition.
-{{ :nomenclatoare:utilizatori:import_users_3.png |}}
+{{ :nomenclatures:vehicles:vehicles_import2.png |}}
-**Step 4.** \\
+**Pas 4.** \\
-**Verify in the received csv file if all users have been created successfully.**\\
+**Check the import status in Job Status column and if all vehicles have been created successfully.**\\
-If the users have not been 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.
-:!: It is recommended to use csv file import, when the dispatcher has several users to add and does not want to manually add each one separately or by generating several association codes simultaneously.
+:!: 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