Column is not appearing in issue export excel

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

8 answers

1 accepted

0 vote

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

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?

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

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

The field is Date field.

Thanks
Anam

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.

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

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.

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

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!

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

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.

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.

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

0 vote

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

0 vote

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

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.

0 vote

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?

it's a single select list.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

229 views 2 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you