Hello,

I have a customer using Laserfiche 5.0. We are now helping them to
extract data from LF to be migrated to a new developed system.
However, I have not much knowledge in Laserfiche nor Btrieve. Is there
any information I can refer about how to export the index and image
data of the documents?

Does anyone know what version of Btrieve is Laserfiche 5.0 using? How
can I read the data in the Btrieve files?
I have searched the internet for some time but cannot find any clue.

Thank you.

If this is a one time migration the simplest solution would be if the
Laserfiche application has an export feature. A "backup" feature
might also be an export.

After that there are a couple of additional solutions available.

1) raw export of the data file(s).
butil -save <datafile> <dumpfile>
However this dumps the raw record contents to the dumpfile along with
a record length. If everything in the record is stored as a string it
would then be easy enough to parse through.

2) I mention this one last because while if I remember correctly
Laserfiche uses a somewhat recent version of Pervasive.SQL 2000i I do
not believe to have the SQL schema for its data files. It may and if
it does it makes creating a SQL/ODBC data source easy which allows for
a simple export through ODBC. If it doesn't you need to define the
SQL schema for the data files before you can access them through SQL.
If I remember correctly the application allows for custom fields in
the data so you are not likely going to be able to "borrow" someone
elses SQL schema / DDF files. However the custom fields probably
translate directly into SQL schema for those parts of the record..

Leonard

On 12 Apr 2006 00:45:52 -0700, danielwong1 (AT) gmail (DOT) com wrote:

The white paper on accessing Btrieve data from ODBC located here:
http://www.goldstarsoftware.com/press.asp
provides a lot of background information on this problem and what is
needed. If the structures are easy enough, we might be able to help
discern the layouts, especially if there are DDF's or if you have some
sort of documentation.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Austin: Pervasive Service & Support Class - 05/2006 ***
*** Chicago: Pervasive Service & Support Class - 07/2006 ***

danielwong1 (AT) gmail (DOT) com wrote: