Daily Actual Work Data

[Diane]

In what table is the data kept where users enter in how many hours per day
they have worked on a task? The MSP_TASKS table solely has cummulative data.
I am looking to extract simply Date & # of hours worked for a resource for a
specific task.

I have looked at the layout, but unless you dump the data, the codes are not
all that intuitive. Is there a book or download that might have more info
specifying how/where the data is stored in Project Server 2003?

 

[Dale Howard [MVP]]

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.

 

[Diane]

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

 

[Sara - EPM]

Diane,

I've worked with MSP_WEB_WORK before and have found a risk in the numbers.
The table contains all hours recorded by a resource, regardless of whether
the PM has approved or rejected the task. I assume you are using this
extract for some sort of reporting. Lets say I'm one of your resources and
I've charged 20 hours towards a task. You do not agree with my hours and
have rejected my update. Because I have not cleared those hours from my
timesheet, those 20 hours will still appear in your extract from WEB_WORK.

Use this link:

http://www.microsoft.com/downloads/...8C-8BCA-4DB9-8753-178C0D3099C5&displaylang=en


This will get you started with timephased data; it uses hours from actual
hours...not for web work actual hours. If you have access...any good SQL
person will be able to help, if needed.

Also, if you need hours from just one project at a time, explore the Analyze
Timephased Data in Excel Wizard in Professional (in your Analysis toolbar).

Sara

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.

 

[Joe]

Try this link:

http://msdn.microsoft.com/library/d.../pjsdkExtractingTimephasedData_HV01112435.asp

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.

 

[Diane]

I found that table & a few others ... I thought about doing this:

I get the Project name from MSP_WEB_PROJECTS
The date (since I only allow them to enter hrs per day) from
MSP_WEB_WORK.WWORK_START (same as finish)
resource name from MSP_WEB_RESOURCES
Phase & Tasks from MSP_WEB_ASSIGNMENTS
and then I get the # of hours from MSP_WEB_WORK.WWORK_VALUE ... but only
take the data where WWORK_APPROVAL_STATUS = 1 (has been adjusted and/or
approved.)

What do yo think of this method?

Diane,

I've worked with MSP_WEB_WORK before and have found a risk in the numbers.
The table contains all hours recorded by a resource, regardless of whether
the PM has approved or rejected the task. I assume you are using this
extract for some sort of reporting. Lets say I'm one of your resources and
I've charged 20 hours towards a task. You do not agree with my hours and
have rejected my update. Because I have not cleared those hours from my
timesheet, those 20 hours will still appear in your extract from WEB_WORK.

Use this link:

http://www.microsoft.com/downloads/...8C-8BCA-4DB9-8753-178C0D3099C5&displaylang=en


This will get you started with timephased data; it uses hours from actual
hours...not for web work actual hours. If you have access...any good SQL
person will be able to help, if needed.

Also, if you need hours from just one project at a time, explore the Analyze
Timephased Data in Excel Wizard in Professional (in your Analysis toolbar).

Sara

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.




In what table is the data kept where users enter in how many hours per day
they have worked on a task? The MSP_TASKS table solely has cummulative
data.
I am looking to extract simply Date & # of hours worked for a resource for
a
specific task.

I have looked at the layout, but unless you dump the data, the codes are
not
all that intuitive. Is there a book or download that might have more info
specifying how/where the data is stored in Project Server 2003?

 

[Joe]

Diane,

I would like to access this table (and a few others) using MS Access. Could
you tell me how to go about setting it up? I would like to create a "linked"
table in Access, but I don't know what the ODBC settings should be. I know I
need to create DSN using the SQL Server Driver, but I don't know the rest,
such as the server name and log on settings. Would you be able to guide me
in the right directions?

I found that table & a few others ... I thought about doing this:

I get the Project name from MSP_WEB_PROJECTS
The date (since I only allow them to enter hrs per day) from
MSP_WEB_WORK.WWORK_START (same as finish)
resource name from MSP_WEB_RESOURCES
Phase & Tasks from MSP_WEB_ASSIGNMENTS
and then I get the # of hours from MSP_WEB_WORK.WWORK_VALUE ... but only
take the data where WWORK_APPROVAL_STATUS = 1 (has been adjusted and/or
approved.)

What do yo think of this method?

Diane,

I've worked with MSP_WEB_WORK before and have found a risk in the numbers.
The table contains all hours recorded by a resource, regardless of whether
the PM has approved or rejected the task. I assume you are using this
extract for some sort of reporting. Lets say I'm one of your resources and
I've charged 20 hours towards a task. You do not agree with my hours and
have rejected my update. Because I have not cleared those hours from my
timesheet, those 20 hours will still appear in your extract from WEB_WORK.

Use this link:

http://www.microsoft.com/downloads/...8C-8BCA-4DB9-8753-178C0D3099C5&displaylang=en


This will get you started with timephased data; it uses hours from actual
hours...not for web work actual hours. If you have access...any good SQL
person will be able to help, if needed.

Also, if you need hours from just one project at a time, explore the Analyze
Timephased Data in Excel Wizard in Professional (in your Analysis toolbar).

Sara

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

:

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.




In what table is the data kept where users enter in how many hours per day
they have worked on a task? The MSP_TASKS table solely has cummulative
data.
I am looking to extract simply Date & # of hours worked for a resource for
a
specific task.

I have looked at the layout, but unless you dump the data, the codes are
not
all that intuitive. Is there a book or download that might have more info
specifying how/where the data is stored in Project Server 2003?

 

[Diane]

I'm not really sure that can be done BUT, I do know that if you load he SQL
Client tools locally onto a users computer, you can probably get what you
need to out of query code, etc. I just did this instead of using access and
it worked like a charm.. I am very pleased.

Hope this helps.

Diane,

I would like to access this table (and a few others) using MS Access. Could
you tell me how to go about setting it up? I would like to create a "linked"
table in Access, but I don't know what the ODBC settings should be. I know I
need to create DSN using the SQL Server Driver, but I don't know the rest,
such as the server name and log on settings. Would you be able to guide me
in the right directions?

I found that table & a few others ... I thought about doing this:

I get the Project name from MSP_WEB_PROJECTS
The date (since I only allow them to enter hrs per day) from
MSP_WEB_WORK.WWORK_START (same as finish)
resource name from MSP_WEB_RESOURCES
Phase & Tasks from MSP_WEB_ASSIGNMENTS
and then I get the # of hours from MSP_WEB_WORK.WWORK_VALUE ... but only
take the data where WWORK_APPROVAL_STATUS = 1 (has been adjusted and/or
approved.)

What do yo think of this method?

Diane,

I've worked with MSP_WEB_WORK before and have found a risk in the numbers.
The table contains all hours recorded by a resource, regardless of whether
the PM has approved or rejected the task. I assume you are using this
extract for some sort of reporting. Lets say I'm one of your resources and
I've charged 20 hours towards a task. You do not agree with my hours and
have rejected my update. Because I have not cleared those hours from my
timesheet, those 20 hours will still appear in your extract from WEB_WORK.

Use this link:

http://www.microsoft.com/downloads/...8C-8BCA-4DB9-8753-178C0D3099C5&displaylang=en


This will get you started with timephased data; it uses hours from actual
hours...not for web work actual hours. If you have access...any good SQL
person will be able to help, if needed.

Also, if you need hours from just one project at a time, explore the Analyze
Timephased Data in Excel Wizard in Professional (in your Analysis toolbar).

Sara

:

I though of that, but it just seemed like an extra step being this will not
be the data's final resting place ;-)

I was fortunate enough to find the hours by data in MSP_WEB_WORK table, now
I guess it is just a matter of linking the other stuff I need, resource # etc
from other tables ... [I hope] to make one clean download from SQL.

:

Diane --

You might try this approach:

1. Log into PWA and navigate to the Resource Center
2. Click the View resource assignments link in the sidepane on the left
3. Select the resources whose assignments you wish to see and click the
Apply button
4. Click the View Options tab and select the Show scheduled work option
5. Select the Timesheet format option in the sidepane on the left
6. Select the All Tasks option in the sidepane on the left, if desired
7. Click the View Options tab again to collapse the options at the top of
the page
8. Click the Save Link button at the top of the grid and save this custom
view as a link so you can reapply it easily in the future
9. Click the Export Grid link in the lower right corner of the data grid
and export the data to Excel

Just a thought. Hope this helps.




In what table is the data kept where users enter in how many hours per day
they have worked on a task? The MSP_TASKS table solely has cummulative
data.
I am looking to extract simply Date & # of hours worked for a resource for
a
specific task.

I have looked at the layout, but unless you dump the data, the codes are
not
all that intuitive. Is there a book or download that might have more info
specifying how/where the data is stored in Project Server 2003?