Importing the attribute value
Prerequisites
• Access to the File > Requirement (REQ021) menu;
• Requirement with attribute associated.
Introduction
The system enables the requirement attributes to be filled out through an Excel spreadsheet. Thus, it is possible to fill out multiple attributes and even attributes from more than one requirement at once.
Downloading and filling out the import spreadsheet
1. Access the File > Requirement (REQ021) menu.
2. Click on Search to display the list of records.
3. Click on More and choose the Import option.
4. On the screen that will open, select the Import requirement attributes and click on the Start button.
5. The screen of the Select file step will open.
6. Go to the First time? section and click on the specified location.
7. Open the RQREQATTRIBUTE spreadsheet that has been downloaded.
8. The RQREQATTRIBUTE tab displays the columns equivalent to the requirements whose attributes will be filled out and the tab to enter the attribute value. The Recommendations column specifies what each column represents and which are mandatory to be filled out.
9. Fill out the columns indicating the requirement whose value will be filled out and the desired value for the attribute. Each row filled out in the table will be equivalent to a different attribute, and it will be possible to fill out attributes in more than one requirement.
10. Save the spreadsheet. The attribute values are ready to be imported.
• If the required columns are not filled out, the system will not validate the import.
• The columns that reference the system records, such as the requirement ID # and attribute ID #, must be filled with the exact same information as that of the system.
• The extension of the file must be .xls and said file must maintain the same language downloaded from the system. For example: if the spreadsheet is downloaded while SoftExpert Suite is in English, but is imported later on with SoftExpert Suite in Portuguese, the system will not validate it.
• If the attribute value will be imported to a reference requirement, the requirement ID # and reference requirement ID # columns must be filled out with the same information.
Importing the attribute value
Once the spreadsheet is duly filled out and saved, perform the following steps:
1. Access the File > Requirement (REQ021) menu.
2. Click on Search to display the list of records.
3. Click on More and choose the Import option.
4. On the screen that will open, select the Import requirement attributes and click on the Start button.
5. The screen of the Select file step will open.
6. Click on the indicated location in the Send file field. Select the spreadsheet and click on Open.
7. Click on Next.
8. In the Execute step, check if the imported data is correct.
9. If there is an error with part of the information, click on Previous, correct the Excel file, and import it again.
10. When everything is correct, click on Next again and confirm the operation.
11. The View step will display all imported data. If any problems have occurred, the Error description column will inform the error to be corrected.
12. If there are any errors, the corrections must be made in the Excel file, which must be imported again.
13. If everything is correct, click on Finish.
Conclusion
The attribute values are duly filled out. This is a very practical way to fill out multiple attributes all at once.