How to Import an attribute type of Item into RTC via a CSV file
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
showing 5 of 8
show 3 more comments
|
One answer
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" |
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.
Comments
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.
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
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.
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.
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.
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"
so maybe UUID as input would work.
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.
yeh, tried it here too.. looks like import to item is not supported. altho export from is