Re: [GNC] Auto commit with auto save?

2023-05-06 Thread David T. via gnucash-user
I agree that it would be nice to have some visual cue that a transaction has been edited but not saved; that would be useful. I'm honestly not sure why that hasn't been implemented. The app does throw a dialog onscreen when a user tries to save with an open transaction. Unfortunately, the

[GNC] Issues with Release 5.1

2023-05-06 Thread eliotread
Dear list, I have been using GNUCash in various forms for 3-4 years. However with the 5.1 release I have some issues: 1. When uploading transactions, I can select the date, description, but the "Deposit" option has disappeared from the dropdown selection. The "requirements" that indicate

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Colin Arndt
Thank you Bruce. That fixed it and was a lot quicker than changing ~30 securities to a new provider. For anyone else on macOS, the location was: /Library/Perl/5.30/Finance/Quote/YahooJSON.pm Best, Colin > On May 6, 2023, at 3:19 PM, gnucash-user-requ...@gnucash.org wrote: > >

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Ken Farley
Bruce, It's okay, I'm not an expert with Perl, but have done a lot of programming. I used one of the methods proposed to extract the data I need and use it. It's not elegant code, but as with all such investigations that eventually get solved, it's so satisfying to have done it. And I

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Bruce Schuck
Switching all my securities to Alphadvantage was tiresome, as the gui was no responsive to the keyboard, but I found the source could be found using page up. Some display at the security editor main screen or somewhere would help to see which is running quotes where, how many currently owned. I

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Bruce Schuck
On Sat, May 6 2023 at 17:45 EDT Michael wrote: Thanks Bruce. Worked great calling the v6 version of the API. In the mean time, for those savvy enough to find and edit the YahooJSON.pm file on their system, a quick fix is to change this line: my $YIND_URL_HEAD =

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-05-06 Thread Bruce Schuck
On 5/6/23 15:01, John Ralls wrote: On my mid-2010 MBP running Mac OS X 10.13.6 I get the following from your script: `.cpan/build/Finance::Quote-blah/Examples/stockdump.pl alphavantage AAPL` works fine. `Examples/currency-lookup.pl EUR GBP` returns "Urgh. Nothing back" while on my 2013

[GNC] Shortcuts in Security Editor

2023-05-06 Thread flywire
https://wiki.gnucash.org/wiki/Keyboard_Shortcuts ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-05-06 Thread John Ralls
Bruce, On my mid-2010 MBP running Mac OS X 10.13.6 I get the following from your script: Archive::Any::Lite version = 0.11 Array::Diff version = 0.09 AutoLoader version = 5.74 B::COW version = 0.007 B::Keywords version = 1.24 Bundle::NetSNMP version = Not Found CPAN::DistnameInfo version = 0.12

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Fross, Michael
Thanks Bruce. Worked great calling the v6 version of the API. On Sat, May 6, 2023 at 2:13 PM Bruce Schuck wrote: > Ken, > > I am currently evaluating which of the alternatives is the best > replacement. I'm also a little hopeful that in the meantime the > functionality of the current URL/API

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-05-06 Thread Bruce Schuck
John, Is this still an issue? From my virgin High Sierra Virtual Box system after installing Finance::Quote and updating Load::Module. Archive::Any::Lite version=0.11 Array::Diff version=0.09 AutoLoader version=5.74 B::COW version=0.007 B::Keywords version=1.24 Bundle::NetSNMP

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread David G. Pickett via gnucash-user
PS: I give up on Yahoo! Switching all my securities to Alphadvantage was tiresome, as the gui was no responsive to the keyboard, but I found the source could be found using page up.  Some display at the security editor main screen or somewhere would help to see which is running quotes where,

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Bruce Schuck
On 5/6/23 17:51, David G. Pickett wrote: Yeah, it's back.?? > - Is Yahoo aware of their server rejects??? - Is there some magic cookie or such we need to be authorized?? > Many previous fixes proposed, which did not seem to prevent > its return! I don't believe the APIs

[GNC] Shortcuts in Security Editor

2023-05-06 Thread Fred Tydeman
On Linux, is the file /home//.local/share/gnucash/accelerator-map the entire set of shortcuts? Or, is it possible to add others? I would like one to quickly delete a Security in the Security Editor (instead of clicking on Remove). Also, it would be nice if the Highlight line moved to the next

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Bruce Schuck
Ken, I am currently evaluating which of the alternatives is the best replacement. I'm also a little hopeful that in the meantime the functionality of the current URL/API is restored before the time is spent to not only make the changes, but the related housekeeping necessary before pushing

