1. Forum
  2. Usenet
  3. COMP.LANG.CLIPPER

  • DBF + DBV

    From Dan Yaeger@21:1/5 to Stephen Quinn on Mon May 24 14:21:47 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dlzc@21:1/5 to Dan Yaeger on Tue May 25 07:20:02 2021
    Dear Dan Yeager:

    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 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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Yaeger@21:1/5 to dlzc on Tue May 25 11:24:14 2021
    On Tuesday, May 25, 2021 at 9:20:06 AM UTC-5, dlzc wrote:
    Dear Dan Yeager:

    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 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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dlzc@21:1/5 to Dan Yaeger on Tue May 25 13:17:16 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jan Bucek@21:1/5 to All on Wed May 26 17:03:20 2021
    Dne 24.5.2021 v 23:21 Dan Yaeger napsal(a):
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Yaeger@21:1/5 to Jan Bucek on Thu Jun 3 14:32:59 2021
    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):
    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
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jan Bucek@21:1/5 to All on Fri Jun 4 09:24:58 2021
    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):
    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
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Yaeger@21:1/5 to Jan Bucek on Fri Jun 4 12:11:17 2021
    On Friday, June 4, 2021 at 2:25:13 AM UTC-5, Jan Bucek wrote:
    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):
    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
    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

    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!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)