ODBC for QuickBase

Application Note for QuNect Backup

Automating QuNect Backup using Windows Scheduler

1. The first step is to install QuNect ODBC for QuickBase from this link.
2. The second step is to install QuNect Backup 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 QuNectBackup.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 QuNectBackup.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.

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 QuickBase or on 64 bit machines to C:\Program Files (x86)\QuNect ODBC for QuickBase and then click on QuNectBackup and then click Open.
4. In the input box labeled Add Arguments (optional) you will add nine command line arguments.
   1. The full path to the folder that will receive the .csv files and the .fids files. You will want to enclose this in double quotes. The path should not end with a trailing backslash.
   2. A semicolon delimited list of the dbids that should be backed up. Or specify "all" to backup all the tables the user token has access to.
   3. Quickbase username
   4. Quickbase usertoken for the above user
   5. The Quickbase host name for your realm. For example mycompany.quickbase.com
   6. A "1" if you need to use a proxy server to connect to the Internet, otherwise "0"
   7. A "1" to create a separate folder for each day, otherwise "0"
   8. A "1" to create a separate folder for each Quickbase application, otherwise "0"
   9. A 0, 1, 2, or 3 to configure the download of file attachments.
      • "0" to prevent attached files from being backup up.
      • "1" to download current revision and current rev file URL in CSV.
      • "2" to download all revisions and current rev file URL in CSV.
      • "3" to download all revisions and all file URLs in CSV.
   • Here's an example of the arguments portion of the command line

   • "C:\Users\claude\Downloads\task" bc45c8xjj;bc45c8xjk claude@qunect.com ked_bahz_cabbtdzb3wmjaabj9vsnjaabrwi5 qunect.quickbase.com 0 0 0 3

5. You can learn about the other features of Windows Task Scheduler here.