In this page
Profields integration features
Profields integration vs. the Profields built-in Excel exports
Tutorial video
Profields Excel export samples
Issues with Profields custom fields
Projects with Profields custom fields
Profields project report
Configuration
Exporting Profields custom fields for issues
Exporting Profields custom fields for projects
Learn more about Profields
What is Profields?
(supported since Better Excel Exporter 4.3.0)
Profields is the project administration app for Jira that enables adding custom fields to projects, such as due dates, budgets and supervisors.
Profields integration features
- You can export the Profields-managed issue custom field types to which the Profields-managed project custom fields are mapped to. The supported project custom field types include Date, Duration, Group, List, Number, Priority, Project, Status, Text and User to Excel. (Cumulative and Script are not supported, as those cannot be mapped to issue custom fields.)
(Need more features? Tell us in a support ticket!)
Profields integration vs. the Profields built-in Excel exports
You may want to ask: if Profields has a built-in Excel export feature, why would you use another app for the same?
While the Profields built-in Excel exports may be sufficient for basic use cases, the Better Excel Exporter integration is more powerful in, at least, these:
-
It supports Excel automation.
You can export, email and attach Excel files using Automation for Jira (visual automation rules), ScriptRunner (Groovy scripts), or the REST API (use your favorite language!). -
It is extremely customizable.
Instead of accepting the pre-defined export types in Profields, you can define your own types via Excel templates. -
It supports all the powerful Excel features.
You can use Excel formulas and functions, custom calculations in Groovy (sorting, complex math, data integration, etc.), charts, pivot tables, pivot charts, Visual Basic macros, among others. -
It is integrated with all the popular Jira apps.
You can freely combine Profields data and other apps' data in the same Excel file. -
It comes with powerful templates optimized for Profields.
You can use those "as is", or customize them to your needs. - It is well-documented with the customization guide, the expression reference manual, the recipes, and such.
If any of these are important for you, give it a try.
Tutorial video
After mapping the project custom fields to issue custom fields (using the standard Profields feature), the Better Excel Exporter app transparently exports those to Excel:
Profields Excel export samples
Issues with Profields custom fields
This export contains Jira issues from multiple projects, with the Profields-managed data of their encompassing projects (column E-L). Note that the Profields values are exported to Excel with the precise data types (numbers, dates, etc.).
Projects with Profields custom fields
Not only issues, but also projects can be exported to Excel (using this technique). If you have a large number of Jira projects, it offers an easy way to search, share and transfer project information between stakeholders or IT systems.
Profields project report
You can also create powerful cross-project, program- and portfolio reports from Profields data to complement your Jira reporting. This example contains Excel pivot charts to visualize the project status distribution among projects, the project costs, and the relationship between those (cost by status).
Configuration
Exporting Profields custom fields for issues
Please note that the Profields-managed custom fields are primarily attached to projects (not to issues). To make them available also for issues, map the project fields to Jira issue custom fields by using the Map into a Jira issue custom field option (in the Special options dropdown at Profield field settings).
After this, Better Excel Exporter will automatically recognize the issue custom fields to which the project custom fields are mapped to, and export them accordingly.
Exporting Profields custom fields for projects
In another Profields-related use case, you want to export the projects (not issues) and their custom fields to Excel. Although the default export types offered by Better Excel Exporter primarily focus on issues, exporting project is also possible with an easy workaround.
Steps:
- Open Issue Navigator.
- Select exactly one issue from each project you want to export. (See the next section for techniques.)
- Show the Project column.
- Show the columns with those Profields-managed fields that you want to export.
- Hide all issue-specific columns (like Summary and such).
- At this point, there is one project in each line and there are only project-dependent columns shown. Export using the "Better Excel (Current fields)" option in the Export drop-down menu.
- Voila, you have just exported your projects to Excel!
All right, but how to select the issues as in step 2 above?
-
If you want to export only a couple of projects, you can write a JQL by enumerating the first issue keys in those:
key IN (FOO-1, BAR-1, BAZ-1) ORDER BY project
This is simple, but it is painful for a larger number of projects. -
If you want to make it more automatic, introduce a new issue type that represents projects, and give it some intuitive name, e.g. "Project Object".
Then, create exactly one instance of this issue type in each project.
Having that, a JQL query like this will return that single issue from each project:
type = "Project Object" ORDER BY project
Note that it will work for any number of projects until there is one "Project Object" type issue created in those. - If you need more flexibility, write a short Groovy script that receives the issue collection as input, iterates over it, only leaves one issue per project and removes the rest, and returns the resulted collection to the template.
Learn more about Profields
- Profields product information (at its own vendor)
- Profields documentation
- Profields app page (on the Atlassian Marketplace)