Skip to main content

Jama Connect Interchange Help

Excel Functions troubleshooting

Question

Answer

I created an Excel Functions integration that isn’t populating values the way I expect.

Before contacting Support, check the following:

  • Make sure the functions in the Excel template are working correctly on their own. Test the functions directly in the Excel template and address any errors before attaching the template in Jama Connect.

  • Make sure the functions in the Excel template are supported. For a full list of supported functions, see Appendix - Supported Excel Functions.

  • Make sure the Excel template is attached to the Jama Connect item that you specified in the integration wizard.

  • Check for errors on the Links page and Logs page in Interchange.

Can the Excel Functions integration be used with Jama Connect lookup matrix fields?

Yes. Using the Excel Functions integration, values can be written directly to lookup matrix picklists. This allows you to use both solutions together for more advanced work streams.

On the Links page for my Excel Functions integration, the Status column for some items is blank. What does this mean?

A blank status for an Excel Functions link indicates the item was unable to sync successfully on the first run of the integration. In this scenario, the integration initially fetched these items and added them to the Links page. However, after the initial fetch, an error occurred when the mapped values were synced to the Excel template. These errors typically occur because of a missed configuration in the template or on the Field Mappings page. Check the Logs page for a corresponding error message with more information.

In this section: