Content
 BigPicture

About BigPicture

BigPicture installation

Quick start with BigPicture

BigPicture Export

Tutorials and tips

Integrations

 BigPicture release notes

BigPicture Cloud Backlog

 BigGantt

About BigGantt

BigGantt - Important Notice

BigGantt installation

BigGantt Cloud Backlog

 BigGantt release notes

Shortcuts
 Release notes
 BigPicture
 Jira Cloud

 Jira Server

 Trello

 BigGantt
 Jira Cloud

 Jira Server

 BigTemplate
 Jira Cloud

 Jira Server

 BigPicture Enterprise
 Jira Cloud

 Jira Server

Knowledge Base

Tutorials and tips

Search

Importing

This bar will allow us to go through a process of creating a completely new Program and Jira Project based on the settings which we import from either MS Project ( MPX / MPP ) or MS Excel ( XLS / XLSX ) files of which 'Sample Projects' can be found below:

SampleExcelProgram.xlsx

SampleMSProjectProgram.mpp

Sample MS Project structure:

When importing from MS Project or MS Excel to BigGantt, it's possible to change the representation of imported project in our applications. For now you can choose only from 2 possible Import WBS Strategies: a 'Structure Based On Tasks' and a 'Structure Based On Epics'. Once we pick one of these two options we will be introduced to the Basic data screen as in every previous case, though in here we will see an additional option which allows us to Browse a file from which we would like to import.

Importing MS Project file into a Gantt chart

The following fields from a MS Project files can be imported to Gantt module:

MS ProjectGantt module (Jira)
Task nameSummary
StartField mapped as the "Start date" in Global configuration - Task configuration when importing to an existing Project.
Finish

Field mapped as the "End date" in Global configuration - Task configuration when importing to an existing Project.

PredecessorDependency link as mapped in Global configuration - Link configuration
WBSWBS (Structure based on tasks or Epics)


Importing MS Excel file into a Gantt chart and WBS

Here's a template of a spreadsheet example and its cells allocation being formatted and ready for an import of the MS Excel file after it was firstly exported from a basic Gantt chart (to *.xlsx format).

The only Task Parameter that can be imported from the table formats (.xlsx or .ods) are:

  • Summary - A name of the Task.
  • Start Date, End Date - beginning and the end of the Task (should have format 'YYYY-MM-DD').
  • Parent Row - ordinal number of Excels row in which the parent of the Task is placed.
  • Link - a cell with dependencies / links, for example: 16FS-1 or 21SS+1, where:
    • 16, 21 - pointer to Excel's row with linked task;
    • FS, SS - link type:
      • FS - finish to start;
      • SS - start to start;
      • FF - finish to finish;
      • SF - start to finish.
    • -1/+1 - link lag in days.

Step-by-step guide

  1. Format your XLSX/ODS file with the previously described rules.

  2. Go to BigPicture/BigGantt Program manager → 'Add new Program' → 'Import data from file'
  3. Pefrorm steps from ImportingDataFromaFile and choose your XLSX/ODS file to import.
  4. Click 'Import MS Excel' and you will see dialog in which you should map fields from your files to task parameters
  5. 'Show' BigPicture/BigGantt which XLSX/ODS columns corresponds to BigPicture/BigGantt task fields.
  6. Voilà! Your file is imported!

Structure BasedOn Tasks

Structure BasedOn Epics