It's all about the answers!

Ask a question

[closed] Not able to create link for "resolved by" by using csv import method.

Varshitha Ramamurthy (11) | asked Oct 31 '22, 7:39 a.m.
closed Nov 02 '22, 7:33 a.m. by Ralph Schoon (63.2k33646)

The CSV import method is used to create link for the different work items, in which "parent" and "child" links are getting linked to the selected work items, but "resolved by" is not getting linked. In both cases the csv format given is same.

1]Format in CSV to link parent or child:
Type                             Id                          Parent              
Story                       1114757                   #1114759:Plugin Test result
The link got created in work item.

2]Format in CSV to link parent or child:
Type                             Id                                Resolved By               
Task                          939185                          #941791:Test Desc limit.
The link is not getting created and following error is shown.
No mapping found for column named "Type,Id,Resolved By"
The CSV file is missing a proper identifier attribute "Id". The desired work item cannot be retrieved.

The question has been closed for the following reason: "Duplicate Question" by rschoon Nov 02 '22, 7:33 a.m.

One answer

permanent link
Ralph Schoon (63.2k33646) | answered Oct 31 '22, 8:46 a.m.

 See the error message: No mapping found for column named "Type,Id,Resolved By"

It looks as if the import does not recognize the columns. 
1. Use a specific delimiter such as ,
2. Let the values be exported with quote characters

You explanation looks as if it is tab separated, but the error message uses commas, so what is it?