It's all about the answers!

Ask a question

How to import attachments into RTC?


T M (8878188143) | 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 (8878188143) | 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.5k480103) | answered Jan 14 '14, 6:11 a.m.

Your answer


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