Extract timephased data day by day from MSP Database

[Microsoft Communities]

Hi all,

How to Extract timephased data from database of MSP Server 2003, day by day.
Now I get directly from MSP local file, but the speed is very slow and
sometime COM cannot get exactly data because exception when call
objAssignment.TimeScaleData

Thanks

 

[Rod Gill]

Hi,

From the SQL Server Views look for the Tables named MSP_VIEW_ Some of them
have time phased data. Your projects have to be published to show latest
data.

--

Rod Gill
Microsoft MVP for Project

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

 

[Microsoft Communities]

Hi,

I see the Tables named MSP_VIEW_ in SQL Server Tables. There are many table
and view, and I can’t understand field' responsibility...

Thanks for support.

 

[Rod Gill]

Open each one in turn and look at the data. I think timephase ones have by
day in the name but its been a long time since I use Project Server 2003.

--

Rod Gill
Microsoft MVP for Project

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