Resource Initials as Enterprise Field

[Studer]

After using MsProject Pro and PWA for a while I've realized that it would be
very usefull for me to have an Enterprise Project Field containing the
initials of all the resources used on a Project. This is specially usefull
when visualizing projects on PWA.

Any idea on how to do this?

I would be even better if I could have a field for all the resources of a
specified group, working on each project.

Thank's a lot

Studer

 

[Dale Howard [MVP]]

Studer --

In the future, please let us know what version of Project Server you are
using. 2002, 2003, or 2007? Regardless of what version you are using, you
could probably do this using a macro in VBA. If you want to explore this
route, please post your question in the microsoft.public.project.developer
newsgroup to let our developers take a stab at it. On the other hand, you
could also create a Data Analysis view in PWA (called a Portfolio Analyzer
view in Project Server 2002 and 2003) that shows the resources in each
project. To create this View, drop the Projects dimension and the Resources
dimension in the Row Fields drop area. Just a couple thoughts. Hope this
helps.

 

[Studer]

Thank's Dale,
I'm using 2003.

I'll post on the newsgoup you told me.

Thanks

 

[John Sitka]

ecf_Nickname(EnterpriseText7) is an Task enterprise custom field of type Text
Resource Initials are established in the resource pool

Sub ENG_WriteResourceInitialsTo_ecf_Nickname()
Dim T As Task
Dim TS As Tasks
Set TS = ActiveProject.Tasks
For Each T In TS
If Not T Is Nothing Then
If T.Assignments.Count <> 0 Then
T.EnterpriseText7 = T.ResourceInitials
End If
End If
Next T
End Sub