Versions Compared

Key

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

...

Contents:

Table of Contents
minLevel2
maxLevel3
outlinefalse
styledefault
typelist
printabletrue
Info

To unlock the export features, Export feature, you need to install the BigTemplate App app from the Atlassian Marketplace.

You can export your data from the Gantt tasks module to different the following formats, including:

  • PDF image

    ,

    .

  • CSV

    ,

    .

  • XLSX (MS Excel)

    ,

    .

  • MPP, MPX, PDF, XML (MS

    Projects

    Project).

Click on the "Export" icon to start. 

Image Removed

Next, you will be asked to select the "File type" and define the "Range":

  • Full scope (all formats supported)
  • Specific period (PDF image supported)

When ready, click on the "Export" button. 

Image Removed

Info

Keep in mind that for the "Specific period" range, the available export format is PDF. Although you can still see other formats, they are not supported.

Export to XLSX / CSV

Before exporting data, you can adjust the Column View and decide which columns should be visible in the exported file. To modify the Column View, click on the "Manage columns" icon, as presented below.

Image Removed

Then, click on the "Export" icon and choose the XLSX or CSV file type.

Image Removed

Depending on the Column View settings, the imported file can look similar to the one presented below.

Info

The fields related to the structure and dependencies of the tasks are added to each XLSX and CSV file by default (these fields are needed in the case of importing such a file to BigPicture afterward): 

  • Key, 
  • Parent Row, 
  • Issue Type, 
  • Start Date, 
  • End Date, 
  • Parent Key, 
  • Link.

Image Removed

Custom templates

To avoid modifying the Column View section before each export, you can easily prepare templates that will be tailored to your needs. You can use them with no need to adjust displayed columns. 

For more instructions on how to prepare custom templates, refer here

Export to MS Project

All file types use the same format compliant with the MS Project. At the moment, although it is possible to import a customized template of the MPP type, it does not affect the imported data. Pairing a column with the ID of a given custom field is currently not possible due to a fixed set of fields, which are hard-coded in the app. This set contains the following custom fields:

  • Task Name,
  • Duration,
  • Start,
  • Finish,
  • Predecessors (links),
  • Resource Names.

Export to PDF

Export to MS Project Empty Template (PDF)

The "MS Project Empty Template (PDF)" export covers all tasks, not only the ones visible on the page. 

The exemplary PDF export in the MS Project format:

Image Removed

Export to PDF image

The exported image is a screenshot of the current view and covers the whole timeline. As there might be blank areas on the timeline, for example, before the first task start, we recommend applying the date range filters to exclude the blank areas.

If you open the Resources panel and then export to a PDF image, the Resources panel will be included in the export:

  • export can be limited horizontally as a specific period
  • export contains all the tasks and resources
  • tasks and resources may be limited by filters and quick filters
Info

Image export requires NodeJS installation. If you do not see the "PDF image" export option, click here for more information.

The exemplary PDF image export:

Image Removed

Additional information

If you are encountering any issues during the installation process, make sure that the BigTemplate App is installed properly.

Info

To unlock the export features, install the BigTemplate App from the Atlassian Marketplace.

You can export your Gantt tasks to different formats, including:

  • PDF image,
  • CSV,
  • XLSX (MS Excel),
  • MPP, MPX, PDF, XML (MS Projects).

Click on the "Export" icon to start. 

Image Removed

Next, you will be asked to select the "File type" and define the "Range":

  • Full scope (all formats supported)
  • Specific period (PDF image supported)

When ready, click on the "Export" button. 

Image Removed

Info

Keep in mind that for the "Specific period" range, the available export format is PDF. Although you can still see other formats, they are not supported.

...

Depending on the format type, the exported file will also contain data from the Gantt chart.

It is not recommended to exceed 2.000 tasks while exporting data to a PDF file. Doing so can cause problems with generating the correct PDF and opening the file.

How to export Gantt data

  1. Click on the Export button.

...

  1. Select the File type from the drop-down menu and define the Range of the scope you want to export.

  • Full scope (all formats support full scope export).

  • Specific time range (only the PDF image supports partial scope export).

...

  1. Click on the Export button.

Export data to XLSX and CSV

Before exporting data, you can adjust the Column View and decide which columns should be visible in the exported file. To modify the Column View, click on the "Manage columns" icon, as presented below.Image Removed

...

Then, click on the "Export" icon and choose the XLSX or CSV file type.Image Removed

...

Depending on the Column View settings, the imported file can look similar to the one presented below.

Info

The fields related to the structure and dependencies of the tasks are added to each XLSX and CSV file by default (these fields are needed in the case of importing such a file to BigPicture afterward): 

  • Key, 

  • Parent Row, 

  • Issue Type, 

  • Start Date, 

  • End Date, 

  • Parent Key, 

  • Link.

...

Actions that temporarily change data display in the Gantt module, such as Sort by feature, have no effect on the exported data.

Custom templates

To avoid modifying the Column View section before each export, you can easily prepare templates that will be tailored to your needs . You can and use them with no need without needing to adjust displayed columns. 

For more instructions on how to prepare custom templates, refer here

Export to MS Project

All file types use the same format compliant with the MS Project. At the moment, although it is possible to import Although importing a customized template of the MPP type is possible, it does not affect the imported data. Pairing a column with the ID of a given custom field is currently not possible due to a fixed set of fields, which are hard-coded in the app. This set contains the following custom fields:

  • Task Name,

  • Duration,

  • Start,

  • Finish,

  • Predecessors (links),

  • Resource Names.

Export to PDF

Export to MS Project Empty Template (PDF)

The "MS Project Empty Template (PDF)" export covers exports all tasks, not only the ones just those visible on the page. 

The exemplary PDF export in the MS Project format:Image Removed

...

Export to PDF image (screenshot only)

The exported image is a screenshot of the current view (not clickable) and covers the whole timeline. As there might be blank areas on the timeline, for example, before the first task startstarts, we recommend applying the date range filters to exclude the blank areasthem.

If you open the Resources panel and then export to a PDF image, the Resources panel will be included in the export:

  • export can be limited horizontally as a specific period

  • export contains all the tasks and resources

  • tasks and resources may be limited by filters and quick filters

Info

Image export requires NodeJS installation. If you do not see the "PDF image" export option, click here for more information.

The exemplary PDF image export:

...

Export tasks without dates

The exporting mechanism lets you export:

...

  • tasks with no dates

  • tasks with a single date (start or end)

Additional information

If you are encountering encounter any issues during the installation process, make sure that ensure the BigTemplate App is installed properly.

...