We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

.DAT file conversion.

Computerguy107
on
Medium Priority
10,495 Views
Last Modified: 2013-12-25
Hi there.

I have a client that has an old DOS Btrieve database with several .dat files named customer.dat, etc. I am looking for some kind of utility to convert these .dat files into something usable, such as a csv file. Any suggestions would be welcomed. Thank you in advance.

ComputerGuy : -)
Comment
Watch Question

ch2

Commented:
You can use BUTIL.exe

Download here:

http://www.goldstarsoftware.com/download.asp
ch2

Commented:
Also you will need Btrieve.exe

you can create a batch file like this one:

@echo off
btrieve
butil -recover yourfile.dat newfile.csv

Author

Commented:
I tried that and all I came up with was a bunch of **&&^^%%$$$$$  all garbage.
ch2

Commented:
I have also some old btrieve files wich also outputs garbage, because they were created with Btrieve 4.11b using BFLOAT data type and stored in Microsoft Binary Format.

btw which btrieve version are those files?

@echo off
btrieve
butil -ver yourfile.dat

Author

Commented:
The version is Btreive is 5.1
Hi Computerguy,

Unfortunately, butil won't actually create a file in csv format.  The format it does create is a Btrieve "unformatted", or sequential file, but it is neither clear ascii text (as you've found out) nor legible as a csv.

There are third-party tools that will do this, and Bill might have one on his site, but here's one I've found in the Pervasive Component Zone:

http://www.pervasive.com/ComponentZone/Component/Lookup.asp?Function=ShowDetail&ID=297&Component=butool+%28btr+export%29&AuthorID=1202&CategoryID=6&Page=2&CategoryName=Tools+%2F+Utilities

Give it a try and let us know how it works out.  There might be an even better one out there somewhere.

Wayne Freeman
Analytica Business Systems
www.analyticabiz.com
President and Btrieve Guru
CERTIFIED EXPERT
Commented:
You can also get more information about what it takes to extract data from a Btrieve database from our white paper on ODBC Access of Btrieve files, located at www.goldstarsoftware.com/press.asp.  

As you'll see by the paper, it sometimes gets quite complicated, we also offer services to perform the extraction for various companies.  Given the data set, and sometimes a sample application, we can provide a turnkey extraction for you if you are interested in outsourcing the process.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
ch2
Commented:
Well, it won't exctract a csv file but will output each record on the database.

Then you need to know the key.

For example:

In the output file you will see the "record length" at the begining of each line, a number and a comma. Ex; 130, This means 130 bytes.

From here you will have to guess what is each byte if it's a String, Date, Bfloat etc..

If the data was stored as string you should see plain text on your recovered file if not you will see only strange characters, as you do.

If you have they key, you can download pervasive 6 (i say 6 because it was the one i used to do this) and open those btrieve files and put the key manally.

If you don't have they key or don't have any idea of programming, i'd suggest BillBach advise.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.