How to map Jira Issue Keys to Google Sheet Values?

[martins.vanags]

Hi Christian,

I believe the “skip missing” option is needed in your import definition (when mapping data from your Google sheets)

https://docs.eazybi.com/display/EAZYBIJIRA/Additional+data+import+into+Jira+Issues+cube#AdditionaldataimportintoJiraIssuescube-Columnmapping

It should import rates only to epics and ignore missing entries.

Please check also this article (“Rates import for a user” part):

How to build profit & loss report with additional data import

Overview In this example, JIRA has custom field Cost Center and a file with a budget for each Cost Center per month. Cost calculation goes over logged hours and user rate. Users have flat rates in a seperate file. The example describes how to import both files into eazyBI, mapping budget to custom field Cost Center and Time, and mapping Rate to Logged by User. You could either upload a file, import data via REST API, or SQL, or use Google Sheets in the same way. eazyBI supports additional data …

Martins / eazyBI support team