Synchronize with Microsoft Project

Once you've turned your Microsoft Project file (or files) into a Quick Base application, you can continue to work in both programs at once. Download updates from Quick Base to your local Project file or work in your Project file and upload changes to Quick Base.

Note: Only applications created using the Quick Base Project Synchronization tool are on speaking terms with Microsoft Project. Before you can follow the steps below, you must turn your Microsoft Project Plan into a Quick Base application.

To synchronize between Quick Base and Project:

  1. Open the Quick BaseProject.mpp file in Microsoft Project.

    You downloaded this file when you turned your Project file into a Quick Base application. Can't find it? Right-click this link and select Save Target As or Save link as from the menu that appears.

  2. Open the Project file that you want to synchronize with Quick Base.

    This file lives on your computer's hard-drive or local server.

  3. Make Quick BaseProject.mpp the active file in Project.

    From the Project menu, select Window > Quick BaseProject.mpp to display the file on your screen.

  4. Press Ctrl+Q.

    A Quick Base Authentication prompt appears.

  5. Type in your Quick Base username and password and click Sign in.

  6. From the Pick an .mpp file dropdown, select the file you want to synch with Quick Base.

  7. Within the Connect to section, select the an existing Quick Base Application radio button.

  8. If this is your first time synchronizing, you must set synchronization options (see next section, below).

  9. Copy data.

    Tell Quick Base which way to move the data by clicking one of these two buttons:

If your Quick Base application consists of multiple Project files, repeat the steps above for each Project that you want to synchronize.

Setting Synchronization Options

When you open the Quick Base Project.mpp file, press Ctrl+Q and enter your Quick Base username and password, Quick Base displays the Synchronization dialog box. The first time you did this, you were creating a Quick Base application out of your Project file and Quick Base copied over all the fields it could. If you plan to synchronize (copy data between the two applications regularly) Quick Base needs some additional information, so the program knows what to copy.

To set synchronization options:

  1. Tell Quick Base how you track progress in Quick Base.

    If staffers will update their time in Quick Base and you'll copy the updates back down to Microsoft Project, tell Quick Base what field you'll use to track progress. Within the Synchronization dialog box, click the Choose a Progress Tracking Method button. The dialog box that displays offers the following options:

    When you've made your selection, click OK.

    Note: Your Quick Base application is automatically set to track staff progress using the Percent Work Complete field. There are other fields available (like those listed above) for this purpose. However, these alternate fields are marked as Read only on the Assignment table's View/Add/Edit form and on the Task table's View Task form. If you want to use any of these fields instead, make them available (in other words, turn off the read only setting), by editing the form.

  2. Tell Quick Base which fields to synchronize and which direction the data will move.

    If you plan to copy data from Quick Base back into your Microsoft Project plan, you need to tell Quick Base what fields you want the sync tool to copy. Within the Synchronization dialog box, click the Configure Additional Fields to Import from Quick Base button. The Quick Base Project Field Mapping dialog box opens. Here, you'll tell Quick Base which fields are important to you and if you want their values entered in Quick Base and copied to Project, or vice-versa. The dialog box feature three tabs (Tasks, Assignments and Resources) which represent tables in your Quick Base application. Each tab features a pane on the left and a pane on the right.

    When you've made your selections, click OK.

Related Topics:


Go back      |       

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.