QuNect Restore allows you to restore a Quickbase 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 QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect Restore for free.
QuNect Restore requires MS Windows and .NET Framework 4.5.
Automating QuNect Restore using Windows Scheduler
The first step is to install QuNect ODBC for QuickBase from this link.
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.
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 QuickBase or on 64 bit machines in
C:\Program Files (x86)\QuNect ODBC for QuickBase. 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.
On the Action menu select Create Task
On the General tab give your task a name.
on the Actions tab click New... and then click Browse,
navigate to C:\Program Files\QuNect ODBC for QuickBase
or on 64 bit machines to
C:\Program Files (x86)\QuNect ODBC for QuickBase and then click
on QuNectRestore and then click Open.
In the input box labeled Add Arguments (optional) you will add six command line arguments.
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 Quickbase.
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.
ODBC for QuickBase
QuNect Restore
