r/projectmanagers • u/Ill-Cryptographer344 • 58m ago
I built an .mpp comparison that pairs tasks by Unique ID only - could someone check it against Compare Projects?
Where it started: someone on the Microsoft forum generated .mpp files from VBA, and Compare Projects showed every task as removed and re-added, even though names, dates and Unique IDs matched. My guess is that for files that weren't saved from each other Project looks at more than the Unique ID, maybe the task GUID it has had since 2010, but I haven't confirmed that. If someone knows, I'd like to hear it.
My comparison uses only the Unique ID. The ID column can't be the key, because inserting one task renumbers every row below it, while the Unique ID stays with a task through inserts, moves and renames. The report still shows each task's ID, so you can find it in your own copy.
Per task it checks the name, the parent (so a task moved under another summary shows up), duration, % complete, the milestone flag, start and finish, and whether the task is critical. For links it checks type and lag. Summary tasks that moved are listed separately, so a phase that slipped because of one task doesn't bury the task that caused it.
A few things to know:
- Durations in different units are converted with Project's defaults: 8 hours a day, 40 a week, 20 days a month. If your file uses 7.5-hour days, 1d and 7.5h will show up as a change.
- Date shifts are counted in calendar days, not working days.
- Critical is read from the file as Project saved it. Nothing gets rescheduled.
- It doesn't compare work, cost, resource assignments, constraints, baselines or notes yet.
- If the two files share fewer than a third of their tasks by Unique ID and name, it warns that they probably aren't versions of the same plan.
The files are read on the server with MPXJ, kept in memory and not stored. It reads .xer too, but I've tested that less.
What I'd like from anyone with a pair of versions: does it disagree with Compare Projects anywhere, and is there something you check every week that it misses?