Configuring How Requirement Objects Are Imported From Microsoft Excel

You can specify which types of requirement objects can be imported from Microsoft Excel. You can also specify which attributes of those requirement objects can be selected for import and which parent/child relationship is applied to imported requirement objects.

See Properties for Importing Requirements Objects From Microsoft Excel.

  1. Create or open the text file for customized properties. For more information, see Editing Properties Using MQL.
  2. To control the types of objects that are selectable from the Type drop-down list when importing content from Microsoft Excel, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxRequirements.ExcelCapture.AvailableTypes = Requirement, Comment

    2. Delete or add the relevant object types.
  3. To specify the options used to filter the Attribute drop-down list so that certain attributes do not appear as selectable, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxRequirements.ExcelCapture.UnallowedAttributes = Content Text, Content Type, Originator

    2. Delete or add the relevant types.

      This option is applicable for all Types. If there are multiple types that can be created, you do not have to limit the attribute list for each type. This option just defines which attributes are not allowed for all Types.

      Note: Attributes cannot be filtered for specific types. For example, if TypeA and TypeB both share an attribute called "Notes", an Administrator cannot filter out this attribute only for TypeA and not for TypeB. If "Notes" is configured to be filtered, it would be filtered for both TypeA and TypeB.

  4. To specify options that control parent types for each importable object type: parent type, parent relationship, and parent file checkin enabled, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxRequirements.ExcelCapture.Requirement.Parent1.Type = Requirement Specification
emxRequirements.ExcelCapture.Requirement.Parent1.Relationship = Specification Structure
emxRequirements.ExcelCapture.Requirement.Parent1.FileCheckinEnabled = true

    2. Delete or add the relevant object types for each attribute:

      • ParentType specifies the root type of the object that can be created as a parent.
      • ParentRelationship specifies which relationship is used to link the two objects.
      • When ParentFileCheckinEnabled = true, users will be prompted to check in a file on the parent object.

  5. When you are finished updating the text file with all properties that you want to modify, use the text file to modify the emxRequirements.properties page object. For more information, see Editing Properties Using MQL.