Skip to main content

Jama Connect Interchange Help

Map test runs and test cases

Map your Excel template to test runs and test cases in the selected project.

  1. On the Integrations page, select the link for the integration you just created.

    The Integrations page displays a search string and a 2-column table (Type and Name), with Excel Risk Calculations highlighted.
  2. Select the Field Mappings tab.

    The Field mappings tab is highlighted on the Jama to Excel Functions integration page.
  3. Select Add new field mapping group.

    The Add new field mapping group button is highlighted at the bottom of the integration's Field mappings tab.
  4. On the page that opens, select Test Plan, then select Next.

    On the Add a new Field Mapping Group page, the Test Plan option is selected and highlighted.
  5. In the Name field, enter a descriptive name for the field mapping group.

  6. In the drop-down list, select the test item type you want to map, then select Create.

    The Add a new field mapping group page includes fields for name and a highlighted dropdown list where you select the test item type to map.

    The field mapping group is created.

  7. Using the drop-down lists, map the fields and cells to one another. Add a separate row for each field/cell combination, as shown in this example.

    The drop-down lists in each row let you map fields and cells between Jama Connect and Excel.

    These fields are available in each row:

    • Select Field — Select the field in Jama Connect that is being mapped to Excel.

    • Directionality — Select whether data is written from Jama Connect to Excel (→) or from Excel to Jama Connect (←).

    • Select Sheet — Select the sheet in the Excel template where the cell is located.

    • Input Cell — Enter the cell location in the Excel template. For example, G5.

    Typically, output fields are read-only in Jama Connect to prevent users from updating them manually. If you mark a field as read-only in Jama Connect, you must also select Allow API Overwrite in the field settings to allow the integration service to write the updated Excel value to the item.

    The Edit field window includes fields for label, infotip, and unique name, as well as three options, two of which are selected.
  8. Select Save Changes.

  9. Map test cases to your test runs:

    1. Select Add new associated mapping group.

      The drop-down lists in each row let you map fields and cells between Jama Connect and Excel. The Add new associated mapping group option is highlighted.
    2. Select the type of test case to map, then select Create.

      The Validation drop-down list is highlighted on the Add a new associated mapping group page.
    3. Add additional field mapping rows for the test case items.

      The drop-down lists in each row let you map fields and cells between Jama Connect and Excel.
    4. Select Save Changes.