Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Btrieve conversion utility

151 views
Skip to first unread message

CrisGC

unread,
May 8, 1998, 3:00:00 AM5/8/98
to

I am new to using Btrieve files. Can anyone tell me if there is a utility to
dump btrieve file records into a regular flat file and vice versa.

Any help will be greatly appreciated.

Thanks,
Cris
CrisGC@<nospace>aol.com
If you spam me, you pay $500.

Paul Schmidt

unread,
May 8, 1998, 3:00:00 AM5/8/98
to

CrisGC wrote in message <199805081632...@ladder03.news.aol.com>...


>I am new to using Btrieve files. Can anyone tell me if there is a utility
to
>dump btrieve file records into a regular flat file and vice versa.
>
>Any help will be greatly appreciated.


There used to be a DOS program called BTFiler, that did this kind of
thing, you had to tell it though the file layout. And another DOS program,
bedit could do this, not sure where you could get either now...

Michael Salem

unread,
May 8, 1998, 3:00:00 AM5/8/98
to

CrisGC wrote:

> is there a utility to


> dump btrieve file records into a regular flat file and vice versa.

What do you mean by "a regular flat file"? The DOS program BUTIL.EXE,
as supplied with various BTRIEVE packages, will dump records into a
sequential file. As far as I remember each BTRIEVE record will
generate an entry in the file comprising the: record length in ASCII;
followed by a comma; the BTRIEVE data record, exactly as stored; and
a CR LF.

I don't know how variable length records are handled.

See BUTIL documentation. Option -SAVE will copy from a BTRIEVE file
to a sequential file; option -LOAD will copy from such a sequential
file to a BTRIEVE file.

Best wishes,
--
Michael Salem


Dennis Jacobsen

unread,
May 9, 1998, 3:00:00 AM5/9/98
to

On 08 May 1998 16:32:44 GMT, cri...@aol.com (CrisGC) wrote:
>I am new to using Btrieve files. Can anyone tell me if there is a utility to

>dump btrieve file records into a regular flat file and vice versa.
>Any help will be greatly appreciated.

Btrieve's utility BUTIL.EXE may do the trick. It will dump the raw
data into a flat file. The only trick is if numbers are stored in a
binary format, that format will be retained in the flat file instead
of showing the numbers as text.

From DOS, you need to have Btrieve running, and then the
syntax is:

butil -recover sourcefile destinationfile

On each record, the system will have the number of bytes in the record
followed by a comma, the record itself, and then carrige return, line
feed.

Doug Reilly

unread,
May 9, 1998, 3:00:00 AM5/9/98
to

My program, BTFILER will do the trick. It is available at:

http://ourworld.compuserve.com/homepages/access_microsystems
or
http://www.webspan.net/~dreilly/

You need to either dump the record images (it will create a file in BUTIL
format, that is the length in Ascii, followed by a comma, followed by the
exact bytes saved in the file (binary data and all) or you can create an
ASCII description file (giving field lengths, types, start positions, etc)
and get a delimited file. If you have DDF files (I suspect you do not) you
can use our BTVIEWER to more easily get to delimited or dBase files.

CrisGC wrote in message <199805081632...@ladder03.news.aol.com>...

>I am new to using Btrieve files. Can anyone tell me if there is a utility
to
>dump btrieve file records into a regular flat file and vice versa.
>
>Any help will be greatly appreciated.
>

gr_n...@cari.net

unread,
May 17, 1998, 3:00:00 AM5/17/98
to

Chis,

You might check out BtSearch. It allows you to send your data to ascii or
dbase format. It is a Windows program where you select the file and then any
or all fields to export. If you don't have the DDF files (file.ddf,
field.ddf) then it also will help you in creating these files.

Gil

In article <199805081632...@ladder03.news.aol.com>,


cri...@aol.com (CrisGC) wrote:
>
> I am new to using Btrieve files. Can anyone tell me if there is a utility to
> dump btrieve file records into a regular flat file and vice versa.
>
> Any help will be greatly appreciated.
>
> Thanks,
> Cris
> CrisGC@<nospace>aol.com
> If you spam me, you pay $500.
>


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

0 new messages