Butil -recover 
Author Message
 Butil -recover
When I execute butil -recover the ASCI file is created
Most fields are OK. especially containing text information
But fields containing  numeric information aren't visible in text format
How to access these fields.

Romi



Sun, 18 Jul 2004 17:42:37 GMT
 Butil -recover

Romi,

BUTIL -SAVE or -RECOVER simply take raw data from a Btrieve file and write
it to disk.  BUTIL does not perform any kind of 'conversion' on the data,
so, if you have data stored in a binary format (i.e. all numbers), that is
how it is written to the ASCII output.

If you were expecting to see the data formatted as readable text, then
you'll want to access the data via ODBC.  You possibly don't have the
necessary driver, or the necessary "DDFs" to do this.  For more information
on DDFs and ODBC, see the relevant FAQs in our Support section:
  http://southdown.co.uk/db/support

If you wish to try ODBC, you could download the Pervasive.SQL 2000i
Workstation evaluation version from Pervasive's Web site.

Regards,

Jon Grieve
Southdown House Software Ltd
http://www.southdown.co.uk
_______________________________________________

The U.K's #1 distributor for Pervasive Software

(To reply, modify return address; change commas to dots)

Quote:

> When I execute butil -recover the ASCI file is created
> Most fields are OK. especially containing text information
> But fields containing  numeric information aren't visible in text format
> How to access these fields.

> Romi



Sun, 18 Jul 2004 18:02:57 GMT
 Butil -recover
My database is write in version 6 of btrieve. I've tried Pervasive ODBC but:
- I don't have ddf files
- When I installed Odbc drives - brequest provided by Novell which is
necessary by my DOS aplication didn't work. Command bdosstub.exe work - but
only when my btr files aren't in use. It makes that I give up Pervasive.



Quote:
> Romi,

> BUTIL -SAVE or -RECOVER simply take raw data from a Btrieve file and write
> it to disk.  BUTIL does not perform any kind of 'conversion' on the data,
> so, if you have data stored in a binary format (i.e. all numbers), that is
> how it is written to the ASCII output.

> If you were expecting to see the data formatted as readable text, then
> you'll want to access the data via ODBC.  You possibly don't have the
> necessary driver, or the necessary "DDFs" to do this.  For more
information
> on DDFs and ODBC, see the relevant FAQs in our Support section:
>   http://southdown.co.uk/db/support

> If you wish to try ODBC, you could download the Pervasive.SQL 2000i
> Workstation evaluation version from Pervasive's Web site.

> Regards,

> Jon Grieve
> Southdown House Software Ltd
> http://www.southdown.co.uk
> _______________________________________________

> The U.K's #1 distributor for Pervasive Software

> (To reply, modify return address; change commas to dots)


> > When I execute butil -recover the ASCI file is created
> > Most fields are OK. especially containing text information
> > But fields containing  numeric information aren't visible in text format
> > How to access these fields.

> > Romi



Sun, 18 Jul 2004 18:20:32 GMT
 Butil -recover
Tomek,
    If you know the format of the data, you could write a small app that
converts the data into a readable format.  Otherwise, try viewing the data
in a binary editor that allows you to display the 'columns' at different
offsets.  Run butil -stat to list the different keys (to allow you to see
the positions.).  From that point, writing an app to get at the recovered
data should be a snap.

Good luck!

Mike Hovis

Quote:

> My database is write in version 6 of btrieve. I've tried Pervasive ODBC
but:
> - I don't have ddf files
> - When I installed Odbc drives - brequest provided by Novell which is
> necessary by my DOS aplication didn't work. Command bdosstub.exe work -
but
> only when my btr files aren't in use. It makes that I give up Pervasive.



> > Romi,

> > BUTIL -SAVE or -RECOVER simply take raw data from a Btrieve file and
write
> > it to disk.  BUTIL does not perform any kind of 'conversion' on the
data,
> > so, if you have data stored in a binary format (i.e. all numbers), that
is
> > how it is written to the ASCII output.

> > If you were expecting to see the data formatted as readable text, then
> > you'll want to access the data via ODBC.  You possibly don't have the
> > necessary driver, or the necessary "DDFs" to do this.  For more
> information
> > on DDFs and ODBC, see the relevant FAQs in our Support section:
> >   http://southdown.co.uk/db/support

> > If you wish to try ODBC, you could download the Pervasive.SQL 2000i
> > Workstation evaluation version from Pervasive's Web site.

> > Regards,

> > Jon Grieve
> > Southdown House Software Ltd
> > http://www.southdown.co.uk
> > _______________________________________________

> > The U.K's #1 distributor for Pervasive Software

> > (To reply, modify return address; change commas to dots)




- Show quoted text -

Quote:
> > > When I execute butil -recover the ASCI file is created
> > > Most fields are OK. especially containing text information
> > > But fields containing  numeric information aren't visible in text
format
> > > How to access these fields.

> > > Romi



Mon, 19 Jul 2004 03:46:12 GMT
 Butil -recover
In my btrieve file I have field with format as:
- Byte (I know how to transfer these fields to txt)
- String (I know how to transfer these fields to txt)
- Char (I know how to transfer these fields to txt)
- Extended      (????????????????????????????????????)

I want make program which will transfer data from this field (Extended) to
text. But I don't have information how transform these information to text.
For example in btrieve file in field extended I have:
value  - 4,15
after executing command butil -recover SURCE DEST
in DEST file i obtain ASCII text witch (205) (204) (204) (204) (204) (204)
(204) (132) (1) (64) - In brackets are numbers which represents single ASCII
char.
And I don't have description how to transfer it to number:  4,15

If someone have such description pleas send me.

Thanks



Mon, 19 Jul 2004 15:34:05 GMT
 Butil -recover
Tomek,
    Is this some kind of float or decimal value?

Converting the string you gave to hex gives:
original - (205) (204) (204) (204) (204) (204) (204) (132) (1) (64)
hex - CD CC CC CC CC CC CC 84 C0

I am assuming that (1)(64) can be represented as 1 and then the 7 bits
required for 64 which are 1000000 - combined to make 11000000 or C0.

Overall, I am a bit confused
Sorry I can't seem to be of any more help,
Mike

Quote:

> In my btrieve file I have field with format as:
> - Byte (I know how to transfer these fields to txt)
> - String (I know how to transfer these fields to txt)
> - Char (I know how to transfer these fields to txt)
> - Extended      (????????????????????????????????????)

> I want make program which will transfer data from this field (Extended) to
> text. But I don't have information how transform these information to
text.
> For example in btrieve file in field extended I have:
> value  - 4,15
> after executing command butil -recover SURCE DEST
> in DEST file i obtain ASCII text witch (205) (204) (204) (204) (204) (204)
> (204) (132) (1) (64) - In brackets are numbers which represents single
ASCII
> char.
> And I don't have description how to transfer it to number:  4,15

> If someone have such description pleas send me.

> Thanks



Tue, 20 Jul 2004 07:54:30 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. butil -recover not recovering integer data types

2. using butil -recover

3. BUTIL -RECOVER under Btrieve 7.01 ?

4. Database in 'Recovering' mode never recovers

5. BUTIL -INDEX

6. windows 2000 server and DOS butil

7. butil.exe error on win2k machine

8. Newbie: BUTIL and VB

9. butil

10. BUTIL description file format

11. BUTIL and Counting Records

12. Butil doesn't create all *.^^^ for *.dat


 
Powered by phpBB® Forum Software