You can get started with Dragonboat by importing your current Roadmaps from Spreadsheets. Migrating your data is straightforward - you can simply copy and paste the information directly from your spreadsheets into the Dragonboat platform.
This article covers:
Importing Portfolio Items from Spreadsheets
Here's a step-by-step guide to effectively Import Portfolio Items from Spreadsheets to Dragonboat:
1. Access Import Options: Begin by navigating to the Portfolio Roadmaps module and select the Import option.
Image:
2. Choose Copy/Paste Method: Within the Import Options, opt for the Copy/Paste approach to bring your Product items from the spreadsheet into Dragonboat.
-
-
-
-
Customize Import Fields: Utilize the drop-down menu to select the import fields you wish to incorporate. Once selected, move to the next step.
-
-
-
-
-
-
- Arrange Columns: Arrange columns by dragging the column headers as needed. Consider referencing a field mapping guide to correlate your spreadsheet columns with the appropriate Dragonboat fields. A recommended approach is to copy and paste one column at a time.
-
-
Note: Dragonboat does not support copy/paste method for dropdown custom fields. To do this, the user must:
1. Create Short Text custom field.
2. Import the drop down values into the Short Text custom field.
3. Search on the values in the Short Text custom field.
4. Bulk update the dropdown.
3. Visualize and Organize Your Roadmap:
Explore how your Roadmap appears in different modules and pages
Image: The new Roadmap items appear in Board page
Image: The new Roadmap items appear in List page, grouped by Goal
If further adjustments to the mapping are necessary, you can use the Bulk Update or Delete features to manage multiple Portfolio Items. This enables you to make modifications and re-import items as needed. Here is a quick video showing the copy/paste method in action!
Importing from Multiple Sources
For those situations where you have epics stored in Jira while your OKRs or Quarterly tracking information resides in Spreadsheets, a smooth solution is available:
- Import your Epics from Jira by using this guide.
- Use Bulk Update to integrate Portfolio data (e.g. OKRs, Timeframe, etc.) into Dragonboat.
Some related topics:
- Other ways to import Portfolio Items
- Grouping portfolio items on the List page
- Customizing system field naming conventions
- Creating a Visual Roadmap
FAQs:
How can I prevent the column from re-sorting after copying and pasting the data when importing portfolio items from spreadsheets?
- Check to see if the column header is accidentally set to sort by clicking on any columns, e.g. Title column 3 times or until you don't see the up and down arrow, in order to remove any potential sort anywhere.
- Instead of using copy and paste, it could be easier to import portfolio items from a CSV file, assuming all fields are filled-in.
---
Need help? Contact help@dragonboat.io or use the widget on the bottom right of your screen to search for help topics/ reach our product consultants.