Re: [GNC] Removing Orphan components from transaction
Peter, You [re]discovered a quirk of GnuCash that it is possible to leave a transaction having an uncommitted pending edit, then edit the 'home' split line from a different account of the same transaction by deleting the 'home' account. GnuCash then automagically commits the edit and it disappears from view in that account. If the complete transaction disappeared rather than only the 'home' split line, I would consider that a true bug which should be reported. For the part about the 'home' split line disappearing, It would be an uphill battle to get this quirk fixed because some users consider that a feature rather than a bug. I have submitted a couple of enhancement bug reports without seeing any action. I personally try to discipline myself to always jump to a different account register to edit and never edit the account field in the 'home' split line of a transaction, but sometimes I slip up. As for finding lost pending edits, I try tricks like hitting the tab key to see if there is one in the current account register, or trying to save the file to see if a warning appears about an uncommitted edit in another account register. A complication to this is that the automagic backup can work without triggering the warning about uncommitted edits, which will then leave the Save button greyed out when there is still an uncommitted edit. Further, if there is an uncommitted edit in a special register such as the general ledger, a search result or 'with child' register, it gets harder to figure out exactly which register tab is the culprit. I'd better get off the soap box. David Carlson On Sun, Nov 17, 2019 at 11:19 PM Peter West wrote: > I found a transaction in Orphan-AUD. It was a split, and the Orphan > component was zero. Maybe I had forgotten part of the split, and then > corrected it, leaving nothing in the Orphan-AUD account. > > I wanted to remove this transaction from Orphan-AUD. As I recall, I tried > to remove the Orphan line from the copy of the transaction under the > Orphan-AUD tab. Uh-uh. Something about the anchoring to another account. > > So I went to the parent account (an asset account) of the split, and tried > to delete the null Orphan-AUD line. That seemed to work. > > Back to the Orphan-AUD tab, delete this transaction as a whole. Presto! > All gone. > > Bad mistake. Deleting transaction was good to its word, and deleted the > whole transaction. I lost the only references I had to the original > transaction (from August). > > What is the correct method? > > Peter > > > -- > Peter West > p...@pbw.id.au > But he cried out all the more, “Son of David, have mercy on me!” > > ___ > 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. > -- David Carlson ___ 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] Removing Orphan components from transaction
Peter If you open the Asset register in auto split register ( View->Autosplit register), select the transaction and then right click on the split to the Orphan AUD account you will get a popup menu one of the entries of which is Delete Split. If the split to Orphan AUD was the only split other than the split to the Asset account you may need to provide a target account for the second split of the transaction. There is no need to repeat the process of deleting the split in the Orphan AUD account after deleting it from the Asset register. GnuCash creates the splits to the Orphan AUD account whenever you create an unbalanced transaction i.e. one in which the sum of the debit and credit entries is not equal to zero. the difference between Orphan and Imbalance accouts is explained in this thread http://gnucash.1415818.n4.nabble.com/ORPHAN-vs-IMBALANCE-td4675769.html David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Locked out of gnucash
Is there a simple way to reword the warning to say that a lock file is present thus some instance of GnuCash has either abandoned it or is not finished working with the data. If you are sure that it was *not* opened by another user or still opened by yourself on another screen or computer click 'Open Anyway'. Otherwise click one of the other options." David Carlson On Sun, Nov 17, 2019 at 9:57 PM John Ralls wrote: > Except that the file was closed immediately after completing the session > load. GnuCash will rename it and write a new one if you have made changes > to the book in memory and tell it to save those changes or let it > auto-save, but you can certainly close the session and so delete the lock > file without saving. > > It really is about the lock file, not the data file. > > Regards, > John Ralls > > > > On Nov 17, 2019, at 4:24 PM, David Carlson > wrote: > > > > A comment about Stan Brown's suggestion. > > > > I think a better and more accurate wording would be "The data file has > not > > been cleanly closed since it was last opened. If you are sure that it > was > > not opened by another user, click 'Open Anyway'. Otherwise click one of > > the other options." > > > > To me the important part is that the data file has not been cleanly > closed, > > which is the real reason that the lock file exists. There may be better > > words to use as long as this idea is incorporated. > > > > David Carlson > > > > On Sun, Nov 17, 2019 at 4:35 PM Frank H. Ellenberger < > > frank.h.ellenber...@gmail.com> wrote: > > > >> Hello Stan et al. > >> > >> I like the idea. A short grep delivers 5 occurrences of likewise texts: > 4 > >> at > >> > >> > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 > >> and one further below: > >> > >> > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 > >> I am not totally sure if the change can be applied on aloof them. > >> > >> BTW. Splitting the first 4 strings like the last would reduce the > >> burden for our translators. > >> > >> Regards > >> Frank > >> > >> Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown > >> : > >>> > >>> In the two years I've been reading this list, I think the single most > >>> common question has been about this "could not obtain the lock" > message. > >>> Seems like someone asks about it at least once a week. > >>> > >>> The text "that database may be in use by another user," while literally > >>> true, isn't helpful because it points to a less common case and gives > no > >>> guidance for the more common case. It's like hearing hoofbeats and > >>> hypothesizing "zebra" instead of "horse". > >>> > >>> I suggest that improving the message would be a huge boon to less > >>> experienced GC users, and very little effort for the developers. > >>> > >>> Why not replace the present text > >>> > >>>That database may be in use by another user, in which case you > >>>should not open the database. What would you like to do? > >>> > >>> with this: > >>> > >>>If your previous session crashed, select Open Anyway. If this is > >>>a shared database, wait for other users to finish using it or > >>>select Open Read-Only. For more information, see (link to sec > >>>2.5.3 of Tutorial). > >>> > >>> "What would you like to do?" can be omitted, in my opinion. Seeing > >>> buttons, users will know that they need to pick one. What they _do_ > need > >>> is text that is relevant to their situation. > >>> > >>> (I question the tutorial's advice to delete the lock files manually. > >>> David Cousens reports: > My experience on Linux is that when you select Open > Anyway, the previous .LNK and .LCK files will be deleted and new ones > created which should then be deleted when GNucash is closed properly. > >>> The same happens for me in Windows. Is there any OS where this > desirable > >>> behavior doesn't happen? If there is, the tutorial's advice should > >>> mention those specific systems, or at least it should say that in > >>> Windows and Linux GC will do this automatically when you reopen a data > >>> file after the "could not obtain the lock" message.) > >>> > >>> -- > >>> Regards, > >>> Stan Brown > >>> Tompkins County, New York, USA > >>> https://BrownMath.com > >>> http://OakRoadSystems.com > >>> > >>> > >>> On 2019-11-16 20:27, David Cousens wrote: > Kay > > If GnuCash is not closed properly,e.g. a crash the .LNK and .LCK files > created in your data directory prevent you from opening GnuCash. > >> Section > 2.5.3 of the Tutorial guide covers them. > > .LCK file extensions. My experience on Linux is that when you select > >> Open > Anyway, the previous .LNK and .LCK files will be deleted and new ones > created which should then be deleted when GNucash is closed properly. > >>> __
[GNC] Removing Orphan components from transaction
I found a transaction in Orphan-AUD. It was a split, and the Orphan component was zero. Maybe I had forgotten part of the split, and then corrected it, leaving nothing in the Orphan-AUD account. I wanted to remove this transaction from Orphan-AUD. As I recall, I tried to remove the Orphan line from the copy of the transaction under the Orphan-AUD tab. Uh-uh. Something about the anchoring to another account. So I went to the parent account (an asset account) of the split, and tried to delete the null Orphan-AUD line. That seemed to work. Back to the Orphan-AUD tab, delete this transaction as a whole. Presto! All gone. Bad mistake. Deleting transaction was good to its word, and deleted the whole transaction. I lost the only references I had to the original transaction (from August). What is the correct method? Peter -- Peter West p...@pbw.id.au But he cried out all the more, “Son of David, have mercy on me!” ___ 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] Archiving transactions
Hi, I should clarify that when I mean transactions I am referring to double entries. Each business transaction, from the e-commerce stuff I do, outputs on average five double entries: one each for sales, commissions, shipping, coupons and so on. So 500k double entries would yield around 100k actual business transactions over 3 or so years. The software is not slow to the point of being non-functional or a even frustration. It is only that I prefer a tad bit more sprightliness. Also it seems to run perfectly well on my relatively slower laptop which just has 6GB of RAM. Noted about the loading of transactions to memory. I will keep a closer eye on the memory footprint. Unfortunately my programming experience is limited to VBA on MS Excel. I have sadly not worked with apps, and with databases only very little. I am not sure how I could contribute to the development over someone with actual database experience. Thanks, Rizwan On Mon, Nov 18, 2019, 11:21 AM D wrote: > Rizwan, > > I am intrigued. You say you're a new user, but you have 500,000 > transactions. Wow! > > You've been getting the usual kinds of responses to your question: how > fast is your computer, how many reports are you running, be patient, don't > close Gnucash, etc. > > But it sounds as if you're pushing boundaries that most of us > personal/small business users aren't. For example, my data file loads and > runs pretty well. It covers over ten years of transactions, and the last > time I checked, it was around 200,000 transactions all told. It may be that > you are an outlier user who tests the functional limits of Gnucash. > > One major issue that has long been known is that the software is not built > to think like a database app. It loads the entire data file into memory on > start up. It does this even with the SQL back ends, which is a roundabout > way to tell you that changing to a database back end won't help at this > time, sadly. > > I see that you had another query about transaction imports that suggests > that you have some programming experience. Many of us would cheer if you > were to put that experience to work helping the small development team. One > really big area they are looking at is the migration of Gnucash to a true > db app--a long term goal, to be sure, since there are so many immediate > issues that need to be addressed. > > Cheers, > David T. > > On November 18, 2019, at 8:17 AM, David Carlson < > david.carlson@gmail.com> wrote: > > There is a setting under Edit > Preferences > General to compress the data > file. I think it is selected by default. In Windows 10 compression > happens very fast so that is not likely to be an issue with speed. > > However, because the entire database is [theoretically] in RAM, at some > point that will cause RAM to spill over into swap space on the local > drive. Then things really slow down. This will happen more quickly if a > web browser is running concurrently. In Windows open the Task Manager and > look under performance to see how your machine is doing. > > David Carlson > > On Sun, Nov 17, 2019 at 8:14 PM M. Rizwan Muzzammil > wrote: > > > I will check. Thanks for the suggestion. > > > > On Mon, Nov 18, 2019, 10:06 AM Greg Feneis wrote: > > > > > It seems like there used to be an option to encrypt, or zip the working > > > file when it's the default xml type. If that's still an option, and is > > > enabled, it could cause a delay relative to the file size > > > > > > Kind regards, Greg Feneis > > > (Pixel 3) > > > > > > > > > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil > > > wrote: > > > > > > > Thanks for your replyI am using the default file types. Does it > > make > > > a > > > > difference if I change? > > > > If so to what other type and how can it be done? > > > > > > > > > > > > > > > > > > > ___ > > > 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. > > > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: >
Re: [GNC] Locked out of gnucash
Except that the file was closed immediately after completing the session load. GnuCash will rename it and write a new one if you have made changes to the book in memory and tell it to save those changes or let it auto-save, but you can certainly close the session and so delete the lock file without saving. It really is about the lock file, not the data file. Regards, John Ralls > On Nov 17, 2019, at 4:24 PM, David Carlson > wrote: > > A comment about Stan Brown's suggestion. > > I think a better and more accurate wording would be "The data file has not > been cleanly closed since it was last opened. If you are sure that it was > not opened by another user, click 'Open Anyway'. Otherwise click one of > the other options." > > To me the important part is that the data file has not been cleanly closed, > which is the real reason that the lock file exists. There may be better > words to use as long as this idea is incorporated. > > David Carlson > > On Sun, Nov 17, 2019 at 4:35 PM Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> Hello Stan et al. >> >> I like the idea. A short grep delivers 5 occurrences of likewise texts: 4 >> at >> >> https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 >> and one further below: >> >> https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 >> I am not totally sure if the change can be applied on aloof them. >> >> BTW. Splitting the first 4 strings like the last would reduce the >> burden for our translators. >> >> Regards >> Frank >> >> Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown >> : >>> >>> In the two years I've been reading this list, I think the single most >>> common question has been about this "could not obtain the lock" message. >>> Seems like someone asks about it at least once a week. >>> >>> The text "that database may be in use by another user," while literally >>> true, isn't helpful because it points to a less common case and gives no >>> guidance for the more common case. It's like hearing hoofbeats and >>> hypothesizing "zebra" instead of "horse". >>> >>> I suggest that improving the message would be a huge boon to less >>> experienced GC users, and very little effort for the developers. >>> >>> Why not replace the present text >>> >>>That database may be in use by another user, in which case you >>>should not open the database. What would you like to do? >>> >>> with this: >>> >>>If your previous session crashed, select Open Anyway. If this is >>>a shared database, wait for other users to finish using it or >>>select Open Read-Only. For more information, see (link to sec >>>2.5.3 of Tutorial). >>> >>> "What would you like to do?" can be omitted, in my opinion. Seeing >>> buttons, users will know that they need to pick one. What they _do_ need >>> is text that is relevant to their situation. >>> >>> (I question the tutorial's advice to delete the lock files manually. >>> David Cousens reports: My experience on Linux is that when you select Open Anyway, the previous .LNK and .LCK files will be deleted and new ones created which should then be deleted when GNucash is closed properly. >>> The same happens for me in Windows. Is there any OS where this desirable >>> behavior doesn't happen? If there is, the tutorial's advice should >>> mention those specific systems, or at least it should say that in >>> Windows and Linux GC will do this automatically when you reopen a data >>> file after the "could not obtain the lock" message.) >>> >>> -- >>> Regards, >>> Stan Brown >>> Tompkins County, New York, USA >>> https://BrownMath.com >>> http://OakRoadSystems.com >>> >>> >>> On 2019-11-16 20:27, David Cousens wrote: Kay If GnuCash is not closed properly,e.g. a crash the .LNK and .LCK files created in your data directory prevent you from opening GnuCash. >> Section 2.5.3 of the Tutorial guide covers them. .LCK file extensions. My experience on Linux is that when you select >> Open Anyway, the previous .LNK and .LCK files will be deleted and new ones created which should then be deleted when GNucash is closed properly. >>> ___ >>> 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
Re: [GNC] Archiving transactions
Rizwan, I am intrigued. You say you're a new user, but you have 500,000 transactions. Wow! You've been getting the usual kinds of responses to your question: how fast is your computer, how many reports are you running, be patient, don't close Gnucash, etc. But it sounds as if you're pushing boundaries that most of us personal/small business users aren't. For example, my data file loads and runs pretty well. It covers over ten years of transactions, and the last time I checked, it was around 200,000 transactions all told. It may be that you are an outlier user who tests the functional limits of Gnucash. One major issue that has long been known is that the software is not built to think like a database app. It loads the entire data file into memory on start up. It does this even with the SQL back ends, which is a roundabout way to tell you that changing to a database back end won't help at this time, sadly. I see that you had another query about transaction imports that suggests that you have some programming experience. Many of us would cheer if you were to put that experience to work helping the small development team. One really big area they are looking at is the migration of Gnucash to a true db app--a long term goal, to be sure, since there are so many immediate issues that need to be addressed. Cheers, David T. On November 18, 2019, at 8:17 AM, David Carlson wrote: There is a setting under Edit > Preferences > General to compress the data file. I think it is selected by default. In Windows 10 compression happens very fast so that is not likely to be an issue with speed. However, because the entire database is [theoretically] in RAM, at some point that will cause RAM to spill over into swap space on the local drive. Then things really slow down. This will happen more quickly if a web browser is running concurrently. In Windows open the Task Manager and look under performance to see how your machine is doing. David Carlson On Sun, Nov 17, 2019 at 8:14 PM M. Rizwan Muzzammil wrote: > I will check. Thanks for the suggestion. > > On Mon, Nov 18, 2019, 10:06 AM Greg Feneis wrote: > > > It seems like there used to be an option to encrypt, or zip the working > > file when it's the default xml type. If that's still an option, and is > > enabled, it could cause a delay relative to the file size > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil > > wrote: > > > > > Thanks for your replyI am using the default file types. Does it > make > > a > > > difference if I change? > > > If so to what other type and how can it be done? > > > > > > > > > > > > > > ___ > > 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. > -- David Carlson ___ 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] Locked out of gnucash
Am Mo., 18. Nov. 2019 um 01:24 Uhr schrieb David Carlson : : There are a few other reasons, where I already have run in: > "The data file has not been cleanly closed since it was last opened. If you > are sure that it was not opened by another user, click 'Open Anyway'. > Otherwise click one of the other options." ... by another user or yourself, probably on another screen or computer, ... > To me the important part is that the data file has not been cleanly closed, > which is the real reason that the lock file exists. There may be better > words to use as long as this idea is incorporated. > > David Carlson ___ 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] Archiving transactions
There is a setting under Edit > Preferences > General to compress the data file. I think it is selected by default. In Windows 10 compression happens very fast so that is not likely to be an issue with speed. However, because the entire database is [theoretically] in RAM, at some point that will cause RAM to spill over into swap space on the local drive. Then things really slow down. This will happen more quickly if a web browser is running concurrently. In Windows open the Task Manager and look under performance to see how your machine is doing. David Carlson On Sun, Nov 17, 2019 at 8:14 PM M. Rizwan Muzzammil wrote: > I will check. Thanks for the suggestion. > > On Mon, Nov 18, 2019, 10:06 AM Greg Feneis wrote: > > > It seems like there used to be an option to encrypt, or zip the working > > file when it's the default xml type. If that's still an option, and is > > enabled, it could cause a delay relative to the file size > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil > > wrote: > > > > > Thanks for your replyI am using the default file types. Does it > make > > a > > > difference if I change? > > > If so to what other type and how can it be done? > > > > > > > > > > > > > > ___ > > 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. > -- David Carlson ___ 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.
[GNC] Creating profiles for mapped accounts
Hello all, I am using the import transactions feature to import sales data into gnucash. This works brilliantly. If you do it once then gnucash recognizes the same account descriptions with subsequent imports and automatically remaps correctly. Currently I have two sources of sales data (e-commerce stuff), one which I import more frequently and one less. Both data sets have similar account descriptions but they are not identical, for example one might say 'coupon US' and the other 'coupon UK'. My problem is that gnucash makes errors in remapping when I switch. Sometimes the US transaction gets mistaken for a UK transaction. I have to go through the multiple accounts affected and adjust manually. I am guessing this is because the account descriptions are MOSTLY similar, and gnucash chooses a partial match even though a full match may also be present. I do not know why it does this. So my question is, is there a way I can explicitly switch mapped accounts for the data type (US or UK) using profiles, rather than let gnucash guess for me? If not then i guess a possible remedy is prepping my data better before import. I use Excel VBA to organize the data correctly, but perhaps modifying the description by adding some sort of prefix is a potential method. Appreciate any advice. Rizwan ___ 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] Archiving transactions
I will check. Thanks for the suggestion. On Mon, Nov 18, 2019, 10:06 AM Greg Feneis wrote: > It seems like there used to be an option to encrypt, or zip the working > file when it's the default xml type. If that's still an option, and is > enabled, it could cause a delay relative to the file size > > Kind regards, Greg Feneis > (Pixel 3) > > > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil > wrote: > > > Thanks for your replyI am using the default file types. Does it make > a > > difference if I change? > > If so to what other type and how can it be done? > > > > > > > > > ___ > 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] Archiving transactions
It seems like there used to be an option to encrypt, or zip the working file when it's the default xml type. If that's still an option, and is enabled, it could cause a delay relative to the file size Kind regards, Greg Feneis (Pixel 3) On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil wrote: > Thanks for your replyI am using the default file types. Does it make a > difference if I change? > If so to what other type and how can it be done? > > > > ___ 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] Archiving transactions
Thanks for your reply. I do not believe it is a hardware issue as this is a new PC. I am running gnucash on Win10 and reading from a, relatively slowish but still very quick, local NVMe SSD. I am using the default file types. Does it make a difference if I change? If so to what other type and how can it be done? On Sun, Nov 17, 2019, 5:11 AM Colin Law wrote: > On Sat, 16 Nov 2019 at 18:14, M. Rizwan Muzzammil > wrote: > > ... > > My accounts have a large number of transactions in them. > > > > This seems to slow the program down, and it take a minute or so to open > it > > each time. > > How large is your accounts file (I assume that you are using the > default xml file storage rather than sqlite or mysql)? > What processor are you running on, if you know that. Otherwise what > make/model PC is it? Also what operating system? > Is the file stored on a disc on the PC or on a network drive? > > Colin > ___ 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] Archiving transactions
Thanks for your reply. I don't usually keep reports open so I do not believe it is a reason. Also I recall on an occasion where a report tab, that was kept open, took time to reload on activating the tab. So i assume that time was saved on opening. Will check later today. Slowness is perhaps due to transaction volume. I don't have an exact count but I guess it is near to the 500,000 mark. I was mainly searching for an automatic method to truncate. If there is none I guess I will have to do it manually as you suggest. On Sun, Nov 17, 2019, 5:17 AM David Carlson wrote: > Slowness to open and to save and close, and even to commit any transaction > edit has been a known problem for some time now. Releases after about 3.4 > or so are supposed to be much improved, but there may still be slowness if > there are a lot of account tabs to open or reports to recreate. There was > also an issue if the account windows were rather large, if I recall > correctly. GnuCash may still seem slow in release 3.7, but I have not > tried it personally yet, so I have no personal experience. > > That said, it is possible to truncate history out of a file, but the > process is not automated and requires a combination of opening a new file > with the same account structure then manually setting all the opening > balances and importing the data that you want to keep from exports from the > old file. > > If you only have a few thousand transactions it is easier to fine tune > your work method to minimize the lags. > > On Sat, Nov 16, 2019 at 12:14 PM M. Rizwan Muzzammil > wrote: > >> Hi all, >> >> New user of GNU cash here. >> >> My accounts have a large number of transactions in them. >> >> This seems to slow the program down, and it take a minute or so to open it >> each time. >> >> Would there be a way to archive older previous year transactions so that >> the program runs faster? >> >> Thanks very much in advance for any help. >> >> Rizwan >> ___ >> 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. >> > > > -- > David Carlson > ___ 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] Locked out of gnucash
A comment about Stan Brown's suggestion. I think a better and more accurate wording would be "The data file has not been cleanly closed since it was last opened. If you are sure that it was not opened by another user, click 'Open Anyway'. Otherwise click one of the other options." To me the important part is that the data file has not been cleanly closed, which is the real reason that the lock file exists. There may be better words to use as long as this idea is incorporated. David Carlson On Sun, Nov 17, 2019 at 4:35 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Hello Stan et al. > > I like the idea. A short grep delivers 5 occurrences of likewise texts: 4 > at > > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 > and one further below: > > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 > I am not totally sure if the change can be applied on aloof them. > > BTW. Splitting the first 4 strings like the last would reduce the > burden for our translators. > > Regards > Frank > > Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown > : > > > > In the two years I've been reading this list, I think the single most > > common question has been about this "could not obtain the lock" message. > > Seems like someone asks about it at least once a week. > > > > The text "that database may be in use by another user," while literally > > true, isn't helpful because it points to a less common case and gives no > > guidance for the more common case. It's like hearing hoofbeats and > > hypothesizing "zebra" instead of "horse". > > > > I suggest that improving the message would be a huge boon to less > > experienced GC users, and very little effort for the developers. > > > > Why not replace the present text > > > > That database may be in use by another user, in which case you > > should not open the database. What would you like to do? > > > > with this: > > > > If your previous session crashed, select Open Anyway. If this is > > a shared database, wait for other users to finish using it or > > select Open Read-Only. For more information, see (link to sec > > 2.5.3 of Tutorial). > > > > "What would you like to do?" can be omitted, in my opinion. Seeing > > buttons, users will know that they need to pick one. What they _do_ need > > is text that is relevant to their situation. > > > > (I question the tutorial's advice to delete the lock files manually. > > David Cousens reports: > > > My experience on Linux is that when you select Open > > > Anyway, the previous .LNK and .LCK files will be deleted and new ones > > > created which should then be deleted when GNucash is closed properly. > > The same happens for me in Windows. Is there any OS where this desirable > > behavior doesn't happen? If there is, the tutorial's advice should > > mention those specific systems, or at least it should say that in > > Windows and Linux GC will do this automatically when you reopen a data > > file after the "could not obtain the lock" message.) > > > > -- > > Regards, > > Stan Brown > > Tompkins County, New York, USA > > https://BrownMath.com > > http://OakRoadSystems.com > > > > > > On 2019-11-16 20:27, David Cousens wrote: > > > Kay > > > > > > If GnuCash is not closed properly,e.g. a crash the .LNK and .LCK files > > > created in your data directory prevent you from opening GnuCash. > Section > > > 2.5.3 of the Tutorial guide covers them. > > > > > > .LCK file extensions. My experience on Linux is that when you select > Open > > > Anyway, the previous .LNK and .LCK files will be deleted and new ones > > > created which should then be deleted when GNucash is closed properly. > > ___ > > 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. > -- David Carlson ___ 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
Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable
Thanks David, Bruce and Adrien, Using account numbers in the name field is great. I can sort on the numbers and get my accounts to look the same as in Simply Accounting. Adrien's tip about the edit/options/display feature in income accounts allows me to get exactly what I had before. It just requires a placeholder subheading account and point all the sub-accounts to that one. Rick On 2019-11-17 2:31 p.m., Adrien Monteleone wrote: If you mean you want to roll up the sub-accounts into the parent, then go to Options > Display > Parent account balances: and set it to “Subtotal” instead of “Account Balance” Note, you should also not have any transactions in that parent account and set it to being a placeholder. If you don’t want to use the parents as placeholders you also have the option right below it: ‘Parent account subtotals:’ set it to “Show subtotals” You can do this with the options window to the side of the report and it will toggle on and off the report in real time so you can refine how you want the report to look/work. Regards, Adrien On Nov 16, 2019 w46d320, at 7:13 PM, Richard Danielson wrote: Hello David, Thanks for the tip on the arrow on the right side of the accounts window. I tapped that once but didn't notice that it was offering me a whole bunch of information options. I now have account numbers showing and can sort on that column to make things look more or less the same as in Simply Accounting. Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, snacks and restaurants in the food category) which showed up in income accounts. That is what I can't figure out in GC. I can make accounts sub-accounts for heading accounts, and get the totals for the sub-accounts to show in the income statement, but can't get the program to sum the sub-accounts into the heading accounts. Rick ___ 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] Locked out of gnucash
Hello Stan et al. I like the idea. A short grep delivers 5 occurrences of likewise texts: 4 at https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 and one further below: https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 I am not totally sure if the change can be applied on aloof them. BTW. Splitting the first 4 strings like the last would reduce the burden for our translators. Regards Frank Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown : > > In the two years I've been reading this list, I think the single most > common question has been about this "could not obtain the lock" message. > Seems like someone asks about it at least once a week. > > The text "that database may be in use by another user," while literally > true, isn't helpful because it points to a less common case and gives no > guidance for the more common case. It's like hearing hoofbeats and > hypothesizing "zebra" instead of "horse". > > I suggest that improving the message would be a huge boon to less > experienced GC users, and very little effort for the developers. > > Why not replace the present text > > That database may be in use by another user, in which case you > should not open the database. What would you like to do? > > with this: > > If your previous session crashed, select Open Anyway. If this is > a shared database, wait for other users to finish using it or > select Open Read-Only. For more information, see (link to sec > 2.5.3 of Tutorial). > > "What would you like to do?" can be omitted, in my opinion. Seeing > buttons, users will know that they need to pick one. What they _do_ need > is text that is relevant to their situation. > > (I question the tutorial's advice to delete the lock files manually. > David Cousens reports: > > My experience on Linux is that when you select Open > > Anyway, the previous .LNK and .LCK files will be deleted and new ones > > created which should then be deleted when GNucash is closed properly. > The same happens for me in Windows. Is there any OS where this desirable > behavior doesn't happen? If there is, the tutorial's advice should > mention those specific systems, or at least it should say that in > Windows and Linux GC will do this automatically when you reopen a data > file after the "could not obtain the lock" message.) > > -- > Regards, > Stan Brown > Tompkins County, New York, USA > https://BrownMath.com > http://OakRoadSystems.com > > > On 2019-11-16 20:27, David Cousens wrote: > > Kay > > > > If GnuCash is not closed properly,e.g. a crash the .LNK and .LCK files > > created in your data directory prevent you from opening GnuCash. Section > > 2.5.3 of the Tutorial guide covers them. > > > > .LCK file extensions. My experience on Linux is that when you select Open > > Anyway, the previous .LNK and .LCK files will be deleted and new ones > > created which should then be deleted when GNucash is closed properly. > ___ > 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
On 11/16/2019 9:29 PM, David Carlson wrote: I searched the help for information on account codes but all I found was: https://www.gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=help I thought there used to be a lot more information than that. I know that you can use account codes in the account fields when editing transactions instead of the tedious full tree account names. Unfortunately, you cannot make the account drop-down-list show the account code numbers, you have to 'just know' them. I didn't find a reference to that. Well you can (sort of). In addition to using the account number in THAT field, duplicate the number as part of the name of the account. 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 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
If you mean you want to roll up the sub-accounts into the parent, then go to Options > Display > Parent account balances: and set it to “Subtotal” instead of “Account Balance” Note, you should also not have any transactions in that parent account and set it to being a placeholder. If you don’t want to use the parents as placeholders you also have the option right below it: ‘Parent account subtotals:’ set it to “Show subtotals” You can do this with the options window to the side of the report and it will toggle on and off the report in real time so you can refine how you want the report to look/work. Regards, Adrien > On Nov 16, 2019 w46d320, at 7:13 PM, Richard Danielson > wrote: > > Hello David, > Thanks for the tip on the arrow on the right side of the accounts window. I > tapped that once but didn't notice that it was offering me a whole bunch of > information options. I now have account numbers showing and can sort on that > column to make things look more or less the same as in Simply Accounting. > > Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, > snacks and restaurants in the food category) which showed up in income > accounts. That is what I can't figure out in GC. I can make accounts > sub-accounts for heading accounts, and get the totals for the sub-accounts to > show in the income statement, but can't get the program to sum the > sub-accounts into the heading accounts. > > Rick ___ 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] Archiving transactions
Also note that leaving report tabs open when closing GnuCash will slow it down opening back up as each of those reports is loaded once again. (same goes for all tabs) If your workflow can handle it, either close all tabs except the Accounts tab before exiting, or, don’t close GnuCash unless you really need to. (I leave it open 24/7 and only restart when updating) Regards, Adrien > On Nov 16, 2019 w46d320, at 12:03 PM, M. Rizwan Muzzammil > wrote: > > Hi all, > > New user of GNU cash here. > > My accounts have a large number of transactions in them. > > This seems to slow the program down, and it take a minute or so to open it > each time. > > Would there be a way to archive older previous year transactions so that > the program runs faster? > > Thanks very much in advance for any help. > > Rizwan ___ 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] [noob inside] Swiss account numbers
Hello Nicolas Michel, If you start the program as LANG=de_CH LANGUAGE=fr_ch gnucash (assuming you are french speaking) and inside go through File->New you will see the template chkmu with the description "Kontenrahmen fuer Schweizer KMU gem Walher Sterchi publiziert vom schweizerischen Gewerbeverband". Until now no user has sent us the french, italian or romansh translation of it. If you are interested, see https://wiki.gnucash.org/wiki/Translation#How_to_translate_the_files_containing_the_new_account_hierarchies Regards Frank Am So., 17. Nov. 2019 um 01:25 Uhr schrieb namichel : > > Hi all > Sorry, I'm a noob on accounting. > Previously, for an other task, I used banana who use numbers like this: > https://www.banana.ch/apps/fr/node/8017 > > So cash is 1000, bank is 1010, selling 3200, stock 4200, etc ... > > Now I would like to start accounting with GnuCash who seam nice but I'm > lost, I don't find account numbers. Are theses numbers only for Swiss > accounting ? Is there any template for switzerland ? > > Thanks ! > > Nicolas > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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.
[GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable
David: >I thought there used to be a lot more information than that. I know that you can use account codes in the account fields when editing transactions instead of the tedious full tree account names. Unfortunately, you cannot make the account drop-down-list show the account code numbers, you have to 'just know' them. I didn't find a reference to that.< Having learned accounting "BC" (Before Computer), I needed to keep account numbers. My solution in GC is to prefix the Acct Name with the number as well as in the Code field, ie: 101 Cash on hand. This way, I only have to type 101 to select that account (or 610.1 to select fuel). If you want subtotals, in reports at least, make them sub-accounts of a placeholder:610. Auto Expense 610.1 fuel 610.2 lube 610.3 repairsNote that I put a '.' after 610 to remind myself it is a place holderOn reports this will look like Expenses610. Auto Expense (optional) 1168 610.1 fuel 123 610.2 lube 45 610.3 repairs 1000 (optional) Auto Expense 1168 The options are in Edit/Report Options/Display Bruce ___ 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] Locked out of gnucash
On 16 November 2019 at 19:17, Kay Robinson said: > Hi > > Whilst gnucash was minimised on my toolbar I had a short power outage. > When I re-booted the system I couldn't open my accounts because 'another > user was using them' I chose to open anyway, but couldn't save a change I > made. What do you mean by "couldn't save"? What happened when you tried? - "Save" greyed-out on the "File" menu? - Error message when you ran "save"? - No error indication but file not updated? - ??? ___ 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] gnucash 3.7.1 does not start on Macos 10.13.6
thank you all, first of all i tried this: http://macappstore.org/guile/ it didnt worked, and the github link is too complicated for me.. So i downloaded 2.6 and works fine :) On Sun, Nov 17, 2019 at 7:00 AM John Ralls wrote: > That's not GnuCash 3.7, it's a Gtk2 version. Not only that but it seems to > have Guile 1.7, which would put it into the 2.4 series -- except that I > never used Guile 1.7: > > https://github.com/Gnucash/gnucash-on-osx/commit/1e63de2b73189b38060068f030ca7977c9967394 > shows upgrading from Guile-1.6 to Guile 1.8.8. > > The crash is due to a libpng mismatch in MacOS 10.13 and later, and was > fixed somewhere in the middle of the 2.6 series. If you don't want to > upgrade to 3.x 2.6.21 should work. > > Regards, > John Ralls > > > On Nov 16, 2019, at 3:27 PM, George Michalopoulos > wrote: > > > > first part of the log file in console: > > > > Process: Gnucash-bin [22377] > > Path: /Applications/Gnucash.app/Contents/MacOS/Gnucash > > Identifier:org.gnucash.Gnucash > > Version: ??? > > Code Type: X86 (Native) > > Parent Process:??? [1] > > Responsible: Gnucash-bin [22377] > > User ID: 502 > > > > Date/Time: 2019-11-07 17:35:57.554 +0200 > > OS Version:Mac OS X 10.13.6 (17G7024) > > Report Version:12 > > Anonymous UUID:0362B72E-BF2A-9A23-9582-53F3EF0AAEA5 > > > > > > Time Awake Since Boot: 48 seconds > > > > System Integrity Protection: enabled > > > > Crashed Thread:0 > > > > Exception Type:EXC_CRASH (SIGABRT) > > Exception Codes: 0x, 0x > > Exception Note:EXC_CORPSE_NOTIFY > > > > Termination Reason:DYLD, [0x4] Symbol missing > > > > Application Specific Information: > > dyld: launch, loading dependent libraries > > DYLD_FRAMEWORK_PATH=/Applications/Gnucash.app/Contents/Frameworks > > > DYLD_LIBRARY_PATH=/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash::/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/:/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash > > > > Dyld Error Message: > > Symbol not found: _inflateValidate > > Referenced from: > /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib > > Expected in: > /Applications/Gnucash.app/Contents/Resources/lib/libz.1.dylib > > in > /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib > > > > On Sat, Nov 16, 2019 at 5:09 PM John Ralls wrote: > > "Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind > handler." Indicates that Guile's stack has run out of space. That might be > a locale problem, what happens if you set the computer language to Greek so > that it matches your region settings? > > > > Are there any crash reports (open /Applications/Utilities/Console and > select User Reports in the sidebar and look in the list for reports > beginning with Gnucash)? > > > > Is anything written to the trace file ( > https://wiki.gnucash.org/wiki/Tracefile)? > > > > > > > > > On Nov 16, 2019, at 6:40 AM, George Michalopoulos > wrote: > > > > > > i had to run it 1,5-2 years.. > > > > > > should i try an older version ? > > > > > > > > > On Sat, Nov 16, 2019 at 4:23 PM David Carlson < > david.carlson@gmail.com> > > > wrote: > > > > > >> Release 3.7.1 has only been around for several. Weeks. Is this the > first > > >> time for you to start Gnucash after updating? > > >> > > >> If so, which version did you have before? > > >> > > >> David Carlson > > >> > > >> On Sat, Nov 16, 2019, 6:58 AM George Michalopoulos > > > >> wrote: > > >> > > >>> i made all the things you say, no good.. > > >>> > > >>> This is what i see on terminal.. > > >>> > > >>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash > > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.538: > > >>> [mac_find_close_country()] Apple Locale is set to a value en_GR not > > >>> supported by the C runtime > > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.539: > > >>> [mac_find_close_country()] Using el_GR instead. > > >>> (process:1839): gnc.gui-WARNING **: 14:52:58.540: > [mac_set_languages()] > > >>> Language list: en:el:en:C > > >>> (process:1839): Gtk-WARNING **: 14:52:58.541: Locale not supported > by C > > >>> library. > > >>> Using the fallback 'C' locale. > > >>> Warning: Unwind-only `stack-overflow' exception; skipping pre-unwind > > >>> handler. > > >>> > > >>> > > >>> On Sat, Nov 16, 2019 at 2:49 PM Adrien Monteleone < > > >>> adrien.montele...@lusfiber.net> wrote: > > >>> > > If you’re getting the GnuCash splash screen then it is starting, but > > >>> then > > either being hidden, or crashing. > > > > I’ll presume: > > > > > > That you’ve checked *all* worksp
