Lets' say we need to import nested structure of requirements from the Excel file. For this, you must define the Owner property in the Excel spreadsheet with the name or id of each requirement. As example, see the following figure.
To import nested Requirements
Open the project in the modeling tool.
In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using New Map.
For element import via tables, use the Exce/CSV Sync functionality. |
In the Excel/CSV Import dialog, select the Excel file.
Make sure the Excel file contains Owner column. See the example above. |
Target Scope - select the Package you want to contain imported Requirements. If the Owner property is selected as the Properties to Map option value, the data is imported according the owner.
You can specify more mapping options according to your needs. Learn more about mapping options >> |
Create the mapping between Excel file columns and element properties by dragging the column on the right to the property on the left. Learn more about mapping area >>