Convert data Tool

[KJensen]

I haven't worked with Progress Data before and I have just been given DataBase folder containing file with the extension .b1, .d1, .db, .st and .pbk. (version 9)
Is there a database tool out there that I can load the data into and Export it to other formats?

Thanks for any help
KJ

 

[jongpau]

Hi,

You can do this either from within Progress itself (but you'd have to have a developers or query licence to do this and know the "how to's" of using the Progress language) or from within the Data Administration function that comes with your Progress licence (it has some export functions, but these are limited). So, best to go see someone in your organisation and ask them if they can help you out by either exporting the data for you OR by giving you access to the Data Administration functions (you can download documentation on the Database Administration functions from the Progress Website)

Paul

 

[taqvia]

The easiest way will be to export data thru simple 4gl query. Export all the records of the table in the csv format.
I think you need to involve a developer for this purpose. Start your DB and execute one by one thru procedure editor or thru shell script.
below is a sample code which needs to be modified according to your environment.

===================================================
#!/bin/ksh
table=test.txt /* will contain list of all tables */
cat ${table} |
while read file
do
if [ -f $file.p ]
then
rm /root/test/$file.p
fi
echo "/* This is an auto generated Code Please do not edit Arshad */ " >>/root/test/$file.p
echo " def var outputfile as char init '$file.d' . " >>/root/test/$file.p
echo " def var i as int no-undo . " >> /root/test/$file.p
#echo " output to \""$file".d \" . " >>/root/test/$file.p
echo " for each $file no-lock: " >>/root/test/$file.p
# check for 2gb file size limit if greter than output to next file with same
# file name +1
echo " if file-info:file-size(outputfile) > 2000000000 then do : " >>/root/test/$file.p
echo " i = i + 1 . " >> /root/test/$file.p
echo " outputfile = $file+i.d . " >>/root/test/$file.p
echo " end . " >>/root/test/$file.p
#echo " export $file . " >>/root/test/$file.p
echo " run export-file . " >>/root/test/$file.p
echo "\n\n\n" >> /root/test/$file.p
echo " procedure export-file . " >>/root/test/$file.p
echo " output to value(outputfile) append . " >>/root/test/$file.p
echo " export $file . " >>/root/test/$file.p
echo " end . " >>/root/test/$file.p
echo " end . " >>/root/test/$file.p
# run the code in background
bpro -db <database path> -RO -p table.p >>/tmp/${file}.log
done


I have exported all data in .d you can also generate the same in csv format.
outfile initialize as $file.csv
export delimiter "," $file.

Arshad