It's all about the answers!

Ask a question

Importing Artifact Links in RRC 3.0.1


Brad Poulliot (561210) | asked Sep 08 '11, 6:16 p.m.
JAZZ DEVELOPER
Is it possible to create artifact links via the CSV import capability?

The reason I ask is that it would make my life much easier and when you export a saved filter with the 'Link To' column the resulting .csv has an associated column with the correct links listed.

When I tried to import a CSV with with new requirements and links to existing requirements I received the following:

"Warnings were received while processing the comma-separated (CSV)
file.

The following attributes were not imported:
Column: Link To
Reason: NOT_FOUND"

Is this because the 'Link To' object is not an attribute, but a link type and the CSV import capability does not know how to handle it?

Thank you for any insights!

4 answers



permanent link
Daniel Moul (5.0k1318) | answered Sep 09 '11, 7:33 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
In RRC V301 it's not possible to use the CSV import facility to create links. It is possible to do this using the OSLC-RM API ( http://open-services.net/bin/view/Main/RmHome ). it's even possible to do this in Excel macros if you are staring with information in spreadsheets (though I'm not aware of any good example code for V3).

permanent link
Peter George (2651) | answered Oct 07 '11, 12:04 p.m.
i have made a macro for v3.0.1 to import artifacts from excel. I take the sheet and format the data and search for specific characters to remove due to issues in putting it into .csv ms-dos and also RQM. I get one link that says it is missing, but when I check it, it is there. So I am unsure why that warning gets thrown. We use it to import requirements because we don't have a requirement management system, so it is tailored to our company. If you would like to see the macro coding I can post it and you can use it if you want.

permanent link
Chris Horning (2711) | answered Oct 13 '11, 10:45 a.m.
JAZZ DEVELOPER
i have made a macro for v3.0.1 to import artifacts from excel. I take the sheet and format the data and search for specific characters to remove due to issues in putting it into .csv ms-dos and also RQM. I get one link that says it is missing, but when I check it, it is there. So I am unsure why that warning gets thrown. We use it to import requirements because we don't have a requirement management system, so it is tailored to our company. If you would like to see the macro coding I can post it and you can use it if you want.

Hi Peter
I would be interested in seeing this macro. It sounds like it helps provide a smoother integration from Excel.

permanent link
Eduardo Mylonas da Silva (23422519) | answered Apr 13 '12, 2:04 p.m.
i have made a macro for v3.0.1 to import artifacts from excel. I take the sheet and format the data and search for specific characters to remove due to issues in putting it into .csv ms-dos and also RQM. I get one link that says it is missing, but when I check it, it is there. So I am unsure why that warning gets thrown. We use it to import requirements because we don't have a requirement management system, so it is tailored to our company. If you would like to see the macro coding I can post it and you can use it if you want.


Hi, I hate to ask this, but this is too important and useful. By any chance would this very important and useful macro be available somewhere?

Thank you

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.