Importing custom "Platform(s)" field results in blank cell.

[lucbloom]

Hello, first off, thanks for creating this tool. We'd like to view the "Platform(s)" property of our tickets in a sheet. However, it's not importing correctly. It's a list of items that works like a checkbox list, but it's visualized as a list of menu options inside a scrolling box. =>

[ljay79]

Hi. What is the specific field type in jira called for that 'Platforms'?

[ljay79]

Hi @lucbloom at this stage, i was not able to reproduce your issue. For my Jira (Cloud) instance i had created a field of type "Select List (multiple choices)". This was correctly imported into the Google Sheet as a text value list with comma separation.

For further investigation, pelase activate Debugging in "About" dialog, provide me your "Temp. User Key" and then perform at least one another try. This way it will log the error and debug information to my StackDriver logging account where i can analyze it better. User credentials are not transmitted in any log data.

[lucbloom]

Thanks for looking into it. I ran the import with Debug ID AFzpkET0voPAQ4JFhbXlnmX7Dw/tIhJ4hNZRlYVNl0YqUZ2TRao4m7cTAaxlkdsaMnSLmTX3lRur

[lucbloom]

What I see in Jira:

[cid:67bd58a6-879d-4dca-8926-e4cceff90697]

[ljay79]

What I see in Jira: [cid:67bd58a6-879d-4dca-8926-e4cceff90697]

Your last comment is empty, pls check.

[ljay79]

@lucbloom i have investigated all log informations from you. According to the logs, you performed 3 searches for the filter "HM4 my issues".

• 1st - selected fields to fetch: [summary, status, description]
• 2nd - selected fields to fetch: [summary, status]]
• 3rd - selected fields to fetch: [summary, status, assignee, customfield_10165]

Where customfield_10165 is your "Platform(s)". That last search returned a total of 22 issues, all/most of them with a valid value for the field "Platform(s)". I then took the logged Json response data and manipulated my own request in a test environment on a blank new sheet. The result was as expected. A new Issue Table with 5 columns, namely: [Key; Summary; Status; Assignee; Platform(s)]. All data was displayed correctly including values like "iOS" and "Android" in the Platforms column.

It seems to work correctly and expected.

Please do me a favor and perform the following to eliminate possible flaws.

• go to Addon menu "Configure Custom Fields"
• uncheck your custom field "Platform(s)"
• Hit "Save"
• Now open a new fresh google sheet
• go back to menu "Configure Custom Fields"
• check/activate your custom field "Platform(s)"
• Hit "Save"
• perform your request with "List Issues from Filter"; choosing just the fields: [Key; Summary; Status; Assignee and Platform(s)]

Once done, please report back to me with the result.

[lucbloom]

Still empty: [cid:88a79542-0d6e-4883-ab53-d5edb3b5302e]

So weird that the values are in the JSON but not filled in. I was using Chrome on Windows and now Chrome on OSX. Version 71.0.3578.98 (Official Build) (64-bit) It's an English sheets interface... hmmm what else

[ljay79]

I'll make another check tomorrow. Meanwhile, if you are able to - it's just a shot into the blue - rename the Platforms field in jira to something without brackets, if you can.

[ljay79]

I did investigate more, prepared my own Jira to have a field of same name and type. Everything worked as exptected.

I can not make out any possible reason why your column would stay empty.

Did you tried uninstalling the add-on completly and then re-install it?

[ljay79]

Hi @lucbloom do you have any new insights?