How to import TFS Users as Project Resources

How to import TFS Users as Project Resources

• Eddie Smith

  Yogita

  Do you know if the KB article you referenced has been released yet If so, can you provide the reference number so that I can find it online

  Thank you,

  Ron L

  
  
  

• double americano

  Ron,

  Do let me know if the fix you got from Product support on this issue resolved the problem.

  Thanks!

  
  
  

• billmac3

  I understood that part to mean, there was a field in your work item called MS Project Resources, that was kind of a copy of the AssignedTo field, minus the commas. That new field, MS Project Resources, is what would be mapped to MS Project's Resource field. Maybe I misunderstood the solution given in that post. Either way, I do not know how Project does mapping internally.

  Maybe Yogita could provide a little more clarification on what the actual solution posed in that link was.

  
  

• AMSS

  I'm not sure what fix will be there in the knowledge base, but you can try the following to make sure The new field MS Project Resources and Assigned to Field are in sync without manual copying.

  You can write a VBA macro and ship that to everyone who uses MS Project integration. But this would also mean that you will always have to work from the file that contains the macro.

  In the macro in the MS Project Field, you can write code to copy the name from text field (which is mapped to Assigned To) to Resource Names field (which is mapped to MS Project Resources field of WIT) after removing the comma. You can wrire this code for some event like OnSave or OnChange.

  This will make the copying automatic and you won't have to worry about syncing the two fields

  Cheers

  Sanjay

  
  

• madd

  Yogita

  I am not sure what the fix you are referring to is, can you post a link to it, please

  Thanks,

  Ron L

  
  
  

• Noah Khan

  Ron,

  A KB article on this issue will be released in the next couple of weeks. Meanwhile, you can call CSS and ask them for the fix for the TFS Project comma issue.

  Let me know if you have any trouble obtaining the fix or if it resolve the issue.

  
  
  

• Marty1066

  Douglas

  Thanks for the response. I have looked at the post you reference, and I don't think that changing the delimiter is going to be effective for us. Do you have more information on the text field workaround Are you somehow changing the type of the Resource Name field, or adding a new field and changing the mapping to TFS

  Any assistance you can render in this would be appreciated.

  Thanks,

  Ron L

  
  
  

• John Portnov

  Here is a thread with a different explanation of the second work around. I personally have not had to deal with this issue yet, but I'm sure my time is coming. I've given this a lot of thought, but have yet to come up with anything better than what has already been suggested.

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=274413&SiteID=1

  Good luck

  Doug

  
  

• afel

  Doug

  Thanks for the link, that will definitely help the TFS to Project mapping. If I understood the first link correctly however, there was also a mapping internal to Project ("MS Project Resources" to "Resource Name"). Do you have any information on how that is done

  Thanks,

  Ron L

  
  
  

• Need_Helpss

  I have seen many threads on this issue. This one suggests some possible work arounds.
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=277816&SiteID=1

  
  

• Bloke

  Yogita

  The link that Doug referenced is a start, but it leaves a lot of questions. For instance, it refers to adding a field ("MS Project Resource") to the Project file and mapping it to the resource field. Can you point me to a reference on how to do this I haven't been able to find how to map fields inside of Project.

  Thanks,

  Ron L

  
  
  

• wPa

  Hello Ron,

  The field MS Project Resources exists in Project, not in TFS. Here is a list of steps, hope it clarifies things:

  • Update Mapping.xml to map "assigned to" a regular text field in MS Project.
  • Update Mapping.xml to map ResourceName field in MS Project to a field (MS Project Resources) that is driven by a WIT list that contains project friendly user names.
  • Rountrip both and manually manage the mappings so that they will not be out of sync.

  There is significant manual work involved in syncing these fields. Have you looked at the fix that our support team is providing to handle this issue

  Thanks!

  
  
  

• aaguiar

  You can do this in the Process Template. In the "Classification" folder, there is a file called FileMapping.xml that maps work item fields to MS Project fields. In that file there is a line that maps System.AssignedTo to the project field pjTaskResourceNames. This link to MSDN also might be helpful.

  http://msdn2.microsoft.com/en-us/library/ms404684(VS.80).aspx

  Doug

  
  

• Memo.CPP

  Doug

  I had thought (there you go thinking again - it always gets you in trouble) that it was an MS Project, since the directions are to map AssignedTo to a text field (how do I do this ) and then add another field... Essentially, the problem appears to be Project's handling of the seperator in the name list.

  As you said, hopefully Yogita or someone else can provide some amplifying information.

  Ron L

  
  
  
• How to import TFS Users as Project Resources