Importing data from outside Quick Base

You can start a new app by importing a file to create an app or by pasting data to create an app.

If work on your app is already well-underway, you can still import data from outside of Quick Base at any time.

Note: As an alternative to importing data, you can add a connected table to display and automatically refresh data from:

You can select the fields that you want to include in your connected table and automatically refresh the table, based on a schedule that you set. You can also refresh connected tables on-demand, any time you want.

Since the data in connected fields comes from an external app, service, or CSV file in a connected folder, you can’t edit the data in connected fields. This helps to keep your data in sync and eliminate potential confusion about which system contains the most up-to-date information.

To import data into an existing app, you can:

When you import data into an existing app in Quick Base, Quick Base either adds the new records to an existing table (a normal import), or replaces existing Quick Base records with those that you import (an update import). Quick Base decides which type of import you want based on whether or not you import data into the destination table's merge field.

If you have chosen to import data into a merge field, Quick Base checks each row of data to see if there's a match between the value for that merge field and any value that already exists in the merge field in your table. If it finds a match, Quick Base updates the matching record with the new data you're importing. If it doesn't find a match, Quick Base creates a new record.  

For example, you have an app that manages language classes your business offers. In the Course table, you change the key field from the Record ID to the Course ID (which you know will always be unique). Records in your app might look like this:

Now, let's say you go to the Import page, copy and paste the following data, and keep Course ID as your merge field: 

Course ID, Course name, Description

201009, Advanced French, "This course describes how to build complex sentences, etc."

201111, Italian for Beginners, "This course covers basic Italian vocabulary, conversation, etc."

Because you are importing into your merge field (Course ID), Quick Base checks to see if there's a match between any value you're trying to import into your merge field and an existing value. In this case, it finds a match in Course ID 201009.

Therefore, Quick Base takes the following actions:

  • Updates Course ID 201009 with a new Course name (Advanced French) and the new description

  • Adds Course ID 201111 to the table

Read more about formatting data for import by pasting, and importing blank values.

Copy and paste data from another program

To copy and paste data from another program:
  1. In your source document, highlight the text that you want to copy, and choose Copy from the Edit menu.

    You can copy tables from a word-processing document, or specific rows or columns from a spreadsheet program.

  2. Open the Quick Base app into which you want to paste the data.

  3. Choose Import/Export from the More menu on the right.

  4. Choose Import into a table from the clipboard.

  5. In the Select Table section, select the table into which you want to import data.

  6. In the Select Merge Field section, choose a field in your table to match imported data to existing records. Read more about merging.

  7. In the Paste Data section, paste the data that you want to import.

  8. Click Import Data.
    Quick Base analyzes your data, and then displays a preview of the results.

    Note: Quick Base may display a warning prompt to let you know that you're about to perform an "Update import.” If you don't want to do so, remove the merge field from your import. To remove it, locate the field and click Do Not Import at the top of the column.

  9. Check the Import Data page to ensure that the field labels for each field (column) are correct and that the data is properly aligned. To do so:

    • Examine the data displayed beneath each field label. If the column is set for importing into an existing field, check that the correct field label is showing or else select it in the drop-down menu. If the column is set for creating a new field, check that the correct field type is shown or else select it in the drop-down menu. Also enter a label for this new field.

    • If you want to import a column's values into a different field, click the drop-down and select the correct field.

    • If you want to import the values but there's no appropriate field to receive them, create a new field. To create a new field, click Create New Field at the top of the column, select a field type, then enter a label for the field in the Field Label box.

    • For new fields, if a field type isn't correct, select the appropriate type from the drop-down at the top of the column. Remember, fields that stored parts of addresses should be matched to Address subfields.

      Tip: If you import values that are also people who'll use your Quick Base app, import those values into a User field. (Read more about user fields.) When you import into User fields, you can import text or—if you've got them—email addresses. When you import text into a User field, Quick Base creates placeholders that you can later convert to user values. If you import email addresses, Quick Base can immediately match a value with the Quick Base user who's registered with that email address. So, if you can, try to import email addresses instead of names. You can save time later.

    • If you don't want to import any of the values that appear under a particular field, select Do Not Import at the top of the column.

  10. Click Import or Import (with Update).

    If the import creates new fields, Quick Base displays a warning message asking you to confirm the action. If this isn't your intention, click Cancel, then edit your import (refer back to Step 8). Otherwise, click OK.

    Quick Base tells you how many records you created or updated.

    Note: If the program created placeholders to populate a User field, Quick Base displays the number of placeholders created. A Replace Placeholders link appears in the explanatory text. Click Replace Placeholders to convert placeholder values to real users. If your roles include the Manage users and share the app permission, you can convert placeholders later, via the Users page.

  11. To access the app, click Go to the App Home Page.

Import data from a file

