ACT!6 - Can you export the .dbf files to a .csv file, or some sort of flat file, and if so, how?

c9k9h
c9k9h used Ask the Experts™
on
Without any outside tools.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Yes, you can use xls2csv to do this as far as I know. If you are using Linux, you can use the program I wrote to install this package. Simply copy this code into a text file and name it install.sh. Then from the Terminal, type sh install.sh to launch it. After you are done, type xls2csv to get the syntax for doing what you need. If you are in Windows, you can use this 30 day trial program: http://www.download.com/DBF-to-CSV/3000-2065_4-10405766.html
#!/bin/bash
 
clear
echo 'Launching installer for xls2csv installation...\n'
 
# Download and extract Unicode::Map
echo 'Downloading Unicode::Map...'
wget -q http://search.cpan.org/CPAN/authors/id/M/MS/MSCHWARTZ/Unicode-Map-0.112.tar.gz
if [ -f ./Unicode-Map-0.112.tar.gz ]
then
	tar -xf ./Unicode-Map-0.112.tar.gz >/dev/null
else
	echo 'Cannot download Unicode::Map from cpan.org so quitting...'
	exit
fi;
 
# Download and extract Spreadsheet-ParseExcel
echo 'Downloading Spreadsheet-ParseExcel...'
wget -q http://search.cpan.org/CPAN/authors/id/S/SZ/SZABGAB/Spreadsheet-ParseExcel-0.32.tar.gz
if [ -f ./Spreadsheet-ParseExcel-0.32.tar.gz ]
then
	tar -xf ./Spreadsheet-ParseExcel-0.32.tar.gz >/dev/null
else
	echo 'Cannot download Spreadsheet-ParseExcel from cpan.org so quitting...'
	exit
fi;
 
# Download and extract libintl-perl
echo 'Downloading libintl-perl...'
wget -q http://search.cpan.org/CPAN/authors/id/G/GU/GUIDO/libintl-perl-1.16.tar.gz
if [ -f ./libintl-perl-1.16.tar.gz ]
then
	tar -xf ./libintl-perl-1.16.tar.gz >/dev/null
else
	echo 'Cannot download libintl-perl from cpan.org so quitting...'
	exit
fi;
 
# Download and extract Text::CSV_XS
echo 'Downloading Text::CSV_XS...'
wget -q http://search.cpan.org/CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-0.52.tgz
if [ -f ./Text-CSV_XS-0.52.tgz ]
then
	tar -xf ./Text-CSV_XS-0.52.tgz >/dev/null
else
	echo 'Cannot download Text::CSV_XS from cpan.org so quitting...'
	exit
fi;
 
# Download and extract OLE::Storage Lite
echo 'Downloading OLE::Storage Lite...'
wget -q http://search.cpan.org/CPAN/authors/id/J/JM/JMCNAMARA/OLE-Storage_Lite-0.17.tar.gz
if [ -f ./OLE-Storage_Lite-0.17.tar.gz ]
then
	tar -xf ./OLE-Storage_Lite-0.17.tar.gz >/dev/null
else
	echo 'Cannot download OLE::Storage Lite from cpan.org so quitting...'
	exit
fi;
 
# Download and extract IO::Scalar
echo 'Downloading IO::Scalar...'
wget -q http://search.cpan.org/CPAN/authors/id/D/DS/DSKOLL/IO-stringy-2.110.tar.gz
if [ -f ./IO-stringy-2.110.tar.gz ]
then
	tar -xf ./IO-stringy-2.110.tar.gz >/dev/null
else
	echo 'Cannot download IO::Scalar from cpan.org so quitting...'
	exit
fi;
 
# Download and extract xls2csv
echo 'Downloading xls2csv...'
wget -q http://search.cpan.org/CPAN/authors/id/K/KE/KEN/xls2csv-1.06.tar.gz
if [ -f ./xls2csv-1.06.tar.gz ]
then
	tar -xf ./xls2csv-1.06.tar.gz >/dev/null
else
	echo 'Cannot download xls2csv from cpan.org so quitting...'
	exit
fi;
 
echo 'Installing xls2csv and dependencies...'
echo 'Ignore any warnings about building XS version of libintl-perl'
 
# Make and isntall the Unicode::Map modules
cd ./Unicode-Map-0.112
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the Spreadsheet-ParseExcel modules
cd ../Spreadsheet-ParseExcel-0.32
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the perl modules
cd ../libintl-perl-1.16
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the text-csv modules
cd ../Text-CSV_XS-0.52
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the OLE::Storage Lite modules
cd ../OLE-Storage_Lite-0.17
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the IO::Scalar modules
cd ../IO-stringy-2.110
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the xls2csv modules
cd ../xls2csv-1.06
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Do a garbage cleanup
cd ..
rm -rf ./Spreadsheet-ParseExcel* >/dev/null
rm -rf ./Unicode-Map* >/dev/null
rm -rf ./libintl-perl* >/dev/null
rm -rf ./Text-CSV_XS* >/dev/null
rm -rf ./OLE-Storage_Lite-0.17* >/dev/null
rm -rf ./IO-stringy-2.110* >/dev/null
rm -rf ./xls2csv* >/dev/null
 
echo '\nFinished installing xls2csv. You may now run xls2csv using /usr/bin/xls2csv'

Open in new window

Author

Commented:
Thank you for your quick response!  I am using windows.  (Sure wish I could use your code!)  I'll check out the free trial.  Is reasonably priced.  Thanks again!

Commented:
:) Glad to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial