Creating a Field Extract or 'Data Fact Sheet'

[Nock]

Hi all,

We are looking to migrate data from our Project Server environment and we
would like to create an Excel spreadsheet, or matrix that:

- Lists all Columns, or 'Field Names' available to Project Managers (Eg.
Work, Start Finish, Actual Work etc). From what I can make out it seems
there are several hundred at least.
- Lists all Projects stored in our current Project Server environment
- Identifies whether data is stored in each field, for each project. A
simple yes\no answer in each field is sufficient.

Is it possible to extract this from the Project Server SQL DB? Is there
another way to do this?

Many thanks,

Nock (Newb)

p.s An excellent forum especially given product complexity and uncommon use.

 

[Rod Gill]

Yes you can do this. I have regularly created Excel VBA macros to import
data from SQL Server to report on a project or multiple projects.

Read pjdb.htm and pjsvr.htm in one of Project's program folders for details
on the database schema. Provided all projects are published regularly, the
MSP_VIEW tables are best for report data.

You can also use the new SQL Server reporting services tool.

 

[Nock]

Thanks for your reply Rod.

I had a look at the two files and it seems as thou the information I require
is actually spread across several different tables...which could take a while
to put together.

For example, the 'Actual Cost' column that is available within Project
Professional si is actually called something else and sits under a different
table to the 'Resource Names' field.

I need to be able to extract a flat list of all the available columns within
Project Professional. Might try and source a SQL DBA to help me out.

Cheers,
Nock