Project 2003\Sharepoint 'primary keys'

[Nock]

Hi all,

I'm trying to figure out how best to extract sharepoint data to an Excel
report. At the moment I've got a clunky VBA interface that performs basic
SQL queries and custom built SQL views. I can also extract WSS data using
Excel 2003 data retrieval services (Data Connection Wizard).

However, is there a 'primary key' or something similar that identifies a
specific project across both Project 2003 and Windows Sharepoint systems?

For example. My Excel VBA 'app' allows an admin person to select project X
via a listbox (which uses the Proj_ID column contained in the MSP_Projects
table as the primary key) from which to extract data via SQL queries. Using
this same approach, how can I extract Project X data stored in Sharepoint?
Can I pass the unique project ID (Proj_ID) via XML or something?

Hope this makes sense.

System Environment
Project 2003
Server 2003
SQL 2000
Project Professional
Excel 2003 (for report generation)

Many thanks, this discussion group is fantastic.

Nock (Australia)

 

[Rod Gill]

Hi,

Have you read the pjsvrdb.htm file stored in one of Project's program
folders (and the Project CD?). There is a WPROJ_ID that I think will work
for you. In the MSP_WEB_PROJECTS Table there is a wproj_issue_list_name and
a wproj_risk_list_name field.

I have linked the tables in the project server database to the tables in the
WSS database and extracted Issues and Risks for a project so I know it can
be done, I just don't have access to the VIEWS I created that did this.

Hope the summer isn't too hot for you, where are you based? I'm just north
of Auckland NZ.

 

[Nock]

Rod,

I was looking in the PJDB.htm (MS Project 2003 Data Reference) but couldn't
find anything relating to WSS, my inexperience showing here...

I'll give the MS Project Server 2003 Data Reference a go and let you know.
Thanks again for the direction, much appreciated. Now if I could just get
someone to give me access to a CD....or the server.

Hottest summer here in 60 years+ apparently. I'm based in Canberra and
working for the Federal Gov. Most of us are walking around resembling the
undead (not that uncommon regardless) it's just so difficult to sleep when
it's this hot.

Thanks again for your help, it's been a steep (but interesting) learning
curve for me.

Nock

 

[Nock]

I must admit in my ignorance I assumed you were a yank and that you must have
been a hardworking one at that, as your replies to my quesitons came through
an hour or two after I posted them - approx 4-5am New York time!

Cheers,

Nock