Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Migrating from Microsoft Planner

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.

0 answers

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

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! ...

100 views 1 10
Read article

Community Events

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

Events near you