Create old sprints and be able to see their commitments.

[Leonard Pooch]

Hi, for some reasons, including getting closer to the agile/scrum methodology and allow PMs and Scrum masters to have a global view over our projects, we are currently doing some tests in order to perform a migration from our Redmine instance (dozens of projects, ten of thousands of issues, nearly ten years of work) to a whole new Jira one.

We are testing differents configurations with a few of our projects and it seems to work like we had expected to, but as our projects are quite old and far away ahead the first version, we have a substantial bunch of sprints that we would like to recreate in Jira.

Let's consider a project (current sprint 28), if i create, process and close a sprint, the result i get is the one i expected, no problem on that sprint or any other that was created and started after the import.

However, with my older sprints (1-27), i ain't got the expected result, the commitment "pilar" of my velocity chart for any of the old sprints is 0, the sprint report having marked all my issues with a star and it is said in the burndown chart that the issues were added to sprint after the actual start. If i take a closer look at the dates, here is the problem, the sprint has started (a date last year) before the issues were imported (this week, but their original dates were kept during the import) and added to it.

So i need to figure out if i can either : change the date an issue was added to a sprint, modify the sprint history or do anything else.

I know that many will say not to touch to the database but if it can solve my needs, so be it.

I also have to say that i already took a look at the db and the schema and it's so incomprehensible and almost black magic that i cannot find myself how issues and sprints are connected together so i someone can explain this relationship.

Thanks, Léonard