Import requirements from an Excel file (API)
Using the API, it is now possible for you to import requirements you have in Excel to our RY app.
Use case
If you want to work with requirements sent from stakeholder and keep those as a reference.
If you want to be able to refer your Excel requirements to your requirements defined in Confluence.
If you want to import requirements to Requirement Yogi, and you do not plan to have those as Confluence pages but still want to link them to Jira issues, reference them in Confluence, create baselines and more.
How to import requirements from an Excel file using the API
Follow this documentation: https://github.com/requirement-yogi/ry-cloud-excel-importer .
You will be able to create a script that will parse your Excel file and create requirements for you.
You will need to map each column as requirement key, description or properties.
How to edit/delete requirements from Excel
If you want to modify requirements that you had imported to Excel, you simply need to reimport an excel file with the exact file name and it will replace the previous import:
If you have removed requirements from the file, it will delete them in our database
If you have modified requirements from the file, it will modify them in our database
If you have added requirements to the file, they will be added in the database.
Which features can I use on my Excel imported requirements ?
In Confluence and Jira | |
|---|---|
| You will be able to add ‘Requirement Link’ macros to requirements imported from Excel. |
| You will be able to create links from Jira issues to requirements imported from Excel |
| You will not be able to see your 'Requirement Definition' macros for imported requirements and you will not be able to edit them directly in Confluence. Any modification will have to be done in the Excel file. |
In Requirement Yogi app | |
| In the search, the traceability matrix, modification matrix, coverage etc.
|
| You will be able to put them in Requirement Types. |
| You will be able to freeze them and create baselines. |
| You will not be able to choose another variant than ‘Current’. |
Limitations
There is no limitation to the number of rows or columns
For any modification (edit / add / delete) you will need to reupload the file with the exact name.
It is not possible to add links in the Excel file to requirements defined in Confluence.