2. Import Data / 3rd Party App Integration

Import From Files (includes projects, time, resources, roles)
Roadmap API


Roadmap supports Basecamp, Basecamp Classic, or one of each account types simultaneously. Go to Connecting Applications > Basecamp after watching the tutorial below.

Related topic:
Clean-up old Basecamp data

Important! Roadmap syncs with Basecamp through a single user's Basecamp credentials. This was done for simplicity / reliability purposes. Thus, changes that trigger a Basecamp email update -- like marking a to-do as complete -- are "funneled" through this single Basecamp user.

Integrate with GitHub

Go to Connecting Applications > GitHub after watching the tutorial below.

Integrate with JIRA

  1. Go to Atlassian Marketplace
  2. Install the add-on
  3. Follow the steps outline in JIRA add-on is installed, now what?

Import From Files

Some prerequisites to run through before getting started:

  • You must be an admin to import time log files
  • File type must be .CSV, .XLS or .XLSX and not be password protected
  • If importing time data, time tracking must be enabled
  • Recommend Excel 2010 or higher (Windows) or Excel 2011 or higher (Mac)
  • Spreadsheet columns or fields (required in bold)
Projects Time Resources
Project Name
Project ID
Start Date
End Date
Project Status
Project Health
User Access Group
Project ID or Project Name
Resource ID or Resource Name
To-Do Item Name
Milestone Name
Resource Name or First Name + Last Name*
Resource ID

How to add individual users / resources

Role Name
Standard Rate***
Download sample Download sample**** Download sample
Do not use if integrating w/ 3rd party app
Download sample
Go to Settings > Import when file to be imported is ready.

* 2 separate columns
** Does not invite or automatically create new user
*** Do not include currency symbol
**** Sample file user "." as decimal separator. Be sure decimal separator matches account numeric display.

Roadmap API

The API must be enabled to support the Basecamp and GitHub browser extensions, as well as the JIRA add-on. Go to Connecting Applications to enable it (documentation).

◀︎ 1. Account Set-Up   |   3. Add or Configure Resources

Return to top

Feedback and Knowledge Base