Artifact ID:	90ff8ed9e61810e136db8965d8f2e05b424f5dd7
Page Name:	Refdb
Date:	2014-05-28 06:43:28
Original User:	matt
Parent:	7feec1a15785b8101928990455008ad5ef36479c (diff)
Next	177607f0a6ede7c3ef58e8f7012d7b052f3bdc8e

RefDB

... is a tool for storing a three level deep hierarchical key store in flat text files while being able to edit the data with a spreadsheet.

Run refdb from the commandline to get quick help:

> refdb
Usage: refdb action params ...

Note: refdbdir is a path to the directory containg sheet-names.cfg

  import filename.gnumeric refdbdir   : Import a gnumeric file into a txt db directory
  export refdbdir filename.gnumeric   : Export a refdb to a gnumeric file
  edit   refdbdir                     : Edit a refdbdir using gnumeric.
  ls refdbdir                         : List the keys for specified level 
  lookup refdbdir sheetname row col   : Look up a value in the text db   
  getrownames refdb sheetname         : Get a list of row titles
  getcolnames refdb sheetname         : Get a list of column titles

To export to other formats; first export to gnumeric then use ssconvert.

e.g. 

refdb export mydata mydata.gnumeric
ssconvert -T Gnumeric_html:html40 mydata.gnumeric mydata.html 
  
Part of the Megatest tool suite. Learn more at http://www.kiatoa.com/fossils/megatest

Version: 1.0

Usage

Accessing the data

Installation

1. Install chicken scheme from: www.call-cc.org
2. Install the refdb egg: chicken-install refdb

Data format

Files with extension .dat contain the data for each sheet.

[column header]
rowlabel value