AnsweredAssumed Answered

PM name with more than one similar names

Question asked by venkitta.subramanian on Mar 27, 2012
Latest reply on Mar 30, 2012 by another_martink
CA-Clarity V12.1.1

I have an interesting situation...

We have the same resource name as an Associate and a Contractor, example: 1) David Johnson (user id: djohn01) 2) David Johnson (user id: djohn02). First one is the associate and later is the contractor.

On the Project List page, there is no user id captured for the project manager name.

My requirement is to get the PM name and role name. So I pull all the projects from the project list page portlet and all resource data from resource list page portlet

So, when I match the PM name with the resource name to get the role, I get two match, so the vlookup function in excel pick the first available match and I get the Contractor role instead of associate role.

Please note that, we have contractors also managing projects.

Is there anyway to get the PM user id from the project list page?

Any thoughts!!!

Thanks
-Venkitta

Outcomes