Assignment Project field

[hreintke]

LS,

I am using MSProject 2007.
I have created a "shared resource" project which only defines the
available resources to be shared by multiple projects.

In separate projects files I have defined the projects and am using the
"shared resource" project as the combined resource pool.

From planning/information point of view all works as expected.
In all the project files I see the combined work effort.

The question is about the view of the information. In the "Resource
Usage" view I can add a field "Project". But the content of the field is
not consistent. Sometimes I see the full filename of the project,
sometimes I see only the projectname. The latter is for me the preferred
way.

Does someone know how the content of the field is controlled ?

Kind regards,

Herman Reintke

 

[Jim Aksel]

The Project Field is taken from the File Name of origination.
I have not tried it, but you can insert Task0 (Project Summary Task) to the
source files (Tools/Options... check the display project summary task). You
can change the information shown for Task0 from File/Properties. However,
that is not the file name.

If you are saying that your inserted subprojects "Project Field" name is
showing the same name as your master project name, that would probably be
because when the file was inserted the "link" box was unchecked.

The two sources of data you have available are under File/Properties and the
name of the file itself.

If this does not address your issue, please post additional detail so this
old man can get a clearer picture.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Mike Glen]

Hi Herman,

Welcome to this Microsoft Project newsgroup

I understand that the file name alone will appear if the file is in the same directory. If the project file is in a different directory, then the full path will be shown.

FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials




LS,

I am using MSProject 2007.
I have created a "shared resource" project which only defines the
available resources to be shared by multiple projects.

In separate projects files I have defined the projects and am using the
"shared resource" project as the combined resource pool.

From planning/information point of view all works as expected.
In all the project files I see the combined work effort.

The question is about the view of the information. In the "Resource
Usage" view I can add a field "Project". But the content of the field is
not consistent. Sometimes I see the full filename of the project,
sometimes I see only the projectname. The latter is for me the preferred
way.

Does someone know how the content of the field is controlled ?

Kind regards,

Herman Reintke

 

[hreintke]

LS,

No it's not as straightforward as I hoped it would be. Although th
files are in one directory now (which will cange once all is in place)
the field gives different content view on different times.

Let' get my situation clear.

I have a mpp file called shared_resources. In here only the resource
are defined and no actual tasks inserted.
Besides that I have a number of mpp files where the actual tasks ar
defined and resources allocated. These "task mpp files" all use th
shared_resources mpp as the resource pool.

Then I want to get an overview of the overall resource usage. I ope
the shared_resources mpp and go to the "resource usage view". I adde
the Column Project to be able to see which project alloacted th
resource.

Data then for example

Shared_Resources Unassigned
PaperlessDelivery Realisatie
Frico_XX Cutover
Frico_XX Aftercare
CRMIF Quote delivery 30%
Shared_Resources CRM
PaperlessDelivery Feasibility
PaperlessDelivery Detailed Design
PrePaidInternational Feasibility
PrePaidInternational Detailed Design
PrePaidInternational Realisation
CRMIF Feasibility
CRMIF Detailed Design
CRMIF Realisation
CRMIF Aftercare

You see, only project names.

But sometimes I get

Shared_Resources Unassigned
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Realisatie
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\Frico_XX.mpp Cutover
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\Frico_XX.mpp Aftercare
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Quote deliver
30%
Shared_Resources CRM
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Feasibility
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Detaile
Design
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Feasibilit

\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Detaile
Design
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Realisation
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Feasibility
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Detaile
Design
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Realisation
\\India\shr-tmnl-tsn
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Aftercare

So suddenly I get filenames.

Other times I even get a mixture of projectnames and filenames.

The same happens when I get the shared_resources data from an excel
macro using this code :

Set rs = ActiveProject.Resources
For Each r In rs
If Not r Is Nothing Then
Set Asg = r.Assignments
For Each a In Asg
Set TSV = a.TimeScaleData(sd, ed, pjAssignmentTimescaledWork
pjTimescaleWeeks, 1)
For j = 1 To TSV.Count
debug.Print a.Project
Next j
Next a
End If
Next r

Also here the a.Project gives (on different times, same file) differen
content.

Kind regards,

Herman Reintk

 

[Mike Glen]

If you've put them all on the same directory and get just the file names, that is what I would expect. Can you analyse what you're doing differently when the full path suddenly appears? At the moment, I can't think of why that should happen so there must be something different.

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials


