Importing Artifact Links in RRC 3.0.1
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!
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
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).
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.
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.
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