Open Source Python Code to Export Data from OpenProject to Microsoft Project
The Integer software development team has found a solution for developers and project managers who have struggled to efficiently import data from OpenProject to Microsoft Project.
This is particularly relevant for developers working on government projects with CUI requirements, as there is currently no official export from OP to MS Project. In previous OP versions, a community plugin was available; however, that is no longer compatible with the current version of OP.
The zip file below contains a Python script and ReadMe file to export data from an OpenProject server. This is accomplished by traversing the project hierarchy from the OP API, transforming the data to internal objects, and finally saving an MS Project compatible XML file.
Visit the project:
or download the zipped file:
This is a one-way transfer, we have not yet developed an export method from MS Project back to OP, but would enjoy hearing from the developer community if you have ideas on this.
Many thanks to Nate Klauer and Jay Liu who worked on this project! Nate is a Software Engineering Manager and Jay interned with us earlier this year as part of a mechanical engineering co-op while he completes his degree at Rochester Institute of Technology.
Comments