pxview: Program to read Paradox Database files

pxview is a program to read Paradox DB files. It is based on the pxlib library. pxview allows to output csv for reading with spread sheets, sql to import into a relational database, html and sqlite. You can also just show some information and the table structure of the database.

Features

  • Reading Paradox DB files and output them as csv, sql, sqlite or html
  • Output many information about a paradox file

Downloading

The most recent release of pxview is version 0.1.9.

  • Source and Debian package of version 0.1.9 for PPC is available at sourceforge

To compile this you'll only need a C Compiler.

FAQ

recent news

January 08, 2004 version 0.1.9
  • mask ' and tabulator in sql and sqlite output
  • use ',' as the default separator for fields in csv output
  • Mask the enclosure char in csv output if it occurs in a field value
  • pxfCurrency and pxfNumber are mapped to double in sql output
  • fixed BCD and Date fields in sql output
  • columns without a name will be named 'column%d' (such columns exist in primary index files)
  • added option --version
  • New option --without-head to suppress first line with field names in csv output
  • added complete header line to csv output of primary index files
December 11, 2003 version 0.1.8
  • All float values will formated with %g and not %f
  • sql output uses by default INSERT-statements, --use-copy enforces the use of the COPY-statement which was the default up to version 0.1.7
December 09, 2003 version 0.1.7
  • First line of HTML output uses <th> instead of <td><b>
  • added configure option --with-memory-debug
November 17, 2003 version 0.1.6
  • fixed freeing of memory
November 11, 2003 version 0.1.5
  • support for sqlite output
October 30, 2003 version 0.1.4
  • support for gsf library
September 29, 2003 version 0.1.3
  • output file with name "-" means stdout
  • csv output of .PX files got an extra column with the block number of the current record for better investigation of the index file
  • output of first and last block number
  • option 'output' is now 'output-file'
  • fixed debug output
  • added output of fileUpdateTime
  • some smaller cleanups
  • Use PX_get_data_byte() instead accessing the data directly
August 21, 2003 version 0.1.2
  • added option --primary-index-file to read a primary index which accelerates access
  • debug mode: output information about the datablock where a record is stored
  • usage output has been to restrictive if run as pxview
  • options --output-deleted, --delete-table has been misinterpreted
  • new option --mark-deleted to mark those records which are deleted the csv and html ouput will have an extra column
August 18, 2003 version 0.1.1
  • html output
  • field selection is case insenitive
August 14, 2003 version 0.1.0
  • - output modified flags 1 and 2 in verbose mode
  • added aliases --include-blobs and --delete-table for --includeblobs and --deletetable
  • allow to read deleted records (new option --output-deleted)
  • output calculated size of a record
  • use own error handler
August 11, 2003 version 0.0.7
  • man pages are not created if docbook-to-man is missing
  • program returns 1 in case of error else 0
  • better sql output
  • fixed potential segm fault
  • moved manpage into section 1
July 31, 2003 version 0.0.6
  • output sql data only if num records < 0
  • put field values into enclosing char only if the delimiter is in the field value
  • added option -v to output more header information
  • added spec file to create rpms
  • don't use enclosure characters in sql output
July 23, 2003 version 0.0.5
  • added support for recoding alpha fields
  • access to alpha fields is done with PX_get_data_alpha()
June 11, 2003 version 0.0.4
  • proper handling of negative Long, Short, Double value
  • finaly implemented export to a given output file (option --output)
  • added option --deletetable
  • updated manual page
  • calling pxview as px2sql or px2csv will set the appropriate options
  • moved data conversion routines to pxlib
Not published version 0.0.3
  • many bugfixes
  • output of sql
June 03, 2003 version 0.0.2
April 29, 2003 version 0.0.1
  • initial release

<uwe@steinmann.cx>

SourceForge Logo