Home > MSProject-BaseCamp-Sync

MSProject-BaseCamp-Sync

MSProject-BaseCamp-Sync is a project mainly written in ..., based on the View license.

One way sync from MSProject to BaseCamp

h1. MSProject-Basecamp-Sync

This project is a Visual Basic module that I wrote for MSProject to send task and milestone information to Basecamp. Basecamp is an awesome project management system made by 37signals - http://www.basecamphq.com

h1. Overview

After installation (see below) the macro will perform the following sequence of events:

Each milestone in the projected is synced. The milestone name, deadline and responsible party are sent to Basecamp. A todo list is created for each milestone.

Then each task for the milestone is synced. The task name, due date and assignee and sent to Basecamp and added to the milestones todo-list.

h2. Some notes

The names of people in Basecamp must be exactly the same as MSProject

Tasks that are not indented within a milestone are ignored

h1. Installation

h2. Importing the class file

You need to import the class file into each MSProject file you want to sync.

Download the MSProject-Basecamp-Sync.cls file from github.

Open your MSProject file

Click on the Tools -> Macro -> Visual Basic Editor menu or press Alt+F11

From the Visual Basic editor window, click on the File -> Import File ... menu or press Ctrl+M

Select the MSProject-Basecamp-Sync.cls file and click Open

A new folder called "Class Modules" will appear. Expand the folder and double-click the MSProject-Basecamp-Sync icon

At the top of the file you need to edit the SERVER_URL, API_KEY and PROJECT_NAME constants.

The PROJECT_NAME constant must match exactly the name if the project in Basecamp.

After you have edited the constants you can click the Save icon and close the Visual Basic Editor.

h2. Adding a button to your MSProject toolbar

You only need to do this once and a button will be available for all your projects.

Click on the Tools -> Customize -> Toolbars ... menu

Click on the New.. button, enter BasecampSync for the Toolbar name and click OK

An empty toolbar will appear next to the dialog box.

Then select the Commands tab, choose All Macros from the categories list.

Click and drag the !BasecampSync command to the new toolbar.

Right click on the new button in the toolbar and select Assign Macro ...

Change the Command to 'Macro "BasecampSync"' then click OK

Now you can click a drag the new toolbar and dock it where ever you want

Previous:i18n_emails