My first attempt at migrating a Microsoft Planner plan to a Jira project was a really frustrating experience. It took several hours and required a lot of manual editing of the CSV exported from Planner. We have dozens of projects, so this will not scale. I'm looking for help or suggestions on how to automate this as much as possible, given the following hierarchy:
Plan -> Project
Bucket -> Epic
Task -> Story
Checklist item -> Subtask
Task Name -> Summary
The rest of the mappings are pretty obvious. I am not a developer. If there are PowerShell scripts available for preparing the CSV for import, I can adapt and implement them. But I am not proficient enough to write them from scratch.
Here are the problems I am having:
- I couldn't figure out how to import all these tasks at once and create epics from the values in the 'bucket' column. I had to create another spreadsheet containing the bucket names to build the epics and import that first. Then I did a second import job to import the planner CSV, mapping the bucket column as the epic link.
- Subtasks are grouped together in a single column separated by semicolons. I had to export them to another CSV, and then manually map them to a Parent ID, which I had to manually create for each subtask. This took hours, as there were over 100 subtasks in the plan.
I'm grateful for any feedback or suggestions.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events