It's all about the answers!

Ask a question

How to import attachments into RTC?


T M (8876187143) | asked Jul 30 '12, 7:49 p.m.
edited Jul 31 '12, 4:49 p.m. by Jared Burns (4.5k29)

I'm importing work items from a different defect tracking tool to RTC. The question is to find out how to import attachments?

Thanks!


Comments

4 answers



permanent link
Henning Sternkicker (40626) | answered Jul 31 '12, 7:19 a.m.
JAZZ DEVELOPER
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

permanent link
T M (8876187143) | answered Jul 31 '12, 12:11 p.m.

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!


permanent link
Henning Sternkicker (40626) | answered Aug 01 '12, 4:06 a.m.
JAZZ DEVELOPER
edited Aug 01 '12, 4:09 a.m.
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?






















permanent link
Krzysztof Kaźmierczyk (7.4k35699) | answered Jan 14 '14, 6:11 a.m.

Your answer


Register or to post your answer.