Map items in the Project Explorer Tree
Map your Excel template to a set or folder of items in the Project Explorer tree in Jama Connect. For example, a set of risk evaluations or test cases.
On the Integrations page, select the link for the integration you just created.
Select the Field Mappings tab.
For each field mapping group you add, select Add new field mapping group.
On the page that opens, select Explorer, then select Next.
Complete these fields, then select Create.
Name — Enter a descriptive name for the field mapping group.
Jama Location Selector — Select the Jama Connect sets or folders you want to sync. All selected sets must use the same item type (for example, User Stories or Defects).
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.
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.
Organize your mappings in this order:
List the fields written from Jama Connect to Excel (input fields).
List the fields written from Excel back to Jama Connect after the function runs (output fields).
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.
Select Save Changes.