It's all about the answers!

Ask a question

How to Import an attribute type of Item into RTC via a CSV file


Mike Ballard (681610) | asked Oct 06 '15, 3:38 p.m.
We have a custom attribute defined as follows.  We need to be able to import the values of the attribute which are references to existing RTC workitems.

Attribute Name: Driving RFC
Attribute Type: Item
Attribute ID: cris.drivingRfc

I have already tried the following formats for the CSV file based on the assumption that an Item is essentially a link.  The last attempt was with the <ID>: <Summary> (as this is how RTC exported the field).  However, none of this has worked yet, and I can’t seem to find any documentation covering this.

Attempted CSV Formats:
Id, Driving RFC
123, 456
123, #456
123, 456: Test RFC

Comments
1
sam detweiler commented Oct 06 '15, 5:24 p.m.

I don't think RTC provides any mechanism to hold another workitem ID in a field, so import probably will not work. the documented way is links.


Mike Ballard commented Oct 06 '15, 5:33 p.m.

Sam,

Thanks for the response.  We purposely used a built-in type of Item in order to avoid these types of issues.  The Item type allows you to create a singular reference to another work item in RTC as an attribute instead of a link.  For the most part, it seems to work pretty well until we tried importing values into the attribute. 

-Mike


sam detweiler commented Oct 06 '15, 5:40 p.m.

yeh, always fun trying to cover the entire use case.
you might try the UUID of the other workitem.  but I don't know an easy way to get that.

if you use my sample app to dump the attributes, I wonder what it would show for that attribute..  write a query to select the workitems to dump.

see the accepted answer code here
https://jazz.net/forum/questions/94776/assertionfailedexception-problem-with-getting-the-values-of-attributes

don't know if my code would handle 'item' anyhow.


Mike Ballard commented Oct 07 '15, 9:12 a.m.

I grabbed the values for the uniqueId, contextId, itemId, href and the reportableUrl via the RTC REST Reportable API and tried different methods of importing using those values as the reference for the Item.  Unfortunately, none of these worked.


sam detweiler commented Oct 07 '15, 10:52 a.m. | edited Oct 07 '15, 10:57 a.m.

I used my utility to dump out that kind of attribute  holding a workitem

processing for variable=saveitem attrib type=item kind=_meta custom attribute
                attribute id=com.sd.workitem.story.saveitem, type=item value=com.ibm.team.workitem.common.internal.model.impl.WorkItemHandleImpl@5b48f6b8 (stateId: <unset>, itemId: [UUID _wjUx4D7gEeSUIoZsNfPZ_g], origin: com.ibm.team.repository.client.internal.TeamRepository@33e1fcdc, immutable: true)

so it is holding the workitemHandle UUID.



sam detweiler commented Oct 07 '15, 10:57 a.m.

and if I do an Export, with that field and select internal value, it give me the UUID

CSV header
Approvals,"Found In","Id","saveitem","Severity","Summary"

a test approval: Pending (1 of 1),"","14","_wjUx4D7gEeSUIoZsNfPZ_g","Normal","test story"

so maybe UUID as input would work.


Mike Ballard commented Oct 07 '15, 3:17 p.m.

Sam,

I have tried using the itemId (UUID) as the input and it doesn't seem to work. 

I appreciate all of your help and ideas.


sam detweiler commented Oct 07 '15, 5:47 p.m.

yeh, tried it here too.. looks like import to item is not supported. altho export from is

showing 5 of 8 show 3 more comments

One answer



permanent link
Melissa Kivisto (2871121) | answered Oct 23 '15, 11:57 a.m.
edited Oct 23 '15, 12:00 p.m.
 This was determined to be a limitation, under work item 
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=372889 

A potential work around is to create a new attribute of type "Work Item" and update the csv to import to that attribute instead.  (You would have to update presentation editor, and optionally existing work items as well).
The format for importing to this attribute type is #WI_number
Example csv:
"Attribute Of Type Work Item"	
"#19"

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.