It's all about the answers!

Ask a question

How do I map clearquest user to a different user in RTC when importing CQ records?

Karl Weinert (2.0k52736) | asked Mar 06 '13, 1:12 p.m.
retagged Mar 12 '13, 1:18 p.m. by Hadar Hawk (1882214)
I want to be able to map the CQ owner to a different owner in RTC but it always uses the owner from the CQ record.
So in my example below the new Work Item is always owned by admin.
I want to convert admin to my account karl
I'm following Migrating Rational ClearQuest records to work items

Here's my mapping file:
<?xml version="1.0" encoding="UTF-8"?>
<mapping version="1">
    <attribute sourceId="id" targetId="">
    <attribute sourceId="Owner" targetId=""/>
    <attributeType targetId="contributor">
        <value sourceId="admin" targetId="karl"/> 
     <attribute sourceId="Description" targetId=""/>

Here's the exported CQ record:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<bugzilla version="3.3" urlbase="">
    <Description>Test RTC Import</Description>

One answer

permanent link
Matthew Alexander (18126) | answered Mar 06 '13, 4:11 p.m.
Hi Karl,

I think the problem could be because the sourceId fields are case sensitive.  In your mapping file, <attribute sourceId="Owner" has "Owner" capitalized, while <owner> in your xml is lowercase.  Try changing the mapping file to <attribute sourceId="owner" and let me know if you still have problems.


Karl Weinert commented Mar 06 '13, 4:27 p.m.

Hi Matt,
I set this
    <attribute sourceId="owner" targetId=""/>

But then the owner gets set to Unassigned.

Matthew Alexander commented Mar 06 '13, 4:48 p.m.

Hi Karl,

One more thing I noticed is that the "Created By" field has "Karl" with a capital K, while the mapping has "karl".  If this is the same user, I'm thinking the mapping file should be capitalized as well.

I think everything else looks good to me.  I did a quick test with xml that contained <owner>admin</owner> and used the mapping below.  It changed the owner for me.

<attribute sourceId="owner" targetId=""/>
    <attributeType targetId="contributor">
        <value sourceId="admin" targetId="karl"/>     

Let me know if you still have problems.

Your answer

Register or to post your answer.