How would you extract data from a MS Project .mpp file?

Question

I need to extract data from a .mpp file on the network and combine it with other data from several different databases. The application can be written in Perl, VB6, VB.net or C# but must be easily scheduled from a Windows based server.

What would you recommend to extract the MS Project data with no user intervention?

Is there any ODBC drivers available for MS Project?

Are there any modules (for Perl, VB, VB.net or C#) for opening a .mpp and reading activity data?

Answer 1

MPP does have its own object model that can be used to access data in it. The info should be available here: http://msdn.microsoft.com/en-us/office/aa905469.aspx

Answer 2

I would recommend using MPXJ (mpxj.sf.net) to extract data from Microsoft Project files. Don't be put off by the fact that it was originally a Java library - the current release of MPXJ includes native .net dlls as well as the original Java JAR file, thanks to the magic of IKVM.

Disclaimer: I maintain MPXJ.

Answer 3

I have the same need. Here is what I found so far. There is an OLEDB provider for microsoft projects, up to version MP 2007. If Google it, there are enough sites quoting the connection string, but here is the one quote: oConn.Open "Provider=Microsoft.Project.OLEDB.9.0;" & _ "Project Name=c:\somepath\myProject.mpp"

The problem with this approach seems to be that you have to install MS Project on the server. It is nuisance in any case, and an impossibility for me using hosting environtment.

So you are down to parsing .mpp. MPXJ is an excellent library as one commenter above suggests, and I can afford to wait, so I am waiting for them to release .NET version. If you are resolved to get it done, get the code and see what they are doing. Other then in their source code/comments there is no (to my knowledge) documentation of the format.

Answer 4

Can somebody please post a sample in C# so that I can start at least?... I am trying to make a MPP viewer in C#

        ProjectReader objReader = ProjectReaderUtility.getProjectReader(@"C:\BVContentMigrationRev2.mpp");
        ProjectFile objProject = objReader.read(@"C:\BVContentMigrationRev2.mpp");
        List<Task> tasks = (List<Task>)objProject.getAllTasks();

I did this an am stuck.... Jon Iles, Sir I think you can help...

Thanks!

Answer 5

Hi,

Hope the following helps...

http://www.codeproject.com/KB/cs/PrjXlsRpt.aspx

Rgds