Discussion:
DBF + DBV
(too old to reply)
Dan Yaeger
2021-05-24 21:21:47 UTC
Permalink
Jeffrey
Bytes 1 & 2 are the offsets in the DBV where the data resides
Bytes 3 & 4 are the length of the stored data
Bytes 5 & 6 I don't know, at a guess the type of data stored
ie object, array, plain text, encryption type
The above is from memory so 1-4 may be reversed<g>
--
HTH
Steve Quinn
Never take life seriously. Nobody gets out alive anyway.
Sex is like air; it's not important unless you aren't getting any.
Health is merely the slowest possible rate at which one can die.
I am trying to figure out this same task on an old flexfile stored memo field. I am about to give up on this conversion and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv), i just receive the pointer field with 6 characters. Almost every link on the internet is broken that references tools and materials to aid in this conversion.
Steve you seem to have a wealth of knowledge in these older clipper/flexfile systems. Do you know if the tool DBF/DBV -> DBF/DBT converter still exists? or if there are any resources that could get this data out? I am migrating everything to a MySQL database, i have all my dbf data already migrated, but the memo field has been the sticking point.

-Dan
dlzc
2021-05-25 14:20:02 UTC
Permalink
Dear Dan Yeager:

On Monday, May 24, 2021 at 2:21:48 PM UTC-7, Dan Yaeger wrote:
...
Post by Dan Yaeger
I am trying to figure out this same task on an old flexfile
stored memo field. I am about to give up on this conversion
and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv),
i just receive the pointer field with 6 characters. Almost every
link on the internet is broken that references tools and
materials to aid in this conversion.
I find the following: https://groups.google.com/g/comp.lang.xharbour/c/fnO7ZLLumIc/m/uYgYerQLFLMJ

Rename the memofile extension to the one for Fauxpro, and change the first byte (with a suitable editor), and you might be able to treat it as a FauxPro file. You can probably find the tools you need for that. Make sure you do this with a COPY, not the ORIGINAL, of course.

David A. Smith
Dan Yaeger
2021-05-25 18:24:14 UTC
Permalink
Post by dlzc
...
Post by Dan Yaeger
I am trying to figure out this same task on an old flexfile
stored memo field. I am about to give up on this conversion
and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv),
i just receive the pointer field with 6 characters. Almost every
link on the internet is broken that references tools and
materials to aid in this conversion.
I find the following: https://groups.google.com/g/comp.lang.xharbour/c/fnO7ZLLumIc/m/uYgYerQLFLMJ
Rename the memofile extension to the one for Fauxpro, and change the first byte (with a suitable editor), and you might be able to treat it as a FauxPro file. You can probably find the tools you need for that. Make sure you do this with a COPY, not the ORIGINAL, of course.
David A. Smith
Thank you David. I will keep investigating. I feel like I am closer with every bit of information, I believe my files are a bit different than the traditional files. Everything I have tried seems to be a bit different than the standard. It doesn't help that I am not a programmer by trade, I just get roped into projects like this.
dlzc
2021-05-25 20:17:16 UTC
Permalink
Dear Dan Yaeger:

On Tuesday, May 25, 2021 at 11:24:15 AM UTC-7, Dan Yaeger wrote:
...
Thank you David. I will keep investigating. I feel like I am closer
with every bit of information, I believe my files are a bit different
than the traditional files. Everything I have tried seems to be a
bit different than the standard. It doesn't help that I am not a
programmer by trade, I just get roped into projects like this.
You are an "expert" like so many of us. An "ex" is a "has been" and a "spurt" is a drip under pressure. So many people find suckers to do their dirty work for them... that is how I got into computers and programming.

David A. Smith
Jan Bucek
2021-05-26 15:03:20 UTC
Permalink
Post by Dan Yaeger
Jeffrey
Bytes 1 & 2 are the offsets in the DBV where the data resides
Bytes 3 & 4 are the length of the stored data
Bytes 5 & 6 I don't know, at a guess the type of data stored
ie object, array, plain text, encryption type
The above is from memory so 1-4 may be reversed<g>
--
HTH
Steve Quinn
Never take life seriously. Nobody gets out alive anyway.
Sex is like air; it's not important unless you aren't getting any.
Health is merely the slowest possible rate at which one can die.
I am trying to figure out this same task on an old flexfile stored memo field. I am about to give up on this conversion and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv), i just receive the pointer field with 6 characters. Almost every link on the internet is broken that references tools and materials to aid in this conversion.
Steve you seem to have a wealth of knowledge in these older clipper/flexfile systems. Do you know if the tool DBF/DBV -> DBF/DBT converter still exists? or if there are any resources that could get this data out? I am migrating everything to a MySQL database, i have all my dbf data already migrated, but the memo field has been the sticking point.
-Dan
Hi Dan,
I have found my old conversion tools for Clipper 5.3b I have developped
years ago on my PC - EXEs and source too. I have deployed the entire
directory on "http://www.bucek.info/rdd2rdd.zip". Try to use the EXEs
(Win32 max.) or check the source code, if it helps.
Best Regards
Jan Bucek
Dan Yaeger
2021-06-03 21:32:59 UTC
Permalink
Post by Jan Bucek
Jeffrey
Bytes 1 & 2 are the offsets in the DBV where the data resides
Bytes 3 & 4 are the length of the stored data
Bytes 5 & 6 I don't know, at a guess the type of data stored
ie object, array, plain text, encryption type
The above is from memory so 1-4 may be reversed<g>
--
HTH
Steve Quinn
Never take life seriously. Nobody gets out alive anyway.
Sex is like air; it's not important unless you aren't getting any.
Health is merely the slowest possible rate at which one can die.
I am trying to figure out this same task on an old flexfile stored memo field. I am about to give up on this conversion and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv), i just receive the pointer field with 6 characters. Almost every link on the internet is broken that references tools and materials to aid in this conversion.
Steve you seem to have a wealth of knowledge in these older clipper/flexfile systems. Do you know if the tool DBF/DBV -> DBF/DBT converter still exists? or if there are any resources that could get this data out? I am migrating everything to a MySQL database, i have all my dbf data already migrated, but the memo field has been the sticking point.
-Dan
Hi Dan,
I have found my old conversion tools for Clipper 5.3b I have developped
years ago on my PC - EXEs and source too. I have deployed the entire
directory on "http://www.bucek.info/rdd2rdd.zip". Try to use the EXEs
(Win32 max.) or check the source code, if it helps.
Best Regards
Jan Bucek
Thank you Jan. I tried to use the software you linked but still unable to link the dbf and dbv memo file. I may post something to Freelancer or another coding site to see if I can find someone to look at the data and export to another format I can use. I appreciate your time in finding the files and responding, if anything it gives me hope there are still experts out there.
Jan Bucek
2021-06-04 07:24:58 UTC
Permalink
Post by Dan Yaeger
Post by Jan Bucek
Jeffrey
Bytes 1 & 2 are the offsets in the DBV where the data resides
Bytes 3 & 4 are the length of the stored data
Bytes 5 & 6 I don't know, at a guess the type of data stored
ie object, array, plain text, encryption type
The above is from memory so 1-4 may be reversed<g>
--
HTH
Steve Quinn
Never take life seriously. Nobody gets out alive anyway.
Sex is like air; it's not important unless you aren't getting any.
Health is merely the slowest possible rate at which one can die.
I am trying to figure out this same task on an old flexfile stored memo field. I am about to give up on this conversion and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv), i just receive the pointer field with 6 characters. Almost every link on the internet is broken that references tools and materials to aid in this conversion.
Steve you seem to have a wealth of knowledge in these older clipper/flexfile systems. Do you know if the tool DBF/DBV -> DBF/DBT converter still exists? or if there are any resources that could get this data out? I am migrating everything to a MySQL database, i have all my dbf data already migrated, but the memo field has been the sticking point.
-Dan
Hi Dan,
I have found my old conversion tools for Clipper 5.3b I have developped
years ago on my PC - EXEs and source too. I have deployed the entire
directory on "http://www.bucek.info/rdd2rdd.zip". Try to use the EXEs
(Win32 max.) or check the source code, if it helps.
Best Regards
Jan Bucek
Thank you Jan. I tried to use the software you linked but still unable to link the dbf and dbv memo file. I may post something to Freelancer or another coding site to see if I can find someone to look at the data and export to another format I can use. I appreciate your time in finding the files and responding, if anything it gives me hope there are still experts out there.
1. What do you mean with "unable to link the dbf and dbv memo file"?

2. conversion DBT2DBV.EXE works OK for me, command:
DBT2DBV.EXE tableV.dbf DBV tableT.dbf
gives you new table tableT.dbf/dbt converted from existing
tableV.dbf/dbv

3. If it does not work for you, you can send me your DBF/DBV tables and
I convert it for you
--
Tato zpráva byla zkontrolována na viry programem Avast Antivirus.
https://www.avast.com/antivirus
Dan Yaeger
2021-06-04 19:11:17 UTC
Permalink
Post by Jan Bucek
Post by Jan Bucek
Jeffrey
Bytes 1 & 2 are the offsets in the DBV where the data resides
Bytes 3 & 4 are the length of the stored data
Bytes 5 & 6 I don't know, at a guess the type of data stored
ie object, array, plain text, encryption type
The above is from memory so 1-4 may be reversed<g>
--
HTH
Steve Quinn
Never take life seriously. Nobody gets out alive anyway.
Sex is like air; it's not important unless you aren't getting any.
Health is merely the slowest possible rate at which one can die.
I am trying to figure out this same task on an old flexfile stored memo field. I am about to give up on this conversion and notify my users they will be transferring this data by hand.
I cannot seem to get dClip to work for my memo fields (dbv), i just receive the pointer field with 6 characters. Almost every link on the internet is broken that references tools and materials to aid in this conversion.
Steve you seem to have a wealth of knowledge in these older clipper/flexfile systems. Do you know if the tool DBF/DBV -> DBF/DBT converter still exists? or if there are any resources that could get this data out? I am migrating everything to a MySQL database, i have all my dbf data already migrated, but the memo field has been the sticking point.
-Dan
Hi Dan,
I have found my old conversion tools for Clipper 5.3b I have developped
years ago on my PC - EXEs and source too. I have deployed the entire
directory on "http://www.bucek.info/rdd2rdd.zip". Try to use the EXEs
(Win32 max.) or check the source code, if it helps.
Best Regards
Jan Bucek
Thank you Jan. I tried to use the software you linked but still unable to link the dbf and dbv memo file. I may post something to Freelancer or another coding site to see if I can find someone to look at the data and export to another format I can use. I appreciate your time in finding the files and responding, if anything it gives me hope there are still experts out there.
1. What do you mean with "unable to link the dbf and dbv memo file"?
DBT2DBV.EXE tableV.dbf DBV tableT.dbf
gives you new table tableT.dbf/dbt converted from existing
tableV.dbf/dbv
3. If it does not work for you, you can send me your DBF/DBV tables and
I convert it for you
--
Tato zpráva byla zkontrolována na viry programem Avast Antivirus.
https://www.avast.com/antivirus
My output from running that executable doesn't seem to link to the dbv to create usable output. In other words, my input = output after running this application.
I created a temporary link to the files that will expire in a couple days. https://www.dropbox.com/s/kw395wlp0otqxu1/DBF-DBV%20Files.zip?dl=0
Thank you!

Loading...