Document toolboxDocument toolbox

CSV export

WORK IN PROGRESS

With CSV format you will be able to export your issues and import them into another Jira instance. You can choose the delimiter, select between Comma, Semicolon, Vertical bar or Caret.

Rows look like this

Every row in the CSV file is an issue, it does not matter the content type you are exporting.

All exported data (fields with single selection, fields with multiple selection and extra content) will render their values in a single data separated by the selected delimiter.

Extra content

Comments

Comments in the export include:

  • Author and timestamp.

  • Visibility settings (e.g., public or restricted).

  • The comment content.

Comment data will be rendered in a single data separated by the selected delimiter.

Adapt data format before exporting

Date fields

  • Its format is the one the Jira instance has set in Look and field Complete Date/Time Format:

    image-20241213-062614.png

     

Duration fields

Duration fields, such as time spent, aggregate time spent, time estimate, aggregate time estimate, time original estimate, aggregate time original estimate:

  • Format: the one the Jira instance has set on Time tracking Time tracking format:

  • They are calculated based on Jira setting in Working hours per day and Working days per week

Transitions area - duration fields

Time in final status and Time in initial status:

  • Format: the one the Jira instance has set on Time tracking Time display format

  • They are calculated in real hours, not working hours. For example:

    • 3 days = 72 real hours, even if there are only 24 working hours.

      image-20241213-050218.png