How can I export and then reimport records so existing records are updated?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

It is possible and quite easy to import data into QuickBase in such a way that it will update existing records. The key to being able to do this is that you must include the key field so that QuickBase knows exactly what records to update. By default the key field is the "Record ID" field.

You should go through these steps to export then reimport records:
1) Create and display a report that includes the key field (or "Record ID") and all the other data you are interested in manipulating.

2) At the top of the report, click Other and select "Export this view to a spreadsheet" option. (If you don't see this choice, you don't have permission to export.) Your report opens in MS Excel.

3) Save the Excel file. Then make your changes to all columns other than the key field column which you'll need to leave intact. After making all your changes copy all columns and rows to the clipboard.

4) Please read the following instructions to learn how to import data from the clipboard into an existing application:

https://www.quickbase.com/help/importing_data.html#copy_paste

Tags:

34722 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base