Column is not appearing in issue export excel

[Mahmudul Anam]

Hi Experts,
I have created a filter in Jira and download the excel. But couple of issue type field which are in the screen tab are appearing in the issue type all view in the browser. But when I download the excel file, those screen tab fields are not appearing.

Could you please tell how to resolve this issue?

Thanks
Anam

[Nic Brough -Adaptavist- · Accepted solution]

Could you tell us what type of fields they are? (Multi-select, cascading select, etc)

[Nic Brough -Adaptavist-]

Tabs only apply to the screens an issue uses. They do no affect the issue navigator or excel output.

Could you check that the "missing" field is definitely appearing in the issue navigator and is not shown when you downloadd ALL fields?

And, again, could you tell us what type of fields they are?

[Mahmudul Anam]

Hi Nic,

Thanks for your reply.

Actually, I have used two tabs in one issue types. The value of first tab are appearing in the excel but another tab's field are not appearing.

Thanks in advance
Anam

[Mahmudul Anam]

Hi Nic,
Yes, the "missing" fields are appearing in the navigator.

The field is Date field.

Thanks
Anam

[Nic Brough -Adaptavist-]

Ok, which type of date is it? Updated, Created, Due, or is it a custom field you have added? If it is a custom field, then what exactly is the type (go to custom fields, and look in the "type" column - it'll say something like "date picker")

Also, could you go to the issue navigator with your search. Make sure that at least one issue in the results has the date field set, and that it is showing in the navigator. Then choose the "XML" view from near the Excel view link at the top. Either save it and open it, or view it in the browser - it's a bit horrible for a human to read the xml, but we're looking to see if the data comes out in plain xml at all.

[Mahmudul Anam]

Hi Nic,
Thanks for your reply.

According to your suggestions, I have got the following findings.

1. The filed is custom filed "type" column - it'll say something like "date picker".

2. I have downloaded the XML and the field is avaialble there.

3. I am using Jira 4.02 - in case that could help you out to find a solution.

4. I have created a new filter again and downloaded the excel but still the date field is missing.

Thanks for your prompt reply.

Thanks
Anam

[rambabu patina]

You problem is probably due to the field not being available for all issues types in your filter results. If a field is not available for all issue types in the results, then it gets hidden. Try to change your filter to only include a specific issue type that has the field first.

[Nic Brough -Adaptavist-]

I'm afraid that is incorrect.

We have already established that the field appears in the issue navigator, and it comes out in the xml, so the question now is why it does not come out in the Excel sheet as well

[Nic Brough -Adaptavist-]

Hmm, so what does it actually say in the type column? (I think you've pasted in my question and not typed an answer over)

So, the same filter gives us results on-screen and in XML, but not excel. That implies the field doesn't have an XML output template or is deliberately surpressed (which is why I keep asking about the type - there's no way to know without knowing the exact type)

Jira 4.02 shouldn't be a problem, unless there is a bug in the Excel output related to date outputs. I do remember one from Jira 3.3 which did exactly this with one type of field, but I know it was fixed by 3.6. I've also managed to write plugins that do the same, but I doubt you're suffering from my coding!

New filter - good test, worth a try!

[Mahmudul Anam]

Hi Nic,
Thanks for your reply.

In the tab there are couple of fields:

1. Text Field - Type: Text Field (< 255 characters)

2. Date field - Type: Date Time

3. Check box: Multi Checkboxes

Besically, values of tab fields are missing.

If you have any other query please let me know.

Thanks in advance
Anam

[Nic Brough -Adaptavist-]

I don't know why you keep talking about tabs - they have nothing to do with the issue navigator.

Anyway, these three fields are all standard custom field types and should appear in an excel export if they are appearing in the navigator before you click one of the excel export links.

So I'm a bit stuck. They should be there. The only things I can think of that might be breaking it are customisations - do you have any 3rd party plugins or code changes?

Could you also read the log file and check there are no errors in there when you run one of the excel downloads.

[Gaj Umapathy]

it's a single select list.

[Nic Brough -Adaptavist-]

Hmm. That is very odd. I can't replicate it on my local install - the field always comes out when it's valid.

However, what type of field is it?

[Gaj Umapathy]

Hi Nic, the field is valid across the project and that's why i get the same number of issues for both search 1 and search 2. just to confirm the field is only available for the project XYZ and this project XYZ only has one issue type.

[Nic Brough -Adaptavist-]

That suggests that the field is not valid across the entire project. Check the field context in the admin section

[Nic Brough -Adaptavist-]

No. If the field comes out in the issue navigator (which it does, we established that ages ago), then it is indexed correctly.

[Gaj Umapathy]

I've had the same issue just now where the custom field appears on the issue navigator but doesn't output to excel. Only if I put the customfield is not empty then I get the values come up on excel. Just to confirm the number of issues for the two searches are the same:

search 1 - project = XYZ and "Customfield" is not EMPTY

search 2 - project = XYZ

[Gaj Umapathy]

I think it's an indexing issue. If you run your searh with a JQL where that customn field is not empty and then do your output it will work. Otherwise JIRA needs to be reindexed.