JeffreyI 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.
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 flexfileI find the following: https://groups.google.com/g/comp.lang.xharbour/c/fnO7ZLLumIc/m/uYgYerQLFLMJ
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.
Dear Dan Yeager: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.
On Monday, May 24, 2021 at 2:21:48 PM UTC-7, Dan Yaeger wrote:
...
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 find the following: https://groups.google.com/g/comp.lang.xharbour/c/fnO7ZLLumIc/m/uYgYerQLFLMJ
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.
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.
On Saturday, January 8, 2000 at 2:00:00 AM UTC-6, Stephen Quinn wrote:
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
Dne 24.5.2021 v 23:21 Dan Yaeger napsal(a):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.
On Saturday, January 8, 2000 at 2:00:00 AM UTC-6, Stephen Quinn wrote:
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
On Wednesday, May 26, 2021 at 10:03:30 AM UTC-5, Jan Bucek wrote:
Dne 24.5.2021 v 23:21 Dan Yaeger napsal(a):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.
On Saturday, January 8, 2000 at 2:00:00 AM UTC-6, Stephen Quinn wrote:Hi Dan,
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
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
Dne 03.06.2021 v 23:32 Dan Yaeger napsal(a):
On Wednesday, May 26, 2021 at 10:03:30 AM UTC-5, Jan Bucek wrote:
Dne 24.5.2021 v 23:21 Dan Yaeger napsal(a):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.
On Saturday, January 8, 2000 at 2:00:00 AM UTC-6, Stephen Quinn wrote: >>>> JeffreyHi Dan,
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
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
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
--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.
Tato zpr|iva byla zkontrolov|ina na viry programem Avast Antivirus. https://www.avast.com/antivirus
| Sysop: | Amessyroom |
|---|---|
| Location: | Fayetteville, NC |
| Users: | 65 |
| Nodes: | 6 (0 / 6) |
| Uptime: | 04:13:03 |
| Calls: | 862 |
| Files: | 1,311 |
| D/L today: |
921 files (14,318M bytes) |
| Messages: | 264,528 |