MSProject Fields Mapping Problem

MSProject Fields Mapping Problem

• Jake Massey

  I already did all to my mappging file: change encoding, change xml tags, etc. But I can't make my project work. Please, if anyone knows if TFS beta 3 have any bug with the integration with Project, tell me. Or if anyone knows how to solve this problem, tell me too.
  
  

• Julien T

  Hi,

       I was getting the exact error in MSProject:

  "Data at the root level is invalid. Line 1, position 1."

  and I downloaded the mapping xml file and to my disbelief the mapping file had one line Classification\......

  Now, I had other Team Projects that had a good mapping xml file so I copied the good xml into the bad one and uploaded it to the team project giving me the error. Voila! problem solved.

  Hope it helps.

  Thanks,

  
  
  

• feel

  Hi,

  In Notepad (or other application), choose UTF-8 encoding. Click on the dropdown in the file save as dialog box and select UTF-8 instead of the default Text Document.

  Hope this helps.

  
  
  

• abhivyas

  How can I save in a different encoding What is the best enconding for the xml project mapping files
  
  

• booga_boy

  Hi Dennis,

  I have exactly the same error than Hugo and I added only one line in my mapping file
  the line is :
  

  <Mapping WorkItemTrackingFieldReferenceName="MyCustomField.WBS" ProjectField="WBS" ProjectName="WBS" />
  
  

  
  

• Bobby Fu

  Could you also send us the first line in the mapping file

  Thanks

  
  

• Grateful

  I'm getting a problem seemed as yours. I am trying to add an new field that I created. My field is not from thte type PlainText or HTML. So I really don't know what is the problem. I'm geeting this error message when i try to open my work item with project:

  "Data at the root level is invalid. Line 1, position 1."

  Please, tell anything that can help me!

  
  
  

• Bartosz

  The contents look ok.

  Did you try saving the file again with a different encoding

  
  

• MarkPaxton

  rupakg,

  Did you use the alpha version of the Process Template editor that a 3rd party released

  Another TFS customer hit an issue with that tool creating an incomplete template which manifested itself in a similar way.

  
  
  

• Gavin T.D. Greig

  Sam Heald wrote:

  rupakg, Did you use the alpha version of the Process Template editor that a 3rd party released Another TFS customer hit an issue with that tool creating an incomplete template which manifested itself in a similar way.

  Hi,

  My problem was not due to any customisation to the process templates. I used MSF Agile out of the box but still my mapping.xml files got corrupted as I mentioned in my earlier posts. And, I did look at the Process Template Editor and the new version looks very cool. There are still many things it need to do before it is complete.

  
  
  

• MTM

  Hi Hugo,

  This sounds like a schema validation error (XML doesn't match what is expected). Can you post your mapping file

  Thanks,

  -Dennis

  
  

• Mojtaba

  This is my mapping file:

  < xml version="1.0" encoding="utf-8" >
  <MSProject>
  <Mappings>
  <Mapping WorkItemTrackingFieldReferenceName="System.Id" ProjectField="pjTaskText10" ProjectName="Work Item ID"/>
  <Mapping WorkItemTrackingFieldReferenceName="System.Title" ProjectField="pjTaskName" />
  <Mapping WorkItemTrackingFieldReferenceName="System.WorkItemType" ProjectField="pjTaskText24" />
  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Discipline" ProjectField="pjTaskText17" />
  <Mapping WorkItemTrackingFieldReferenceName="System.AssignedTo" ProjectField="pjTaskResourceNames" />
  <Mapping WorkItemTrackingFieldReferenceName="Fabrica.Duracao" ProjectField="pjTaskDuration" /> -->
  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.CompletedWork" ProjectField="pjTaskActualWork" ProjectUnits="pjHour"/>
  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour"/>
  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.StartDate" ProjectField="pjTaskStart" />
  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.FinishDate" ProjectField="pjTaskFinish" />
  <Mapping WorkItemTrackingFieldReferenceName="System.State" ProjectField="pjTaskText13" />
  <Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />

  <ContextField WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.TaskHierarchy"/>
  <SyncField ProjectField="pjTaskText25" />
  <LinksField ProjectField="pjTaskText26" />

  
  </Mappings>
  </MSProject>
  

  
  
  

• Glenn Slayden

  Could you try changing the encoding from ANSI to unicode or vice versa (open in notepad)

  Please let us know if that helps.

  
  

• Ickman

  Hi,

  A couple of items to note here:

  - You cannot map fields that are of type="PlainText" or of type="HTML" in the WIT system to MS Project. Unfortunately, this is not supported in TFS v1. Note that all MS Project fields except for the 'Notes' field are restricted to 255 characters.

  - You cannot map fields to the MS Project Notes field in TFS v1. The Notes field in MS Project is very special. It can contain different OLE objects including pictures and embedded Word documents. Hence, it is a significant challenge to roundtrip and maintain that information between MS Project and WIT

  - We have a bug where there is a bad error message when you try to map System.Description. Thanks for finding that.

  The workaround, if you want to include long bits of text for a work item are:

  - Use the Links and Attachments functionality to attach a document or a file

  - Export the work items into MS Excel where it is possible to roundtrip fields like System.Description

  Please let me know what you think of these workarounds and thoughts on what you would like to see in future versions of TFS with regard to this functionality.

  Thanks,

  -Siddharth

  
  
• MSProject Fields Mapping Problem