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 #1

Updated by Vadim Pariev 11 months ago

  • Assignee set to Alex Katasonov
  • Estimated time set to 8:00 h
Actions #2

Updated by Vadim Pariev 11 months ago

  • Description updated (diff)
Actions #3

Updated by Vadim Pariev 11 months ago

  • Mate cueb is to create an excel sheet as an example one for the uipload functionalities
Actions #4

Updated by Vadim Pariev 11 months ago

3 imports customer, vechicles, vechickle users

Actions #5

Updated by Vadim Pariev 11 months ago

  • Estimated time changed from 8:00 h to 12:00 h
Actions #6

Updated by Alex Katasonov 11 months ago

  • Status changed from Backlog to Open
Actions #7

Updated by Vadim Pariev 11 months ago

  • Description updated (diff)
Actions #8

Updated by Vadim Pariev 11 months ago

  • Description updated (diff)
Actions #9

Updated by Vadim Pariev 11 months ago

  • Description updated (diff)
Actions #10

Updated by Alex Katasonov 11 months ago

  • Status changed from Open to In progress
Actions #11

Updated by Alex Katasonov 11 months ago

  • Status changed from In progress to In review
Actions #12

Updated by Alex Katasonov 11 months ago

  • Status changed from In review to Deployed (QA)

Updated by Vadim Pariev 11 months ago

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

Actions #14

Updated by Vadim Pariev 11 months ago

  • Status changed from Deployed (QA) to Open
Actions #15

Updated by Alex Katasonov 11 months ago

  • Status changed from Open to In progress
Actions #16

Updated by Alex Katasonov 11 months ago

  • Status changed from In progress to Deployed (QA)
Actions #17

Updated by Alex Katasonov 10 months ago

  • Status changed from Deployed (QA) to Closed
Actions #18

Updated by Albert Katasonov 5 days ago

  • Project changed from 8 to Roos-fs-ZIP
Actions

Also available in: Atom PDF