search

Leantime / leantime

Leantime is a goals focused project management system for non-project managers. Building with ADHD, Autism, and dyslexia in mind.
https://leantime.io
GNU Affero General Public License v3.0
4.34k stars 573 forks source link

[FEATURE] Import of To-Dos from csv or xls would be helpful while migrating from a manual excel sheets. #767

Closed javaindian closed 5 months ago

javaindian commented 2 years ago

Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like A clear and concise description of what you want to happen.

Additional context Add any other context or screenshots about the feature request here.

marcelfolaron commented 2 years ago

Thanks. Would you mind sharing some more details, or anwering questions:

  1. What do you want to import? To-Dos? Projects? Ideas? Timesheets? Lean Canvas?
  2. If you import todos over multiple projects, how would you want to map that in the CSV? Project Name or is project id okay?
  3. Do you need to map milestones? Or subtasks? Eg any type of hierarchical relationship between To-Dos?
  4. How would you want to map users? All to one user? Map by email address? Map by name?

There are probably more questions :D but this could get me started.

javaindian commented 2 years ago

Sorry for the delayed response @marcelfolaron. Initially, I would like to go with import of ToDos of a single project with Project Name being primary key.

TareqK commented 2 years ago

@javaindian For what its worth, when we did this(from jira to leantime), all we did was import the CSV into MYSQL directly by renaming the headers, setting the ticket statuses and types using the Ids in the db, and adding a projectId column.

But I 2nd the need for an Import

javaindian commented 2 years ago

@javaindian For what its worth, when we did this(from jira to leantime), all we did was import the CSV into MYSQL directly by renaming the headers, setting the ticket statuses and types using the Ids in the db, and adding a projectId column.

But I 2nd the need for an Import

Diff between Geeks and Nerds ;) Sadly, I have zero knowledge in DBA.

Anyways thanks for the pointer.

gloriafolaron commented 1 year ago

@TareqK @marcelfolaron is this the same thing in the threads yesterday in discord -- for CSV imports of tasks for repeating?

marcelfolaron commented 5 months ago

CSV Import was introduced a few versions ago. Closing this issue