Skip to content

Extract data from Excel files #28

@KirilMT

Description

@KirilMT

Category: Database and Data Management

Sub-tasks:

  • When adding a new task from Excel, ensure the ability to define required technologies/skills before assignment to avoid tasks appearing as "has no required technology defined."
  • Add an option to import task names from an Excel file, compare with the current database, show differences, and allow actions like add (if new), edit, or delete (if not in the new list but exists in the database).
  • Integrate "Planning Notes" column data from Excel into the dashboard table by combining it with another relevant column (e.g., lines) into a single column.
  • Update the total task list by extracting data from an external system as an Excel file, comparing it with database data, and adding new tasks or removing deleted ones (including updating assignments and reordering priorities).

Metadata

Metadata

Assignees

No one assigned

    Labels

    P1-HighHigh priority issue

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions