Skip to main content
K
kevinl
February 23, 2022
Question

Ability to read and ingest .MPP (Microsoft Project Plan) files into Appian - Multiple .MPP Files

  • February 23, 2022
  • 6 replies
  • 0 views

I searched Appian documentation to see if Appian has any capabilities with directly reading .MPP (Microsoft Project) files (local files) but didn't see any OOTB options.

Has anyone had a use case/solution leveraging (ingesting) data from Microsoft Project?

If not, I assume we would need to extract the Microsoft Project data (multiple files at a given interview)  to excel (or another file format) in order to ingest the data.

Thanks in advance for any help/insights!!

6 replies

stewart.burchell
stewart.burchell
February 23, 2022

Exactly what were you hoping to achieve by consuming an MPP file?

K
kevinlAuthor
February 23, 2022

To obtain the target planned start/end dates for multiple activities/milestones for each project record in our portfolio for awareness & planning.  The project plans would be updated in Microsoft Project on a weekly basis as a given project progresses (i.e. dates will change, etc.).  We would want the latest dates ingested (and then viewable) with each weekly refresh across all projects in the portfolio.

stewart.burchell
stewart.burchell
February 23, 2022

So the approach I would take here would be a two-step one:

  • convert your .mpp file to something more consumable by Appian e.g. an XML or JSON file
  • import the converted file and then use the existing functions to extract the information you're looking for

A quick trawl of the Internet found at least one utility that can convert .mpp files to either xml or json.

Terms & ConditionsAccessibility statement