Difference between revisions of "Export Paradox Data"
From reBiND Documentation
(first overview) |
(save working copy) |
||
| Line 22: | Line 22: | ||
=== Installing PX Tools === | === Installing PX Tools === | ||
* http://jan.kneschke.de/projects/pxtools/ | * http://jan.kneschke.de/projects/pxtools/ | ||
| + | |||
| + | <syntaxhighlight lang="bash" enclose="pre"> | ||
tar -zxvf pxtools-0.0.20.tar.gz | tar -zxvf pxtools-0.0.20.tar.gz | ||
cd pxtools-0.0.20/ | cd pxtools-0.0.20/ | ||
| Line 29: | Line 31: | ||
sudo make clean | sudo make clean | ||
pxinfo -f COLEOPTE_DATA.DB | pxinfo -f COLEOPTE_DATA.DB | ||
| − | pxsqldump -d mysql -f | + | pxsqldump -d mysql -f COLEOPTE_DATA.DB -b COLEOPTE_DATA.MB -d coleopte_data> COLEOPTE_DATA.sql |
| + | |||
| + | </syntaxhighlight> | ||
| + | |||
| + | pxconvert.c.477: Read less than requested | ||
| + | pxconvert.c.483: Extract failed: `���A�f,<�� != | ||
| + | pxconvert.c.477: Read less than requested | ||
| + | Speicherzugriffsfehler (Speicherabzug geschrieben) | ||
| + | |||
| + | <syntaxhighlight lang="bash" enclose="pre"> | ||
| + | #!/bin/sh | ||
| + | if [ ! -d "sql" ]; then | ||
| + | mkdir sql | ||
| + | fi | ||
| + | echo | ||
| + | echo "#############################" | ||
| + | echo "# Exporting $1" | ||
| + | echo "#############################" | ||
| + | pxsqldump -d mysql -f $1 -b $(echo "$1" | sed -e 's/\.DB$/\.MB/') -n $(echo "$1" | tr '[:upper:]' '[:lower:]'| sed -e 's/\.db$//' | sed -e 's/.*\///') > sql/$1.sql | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | PATH=$PATH:~/bin | ||
| + | chmod +x ~/bin/px2sql.sh | ||
| + | find -name '*.DB' -exec px2sql.sh {} \; | ||
| + | |||
| + | //TODO SQL Join script | ||
| + | //TODO encoding | ||
Revision as of 16:04, 4 June 2012
This article describes how to export data from Paradox Database files, based on the data set provided by the Museum König.
Contents
Introduction
Further Reading
Viewing the Data
- Paradox dbase Reader
- Paradox Viewer 30 day trial version
Paradox 5.0 and 7.0: jIGGAe or cupcdvum
Paradox 4.0: nx66ppx
Removing Password Protection
Documenting Table Relations
Exporting the data
Installing PX Tools
tar -zxvf pxtools-0.0.20.tar.gz
cd pxtools-0.0.20/
./configure
sudo make
sudo make install
sudo make clean
pxinfo -f COLEOPTE_DATA.DB
pxsqldump -d mysql -f COLEOPTE_DATA.DB -b COLEOPTE_DATA.MB -d coleopte_data> COLEOPTE_DATA.sql
pxconvert.c.477: Read less than requested pxconvert.c.483: Extract failed: `���A�f,<�� != pxconvert.c.477: Read less than requested Speicherzugriffsfehler (Speicherabzug geschrieben)
#!/bin/sh
if [ ! -d "sql" ]; then
mkdir sql
fi
echo
echo "#############################"
echo "# Exporting $1"
echo "#############################"
pxsqldump -d mysql -f $1 -b $(echo "$1" | sed -e 's/\.DB$/\.MB/') -n $(echo "$1" | tr '[:upper:]' '[:lower:]'| sed -e 's/\.db$//' | sed -e 's/.*\///') > sql/$1.sql
PATH=$PATH:~/bin
chmod +x ~/bin/px2sql.sh
find -name '*.DB' -exec px2sql.sh {} \;
//TODO SQL Join script //TODO encoding
