NAME¶
cldump - Clarion database extractor
SYNOPSIS¶
cldump [
options] database.dat
DESCRIPTION¶
cldump extracts the data contained in a
Clarion database;
Clarion is a Windows IDE similar to
Delphi or others, and has
its own (simple) database format.
cldump can extract the data contained in such a database, and export it
to CSV, SQL (including the database schema, keys and indexes) or its own
format (this format will give you all the meta information, but isn't easily
parsable).
A
Clarion database consists in a set of files :
- .DAT
- files contain the data,
- .Kxx
- files contain the key/index data,
- .MEM
- files contain the memo entries associated to the data.
OPTIONS¶
- -x n, --decrypt n
- Decrypt an encrypted file. Required argument n indicates the
location where the key will be retrieved. Valid values are in the range 1
- 4 inclusive. n = 1 usually works.
Decryption happens in-place so KEEP A BACKUP as there is no guarantee
the decryption process won't fail. Encrypted files must be decrypted
before they can be dumped.
Note that only the data file and the memo file are decrypted in this
process; key/index files are left untouched as cldump doesn't use
them.
- -d, --dump-active
- Dump active entries only
- -D, --dump-data
- Dump the actual data (active and deleted entries)
- -m, --dump-meta
- Dump meta information (no SQL or CSV output format exist for this
option)
- -f c, --field-separator c
- Set the field separator to character c. Only valid for CSV output
(see below).
- -c, --csv
- Dump data or schema in CSV format
- -S, --sql
- Dump data or schema in SQL format
- -s, --schema
- Dump database schema
- -M, --mysql
- Use MySQL specific construct (backticks, ...)
- -n, --no-memo
- Do not dump memo entries
- -U[charset], --utf8[=charset]
- Transcode strings and memos from charset to UTF-8 (charset
defaults to ISO8859-1; for the list of supported charsets, see iconv
--list)
OUTPUT¶
cldump outputs the data to
stdout or
stderr depending on
the output format selected, the data to extract and the type of the data
(data, meta data).
BUGS¶
The SQL output could be improved. Not all the types supported by the
Clarion database format are implemented yet (due to lack of test
databases using these types of data); see the source code for details.
Please report bugs to
jb@jblache.org; if possible, please send patches as
the set of test databases I have is
very limited.
AUTHOR¶
cldump was written by Julien BLACHE <jb@jblache.org>.
HOMEPAGE¶
http://www.technologeek.org/projects/cldump/