Git Product home page Git Product logo

pxtools's Introduction

The pxtools are a set of tools to convert a Paradox-database into a
SQL-database. 

This is a fork of https://github.com/ustramooner/pxtools, which is
derived from the original pxtools, which used to be found at
http://www.kneschke.de/projekte/paradox/ (it is now a 404).

Original author: mailto:[email protected]

pxTools
=======

pxinfo
------
dumps the basic infomations of the given paradox-file.

pxsqldump
---------
Parses the Paradox-database and dump the corresponding SQL-strings (CREATE
TABLE and INSERT INTO) on stdout.

use -n to overwrite the tablename.
use -f to specify the filename of t

pxcsvdump
---------
Parses the Paradox-database and dump the corresponding CSV-strings on
stdout.

use -n to overwrite the tablename.



Supported Field Types
=====================
Currently the following field-types are recognized:
ALPHA
DATE
SHORTINT
LONGINT
CURRENCY
NUMBER
LOGICAL
TIMESTAMP
MEMOBLOB

the rest is currenly not supported. mail me if you need more.

Problems
========

Y2K
---
Paradox-files are NOT Y2K-safe. Currently there is a workarund for this bug
in pxconvert.c that adds 100 years if the date is before 1.1.1970.

Index-files
-----------
The information you get out of the index-files by pxsqldump is not rellay
usefull. It all the data it can find, but the header is currently parsed
wrong. Anyway these index-files are not needed to convert a paradox-database
into a SQL-database. (PRIMARY KEY and FOREIGN KEY can't be detected yet.)

TIMESTAMP
---------
The field-type TIMESTAMP returned by pxsqldump has a precission of 
+/- 1 second. 

pxtools's People

Contributors

jsquyres avatar ustramooner avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

pxtools's Issues

Needed build instructions

I feel there's a need for build instructions since this repo doesn't come with the paradigmal ./configure.
Also, there's a weirdness in that both po/makefile.in and po/Makefile.in.in are needed.
For latest commit 53c164b from 14 Sep 2015, this is what worked for me on Ubuntu 20.04:

git clone https://github.com/ustramooner/pxtools.git
cd pxtools
apt install automake gettext
cp po/Makefile.in.in po/Makefile.in
./autogen.sh
./configure
make
sudo make install

Pull request #1 breaks compilation

I am trying to compile the code, I guess something is broken since the pull request that updated autotools.
I am on ubuntu 15.10 with autoconf version 2.69-8

$ ./autogen.sh 
+ autoreconf -ivf
autoreconf: Entering directory `.'
autoreconf: configure.ac: not using Gettext
autoreconf: running: aclocal --force --install -I m4
aclocal: installing 'm4/gettext.m4' from '/usr/share/aclocal/gettext.m4'
aclocal: installing 'm4/iconv.m4' from '/usr/share/aclocal/iconv.m4'
aclocal: installing 'm4/intlmacosx.m4' from '/usr/share/aclocal/intlmacosx.m4'
aclocal: installing 'm4/lib-ld.m4' from '/usr/share/aclocal/lib-ld.m4'
aclocal: installing 'm4/lib-link.m4' from '/usr/share/aclocal/lib-link.m4'
aclocal: installing 'm4/lib-prefix.m4' from '/usr/share/aclocal/lib-prefix.m4'
aclocal: installing 'm4/nls.m4' from '/usr/share/aclocal/nls.m4'
aclocal: installing 'm4/po.m4' from '/usr/share/aclocal/po.m4'
aclocal: installing 'm4/progtest.m4' from '/usr/share/aclocal/progtest.m4'
autoreconf: configure.ac: tracing
autoreconf: configure.ac: AM_GNU_GETTEXT is used, but not AM_GNU_GETTEXT_VERSION
autoreconf: configure.ac: not using Libtool
autoreconf: running: /usr/bin/autoconf --force
autoreconf: running: /usr/bin/autoheader --force
autoreconf: running: automake --add-missing --copy --force-missing
configure.ac:5: installing './compile'
configure.ac:16: installing './config.guess'
configure.ac:16: installing './config.sub'
configure.ac:6: installing './install-sh'
configure.ac:6: installing './missing'
configure.ac:55: error: required file 'po/Makefile.in' not found
src/Makefile.am: installing './depcomp'
autoreconf: automake failed with exit status: 1

When using the code from 522fedb, it does compile without issues, everything is working fine (altought not using autotools)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.