Versions Compared

Old Version 1

changes.mady.by.user Takafumi Ohtake (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Linh Pham_Ricksoft_Inc (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Secure field values can’t be exported with Jira’s standard CSV export.
So Secure Custom Fields provides its own CSV export feature so that you can export secure field values to a CSV file to analyze the values with spreadsheet applications or migrate the field values.

How to export field values to a CSV file

  1. Open the application page and click the CSV export link.

    Image Added


  2. Fill out the form to determine which issue and field should be exported.

    Image Added

  3. Once you have selected the desired fields, you can save them for future export by clicking on Save selected state. This is useful if you need to perform regular secure field export for reporting.

    Tip: You can export Jira fields along with secure fields. If you don’t see the desired Jira fields, please raise a request through our support portal.

    Image Added

Expand
titleHow to load the saved state for future export

Under the Fields to export section, click on Load selected state.

You can choose the saved state from the dropdown list. Then, the selected fields will automatically be loaded.

Image Added

  1. Click the Export button. Then you will download a CSV file like the image below.

    Image Added
Info

  • CSV file is encoded with UTF-8 with BOM.

  • The file name is secure-custom-fields_YYYYMMDDhhmmss.csv.

  • Each row has issue id, issue key, and summary.

  • Up to 1,000 issues can be exported at once. This means the only first 1,000 issues are in the exported file.

  • If the user doesn’t have permission to view the value and the value is not null, the value will be “****“.

Expand
titleSupported Jira fields for CSV export

JIra System Fields

  • Issue type

  • Status

  • Project

  • Priority

  • Resolution

  • Assignee

  • Reporter

  • Creator

  • Created date

  • Updated date

  • Last viewed date

  • Resolution date

  • Due date

  • Fix versions

  • Votes

  • Original estimate

  • Remaining estimate

  • Logged time

  • Work ratio

  • Σ Original estimate

  • Σ Remaining estimate

  • Σ Logged time

Jira Custom Fields

  • Single line text

  • Multiline text

  • Number (including story point)

  • Date picker

  • Date time picker

  • Single select

  • Multiple select

  • Radio

  • Checkboxes

  • Cascading select

  • User picker

  • Multiple user picker

  • Sprint

How to migrate secure fields to standard Jira fields

Sometimes you’d like to migrate secure fields to standard fields.
CSV format of Secure custom fields is compatible with Jira’s CSV format so that you can migrate secure field values to standard Jira fields.

Note

You have to be a Jira administrator to do this operation.

  1. Export secure field values you want to migrate with CSV export. Please make sure you have permission to view the issues and fields before exporting.

  2. Go to [System → External System Import → CSV].

    Image Added

  3. Choose the CSV file you exported at step1. And click the Next.

    Image Added

  4. Fill out the form and click the Next.

    Image Added

  5. Build fields mapping and click the Next.

  6. Image Added

    Build option value mappings and click the Begin Import.

    Image Added