Importing Requirements from an Excel File

Before you can import requirements, you need to create a requirements file in Excel. For more information, see Excel Requirements and Mapping File.

Silk Central uses the information stored in the Excel file and in a mapping file to determine what data to store and captures only the information that is mapped with certain column names. Silk Central uses a mapping file to map the requirements in the Excel file to the Silk Central requirements. A default mapping file named RequirementPropertiesXlsxDefaultMapping.xml is preselected for the import. You can choose your own customized mapping file to map your requirements.

Note: Importing attachments (images, graphs) is not supported.

To import requirements from an Excel file into the Requirements unit:

  1. In the menu, click Requirements > Details View .
  2. Right-click the requirement that you want to use as the parent node of the imported requirements and choose Import from Excel.... The Import Requirements from Excel File dialog box opens.
  3. Select the mapping file from the Choose Mapping File list box. The default mapping file is RequirementPropertiesXlsxDefaultMapping.xml.
  4. Optional: Click to edit the mapping file. Click to delete the mapping file. For more information, see Excel Requirements and Mapping File.
    Note: These actions require the permissions Modify Office import mapping files/Delete Office import mapping files, respectively.
  5. Check the One-Time Import check box if this is a one-time bulk import of requirements, which will only be maintained in Silk Central after the import. Selecting this option imports the requirements directly under the selected node without creating a common root folder. You cannot use the Update from Excel... option to update the imported requirements afterwards.
  6. Either type the fully qualified path of the requirements file into the Requirements File field or click Choose File to search for the requirements file.
  7. Click OK. A message informs you if the import was successful. Click OK to close the message.