Extracting data from *.DTA files.

  • Follow


Hi.

Is there a way to retrieve data from a *.DTA file
other than using butil ?
When I'm putting sth like this:

	butil -SAVE <input_file.DTA> <output_file>

I get this:

	Btrieve error on <input_file.DTA>. Status = 2.

I have no access to Windows/DOS machine. I'm using
Linux+dosemu to accomplish this.

-- 
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72
0
Reply PeDe 8/20/2004 1:14:34 PM

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<font size="-1"><font face="Tahoma">You might try butil -recover
instead. Error 2 means you have a corrupted btrieve file.</font></font><br>
<br>
PeDe wrote:<br>
<blockquote type="cite" cite="midcg4tfk$eq6$1@news2.ipartners.pl">Hi.
  <br>
  <br>
Is there a way to retrieve data from a *.DTA file
  <br>
other than using butil ?
  <br>
When I'm putting sth like this:
  <br>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;butil -SAVE &lt;input_file.DTA&gt; &lt;output_file&gt;
  <br>
  <br>
I get this:
  <br>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;Btrieve error on &lt;input_file.DTA&gt;. Status = 2.
  <br>
  <br>
I have no access to Windows/DOS machine. I'm using
  <br>
Linux+dosemu to accomplish this.
  <br>
  <br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 

John

</pre>
</body>
</html>

0
Reply John 8/20/2004 5:55:50 PM


Just to make sure, you DID replace <input_file.DTA> with the name of
your datafile, right?  As in:
      BUTIL   -SAVE   FILENAME.DTA  OUTPUT.UNF

Also, it might help to know which version your Btrieve file is in, and
which version of Btrieve you are running.  Note that Btrieve 5.x engine
will not understand a Btrieve 6.x database file.  Also, I'm not sure
which database versions, if any, will run in a dosemu environment.

I'd strongly recommend moving to Pervasive.SQL V8, which provides a true
Linux engine (and now a client) for your use.
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach
 BillBach@goldstarsoftware.com
 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: August, 2004: See our web site for details!


John E Singer wrote:

> You might try butil -recover instead. Error 2 means you have a
> corrupted btrieve file.
>
> PeDe wrote:
>
>> Hi.
>>
>> Is there a way to retrieve data from a *.DTA file
>> other than using butil ?
>> When I'm putting sth like this:
>>
>>     butil -SAVE <input_file.DTA> <output_file>
>>
>> I get this:
>>
>>     Btrieve error on <input_file.DTA>. Status = 2.
>>
>> I have no access to Windows/DOS machine. I'm using
>> Linux+dosemu to accomplish this.
>>
>
> --
>
> John
>
>

0
Reply Bill 8/22/2004 10:17:04 PM

Hi.

Bill Bach wrote:
> Just to make sure, you DID replace <input_file.DTA> with the name of
> your datafile, right?  As in:
>       BUTIL   -SAVE   FILENAME.DTA  OUTPUT.UNF

It was correct :)

> 
> Also, it might help to know which version your Btrieve file is in, and
> which version of Btrieve you are running.  Note that Btrieve 5.x engine
> will not understand a Btrieve 6.x database file.  Also, I'm not sure
> which database versions, if any, will run in a dosemu environment.

Well, this app runs perfectly in dosemu env. and I just wanted to know
how I could extract data from those files to use it, let's say, in Excel 
or sth.
Where in the Net can I find a good walk-thru about migrating from btrieve to
pervasive ?

Thanks for Your assist.

-- 
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72
0
Reply PeDe 8/23/2004 6:43:40 AM

Without knowing your database version information, I can't tell you whether you
should be able to use BUTIL to get to the file or not.  If you still get a
Status 2, then the file may be actually corrupted.

To access Btrieve files from other applications, there are several options, all
with prerequisites.  Please check my white paper list at
www.goldstarsoftware.com/press.asp and see the paper on Accessing Btrieve Data
From ODBC.  This gives you a good idea of what is at play here, along with a
link to another paper about determining your database version.

