problem importing category

Robert Thompson (31●2●7●4) | asked Sep 13 '10, 12:17 p.m.

I've got everything importing from ClearQuest 7.1.1 to RTC 2.0.0.2 just fine except the category.

if I have the following:


&lt;attribute sourceId=&quot;Project&quot; targetId=&quot;com.ibm.team.workitem.attribute.category&quot;&gt;

  &lt;value sourceId=&quot;*&quot; targetId=&quot;&quot; /&gt; 

&lt;/attribute&gt;

The records import, but Filed Against is 'Unassigned'.

The import adds to the work item categories list, but will not set the value for the records.

If I don't add then nothing imports.

 &lt;value sourceId=&quot;*&quot; targetId=&quot;&quot; /&gt;

Not sure what to do next?

9 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Lorelei Ngooi (1.5k●2●2) | answered Sep 14 '10, 10:38 a.m.
JAZZ DEVELOPER

Having this value mapping in the category mapping means regardless of the value of the sourceId, the targetId should be set to the empty string which will result in the Unassigned category value.


  &lt;value&gt;

You need to remove this value mapping.

Also, verify in the process configuration that you have the proper permissions when saving a work item.

0	permanent link Lorelei Ngooi (1.5k●2●2) \| answered Sep 14 '10, 10:40 a.m. JAZZ DEVELOPER Sorry, I meant to remove the following value mapping: <value sourceId="*" targetId="" />

permanent link

Robert Thompson (31●2●7●4) | answered Sep 14 '10, 12:20 p.m.

Thanks, I think I have the right permissions - the user importing is a "scrum master" and when I remove the line, nothing imports with no errors that I can find.

I've even tried <value sourceId="*" targetId="Migrated" /> without success.

It does appear to be permission, where should I check for correct permissions?

permanent link

Lorelei Ngooi (1.5k●2●2) | answered Sep 14 '10, 3:40 p.m.
JAZZ DEVELOPER

Actually, I take back what I said about permissions. I think you have the correct permissions set, otherwise, you would have gotten a permissions error when importing.

Try the following experiment:

1). Remove the category value mapping so that you should only have the following category property mapping:

<attribute sourceId="Project" targetId="com.ibm.team.workitem.attribute.category" />

2). Import into a zip file and verify the contents of the Project field.

3). Import into the RTC project area using the zip file and the modified data mapping.

4). Check the value of the filed against field.

permanent link

Robert Thompson (31●2●7●4) | answered Sep 14 '10, 4:20 p.m.

Nothing added to the RTC project area and no errors. Here is an example of the exported XML I'm trying to import:

<xml>
- <bugzilla>
- <bug>
<dbid>33554869</dbid>
<bug_id>TECHR00000437</bug_id>
<Classification>Defect</Classification>
<Headline>Applet Viewer</Headline>
<Release_Build>7.5.01</Release_Build>
<Severity14>2 - High</Severity14>
<CR_Type>Functionality</CR_Type>
<Discovered>System</Discovered>
<State>Closed</State>
<Description>This defect is submittted to document a possible memory leak with the java plug-in. I've attached the error logs with the Out of memory error. Possible solutions is to upgrade the plugin to 1.4.2.06 and adjust Java runtime parameters.</Description>
+ <attachment>
<attachid>Cov error.txt</attachid>
<desc>
<filename>Cov error.txt</filename>
<size>1191</size>
</attachment>
+ <attachment>
<attachid>MEMBER ANNOTATE.txt</attachid>
<desc>
<filename>MEMBER ANNOTATE.txt</filename>
<size>1046</size>
</attachment>
+ <attachment>
<attachid>ar VIEW RECORDS.txt</attachid>
<desc>
<filename>ar VIEW RECORDS.txt</filename>
<size>3670</size>
</attachment>
+ <long_desc>
<who>james.a.price@navy.mil</who>
<bug_when>0005-03-04 01:36 -0600</bug_when>
<thetext>Installing Java plug-in 1.4.2.07 seems to have corrected this problem.</thetext>
</long_desc>
<history>3/2/05 9:12:17 AM CST</history>
<Resolution>Fixed Indirectly</Resolution>
<history>pricej</history>
<Project>Selection Boards</Project>
<Steps_to_Reproduce>Use the applet viewer as various roles and watch the performance degrade over time (icons not showing up, annotations, etc)</Steps_to_Reproduce>
<Owners>Jim Price</Owners>
</bug>
</bugzilla>

If I exclude that line, everything else seams to work - I've mapped all users to bob so far, but this is also working:

Summary Applet Viewer
Status Verified
Resolution Fixed Upstream
Description This defect is submittted to document a possible memory leak with the java plug-in. I've attached the error logs with the Out of memory error. Possible solutions is to upgrade the plugin to 1.4.2.06 and adjust Java runtime parameters.
Severity 2 - High
Found In 7.5.01
Project Area Test
Comments Installing Java plug-in 1.4.2.07 seems to have corrected this problem.
Imported from TECHR00000437.
Severity was: 2 - High
Added: attachment 42 (Cov error.txt), attachment 43 (MEMBER ANNOTATE.txt), attachment 44 (ar VIEW RECORDS.txt)
Origin (Bugzilla) Bugzilla TECHR00000437
Subscribed By added:
bob

