Export Paradox Data

Export Paradox Data

This article describes how to export data from Paradox Database files, based on the data set provided by the Museum König.

Introduction

Further Reading

• A Brief Tour of Paradox Database Files
• Understanding File-System Databases

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

• Paradox Data Editor

Exporting the data

Installing PX Tools

• http://jan.kneschke.de/projects/pxtools/

 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

#!/bin/sh
# parameters: $1=database_name $2=Paradox_File_Encoding

if [ ! -d "sql" ]; then
	echo "creating 'sql' directory"
	mkdir sql
fi
DBFILES=`find -maxdepth 1 \( -name "*.DB" ! -name "BDS_*" \) `

for i in $DBFILES
do 
	echo 
	echo "#############################"
	echo "# Exporting $i"
	echo "#############################"
	pxsqldump -d mysql -f $i -b $(echo "$i" | sed -e 's/\.DB$/\.MB/') -n $1.$(echo "$i" | tr '[:upper:]' '[:lower:]'| sed -e 's/\.db$//' | sed -e 's/.*\///') > sql/$(echo "$i" | tr '[:upper:]' '[:lower:]'| sed -e 's/\.db$//' | sed -e 's/.*\///').sql
done 

cd sql
if [ ! -d "converted" ]; then
	mkdir converted
fi
SQLFILES=`find -maxdepth 1 \( -name "*.sql" ! -name "BDS_*" \)`

for i in $SQLFILES
do 
	echo "Converting $i"
	iconv -f $2 -t UTF-8 < $i > converted/$i
done

cd converted
echo 
echo "Joining SQL Files"
echo "CREATE DATABASE IF NOT EXISTS $1 ;" > $1.sql.tmp
echo "USE $1 ;" >> $1.sql.tmp
echo >> $1.sql.tmp 
echo >> $1.sql.tmp 

SQLFILES=`find \( -name "*.sql" ! -name "BDS_*" ! -name "$1.sql" \)`

for i in $SQLFILES
do 
	cat $i >> $1.sql.tmp 
	echo >> $1.sql.tmp 
	echo >> $1.sql.tmp 
	echo $i
done
echo "" >> $1.sql.tmp
mv $1.sql.tmp ../../$1.sql

px2sql-all.sh ornithol CP437