roos-fs tasks #126
openCreate Data Import functionalities
0%
Description
General
In order to start working wth the system a big chunk of data needs to be imported into the system. Since multiple vechicles could be imported it is wished that there would be a UI for this.
The data for te customers seoperately with the vechicles is to be imported.
User stories (1)
- As an admin user, I want to import multiple vehicle records via a user interface, so that I can efficiently populate the system with vehicle data from external sources.
Acceptance Criteria:
- A UI exists where the user can upload a file (e.g., CSV or Excel) containing vehicle data.
- The imported file should support fields shown in the screenshot, including:
ID
VIN
License Plate
Manufacturer
Model
Model Year
First Registration Date
LP Reference
Location
Customer
Vehicle Category (truncated in screenshot but implied)
The system validates the file before processing:
- Missing required fields are flagged.
- Duplicates are identified.
- Malformed data (e.g., invalid date format, non-unique VIN) is rejected with an error.
- A preview screen is shown before final import with rows that can be accepted/rejected individually.
- Upon confirmation, data is stored and becomes searchable in the vehicle management module.
- Errors are logged and reported to the user after import.
User stories (2)
As an admin user,I want to import customer records separately via a user interface, so that customer data can be managed independently of vehicles.
Acceptance Criteria:
-
A UI exists where the user can upload a file (CSV) containing customer data.
-
The imported file must support at least the fields:
ID
Name -
The system validates data before processing (e.g., duplicate IDs, empty names).
-
A preview screen is shown before final import.
-
Upon confirmation, customers are stored in the customer management module and available for linking to vehicles.
-
Errors are logged and shown to the user after import.
User stories (3)
As an admin user,I want to import vechicle uisers separately via a user interface, so that vechicle user data can be managed.
-
A UI exists where the user can upload a file (CSV) containing vechicle user data.
-
The imported file must support at least the fields:
ID
Name -
The system validates data before processing (e.g., duplicate IDs, empty names).
-
A preview screen is shown before final import.
-
Upon confirmation, vechicle users are stored in the vechicle users management module and available for linking to vehicles.
-
Errors are logged and shown to the user after import.
Files
Updated by Vadim Pariev 11 months ago
- Assignee set to Alex Katasonov
- Estimated time set to 8:00 h
Updated by Vadim Pariev 11 months ago
- Mate cueb is to create an excel sheet as an example one for the uipload functionalities
Updated by Vadim Pariev 11 months ago
3 imports customer, vechicles, vechickle users
Updated by Vadim Pariev 11 months ago
- Estimated time changed from 8:00 h to 12:00 h
Updated by Alex Katasonov 11 months ago
- Status changed from Open to In progress
Updated by Alex Katasonov 11 months ago
- Status changed from In progress to In review
Updated by Alex Katasonov 11 months ago
- Status changed from In review to Deployed (QA)
Updated by Vadim Pariev 11 months ago
- File TEST UPLOAD.xlsx TEST UPLOAD.xlsx added
- File clipboard-202506210329-ixwsi.png clipboard-202506210329-ixwsi.png added
Test result not OK
Customer import
- I can not import a user since the validation revents me from doing that

Vechicle user import
test result OK
Vechicle import
Test result OK
Updated by Vadim Pariev 11 months ago
- Status changed from Deployed (QA) to Open
Updated by Alex Katasonov 11 months ago
- Status changed from Open to In progress
Updated by Alex Katasonov 11 months ago
- Status changed from In progress to Deployed (QA)
Updated by Alex Katasonov 10 months ago
- Status changed from Deployed (QA) to Closed