Retrieving Project Hierarchy using PSI from Project Server 2007

[dilipn123]

Hi,

Greetings!


I'm trying to retrieve list of projects along with their sub-projects
in a custom C# application. I tried using standard PSI (Project
webservice) i.e.ReadProjectList() method. It lists out only the main
projects, the sub-projects aren't listed. I went ahead and tried PWA
webservice which has ProjectGetProjectHeirarchy() method, but the
results are not proper, it displays the project GUID which is passed
as the parameter, doesn't retreive the array of child GUID's
properly.


Is there any standard PSI webservices which I can use in this
scenarios? I tried but couldn't find now I'm thinking of writing my
own custom PSI. I have seen the "Hello World" PSI extension in SDK
but
it doesn't talk about writing a full-fledged custom PSI for e.g. how
to retreive the data from the database and return it in a dataset. It
just shows how to use an existing PSI webservice from the custom
webservice. I want to write my custom PSI which will communicate with
the DAL and get me the list of projects along with the hirearchy
information.


Could you please let me know how to go about it?


Thanks and Regards,
Dilip

 

[Rod Gill]

I think you either need to write a PDI extension or read the project details
directly from the reporting database in SQL Server.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[dilipn123]

Hi Rod,

I have seen some examples in SDK, but all of them show how to consume
the standard web services which PSI provide. Is there any example
or .cs file which will show how this webservice was written, I mean
how it accesses the database, database interface etc. like how it was
with PDS in Project Server 2003.

My purpose is that I want to sych Project Server 2007 with another ERP
system named, microsoft Dynamics Axapta so I'm writing a c# utility
which will use the PSI webservice to pull data from project server and
update in Axapta (Project module). Do you have or anyone have an
example or template which will show how the PSI webservice was
written?

Thanks and Regards,
Dilip

 

[Rod Gill]

No. There is already an interface for Project Server to Dynamics provided by
Microsoft, so evaluate that as well.

As far as I'm aware, the only resources available are the Project SDK and
one or two blogs by Microsoft staff (Search for them)

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


Hi Rod,

I have seen some examples in SDK, but all of them show how to consume
the standard web services which PSI provide. Is there any example
or .cs file which will show how this webservice was written, I mean
how it accesses the database, database interface etc. like how it was
with PDS in Project Server 2003.

My purpose is that I want to sych Project Server 2007 with another ERP
system named, microsoft Dynamics Axapta so I'm writing a c# utility
which will use the PSI webservice to pull data from project server and
update in Axapta (Project module). Do you have or anyone have an
example or template which will show how the PSI webservice was
written?

Thanks and Regards,
Dilip

 

[dilipn123]

Would you be kind enough to point me to the right source from where I
can get more information about the "Interface from Project Server to
Dynamics". It would be great help for me.

 

[Rod Gill]

Don't know where it is I'm afraid, you need to search for it or ask
Microsoft.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


Would you be kind enough to point me to the right source from where I
can get more information about the "Interface from Project Server to
Dynamics". It would be great help for me.