Custom fields for resource groups

[Sebastian Cordoba]

[Project 2007] Hi Everyone.

I'd like to know if Project has custom fields for Resource groups. For
example: I have Resource 1 and Resource 2 and both belong to the "IT" Group.
In this case, can I write something like IT.Number1 or IT.Text2?

What I need to do is saving (monthly) the value of several indicators for
each group (wich I calculate via code), so that I can track that value
through the year.

Or custom fields are available only for Resource (and Task) objects? What
would you suggest?

Thanks in advance.

 

[Andrew Lavinsky]

You might need to provide some clarification. Custom fields are available
at the resource level but can be rolled up to any group level using the Project

Group feature.

That will give you a summary calculation for any group of resources....

Does that answer your question? If you provide a specific example of an
indicator you're looking for, I could provide more details.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

[Project 2007] Hi Everyone.

I'd like to know if Project has custom fields for Resource groups. For
example: I have Resource 1 and Resource 2 and both belong to the "IT"
Group. In this case, can I write something like IT.Number1 or
IT.Text2?

What I need to do is saving (monthly) the value of several indicators
for each group (wich I calculate via code), so that I can track that
value through the year.

Or custom fields are available only for Resource (and Task) objects?
What would you suggest?

Thanks in advance.

 

[Sebastian Cordoba]

Hi Andrew.

I'm gonna explain myself better:I created a macro which calculate certain
indicator (Custom Number Field) for every resource and then rolls up the
results according to the Resource Groups: Group feature doesn't work for this
indicator. But it ain't the problem. The real problem is this: I want to keep
a record of the value that every Resource Group has for every month of the
current year. I don't know where to save this value because, in fact, I have
three different indicators which means 36 values through the year.

For that reason I thought that maybe Resource Groups had custom fields, so
that I could keep the value for the first month in Number 1 field, second
month in Number 2, and so on. What do you suggest? Where can I save this
value?

Moreover, I'd like to know how to access the custom fields of the Project
via code, I mean, the same fields that I can edit from Project server as
Project level custom fields. Right now I have Project Standard so I don't
know how to access those fields (my intention is keeping the number of the
current month in one of those fields).

Thanks in advance. I hope you get my point.

 

[Rod Gill]

The only way to edit custom fields in Project Server is via the PSI
interface. See the Project SDK, its a free download from MSDN.,

I think your only solution is to either save the values in a text field with
comma separation or store them in a database and use OLEDB to read and write
the data,

Project Standard cannot work with project Server, you need Project
Professional to work with Project Server.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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

Hi Andrew.

I'm gonna explain myself better:I created a macro which calculate certain
indicator (Custom Number Field) for every resource and then rolls up the
results according to the Resource Groups: Group feature doesn't work for
this
indicator. But it ain't the problem. The real problem is this: I want to
keep
a record of the value that every Resource Group has for every month of the
current year. I don't know where to save this value because, in fact, I
have
three different indicators which means 36 values through the year.

For that reason I thought that maybe Resource Groups had custom fields, so
that I could keep the value for the first month in Number 1 field, second
month in Number 2, and so on. What do you suggest? Where can I save this
value?

Moreover, I'd like to know how to access the custom fields of the Project
via code, I mean, the same fields that I can edit from Project server as
Project level custom fields. Right now I have Project Standard so I don't
know how to access those fields (my intention is keeping the number of the
current month in one of those fields).

Thanks in advance. I hope you get my point.

__________ Information from ESET Smart Security, version of virus
signature database 4707 (20091221) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4707 (20091221) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Sebastian Cordoba]

Hi Rod.

Thanks for your reply. Rod, does it mean that Project Level custom fields
are available only on Project Server? I wrote the following lines but none of
them worked for what I want:

- Option 1: Activeproject.Number1
- Option 2: Dim pro As Project --> pro.Number1

That's my concern: how do (where do) I save a numerical value as a property
of the project? (in this case the number of the current month)

Thanks!

 

[Jan De Messemaeker]

Hi,

Activeproject.projectsummarytask.text7
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

Number1 is a local custom field and isn't created or reported on by Project
Server. Jan's method is all you need: Activeproject.projectsummarytask.text7
and use it to store all monthly values, EG: 2,4,3,4,2

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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

Hi Rod.

Thanks for your reply. Rod, does it mean that Project Level custom fields
are available only on Project Server? I wrote the following lines but none
of
them worked for what I want:

- Option 1: Activeproject.Number1
- Option 2: Dim pro As Project --> pro.Number1

That's my concern: how do (where do) I save a numerical value as a
property
of the project? (in this case the number of the current month)

Thanks!

__________ Information from ESET Smart Security, version of virus
signature database 4710 (20091222) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4710 (20091222) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Sebastian Cordoba]

Thank you guys for your help!