Import Data from Other QuickBase Applications

If you've created several applications to hold your data, you probably have a good reason for storing that data separately. At some point, however, you may want to gather data in one place to track or compare records across multiple applications. For example, a manager responsible for many separate projects (each stored in its own application) may want a way to view progress on all of them at once.

The Import from Table feature lets you solve problems like this by moving data across applications. You can collect data from many separate applications and feed it into one application. You can pick the specific fields and records that you want to extract and consolidate them in one or more tables. Then you can view and sort the results however you wish.

Note: You cannot import file attachments. If you map a source file attachment field to a text field, the text with the field name copies, but files don't.

What you can do with this feature

There are two types of imports:

If you want to create a Merge import, follow all the steps below.

If you're creating a Copy import, skip ahead to the section called Create the destination application.

Prepare source tables for import

Say you want to merge task records from all your project applications together in one table. You want to do this every week so you can keep up with progress in different departments. No problem. You can set up an import and repeat it each week. But how do you ensure that the records you imported last week are replaced with their updated versions this week?

In order for a merge like this to work, QuickBase needs a way to match records in the source table with corresponding records in the destination table. You make this possible by setting up special fields in both tables that hold unique matching values. This is called a merge key.

Get started by creating a new field in the source table. Keep in mind that you'll eventually import this field's values into the destination table (which may include data from multiple tables). So, you want records in this field to be unique (like those in a key field) and also to indicate what source table they came from. Meet both requirements at once by filling this field with a combination of the table name and key field value (usually Record ID#).By doing this, no two records will have duplicate values in the merge field of your destination table and you'll always know where each record originated.

To prepare each of the source tables:
  1. Open the source application.

  2. Add a field to hold the new record identifier you create.

    1. Add a field to the source table.

    2. Name it something like "ExportID," then under field type, select Formula - Text.

  3. Create a formula for the new field.

    1. Click the name of the new field to display the Field's Properties.

    2. In the Formula box, type the formula that creates a combination of table name and key field value.

      For example, "TableName-" & [Record ID#]. For example, if your table is Tasks name this "Tasks-" & [Record ID#].

    3. Then click Save.

    Note: If you get an error message, check your formula to make sure the field name matches exactly and that you don't leave out any characters. (Read more about using formulas.)

  4. Repeat the steps above for each table that you want to import into the application you're about to create.

Create the destination application

Create the destination application, including the destination table(s) into which you'll import the source data. While creating the new table, add fields that correspond with fields you want to import from your other applications. These field names can match those in the source tables or they can be different. Later, when you set your import preferences, you can map which source field's data feeds into which destination field or just let QuickBase match up fields that have identical names.

If you create a Merge import and you follow the steps in the preceding section, Prepare source tables for import, you need to perform one more step before you configure the import. You must create a new field to hold the merge key values from your source tables.

To create a new field to hold the merge key values from your source tables:
  1. In the destination table, add a field (text type), then name it, for example, SourceID.

  1. Select the Values in the field must be unique checkbox to make the new field a unique field.

    The new field must be unique; it cannot contain duplicate values.

    The first time you merge records during an import, QuickBase populates this field with the merge key values from the source table. During any merge after that, QuickBase matches these values to update matching records in your new application.

Import to the destination table

Begin the import by telling QuickBase where to get the source data and exactly what data you want. Once you configure all your preferences, you can import the data to populate your new application. If you repeat the same import often to see updated information on a regular basis, you can save the import settings. Doing so speeds future imports and ensures that they are identical.

To import to the destination table:
  1. Open the QuickBase application into which you want to paste the data.

  2. If your application has multiple tables, select the table into which you want to import data.

  3. Select Import/Export from the More dropdown.

  4. Select Import into a table from another table.

  5. Click Import from another table.

    The Import from Table screen displays.

  6. If you have multiple tables in your new application, click the tab containing the name of the destination table.

  7. Click Create a new import.

  8. Click Choose a source table.

    QuickBase displays a list of applications to which you have access and which belong to the same billing account as the destination application.

  9. Select the radio button to the left of the application containing the source data, then click OK.

    A list of tables in that application appears.

  10. Select the radio button to the left of the table containing the source data, then click OK.

    QuickBase displays additional import setting options.

  11. In the Import type section, select one of the following:

  12. Set the merge key field.

    Here you'll tell QuickBase to take the values from the new combination field you created in the source tables (see the first section, Prepare source tables for import) and merge them together into your new application's merge key field.

    1. Select the formula field you created in the source table (which combined table name and Record ID#) from the Source Field list on the right.

    2. Select the merge key field you created in your destination table (see Create the destination table section above). from the Merge Key Field list.

      Note: The only fields available in this list are unique fields. For more information, see Create Destination Table.

  13. In the Matching section, choose the criteria that the data should match to import records:

  14. In the Field Mapping section map you map where to put the data QuickBase gets from each field in your source table. Select one of the following options:

  15. Click Import to populate your new table or click Save & Import if you want to repeat this import again.

    QuickBase saves your settings and imports the data at the same time. Then, the next time you select the Import from Table function to populate this destination table, you don't need to configure the import options again. Instead, you can run the saved import.

 

Return to top   

© 1999-2014   Intuit Inc.  All rights reserved.  Legal Notices.