As for "migrating from Btrieiev to Pervasive", there is nothing to do.  Simply
install the new engine and run your apps.  Underneath Pervasive.SQL is a newer
version of the Microkernel Database Engine that is also at the heart of Btrieve
6.x.
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach
 BillBach@goldstarsoftware.com
 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: August, 2004: See our web site for details!


PeDe wrote:

> Hi.
>
> Bill Bach wrote:
> > Just to make sure, you DID replace <input_file.DTA> with the name of
> > your datafile, right?  As in:
> >       BUTIL   -SAVE   FILENAME.DTA  OUTPUT.UNF
>
> It was correct :)
>
> >
> > Also, it might help to know which version your Btrieve file is in, and
> > which version of Btrieve you are running.  Note that Btrieve 5.x engine
> > will not understand a Btrieve 6.x database file.  Also, I'm not sure
> > which database versions, if any, will run in a dosemu environment.
>
> Well, this app runs perfectly in dosemu env. and I just wanted to know
> how I could extract data from those files to use it, let's say, in Excel
> or sth.
> Where in the Net can I find a good walk-thru about migrating from btrieve to
> pervasive ?
>
> Thanks for Your assist.
>
> --
> 10-4
> Pe<>De
> Life is an open road to me.
> http://www.pld-linux.org/Members/dlugi72

0
Reply Bill 8/25/2004 8:36:49 PM

Bill Bach wrote:
> Without knowing your database version information, I can't tell you whether you
> should be able to use BUTIL to get to the file or not.  If you still get a
> Status 2, then the file may be actually corrupted.

When I use btrieve locally from a workstation it shows "5.10a" version
but this error code suggest that those DTA files were created using
different record manager. Possibly 6.x.

> To access Btrieve files from other applications, there are several options, all
> with prerequisites.  Please check my white paper list at
> www.goldstarsoftware.com/press.asp and see the paper on Accessing Btrieve Data
> From ODBC.  This gives you a good idea of what is at play here, along with a
> link to another paper about determining your database version.

Thanks! Need to take a peak.

> As for "migrating from Btrieiev to Pervasive", there is nothing to do.  Simply
> install the new engine and run your apps.  Underneath Pervasive.SQL is a newer
> version of the Microkernel Database Engine that is also at the heart of Btrieve
> 6.x.

Would be perfect but somehow I feel it's not that simple ;)
We'll see.

Thanks again for Your assist.

-- 
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72
0
Reply PeDe 8/30/2004 10:09:05 AM

Hi again.

Just to clear things out. When I don't have DDF files and there
is no way to get them from the developers of my btrieve app
I just can't figure out the structure of DTA files by myself (or it 
would take too long).
Am I correct here ?

-- 
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72
0
Reply PeDe 9/8/2004 11:23:20 AM

If the developer provides no DDF's or the structure, then SOMEONE will
need to figure out the structure for you to access it from ODBC.  You
would be the most logical choice, since you know thge application the
best.  However, other companies, such as ourselves, can also help with
the DDF creation.  However, since we don't know the app either, and will
simply need to take a lot of educated guesses, this will take a long
time -- and consequently be quite expensive.  (Probably less expensive
than hiring someone to re-key all of the data, though.)
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach
 BillBach@goldstarsoftware.com
 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: August, 2004: See our web site for details!


PeDe wrote:

> Hi again.
>
> Just to clear things out. When I don't have DDF files and there
> is no way to get them from the developers of my btrieve app
> I just can't figure out the structure of DTA files by myself (or it
> would take too long).
> Am I correct here ?
>
> --
> 10-4
> Pe<>De
> Life is an open road to me.
> http://www.pld-linux.org/Members/dlugi72

0
Reply Bill 9/9/2004 10:43:39 PM

7 Replies
179 Views

(page loaded in 0.405 seconds)

Similiar Articles:













7/26/2012 3:38:09 PM


Reply: