Export Paradox Data - Revision history

AgnesKirchhoff: 5 revision

2014-11-10T16:59:37Z

5 revision

← Older revision	Revision as of 18:59, 10 November 2014
(No difference)

DavidFichtmueller: /* Further Fixing Character Encoding */ Link Correktion

2012-07-23T08:41:35Z

Further Fixing Character Encoding: Link Correktion

← Older revision		Revision as of 10:41, 23 July 2012
Line 137:		Line 137:

	=== Further Fixing Character Encoding ===		=== Further Fixing Character Encoding ===
	Though most of the data in the tables we received were encoded in CP437, some parts of it used different character encodings. This was fixed using the same method as described in [[Export_DataPerfect (Section 'Converting Characters Individually')~~\|\|Export_DataPerfect#converting_characters_individually~~]].		Though most of the data in the tables we received were encoded in CP437, some parts of it used different character encodings. This was fixed using the same method as described in [[Export_DataPerfect#converting_characters_individually\|Export_DataPerfect (Section 'Converting Characters Individually')]].

	=== Turning BLOB Entries Into TEXT Entries ===		=== Turning BLOB Entries Into TEXT Entries ===

DavidFichtmueller: description and images

2012-07-20T15:37:41Z

description and images

Show changes

DavidFichtmueller: complete script added

2012-06-11T12:59:45Z

complete script added

← Older revision		Revision as of 14:59, 11 June 2012
Line 58:		Line 58:
	//TODO SQL Join script		//TODO SQL Join script
	//TODO encoding		//TODO encoding


			<syntaxhighlight lang="bash" enclose="pre">
			#!/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
			</syntaxhighlight>

			px2sql-all.sh ornithol CP437

DavidFichtmueller: save working copy

2012-06-04T15:04:33Z

save working copy

@@ Line 22: / Line 22: @@
 === Installing PX Tools ===
 * http://jan.kneschke.de/projects/pxtools/
   tar -zxvf pxtools-0.0.20.tar.gz
   cd pxtools-0.0.20/
@@ Line 29: / Line 31: @@
   sudo make clean
   pxinfo -f COLEOPTE_DATA.DB
-  pxsqldump -d mysql -f COLEOPTE_TAXA.DB > sql/COLEOPTE_TAXA.sql
+  pxsqldump -d mysql -f COLEOPTE_DATA.DB -b COLEOPTE_DATA.MB -d coleopte_data> COLEOPTE_DATA.sql

DavidFichtmueller: first overview

2012-06-04T10:22:15Z

first overview

New page

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
* [http://www.sundialservices.com/articles/paradox/paradox_file_structures A Brief Tour of Paradox Database Files]
* [http://www.sundialservices.com/articles/paradox/understanding_filesystem_databases Understanding File-System Databases]

== Viewing the Data ==
* [http://www.sportamok.com/development/delphi/8-paradox-dbase-reader Paradox dbase Reader]
* [http://www.scalabium.com/pdx/ Paradox Viewer] 30 day trial version
Paradox 5.0 and 7.0: <code>jIGGAe</code> or <code>cupcdvum</code>
Paradox 4.0: <code>nx66ppx</code>

== Removing Password Protection ==
* [http://www.mitec.cz/pde.html Paradox Data Editor]

== Documenting Table Relations ==

== 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_TAXA.DB > sql/COLEOPTE_TAXA.sql