Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Artifact ID: | 18727236fe1934d0f62ce9e5f63b896f6f0c9499 |
---|---|
Page Name: | Refdb |
Date: | 2014-08-12 06:12:12 |
Original User: | matt |
Parent: | 177607f0a6ede7c3ef58e8f7012d7b052f3bdc8e (diff) |
Next | cac4d913f4fcc1c9bfc45766de85ea4ebaa85033 |
Content
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. The flat files generated by refdb are quite resistant to conflicts on branch and merge.
Motive
Storing configuration data, test control data and so forth can be very convenient in a spreadsheet but spreadsheets cannot be easily modified in parallel and branched and merged in tools like fossil or git.
Information
Installation
- Install chicken scheme from: www.call-cc.org
- Install the refdb egg: chicken-install refdb
Data format
Files with extension .dat contain the data for each sheet.
[column header] rowlabel value
Run refdb for quick help
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