Linking project with WSS sites

[icolias]

Hi all:

I've got some SharePoint sites created with Project template.

Now, I'm creating new projects using PDS and I need to link each new project
with a SharePoint site, but I need do it programmatically.

Any idea ??

Thanks in advance

 

[Ed Morrison]

From the PDS reference documentation in the SDK:

If a Project Web Access administrator selects AutoCreate WSS, and
AutoPublish is set to 1, a site for the new project will also be created on
the server that is hosting the Microsoft Windows SharePointT Services
associated with Project Server.

Hope this helps

 

[icolias]

SharePoint sites are already created. I need to link a new project with an
existing SharePoint site.

Any idea ?

 

[Ed Morrison]

Was the WSS site created with the Project Workspace template? If it was not
you cannot link Risks, Issues, or Documents in PWA. If it was, in PWA goto
Admin, Manage Windows SharePoint Services, Manage SharePoint sites. Select
the project you want and click on the edit button. Enter the appropriate
URL.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com

 

[icolias]

Thanks Ed, that's the way to link a project with a SharePoint Site. But I
need to do it using PDS, directaly in Project Server database, ...

Thanks anyway

 

[Bill Brockbank]

Here is a query that will return all of the SharePoint URLs

Execute against the ProjextServer Database.

**********************************************
SELECT DISTINCT WP.PROJ_ID, WP.PROJ_NAME,
'http://' + WS.WSTS_SERVER_NAME + ':' +
CAST(WS.WSTS_SERVER_WEB_PORT AS varchar(4)) + '/' + WS.WSTS_MANAGED_PATH +
'/' + WP.WPROJ_STS_SUBWEB_NAME As URL
From MSP_WEB_PROJECTS WP
INNER JOIN MSP_WEB_STS_SERVERS WS ON WP.WSTS_SERVER_ID = WS.WSTS_SERVER_ID

**********************************************

 

[icolias]

Thanks Bill.

I try to explain my problem again. I've got some SharePoint sites created
with project template. Now, when I create a new Project directly using PDS,
I need to link this project with one of those existing SharePoint sites, but
it must be programmatically, using PDS, .... not manually.

Thanks in advance.

 

[Ed Morrison]

Try updating the msp_web_projects table. I think you'll need to update the
WPROJ_STS_SUBWEB_NAME, WSTS_SERVER_ID, WPROJ_ISSUE_LIST_NAME,
andWPROJ_RISK_LIST_NAME fields.

Let us know if this works for you.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com