Migrate Planner to Project?

%3CLINGO-SUB%20id%3D%22lingo-sub-824834%22%20slang%3D%22en-US%22%3EMigrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824834%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20client%20that%20is%20heavily%20embedded%20in%20Planner%20and%20would%20like%20to%20Migrate%20this%20data%20to%20Project.%26nbsp%3B%20Client%20is%20on%20Office%20365%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824854%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824854%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3ENo%2C%20it%E2%80%99s%20not%20possible%20at%20this%20time!%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99d%20suggest%20voting%20for%20this%20on%20planner%20uservoice!%20There%E2%80%99s%20a%20few!%20This%20one%20for%20example%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F17310622-could-planner-have-the-ability-to-export-tasks-to%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fplanner.uservoice.com%2Fforums%2F330525-microsoft-planner-feedback-forum%2Fsuggestions%2F17310622-could-planner-have-the-ability-to-export-tasks-to%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824874%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThank%20you%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825162%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825162%22%20slang%3D%22en-US%22%3EWell%2C%20Project%20online%20has%20an%20API%2C%20for%20Planner%20you%20have%20the%20Microsoft%20Graph%20API%20so%20I%20wouldn't%20say%20it's%20not%20possible%20because%20you%20could%20end%20developing%20a%20migration%20project%20to%20migrate%20your%20planner%20data%20to%20Tasks%20in%20Projects%20in%20Project%20Online...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825255%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825255%22%20slang%3D%22en-US%22%3EWell%2C%20%E2%80%9Cnot%20possible%E2%80%9D%20is%20a%20strong%20word%20(or%20two)%20I%20should%20say%20there%E2%80%99s%20no%20such%20integration%20out%20of%20the%20box%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826024%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826024%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20has%20been%20stated%20there%20is%20no%20integration%20out%20of%20the%20box%2C%20and%20it%20would%20be%20difficult%20to%20do%20completely%20because%20not%20all%20of%20the%20fields%20in%20Planner%20map%20to%20Project%20anyway%3B%20specifically%20for%20scheduling%20Project%20needs%20start%2Ffinish%20dates%20which%20could%20relate%20to%20Start%20and%20Due%20date%20in%20Planner.%20%26nbsp%3B%20Planner%20has%20no%20concept%20of%20dependencies%20either%2C%20so%20again%20this%20would%20be%20%22problematic%22%20to%20say%20the%20least.%26nbsp%3B%20I%20think%20the%20best%20option%20would%20be%20just%20to%20export%20the%20planner%20plan%20to%20Excel%2C%20and%20then%20copy%20and%20paste%20the%20task%20names%20into%20Project%2C%20along%20with%20the%20start%20date%20if%20you%20have%20it.%26nbsp%3B%20If%20you%20are%20using%20resources%2C%20these%20will%20need%20to%20be%20split%20out%20(but%20see%20my%20blog%20here%20on%20how%20to%20do%20this%20in%20Power%20BI%20-%20the%20same%20theory%20applies%20to%20Excel%20%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fapplepark.co.uk%2Fpowerbi-planner-template%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapplepark.co.uk%2Fpowerbi-planner-template%2F%3C%2FA%3E%3C%2FFONT%3E)%20.%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%2C%20there%20is%20going%20to%20be%20a%20lot%20of%20manual%20work%20required%20to%20take%20a%20planner%20plan%20(effectively%20a%20nice%20task%20list)%20and%20craft%20it%20into%20a%20meaningful%20resource%20loaded%20and%20levelled%20schedule.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833134%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F302823%22%20target%3D%22_blank%22%3E%40ben_project%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20nice%20if%20we%20could%20the%20same%20possiblity%20as%20with%20Trello%20and%20TeamGantt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftrello.com%2Fpower-ups%2F5970d4298c14fdf691c95a76%2Fteamgantt%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrello.com%2Fpower-ups%2F5970d4298c14fdf691c95a76%2Fteamgantt%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833143%22%20slang%3D%22en-US%22%3ERe%3A%20Migrate%20Planner%20to%20Project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833143%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F146742%22%20target%3D%22_blank%22%3E%40Arve%20Gruehagen%3C%2FA%3E-%20I%20believe%20the%20authentication%20Trello%20requires%20makes%20a%20PowerBI%20connection%20somewhat%20difficult.oka%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a client that is heavily embedded in Planner and would like to Migrate this data to Project.  Client is on Office 365 

Thanks in advance

7 Replies
Highlighted
Hi!
No, it’s not possible at this time!

I’d suggest voting for this on planner uservoice! There’s a few! This one for example:

https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/17310622-co...

Adam
Highlighted

@adam deltinger   Thank you 

 

Highlighted
Well, Project online has an API, for Planner you have the Microsoft Graph API so I wouldn't say it's not possible because you could end developing a migration project to migrate your planner data to Tasks in Projects in Project Online...
Highlighted
Well, “not possible” is a strong word :) (or two) I should say there’s no such integration out of the box
Highlighted

As has been stated there is no integration out of the box, and it would be difficult to do completely because not all of the fields in Planner map to Project anyway; specifically for scheduling Project needs start/finish dates which could relate to Start and Due date in Planner.   Planner has no concept of dependencies either, so again this would be "problematic" to say the least.  I think the best option would be just to export the planner plan to Excel, and then copy and paste the task names into Project, along with the start date if you have it.  If you are using resources, these will need to be split out (but see my blog here on how to do this in Power BI - the same theory applies to Excel https://applepark.co.uk/powerbi-planner-template/ ) .   

 

Basically, there is going to be a lot of manual work required to take a planner plan (effectively a nice task list) and craft it into a meaningful resource loaded and levelled schedule.

Highlighted

@ben_project 

Would be nice if we could the same possiblity as with Trello and TeamGantt

 

https://trello.com/power-ups/5970d4298c14fdf691c95a76/teamgantt

Highlighted

@Arve Gruehagen- I believe the authentication Trello requires makes a PowerBI connection somewhat difficult.oka