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
The first step is to install QuNect ODBC for Quick Base 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
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.
Open Task Scheduler by clicking Start,
click All Programs, point to Accessories, point to System Tools,
and then click
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 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.
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 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.