dbTalk Databases Forums  

Exporting to .txt but querying what to export

comp.databases.btrieve comp.databases.btrieve


Discuss Exporting to .txt but querying what to export in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
michael martelli, jr
 
Posts: n/a

Default Exporting to .txt but querying what to export - 08-04-2004 , 09:32 PM






I need to export records from a Btrieve DB convert them into a .txt
file. This is easy I can use butil, but with that program there are
no options of what records to export, its all or nonw (i think i am
correct with that statement)...

Does anyone know of a way to do this with butil or any other similar
programs (hopefully via msdos command prompt).

I have searched the web but can't find anything.

Any help will be great thanks a lot.

Reply With Quote
  #2  
Old   
Leonard
 
Posts: n/a

Default Re: Exporting to .txt but querying what to export - 08-05-2004 , 08:23 AM






I think from a command prompt that butil is going to be about it.
The only options on butil are which index (if any) to use saving the
data. And technically speaking butil is not an export but a dump of
the data into an "unformatted" file. The layout of the unformatted
file is: length of record in ASCII, a comma ",", then the raw record
as stored in the data file followed by an end of line marker. The
data is dumped as is from the record into the file with no data type
conversions. If it is all text in the data file it will be all text
in the dump file, if it is all binary (e.g. integer, floating point,
.... then it is dumped as is.

If you have DDFs there are a couple of command line SQL executers
around that might be able to do an actual conversions.

Leonard

On 4 Aug 2004 19:32:01 -0700, michael.martelli (AT) gmail (DOT) com (michael
martelli, jr) wrote:

Quote:
I need to export records from a Btrieve DB convert them into a .txt
file. This is easy I can use butil, but with that program there are
no options of what records to export, its all or nonw (i think i am
correct with that statement)...

Does anyone know of a way to do this with butil or any other similar
programs (hopefully via msdos command prompt).

I have searched the web but can't find anything.

Any help will be great thanks a lot.


Reply With Quote
  #3  
Old   
michael martelli, jr
 
Posts: n/a

Default Re: Exporting to .txt but querying what to export - 08-05-2004 , 12:30 PM



Thanks Leonard, and i do have the DDFs (to my knowledge) I have the
full DB and everything about it - and if not I know I can make them.
Do you know of thise comman line SQL executers off the top of your
head that I could use?

Thanks so much.

Leonard <lharvey (AT) austin (DOT) rr.com> wrote

Quote:
I think from a command prompt that butil is going to be about it.
The only options on butil are which index (if any) to use saving the
data. And technically speaking butil is not an export but a dump of
the data into an "unformatted" file. The layout of the unformatted
file is: length of record in ASCII, a comma ",", then the raw record
as stored in the data file followed by an end of line marker. The
data is dumped as is from the record into the file with no data type
conversions. If it is all text in the data file it will be all text
in the dump file, if it is all binary (e.g. integer, floating point,
... then it is dumped as is.

If you have DDFs there are a couple of command line SQL executers
around that might be able to do an actual conversions.

Leonard

On 4 Aug 2004 19:32:01 -0700, michael.martelli (AT) gmail (DOT) com (michael
martelli, jr) wrote:

I need to export records from a Btrieve DB convert them into a .txt
file. This is easy I can use butil, but with that program there are
no options of what records to export, its all or nonw (i think i am
correct with that statement)...

Does anyone know of a way to do this with butil or any other similar
programs (hopefully via msdos command prompt).

I have searched the web but can't find anything.

Any help will be great thanks a lot.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.