Project

General

Profile

Actions

roos-fs tasks #126

open

Create Data Import functionalities

Added by Vadim Pariev 11 months ago. Updated 5 days ago.

Status:
Closed
Priority:
Normal
Start date:
06/15/2025
Due date:
% Done:

0%

Estimated time:
12:00 h

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)

  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

TEST UPLOAD.xlsx (8.82 KB) TEST UPLOAD.xlsx Vadim Pariev, 06/21/2025 01:47 AM
clipboard-202506210329-ixwsi.png (120 KB) clipboard-202506210329-ixwsi.png Vadim Pariev, 06/21/2025 01:48 AM
Actions

Also available in: Atom PDF