CSV Import Does Not Correctly Map Status

Hi everyone,

I am importing data from an old system to RTC. In the process I discovered that I needed to add an additional state to the Defect Workflow - Backlog. I have gone into the project management area/Defect Workflow, added Backlog as a state, as well as transitions to move work items to the backlog, and from the backlog to in process or resolved. I created a dummy work item, which started in the New state, and was able to place it in the backlog and, ultimately, resolve the work item.

I have created a custom xml mapping file to import tickets from the old system into RTC, and here is what I came up with for the status:

    <!-- Maps State to Status -->
    <attribute sourceId="State" targetId="com.ibm.team.workitem.attribute.state">
        <value sourceId="Backlog" targetId="Backlog"/>
    </attribute>

What this should do is go through my csv file, and any ticket I'm migrating with a state of "Backlog" should be imported as a work item with the status of "Backlog." This does not, however, change the state to the Backlog I created. The "State" drop down box does have the word "Backlog" written there, however clicking the drop down does not show me any of the options I created to change the state.

I exported and imported my previous testing work item (which seems to be functioning correctly) so that I could force RTC to show me an xml mapping file created from the data. Here is what it suggests:

    <attribute sourceId="Status" targetId="com.ibm.team.workitem.attribute.state">
        <value sourceId="Backlog" targetId="Backlog"/>
    </attribute>

The only difference I see is in the attribute sourceId, which is expected, since in my previous system the field is called "State." Any insight would be greatly appreciated.