QuickBase API Cookbook v3 - Recipe #82
Send a file to QuickBase from the Windows 'Send To' menu
send Windows explorer right-click
You want to upload files from Windows folders by right-clicking them and selecting 'Send To, QuickBase' .
1. Create a sendToQuickBase.bat file with the following text:

ruby sendToQuickBase.rb %1
pause

2. Put the attached sendToQuickBase.rb file next to your sendToQuickBase.bat file
3. Right-click your Windows Start button and select Explore
4. Find the 'SendTo' folder
5. In the SendTo folder, create a shortcut that points to you sendToQuickBase.bat file
5. Give the name 'QuickBase' to the shortcut.
6. Test out your shortcut by right-clicking any Windows file and selecting 'QuickBase' from the 'Send To' menu. The file you selected will appear in a QuickBase application with the same name as the folder that contains the file. For example, if you select the file c:\temp\test.txt, the file will go into a QuickBase application called c:\temp.



=======================================
require 'QuickBaseClient'

if ARGV[0] and File.exist?(ARGV[0]) and ARGV[0].rindex("\\")
  username = ARGV[1] || ENV["quickbase_username"]
  password = ARGV[2] || ENV["quickbase_password"]
  if username.nil?
    print "Please enter your QuickBase user name: "
    username = gets.chop
  end
  if password.nil?
    print "Please enter your QuickBase password: "
    password = gets.chop
  end    
  qbc = QuickBase::Client.new(username, password)
  folder = ARGV[0][0,ARGV[0].rindex("\\")]
  file = ARGV[0][ARGV[0].rindex("\\")+1,ARGV[0].length]
  dbid = qbc.findDBByName(folder)
  if dbid.nil?
    dbid = qbc.createDatabase(folder,"Files uploaded from #{folder}")
    qbc.addField(dbid, "Description","text")
    qbc.addField(dbid, "File Attachment","file")
  else
    qbc.getSchema(dbid)
    dbid = qbc.lookupChdbid(folder.dup)
  end
  Dir.chdir(folder)
  qbc.uploadFile(dbid,file.dup,"File Attachment")
else
  puts "\n\nusage: ruby sendToQuickBase.rb <filepath> [username] [password]"
  puts "\ne.g. ruby sendToQuickBase.rb c:\temp\mySpecialFile"
  puts "\nYou can omit your username and password if they are in environment"
  puts "variables 'quickbase_username' and 'quickbase_password'.\n\n"
end
To distrubute this to users easily, use the rubyscript2exe utility to make a sendToQuickBase.exe file, and have the users create a SendTo shortcut to sendToQuickBase.exe using the steps above.
sendToQuickBase.rb
One-Click Ruby Installer for Windows Ruby wrapper for QuickBase HTTP API rubyscript2exe
Created on March 12, 2008 at 10:59 PM (PDT). Last updated by Quick Base on March 12, 2008 at 11:10 PM (PDT). Owned by Quick Base.
Quick Base
Quick Base
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

We're glad you're interested in doing more with Quickbase!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quickbase with others in your company.

Your work email
Your company