LS,

No it's not as straightforward as I hoped it would be. Although the
files are in one directory now (which will cange once all is in place),
the field gives different content view on different times.

Let' get my situation clear.

I have a mpp file called shared_resources. In here only the resources
are defined and no actual tasks inserted.
Besides that I have a number of mpp files where the actual tasks are
defined and resources allocated. These "task mpp files" all use the
shared_resources mpp as the resource pool.

Then I want to get an overview of the overall resource usage. I open
the shared_resources mpp and go to the "resource usage view". I added
the Column Project to be able to see which project alloacted the
resource.

Data then for example

Shared_Resources Unassigned
PaperlessDelivery Realisatie
Frico_XX Cutover
Frico_XX Aftercare
CRMIF Quote delivery 30%
Shared_Resources CRM
PaperlessDelivery Feasibility
PaperlessDelivery Detailed Design
PrePaidInternational Feasibility
PrePaidInternational Detailed Design
PrePaidInternational Realisation
CRMIF Feasibility
CRMIF Detailed Design
CRMIF Realisation
CRMIF Aftercare

You see, only project names.

But sometimes I get

Shared_Resources Unassigned
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Realisatie
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\Frico_XX.mpp Cutover
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\Frico_XX.mpp Aftercare
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Quote delivery
30%
Shared_Resources CRM
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Feasibility
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PaperlessDelivery.mpp Detailed
Design
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Feasibility

\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Detailed
Design
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\PrePaidInternational.mpp Realisation
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Feasibility
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Detailed
Design
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Realisation
\\India\shr-tmnl-tsnl
projects\Projectmanagement\Overall_Planning_old\CRMIF.mpp Aftercare

So suddenly I get filenames.

Other times I even get a mixture of projectnames and filenames.

The same happens when I get the shared_resources data from an excell
macro using this code :

Set rs = ActiveProject.Resources
For Each r In rs
If Not r Is Nothing Then
Set Asg = r.Assignments
For Each a In Asg
Set TSV = a.TimeScaleData(sd, ed, pjAssignmentTimescaledWork,
pjTimescaleWeeks, 1)
For j = 1 To TSV.Count
debug.Print a.Project
Next j
Next a
End If
Next r

Also here the a.Project gives (on different times, same file) different
content.

Kind regards,

Herman Reintke

 

[hreintke]

Mike,

What you are describing is exactly my issue. I see no obvious reason
for the difference in field appearance. As far as I know I am using th
project files and fields in the same way but still there is the chang
in behaviour, am stuck with the situation and don't know where to g
from now.

Any hint in a direction to look for is appreciated.

Kind regards,

Herman

 

[Mike Glen]

Hi Herman,

We need to discover whether your project is at fault, whether it is Project at fault, or whether it's your PC. Does the symptom occur with other projects on this PC? Does it occur with this project on other PCs? Does it occur with other projects on other PCs?

Mike Glen
MS Project MVP



Mike,

What you are describing is exactly my issue. I see no obvious reasons
for the difference in field appearance. As far as I know I am using the
project files and fields in the same way but still there is the change
in behaviour, am stuck with the situation and don't know where to go
from now.

Any hint in a direction to look for is appreciated.

Kind regards,

Herman

 

[JulieS]

Herman,

I think the differences can be explained with the examples below:

If I open a shared resource pool file with the option "Open read-only
....." I see the full path in the Project field added to the Resource
Usage view.

If I open the shared resource pool file with the option "Open
read-write...." I see the full path in the Project field.

If I open the shared resource pool file with third option "Open the
resource pool read-write and all sharer files..." and I look at the
Resource Usage view of the resource pool, I see only the short path
(file name) if the files are stored in the same directory.

If I open one of the sharer files (file getting resources from the pool)
with the option "Open resource pool to see assignments....." and I look
at the resource usage view in the pool file, I see the short path (file
name only) for the sharer project file currently open but the long path
for any other sharer files not currently open.

If I open one of the sharer files with the option "Do not open other
files" and I look at the Resource Usage view in the sharer file I have
open (the pool file is not open) I see only resources assigned in the
currently open project, and I see only the short path.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQos and additional
information about Microsoft Project

 

[JulieS]

Yes. Fast fingers opening those files, Mike

Julie