Imported from TECHR00000437
Resolved By bob
Reproduce Steps Use the applet viewer as various roles and watch the performance degrade over time (icons not showing up, annotations, etc)

:?:

permanent link

Lorelei Ngooi (1.5k●2●2) | answered Sep 14 '10, 7:29 p.m.
JAZZ DEVELOPER

Are you saying if you exclude the following line from the mapping file that all the other fields are imported successfully but if you do include the line that no record is imported?

<attribute>

You probably need to include your data mapping file.

permanent link

Robert Thompson (31●2●7●4) | answered Sep 15 '10, 9:53 a.m.

Yes, that is was is happening. Here is the mapping file:

&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; standalone=&quot;yes&quot; ?&gt;



    &lt;!--

        *** Attachments &amp; Notes_log imported if they exists *** 

        

    Usage&#58;

    - Removal of an &lt;attribute&gt; element will disable the import of the corresponding attribute

    - Custom attributes will be added to the target work item if necessary

    - Custom attributes are not created if they do not already exist in the corresponding project area

    - If no explicit mapping for a value exists the mapping for source id &quot;*&quot; will be used if it exists

    - Using source id &quot;*&quot; with an empty target id can be used to ignore unknown values

    - If no explicit or &quot;*&quot; mapping for a value exists the original value will be used         

    --&gt;



&lt;mapping version=&quot;1&quot;&gt;



    &lt;attribute sourceId=&quot;State&quot; targetId=&quot;com.ibm.team.workitem.attribute.state&quot;&gt;

        &lt;value sourceId=&quot;Submitted&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Assigned&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Opened&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Postponed&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Impacted&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Fixed&quot; targetId=&quot;3&quot; /&gt;

        &lt;value sourceId=&quot;Resolved&quot; targetId=&quot;3&quot; /&gt;

        &lt;value sourceId=&quot;Delivered_to_Test&quot; targetId=&quot;3&quot; /&gt;

        &lt;value sourceId=&quot;Closed&quot; targetId=&quot;4&quot; /&gt;

        &lt;value sourceId=&quot;Duplicated&quot; targetId=&quot;4&quot; /&gt;

        &lt;value sourceId=&quot;*&quot; targetId=&quot;0&quot; /&gt;

    &lt;/attribute&gt;



    &lt;attribute sourceId=&quot;Resolution&quot; targetId=&quot;com.ibm.team.workitem.attribute.resolution&quot;&gt;

        &lt;value sourceId=&quot;&quot; targetId=&quot;0&quot; /&gt;

        &lt;value sourceId=&quot;Fixed&quot; targetId=&quot;1&quot; /&gt;

        &lt;value sourceId=&quot;Duplicate&quot; targetId=&quot;2&quot; /&gt;

        &lt;value sourceId=&quot;Functions as Designed&quot; targetId=&quot;3&quot; /&gt;

        &lt;value sourceId=&quot;Enhancement Request&quot; targetId=&quot;5&quot; accurate=&quot;false&quot; /&gt;

        &lt;value sourceId=&quot;Fixed Indirectly&quot; targetId=&quot;8&quot; /&gt;

        &lt;value sourceId=&quot;*&quot; targetId=&quot;0&quot; /&gt;

    &lt;/attribute&gt;

    

