Export all artifacts in RRC into an excel format make the live inks
We have a customer who need to export around 200 requirements into an excel format.
Several questions: 1. how i can select all requirements to export them in a shut as the maximum page size is limited to 50. 2. how can I make the Validated By link live? 3. the customer has for a while RI installed. Would that be of any help? I exported into a csv format and then opend it with Openoffice.org Calc and it looks like a table but, the live links are not live at all. The only possibility to geth them live is to use the Tracebility Report but this is an work like document and not a table. Any input on this ? Thank you, Zica |
3 answers
RRC exports to CSV where comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
As the content is plain text there would need to be additional content added to the raw file so that Excel can interpret the link, for example adding the hyperlink function to the csv file wrapped around each of the plain URL text. Now the grid view does have a 50 row limit but if you are using V4.0.1 and later there is the module capability where by you can store more rows of information and organize them into a hierarchical structure, and this can be exported to CSV. That said I would like to understand better the need for working in Excel rather than using the RRC web client? If you have any knowledge that would be great if you could share so that we better understand how customers are using RRC and any necessary changes. Comments Hi Robin
The reason why we use Excel is because we are approaching the M120 phase and we need to prioritize a long list of requirements. RRC can display only 50 rows per page and does not offer a fast way to filter the rows (in Excel that is much more comfortable). For these reasons we prefer to export all requirements in Excel and do this job with that tool. cheerserwin |
|
Thank you Robin for the great info you posted.
Here my comments/answers: 1. The customer uses CLM 4.0.1. 2. Do you consider for the next versions this functionality of hyperlinks in RRC and not using external applications? 3. I have tried using the modules and it work indeed to select all requirements in a row. Personally, I consider it as an workaround as it is not so intuitive . 4. Our customers need an Excel sheet as they work on a project where their partners shouldn't have access to their RRC project. Thank you, Zica |
|
Hi,
I have to correct my previous statement, namely that one can select more than 50 rows in a module. Here is the error message I gotten when trying to select more than 50 rows: On the Artifacts page or in a module, operations are limited to 50 artifacts. Select fewer artifacts. If you need to perform an operation on more than 50 artifacts, do it in batches of no more than 50. Thanks, Zica |
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.