Better Excel Exporter supports all built-in system fields, all built-in custom fields and the majority of the popular 3rd party custom field types.
You can try free if this fits your use case.
I'm confused.
You can directly export the issues and have the custom field values embedded (as direct values only, not reference).
Though, if you wish, you can of course directly query in the database.
You only need to check 3 tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Indeed. Run a filter for the issues you want to see the custom field values for, choose the right columns, export to CSV, and open the result in Excel. It's built in, you don't need add-ons or anything
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nic, the filter works fine, but while excel exporting, all the fields for all the issues along with issue details, default and custom fields get printed in the excel sheet. My requirement stands still: I want to export only custom fields(values and definition) being used in my Jira instance to an excel file. Please guide
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Same answer - choose the columns you want in the export and export it to CSV - you should have seen the "CSV (current fields)" right next to the "CSV (all fields)" option you've used before.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If we have more than 1000 custom fields, just want to export only certain kinds of fields(like picker kind of or date kind of), is it possible with this solution?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, although it's not done by type, you have to choose the columns you want to download.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
may i now the exact filter u used to extract the custem fields in jira cloud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Filters do not extract custom fields, they give you a list of issues that match a query.
For an "extract", you probably want to use "export" in the issue navigator, which can give you all the fields that it is currently displaying when it show your list of results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Follow up on comment above - "CSV (all fields)."
This option does not appear my export drop down. I only see CSV (current fields). Why might that be?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Quick questions re: comments above:
Thanks in advance for your clarifications.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there any builty in option to extratct all the custem fields in my instance . if exist then please give a conclusion or this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use the database.
You can either connect directly to it, or use a SQL addon.
If am not mistaken something like "SQL Driver for JIRA"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No. Do not. The query required for even the most basic issue download is hideous and this way lies madness.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do it all the time and have no problem at all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there a way to export it without it saying "Custom field" in the spreadsheet? I am trying to export but it keeps listing as follows: Custom field (item name).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
There are other export-AddOns too - we use
https://marketplace.atlassian.com/plugins/com.xpandit.plugins.jiraxporter/cloud/overview
and are very sattisfied
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does this app allow a dump of all custom fields regardless of issueID? I'm not seeing a way to use this to pull all CustomFields that are in my instance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can check this app in the marketplace:
https://marketplace.atlassian.com/plugins/com.deiser.jira.exporter/server/overview
This app will give you a lot of different functionalities to export your data from jira.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.