&lt;!--

      &lt;attribute sourceId=&quot;Project&quot; targetId=&quot;com.ibm.team.workitem.attribute.category&quot;/&gt;

         &lt;value sourceId=&quot;*&quot; targetId=&quot;&quot; /&gt;

      &lt;/attribute&gt;    

 --&gt;      

    &lt;attribute sourceId=&quot;history.action_timestamp&quot; targetId=&quot;com.ibm.team.workitem.attribute.creationdate&quot; /&gt;

    &lt;attribute sourceId=&quot;Resolved&quot; targetId=&quot;com.ibm.team.workitem.attribute.resolutiondate&quot; /&gt;



    &lt;attribute sourceId=&quot;Classification&quot; targetId=&quot;com.ibm.team.workitem.attribute.workitemtype&quot;&gt;

        &lt;value sourceId=&quot;Defect&quot; targetId=&quot;defect&quot; /&gt;

        &lt;value sourceId=&quot;Requirements Change&quot; targetId=&quot;defect&quot; /&gt;

        &lt;value sourceId=&quot;Enhancement&quot; targetId=&quot;defect&quot; /&gt;

    &lt;/attribute&gt;



    &lt;attribute sourceId=&quot;Headline&quot; targetId=&quot;com.ibm.team.workitem.attribute.summary&quot; /&gt;

    &lt;attribute sourceId=&quot;Description&quot; targetId=&quot;com.ibm.team.workitem.attribute.description&quot; /&gt;

    

    &lt;attribute sourceId=&quot;Steps_to_Reproduce&quot; targetId=&quot;reproduce&quot; /&gt;



    &lt;attribute sourceId=&quot;history.user_name&quot; targetId=&quot;com.ibm.team.workitem.attribute.creator&quot; /&gt;

    &lt;attribute sourceId=&quot;Owners&quot; targetId=&quot;com.ibm.team.workitem.attribute.owner&quot; /&gt;

    &lt;attributeType targetId=&quot;contributor&quot;&gt;

        &lt;value sourceId=&quot;harrisk&quot; targetId=&quot;bob&quot; /&gt;

        &lt;value sourceId=&quot;fleenorj&quot; targetId=&quot;bob&quot; /&gt;

        &lt;value sourceId=&quot;hedgepethp&quot; targetId=&quot;bob&quot; /&gt;

        &lt;value sourceId=&quot;christyc&quot; targetId=&quot;bob&quot; /&gt;

        &lt;value sourceId=&quot;Mindee Wolven&quot; targetId=&quot;bob&quot; /&gt;

        &lt;value sourceId=&quot;*&quot; targetId=&quot;&quot; /&gt;

    &lt;/attributeType&gt;



    &lt;attribute sourceId=&quot;Priority&quot; targetId=&quot;com.ibm.team.workitem.attribute.priority&quot; /&gt;

    &lt;attributeType targetId=&quot;priority&quot;&gt;

        &lt;value sourceId=&quot;1 - High&quot; targetId=&quot;priority.literal.l11&quot; /&gt;

        &lt;value sourceId=&quot;2 - Medium-High&quot; targetId=&quot;priority.literal.l07&quot; /&gt;

        &lt;value sourceId=&quot;3 - Medium&quot; targetId=&quot;priority.literal.l07&quot; /&gt;

        &lt;value sourceId=&quot;4 - Medium-Low&quot; targetId=&quot;priority.literal.l07&quot; /&gt;

        &lt;value sourceId=&quot;5 - Low&quot; targetId=&quot;priority.literal.l02&quot; /&gt;

        &lt;value sourceId=&quot;*&quot; targetId=&quot;priority.literal.l01&quot; /&gt;

    &lt;/attributeType&gt;



    &lt;attribute sourceId=&quot;Severity14&quot; targetId=&quot;com.ibm.team.workitem.attribute.severity&quot; /&gt;

    &lt;attributeType targetId=&quot;severity&quot;&gt;

        &lt;value sourceId=&quot;1 - Catastrophic&quot; targetId=&quot;severity.literal.l5&quot; /&gt;

        &lt;value sourceId=&quot;2 - Major&#58; No Work-around&quot; targetId=&quot;severity.literal.l4&quot; /&gt;

        &lt;value sourceId=&quot;3 - Major&#58; With Work-around&quot; targetId=&quot;severity.literal.l3&quot; /&gt;

        &lt;value sourceId=&quot;4 - Minor&quot; targetId=&quot;severity.literal.l2&quot; /&gt;

        &lt;value sourceId=&quot;5 - Cosmetic&quot; targetId=&quot;severity.literal.l2&quot; /&gt;

        &lt;value sourceId=&quot;6 - Internal&quot; targetId=&quot;severity.literal.l1&quot; /&gt;

        &lt;value sourceId=&quot;N/A&quot; targetId=&quot;severity.literal.l1&quot; /&gt;

    &lt;/attributeType&gt;

    

    &lt;attribute sourceId=&quot;Release_Build&quot; targetId=&quot;com.ibm.team.workitem.attribute.version&quot;/&gt;

    

    &lt;attribute sourceId=&quot;Production_Release&quot; targetId=&quot;com.ibm.team.workitem.attribute.target&quot; /&gt;

    

    &lt;attribute sourceId=&quot;Classification&quot; targetId=&quot;com.ibm.team.workitem.attribute.tags&quot;/&gt;

    &lt;attributeType targetId=&quot;tags&quot;&gt;

        &lt;value sourceId=&quot;Requirements Change&quot; targetId=&quot;Requirements_Change&quot; /&gt;

        &lt;value sourceId=&quot;Enhancement&quot; targetId=&quot;Enhancement&quot; /&gt;

        &lt;value sourceId=&quot;*&quot; targetId=&quot;&quot; /&gt;

    &lt;/attributeType&gt;

    

    &lt;attribute sourceId=&quot;DuplicateOf&quot; targetId=&quot;com.ibm.team.workitem.rcp.core.is_dup_of&quot;/&gt;

    &lt;attribute sourceId=&quot;Duplicated_By&quot; targetId=&quot;com.ibm.team.workitem.rcp.core.duplicates&quot;/&gt;

    

&lt;/mapping&gt;

0	permanent link Lorelei Ngooi (1.5k●2●2) \| answered Sep 15 '10, 11:04 a.m. JAZZ DEVELOPER I think we need to take a closer look at your environment. Please open a ticket with support.

0	permanent link Robert Thompson (31●2●7●4) \| answered Sep 15 '10, 1:53 p.m. Thanks, the support ticket number is 90706 005 000

Your answer

Register or log in 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.

It's all about the answers!

Related questions

problem importing category

9 answers

Your answer