Re: [GNC] Search and Replace

2023-05-06 Thread Gyle McCollam
Already did a rfe in bug tracker, thanks Sent from Samsung Galaxy smartphone. Original message From: Vincent Dawans Date: 5/6/23 2:56 PM (GMT-05:00) To: AC Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Search and Replace I personally think it would be easier to keep

Re: [GNC] Search and Replace

2023-05-06 Thread Vincent Dawans
I personally think it would be easier to keep track of enhancement requests via the bug tracking system. https://bugs.gnucash.org/ You can select "enhancement" under the "severity" option when creating a "bug". Also it helps to start the description with "RFE:" which stands for "request for

Re: [GNC] Search and Replace

2023-05-06 Thread AC
I'm a bit disappointed that this thread went off in a different direction and never addressed actual search and replace. Is it even on the roadmap or do I still have to resort to butchering the XML file? On 2023-04-29 10:58, Stan Brown wrote: On 2023-04-29 08:32, Gyle McCollam wrote: On

Re: [GNC] Auto commit with auto save?

2023-05-06 Thread David G. Pickett via gnucash-user
"Don't do that!" does not prevent data loss from human error, which for this app behavior is too easy to create and not realize. If the commit was automatic every time you modified a transaction when the new state was valid, then I would not leave the tab in an uncommitted state, but that is

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread David G. Pickett via gnucash-user
Yeah, it's back.   - Is Yahoo aware of their server rejects?   - Is there some magic cookie or such we need to be authorized?  Many previous fixes proposed, which did not seem to prevent its return! ___ gnucash-user mailing list

Re: [GNC] Easy way to delete old transactions

2023-05-06 Thread NoobAlice
In my opinion, you are opening a can of worms, but if you are set on this course... If you have separate tax returns or other documents that let you know the income/loss of each entity each year, you may need those to let you determine correct starting equity by entity. You will need to

Re: [GNC] Meaning of A/U+C/C in the importer

2023-05-06 Thread Gyle McCollam
A is for add, meaning a new transaction not already in the file. U+C is for Update & Clear, which means change the description to what is showing vs what you have entered and clear the transaction, and the C means to leave the transaction as is, but clear or match it to what is already in the

Re: [GNC] Easy way to delete old transactions

2023-05-06 Thread Michael or Penny Novack
On 5/6/2023 3:06 AM, Fred Tydeman wrote: Is there an easy way to delete all transactions in all accounts before a certain date? Don't do this! If what you want is to mimic the old days (fresh books every year -- remember they were once PHYSICAL books with a finite number of pages a) Do a

Re: [GNC] Easy way to delete old transactions

2023-05-06 Thread Fred Tydeman
I have been keeping the books for three separate related entities in the same file. I have decided it would be better to have each entity in its own file. So, one idea is to copy the large file 3 times, to three different names. Then delete the accounts and transactions of 2 entities, keeping the

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-05-06 Thread Ken Farley
This message from the list contains links to the development bug reports for the Finance:Quote module: https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106863.html If you look at those reports, there are alternate queries discussed that could provide the data needed. They need to be

Re: [GNC] Easy way to delete old transactions

2023-05-06 Thread Glenn Fowler
You can bulk delete but know your records will be off like Gyle mentioned: https://lists.gnucash.org/pipermail/gnucash-user/2021-December/098934.html On Sat, May 6, 2023, 4:40 AM Gyle McCollam wrote: > You can't do that, it will screw up your records. The only thing you can > do is start a

Re: [GNC] Easy way to delete old transactions

2023-05-06 Thread Gyle McCollam
You can't do that, it will screw up your records. The only thing you can do is start a new set of books with the initial balances being the current book's balances. Sent from Samsung Galaxy smartphone. Original message From: Fred Tydeman Date: 5/6/23 3:07 AM

[GNC] Easy way to delete old transactions

2023-05-06 Thread Fred Tydeman
Is there an easy way to delete all transactions in all accounts before a certain date? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Trouble Changing Imported Descriptions

2023-05-06 Thread David T. via gnucash-user
Of course, the specific problem that OP outlined here had to do with what happens in GnuCash *after* transactions have been imported, rather than the import itself. David T.​ On May 6, 2023, 04:14, at 04:14, R Losey wrote: >It's issues like this that have made me wary of importing