CSV Import to "Filed Against" field
Hi everyone,
I need to import a number of work items from a CSV file into RTC. The mapping I have created, however, does not seem to work. Lets assume that the value read from the CSV file will be "Test." I noticed in Categories tab that all of my categories fall under a root category called "Unassigned."
To import these values, I have tried:
<value sourceId="Test" targetID="Test" />
<value sourceId="Test" targetID="Unassigned/Test" />
Neither of these seem to work. I tried setting the field manually and exporting the work item's Filed Against field's internal value, but that gave me a value something like _Y0BWgAghEe.
Is this field mapping supposed to map to some sort of path (like the Planned For field) or some internal value such as priority.literal.l11 (the ID for the High priority value), or something else entirely?
Thanks,
- Josh
I need to import a number of work items from a CSV file into RTC. The mapping I have created, however, does not seem to work. Lets assume that the value read from the CSV file will be "Test." I noticed in Categories tab that all of my categories fall under a root category called "Unassigned."
To import these values, I have tried:
<value sourceId="Test" targetID="Test" />
<value sourceId="Test" targetID="Unassigned/Test" />
Neither of these seem to work. I tried setting the field manually and exporting the work item's Filed Against field's internal value, but that gave me a value something like _Y0BWgAghEe.
Is this field mapping supposed to map to some sort of path (like the Planned For field) or some internal value such as priority.literal.l11 (the ID for the High priority value), or something else entirely?
Thanks,
- Josh
Accepted answer
Hi Josh
The targetId should be the same value as the name of the Category you see in your Categories tab. You can ignore the "Unassigned" root, however, if there is another level between "Unassigned" and "Test", you'll need to include it, i.e. "Parent/Test".
Is the rest of the mapping xml correct? Assuming the header for this column in your csv is "Filed Against", the xml should look like:
<attribute sourceId="Filed Against" targetId="com.ibm.team.workitem.attribute.category">
<value sourceId="Test" targetId="Test"/>
</attribute>
The targetId should be the same value as the name of the Category you see in your Categories tab. You can ignore the "Unassigned" root, however, if there is another level between "Unassigned" and "Test", you'll need to include it, i.e. "Parent/Test".
Is the rest of the mapping xml correct? Assuming the header for this column in your csv is "Filed Against", the xml should look like:
<attribute sourceId="Filed Against" targetId="com.ibm.team.workitem.attribute.category">
<value sourceId="Test" targetId="Test"/>
</attribute>
Comments
