Man Linux: Main Page and Category List


       cldump - Clarion database extractor


       cldump [options] database.dat


       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.


       -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)


       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).


       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; if possible, please send patches
       as the set of test databases I have is very limited.


       cldump was written by Julien BLACHE <>.