To import data from a file:
  1. If your data is in Microsoft Excel 2007 or later, you can import the .xlsx file. Read more about importing data from Excel into existing applications.

    Otherwise, open the file in the original program that created it, then export the file as a tab-delimited (.tsv) or comma-delimited (.csv) file. If there's no Export command, click Save As and specify either file type.

    Tip: If you have rows that contain explanatory text, remove them before you save the file as a tab-delimited (.tsv) or comma-delimited (.csv) file. Import only column headings and records into Quick Base. Doing so helps Quick Base analyze the structure of your data.

  2. Open the Quick Base app into which you want to import data.

  3. Choose Import/Export from the More menu on the right.

  4. Choose Import into a table from a file.

  5. In the Select Table section, select the table into which you want to import data.

  6. In the Select Merge Field section, choose a field in your table to match imported data to existing records. Read more about merging.

  7. In the Choose file section, click Browse, select the Excel (.xlsx), comma-delimited (.csv), or the tab-delimited (.tsv) file that you want to import, then click Open.

  8. Click Import from File.

    The Import Data page displays, showing you how Quick Base will structure the import.

    Note: Quick Base may display a warning prompt to let you know that you're about to perform an "Update import.” If you don't want to do so, remove the merge field from your import. To remove it, locate the field and click Do Not Import at the top of the column.

  9. Check the Import Data page to ensure that the field labels for each field (column) are correct and that the data is properly aligned. To do so:

    • Examine the data displayed beneath each field label. If the column is set for importing into an existing field, check that the correct field label is showing or else select it in the drop-down menu. If the column is set for creating a new field, check that the correct field type is shown or else select it in the drop-down menu. Also enter a label for this new field.

    • If you want to import a column's values into a different field, click the drop-down and select the correct field.

    • If you want to import the values but there's no appropriate field to receive them, create a new field. To create a new field, click Create New Field at the top of the column, select a field type, then enter a label for the field in the Field Label box.

    • For new fields, if a field type isn't correct, select the appropriate type from the drop-down at the top of the column. Remember, fields that stored parts of addresses should be matched to Address subfields.

      Tip: If you import values that are also people who'll use your Quick Base app, import those values into a User field. (Read more about user fields.) When you import into User fields, you can import text or—if you've got them—email addresses. When you import text into a User field, Quick Base creates placeholders that you can later convert to user values. If you import email addresses, Quick Base can immediately match a value with the Quick Base user who's registered with that email address. So, if you can, try to import email addresses instead of names. You can save time later.

    • If you don't want to import any of the values that appear under particular field, select Do Not Import at the top of the column.

    • If you want to import the values but there's no appropriate field to receive them, create a new field.

      To create a new field, click Create New Field at the top of the column, select a field type, then enter a name for the field in the Field Label box.

  10. Click Import or Import (with Update).

    If the import creates new fields, Quick Base displays a warning message asking you to confirm the action. If this isn't your intention, click Cancel, then edit your import settings (refer back to Step 8). Otherwise, click OK.

    Quick Base tells you how many records you created or updated.

    Note: If the program created placeholders to populate a User field, Quick Base displays the number of placeholders created. A Replace Placeholders link appears in the explanatory text. Click Replace Placeholders to convert placeholder values to real users. You can do this at any time.

  11. To access the app, click Go to the App Home Page.

Importing from a relational database

Before you import data from a relational database into a Quick Base app, decide whether you want the app to preserve relationships based on the primary and foreign key fields in the relational database.

To import data without preserving relationships:
  1. Export the data from the relational database to Microsoft Excel (2007 or later) files, comma-delimited (.csv) files, or tab-delimited (.tsv) files.

  2. You can do one of the following tasks:

To import data and preserve relationships:
  1. Export the data from your the relational database to Microsoft Excel (2007 or later) files, comma-delimited (.csv) files, or tab-delimited (.tsv) files.

  2. Create a new Quick Base app from scratch, change the key field of each table so that it corresponds to the key field in the relational database, and set up the table, relationship, and field structure that matches the relational database structure. The exceptions are:

    • Quick Base does not support compound keys.

    • Quick Base supports auto-numbering key fields only with the built-in field called Record ID#. You cannot import information into the default "Record ID#" key field, or into any of the other four Quick Base built-in fields. Follow the steps below if you have an existing auto-numbering key field and want to preserve relationships when you import your data into Quick Base:

      1. Create a Numeric field in Quick Base and designate it as the key field.

      2. Import your data into the table, then map the auto-numbering key field to the key field from step 1.

      3. If you are not planning to use the relational database anymore, change the key field back to the built-in "Record ID" field so that you can continue to have an auto-numbering key field in Quick Base.

        Quick Base takes care of managing all the relationships; changing the key field does not disrupt any relationships between records across tables.

  3. Import the file for each table into Quick Base.

 

 

Go back      |       

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