Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cldump(1) [debian man page]

cldump(1)							   User Manuals 							 cldump(1)

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 data-
       bases 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/

Linux								   November 2010							 cldump(1)

Check Out this Related Man Page

MDBTools(1)															       MDBTools(1)

NAME

       mdb-export - Export data in an MDB database table to CSV format.

SYNOPSIS

       mdb-export [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I] [-D format] database table

DESCRIPTION

       mdb-export is a utility program distributed with MDB Tools.

       It  produces  a	CSV  (comma separated value) output for the given table. Such output is suitable for importation into databases or spread-
       sheets.

OPTIONS

       -H     Supress header row

       -Q     Don't wrap text-like fields (text, memo, date) in quotes.  If not specified text fiels will be surrounded by " (double quote)  char-
	      acters.

       -d     Specify an alternative column delimiter If no delimiter is specified, table names will be delimited by a , (comma) character.

       -R     Specify a row delimiter

       -I     INSERT statements (instead of CSV). You must specify the SQL dialect.

       -D     Set the date format (see strftime(3) for details)

       -q     Use to wrap text-like fields. Default is ".

       -X     Use to escape quoted characters within a field.  Default is doubling.

       -N namespace
	      Prefix identifiers with namespace.

NOTES

ENVIRONMENT

       MDB_JET3_CHARSET
	      Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).

       MDBICONV
	      Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.

       MDBOPTS
	      semi-column separated list of options:

	      o  use_index

	      o  no_memo

	      o  debug_like

	      o  debug_write

	      o  debug_usage

	      o  debug_ole

	      o  debug_row

	      o  debug_props

	      o  debug_all is a shortcut for all debug_* options

SEE ALSO

       gmdb2(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)

HISTORY

       mdb-export first appeared in MDB Tools 0.1.

AUTHORS

       The mdb-export utility was written by Brian Bruns.

BUGS

       Memo fields are allowed to contain a newline characters, the current program does nothing about this.

0.7								   13 July 2013 						       MDBTools(1)
Man Page