Combining Project & Sharepoint

[venetian_jigsaw]

We have multiple project listings (from Sharepoint), spreadsheets and
project plans that we are trying to combine into a master project plan.
Realizing that SQL Server and data mapping might be required, does
anyone have an idea how we can reduce the duplicity? What our optimal
scenario would be is that for any project related matter, we somehow
have allow the user to enter their project in the Sharepoint site and it
then gets entered into MS Project...BTW, we are running Project Server
2007 and it is also contained in a Sharepoint portal. One common thread
for all three of these tools: XLS based and maybe that is the starting
point. Additionally, SQL may also be another common thread as well (w/
the exception of Excel and that is unless we allow exports to SQL
Server, which would be highly unlikely since we are talking production
data).

Hope this makes sense to the masses...would hate to confuse on my
initial post from what appears, at first glance, to be a really
intelligent user community!

v_j

 

[Rod Gill]

Hi,

Project Server is designed to combine project information, including
Resource assignments. I suggest getting all projects to live in Project
Server where they can be reported on with possibly no need to create a
master project at all. All project data in Project Server is automatically
stored in SQL Server so you can use whatever reporting tools you have that
work with SQL Server.

project Server uses SharePoint for custom workspaces for each Project to
hold project documentation etc.

--

Rod Gill
Microsoft MVP for Project

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