QuickBase API Cookbook v3 - Recipe #30
Edit data offline in a simple text file
text file offline
You want to edit data in simple text file and send the data into to a QuickBase table
require 'QuickBaseTextData'

# download the Ingredients table in the QuickBase API Cookbook v2 to a text file
QuickBase::TextData.downloadData("username","password","bb2mad4ss")

=begin 

The 'downloadData' line above will write a file called 'downloadedTextData.txt' in your current directory.
The contents will be something close to the text below. You can edit the text and send it back to QuickBase
using QuickBase::TextData.uploadData("username","password","downloadedTextData.txt")

dbid:bb2mad4ss
record:1
Name:Ruby wrapper for QuickBase HTTP API
Description:This is a Ruby language wrapper for the QuickBase HTTP API. It includes routines for all everything in the API, plus additional routines to reduce the amount of code you have to write to get things done using the QuickBase API.
File Attachment:
URL:https://www.quickbase.com/db/8emtadvk?a=dr&r=ztj&rl=cjtm
Contact E-mail:
record:2
Name:QuickBase HTTP API
Description:
File Attachment:
URL:https://www.quickbase.com/up/6mztyxu8/g/rc7/en/va/QuickBaseAPI.htm
Contact E-mail:
record:3
Name:One-Click Ruby Installer for Windows
Description:This is a [one-click, self-contained Windows installer] that contains the Ruby language itself, dozens of popular extensions and packages, a syntax-highlighting editor and execution environment, and a Windows help file that contains the full text of the book, Programming Ruby: The Pragmatic Programmer's Guide. 
File Attachment:
URL:http://rubyinstaller.rubyforge.org/wiki/wiki.pl
Contact E-mail:
record:4
Name:Visual Basic SDK
Description:
File Attachment:
URL:https://www.quickbase.com/db/6mztyxu8?a=dr&r=c4
Contact E-mail:
record:5
Name:Perl SDK
Description:
File Attachment:
URL:https://www.quickbase.com/db/6mztyxu8?a=dr&r=c5
Contact E-mail:
record:6
Name:Javascript SDK
Description:
File Attachment:
URL:https://www.quickbase.com/db/6mztyxu8?a=dr&r=c8
Contact E-mail:
record:7
Name:Java SDK
Description:
File Attachment:
URL:https://www.quickbase.com/db/6mztyxu8?a=dr&r=c6
Contact E-mail:
record:8
Name:Excel
Description:
File Attachment:
URL:
Contact E-mail:


=end
QuickBaseTextData.rb comes with the Ruby API for QuickBase.  The file format it reads and writes is simpler than XML and more readable than CSV. It is suitable for editing small-to-medium amounts of data manually and as an intermediate format that applications can use to send data to QuickBase.
downloadToTextFile.rb
One-Click Ruby Installer for Windows Ruby wrapper for QuickBase HTTP API
Created on Jan. 31, 2007 at  9:21 PM (PST). Last updated by Quick Base on Feb.  1, 2007 at  8:43 PM (PST). 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