Problems pulling timephased information from Project DB via query

[David Childers]

I am running a macro that pulls information out of Project into Excel
via a query to the Project DB in SQL Server. I've noticed that when I
run a query to look at a resource's daily actuals, the daily hours
don't show up if I adjust their hours in a previous time period through
PWA. E.g: When running a report for November, I realize someone booked
hours to the wrong task the first week of November. I swap their hours
to the correct task, and this shows up fine in Project itself, and in
PWA. However, when I run a query on the MSP_VIEW_PROJ_ASSN_TP_BY_DAY
table in the database, it removes their orginal hours, but does not
update the new hours for that week. Any ideas?

Thanks,

David

 

[David Childers]

David Childers Dec 8, 6:24 pm show options

Newsgroups: microsoft.public.project.pro_and_server
From: "David Childers" <[email protected]>
Date: 8 Dec 2004 18:24:03 -0800
Local: Wed, Dec 8 2004 6:24 pm
Subject: Re: Problems pulling timephased information from Project DB
via query
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I've found that the changes I made in PWA are visible in the
MSP_WEB_WORK_ADJUSTED table, but for some reason the timephased
information did not transfer to the Project
MSP_VIEW_PROJ_ASSN_TP_BY_DAY table, which is where I would expect it to
go, and where my query pulls the data from. Any ideas on how to redo
the actuals adjustment to get Project to put the data into the table I
want, or how to trasnfer the data from the WEB table to the VIEW table?
Thanks!

 

[JackD]

I think that when you update the project with the PWA data then the view
tables will change.
I may be wrong, but that is the way it used to work with Project Central.
Changes in the plan are not reflected until the updates are accepted and
processed.

 

[David Childers]

I've actually already updated and approved/accepted everything, but it
still doesn't show up in the timephased table. I tried the exact same
process on my MS Project test server, and I had no problems at all with
that one (time changes show up in the timephased tables). I've tried
everything from reentering/approving time as an admin to having the
people submit the time themselves, but it never shows up on my
production server.

 

[JackD]

Sorry, I can't give you much more help. I suggest you post in the Project
server group.
They know more about this.

 

[Rod Gill]

Matches my knowledge:

Get the PM to accept the timesheet entries, then open project and save to
transfer to MSP_ tables and publish to update MSP_VIEW tables.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz