Exporting timephased data...

[K Major]

Is there any way to use MSP's export function to grab timephased data from a
certain defined period?

Example: I want to grab the "actual work" timephased field entered for the
week beginning 3/6/2005 and dump it into Excel. I would also want to
associate the resource that performed the work. Basically, I'm describing a
timecard reporting process based on a weekly reporting.

It seems like this can be done based on canned reports I see that are doing
somewhat similar things (at least in theory).

Any ideas?

Thanks, Kevin

 

[Dale Howard [MVP]]

K Major --

You might try the following procedure:

1. Click View - Toolbars - Analysis
2. Click View - Resource Usage
3. Click the Analyze Timescaled Data in Excel button on the Analysis
toolbar
4. Select the "Entire project" option and click Next
5. Remove the Work field and add the Actual Work field and click Next
6. Enter the starting/ending dates in the From and To fields and click Next
7. Select the No Thanks option and click Next
8. Click the Export Data button

The key is to run the Analyze Timescaled Data in Excel macro while in the
Resource Usage view. Please note, however, that you cannot see the task(s)
upon which each resource worked during the reporting period using this
procedure.. Hope this helps.

 

[John]

K Major --

You might try the following procedure:

1. Click View - Toolbars - Analysis
2. Click View - Resource Usage
3. Click the Analyze Timescaled Data in Excel button on the Analysis
toolbar
4. Select the "Entire project" option and click Next
5. Remove the Work field and add the Actual Work field and click Next
6. Enter the starting/ending dates in the From and To fields and click Next
7. Select the No Thanks option and click Next
8. Click the Export Data button

The key is to run the Analyze Timescaled Data in Excel macro while in the
Resource Usage view. Please note, however, that you cannot see the task(s)
upon which each resource worked during the reporting period using this
procedure.. Hope this helps.

Kevin,
I'll add a couple comments to Dale's response. As Dale suggested,
starting from the Resource Usage view will give the timephased data for
each resource. If the export is also done from the Task Usage view, the
timephased data for each Task is exported. Depending on the file
structure, the resulting Excel Worksheets can be combined to give a more
complete picture (i.e. timephased data for Resources and their
assignments). This method works best if there is only one resource per
task - not an unusual structure.

I you have, (or know someone who has), VBA experience, another option is
to develop a custom VBA routine to export all the data you need and
format it in any way you need.

Hope this helps.
John
Project MVP

 

[K Major]

This helps a bit - thanks.

Looks like I'm going to have to go to VBA though. What I'm trying to do is
generate a timecard per resource for weekly work at the task level.

We have lots of IT resources here - what do I even tell a VBA programmer to
do for me? How does he access the table, etc.?

Kevin

 

[John]

This helps a bit - thanks.

Looks like I'm going to have to go to VBA though. What I'm trying to do is
generate a timecard per resource for weekly work at the task level.

We have lots of IT resources here - what do I even tell a VBA programmer to
do for me? How does he access the table, etc.?

Kevin

Kevin,
There are a couple of methods. One is to use VBA, the other SQL. VBA can
access Project objects directly. For example, to get timephased data for
Tasks, Resources, or Assignments, use the TimeScaleData Method inside a
loop that cycles through all the Task, Resource, or Assignment objects.
For more information, look in the VBA help file.

SQL access the Project database tables directly. For a definition of the
database structure, look for the following file on your "C" drive:
prjdb.htm

As far as telling you IT programmer what to do, I suggest you put
together a mock up of the report you want on an Excel Worksheet and give
that to him. That's what I would want if I were writing the code.

Hope this helps.
John
Project MVP

 

[pooja]

hey John,
Thanx for ur suggesions in VBA...it really helped...
Thank u
Pooja

 

[John]

hey John,
Thanx for ur suggesions in VBA...it really helped...
Thank u
Pooja

Pooja,
You're welcome.
John