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!!
Discussion posts and replies are publicly visible
Exactly what were you hoping to achieve by consuming an MPP file?
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.
So the approach I would take here would be a two-step one:
A quick trawl of the Internet found at least one utility that can convert .mpp files to either xml or json.
Thank you Stewart!
...parting shot - it seems Microsoft Project can natively export to other file types such as Excel, CSV and XML. This should give you plenty of options to roll forwards with a design.
Thanks, yes agreed! We will need to evaluate how we can automate as much as possible to convert these files given the individual number of files and frequency, but at least there is a path forward. To start, may convert to Excel/CSV and then work from there. Thanks again!