?
Solved

Project server interface and PHP

Posted on 2009-02-10
10
Medium Priority
?
831 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.
0
Comment
Question by:sgpinc
8 Comments
 

Author Comment

by:sgpinc
ID: 23612507
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?
0
 

Author Comment

by:sgpinc
ID: 23612518
Am I asking the right group?
0
 
LVL 111

Assisted Solution

by:Ray Paseur
Ray Paseur earned 80 total points
ID: 23612944
@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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:sgpinc
ID: 23613012
Ray_Paseur

Thank you
0
 

Author Comment

by:sgpinc
ID: 23613273
modus_operandi

Thank you for your assistance.
0
 
LVL 51

Assisted Solution

by:Ted Bouskill
Ted Bouskill earned 80 total points
ID: 23629429
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
0
 
LVL 13

Assisted Solution

by:jbfraser
jbfraser earned 200 total points
ID: 23634125
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

0
 

Accepted Solution

by:
sgpinc earned 0 total points
ID: 23682010
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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
A simple overview of the possibilities of using technology for project management.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses
Course of the Month17 days, 12 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question