Versions Compared

Key

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

Import from Asana to

...

Strategic Roadmaps

Export from Asana to CSV

In Asana, users have the option to export a CSV of their data by project or by tasks assigned to a user.

CSV Changes for

...

Strategic Roadmaps

When opening the CSV it will contain the data from your Asana project. Please note you will have to format it differently in order to make it compatible with RoadmunkStrategic Roadmaps

Mandatory Changes

The following changes must be made to the CSV file:

...

For more information on formatting including examples, please download a free template from our templates page.

Import to

...

Strategic Roadmaps

Once changes have been made the CSV can be imported to RoadmunkStrategic Roadmaps.

See the importing tutorial for further steps.

...

Import from Excel to

...

Strategic Roadmaps

In this guide, we'll walk through the 5 easy steps to follow when preparing an Excel roadmap for import into RoadmunkStrategic Roadmaps.

Step 1 - Identifying Data Pivots

...

The next step is to format the data in the spreadsheet by putting the pivot data identified in the previous step into separate columns for import into Roadmunk Strategic Roadmaps columns.

The roadmap spreadsheet should now have:

...

  • A Start Date and an End Date column containing the start and end dates of each date range represented in the spreadsheet using colored cells

  • Dates in the columns formatted as Numbers using a consistent format (e.g, 01-Dec-16)

NOTE: For the import to Roadmunk Strategic Roadmaps to be successful, each item in the Excel roadmap must have a Start and End Date. Even if you don't know what an item's dates are, add a best-guess date. You can always change this once the date is in RoadmunkStrategic Roadmaps.

Step 4 - Removing Extra Cells

...

  • an Item column for the items in the roadmap

  • Owner and Status columns with appropriate values

  • Start Date and End Date columns, containing the start and end dates of each item, formatted as Numbers, and using a consistent format. 

  • No blank rows or cells

Step 5 - Importing to

...

Strategic Roadmaps

Finally, save the Excel file as a CSV and import it into Roadmunk Strategic Roadmaps following the instructions in Import items from CSV.

...

Import from Pivotal Tracker to

...

Strategic Roadmaps

Exporting from Pivotal Tracker to CSV

...

  1. Delete Created at

  2. Delete Accepted at

  3. Delete Deadline

  4. Delete URL

  5. Delete Owned By

  6. Delete Comment

Advanced Changes

If Roadmunk Strategic Roadmaps will be regularly updated from Pivotal Tracker, we recommend renaming the ID field in the CSV to ExternalID. Roadmunk Strategic Roadmaps uses this field to match existing items so they're updated instead of overwritten.

Importing the CSV into

...

Strategic Roadmaps

Once changes have been made the CSV, you can start the import to RoadmunkStrategic Roadmaps. For details, see our article on importing data from CSV into RoadmunkStrategic Roadmaps.

...

Import from Rally to

...

Strategic Roadmaps

Exporting from Rally to CSV

...

  1. Delete Plan Estimate

  2. Delete Task Estimate Total

  3. Delete To Do

  4. Delete Parent ID

Advanced Changes

If Roadmunk Strategic Roadmaps will be regularly updated from Rally, we recommend renaming the ID field in the CSV to ExternalID. Roadmunk Strategic Roadmaps uses this field to match existing items so they're updated instead of overwritten.

Importing the CSV into

...

Strategic Roadmaps

Once changes have been made the CSV, you can start the import to RoadmunkStrategic Roadmaps. For details, see our article on importing data from CSV into RoadmunkStrategic Roadmaps.

...

Import from Trello to

...

Strategic Roadmaps

Exporting from Trello to CSV

...

  1. Delete CardID

  2. Delete ListID

  3. Delete Board ID

  4. Delete Last Activity Date

Advanced Changes

If Roadmunk Strategic Roadmaps will be regularly updated from Trello, we recommend renaming the CardID field in the CSV to ExternalID. Roadmunk Strategic Roadmaps uses this field to match existing items so they're updated instead of overwritten.

Importing the CSV into

...

Strategic Roadmaps

Once changes have been made the CSV, you can start the import to RoadmunkStrategic Roadmaps. For details, see our article on importing data from CSV into RoadmunkStrategic Roadmaps.

...

Import from VersionOne to

...

Strategic Roadmaps

Exporting from Version One to CSV

...

  • The first column in the CSV (Item) must contain the title of the feature or project task.

  • The file must contain separate columns for Start Date and End Date.

  • The file must contain a Bucket field and a Description field. Both fields can be left blank.

Importing the CSV into

...

Strategic Roadmaps

Once changes have been made the CSV, you can start the import to RoadmunkStrategic Roadmaps. For details, see our article on importing data from CSV into RoadmunkStrategic Roadmaps.