Re: [GNC] File not found, file in history
Thanks! I think the panic of losing years of Dara blinded me to the simple idea that that was just a blank and not some imagined lost key to a proprietary file structure or something. Then down a rabbit hole trying to get Mailman installed just to get some help. Thanks for all the help! Sorry for replying to one, not list! > On Jun 7, 2019, at 9:24 PM, Greg Feneis wrote: > > Please remember to send replies to the list, not just the members you are > replying to. > > Macs aren't my strength here, but every time you start GnuCash, if GnuCash > starts with a message saying it can't find a file, then once you get past > the screen that asks you if you want to remove it from the recent file > list, what you have is GnuCash running with a default empty file. I > wouldn't bother saving that. Instead, click the file menu and select open, > then point to the file you usually use. You may have to find that file, > using the Mac's file manager, then use GnuCash file>open to get to where > the file is and open it. > > Kind regards, Greg Feneis > (Galaxy S7) > > >> On Fri, Jun 7, 2019, 18:41 Giuseppe Quinn wrote: >> >> I’m running MacOS 10.14.5 >> >> In the attached screenshot you can see the msg I’m getting. Originally, >> the file name was empty >> >> >> >> If “No” or “Yes” is selected the following window opens. >> >> >> >> Nothing I tried changed anything, till I selected save and it asked for a >> name, and that’s how “WHatisthis” became the “missing” file from the first >> image. I have plenty of these files; >> >> >> Which are the ones I want to open, and I’ve tried opening GNUCash by >> clicking various versions of these. >> >> HELP!!! >> >> On Jun 7, 2019, at 9:03 AM, Greg Feneis wrote: >> >> You could also use your computer's file manager, EG Windows Explorer, to >> find the file that GnuCash can't seem to find. >> >> Kind regards, Greg Feneis >> (Galaxy S7) >> >> >> On Fri, Jun 7, 2019, 07:59 Greg Feneis wrote: >> >> You may have changed the file's location and GnuCash can no longer find >> it. Try using the file>open menu items to navigate to the file location and >> open it. After GnuCash opens it up,it will remember the new location and >> open it automatically the next time you start it >> >> Kind regards, Greg Feneis >> (Pixel 3) >> >> >> On Fri, Jun 7, 2019, 07:34 Centins@rq wrote: >> >> When I try to open GnuCash 3.4 I get an error msg saying a file can’t be >> found, but that the file is in history and do I want to remove it. When I >> click either the “Yes”, or “No” a window opens with nothing in it and a >> “Save” and some other button. >> >> Help! I can’t open any of my data! >> ___ >> 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. >> >> >> > > > > ___ > 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] File not found, file in history
Anytime you open GnuCash and it can’t open your data file it will open a ‘blank’ file because it has to have something open. That is what the Giuseppe is seeing. Giuseppe, Your best bet is to follow previous advice. Open GnuCash. Disregard any messages and pay no notice to a blank file. Click the File menu and choose the Open option. Navigate to where your file is stored, and select it. Then GnuCash will remember it after close and will re-open that last used file next time. Until and unless you get this far, I don’t know we can help much more. If you have zero idea where your data file is stored, then we can help somewhat in that regard, just let us know that is the problem. Regards, Adrien > On Jun 7, 2019, at 10:24 PM, Greg Feneis wrote: > > Please remember to send replies to the list, not just the members you are > replying to. > > Macs aren't my strength here, but every time you start GnuCash, if GnuCash > starts with a message saying it can't find a file, then once you get past > the screen that asks you if you want to remove it from the recent file > list, what you have is GnuCash running with a default empty file. I > wouldn't bother saving that. Instead, click the file menu and select open, > then point to the file you usually use. You may have to find that file, > using the Mac's file manager, then use GnuCash file>open to get to where > the file is and open it. > > Kind regards, Greg Feneis > (Galaxy S7) > > > On Fri, Jun 7, 2019, 18:41 Giuseppe Quinn wrote: > >> I’m running MacOS 10.14.5 >> >> In the attached screenshot you can see the msg I’m getting. Originally, >> the file name was empty >> >> >> >> If “No” or “Yes” is selected the following window opens. >> >> >> >> Nothing I tried changed anything, till I selected save and it asked for a >> name, and that’s how “WHatisthis” became the “missing” file from the first >> image. I have plenty of these files; >> >> >> Which are the ones I want to open, and I’ve tried opening GNUCash by >> clicking various versions of these. >> >> HELP!!! >> >> On Jun 7, 2019, at 9:03 AM, Greg Feneis wrote: >> >> You could also use your computer's file manager, EG Windows Explorer, to >> find the file that GnuCash can't seem to find. >> >> Kind regards, Greg Feneis >> (Galaxy S7) >> >> >> On Fri, Jun 7, 2019, 07:59 Greg Feneis wrote: >> >> You may have changed the file's location and GnuCash can no longer find >> it. Try using the file>open menu items to navigate to the file location and >> open it. After GnuCash opens it up,it will remember the new location and >> open it automatically the next time you start it >> >> Kind regards, Greg Feneis >> (Pixel 3) >> >> >> On Fri, Jun 7, 2019, 07:34 Centins@rq wrote: >> >> When I try to open GnuCash 3.4 I get an error msg saying a file can’t be >> found, but that the file is in history and do I want to remove it. When I >> click either the “Yes”, or “No” a window opens with nothing in it and a >> “Save” and some other button. >> >> Help! I can’t open any of my data! ___ 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] Pending Edit Behavior in GnuCash
I figured as much, but suggested it anyway at least as a temporary workaround. I do see the utility of an edit-only tab. Regards, Adrien > On Jun 7, 2019, at 8:37 PM, David Carlson wrote: > > Returning to Adrien's comment on my Edit window Suggestion: > > >> Finally, I will throw out a radical suggestion that all edits get their own > >> new window instead of happening within a certain register view with a > >> certain "anchor" account which has special behavior compared to other split > >> lines. This Edit window would not be tied to any account and would be > >> obviously not saved as long as it exists. > >> > > This already exists as the ‘General Journal’ (Tools menu) It’s your choice > > to use it. Though it is not implemented for only the currently edited > > transactions, but the entirety of your data file. > > > > My reasoning for suggesting a dedicated edit window for each transaction edit > is to serve a completely different purpose than that served by the General > Journal, but it may share some code in an implementation. If each > transaction edit was in it's own dedicated window, they would all be very > easy to find and commit or cancel at a later time. Then the possible > ambiguity of having some pending edits in search windows or the General > Ledger would also be avoided. There may be a better coding technique to > implement this, especially in SQL, so I do not want to be so specific to > prevent the developers from thinking creatively in an implementation. > > > 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] Pending Edit Behavior in GnuCash
Returning to Adrien's comment on my Edit window Suggestion: >> Finally, I will throw out a radical suggestion that all edits get their own >> new window instead of happening within a certain register view with a >> certain "anchor" account which has special behavior compared to other split >> lines. This Edit window would not be tied to any account and would be >> obviously not saved as long as it exists. >> > This already exists as the ‘General Journal’ (Tools menu) It’s your choice to use it. Though it is not implemented for only the currently edited transactions, but the entirety of your data file. > My reasoning for suggesting a dedicated edit window for each transaction edit is to serve a completely different purpose than that served by the General Journal, but it may share some code in an implementation. If each transaction edit was in it's own dedicated window, they would all be very easy to find and commit or cancel at a later time. Then the possible ambiguity of having some pending edits in search windows or the General Ledger would also be avoided. There may be a better coding technique to implement this, especially in SQL, so I do not want to be so specific to prevent the developers from thinking creatively in an implementation. > 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. > -- 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] Export files for audit
On 6/7/2019 9:54 AM, Mike stagl wrote: This is end of my first year as Treasurer of a PTA, and my first year using gnucash. What is the best way to export or print a year's worth of gnucash data for an auditor to review? What is the auditor asking for? Is the auditor willing to install gnucash (in which case you could send the FILE which is the books and the auditor could look at whatever). 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] QIF import fails in GnuCash 3.5, win 7
Thank you David I did find the trace file. I was looking at the wrong place. The file is attached. Message: 3 Date: Wed, 5 Jun 2019 15:20:06 -0500 From: David Carlson To: Tom Hatzigeorgiou Cc: "gnucash-user@gnucash.org" Subject: Re: [GNC] QIF import fails in GnuCash 3.5, win 7 Message-ID: Content-Type: text/plain; charset="UTF-8" Tom, There is always at least a rudimentary trace file. Read < https://wiki.gnucash.org/wiki/Tracefile> On Wed, Jun 5, 2019 at 3:12 PM Tom Hatzigeorgiou wrote: > there is no trace file generated > The import fails on the second step (importing the QIF file). The first > being checking the transfers. > > By the way I'm able to use my data as I install GNU version 3.1 import the > data then install version 3.5 and use the data. > Is just that the importing fails otherwise I find version 3.5 better and > faster than the previous one. > > Hopefully they will fix the importing function with the next release. gnucash.trace.SZN62Z.log Description: gnucash.trace.SZN62Z.log ___ 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] Export files for audit
I say, “Ask the Auditor” but otherwise, check out the Transaction Report. It is probably the most detailed available. There are also the General Journal and General Ledger Reports. Regards, Adrien > On Jun 7, 2019, at 8:54 AM, Mike stagl wrote: > > This is end of my first year as Treasurer of a PTA, and my first year > using gnucash. > > What is the best way to export or print a year's worth of gnucash data > for an auditor to review? > > I notice the export functions do not include running balance > information. What data does an auditor usually need and what format > would be best? Any tips? > > Thanks to all the contributors, > > Mike ___ 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] Additions to price database not being displayed
> On Jun 7, 2019, at 8:31 AM, Colin Law via gnucash-user > wrote: > > On Fri, 7 Jun 2019 at 14:40, David Lynch via gnucash-user > wrote: >> >> I recently upgraded from 3.3 to 3.5 on Windows 10. >> >> I add prices to the share price database Tools->Price Database->FUND, >> then click on a line then Add. >> >> When I click OK in the Add dialog, the price added is not displayed. It >> is there, however: it shows if I close the share prices, open another >> share, close that and reopen the original share. >> >> All worked as expected in 3.3. Am I doing something wrong? > > I believe it is a bug, I am seeing that too. I don't know whether it > has been reported. Getting windows to redraw after a data update seems to have changed with a recent upgrade to Gtk in the Windows builds. Bob Fewell has fixed some of them, please try the latest nightly from https://code.gnucash.org/builds/win32/maint to see if this has been fixed already. If not, please file a bug. Regards, John Ralls ___ 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] Pending Edit Behavior in GnuCash
Making sure all registers have you in the next blank transaction before exiting should also do the trick. Or close them all before saving/exiting. Then if you try to close a register that is being edited, you’ll fire the warning right away and know which one it is. (just a workflow ‘workaround’ mind you, some visual indicator or text in the warning would be nice) Regards, Adrien > On Jun 7, 2019, at 4:40 AM, David Carlson wrote: > >> >> >> Does this mean that it is still possible in a SQLite database to start a > transaction edit, then, without committing it, navigate to another account > register and edit another transaction? If so, when does the first > transaction edit finally get committed? The difficulty with finding those > un-committed edits in the XML data version is the reason for my 'blinking' > proposal. > > The method that I currently use is to start a manual File > Save, then, if > there is a pop-up indicating a need to save or cancel an edit, try to guess > which tab I need to look under for the offending edit, When I think I have > the right tab, press the Tab key to see if I am in the un-committed > transaction. If the warning re-appears, I am there. If not, maybe it is > in another tab, perhaps a search tab. This is hardly efficient. > > It would also be helpful if any transaction edit action somehow changed the > appearance of that transaction so that the need to commit is more obvious. > > -- > 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] Pending Edit Behavior in GnuCash
Interesting it is even there. Since there are no amounts and it looks like a dupe, then —delete it? Do the two referenced accounts also show it in their respective registers? Regards, Adrien > On Jun 7, 2019, at 4:36 AM, jeffrey black wrote: > >> > > Thanks. Found it under View->Filter by. > > But; it is giving me the same annoying entry I am getting under other > views as well. There is one extra transaction that is a partial > duplicate of the last real transaction. It has the same date as the > previous valid transaction, no description, has the same funds in > account, no funds out account, and no dollar amounts on either line (not > zero, blank). Gnu-Cash is waiting for me to enter a new transaction > after this one. > > -- > --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 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] Additions to price database not being displayed
On Fri, 7 Jun 2019 at 14:40, David Lynch via gnucash-user wrote: > > I recently upgraded from 3.3 to 3.5 on Windows 10. > > I add prices to the share price database Tools->Price Database->FUND, > then click on a line then Add. > > When I click OK in the Add dialog, the price added is not displayed. It > is there, however: it shows if I close the share prices, open another > share, close that and reopen the original share. > > All worked as expected in 3.3. Am I doing something wrong? I believe it is a bug, I am seeing that too. I don't know whether it has been reported. 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] File not found, file in history
We need more information. What is your OS? Is GnuCash still running from before? What are your exact keystrokes and results, including warning texts and button names? David Carlson On Fri, Jun 7, 2019 at 9:33 AM Centins@rq wrote: > When I try to open GnuCash 3.4 I get an error msg saying a file can’t be > found, but that the file is in history and do I want to remove it. When I > click either the “Yes”, or “No” a window opens with nothing in it and a > “Save” and some other button. > > Help! I can’t open any of my data! > ___ > 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] File not found, file in history
You may have changed the file's location and GnuCash can no longer find it. Try using the file>open menu items to navigate to the file location and open it. After GnuCash opens it up,it will remember the new location and open it automatically the next time you start it Kind regards, Greg Feneis (Pixel 3) On Fri, Jun 7, 2019, 07:34 Centins@rq wrote: > When I try to open GnuCash 3.4 I get an error msg saying a file can’t be > found, but that the file is in history and do I want to remove it. When I > click either the “Yes”, or “No” a window opens with nothing in it and a > “Save” and some other button. > > Help! I can’t open any of my data! > ___ > 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] File not found, file in history
When I try to open GnuCash 3.4 I get an error msg saying a file can’t be found, but that the file is in history and do I want to remove it. When I click either the “Yes”, or “No” a window opens with nothing in it and a “Save” and some other button. Help! I can’t open any of my data! ___ 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] Export files for audit
This is end of my first year as Treasurer of a PTA, and my first year using gnucash. What is the best way to export or print a year's worth of gnucash data for an auditor to review? I notice the export functions do not include running balance information. What data does an auditor usually need and what format would be best? Any tips? Thanks to all the contributors, Mike ___ 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] Additions to price database not being displayed
I recently upgraded from 3.3 to 3.5 on Windows 10. I add prices to the share price database Tools->Price Database->FUND, then click on a line then Add. When I click OK in the Add dialog, the price added is not displayed. It is there, however: it shows if I close the share prices, open another share, close that and reopen the original share. All worked as expected in 3.3. Am I doing something wrong? David Lynch ___ 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] QFX/OFX import issue from American Express
Were those transactions previously imported, or at least seen in a previous import file? OFX/QFX checks the file for duplicates and refuses to import the same transactions again. If they were seen but later lost, or changed because of an error, it is a challenge to re-import them. David Carlson On Fri, Jun 7, 2019 at 4:15 AM jeffrey black wrote: > Has anyone besides me run into an issue with the QFX file import from > American Express? I tried downloading and importing, one statements > worth of transactions at a time (just as I have successfully done in the > past), and the import window showed no transactions. When I look at the > QFX file it has multiple transactions in it. > > I have not yet looked at the file(s) in detail yet to see if I can spot > a change in format. > > This is under Windoze 10 and Gnu-Cash version 3.5. > > -- > --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 > 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] Pending Edit Behavior in GnuCash
On Thu, Jun 6, 2019 at 6:25 PM John Ralls wrote: > > > > On Jun 6, 2019, at 1:21 PM, Colin Law wrote: > > > > On Thu, 6 Jun 2019 at 19:04, Adrien Monteleone > > wrote: > >> > >> > >>> On Jun 6, 2019, at 12:40 PM, David Carlson < > david.carlson@gmail.com> wrote: > >>> > >>> Adrien, > >>> > >>> Looking at your comments, I have two questions. > >>> > >>> 1. Does SQLite not allow pending edits at all? or is it after every > keystroke? How do you avoid accidental deletions? > >> > >> Not sure specifically what you mean by ‘pending edits'. I think writes > are supposed to be instant, but I haven’t tested exactly how ‘instant’ —as > by keystroke, Tab, or Enter as a commit. I don’t know that I’ve > accidentally deleted something critical, certainly not an entire > transaction. I might have inadvertently changed an account assignment to > something I didn’t want, or selected an entire memo and deleted it when I > only wanted to delete a portion of it, but that is an easy fix, especially > as I’ll notice it immediately. (I wish CMD-Z ‘undo’ worked though - since > it doesn’t, perhaps writes are by keystroke?) As long as the app is still > open, I just make any changes I need. I’m not prevented from doing so. (I > also keep the app open 24/7 and only close to do an update of GC itself, or > the OS) > > > > I believe the transaction is not saved until you hit that last Enter > > key to do it. There is, after all, a Cancel button at the top that > > allows one to revert the transaction being edited back to what it was > > originally. > > Mostly right: Committing the edit immediately generates a database update. > If it's editing an object with a dialog box (including transactions with > the Transfer Dialog) then clicking the OK button commits. For transactions > in the register, it's hitting Enter, tabbing off the end, or clicking on a > different transaction and then confirming the edit in the message box. > > Does this mean that it is still possible in a SQLite database to start a transaction edit, then, without committing it, navigate to another account register and edit another transaction? If so, when does the first transaction edit finally get committed? The difficulty with finding those un-committed edits in the XML data version is the reason for my 'blinking' proposal. The method that I currently use is to start a manual File > Save, then, if there is a pop-up indicating a need to save or cancel an edit, try to guess which tab I need to look under for the offending edit, When I think I have the right tab, press the Tab key to see if I am in the un-committed transaction. If the warning re-appears, I am there. If not, maybe it is in another tab, perhaps a search tab. This is hardly efficient. It would also be helpful if any transaction edit action somehow changed the appearance of that transaction so that the need to commit is more obvious. > Regards, > John Ralls > > ___ > 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] Pending Edit Behavior in GnuCash
On 6/7/2019 4:06 AM, Adrien Monteleone wrote: > >> On Jun 7, 2019, at 3:57 AM, jeffrey black wrote: >> >> I think I missed something here Adrien. I only get a /months worth /of >> transactions in a tab across some but not all accounts which have >> entries. What am I not setting right in preferences? (Windoze 10 => >> Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) >> >> -- >> --JEffrey Black M.B.A. > Check Edit > Filter By... > > The General Journal defaults to a 30 day window if I’m not mistaken. (mine > was set as such) Unfortunately, I don’t think there is a preference to set > this. You have to change it each time you open it. > > Be sure to check the other Filter tab as well to make sure you are seeing all > transactions you want to see. (personally, I’d think the Journal should show > everything, but that’s just me) > > My understanding is that one or the other (individual account registers, or > General Journal) is ‘virtual’ while the other is how the data is actually > stored. Traditional accounting would use the Journal first, but I seem to > recall reading that GnuCash does this in reverse. > > Regards, > Adrien > ___ > 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. Thanks. Found it under View->Filter by. But; it is giving me the same annoying entry I am getting under other views as well. There is one extra transaction that is a partial duplicate of the last real transaction. It has the same date as the previous valid transaction, no description, has the same funds in account, no funds out account, and no dollar amounts on either line (not zero, blank). Gnu-Cash is waiting for me to enter a new transaction after this one. -- --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 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] Pending Edit Behavior in GnuCash
Op vrijdag 7 juni 2019 11:06:28 CEST schreef Adrien Monteleone: > > On Jun 7, 2019, at 3:57 AM, jeffrey black > > wrote: > > > > > > I think I missed something here Adrien. I only get a /months worth /of > > transactions in a tab across some but not all accounts which have > > entries. What am I not setting right in preferences? (Windoze 10 => > > Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) > > Check Edit > Filter By... > > The General Journal defaults to a 30 day window if I’m not mistaken. (mine > was set as such) Unfortunately, I don’t think there is a preference to set > this. You have to change it each time you open it. > Recent versions of GnuCash allow you to save your preference, even for the General Journal. This was implemented by Robert Fewell somewhere in the 3.x series. Geert ___ 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] QFX/OFX import issue from American Express
Has anyone besides me run into an issue with the QFX file import from American Express? I tried downloading and importing, one statements worth of transactions at a time (just as I have successfully done in the past), and the import window showed no transactions. When I look at the QFX file it has multiple transactions in it. I have not yet looked at the file(s) in detail yet to see if I can spot a change in format. This is under Windoze 10 and Gnu-Cash version 3.5. -- --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 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] Pending Edit Behavior in GnuCash
> On Jun 7, 2019, at 3:57 AM, jeffrey black wrote: > >> > I think I missed something here Adrien. I only get a /months worth /of > transactions in a tab across some but not all accounts which have > entries. What am I not setting right in preferences? (Windoze 10 => > Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) > > -- > --JEffrey Black M.B.A. Check Edit > Filter By... The General Journal defaults to a 30 day window if I’m not mistaken. (mine was set as such) Unfortunately, I don’t think there is a preference to set this. You have to change it each time you open it. Be sure to check the other Filter tab as well to make sure you are seeing all transactions you want to see. (personally, I’d think the Journal should show everything, but that’s just me) My understanding is that one or the other (individual account registers, or General Journal) is ‘virtual’ while the other is how the data is actually stored. Traditional accounting would use the Journal first, but I seem to recall reading that GnuCash does this in reverse. Regards, Adrien ___ 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] Pending Edit Behavior in GnuCash
On 6/5/2019 4:51 PM, Adrien Monteleone wrote: > >> GnuCash, at least in the 2.6.xx series usually prohibits leaving a >> transaction that contains pending edits without using the Enter key to >> commit the edits, but it has some exceptions which set up some difficult >> situations when finally trying to do a manual File > Save. At that point >> it asks if you want to save edits in some register view which may even be >> accidental edits or keystrokes that would delete desired data. >> >> The most common action (for me) that sets this up is to start an edit in >> some register then navigate to another register without first saving the >> pending edit. This easily happens if the user is reviewing results from >> the Since Last Run assistant especially if a cat crosses the keyboard. > Using Sqlite backend, of course I get instant saves so I don’t see this issue > anymore, but that sort of ambiguous ’save edits’ question is disconcerting if > you are pretty sure you’ve committed all transactions, and now you’re being > told you haven’t. > >> I can see the reasoning that often users may need to view other registers >> to compare the transaction currently being edited to something else, so I >> do not want to prevent that. I would propose that the tabs containing >> pending edits flash in some way to catch the user's attention so he can >> find his way back to see if it was cat-tracks or a real pending edit. > Interesting idea. Though this might interfere with the custom tab colors, I > like the idea of some visual indicator that something has been edited and > needs attention. (perhaps a bold or italic typeface change?) Flashing however > I would not be in favor of. I don't use the SQL back-end because of the lack of a rollback feature. I frequently, much to often, make mistakes on import matching, wrong account match, etc. And some recent crashes have created something of a nightmare for me (the xml file is shall we say much more user friendly in that regard). Windoze 10 is not exactly stable, it crashes on Micro$oft's own programs. (wish list: the Ubuntu repositories provide the latest version. My attempts at building have failed miserably. My tower typically runs Windoze 10 while my networked laptop runs Ubuntu. For whatever reason that is the only combination of OS's that I can get to cooperate over my network. I suspect it is a router incompatibility but; that is my problem not the teams.) I frequently get the message box of save or cancel the changed transaction. What transaction, I have not edited or started one. And Gnu-Cash does not show me where or which transaction has been changed. An indicator of the account which has been altered transaction and taking me back to the transaction would be a godsend. I agree a flashing account tab would not be aesthetic. Perhaps a scrolling color change for the account tab but; at least take me back to the offending transaction so I can see if I am accepting or canceling a mistake or not. > >> Finally, I will throw out a radical suggestion that all edits get their own >> new window instead of happening within a certain register view with a >> certain "anchor" account which has special behavior compared to other split >> lines. This Edit window would not be tied to any account and would be >> obviously not saved as long as it exists. >> > This already exists as the ‘General Journal’ (Tools menu) It’s your choice to > use it. Though it is not implemented for only the currently edited > transactions, but the entirety of your data file. > > Regards, > Adrien I think I missed something here Adrien. I only get a /months worth /of transactions in a tab across some but not all accounts which have entries. What am I not setting right in preferences? (Windoze 10 => Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) -- --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 > 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.