It's all about the answers!

Ask a question

Not able to import links for work item using CSV.


Varshitha Ramamurthy (11) | asked Nov 02 '22, 6:47 a.m.

  1]I am trying to create "Resolved By" link using Import csv in RTC and the csv file contains below data.

Type,Id,Resolved By (WorkItem)
Task,939185,#941791:Test Desc limit
While importing I have selected, "File separated By" as Comma and "update existing work item".
 I get an error [No mapping found for column named "Resolved By (WorkItem)"]

2] Tried importing using quotes as below:
  Type,Id,Resolved By (WorkItem)
  "Task","939185","#941791:Test Desc limit"
While importing I have selected, "File separated By" as Comma and "update existing work item". 
I get the same error [No mapping found for column named "Resolved By (WorkItem)"].

One answer



permanent link
Ralph Schoon (63.2k33646) | answered Nov 02 '22, 7:32 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Nov 02 '22, 7:37 a.m.

 It is frowned upon, when the same question gets asked multiple times by the same user. You can close the other question if you want to ask again.


Here what I did to look into your question and what I see - very quickly.

1. I created a query that shows some work items e.g. 180 and 181. The query shows the ID, Summary, some other stuff and I added the resolved by as well as the resolves - the link Resolved By (Work item), both directions.
2. I exported the query in the Web UI to CSV. 
3. I opened the result which is TAB separated and the column values are all in "" parentheses. 
4. I deleted the link between the work items.
5. I used the EWM Client with exactly that file like this with the file I created as export


6. The file imported without any issue and the link was recreated.

I would suggest you try the same and then you play with leaving out a link end etc.


Comments
Ralph Schoon commented Nov 02 '22, 7:43 a.m. | edited Nov 02 '22, 7:45 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

In the CSV you specify the work item ID for the link creation using #workitemid e.g. #180.

Note that for me the link got also created when I selected Create a new work item. So the import process remembers the ID for the newly created item and apparently creates the link to the newly created item. 

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.