Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Just an observation, from the depths of history... IIRC, 2.3.x I think was a development series; unstable and for bug testing and so on, and for "expert" users only (ie not me) it feels to me that having that running on win11 is unlikely, I'm not even sure that 2.3 release were for windows - if they were available then they would have been some of the very first releases of GC on winXP. I am pretty sure that if 2.3.4 was installed by the OP, then the GC database would be in XML not SQL and so the usually auto-created backup files should have been made and might be lurking in a corner of a hard disk? HTH, Maf. On Thursday, 20 October 2022 06:52:54 BST Adrien Monteleone wrote: > Unlikely, but you might get lucky. (You really don't have *any* backup > at all? Really? You've been using a decades old version of GnuCash and > you never make backups?) > > Note, the GnuCash file, by default unless you changed it, is a > compressed XML file. Uncompressed, it is just plain text and human > readable. (albeit in a markup language) How the file is arranged has > changed over the years, but the raw data should still be there. > > As for 'developing a problem afterwards' it could be that GnuCash is > proceeding with data migration in the background, but it may have gotten > hung up on something, or it is just really taking a long time. > > As David noted, running from the command line, or getting a Trace File > might shed some light as to what is going on. > > You *might* get lucky by removing 4.12, going back to 2.3.4, then > proceeding as I outlined, *but* be darned sure to MAKE A COPY of your > file before doing so! > > Honestly, I'd go the route David suggested first to get some output and > then report back here what you get. > > Also, what do you mean by 'blank screen'? Can you take a screenshot and > attach it in a reply? (do not paste in-line, it needs to be attached) > > Maybe do that FIRST, and then once we see what you see, we can advise > further. > > Regards, > Adrien > > On 10/19/22 10:13 PM, Rosepetals wrote: > > I don’t have a backup of the 2.3.4 database. Is there a way to recover > > data > > from the current 4.12 database? > > > > Also why does Gnucash work fine after the database upgrade but then > > develop > > a fault afterwards? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
Hi, The location of the database file has a number of log files in it if that helps. Thanks for responding. On Thu, 20 Oct 2022 at 7:01 pm, Maf. King wrote: > Just an observation, from the depths of history... > > IIRC, 2.3.x I think was a development series; unstable and for bug testing > and > so on, and for "expert" users only (ie not me) > > it feels to me that having that running on win11 is unlikely, I'm not even > sure that 2.3 release were for windows - if they were available then they > would have been some of the very first releases of GC on winXP. > > I am pretty sure that if 2.3.4 was installed by the OP, then the GC > database > would be in XML not SQL and so the usually auto-created backup files > should > have been made and might be lurking in a corner of a hard disk? > > HTH, > Maf. > > > > On Thursday, 20 October 2022 06:52:54 BST Adrien Monteleone wrote: > > Unlikely, but you might get lucky. (You really don't have *any* backup > > at all? Really? You've been using a decades old version of GnuCash and > > you never make backups?) > > > > Note, the GnuCash file, by default unless you changed it, is a > > compressed XML file. Uncompressed, it is just plain text and human > > readable. (albeit in a markup language) How the file is arranged has > > changed over the years, but the raw data should still be there. > > > > As for 'developing a problem afterwards' it could be that GnuCash is > > proceeding with data migration in the background, but it may have gotten > > hung up on something, or it is just really taking a long time. > > > > As David noted, running from the command line, or getting a Trace File > > might shed some light as to what is going on. > > > > You *might* get lucky by removing 4.12, going back to 2.3.4, then > > proceeding as I outlined, *but* be darned sure to MAKE A COPY of your > > file before doing so! > > > > Honestly, I'd go the route David suggested first to get some output and > > then report back here what you get. > > > > Also, what do you mean by 'blank screen'? Can you take a screenshot and > > attach it in a reply? (do not paste in-line, it needs to be attached) > > > > Maybe do that FIRST, and then once we see what you see, we can advise > > further. > > > > Regards, > > Adrien > > > > On 10/19/22 10:13 PM, Rosepetals wrote: > > > I don’t have a backup of the 2.3.4 database. Is there a way to recover > > > data > > > from the current 4.12 database? > > > > > > Also why does Gnucash work fine after the database upgrade but then > > > develop > > > a fault afterwards? > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] ANNOUNCE: Updated GnuCash with Finance::Quote 1.53 available on Flathub
Hi David, I have just tried again on my system and I don't get that error. Perhaps there was a download glitch ? Have you tried again some time later ? Regards, Geert Op maandag 17 oktober 2022 02:56:10 CEST schreef David H: > Hi Geert, > > Thanks for the update, it's appreciated. Unfortunately I'm getting the > following checksum error when trying to update : > > 1. [✗] org.gnucash.GnuCash stable u flathub > 2.7 MB / 110.1 MB > > Error: While pulling app/org.gnucash.GnuCash/x86_64/stable from remote > flathub: opcode close: Corrupted file object; checksum > expected='72a432ec6003270f7b3ff6a60dc9112743006c41e63019d457e1fdad963ed0d9' > actual='3e6e3dd99408f9a5cfc78d1d1c77e2fbaf7ae282f1a6f220f05c6ff7d878a1a1' > Updates complete. > error: There were one or more errors > > Cheers David H. > > > On Mon, 17 Oct 2022 at 05:19, Geert Janssens > > wrote: > > We have updated the GnuCash package on flathub to > > include Finance::Quote 1.53. > > > > The new flatpak is released as version 4.12-1. > > > > Update the org.gnucash.GnuCash flatpak via your > > distribution's package manager or by runing 'flatpak -- > > update org.gnucash.GnuCash' on the command line. > > ___ > > gnucash-devel mailing list > > gnucash-de...@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
I don't profess to have any great ideas, but I see from the one screenshot that your file opens, but appears to be empty, and I see from the other that you have numerous large log files (9mb or so) on every day of the display. Many of them appear to be only a few days old. Personally, my log files are very small (measured in kilobytes, not megabytes), so I am curious what you have been doing to get such large files. David T. P.S. -- I can't imagine how you ended up using a development version of GnuCash, and am sad to hear you've been using it all these years. On Oct 20, 2022, 2:05 PM, at 2:05 PM, Rosepetals wrote: >Hi, > >Yes it was silly of me. I recall years ago checking if I could update >to a >newer version but the official site said it was not advised. Then I >checked >recently and it said yes it was possible so I went on my merry way >thinking >it would be more streamlined. > >I may have a backup from 2 years ago on version 2.3.4 but of course >that >would mean I wouldn’t have the recent 2 years of transactions. > >The file type is simply File so it may be XML but upon opening it in >Notepad it mentions SQLite among the garbled text. > >I’ll try the trace tonight. For now I’ve left it running on 4.12 for >about >30 mins and no result in opening the file as shown in the pic below. >I’ve >reinstalled 2.3.4 and tried opening the file but it’s stuck on reading. >Will leave this for a while. > >Thank for your reply. > > >On Thu, 20 Oct 2022 at 4:12 pm, David Cousens > >wrote: > >> >> As Adrien pointed out anytime you do an upgrade of GNuCash you should >> ALWAYS >> make a backup copy of the data file before starting the upgrade and >keep >> it at >> least until everything is working. It is a good practice to regularly >make >> a >> backup copy of your data file in any case, preferrably to another >computer, >> network storage or a cloud (online) storage, usb stick etc. If you >have >> problems >> then you can always copy (not move) the file from your backup to your >data >> directory and start again. Are you using the xml file (a text file) >or an >> actual database backend? >> >> The datafile format sometimes has to be changed to accomodate new >features >> and >> fix some bugs. If such changes occur it is usually when changing from >the >> last >> version of a major series to the first version of the next. Version >4.x >> will >> assume that the file has already been upgraded from version 2 to >version >> 3. Each >> new major version of GnuCash includes a procedure for updating the >> datafile the >> first time it is run with a higher version. >> >> As well as changes in the datafile itself, there are sometimes >changes in >> the >> locations where stored reports and user preference data etc are >located. >> These >> are usually translated by the installation procedure for the first >install >> of a >> higher major version (2->3->4). The locations are also different on >> different >> operating >systems.https://wiki.gnucash.org/wiki/Configuration_Locations >> has >> details of the locations for various versions on Linux/Windows/Mac. >The >> page can >> be hard to read but there are some diagrams accessed form links about >> halfway >> down the page >> >> Not sure how you can recover without a backup of the original file. >> >> With a 30Mb file it may take some time to convert the datafile at >startup. >> GnuCash will be unresponsive while this is taking place so don't >assume it >> has >> stopped/crashed - use the task manager >> >(https://www.howtogeek.com/405806/windows-task-manager-the-complete-guide/) >> to >> check that it is no longer runnning as Adrien suggested and if so let >it >> run to >> completion or until it actually crashes. >> >> If GnuCash is actually crashing, i.e. it stops running completely, >then >> generating a trace file and stack trace file as described in >> https://wiki.gnucash.org/wiki/Tracefile and posting them here may >help in >> working out if your file can be fixed and how. >> >> If you can get your datafile to open, before doing anything else run >the >> Actions->Check & Repair->All transactions from the menu. >> >> Hope this helps. >> >> >> >> On Wed, 2022-10-19 at 23:11 +1100, Rosepetals wrote: >> > Hi all, >> > >> > I’m running Windows 11. >> > >> > I was running Gnucash 2.3.4 for years and finally decided to >upgrade to >> the >> > latest stable release of 4.12 so I can export to a spreadsheet. >> > >> > The setup needed to uninstall 2.3.4 which went fine and then 4.12 >> finished >> > installing. >> > >> > I opened Gnucash 4.12 and opened my Gnucash database. It notified >me I >> > needed to upgrade the database to the new version which worked fine >and I >> > was able to access all my data. I made a few entries and closed >Gnucash >> > without any issues. >> > >> > Later I opened Gnucash again but this time it didn’t auto open the >> database >> > and I'm left with a blank screen. I proceed to locate and open the >> database >> > but after waiti
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
On 10/20/2022 1:11 AM, David Cousens wrote: As Adrien pointed out anytime you do an upgrade of GNuCash you should ALWAYS make a backup copy of the data file before starting the upgrade and keep it at least until everything is working. It is a good practice to regularly make a backup copy of your data file in any case, preferrably to another computer, network storage or a cloud (online) storage, usb stick etc. Whenever you are upgrading ANY application you should make a back-up of the user data of that application (immediately before the upgrade). This is in addition to the regular periodic back-ups you are making (unless you always to choose to do all application upgrades immediately after the regular periodic back-up). You ARE doing periodic back-ups of your user data, yes? In other words, the advice how to do it for gnucash is not specific to gnucash. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 235, Issue 46
I am a new GnuCash user and currently busy setting everything up. I have done a lot of thinking and testing on the multi-currency issue in order to hopefully get it right from the start. So far my conclusion is this - and please, more experienced users, correct me if there is a flaw in my thinking: - For asset and liability accounts, multi-currency accounts make obviously a lot of sense if you hold assets and liabilities denominated in multiple currencies. Changes in value in respect to your base currency are perfectly taken care of by using the automatic trading accounts. - BUT: For income and expense accounts, multi-currency accounts seem to be a total disaster. Why? Because all PAST transactions on both income and expense accounts will be valued at the CURRENT exchange rates. Consider an extreme example which illustrates the problem drastically: Imagine you dined at a restaurant in Argentina in January 2018. You paid 250 ARS in cash, which equaled about 11 EUR at the time. If you had recorded this on an expense account denominated in ARS and you looked at your GnuCash book today, it would show you that you spent only 0.88 EUR for that meal in 2018. The peso lost almost all of its value since then. Your data in GnuCash will be almost worthless. GnuCash does record the difference between 11 and 0.88 EUR in your trading accounts as a loss of value of "your" ARS 250 (that you don't have any more because you spent them in 2018), but for all transactions that have been recorded in the ARS expense account, it will only show just the total loss you have had over the years in ARS vs EUR. If there were many transactions, you would have no idea what you really paid in your base currency at the time of each transaction. Trading accounts are meant to track changes in value of assets and liabilities you are currently holding, but most definitely not for expenses and income from the past, which has already happened and cannot be changed anymore. Therefore, my current conclusion is that for all transaction that involve income or expense accounts, the amount has to be converted into the base currency using the exchange rate on the day the transaction occurred, or at least closely. Exchange rates normally do not move a lot from day to day, but over many months or even years there can be huge moves - and those will ruin the data in your GnuCash book if you don't consider this effect. If somebody has another solution, please let me know, as the extra effort to make the conversion for each transaction is obviously anything but fun. Best regards, Patrick Poendl Am Mi., 19. Okt. 2022 um 02:47 Uhr schrieb : > > -- Forwarded message -- > From: Anton Tsyganenko > To: gnucash-user@gnucash.org > Cc: > Bcc: > Date: Tue, 18 Oct 2022 13:34:13 +0400 > Subject: [GNC] Enhancement request: multi-currency accounts > Let's take a look on accounts that are created in gnucash by default. > Generally most of the accounts may be multi-currency, i. e. not bond to > a specific currency: you may have cash in multiple currencies, your > opening balances may be in multiple currencies, you may have incomes and > expenses in multiple currencies. Bank accounts generally have only one > currency, but there are some banks that offer multi-currency cards and > deposits. These surely can be considered as just a few different > accounts, but it may be more convenient to group them together.Now I > solve that by creating sub-accounts for each currency I need for each > account where I need it. It looks like: > Expenses:Dining:USD > Expenses:Dining:EUR > Expenses:Dining:CAD > Expenses:Transport:USD > Expenses:Transport:EUR > Expenses:Transport:CAD > > It's very painful to create all of them. I know that I may have only one > account in my _main_ currency, but I prefer all currencies to be equal > and not perform redundant currency conversions, for example when I spend > CAD cash for dining in Canada. > > So my proposal is: > > All accounts that user creates are "multi-currency", like placeholder > accounts without any specific currency. Sub-accounts for each currency > are created automatically, when the first operation in this currency in > this account is made. If a multi-currency account is deleted and > operations are moved to another account, operations in all the > subaccounts are moved to the corresponding subaccounts of the second > account. Balances can be shown as a sum of (non-null) amounts in > different currencies (but sometimes can be converted to one currency). > In a multi-currency account's view (basic ledger) there should be just > an additional column -- currency of an operation (editable as a > drop-down menu). So user opens account "cash" and sees something like: > > Date | Description | Transfer | Debit | Credit | Currency | Balance > > 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR | 100 > USD + 55 EUR > > That operation is a transfer of 25 EUR from Assets:Cash:EUR to > Expenses:Dining:EUR.
Re: [GNC] Enhancement request: multi-currency accounts
I am a new GnuCash user and currently busy setting everything up. I have done a lot of thinking and testing on the multi-currency issue in order to hopefully get it right from the start. So far my conclusion is this - and please, more experienced users, correct me if there is a flaw in my thinking: - For asset and liability accounts, multi-currency accounts make obviously a lot of sense if you hold assets and liabilities denominated in multiple currencies. Changes in value in respect to your base currency are perfectly taken care of by using the automatic trading accounts. - BUT: For income and expense accounts, multi-currency accounts seem to be a total disaster. Why? Because all PAST transactions on both income and expense accounts will be valued at the CURRENT exchange rates. Consider an extreme example which illustrates the problem drastically: Imagine you dined at a restaurant in Argentina in January 2018. You paid 250 ARS in cash, which equaled about 11 EUR at the time. If you had recorded this on an expense account denominated in ARS and you looked at your GnuCash book today, it would show you that you spent only 0.88 EUR for that meal in 2018. The peso lost almost all of its value since then. Your data in GnuCash will be almost worthless. GnuCash does record the difference between 11 and 0.88 EUR in your trading accounts as a loss of value of "your" ARS 250 (that you don't have any more because you spent them in 2018), but for all transactions that have been recorded in the ARS expense account, it will only show just the total loss you have had over the years in ARS vs EUR. If there were many transactions, you would have no idea what you really paid in your base currency at the time of each transaction. Trading accounts are meant to track changes in value of assets and liabilities you are currently holding, but most definitely not for expenses and income from the past, which has already happened and cannot be changed anymore. Therefore, my current conclusion is that for all transaction that involve income or expense accounts, the amount has to be converted into the base currency using the exchange rate on the day the transaction occurred, or at least closely. Exchange rates normally do not move a lot from day to day, but over many months or even years there can be huge moves - and those will ruin the data in your GnuCash book if you don't consider this effect. If somebody has another solution, please let me know, as the extra effort to make the conversion for each transaction is obviously anything but fun. Best regards, Patrick Poendl Am Mi., 19. Okt. 2022 um 02:47 Uhr schrieb : > > -- Forwarded message -- > From: Anton Tsyganenko > To: gnucash-user@gnucash.org > Cc: > Bcc: > Date: Tue, 18 Oct 2022 13:34:13 +0400 > Subject: [GNC] Enhancement request: multi-currency accounts > Let's take a look on accounts that are created in gnucash by default. > Generally most of the accounts may be multi-currency, i. e. not bond to > a specific currency: you may have cash in multiple currencies, your > opening balances may be in multiple currencies, you may have incomes and > expenses in multiple currencies. Bank accounts generally have only one > currency, but there are some banks that offer multi-currency cards and > deposits. These surely can be considered as just a few different > accounts, but it may be more convenient to group them together.Now I > solve that by creating sub-accounts for each currency I need for each > account where I need it. It looks like: > Expenses:Dining:USD > Expenses:Dining:EUR > Expenses:Dining:CAD > Expenses:Transport:USD > Expenses:Transport:EUR > Expenses:Transport:CAD > > It's very painful to create all of them. I know that I may have only one > account in my _main_ currency, but I prefer all currencies to be equal > and not perform redundant currency conversions, for example when I spend > CAD cash for dining in Canada. > > So my proposal is: > > All accounts that user creates are "multi-currency", like placeholder > accounts without any specific currency. Sub-accounts for each currency > are created automatically, when the first operation in this currency in > this account is made. If a multi-currency account is deleted and > operations are moved to another account, operations in all the > subaccounts are moved to the corresponding subaccounts of the second > account. Balances can be shown as a sum of (non-null) amounts in > different currencies (but sometimes can be converted to one currency). > In a multi-currency account's view (basic ledger) there should be just > an additional column -- currency of an operation (editable as a > drop-down menu). So user opens account "cash" and sees something like: > > Date | Description | Transfer | Debit | Credit | Currency | Balance > > 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR | 100 > USD + 55 EUR > > That operation is a transfer of 25 EUR from Assets:Cash:EUR to > Expenses:Dining:EUR.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
The oldest release still on SourceForge is 2.2.0 and it includes a Windows setup.exe; the oldest unstable release is 2.3.0 and it does not, but all from 2.3.2 do have a setup.exe. The first commit to gnucash-on-windows was on 25 August 2006, not quite a year before, and the first announcement of a setup.exe being available is for 2.1.1 on 28 April 2007. Regards, John Ralls > On Oct 20, 2022, at 1:00 AM, Maf. King wrote: > > Just an observation, from the depths of history... > > IIRC, 2.3.x I think was a development series; unstable and for bug testing > and > so on, and for "expert" users only (ie not me) > > it feels to me that having that running on win11 is unlikely, I'm not even > sure that 2.3 release were for windows - if they were available then they > would have been some of the very first releases of GC on winXP. > > I am pretty sure that if 2.3.4 was installed by the OP, then the GC database > would be in XML not SQL and so the usually auto-created backup files should > have been made and might be lurking in a corner of a hard disk? > > HTH, > Maf. > > > > On Thursday, 20 October 2022 06:52:54 BST Adrien Monteleone wrote: >> Unlikely, but you might get lucky. (You really don't have *any* backup >> at all? Really? You've been using a decades old version of GnuCash and >> you never make backups?) >> >> Note, the GnuCash file, by default unless you changed it, is a >> compressed XML file. Uncompressed, it is just plain text and human >> readable. (albeit in a markup language) How the file is arranged has >> changed over the years, but the raw data should still be there. >> >> As for 'developing a problem afterwards' it could be that GnuCash is >> proceeding with data migration in the background, but it may have gotten >> hung up on something, or it is just really taking a long time. >> >> As David noted, running from the command line, or getting a Trace File >> might shed some light as to what is going on. >> >> You *might* get lucky by removing 4.12, going back to 2.3.4, then >> proceeding as I outlined, *but* be darned sure to MAKE A COPY of your >> file before doing so! >> >> Honestly, I'd go the route David suggested first to get some output and >> then report back here what you get. >> >> Also, what do you mean by 'blank screen'? Can you take a screenshot and >> attach it in a reply? (do not paste in-line, it needs to be attached) >> >> Maybe do that FIRST, and then once we see what you see, we can advise >> further. >> >> Regards, >> Adrien >> >> On 10/19/22 10:13 PM, Rosepetals wrote: >>> I don’t have a backup of the 2.3.4 database. Is there a way to recover >>> data >>> from the current 4.12 database? >>> >>> Also why does Gnucash work fine after the database upgrade but then >>> develop >>> a fault afterwards? >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
By 'backup' we don't mean something you do within GnuCash, we mean something you do with your entire computer/personal files. If you never make backups of any of your files, or only rarely, then I guess you're stuck rebuilding data if you can't recover this file. (this would be the case with ANY app, or hard drive failure, lightning strike, fire, flood, etc.) The Wiki *well* advises how to upgrade properly, and that includes making sure you have a copy/backup of your file. I haven't checked the GnuCash Manual, but I'd be surprised if it doesn't advise the same. Thanks for the screenshots. Once you get some feedback from the command line and a trace file, maybe we'll see things aren't a disaster. Note, if you have log files dating all the way back to your last known good copy that works with 2.3.4 again, you can 'replay' those logs using 2.3.4 to rebuild the file, then make a copy (!!) and proceed with the incremental upgrade. (making copies at each step!) Regards, Adrien On 10/20/22 6:02 AM, Rosepetals wrote: I may have a backup from 2 years ago on version 2.3.4 but of course that would mean I wouldn’t have the recent 2 years of transactions. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 235, Issue 46
On 10/20/2022 12:21 PM, Patrick Pöndl wrote: I am a new GnuCash user and currently busy setting everything up. I have done a lot of thinking and testing on the multi-currency issue in order to hopefully get it right from the start. So far my conclusion is this - and please, more experienced users, correct me if there is a flaw in my thinking: - For asset and liability accounts, multi-currency accounts make obviously a lot of sense if you hold assets and liabilities denominated in multiple currencies. Changes in value in respect to your base currency are perfectly taken care of by using the automatic trading accounts. - BUT: For income and expense accounts, multi-currency accounts seem to be a total disaster. Why? Because all PAST transactions on both income and expense accounts will be valued at the CURRENT exchange rates. THAT is the major issue with trying to keep multiple currencies in the same set of books. WHEN is to be the time of evaluation (of one to the other in terms of exchange rates). This can even be an issue for accounts of type asset and liability for those who are rarely moving amounts between currencies << who have accounts in both places, who have income and expenses in both places --- say who live/work in one country part of the year and in another the rest of the year >> Since not applying to me, I have never investigated the rules of the various jurisdictions. You have income in country B but your primary tax country is A. What does A say about when "conversion" takes place (when evaluated for income in B, taxes paid in B for which A might give credit, etc.) OR if A allows you to choose the date (say the end of the reporting year) how do you do that unless separate books? << since you would NOT want evaluations to have been taking place as you went along >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] gnucash-user Digest, Vol 235, Issue 46
>* - BUT: For income and expense accounts, multi-currency accounts seem to be *>* a total disaster. Why? Because all PAST transactions on both income and *>* expense accounts will be valued at the CURRENT exchange rates.* Simply recording value in local currency works for me. You can add a note/memo with original currency if required but I don't bother now. If conversion happens at a different date then a transaction is required for that date. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
I thought Gnucash by default kept backups of the database file. On Thu, Oct 20, 2022 at 4:28 AM Rosepetals wrote: > Hi, > > The location of the database file has a number of log files in it if that > helps. > > Thanks for responding. > > On Thu, 20 Oct 2022 at 7:01 pm, Maf. King wrote: > > > Just an observation, from the depths of history... > > > > IIRC, 2.3.x I think was a development series; unstable and for bug > testing > > and > > so on, and for "expert" users only (ie not me) > > > > it feels to me that having that running on win11 is unlikely, I'm not > even > > sure that 2.3 release were for windows - if they were available then they > > would have been some of the very first releases of GC on winXP. > > > > I am pretty sure that if 2.3.4 was installed by the OP, then the GC > > database > > would be in XML not SQL and so the usually auto-created backup files > > should > > have been made and might be lurking in a corner of a hard disk? > > > > HTH, > > Maf. > > > > > > > > On Thursday, 20 October 2022 06:52:54 BST Adrien Monteleone wrote: > > > Unlikely, but you might get lucky. (You really don't have *any* backup > > > at all? Really? You've been using a decades old version of GnuCash and > > > you never make backups?) > > > > > > Note, the GnuCash file, by default unless you changed it, is a > > > compressed XML file. Uncompressed, it is just plain text and human > > > readable. (albeit in a markup language) How the file is arranged has > > > changed over the years, but the raw data should still be there. > > > > > > As for 'developing a problem afterwards' it could be that GnuCash is > > > proceeding with data migration in the background, but it may have > gotten > > > hung up on something, or it is just really taking a long time. > > > > > > As David noted, running from the command line, or getting a Trace File > > > might shed some light as to what is going on. > > > > > > You *might* get lucky by removing 4.12, going back to 2.3.4, then > > > proceeding as I outlined, *but* be darned sure to MAKE A COPY of your > > > file before doing so! > > > > > > Honestly, I'd go the route David suggested first to get some output and > > > then report back here what you get. > > > > > > Also, what do you mean by 'blank screen'? Can you take a screenshot and > > > attach it in a reply? (do not paste in-line, it needs to be attached) > > > > > > Maybe do that FIRST, and then once we see what you see, we can advise > > > further. > > > > > > Regards, > > > Adrien > > > > > > On 10/19/22 10:13 PM, Rosepetals wrote: > > > > I don’t have a backup of the 2.3.4 database. Is there a way to > recover > > > > data > > > > from the current 4.12 database? > > > > > > > > Also why does Gnucash work fine after the database upgrade but then > > > > develop > > > > a fault afterwards? > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > - > > > 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 > > - > > 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Valuation of multi-currency accounts
Just a reminder to all ... PLEASE don't use non-descriptive subject lines of the form GnuCash-user Digest Vol XXX Issue XX. If a newbie does it, please change the subject line to something more helpful when replying. Thanks! Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2022-10-20 15:29, flywire wrote: >> * - BUT: For income and expense accounts, multi-currency accounts seem to be > *>* a total disaster. Why? Because all PAST transactions on both income and > *>* expense accounts will be valued at the CURRENT exchange rates.* > > > Simply recording value in local currency works for me. You can add a > note/memo with original currency if required but I don't bother now. > If conversion happens at a different date then a transaction is > required for that date. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.
You can turn it off. Some may have and forgot. And I'm not sure when that was added. It may not have been available for 2.3.4. That version was never intended to be used regularly. It was a development/testing version only. Though such a file or files might be in the OPs data directory, we'll have to wait and see. Regards, Adrien On 10/20/22 5:57 PM, R Losey wrote: I thought Gnucash by default kept backups of the database file. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement request: multi-currency accounts
Hello, Patrick, welcome to GnuCash! On 2022-10-20 09:28, Patrick Pöndl wrote: ... - BUT: For income and expense accounts, multi-currency accounts seem to be a total disaster. Why? Because all PAST transactions on both income and expense accounts will be valued at the CURRENT exchange rates I think you are misunderstanding the original proposal. Look below in the thread, to what Anton Tsyganenko wrote: On 2022-10-18 02:34, Anton Tsyganenko wrote: ...All accounts that user creates are "multi-currency", like placeholder accounts without any specific currency. Sub-accounts for each currency are created automatically, when the first operation in this currency in this account is made Thus, the "multi-currency" part is a placeholder. Transactions are not recorded in the placeholder, they are recorded in "sub-accounts for each currency". Once they are recorded in that currency, they are valued in that currency. Relationship to other currencies is established by means of trading accounts, which GnuCash already supports. As I read it, Anton is just proposing that GnuCash do automatically what I do manually. I have transactions denominated in CAD, USD, EUR, and various stocks and funds in my book today. What is the base-currency value of a book with transactions denominated in various currencies? That is a separate question to the proposal for "multi-currency accounts". It is already an issue for books like mine. For some GnuCash users, accounting regulations will determine how they calculate base-currency value. For others, it can be whatever meets the information needs of the user. ...Therefore, my current conclusion is that for all transaction that involve income or expense accounts, the amount has to be converted into the base currency using the exchange rate on the day the transaction occurred, or at least closely OK, that is one way to deal with transactions in multiple currencies. It is not what I am required to do for tracking capital gains in US stocks when I report to Canadian authorities, or Canadian stocks when I report to US authorities. Or, are you saying that GnuCash should only allow me to record transactions in my base currency, not in any foreign currency? That would be a big inconvenience for my usage. Best regards, —Jim DeLaHunt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement request: multi-currency accounts
Whatever works for you is fine. I would find that strange. I have income and expenses in two currencies pretty much all the time. I live in one country and still have property in another. I keep track of everything in the currency that it occurred in. Conversions occur if I am traveling in a third country and have an expense is some other currency. Then it gets converted to one of the primary two currencies depending on which bank card I used. I have debit cards in both currencies. The other time something gets converted is if I move money from a bank in one country to a bank in the other. Then one side of the transaction will obviously be in one currency and the other side in the other, But keeping all my expense accounts in one currency sounds crazy to me. I keep them in whichever currency they were paid with. My 2 cents, and worth what you paid for it. Will On 2022 Oct 20, at 10-20 11:28:34, Patrick Pöndl wrote: I am a new GnuCash user and currently busy setting everything up. I have done a lot of thinking and testing on the multi-currency issue in order to hopefully get it right from the start. [...] income or expense accounts, the amount has to be converted into the base currency using the exchange rate on the day the transaction occurred, or at least closely. Exchange rates normally do not move a lot from day to day, but over many months or even years there can be huge moves - and those will ruin the data in your GnuCash book if you don't consider this effect. If somebody has another solution, please let me know, as the extra effort to make the conversion for each transaction is obviously anything but fun. Best regards, Patrick Poendl Am Mi., 19. Okt. 2022 um 02:47 Uhr schrieb : > > -- Forwarded message -- > From: Anton Tsyganenko > To: gnucash-user@gnucash.org > Cc: > Bcc: > Date: Tue, 18 Oct 2022 13:34:13 +0400 > Subject: [GNC] Enhancement request: multi-currency accounts > Let's take a look on accounts that are created in gnucash by default. > Generally most of the accounts may be multi-currency, i. e. not bond to > a specific currency: you may have cash in multiple currencies, your > opening balances may be in multiple currencies, you may have incomes and > expenses in multiple currencies. Bank accounts generally have only one > currency, but there are some banks that offer multi-currency cards and > deposits. These surely can be considered as just a few different > accounts, but it may be more convenient to group them together.Now I > solve that by creating sub-accounts for each currency I need for each > account where I need it. It looks like: > Expenses:Dining:USD > Expenses:Dining:EUR > Expenses:Dining:CAD > Expenses:Transport:USD > Expenses:Transport:EUR > Expenses:Transport:CAD > > It's very painful to create all of them. I know that I may have only one > account in my _main_ currency, but I prefer all currencies to be equal > and not perform redundant currency conversions, for example when I spend > CAD cash for dining in Canada. > > So my proposal is: > > All accounts that user creates are "multi-currency", like placeholder > accounts without any specific currency. Sub-accounts for each currency > are created automatically, when the first operation in this currency in > this account is made. If a multi-currency account is deleted and > operations are moved to another account, operations in all the > subaccounts are moved to the corresponding subaccounts of the second > account. Balances can be shown as a sum of (non-null) amounts in > different currencies (but sometimes can be converted to one currency). > In a multi-currency account's view (basic ledger) there should be just > an additional column -- currency of an operation (editable as a > drop-down menu). So user opens account "cash" and sees something like: > > Date | Description | Transfer | Debit | Credit | Currency | Balance > > 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR | 100 > USD + 55 EUR > > That operation is a transfer of 25 EUR from Assets:Cash:EUR to > Expenses:Dining:EUR. > > I would be happy to discuss the concept. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 1:33 AM, Geoff wrote:
I doubt if this has change since last you asked, these are your choices:
https://wiki.gnucash.org/wiki/FAQ#SQL_Database
SQLite claims to be very reliable:
https://www.sqlite.org/hirely.html
An easy solution to dodgy power is a cheap laptop - put a battery
between yourself and the grid.
Good luck
Geoff
=
On 14/10/2022 5:24 pm, Jeff wrote:
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which
just happened to have images attached to GNC transactions. Bad luck
on my part, they also happened to be my backup drives. Murphy is
after all the patron saint of all physicists. Everything that can go
wrong will go wrong. I am currently adding 2 more backup drives plus
a third working drive (all 6 TB, right now, I expect all of them to
be filled with my next project in the next 2 weeks, although 6 gigs
will be devoted specifically to GNC).
Is there any way, even the slightest, to attach a transaction image
to a daemon instead of a specific file? That way I could use a
database system in the background to hold images instead of the file
system. That way images would still be available to GNC and
searchable for me (never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit
boards (i need battery backup here but right now I cannot afford a
large enough system with voltage spike protection) and my electric
company is well known for feeding large voltage spikes here since I
have the best grounding system for miles and I am the last drop on
their power line. 60 volts on the neutral is a common experience.
It's a wonder that I still have at least one computer that works.
Sorry, the SQL interface does not work with my main set of books. 30+
years worth of transactions and the SQL conversion locks up. 6 years no
problem.
Dirty power or not, this system worked without a hitch on a 10kw
generator that was, pardon my language, noisier than hell, spikes, lows
were not uncommon.
Somewhere there is a glitch with GNC and the SQL backend. And I am the
butt of that problem.
--
--JEffrey Black M.B.A.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 7:10 AM, Murugan Muruganandam wrote:
Jeff
this may not be the direct answer, nevertheless i use the cloud
storage for my GNU files and it works like a charm(and economical).
Apart from crashes, it allows me to connect from different computers
and work.
Again not an answer to your question, thought will share.
Saludos Cordiales
Murugan
*From:* gnucash-user
on
behalf of Jeff
*Sent:* Friday, October 14, 2022 3:24 AM
*To:* Gnucash userlist
*Subject:* [GNC] transaction images and failed hard drives
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which just
happened to have images attached to GNC transactions. Bad luck on my
part, they also happened to be my backup drives. Murphy is after all the
patron saint of all physicists. Everything that can go wrong will go
wrong. I am currently adding 2 more backup drives plus a third working
drive (all 6 TB, right now, I expect all of them to be filled with my
next project in the next 2 weeks, although 6 gigs will be devoted
specifically to GNC).
Is there any way, even the slightest, to attach a transaction image to a
daemon instead of a specific file? That way I could use a database
system in the background to hold images instead of the file system.
That way images would still be available to GNC and searchable for me
(never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit boards
(i need battery backup here but right now I cannot afford a large enough
system with voltage spike protection) and my electric company is well
known for feeding large voltage spikes here since I have the best
grounding system for miles and I am the last drop on their power line.
60 volts on the neutral is a common experience. It's a wonder that I
still have at least one computer that works.
--
--JEffrey Black M.B.A.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Appreciate the answer but; I do not trust cloud images. Too many
possible snoopers. Everything you send over the web is public, keyed or
not.
For security reasons I need to keep all data local and not just GNC.
All private data is kept on a system that is not accessible via the web,
no internet period.
--
--JEffrey Black M.B.A.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 12:14 PM, john wrote:
On Oct 13, 2022, at 11:24 PM, Jeff wrote:
Is there any way, even the slightest, to attach a transaction image
to a daemon instead of a specific file? That way I could use a
database system in the background to hold images instead of the file
system. That way images would still be available to GNC and
searchable for me (never know when a rebate might show up {grin}).
There's https://github.com/MigNov/Fuse-db that uses mysql-connector
(should also work with mariadb's connector) to create a filesystem
interface. There's also a perl module,
https://metacpan.org/pod/Fuse::DBI, that (like GnuCash) uses libdbi
so it's a bit more general; the problem is that it's only mountable
from inside perl so it won't work directly with GnuCash.
Alternatively the link field takes URIs as well as directory paths and
IIRC it can load http: or https: URIs. If you can run a local web
server to serve the URIs you can use PHP to query a supported database
for the desired image.
Regards,
John Ralls
Thank you John, I'll look into it. That might be the only suggestion
for now. I would rather have a program standing next to GNC to look at
images, from any location that GNC can access regardless of location.
--
--JEffrey Black M.B.A.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
