...
The Excel loop is useful when the file you want to import contains requirements you have defined with Requirement Yogi. You can export requirements using the Traceability Matrix for example.
Make sure you have already created the external properties you wish to import, before starting to upload the file. You can add new external properties in the Administration.
Step by step guide
1. UploadTo upload your external properties, go into the External properties tab → Click on Upload Excel File | |
2. Choose a templateOnce you have chosen the correct file, you will need to map columns to what they are (key, external property etc.) → You can use an already existing template if you have one, or go to the mapping without using a template. | |
3. OverviewIn this screen, you can do multiple things:
| |
4. Mapping optionsCog menus have 5 options:
You may have other columns as well, that are your requirements properties, but we do not care about them. We only care about the external properties. By default other columns will be put as “Ignored". → Go on an external property column and select “Import as an external property”. | |
5. Select a propertyChoose the corresponding external property. → Only already created properties will be displayed, this is why if you want to import a new external property. Creating it beforehand will avoid backs and forths. | |
6. Save and importYou can see in the screenshot external properties columns have been mapped properly by looking at the top of each column.
| |
7. Watch for errorsWait for the job to finish, acknowledge the import is successful and you’re done! |
You’re done!
You will be redirected to the External Properties tab, to check if your comments have correctly been added, you can click on the property and build your matrice (if you did not have one saved before hand).
...