Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CSV import of related links, parent, children ...

I'm running RTC 2.0.0.2 iFix 6 and I cannot figure out how to import a work item with related links and parent (by storing the content in the CSV file).

Is there a way to import from a CSV file that can build a work item structure and set related link content?

Also, is there a way to export the related links and parent/child ID to CSV or HTML? I don't see it in the column list.

0 votes



14 answers

Permanent link
CSV Importer is NOT meant to be used to migrate data, the use case is to
quickly create 10 work items or update existing work items.

On 02.08.2011 2:34, Benjamin Pasero wrote:
Attachments can only be imported from bugzilla.

On 02.08.2011 12:53, achal wrote:
The shared library link says that we can not import attachments using
CSV import. Do we have any work around for this?

P.S: We are migrating data from a legacy system to RTC and many
workitems in legacy system have attachments with them.

0 votes


Permanent link
Benjamin: If they created a zip file in the bugzilla format, could they
then use the bugzilla importer to import the work items with
attachments? Or alternatively, if they exported their work items into
bugzilla (with attachments), I assume they could then use the bugzilla
importer directly (but just creating the zip file would seem like the
more direct approach).

Note that work item 100993 asks for support for importing attachments.
Please feel free to add a comment indicating your interest/support.

Cheers,
Geoff

On 8/2/2011 8:34 AM, Benjamin Pasero wrote:
Attachments can only be imported from bugzilla.

On 02.08.2011 12:53, achal wrote:
The shared library link says that we can not import attachments using
CSV import. Do we have any work around for this?

P.S: We are migrating data from a legacy system to RTC and many
workitems in legacy system have attachments with them.

0 votes


Permanent link
Yes thats a valid use case, in fact I think thats how RTC is capable of
importing from ClearQuest

Ben

On 02.08.2011 3:08, Geoffrey Clemm wrote:
Benjamin: If they created a zip file in the bugzilla format, could
they then use the bugzilla importer to import the work items with
attachments? Or alternatively, if they exported their work items into
bugzilla (with attachments), I assume they could then use the bugzilla
importer directly (but just creating the zip file would seem like the
more direct approach).

Note that work item 100993 asks for support for importing attachments.
Please feel free to add a comment indicating your interest/support.

Cheers,
Geoff

On 8/2/2011 8:34 AM, Benjamin Pasero wrote:
Attachments can only be imported from bugzilla.

On 02.08.2011 12:53, achal wrote:
The shared library link says that we can not import attachments using
CSV import. Do we have any work around for this?

P.S: We are migrating data from a legacy system to RTC and many
workitems in legacy system have attachments with them.

0 votes


Permanent link
@Ben,Geoff

Thanks a lot for sharing your views and info :) .

We also considerd to use Bugzilla importer. However, we already have a tried and tested utility in place to generate CSV files from our legacy system and development of a utility to generate zips would have been an large aaditonal effort (and people hate spending their money :wink: ).

Now we have designed a Java plug in to uppload attachment and are using CSV files for data import. We also get detailed logs for attachmet upload and are still looking for a way to generate/find detailed logs for CSV.


-Regards,
Achal

0 votes

1–15 items
page 2of 1 pagesof 2 pages

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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 25 '11, 6:20 p.m.

Question was seen: 14,395 times

Last updated: Apr 25 '11, 6:20 p.m.

Confirmation Cancel Confirm