How to import attachments into RTC?

There is an older thread about this topic with some hints here : https://jazz.net/forum/questions/61133/how-to-import-attachments

The thread basically points to this article : https://jazz.net/library/article/69
The Bugzilla Importer should be used for such imports, as it is able to handle attachments.

Hope that helps,

Henning

Hi,

 

Below is my CSV file (sample one).

 

"Type","Id","Status","Priority","Severity","Summary","Owned By","Created By"

"Task","49","New","Unassigned","Normal","Test Import","user1","user2"

 

In addition to creating a work item in RTC (Import from CSV) I need to attach a file – “file1.txt” to the work item that will get created from the above CSV format. Will someone please let me know the exact steps?

 

Thanks!

I tried it with the steps that are mentioned in this article https://jazz.net/library/article/69
it is key, that you use the Bugzilla importer (Please read the section at the end "Import via Bugzilla Importer" and follow the steps:
1. prepare a xml file for each bug that should be imported
2. store each attachment in a folder that has the id of the bug as name
3. create a zip-file that contains the xml and the folder with the attachments
4. Use RTC-Eclipse Client -> Import->Team->Bugzilla-Importer and choose "import from zip-File"

with the following xml I was able to import your example:

<?xml version="1.0" standalone="yes" ?>
<bugzilla urlbase="http://bugs.yourcompany.com/">
    <bug>
        <bug_id>49</bug_id>
        <creation_ts>2007-03-26 14:48 -0400</creation_ts>
        <short_desc>Test import</short_desc>
        <delta_ts>2007-10-18 14:23:52 -0400</delta_ts>
        <bug_status>New</bug_status>
        <priority>P2</priority>
        <reporter>user2</reporter>
        <assigned_to>user1</assigned_to>
        <long_desc>
            <who>contributor2</who>
            <bug_when>2007-03-26 14:48:21 -0400</bug_when>
            <thetext>Comment content 0</thetext>
        </long_desc>
        <long_desc>
            <who>contributor1</who>
            <bug_when>2007-10-18 14:23:52 -0400</bug_when>
            <thetext>Comment content 1</thetext>
        </long_desc>
        <attachment>
            <attachid>file1.txt</attachid>
            <desc>Attachment description 1</desc>
        </attachment>
    </bug>
</bugzilla>

This is just a rough try, Priority will not be correctly mapped so there is need for a mapping file to do a bulk import. But it works for me, the attachment was correctly added with the steps described in the article.

Hope that helps?

There is also RFE to track importing attachments: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=250139