Connecting to a folder containing CSV files

This topic refers to functionality that is not available to accounts on the Quick Base Essential plan. If the functionality described here does not match what you're seeing in Quick Base, your account is probably on this plan.

You can connect to folders containing CSV files stored in Dropbox, Box, Google Drive, or an SFTP server and sync data into a connected table in your Quick Base app.

Any data that you can save in CSV format, from any system, on premise or in the cloud, can automatically refresh in Quick Base, based on a schedule that you set.

As with all connected tables, the data that you bring in is read-only and can’t be edited in Quick Base. This helps keep your data in sync and eliminates potential confusion about which system contains the most up-to-date information.

You can update records in your connected table by refreshing the table to display data from the most recent CSV file(s) in your connected folder. We only look at CSV files in your connected folder.

You decide how refresh the data in your connected table. You can choose:

Before you connect to a folder containing CSV files

Make sure your CSV file:

Connecting to a folder containing CSV data

The first time you connect to Box, Dropbox, Google Drive, or an SFTP server, we'll guide you through connecting, creating a folder, and adding your CSV file:

  1. Open your Quick Base app, click New Table in the table bar, and select Using connected data.

  2. Name your table, click Next, and select your file storage location: Box, Dropbox, Google Drive or SFTP.

  3. Give your connection a name and then Sign in.

  4. The first time you create a connection, we'll create a Quick Base Sync folder in your account. Then, we'll ask you to:

    1. Go to the service, for example, Dropbox.

    2. Create a new folder within the Quick Base Sync folder.

    3. Put a CSV file inside the folder you created. Each time you refresh, we'll use the most recent .csv file in the folder, regardless of the file name.

  5. Return to Quick Base and click Yes, I did to continue. The folder you added inside the Quick Base Sync folder displays.

  6. Select the folder and then choose the fields you want to connect. These fields become text fields in the connected table. Later, you can change field types. The first row of the CSV file becomes the column names in your connected table.

  7. Optionally, define a filter to limit the records that you connect.

  8. Select refresh options to define when and how to refresh the connected table. We'll always use the most recent CSV file in your connected folder when refreshing your table.

    1. Refresh Key - Select a field that makes each record unique. It must be a connected field with unique values (no blanks).

    2. Table updates

      Choose Keep everything in my table and add new records to keep all the data in your connected table, even if it is not in the most-recent CSV file. Existing records will updated and new records added.

      Tip:This is a good choice if your table serves as an archive of all records.

      For new CSV-connected tables, you can also use this option when your source folder contains multiple files.

      Choose Make my table match the latest CSV file to overwrite your table so it matches the latest CSV file exactly.

    3. Schedule - optionally, set a schedule to automatically refresh using the most recent CSV file in your connected folder. You can refresh your table any time by clicking Refresh Data .

Later, you can update the CSV file or put a new CSV file in your connected folder, and then refresh your table to keep in sync with your latest changes.

If connected records don't display in your new table, click the yellow warning icon beside Refresh Data for details and then check out Troubleshooting connected tables for tips.

Connect to a folder with multiple files

For CSV-connected tables, you can sync data from files dropped into your CSV folder from multiple sources, like invoice data from different vendors. Or, suppose your order management system outputs multiple CSV files every hour. You can ensure each of the files will be synced to your connected table.

Here's how it works:

Warning:  As a best practice, do not create more than one "keep everything" connected table that points to the same CSV folder, since files that are processed and moved to the Done folder when you refresh one connected table won’t be available for refreshing another connected table.

Connecting more folders

After you've created a connected folder in your Box, Dropbox, Google Drive, or SFTP server, you can add another connected folder by going to the service, creating a new folder inside the Quick Base Sync folder, and putting a CSV file inside it. When you create a new connected table, your new folder will display in the list of folders you can connect.

View connected table details and history

To view Details about your connected table, including the connected service, connection owner, connected fields, filter, and schedule for the connected table, access the connection in Table Settings. You can also view a History of recent refreshes, and edit the connection filter, refresh schedule, or switch to use a different connection, if necessary.

View, test, or delete your connections

To view details about your connection and test, change, or delete connections, click the user dropdown on the Global bar, then click My preferences. Your connections display in the My Connections area.

Related Topics:

 

Go back      |       |   

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