QuNect Restore

Restore your Quick Base Tables and File Attachments without Limits!

Please install the prerequisite QuNect ODBC for Quick Base first!

Please watch this getting started video 

QuNect Restore allows you to restore a Quick Base table from a CSV (comma separated values) file on your local hard drive. QuNect Restore allows you to selectively choose which records are imported. In advance of importing it will check for missing required values and duplicates in unique fields. QuNect Restore will upload file attachments including all revisions, not just the current revision. In bulk restore mode QuNect Restore traverses a directory of backup files created by QuNect Backup, restoring all the CSV files discovered in the directory and relinks restored child records to their restored parent records. QuNect Restore is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for Quick Base is required. Licensees of QuNect ODBC for Quick Base can use QuNect Restore for free. QuNect Restore requires MS Windows and .NET Framework 4.5.

Automating QuNect Restore using Windows Scheduler

  1. The first step is to install QuNect ODBC for Quick Base from this link.
  2. The second step is to install QuNect Restore from this link. This will make sure that your computer has all the .NET prerequisites and will put a shortcut on your Start menu. However the QuNectRestore.exe executable is buried in some inscrutable location. This makes it hard to configure Windows Scheduler.
  3. So to make it easier you can download QuNectRestore.exe from this link. Place it on your hard drive where you can browse to it easily. I would recommend putting it in C:\Program Files\QuNect ODBC for Quick Base or on 64 bit machines in C:\Program Files (x86)\QuNect ODBC for Quick Base. The following instructions will assume you've done so.

Windows 7

Open Task Scheduler by clicking Start, click All Programs, point to Accessories, point to System Tools, and then click Task Scheduler.

  1. On the Action menu select Create Task
  2. On the General tab give your task a name.
  3. on the Actions tab click New... and then click Browse, navigate to C:\Program Files\QuNect ODBC for Quick Base or on 64 bit machines to C:\Program Files (x86)\QuNect ODBC for Quick Base and then click on QuNectRestore and then click Open.
  4. In the input box labeled Add Arguments (optional) you will add six command line arguments.
    1. The full path to the folder containing the .csv file and the .fids file. You will want to enclose this in double quotes. The path should not end with a trailing backslash. The .fids file needs to have the same name before the extension as the .csv file. The filename (before the .csv or .fids extension) should be the dbid of the destination table in Quick Base. The first and only line of the .fids file should be a period delimited list of the fids that each column of the .csv file should be imported into. To ignore a column in the .csv file pair it with a zero.
    2. Quick Base username
    3. Quick Base usertoken for the above user
    4. The Quick Base host name for your realm. For example mycompany.quickbase.com
    5. A "1" if you need to use a proxy server to connect to the Internet, otherwise "0"
    6. A "1" if your .csv files have field names on the first line, otherwise "0"
  5. You can learn about the other features of Windows Task Scheduler here.