Re: [GNC] Trouble opening ancient files
Online resources indicate that Windows support was added for 2.2, so finding Windows binaries before that may be futile. According to the wikipedia article, that was in 2007. On Jun 17, 2020, 12:17, at 12:17, Derek Atkins wrote: >Thomas Klausner writes: > >> On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote: >>> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. >The >>> ability to read those old binary files was removed more than a >decade ago. >>> >>> You'll need to import that using something probably as old (new?) as >1.6 >>> in order to convert it to XML, but you'll probably need a very old >OS in >>> order to build it. >> >> Ok, I didn't find such an old binary. >> >> Does anyone still have such a binary running, or a Windows 2.0.x exe >somewhere? > >You MAY be able to find them on sourceforge under the Files section. >Either that or you'll need to install an old VM to build 2.0 yourself. >Unfortunately the earliest Windows exe I've got is 2.4.0 which is way >too new for you. > >>> [snip] >>> > Any suggestions on how to get versions of these files that could >be >>> > opened by gnucash 3.10? >>> >>> These later XML files are also relatively old. My guess, you'll >>> probably need to start with 1.6 (or maybe even 1.4 for the binary >data) >>> and then keep on doing File -> Open / File -> Save As to translate >the >>> data files from version to version: >>> >>> 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 >-> >>> 2.4 -> 2.6 -> 3.x >>> >>> Expect this to take a while. >> >> Actually, this quite a bit easier than I expected. I downloaded the >> Windows 2.2.9 binary and opened the newer file and saved it, then >3.10 >> could open it successfully. :) > >Hmm. Surprised that you could jump from 2.2.9 to 3.10 without any >issues! I would have expected that you'd have to hit 2.4 or 2.6 first. > >> Can you please fix this warning: >> >> "This file/URL appears to be from a newer version of GnuCash. You >must >> upgrade your version of GnuCash to work with this data." >> >> that appeared for this file? > >You would need to provide a copy of the file in (or possible work with >the devs to recreate it) in order to get that warning fixed >appropriately. > >> Thanks, >> Thomas > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > >-derek > >-- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >If you are using Nabble or Gmane, please see >https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
Thomas Klausner writes: > On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote: >> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The >> ability to read those old binary files was removed more than a decade ago. >> >> You'll need to import that using something probably as old (new?) as 1.6 >> in order to convert it to XML, but you'll probably need a very old OS in >> order to build it. > > Ok, I didn't find such an old binary. > > Does anyone still have such a binary running, or a Windows 2.0.x exe > somewhere? You MAY be able to find them on sourceforge under the Files section. Either that or you'll need to install an old VM to build 2.0 yourself. Unfortunately the earliest Windows exe I've got is 2.4.0 which is way too new for you. >> [snip] >> > Any suggestions on how to get versions of these files that could be >> > opened by gnucash 3.10? >> >> These later XML files are also relatively old. My guess, you'll >> probably need to start with 1.6 (or maybe even 1.4 for the binary data) >> and then keep on doing File -> Open / File -> Save As to translate the >> data files from version to version: >> >> 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> >> 2.4 -> 2.6 -> 3.x >> >> Expect this to take a while. > > Actually, this quite a bit easier than I expected. I downloaded the > Windows 2.2.9 binary and opened the newer file and saved it, then 3.10 > could open it successfully. :) Hmm. Surprised that you could jump from 2.2.9 to 3.10 without any issues! I would have expected that you'd have to hit 2.4 or 2.6 first. > Can you please fix this warning: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > that appeared for this file? You would need to provide a copy of the file in (or possible work with the devs to recreate it) in order to get that warning fixed appropriately. > Thanks, > Thomas > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
I’d suspect if you walked a bit more slowly through the versions, you wouldn’t get that message, but I can’t say that with certainty. Maybe the Tracefile has more info. (see the wiki about finding the Tracefile on your system) So you might have to step back from the original copy through the 2.x series. Back then, each ‘x’ was a fairly major release. 2.0 --> 2.2 is more analogous to 2.x --> 3.x than to 3.0 --> 3.1 (The devs moved from a major.minor.bugfix number scheme to an major.minor_and_bugfix scheme If you don’t go through the steps in order as recommended, you might not get certain file conversions along the way. You might be able to skip *some* ‘bugfix’ releases, but you might still have to step through each ‘minor’ release. Regards, Adrien > On Jun 16, 2020 w25d168, at 12:50 PM, Thomas Klausner wrote: > > On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote: >> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The >> ability to read those old binary files was removed more than a decade ago. >> >> You'll need to import that using something probably as old (new?) as 1.6 >> in order to convert it to XML, but you'll probably need a very old OS in >> order to build it. > > Ok, I didn't find such an old binary. > > Does anyone still have such a binary running, or a Windows 2.0.x exe > somewhere? > >> [snip] >>> Any suggestions on how to get versions of these files that could be >>> opened by gnucash 3.10? >> >> These later XML files are also relatively old. My guess, you'll >> probably need to start with 1.6 (or maybe even 1.4 for the binary data) >> and then keep on doing File -> Open / File -> Save As to translate the >> data files from version to version: >> >> 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> >> 2.4 -> 2.6 -> 3.x >> >> Expect this to take a while. > > Actually, this quite a bit easier than I expected. I downloaded the > Windows 2.2.9 binary and opened the newer file and saved it, then 3.10 > could open it successfully. :) > > Can you please fix this warning: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > that appeared for this file? > > Thanks, > Thomas ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote: > This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The > ability to read those old binary files was removed more than a decade ago. > > You'll need to import that using something probably as old (new?) as 1.6 > in order to convert it to XML, but you'll probably need a very old OS in > order to build it. Ok, I didn't find such an old binary. Does anyone still have such a binary running, or a Windows 2.0.x exe somewhere? > [snip] > > Any suggestions on how to get versions of these files that could be > > opened by gnucash 3.10? > > These later XML files are also relatively old. My guess, you'll > probably need to start with 1.6 (or maybe even 1.4 for the binary data) > and then keep on doing File -> Open / File -> Save As to translate the > data files from version to version: > > 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> > 2.4 -> 2.6 -> 3.x > > Expect this to take a while. Actually, this quite a bit easier than I expected. I downloaded the Windows 2.2.9 binary and opened the newer file and saved it, then 3.10 could open it successfully. :) Can you please fix this warning: "This file/URL appears to be from a newer version of GnuCash. You must upgrade your version of GnuCash to work with this data." that appeared for this file? Thanks, Thomas ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
Just because I was curious and had time on my hands, some digging into git looks like the binary file support was removed sometime during the development of 2.2, so the 2.0 series looks to be the last version that would read the old binary files. In case anyone is curious, here is the commit: https://github.com/Gnucash/gnucash/commit/89f37371d94ffe02af99b27e3a0dd30981263550#diff-8a2fc856d7cef71a3ac47d2f08469ec3 Matt On Tuesday, June 16, 2020, 09:23:25 AM CDT, Derek Atkins wrote: Hi, Thomas Klausner writes: > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The ability to read those old binary files was removed more than a decade ago. You'll need to import that using something probably as old (new?) as 1.6 in order to convert it to XML, but you'll probably need a very old OS in order to build it. [snip] > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? These later XML files are also relatively old. My guess, you'll probably need to start with 1.6 (or maybe even 1.4 for the binary data) and then keep on doing File -> Open / File -> Save As to translate the data files from version to version: 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> 2.4 -> 2.6 -> 3.x Expect this to take a while. > Thank you, > Thomas > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
Hi, Thomas Klausner writes: > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| This looks like it might be a GnuCash 1.2 or 1.4 binary datafile. The ability to read those old binary files was removed more than a decade ago. You'll need to import that using something probably as old (new?) as 1.6 in order to convert it to XML, but you'll probably need a very old OS in order to build it. [snip] > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? These later XML files are also relatively old. My guess, you'll probably need to start with 1.6 (or maybe even 1.4 for the binary data) and then keep on doing File -> Open / File -> Save As to translate the data files from version to version: 1.4 -> 1.6 -> 1.8 (was there a 1.8? I don't recall) -> 2.0 -> 2.2 -> 2.4 -> 2.6 -> 3.x Expect this to take a while. > Thank you, > Thomas > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
Message: 5 Date: Mon, 15 Jun 2020 23:56:34 -0500 From: Adrien Monteleone To: GnuCash Users Subject: Re: [GNC] Trouble opening ancient files Message-ID: <23fbb3da-53a4-47c1-99e4-b0a1cac1f...@lusfiber.net> Content-Type: text/plain; charset=utf-8 That first 2002 file is indeed ancient. (the 2005 file is no spring chicken either) For both cases, you?d have to find the ?newest? version of GnuCash that will open each file, then upgrade GnuCash in steps (possibly some leaps skipping bug-fix releases) and open each file with each version. At some point, file conversions will be done so they are readable by newer versions, and not backwards compatible. Eventually you?ll arrive at the 3.x series and then you can jump to 3.10. You?ll have to start this further back for the 2002 file and then eventually you?ll be able to open up each with the same version. You might get lucky and only have to make 2 or three steps. Sorry I can?t help pinpoint a version to target to get started, or help with which versions you can skip. The wiki may provide some help if you dig, (as in reading old change logs) otherwise maybe someone familiar with those older files can help with specifics. Regards, Adrien > On Jun 15, 2020 w25d167, at 3:49 PM, Thomas Klausner wrote: > > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| > > where I'm quite sure that "Ausgaben" is an account name and FRF is a > unit of currency, so probably Account number 100 in the Unit of FRF. > > > The second file has a timestamp from 2005. It is plaintext XML. The > error from gnucash is: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > The file starts with: > > --- begin quote --- > > > 1 > > 61535f2d2589fccc34164e57b1255f25 > 1 > 38 > 1023 > > NASDAQ > Fond > Fond > 10 > > --- end quote --- > > Then follows a gnc:pricedb and some accounts like > > --- begin quote --- > > Ausgaben > be0508dcdbc39e35f677dd6f334d36e5 > EXPENSE > >ISO4217 >ATS > > 100 > 100 > Ausgaben > > --- end quote --- > > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? > > Thank you, > Thomas Hi Thomas, Maybe you're opening the wrong file... GnuCash data files used to be .xac files. See https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_... Also https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgra de Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble opening ancient files
That first 2002 file is indeed ancient. (the 2005 file is no spring chicken either) For both cases, you’d have to find the ’newest’ version of GnuCash that will open each file, then upgrade GnuCash in steps (possibly some leaps skipping bug-fix releases) and open each file with each version. At some point, file conversions will be done so they are readable by newer versions, and not backwards compatible. Eventually you’ll arrive at the 3.x series and then you can jump to 3.10. You’ll have to start this further back for the 2002 file and then eventually you’ll be able to open up each with the same version. You might get lucky and only have to make 2 or three steps. Sorry I can’t help pinpoint a version to target to get started, or help with which versions you can skip. The wiki may provide some help if you dig, (as in reading old change logs) otherwise maybe someone familiar with those older files can help with specifics. Regards, Adrien > On Jun 15, 2020 w25d167, at 3:49 PM, Thomas Klausner wrote: > > Hi! > > I have been using gnucash for a very long time, and recently I tried > opening some of my first files -- but couldn't. Many old files worked, > but not these two and their related .xac files. > > I see two different symptoms. > > One file has an timestamp from 2002. I don't recognize the file > format, it's a binary format, but gzip cannot unpack it > The error I get from gnucash (3.10) is: > > "No suitable backend was found for /path/to/file." > > A hexdump of the file starts with: > > 00 00 00 0a 00 00 00 04 00 00 00 ab 00 08 00 00 || > 0010 00 09 41 75 73 67 61 62 65 6e 00 00 00 00 04 31 |..Ausgaben.1| > 0020 30 30 00 00 00 00 01 00 00 00 00 01 00 00 00 00 |00..| > 0030 04 46 52 46 00 00 00 00 01 00 00 00 00 00 00 00 |.FRF| > 0040 00 01 00 00 00 05 00 00 00 d6 00 08 00 00 00 06 || > 0050 45 73 73 65 6e 00 00 00 00 04 31 31 30 00 00 00 |Essen.110...| > > where I'm quite sure that "Ausgaben" is an account name and FRF is a > unit of currency, so probably Account number 100 in the Unit of FRF. > > > The second file has a timestamp from 2005. It is plaintext XML. The > error from gnucash is: > > "This file/URL appears to be from a newer version of GnuCash. You must > upgrade your version of GnuCash to work with this data." > > The file starts with: > > --- begin quote --- > > > 1 > > 61535f2d2589fccc34164e57b1255f25 > 1 > 38 > 1023 > > NASDAQ > Fond > Fond > 10 > > --- end quote --- > > Then follows a gnc:pricedb and some accounts like > > --- begin quote --- > > Ausgaben > be0508dcdbc39e35f677dd6f334d36e5 > EXPENSE > >ISO4217 >ATS > > 100 > 100 > Ausgaben > > --- end quote --- > > Any suggestions on how to get versions of these files that could be > opened by gnucash 3.10? > > Thank you, > Thomas ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.