How do I get a file list in Project Server

[Gilgamesh]

As stated in the title I'm trying to get a list project names from Project
Server (using VBA).
All I need to see are those files I would normally see in the File->Open
dialog.
I can easily do this for files stored on the local hard disk but I need the
names from the Server.
I also need the names of schedules that have not been published so using PWA
Project Centre is not viable.
I'm using Project 2007 for this.
Thanks

 

[Assaf]

Hi,
Sounds like you need to query the server - it should be a work for PSI
services.
I didn't do it and couldn't find any information on how to do it, so I don't
think it's possible from VBA.

Why won't you use VSTO addin for server action like that?
You have the PSI project service that returns projects list like you need.

HTH

 

[Gilgamesh]

Hi,
Sounds like you need to query the server - it should be a work for PSI
services.
I didn't do it and couldn't find any information on how to do it, so I
don't
think it's possible from VBA.

Why won't you use VSTO addin for server action like that?
You have the PSI project service that returns projects list like you need.

HTH

Unfortunately I don't have direct access to the server.
I only have my MS Project client and PWA which is why I specified the need
to do it in VBA..
We have one instance of MS Project Server used globally and they won't make
special access requests just for what one country wants to do.

 

[Stephen Sanderlin [MVP]]

If you can access the server through PWA and WinProj, you should be able
to access the PSI. However, without admin access, you'd only be able to
get a list of projects that you are able to access.

--
Stephen Sanderlin, Project MVP
VP of Technology
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com

 

[Gilgamesh]

If you can access the server through PWA and WinProj, you should be able
to access the PSI. However, without admin access, you'd only be able to
get a list of projects that you are able to access.

As I mentioned in my original posts I only want a list of schedules that I
can see in the File Open dialogue which is just the ones I have access to.
Can you direct me to some reading on PSI so I can learn how to use it
properly.
Thanks

 

[Assaf Leibovich]

Hi,
This can get you started:
There is the Project web service as part of PSI services.
its found at this url of your server to add reference:
http://ServerName/ProjectServerName/_vti_bin/psi/Project.asmx
It has a method called ReadProjectStatus, short explanation can be found here:
http://msdn.microsoft.com/en-us/library/websvcproject.project.readprojectstatus.aspx

HTH

 

[Rod Gill]

Hi,

Reading the list of published projects in VBA is easy: read them from the
Reporting db using OLEDB. Plenty of sample code on MSDN and elsewhere
(including page 421 in my book!)

Non published projects won't be in the reporting db. You can read them from
the working db but Microsoft doesn't support that. However this is read only
and the worst case is that the db structure may change slightly after a
hotfix or service pack so you need to update your query.

The free SDK download for Project (from msdn) provides all Reporting db
fields. I recommend reading from the Views ending with _userview as they
have all custom fields appended to them automatically.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

As stated in the title I'm trying to get a list project names from Project
Server (using VBA).
All I need to see are those files I would normally see in the File->Open
dialog.
I can easily do this for files stored on the local hard disk but I need
the names from the Server.
I also need the names of schedules that have not been published so using
PWA Project Centre is not viable.
I'm using Project 2007 for this.
Thanks


__________ Information from ESET Smart Security, version of virus
signature database 4823 (20100201) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4823 (20100201) __________

The message was checked by ESET Smart Security.

http://www.eset.com