Using a resource pool with a Master project

S

shoppingboy

I have consolidated about 100 individual projects into a single 'Maste
project' (using the Insert /project command). Each individual project i
linked to the master.
Also I have a resource pool and linked this to the master project (bu
not individual projects). My thinking is that the resource pool shoul
now show resource usage but it actually doesnt show any usage atall.
Am I trying something that wont work or is there another way to se
things up
 
D

Dale Howard [MVP]

shoppingboy --

You need to connect each of the 100 individual projects to the shared
resource pool file. Then you will see the usage data you want to see. Hope
this helps.
 
S

shoppingboy

Thanks for the advice, I thought as much. Should I break the lin
between 'master' project and resource pool as well? Just out o
curiosity, why doesnt this set up work, after all its only linking on
file to the resource pool
 
D

Dale Howard [MVP]

shoppingboy --

If the master project contains only subprojects, and does not contain any
tasks of its own, then break the link between the master project and the
subprojects as it is not needed. The reason your setup did not work is
because the master project is merely a "container" which holds a working
copy of each of the subprojects. Hope this helps.
 
R

Rod Gill

With 100 projects connected, take daily backups. You will get corruption
sooner or later if anyone ever copies over a linked file, moves one or
renames it without first detaching it from the pool and master project. So
do regular training and reminders and good luck!

--

Rod Gill
Microsoft MVP for Project

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

Rod Gill

Thanks for your response to my "sage wisdom" on your wise and as always,
accurate response!

See you next week at the conference my friend.

--

Rod Gill
Microsoft MVP for Project

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

shoppingboy

Many thanks Dale and Rod for your advice. Do either of you know of a
quick way to link 100 subprojects to the resource pool or do I have to
open each subproject in turn and use tools/resource sharing/share
resources/resource pool ?
 
R

Rob Schneider

The quickest way would be to write a small VBA macro that
: opens each file (for that you need a list)
: attaches the shared resource file
: saves the file

Write, test, and then let rip.

You can get started with this by recording a macro to see the basics.
Then to that recorded macro, add the loop to cycle through all 100 file.
If VBA is not part of your world, then, yes, open them up and do it to
each. It's a one-time thing.


--rms

www.rmschneider.com
 
R

Rod Gill

Actually it may not be just one time. With 100 files corruption will happen,
so code to unattach each file and separate code to then re-attach to a new
Resource Pool will be useful. If a re-organization of Files and folders is
needed, much, much safer to unattach all files first, then move files and
folders etc then re-attach to a new pool.

I've even used a macro to temporarily create a pool for reporting and
resource leveling purposes then unattach afterwards to allow PMs to safely
take files away to clients, sites etc.

--

Rod Gill
Microsoft MVP for Project

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

Rob Schneider

I also find by using a protocol which keeps the files in exactly the
same place (from Project's perspective) works (knock on wood) to avoid
corruption problems. Make Project *think* "no change" in file name,
versions, etc.

--rms

www.rmschneider.com
 
E

EL MOVE

Hi Rob,

Could you explain deeper what is that "protocol" you use to make project
think that files doesn't have been moved?

Thank you so much

Best Regards

Ruben
 
R

Rob Schneider

I've found that, from Project's perspective, the files should always
have exactly the same file name all the time. It my be superstition and
I cannot "prove" it works (since it requires proving the negative case
of no corruption), but it seems to work to avoid file corruption issues
related to linked subproject and resource file.

Remember that Project stores the entire full path for linked files.
therefore avoid situations where file full path will change, depending
on the state of the computer connecting to the source of the files (file
server, SharePoint, local drive, etc.)

For example, a file on a file server could be:

Mapped Drive: L:\projects\projectA\mpp\example.mpp
UNC File: \\servername\\sharename\projects\projectA\mpp\example.mpp

In the above example the exact same file can look to Project as being
different. There are reports that when Project sees linked file name
changes then it leads to corruption.

So I try to ensure all files *look* to Project as being exactly the same
all the time by doing things like:

: Create a "standard" on the c: drive for all project files, e.g.
c:\projects\projectA\mpp\ for all mpp files for Project A.
: Put copies of those file onto a file server for backup and for others
on team to use (if appropriate)
: if others on team use, then they are required to *copy* the files down
from the File Server to their own c:\projects\projectA\mpp folder.
: all files for the project go there: shared resource files, subproject
files, master files.

Do not copy from source mpp files on file server into the person's
private profile space, e.g. in a folder under "My Documents". This is
because these full path names are different for each user, e.g. for me
on this XP machine it is C:\Documents and Settings\Rmschne\My
Documents\projects\projectA\mpp. note "rmschne", my login id, in the
path name. This will be different for each person and that will, I
think, confuse Project.

In larger team environments, I setup a library in SharePoint (or some
other collaboration tool that can do file version management). We check
out, then copy the files into to the designated space on the c: drive
for working on them. Then when done upload and check in. This approach
provides easy versions control for going back, file backups, etc. Even
better use a tool like Colligo to automate this file synchronisation
between SharePoint and the c: drive.

But at this point, I probably am going over the top in explaining it.
The basic thing is to keep it simple by making sure that Project always
sees all filenames it has linked to be always unchanging. That is
possible with the above "protocol" of finding an place where the file
neame never changes and use it for everyone.

--rms

www.rmschneider.com
 
M

Martin Bittner

" I have even used a macro to temporarily create a pool for reporting and
resource leveling purposes then unattach afterwards to allow PMs to safely
take files away to clients, sites etc. "

What do you mean exactly by that? Are you saying that the individual project didn't use the actual shared pool of resources on a daily basis?

With your macro, you temporarily created a pool (by reading all resources from all projects?) to use project's features (reporting, leveling, etc.) to test hypothesis and then unlinked every project?

If this is what you did, how could you be certain every project manager would spell every resources's name correctly or the same way?

We kinda played about 2 hours with a Resources Pool on a shared drive. We were 2 project managers creating test projects with the same resources pool and I gotta say it's far from ready to be used in a production environnement. So I would be interested in learning what you did with your macro.

Thanks
I have consolidated about 100 individual projects into a single 'Master
project' (using the Insert /project command). Each individual project is
linked to the master.
Also I have a resource pool and linked this to the master project (but
not individual projects). My thinking is that the resource pool should
now show resource usage but it actually doesnt show any usage atall.
Am I trying something that wont work or is there another way to set
things up?


--
shoppingboy
------------------------------------------------------------------------
shoppingboy's Profile: http://forums.techarena.in/members/117441.htm
View this thread: http://forums.techarena.in/microsoft-project/1243637.htm

http://forums.techarena.in
On Tuesday, September 08, 2009 10:25 AM Dale Howard [MVP] wrote:
shoppingboy --

You need to connect each of the 100 individual projects to the shared
resource pool file. Then you will see the usage data you want to see. Hope
this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top