INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Exporting from unknown BTRIEVE file

Exporting from unknown BTRIEVE file

(OP)
I have application files that are in a BTRIEVE format (version unknown).  The files were part of an application written in Micro Focus COBOL and meant to run in DOS or early Windows.  There are no DDF files or other dictionary files that I can find.  And yes the company is defunct and can't be reached.

I need to get the data out of these files into soemthing else that can be maintained.  I can dump the files using a hex editor.  I was wondering where I can get the definition of the physical BTRIEVE file structure.  I was hoping to find out what file version I was dealing with.  All of the generic utilities I have tried are not having any success accessing these files.  The application is so old it will not run on anything I curently have.  As a result I do not have BTRIEVE running anywhere.

If need be I will write a low level file access program to get the data out if I can find any documentation as to the BTRIEVE physical file layout.  Any help or pointers would be appreciated.

TIA

RE: Exporting from unknown BTRIEVE file

AS far as the record sturcture, Btrieve does not store that information any where in the file.  It stores the record as a collection of bytes.  It might be possible to guess what the structure is by using the Btrieve Function Executor. You probably won't be able to use a hex editor to open the file as there is more to the file than just the data.  You can download a trial version of the latest version of Btrieve (called Pervasive.SQL) from www.pervasive.com.  That should be able to read the file because it's backward compatible with older file formats.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Exporting from unknown BTRIEVE file

If you need to try and create the DDF files you can check out BtSearch at www.nssdd.com.  It will allow you to open the file and if you install the trial version of Pervasive V8 at www.pervasive.com/downloads then you should be able to run BtSearch to analyze the structure.

Gil

RE: Exporting from unknown BTRIEVE file

Most Likely it has a flat file equivalent.

you may be able to use butil -save to extract the records with their keys.

I can write a quick program to create a file with fixed length records for easy use in many languages.


What is the size of the file?

RE: Exporting from unknown BTRIEVE file

(OP)
There are many files I am after.  In looking at the raw data in a hex editor I think your approach will work.  I do not know the physical layout of a BTrieve file but I am sure that there is a way to break the file into records and subsequently the records into fields.

If you are willing to work on this I can send you a file.

TIA

RE: Exporting from unknown BTRIEVE file

How do I give you my e-mail on this forum?

I can startout with a free-email?


lbasicuser@yahoo.com

once we are connected using this I will pass you my normal e-mail.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close