Import Tasks into Timeline/Gantt from File
If you have an existing project planned outside of Jira and want to manage it in TeamBoard ProScheduler, you can easily import the file instead of manually recreating the project. Your Timeline and Gantt chart will automatically populate with all the project details.
We allow users to directly import files in formats such as .mpp, .mpt, .csv, .xls, and .xlsx into ProScheduler’s Timeline and Gantt charts, streamlining the transition between project management tools. To proceed, follow these steps:
Go to TeamBoard and navigate to the Timeline or Gantt tab.
Click on the "Import icon” located at the top right corner.
In the Import window, click "Browse” and upload a specific file (Supported file formats: .mpp, .mpt, .csv, .xls, .xlsx). Select a project you want to import.
Map the following fields from your file to TeamBoard fields:
Summary (Required): Your task name will be imported as Issue Summary
Start Date and End Date (Optional): Start and end dates of tasks (Accepted date formats: YYYY-MM-DD, DD/MMM/YY, DD-MM-YYYY, MMM-DD-YYYY)
Parent Row (Optional): The row number of parent tasks in your file. Map this field and check the "Convert parent issues to Epic" box to import the task as the parent-child hierarchy (Hierarchies supported: Epic → Task)
For reference, see the example .xlsx file format below:
Click “Import” and see the result
Tips for a Smooth Import:
Ensure that your file is properly organized and up-to-date.
Resolve any missing dependencies or conflicting data before importing.
Use filters and grouping in ProScheduler to organize your imported tasks more effectively.
Export Tasks to File from Timeline/Gantt
The export feature offers a customizable column selection, enabling you to include only the relevant data in your spreadsheet.
Click on the "export" button. A dialog box will appear with a list of available columns.
Choose the columns you want to include in your Spreadsheet.
Click the "Export" button to generate the file.
Please note: To export the desired columns to your spreadsheet, you must add those columns to the left pane of the Timeline/Gantt chart before exporting.
