We help IT Professionals succeed at work.

Project server interface and PHP

Medium Priority
892 Views
Last Modified: 2013-12-13
How do I extract Microsoft Project 2007 data without using languages like asp, .net, C# & I looking for an example in PHP using the PSI (Project Server Interface) to extract for example ActualWorkHours. We currently have a project training class going on and the instructor stated that its a simple connect followed by some sql calls. Is this true? Can you provide an example or point me to one? I have the project 2007 SDK loaded and installed but I am running out of time.
Comment
Watch Question

Author

Commented:
I just started to look at the project 2007 SDK and havent got deep into it yet. I want to provide an open source solution to a Microsoft interface. The code I am writing communicates with several proprietary software products through COM object, ODBC connections ect. My garbage collection routines will then use filters to create reports. A majority of the code is in PHP but I seem to hit a wall supporting all versions of Project so 2007 seem to be the logical starting point. Everything so far runs on Apache I dont want to throw IIS into the mix. I am aware of MPXJ as a possible solution. Is my goal even worth pursuing?

Author

Commented:
Am I asking the right group?
Most Valuable Expert 2011
Author of the Year 2014
Commented:
@sgpinc: click the "request attention" button at the bottom right of the original post and ask a moderator to help you choose the right zones.  You probably want PHP for Windows, and maybe some others.  They can help

Refs (you may have seen already)
http://msdn.microsoft.com/en-us/library/ms457477.aspx
http://msdn.microsoft.com/en-us/library/ms471381.aspx

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Ray_Paseur

Thank you

Author

Commented:
modus_operandi

Thank you for your assistance.
Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Why can't a .NET solution running on IIS be considered open source?  There are lots of open source projects in virtually any language available.

Project Server 2007 isn't the best performing application in it's native languages.  Adding the overhead of COM and a variety of interfaces will make it even slower.

http://thedailywtf.com/Articles/The_Complicator_0x27_s_Gloves.aspx
Commented:
You wrote:
"How do I extract Microsoft Project 2007 data without using languages like asp, .net, C# & I looking for an example in PHP using the PSI (Project Server Interface) to extract for example ActualWorkHours. We currently have a project training class going on and the instructor stated that its a simple connect followed by some sql calls. Is this true? Can you provide an example or point me to one? I have the project 2007 SDK loaded and installed but I am running out of time."

OK. A few problems here. The PSI is a Microsoft Web service API. You'll have a really hard time trying to use this without .NET. Could be done I suppose, but not something for those who aren't sure how to do it. (I believe it's SOAP at its core.)
Also, the PSI is only provided by Project Server 2007, not Project Professional 2007, the thick client software. Are you trying to integrate with Project Server 2007, or the clients?

If you are trying to integrate with PRoject Server 2007, there is a really nice Reporting database, that includes a bunch of denormalized views to extract exactly the data you are referring to. So a SQL connection to that data base will get you what you want. Use your favorite ODBC client to connect to MS SQL Server holding the databases.

If you are trying to extract data from Project Professional 2007, the client, there are some other interfaces that I'm not as familiar with, but there is an Access/SQL-like interface.


Hope this helps...
James Fraser

Commented:
I have no comment. The SDK explains the interfaces described also states the ODBC connections should not be used for writing but not very clear on read only. My question is too generic I will remove it.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.