Import Data from Outside Quick Base

You can get a new application off to a running start by importing a file to create an application or by pasting data to create an application.

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

Note: Instead of 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 application, you can:

When you import data into an existing application 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 key field.

If you have chosen to import data into a key field, Quick Base checks to see if there's a match between any value you import into a key field and any value that already exists in the key 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, imagine you have an application 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 copy and paste the following data into the Import from Clipboard feature: 

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 key field (Course ID), Quick Base checks to see if there's a match between any value you're trying to import into your key field and an existing value. In this case, it finds a match in Course ID 201009.

Therefore, Quick Base takes the following actions:

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 application into which you want to paste the data.

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

  4. Choose Import/Export from the More dropdown.

  5. Select Import into a table from the Clipboard.

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

  7. Click Import Data.
    Quick Base analyzes your data, and then displays the results.

  8. 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:

  9. Click Import.

    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. You can do this at any time.

  10. To access the application, 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.  

    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 the program analyze the structure of your data.

    If you import data from a Microsoft Excel file, read more about importing data from Excel into existing applications. If you're importing from Microsoft Project, the process is slightly different. Read about importing Project data into Quick Base.

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

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

  4. Choose Import/Export from the More dropdown.

  5. Click Import into a table from a file.

  6. 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.

  7. 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" (see Tip above). If you don't want to do so, remove the key field from your import. To remove it, locate the field and click Do Not Import at the top of the column.

  8. 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:

  9. Click Create.

    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.

  10. To access the application, click Go to the App Home Page.

Importing from a relational database

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

To import data without preexisting key fields:
  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 with preexisting key fields:
  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 application from scratch with a table and field structure that matches the relational database structure.

  3. In Quick Base, change the key field of each table so that it corresponds to the key field in the relational database.

  4. Import the file for each table into Quick Base. The relationships are now set according to the key fields in the imported data. The exceptions are:

 

Go back      |       

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