The challenge
Microsoft Project Online was shutting down on 30 September 2026, and the client's revenue planning data lived there. The first phase was approved at 66 hours and scheduled as twelve working days.
What we built
We started from our timesheet platform for the same client and adapted it into a separate product. All 265 projects were archived into a verified archive, and new plan, finance and currency tables were defined in Dataverse, Microsoft's business data platform.
A verification step reads Dataverse back and compares it with what was loaded, down to the second. Projects are keyed on an identifier stored in each Microsoft Project file, so a later sync cannot duplicate tasks loaded from Project Online.
Outcome
All 265 projects archived, and 7 projects with 10,671 tasks loaded into a staging environment. The production load, a reconciliation against the finance workbook's totals, and the add-in's revenue logic and web parts are still to do.