[GNC] version 5.0 stable, is there a flathub update?

2023-03-30 Thread Jeff
I see that the much awaited version 5.0 stable has been released.  Is there a way to do it under Flathub, on Ubuntu 22.04.1 lts?  Or do I need to figure out how to convert my updates to flatpak? I would build it on my own server but it fails to create an executable version every-time.  One of

[GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Jeff
The IRS threw me a curve ball this year (imagine that).  One of their tax forms went from $600 minimum to you, to $20,000 "AND" more than 200 transactions in 2022.  Is there someone out there that can hold my hand and show me how to export those transactions to a spreadsheet to see if we fall

Re: [GNC] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

2023-03-30 Thread Outlook
I have the same problem with quote update on version 5.0, and now I have to return back to version 4.13 and it works fine. Some quotes from Taiwan stock, for example 0050.TW updated from Yahoo as JSON on macOS 13.3/ Thanks! > David G. Pickett via gnucash-user 於 2023年3月29日 > 上午7:30 寫道: > >

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Brad Morrison
Hi Jeff/all, I encountered this issue a few weeks ago for a tax client with a short term rental property. Apparently, 2022 is a "transition" year for the new requirements for producing a form 1099K - https://www.irs.gov/businesses/understanding-your-form-1099-k This VRBO page might be

Re: [GNC] version 5.0 stable, is there a flathub update?

2023-03-30 Thread Murugan Muruganandam
Jeff Flathub has 5,0 Regard Murugan > On 30-03-2023, at 03:18, Jeff wrote: > > I see that the much awaited version 5.0 stable has been released. Is there > a way to do it under Flathub, on Ubuntu 22.04.1 lts? Or do I need to figure > out how to convert my updates to flatpak? > > I

[GNC] v5.0: Not finding Import OFX/QFX File choice

2023-03-30 Thread L Smith
Running Windows 11. Just updated from v4.16 to v5.0. When I look for "File > Import > Import OFX/QFX file", it's not there. [cid:55230af7-f625-4598-a209-72b947f47d01] Section 6.16.1 of the updated documentation still lists OFX/QFX as a valid import file. Is this a bug? Lamar

Re: [GNC] v5.0: Not finding Import OFX/QFX File choice

2023-03-30 Thread Joseph St. Denis via gnucash-user
I have seen the same problem with the QFX file missing. Luckily my bank still supports the QIF downloads. I how ever have a problem with CSV files I get up to point of selecting the suggested amount but I get no results no matter what I select. Joseph St Denis Get Outlook for

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Adrien Monteleone
Jeff, It looks like your best bet is a Transaction Report that you then export to a spreadsheet app. An enhancement to show the count of results on a Find operation might be nice though. You could then use that info with an Account Report on Find results. Regards, Adrien On 3/30/23 1:43

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread john
To reduce the number of matches just keep typing. Regards, John Ralls > On Mar 30, 2023, at 10:38 AM, R Losey wrote: > > I also disagree; I have only used 5.0 for a few entries; it will get a good > workout tomorrow, but I can see it saving typing. Currently, it's a bit of > a surprise to see

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Dr. David Kirkby
I noticed from the Google website - actually Google, not what someone says they think about Google. https://support.google.com/webmasters/answer/10218333?hl=en-GB#not_enough_data "The Page Experience report provides a summary of the user experience of visitors to your site. Google evaluates page

Re: [GNC] Building 5.0 on Ubuntu 18.04

2023-03-30 Thread Tom Weichmann
Yeah I have got to update soon, there are some reasons I haven't yet but those are going away. Anyway, I applied the change that John referred to (simple move of one line ~6 lines down [ https://github.com/Gnucash/gnucash/pull/1593/commits/3355546753cc082c8d61b28923389a3ac2352b63]) and started my

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread john
According to https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US IIF is a tab-separated-values format. You can import that with the CSV importer by setting the separator to Tab. Regards, John Ralls >

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Michael or Penny Novack
"Here are the criteria for a URL to rate as good in page experience status in Google Search:: - *Failed:* The URL is served using HTTP, not HTTPS. So it seems to me that the argument that a website does not collect personal information, so does not need HTTPS, is flawed. You can argue the

Re: [GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread Chris Skudder
From Intuit: "Intuit Interchange Format (.IIF) files are ASCII text, TSV (Tab-Separated Value) files that QuickBooks Desktop uses to import or export lists or transactions" source:

Re: [GNC] No 5.0 Quotes fix, went back to 4.8

2023-03-30 Thread Jimmie Kelly
flakpak update was released yesterday, v5.0.1, which fixes the issue of retrieving quotes. Do a "sudo flatpak update" to get it. On Thu, Mar 30, 2023 at 9:46 AM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > As the month end approaches, and 5.0 cannot see my Quotes

Re: [GNC] Where to download 5.0

2023-03-30 Thread Gyle McCollam
Thanks, Pat & Ken Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email From: Ken Pyzik Sent: Wednesday, March 29, 2023 9:17 PM To: Gyle McCollam ; Gnucash Users Subject: RE: Where to download 5.0 Gyle

[GNC] Exporting from QuickBooks / Importing to GnuCash

2023-03-30 Thread Richard Lindgren
I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help

[GNC] No 5.0 Quotes fix, went back to 4.8

2023-03-30 Thread David G. Pickett via gnucash-user
As the month end approaches, and 5.0 cannot see my Quotes setup, I did a flatpak uninstall and an Ubuntu Software install, going back to 4.8, and voila, my Quotes work again. Let me know if you ever release a 5.? that can pick up a good Quotes install from 4.?, so I can return to what seems

Re: [GNC] Exporting reports to spreadsheet

2023-03-30 Thread R Losey
As others have said, changing the extension doesn't change the data. Instead of clicking on the file, start LibreOffice Calc, and open the data from Calc. On Wed, Mar 29, 2023 at 11:13 AM George Riner wrote: > The setting: > > Windows 10 > Gnucash 4.13 > > When I Export a report I've been

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread R Losey
I also disagree; I have only used 5.0 for a few entries; it will get a good workout tomorrow, but I can see it saving typing. Currently, it's a bit of a surprise to see the list pop up, but I imagine I'll get used to it. I don't know what happens if there are, say, 20 different older entries; it

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Murugan Muruganandam
hi Jeff I would suggest the best will be to generate the transaction report in options Account:select all account Display: select account name , unselect full name Display: Amount as single column General: date range and check table for export export the report to .xls format and open it in the

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread Dale Alspach
What if there is no more to type? Example: I enter ONG That is exactly what I want. The list includes Amanda Szongo, all possibities including words such as long, e.g., long term care. The highlighted entry is Amand Szongo so I cannot just hit tab. How do I move the cursor off the description ? I

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread cl
On Thu, Mar 30, 2023 at 08:47:50PM +0100, Dr. David Kirkby wrote: > On Thu, 30 Mar 2023 at 19:42, Patrick James > wrote: > > > About two months ago, there was a major ice storm in Austin, and the area > > was completely unprepared for such a storm. A friend of mine was without > > power for about

Re: [GNC] gnucash Crashes

2023-03-30 Thread John Ralls
Please file a bug report (see https://wiki.gnucash.org/wiki/Bugzilla) and attach the crash report from /Applications/Utilities/Console. Regards, John Ralls > On Mar 30, 2023, at 2:01 PM, Paul Roberts wrote: > > Macbook Pro, M1 processor, macOS Ventura V13.2.1 > > gnucash V5.0 > > gnucash

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Adrien Monteleone
And if you just need the number without it being in a cell, you can select a cell from any column in the first non-header row, then CTRL-D to select everything down the column to the end of the data, and your status bar should show you the result of COUNT(). If not, you can most likely add it

Re: [GNC] gnucash Crashes

2023-03-30 Thread john
Well have a look at Paul's bug and see if it's the same. If it isn't then please file a new bug report. Regards, John Ralls > On Mar 30, 2023, at 4:03 PM, Chris Graves wrote: > > I'm getting a similar crash with 5.0 on Ventura. > > Open and run a saved report, then open saved reports again

Re: [GNC] gnucash Crashes

2023-03-30 Thread Paul Roberts
Bug report was submitted on 30 Mar. On Thu, Mar 30, 2023 at 5:04 PM Chris Graves wrote: > I'm getting a similar crash with 5.0 on Ventura. > > Open and run a saved report, then open saved reports again and crash. > > Will be glad to open a separate bug report if needed. > > Chris > > > On Mar

Re: [GNC] gnucash Crashes

2023-03-30 Thread Chris Graves
I'm getting a similar crash with 5.0 on Ventura. Open and run a saved report, then open saved reports again and crash. Will be glad to open a separate bug report if needed. Chris > On Mar 30, 2023, at 3:42 PM, John Ralls wrote: > > Please file a bug report (see

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Patrick James
I keep trying to figure out what to do with all my "likes" on various social media sites, and as of today, no one can really explain why I want/desire/need more "likes," or similar. > On 03/30/2023 11:29 AM Dr. David Kirkby > wrote: > > But that still means if you want to do well in Google,

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Patrick James
About two months ago, there was a major ice storm in Austin, and the area was completely unprepared for such a storm. A friend of mine was without power for about 12 days. He has two small children, and he has good local resources, which were also impacted by the ice storm, and it was not easy

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Dr. David Kirkby
On Thu, 30 Mar 2023 at 19:42, Patrick James wrote: > About two months ago, there was a major ice storm in Austin, and the area > was completely unprepared for such a storm. A friend of mine was without > power for about 12 days. He has two small children, and he has good local > resources, which

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Dr. David Kirkby
On Thu, 30 Mar 2023 at 19:03, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > > "Here are the criteria for a URL to rate as good in page experience > status > > in Google Search:: > > > > - *Failed:* The URL is served using HTTP, not HTTPS. > > > > So it seems to me that the

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Phyllis Bruce
Jeff, I couldn't tie my response to what Murugan suggested. You can use the sum and count on the same spreadsheet. The Excel command for count is =COUNTA(first cell:last cell) Just put that command in the cell beneath the sum. On Thu, Mar 30, 2023 at 3:29 PM Murugan Muruganandam <

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread Tom Weichmann
I'm confused, is someone arguing against using HTTPS on gnucash.org? Is there some cost that is trying to be avoided or something like that? I use HTTPS on my little personal website because why have any data on the internet that isn't encrypted. I can't think of a downside On Thu, Mar 30,

[GNC] gnucash Crashes

2023-03-30 Thread Paul Roberts
Macbook Pro, M1 processor, macOS Ventura V13.2.1 gnucash V5.0 gnucash crashes every time after I open a customer report and then select Edit/Report Options -- Paul L Roberts, Ph.D. Head of School Bay Islands International School E Sandy Bay Beach Road, Sandy Bay Roatan, Islas de la Bahia,

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread David H
I also like this feature, a nice surprise when I started entering a new txn and it popped up - shows me where I've rearranged payee details inadvertently. Being as pedantic as I am, it's now given me extra work because I now feel obliged to go back and sort out the differences :-) Thanks to John

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread Dale Alspach
While that is a short term solution, it may have negative consequences. It eliminates the correct match from the list of matches. Further your solution will likely add the matching string ONG for future entries and the entry may cause formatting (alignment on initial visible character) annoyances

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread paul
In fact, Google has been on a broad push to get rid of http since early 2018: https://www.blog.google/products/chrome/milestone-chrome-security-marking-ht tp-not-secure/ https://www.nationalweb.com/blog/high-time-provide-security-googles-https-pu sh-and-what-it-means-your-business-website

Re: [GNC] 5.0-1 (Flathub) issue

2023-03-30 Thread David H
Dale, Typing 2 spaces to cater for the matches to "ong " with a trailing space works for me in that specific case, of course if you have no matches that end with ong and a trailing space only one space is required. Cheers David H. On Fri, 31 Mar 2023 at 07:07, Dale Alspach wrote: > What if

Re: [GNC] Site certificate expiry warning

2023-03-30 Thread cl
On Thu, Mar 30, 2023 at 03:56:25PM -0400, p...@kroitor.ca wrote: > In fact, Google has been on a broad push to get rid of http since early > 2018: > https://www.blog.google/products/chrome/milestone-chrome-security-marking-ht > tp-not-secure/ >

Re: [GNC] easy way to total number of transactions and USD ammounts

2023-03-30 Thread Phyllis Bruce
Thanks Murugan, I used pivot tables at one time but too long ago to remember how. Thankfully, I don't need them in my retirement. They are certainly valuable tools. On Thu, Mar 30, 2023 at 5:01 PM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > thanks phyllis, my explanations was

Re: [GNC] gnucash Crashes

2023-03-30 Thread R Losey
I believe I had the same issue on a similar platform -- mine is an M1 iMac instead of an M1 MacBook Pro, but I was playing around right after I installed it. I ran a report that showed nothing (apparently needed some options set). I selected Options, and GnuCash crashed. I've avoided doing that