Re: [GNC] GnuCash works on clean install of Ubuntu 24.04
Good that it works, I guess. Is the cause of the problem the broken Nvidia drivers? Regards, John Ralls > On May 23, 2024, at 10:00, Mark at Lorimark > wrote: > > Hey, run gnucash with this to get it to show reports; > >> WEBKIT_DISABLE_COMPOSITING_MODE=1 gnucash > > ~mark petryk > ~w:http://www.lorimarksolutions.com > > On 5/23/24 11:25, Bruce Griffis wrote: >> I saw the message on GnuCash not working on an upgrade to Ubuntu 24.04. >> Just wanted to say that it works on a fresh install. I wanted to go 24.04, >> so did a fresh install than restored /home from backups. While that works, >> if you have a lot of customized packages installed instead of just things >> from the Ubuntu Software store or snaps - it can get hard to maintain. For >> me, Rocksmith 2014 under Steam just doesn't work on 24.04 - so there are >> broken things. But GnuCash was pretty cool (other than reports not >> displaying). > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't download stock prices
Ernie, You probably built it for the wrong architecture. GnuCash is x86_64 so all of the perl modules that aren’t pure perl need to be multi-architecture. See https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt for an explanation. Regards, John Ralls > On May 21, 2024, at 19:16, Ernie Wakamatsu wrote: > > HI John and Gnucash Supporters, > > I was afraid you were going to say that. As far as I can tell, I have > JSON::Parse installed, but gnucash-cli is not finding it. > > Ernie-Mac-mini% cpan JSON::Parse > Loading internal logger. Log::Log4perl recommended for better logging > Reading '/Users/Ernie_1/.cpan/Metadata' > Database was generated on Tue, 21 May 2024 02:17:02 GMT > JSON::Parse is up to date (0.62). > Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info > Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli > Failed to initialize Finance::Quote: missing_modules JSON::Parse > > Sorry to keep troubling you. > > Reards, > Ernie > Just an old FORTRAN programmer > > >> On 22 May 2024, at 1:48 AM, John Ralls wrote: >> >> Depends on the bug. Just like every other development team they have more >> bugs than engineers so they have to prioritize. Some things get fixed >> quickly, others take a while, and some never get attention. I don’t know who >> maintains the libc that Apple uses. If it’s FreeBSD then they won’t consider >> it a bug because their file systems are case sensitive. >> >> As for what to do, that should be obvious: Spell the path correctly, where >> spell includes case. >> You also need to run gnc-update-fq again to get JSON::Parse installed. >> >> Regards, >> John Ralls >> >>> On May 20, 2024, at 22:00, Ernie Wakamatsu wrote: >>> >>> One could hope Apple will fix bugs in a timely manner :-p. >>> >>> So what should I do to workaround this bug or am I hosed? >>> >>> Ernie >>> >>> >>>> On 21 May 2024, at 1:21 PM, John Ralls wrote: >>>> >>>> Hah! I didn’t even notice that. It’s pretty funny. >>>> >>>> The *file system* is by default case-preserving, meaning that you can >>>> create either macOS or MacOS but not both; preserving means that it will >>>> keep whichever one you create first. The shell is too, though Bash >>>> completion is case-sensitive. Apparently dlopen is case-sensitive too: >>>> when we call >>>> `dlopen(/Applications/Gnucash.app/Contents/macOS/lib/gnucash/libgncmod-backend-dbi.dylib, >>>> 0x0009)` it fails to find the file. You can see this yourself by running >>>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli --debug >>>> —logto=stdout -Q info >>>> It’s in the first line of output. >>>> >>>> I’m going to file a bug with Apple on that if it’s still true when the >>>> first macOS 15 developer beta comes out in 3 weeks. Maybe they’ll fix it. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On May 20, 2024, at 18:07, Ernie Wakamatsu wrote: >>>>> >>>>> Very strange. I get two results. >>>>> >>>>> First, following your instructions, by coping and pasting >>>>> Ernie@Ernie-Mac-mini contents % zsh -df >>>>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q >>>>> info >>>>> Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli >>>>> Failed to initialize Finance::Quote: missing_modules JSON::Parse >>>>> >>>>> But when I type in the command line: >>>>> >>>>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q >>>>> info >>>>> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli >>>>> * 11:01:28 WARN failed to load gncmod-backend-dbi from >>>>> relative path >>>>> * 11:01:28 ERROR required library gncmod-backend-dbi not >>>>> found. >>>>> * 11:01:28 WARN failed to load gncmod-backend-xml from >>>>> relative path >>>>> * 11:01:28 ERROR required library gncmod-backend-xml not >>>>> found. >>>>> * 11:01:28 ERROR g_settings_schema_source_lookup: assertion >>>>> 'source != NULL' failed >>>>> * 11:01:28 ERROR g_settings_new_full: assertion 'schema
Re: [GNC] Can't download stock prices
Depends on the bug. Just like every other development team they have more bugs than engineers so they have to prioritize. Some things get fixed quickly, others take a while, and some never get attention. I don’t know who maintains the libc that Apple uses. If it’s FreeBSD then they won’t consider it a bug because their file systems are case sensitive. As for what to do, that should be obvious: Spell the path correctly, where spell includes case. You also need to run gnc-update-fq again to get JSON::Parse installed. Regards, John Ralls > On May 20, 2024, at 22:00, Ernie Wakamatsu wrote: > > One could hope Apple will fix bugs in a timely manner :-p. > > So what should I do to workaround this bug or am I hosed? > > Ernie > > >> On 21 May 2024, at 1:21 PM, John Ralls wrote: >> >> Hah! I didn’t even notice that. It’s pretty funny. >> >> The *file system* is by default case-preserving, meaning that you can create >> either macOS or MacOS but not both; preserving means that it will keep >> whichever one you create first. The shell is too, though Bash completion is >> case-sensitive. Apparently dlopen is case-sensitive too: when we call >> `dlopen(/Applications/Gnucash.app/Contents/macOS/lib/gnucash/libgncmod-backend-dbi.dylib, >> 0x0009)` it fails to find the file. You can see this yourself by running >> /Applications/Gnucash.app/Contents/macOS/gnucash-cli --debug —logto=stdout >> -Q info >> It’s in the first line of output. >> >> I’m going to file a bug with Apple on that if it’s still true when the first >> macOS 15 developer beta comes out in 3 weeks. Maybe they’ll fix it. >> >> Regards, >> John Ralls >> >> >>> On May 20, 2024, at 18:07, Ernie Wakamatsu wrote: >>> >>> Very strange. I get two results. >>> >>> First, following your instructions, by coping and pasting >>> Ernie@Ernie-Mac-mini contents % zsh -df >>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info >>> Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli >>> Failed to initialize Finance::Quote: missing_modules JSON::Parse >>> >>> But when I type in the command line: >>> >>> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info >>> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli >>> * 11:01:28 WARN failed to load gncmod-backend-dbi from >>> relative path >>> * 11:01:28 ERROR required library gncmod-backend-dbi not found. >>> * 11:01:28 WARN failed to load gncmod-backend-xml from >>> relative path >>> * 11:01:28 ERROR required library gncmod-backend-xml not found. >>> * 11:01:28 ERROR g_settings_schema_source_lookup: assertion >>> 'source != NULL' failed >>> * 11:01:28 ERROR g_settings_new_full: assertion 'schema != NULL' >>> failed >>> * 11:01:28 WARN >>> [gnc_gsettings_get_settings_obj()] Ignoring attempt to access unknown >>> gsettings schema org.gnucash.GnuCash.general >>> zsh: segmentation fault >>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info >>> >>> The two command lines are seemingly the same, but the difference is macOS >>> and MacOS. I thought the shell was not case sensitive. hmmmm The >>> behavior is the same when I exit from the default shell. >>> >>> I did check the directory and it is MacOS. >>> >>> Ernie-Mac-mini% cd /Applications/Gnucash.app/Contents >>> Ernie-Mac-mini% ls >>> Info.plist MacOS PkgInfo Resources _CodeSignature >>> Ernie-Mac-mini% >>> >>> Odd that it would behave differently. >>> >>> Thoughts? >>> >>> Ernie >>> >>> >>> >>> >>>> On 21 May 2024, at 2:50 AM, John Ralls wrote: >>>> >>>> Ernie, >>>> >>>> The double slash is present in my output too, and it’s harmless. >>>> >>>> That shows that the app bundle is complete and uncorrupted. Something is >>>> getting in the way of dlopen finding those two libraries. >>>> >>>> Try getting a purely default shell environment by running >>>>zsh -df >>>> That opens a new sub shell with no environment variables set and ignoring >>>> all of your zsh config files. You can quit back to your regular shell with >>>> d, but first try running >>>> /Applications/Gnucash.app/Contents/MacOS/gnucash-c
Re: [GNC] Can't download stock prices
Hah! I didn’t even notice that. It’s pretty funny. The *file system* is by default case-preserving, meaning that you can create either macOS or MacOS but not both; preserving means that it will keep whichever one you create first. The shell is too, though Bash completion is case-sensitive. Apparently dlopen is case-sensitive too: when we call `dlopen(/Applications/Gnucash.app/Contents/macOS/lib/gnucash/libgncmod-backend-dbi.dylib, 0x0009)` it fails to find the file. You can see this yourself by running /Applications/Gnucash.app/Contents/macOS/gnucash-cli --debug —logto=stdout -Q info It’s in the first line of output. I’m going to file a bug with Apple on that if it’s still true when the first macOS 15 developer beta comes out in 3 weeks. Maybe they’ll fix it. Regards, John Ralls > On May 20, 2024, at 18:07, Ernie Wakamatsu wrote: > > Very strange. I get two results. > > First, following your instructions, by coping and pasting > Ernie@Ernie-Mac-mini contents % zsh -df > Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info > Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli > Failed to initialize Finance::Quote: missing_modules JSON::Parse > > But when I type in the command line: > > Ernie-Mac-mini% /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info > Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli > * 11:01:28 WARN failed to load gncmod-backend-dbi from relative > path > * 11:01:28 ERROR required library gncmod-backend-dbi not found. > * 11:01:28 WARN failed to load gncmod-backend-xml from relative > path > * 11:01:28 ERROR required library gncmod-backend-xml not found. > * 11:01:28 ERROR g_settings_schema_source_lookup: assertion > 'source != NULL' failed > * 11:01:28 ERROR g_settings_new_full: assertion 'schema != NULL' > failed > * 11:01:28 WARN [gnc_gsettings_get_settings_obj()] > Ignoring attempt to access unknown gsettings schema > org.gnucash.GnuCash.general > zsh: segmentation fault /Applications/Gnucash.app/Contents/macOS/gnucash-cli > -Q info > > The two command lines are seemingly the same, but the difference is macOS and > MacOS. I thought the shell was not case sensitive. h The behavior is > the same when I exit from the default shell. > > I did check the directory and it is MacOS. > > Ernie-Mac-mini% cd /Applications/Gnucash.app/Contents > Ernie-Mac-mini% ls > Info.plistMacOS PkgInfo Resources _CodeSignature > Ernie-Mac-mini% > > Odd that it would behave differently. > > Thoughts? > > Ernie > > > > >> On 21 May 2024, at 2:50 AM, John Ralls wrote: >> >> Ernie, >> >> The double slash is present in my output too, and it’s harmless. >> >> That shows that the app bundle is complete and uncorrupted. Something is >> getting in the way of dlopen finding those two libraries. >> >> Try getting a purely default shell environment by running >>zsh -df >> That opens a new sub shell with no environment variables set and ignoring >> all of your zsh config files. You can quit back to your regular shell with >> d, but first try running >> /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info >> >> Regards, >> John Ralls >> >>> On May 19, 2024, at 22:22, Ernie Wakamatsu wrote: >>> >>> Thanks John, >>> >>> I ran the below commands and this is what I got. >>> >>> Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app >>> /applications/gnucash.app: accepted >>> source=Notarized Developer ID >>> origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) >>> Ernie@Ernie-Mac-mini contents % otool -L >>> /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib >>> /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib: >>> @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib >>> (compatibility version 0.0.0, current version 0.0.0) >>> @executable_path/../Resources/lib/libgnc-backend-sql.dylib >>> (compatibility version 0.0.0, current version 0.0.0) >>> @executable_path/../Resources/lib/libgnc-engine.dylib (compatibility >>> version 0.0.0, current version 0.0.0) >>> @executable_path/../Resources/lib/libdbi.3.dylib (compatibility version >>> 4.0.0, current version 4.0.0) >>> @executable_path/../Resources/lib/libgnc-core-utils.dylib >>> (compatibility version 0.0.0, current version 0.0.0) >>> @executable_path/../Resources/lib/lib
Re: [GNC] Can't download stock prices
Ernie, The double slash is present in my output too, and it’s harmless. That shows that the app bundle is complete and uncorrupted. Something is getting in the way of dlopen finding those two libraries. Try getting a purely default shell environment by running zsh -df That opens a new sub shell with no environment variables set and ignoring all of your zsh config files. You can quit back to your regular shell with d, but first try running /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info Regards, John Ralls > On May 19, 2024, at 22:22, Ernie Wakamatsu wrote: > > Thanks John, > > I ran the below commands and this is what I got. > > Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app > /applications/gnucash.app: accepted > source=Notarized Developer ID > origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) > Ernie@Ernie-Mac-mini contents % otool -L > /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib > /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib: > @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib > (compatibility version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libgnc-backend-sql.dylib > (compatibility version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libgnc-engine.dylib (compatibility > version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libdbi.3.dylib (compatibility version > 4.0.0, current version 4.0.0) > @executable_path/../Resources/lib/libgnc-core-utils.dylib > (compatibility version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libboost_regex.dylib (compatibility > version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libboost_date_time.dylib > (compatibility version 0.0.0, current version 0.0.0) > @executable_path/../Resources/lib/libicui18n.73.dylib (compatibility > version 73.0.0, current version 73.2.0) > @executable_path/../Resources/lib/libicuuc.73.dylib (compatibility > version 73.0.0, current version 73.2.0) > @executable_path/../Resources/lib/libicudata.73.dylib (compatibility > version 73.0.0, current version 73.2.0) > @executable_path/../Resources/lib/libgmodule-2.0.0.dylib (compatibility > version 7601.0.0, current version 7601.3.0) > @executable_path/../Resources/lib/libglib-2.0.0.dylib (compatibility > version 7601.0.0, current version 7601.3.0) > @executable_path/../Resources/lib/libintl.8.dylib (compatibility > version 13.0.0, current version 13.0.0) > @executable_path/../Resources/lib/libgobject-2.0.0.dylib (compatibility > version 7601.0.0, current version 7601.3.0) > /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version > 1300.36.0) > /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current > version 1319.0.0) > Ernie@Ernie-Mac-mini contents % > > Compared to your output, the only difference I can find is in the first line > where I have a double slash: > > @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib > (compatibility version 0.0.0, current version 0.0.0) > > Just eyeballing, everything else looks the same. Could this double slash be > causing me troubles? > > Ernie > > > > > >> On 20 May 2024, at 1:52 PM, John Ralls wrote: >> >> >> >>> On May 19, 2024, at 18:03, Ernie Wakamatsu wrote: >>> >>> Hi, >>> >>> First time user of this mailing list and just starting to use gnucash. >>> Been transferring information over from Quicken and I am getting things >>> close to the way I would like. >>> >>> I am trying to download stock prices, but getting the following errors. >>> >>> Ernie@Ernie-Mac-mini ~ % >>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info >>> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli >>> * 11:59:02 WARN failed to load gncmod-backend-dbi from >>> relative path >>> * 11:59:02 ERROR required library gncmod-backend-dbi not found. >>> * 11:59:02 WARN failed to load gncmod-backend-xml from >>> relative path >>> * 11:59:02 ERROR required library gncmod-backend-xml not found. >>> * 11:59:02 ERROR g_settings_schema_source_lookup: assertion >>> 'source != NULL' failed >>> * 11:59:02 ERROR g_settings_new_full: assertion 'schema != NULL' >>> failed >>> * 11:59:02 WARN >>> [gnc_gsettings_get_settings_obj()] Ignoring attempt to access unknown &g
Re: [GNC] Can't download stock prices
> On May 19, 2024, at 18:03, Ernie Wakamatsu wrote: > > Hi, > > First time user of this mailing list and just starting to use gnucash. Been > transferring information over from Quicken and I am getting things close to > the way I would like. > > I am trying to download stock prices, but getting the following errors. > > Ernie@Ernie-Mac-mini ~ % /Applications/Gnucash.app/Contents/macOS/gnucash-cli > -Q info > Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli > * 11:59:02 WARN failed to load gncmod-backend-dbi from relative > path > * 11:59:02 ERROR required library gncmod-backend-dbi not found. > * 11:59:02 WARN failed to load gncmod-backend-xml from relative > path > * 11:59:02 ERROR required library gncmod-backend-xml not found. > * 11:59:02 ERROR g_settings_schema_source_lookup: assertion > 'source != NULL' failed > * 11:59:02 ERROR g_settings_new_full: assertion 'schema != NULL' > failed > * 11:59:02 WARN [gnc_gsettings_get_settings_obj()] > Ignoring attempt to access unknown gsettings schema > org.gnucash.GnuCash.general > zsh: segmentation fault /Applications/Gnucash.app/Contents/macOS/gnucash-cli > -Q info > Ernie@Ernie-Mac-mini ~ % > > As you can tell, I am on a Mac Mini running Sonoma 14.4.1 (latest?). Looks > like I may be missing some files. Tried the wiki and other search engines > but not finding any answers. How can I resolve the above? > > Thanks in advance for any assistance. Not quite the latest macOS version, 14.5 dropped last week. That’s unlikely to matter. The two files that it can’t find, libgncmon-backend-dbi.dylib and libgncmod-backend-xml.dylib, should be in /Applications/Gnucash.app/Contents/Rsources/lib/gnucash. If you have Xcode or Xcode command line tools installed and they’re present you can run e.g. otool -L /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib The output should be Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib: @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libgnc-backend-sql.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libgnc-engine.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libdbi.3.dylib (compatibility version 4.0.0, current version 4.0.0) @executable_path/../Resources/lib/libgnc-core-utils.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libboost_regex.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libboost_date_time.dylib (compatibility version 0.0.0, current version 0.0.0) @executable_path/../Resources/lib/libicui18n.73.dylib (compatibility version 73.0.0, current version 73.2.0) @executable_path/../Resources/lib/libicuuc.73.dylib (compatibility version 73.0.0, current version 73.2.0) @executable_path/../Resources/lib/libicudata.73.dylib (compatibility version 73.0.0, current version 73.2.0) @executable_path/../Resources/lib/libgmodule-2.0.0.dylib (compatibility version 7601.0.0, current version 7601.3.0) @executable_path/../Resources/lib/libglib-2.0.0.dylib (compatibility version 7601.0.0, current version 7601.3.0) @executable_path/../Resources/lib/libintl.8.dylib (compatibility version 13.0.0, current version 13.0.0) @executable_path/../Resources/lib/libgobject-2.0.0.dylib (compatibility version 7601.0.0, current version 7601.3.0) /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 1300.36.0) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1319.0.0) You can check that the application bundle is complete and matches its code signature with spctl —assess -vv /Applications/Gnucash.app It should report /Applications/Gnucash.app/: accepted source=Notarized Developer ID origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] All Reports Crashing Version 5.6-1
> On May 19, 2024, at 01:05, Rodney Harrex via gnucash-user > wrote: > > Running any report will crash GnuCash. In > C:\Users\Rodney\AppData\Local\Temp. Any of the reports selected will appear > as HTML file along with a file like > > gnucash.trace.ITONN2.log with the content: 17:31:13 WARN > [taxtable_reset_refcount()] Fixing refcount on taxtable > 8e7068a6313b4b21861f31a8461b9469 (3 -> 2). > > Would this a corrupted table within the dB? Probably not. Please file a bug report (see https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones) and if possible get a stack trace (see https://wiki.gnucash.org/wiki/Stack_Trace#Windows) and attach it to the bug report. Please also attach gnucash.trace.ITONN2.log, 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Delete a trading account => crash
> On May 18, 2024, at 22:04, Fred Tydeman wrote: > > Running GnuCash 4.14 on Fedora Linux. > > Due to a mistake on my part, I have two Trading accounts: > IVR-PC > IVRPRC > for the same security. > > First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy > transaction from the cash account. However, when I pressed Enter, > Gnucash undid my change. > > Then, I tried deleting Trading:IVRPRC account and moving its transactions > to Trading: IVR-PC. > That crashed Gnucash. > > I am now running a Check & Repair all (takes many minutes). Fred, Do you have two commodities IVRPRC and IVR-PC in your book or did you rename IVRPRC to IVR-PC? If the former have you changed all of the accounts that were denominated in IVRPRC to use IVR-PC? Trading splits are deleted and regenerated as part of the transaction balancing code run during transaction commit when trading accounts are enabled in File>Preferences so once you have the account commodities fixed you can edit the transactions with the wrong trading account in some register other than the trading account and delete the trading splits then close the transaction. Deleting the IVRPRC trading account will only work if you renamed the commodity: If you have separate commodities then GnuCash won’t let you transfer the splits because the commodities don’t match. You also need to turn off trading accounts in File>Preferences before you do the delete-and-transfer then turn it back on again. If you have two commodities you need to change all of the accounts using IVRPRC to use IVR-PC then edit every transaction that used IVRPRC, delete the trading splits, and commit it to generate new trading spits in IVR-PC. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transferring Gnu Cash Data to New Computer
> On May 17, 2024, at 3:00 PM, R Losey wrote: > > On Fri, May 17, 2024 at 12:27 PM Stan Brown (using GC 4.14) < > stan...@fastmail.fm> wrote: > >> On 2024-05-17 07:44, R Losey wrote: >>> I hope you know where that file is stored. One >>> way to find it is to open the old GnuCash and then under File, choose >> "Save >>> As" - it will open in the same directory as your current file is stored. >> >> While that will work, I think it's easier just to click File then hover >> the mouse over the filename in the file list. GC will show the full path. >> > > Interesting... that doesn't work on my iMac (M1 running Sonoma 14.4.1) It can't. macOS controls the menus and hover text isn't something that their menus provide. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem building Gnucash from source using wiki page "macOS/Quartz"
> On May 9, 2024, at 10:08, Paul Ingram wrote: > > > Trying to build gnucash-5.6 from source on a mac mini running macOS 14.4.1 in > accordance with the instructions on > https://wiki.gnucash.org/wiki/MacOS/Quartz. > > Created administrator account “gtkosx” > Switched to the new account: "su gtkosx" > Ran “sh gtk-osx-setup.sh” in a bash shell > Got the following messages: > > Installed openssl-3.2.0 … > Installed readline-8.2 … > Installed python-3.11.7 (with warnings “missing the Tk toolkit?” and “missing > the lzma lib?” > Installed pip-24.0 … > Installing collected packages: distlib, setup tools, … > Installed certifi-2024.2.2, distlib-0.3.8, … > Created virtualenv … > Locking dependencies ... > Building requirements … > Resolving dependencies … > > Error: > File > "/Users/gtkosx/.new_local/lib/python3.11/site-packages/pipenv/project.py", > line *239*, in get_requests_session_for_source > > if *self.sessions.get**(*source*[*"name"*])*: > >~~ > > KeyError: 'name' > > ✘ Locking Failed! > > > > Patch for project.py appears here: https://github.com/pypa/pipenv/issues/6106 > > > > Do I patch project.py manually and rerun gtk-osx-setup.sh? > Yes. Pipenv has merged my PR but hasn’t done a new release. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
Kalpesh,
I think your price has too many digits. Try rounding it to 10E-9.
Regards,
John Ralls
> On May 8, 2024, at 09:05, Kalpesh Patel wrote:
>
> Hi GNC User community -
>
>
>
> I am developing a second F::Q module of my own. The first one works fine but
> second one seems to NOT want to work no matter what. I am in middle of
> debugging it and it has stomped me why not so hoping someone might be able
> to help me zero in where I am falling sort on the flow for it. I am working
> with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on
> Windows 11. (Note: I don't believe any interface change has taken place in
> GNC v5.x that would cause this but correct me here if I am wrong.).
>
>
>
> Invoking GNC with debug shows that return value is #f, which means something
> went wrong (run_executor is the "label" for my module and other modules work
> fine from the debug output):
>
>
>
> 11:19:24 DEBUG handling-request: (currency INR USD)
>
> * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone .
> 2024-05-08 11:19:11) (last . 3/250) (currency . USD)))
>
> * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY
>
> * 11:20:39 DEBUG handling-request: (tsp C S L2030 I)
>
> * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S)
> (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD))
> (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last .
> 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD)))
>
> * 11:20:43 DEBUG handling-request: (run_executor BK)
>
> * 11:20:43 DEBUG results: (#f)
>
> * 11:20:43 DEBUG handling-request: (yahoojson ^NYA)
>
> * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone
> . 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD)))
>
>
>
> Following is debug run from command line of gnc-fq-dump (which provides all
> necessary fields for quote to be valid as it does not show '** This stock
> quote cannot be used by GnuCash!' message):
>
>
>
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
> run_executor BK
>
> {snip}
>
> ### [Wed May 8 11:34:40 2024] %info : {
>
> ###'BKISIN' => '-',
>
> ###'BKcurrency' => 'USD',
>
> ###'BKdate' => '05/08/2024',
>
> ###'BKisodate' => '2024-05-08',
>
> ###'BKmethod' => 'run_executor',
>
> ###'BKprice' => '57.64500045776367',
>
> ###'BKsuccess' => '1',
>
> ###'BKsymbol' => 'BK',
>
> ###'BKtimezone' => 'EDT'
>
> ### }
>
> Finance::Quote fields Gnucash uses:
>
> symbol: BK <=== required
>
>date: 05/08/2024 <=== recommended
>
> currency: USD <=== required
>
>last: <=\
>
> nav: <=== one of these
>
> price: 57.64500045776367<=/
>
> timezone: EDT <=== optional
>
>
>
> All fields returned by Finance::Quote for stock BK
>
>
>
> stock field value
>
> - - -
>
> BK ISIN: -
>
> BK currency: USD
>
> BK date: 05/08/2024
>
> BKisodate: 2024-05-08
>
> BK method: run_executor
>
> BK price: 57.64500045776367
>
> BKsuccess: 1
>
> BK symbol: BK
>
> BK timezone: EDT
>
>
>
>
>
> C:\Users\kalpesh>
>
>
>
> When running same command via YahooJSON following is the output which works
> fine (I see that it does have more information returned back):
>
>
>
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
> yahoojson BK
>
> {snip}
>
> Finance::Quote fields Gnucash uses:
>
> symbol: BK <=== required
>
>date: 05/08/2024 <=== recommended
>
> currency: USD <=== required
>
>last: 57.605 <=\
>
> nav: &l
Re: [GNC] no drop-down accounts list in ledger Transfer column.
IIRC this was a bug having to do with computing the box size for the list on
certain window managers. It took Bob Fewell several tries to get it fixed so
unfortunately the fix is to upgrade. You may be able to use the 4.13 .deb from
the Debian Archive, see
https://wiki.gnucash.org/wiki/Debian#Using_the_Debian_Archive.
Regards,
John Ralls
> On May 7, 2024, at 03:17, Adrien Monteleone
> wrote:
>
> Hmm.. it has been many moons since I made the move from 3.x to 4.x, so I
> don't see an obvious preference either. But perhaps toggle the:
>
> Preferences > Register > Actions > Auto-raise lists
>
> checkbox and see if that helps.
>
> If not, note as I mentioned, you should still be able to type through the
> tree as before to narrow down your account list to choose from.
>
> So starting with for example:
>
> "Expenses:"
>
> Would bring up a (albeit now truncated) list of Expense accounts can get you
> started. Then start typing the next branch of the tree, followed by your
> separator. (default being ":") Proceed as before from there.
>
> You may (or may not) need to uncheck:
>
> Preferences > Register Defaults > Other Defaults > Only display leaf account
> names
>
>
> Are you trying to access the *same* book with too different GnuCash versions?
>
> While this is possible within a small release window, it probably isn't a
> 'best practice' if it can be avoided.
>
> When advancing the major release number, some lack of backwards compatibility
> occurs. (not sure that is worded correctly) Usually, in conjunction with the
> next major release, the last minor release is issued such that both can read
> the same file.
>
> Thus, at a bare minimum, it is recommended to upgrade to the last minor
> release of a major version before moving to the next major version. Since the
> last release of 3.x was 3.11, that would mean if your other computer is on
> 4.8, you need the one on 3.8 to at least be on 3.11 so it can properly read
> the 4.8 file. (the 4.8 version should be able to read a 3.8 file with little
> issue, but it appears in your case, you are going back and forth, not one way
> from 3.x to 4.x)
>
> Is there some reason you can't get them both sync'd up to 4.8? (or 4.14 which
> is the last of that series)
>
> Is there some reason you can't advance them both to the current release? (5.6)
>
>
> Regards,
> Adrien
>
> On 5/7/24 3:24 AM, v@scottsonline.org.uk wrote:
>> I've had a hunt through all the preference stuff, but can't see anything
>> that looks relevant. Maybe it's too obvious to spot :-{
>> Account completion works, but doesn't really help if you can't remember the
>> account name!
>> But to reword/clarify my issue.
>> Working with 4.8, I have two separate accounts files. One of them shows a
>> dropdown list of accounts on clicking in in the Transfer field, the other
>> doesn't. There seems no reason the behaviours should be different.
>> The latter shows either for an existing transaction the highlighted current
>> contents or for a new transaction, initially blank (highlighted plus a
>> down-arrow) then the first account from the accounts tree with an up-arrow
>> when clicked.
>> On 3.8 I always get a dropdown accounts list.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] no drop-down accounts list in ledger Transfer column.
IIRC this was a bug having to do with computing the box size for the list on
certain window managers. It took Bob Fewell several tries to get it fixed so
unfortunately the fix is to upgrade. You may be able to use the 4.13 .deb from
the Debian Archive, see
https://wiki.gnucash.org/wiki/Debian#Using_the_Debian_Archive.
Regards,
John Ralls
> On May 7, 2024, at 03:17, Adrien Monteleone
> wrote:
>
> Hmm.. it has been many moons since I made the move from 3.x to 4.x, so I
> don't see an obvious preference either. But perhaps toggle the:
>
> Preferences > Register > Actions > Auto-raise lists
>
> checkbox and see if that helps.
>
> If not, note as I mentioned, you should still be able to type through the
> tree as before to narrow down your account list to choose from.
>
> So starting with for example:
>
> "Expenses:"
>
> Would bring up a (albeit now truncated) list of Expense accounts can get you
> started. Then start typing the next branch of the tree, followed by your
> separator. (default being ":") Proceed as before from there.
>
> You may (or may not) need to uncheck:
>
> Preferences > Register Defaults > Other Defaults > Only display leaf account
> names
>
>
> Are you trying to access the *same* book with too different GnuCash versions?
>
> While this is possible within a small release window, it probably isn't a
> 'best practice' if it can be avoided.
>
> When advancing the major release number, some lack of backwards compatibility
> occurs. (not sure that is worded correctly) Usually, in conjunction with the
> next major release, the last minor release is issued such that both can read
> the same file.
>
> Thus, at a bare minimum, it is recommended to upgrade to the last minor
> release of a major version before moving to the next major version. Since the
> last release of 3.x was 3.11, that would mean if your other computer is on
> 4.8, you need the one on 3.8 to at least be on 3.11 so it can properly read
> the 4.8 file. (the 4.8 version should be able to read a 3.8 file with little
> issue, but it appears in your case, you are going back and forth, not one way
> from 3.x to 4.x)
>
> Is there some reason you can't get them both sync'd up to 4.8? (or 4.14 which
> is the last of that series)
>
> Is there some reason you can't advance them both to the current release? (5.6)
>
>
> Regards,
> Adrien
>
> On 5/7/24 3:24 AM, v@scottsonline.org.uk wrote:
>> I've had a hunt through all the preference stuff, but can't see anything
>> that looks relevant. Maybe it's too obvious to spot :-{
>> Account completion works, but doesn't really help if you can't remember the
>> account name!
>> But to reword/clarify my issue.
>> Working with 4.8, I have two separate accounts files. One of them shows a
>> dropdown list of accounts on clicking in in the Transfer field, the other
>> doesn't. There seems no reason the behaviours should be different.
>> The latter shows either for an existing transaction the highlighted current
>> contents or for a new transaction, initially blank (highlighted plus a
>> down-arrow) then the first account from the accounts tree with an up-arrow
>> when clicked.
>> On 3.8 I always get a dropdown accounts list.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing .qif into Guncash
Yes, use a recent nightly build from https://code.gnucash.org/builds/flatpak/stable. Regards, John Ralls > On May 4, 2024, at 22:04, David Wasserman via gnucash-user > wrote: > > Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub > 5.6-2. > Gnucash Import fails at final screen with error message. Is there a fix? > > David W > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote PreRelease 1.61_03
> On May 3, 2024, at 10:35 AM, Bruce Schuck wrote: > > On 5/3/24 9:58 AM, John Ralls wrote: > >> It’s normal for Linux distros to package perl modules. Fedora’s is >> https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/ >> <https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/>. >> Note that there are back ports of 1.61 for Fedoras 38, 39, and 40. > > John, > > I am well aware of that. In this message yesterday > (https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111771.html) I > suggested that Fred install perl-CPAN and also maybe perl-App-cpanminus. > > What threw me is one of Fred's earlier comments where he stated > something like "I am now able to get quotes *again*". "Again" being the > operative word, as it sounded like he would have already had F::Q > installed, which typically means CPAN and/or CPAN Minus is already > installed. Or maybe I got mixed up with another response from someone else. > >> Debian/Ubuntu also package F::Q >> https://packages.ubuntu.com/search?keywords=libfinance-quote-perl >> <https://packages.ubuntu.com/search?keywords=libfinance-quote-perl> >> but are nowhere near as conscientious about keeping up with your >> releases so patience won’t work for their users. Keeping out of the >> way of the package manager is still a good practice so I think their >> users should also point cpan at a user-space directory. > > Again, not new to me. My primary desktop at home has been an Ubuntu LTS > release since 12.04LTS. I've been alternating between in place upgrades and > doing a fresh install and restoring what I need from backups. And the fresh > install path means I first have to install the Canonical CPAN and CPAN Minus > before I install the modules I use regularly. At home I go back and forth WRT > installing using sudo or using local::lib to install modules outside of the > normal @INC path. On my work macbook, I install all extra modules in > directories under $HOME. > > I've been around Perl a *long* time. Hell, if you grab the Perl source code > from Git, I'm in the list of authors… Bruce, I didn’t mean to impugn your experience, I’m just trying to keep things clear for the less experienced users who read this. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote PreRelease 1.61_03
> On May 2, 2024, at 09:01, Bruce Schuck wrote: > >> This is Fedora Linux 40 (the most recent) > > I find it odd that your system *ever* had Finance::Quote installed, Bruce, It’s normal for Linux distros to package perl modules. Fedora’s is https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/. Note that there are back ports of 1.61 for Fedoras 38, 39, and 40. They also package cpan as https://packages.fedoraproject.org/pkgs/perl-CPAN/. I suggest that he best course for Fedora users who want to get ahead of their distro for selected perl packages is to set up cpan to install to a directory in $HOME and use $PERL5LIB to put it at the top of @INC. That avoids contention with their package manager and for the most part leaves the dependencies to the distro to maintain. For most users a few days of patience will get them Debian/Ubuntu also package F::Q https://packages.ubuntu.com/search?keywords=libfinance-quote-perl but are nowhere near as conscientious about keeping up with your releases so patience won’t work for their users. Keeping out of the way of the package manager is still a good practice so I think their users should also point cpan at a user-space directory. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote on a Mac with a foreign perl
> On Apr 27, 2024, at 2:32 PM, Bruce Schuck wrote: > > On Fri Apr 26, 2024, at 12:07:04 EDT Mr Ralls wrote: > >> Here's an example of a failed session with Homebrew interference: >> https://paste.jvnv.net/view/CcsOd This comes from an IRC discussion at >> https://code.gnucash.org/logs/2024/04/16.html#T06:46:33. There >> was an earlier exchange with another longer dump that implicated >> Homebrew in which I told the user to clean it out but gncbot was >> apparently offline when that occurred and I don't have a link to it. >> In the dump you can see that the user is invoking gnc-fq-update and >> that it's running /usr/bin/perl. Later at line 97 you can see that >> /System/Library/Perl/Extras/5.34 is missing from @INC. That's where the >> pre-built networking modules are. > > John, > > That is indeed odd. I have two Macbook Pros. One Intel based running OSX > Catalina (It's a 2016 model), and a fairly new M1 running OSX Ventura. Both > have HomeBrew's Perl installed along side the Apple bundled Perl. "Perl -V" > does include "/System/Library/Perl/Extras/5.XX" on both (Catalina is 5.18, > Ventura is 5.30). "@INC" in Perl is compiled. Installation of the HomeBrew > Perl should in no way affect the value of @INC in the OSX bundled Perl. Most > people wanting to modify @INC do so by a number of ways. Setting PERL5LIB, > adding "-I" when executing Perl, or adding something like "use lib > '/home/foobar/code';" to the Perl code are some examples. > > As Vince showed, the HomeBrew Perl typically installs its modules under the > $HOME/perl5 path, or as I see on my Ventura Mac, /opt/homebrew/Cellar/. > > From the command line prompt in the session, it appears the user having the > issue is on a MacBook Air. I wonder if the included version of Perl is not > the same as what gets installed on a MacBook? > > I'd be curious to see the output of this find command from that user's Mac. > > find /Library/Perl /System/Library/Perl -path '*/Net/*' -type f -name > 'SSLeay.pm' > > Or more simply, does /System/Library/Perl/Extras exist on the user's MacBook > Air? > > That path may not be in the system Perl's @INC, because it's not part of the > Apple Perl package. Bruce, The user who made the log file is on IRC, handle englishman. I just pinged him about it. I have no info at all about the fellow who added the instruction to point openssl requests at Homebrew's libopenssl. I just remembered a third case that's probably the same problem: https://bugs.gnucash.org/show_bug.cgi?id=799195 complained that it took 15 minutes to install the F::Q dependencies and the attempt ultimately failed because SSLeay failed its unit tests. macOS is macOS. They don't change anything for the hardware, not even the build: Everything in the OS is universal binaries with x86_64 snd arm64. It's possible that Xcode/command-line tools adds stuff to /System/Library/Perl/Extras, but the user said he has both installed. I've asked him about what year MBA and what version of macOS. Perhaps there's a clue there. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up gnucash / stocks
> On Apr 27, 2024, at 7:28 AM, Wolfgang Paul Rauchholz > wrote: > > Hello community! > > I am running the latest gnucash under Fedorca Core. > Finance::Quote is installed and I get quotes for Funds and Stocks. > > EUR is the System Currency. The Stock Quotes are in USD > > Did I set up the initial balance correctly for Stocks (please see > attached screenshot)? I used the Stock Assistant whose transactional > currency is in EUR, but the stock quotes are in USD. Does this work? > > > The reporting of the values in EUR does not seem to be correct. How do I set > up currency correctly? In my setup, is USD or EUR the Security? > > > Thanks for your help. > You need to create a USD-denominated account of type Assets and make it the parent of the Danaher account. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] check printing
20 or so years ago I had a small company and used check-printing software to make the checks. I used generic pre-printed forms and the software included the MICR font and printed the routing id and account number in the appropriate place at the bottom. Back then the bank sent the completed checks back with the statements and every once in a while there'd be a strip of paper taped to the bottom of the check with the MICR line repeated. I guess that read failures were common enough that they had a procedure and probably a machine where a human would read and retype the MICR line to make and attach that strip when the regular read failed. Regards, John Ralls > On Apr 5, 2024, at 8:19 AM, R Losey wrote: > > While things may have changed, many years ago when I worked in the bank, > the info at the bottom of the check was printed with a special ink (I think > they called it a magnetic ink) so that the routing and account numbers > could be scanned by a computer. The rest of the check is regular printing. > > Moreover, I suspect that the banks don't like people being able to print an > entire check, as a small tweat of an account number might pull the money > from the wrong account. > > > On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant > wrote: > >> I was wondering if you need to use a pre-printed check or can you use >> blank check stock and have the routing and account numbers printed out >> by GnuCash. >> -- >> */Andrea Bryant/* >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using gnucash-cli for updating quotes on Windows
> On Apr 4, 2024, at 9:42 AM, fromvendor wrote:
>
> I'm having trouble trying to tell gnucash-cli -Q get which provider to use.
> I want it to use yahoo_json, which is what I have set up in the Security
> Editor ("Yahoo as JSON" for single quote source)
>
> When I do get it to run, it looks like it's getting the data from
> AlphaVantage as I get the following Warning message:
> WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha
> Vantage API key set, currency quotes and other AlphaVantage based quotes
> won't work.
>
> It did work as I only have three securities at the moment. So, how do I
> specify yahoo_json on the command line or is the warning spurious?
>
>
>
> BTW, I really had a hard time getting the command to run properly on windows.
> Perhaps I'm dumb, but the online places give no examples of what a properly
> formatted command to look like. I did, however get the command to run and it
> did update my file.
>
> Here's what I discovered. Perhaps useful to someone in the future.
>
> Apparently the datafile specification won't allow specifying the drive as I
> get this error: failed to get_backend using access method "O"
> I don't know if it would have handled a path specification, but since I had
> to change to a different drive anyway, I changed my command window to the
> location where the file resides.
> Further, the datafile name wants the entire name with the suffix (so
> .gnucash)
> This resulted in a command line which looked like this: "C:\Program Files
> (x86)\gnucash\bin\gnucash-cli.exe" -Q info <-- case matters for the -Q
> This resulted in output so I did that right
> Continued on to use the get and ended up with: "C:\Program Files
> (x86)\gnucash\bin\gnucash-cli.exe" -Q get ".gnucash"
> and that did update my datafile albeit with the warning above.
The missing Alphavantage key warning is independent of the price sources in
your file because of Alphavantage being the default source for retrieving
currency exchange rates.
You don't specify the source on the command line with '-Q get'. It's specified
for each commodity in the data file.
The data-file spec takes a URI so you can use the form
'file:///o:/path/to/datafile.gnucash' to access files on a a different drive
from your CWD.
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 5.6 AQBanking Failure on Windows
The GnuCash 5.6 Windows package was missing a library, libxmlsec1.dll, that AQBanking required. I've repackaged it with the library in place as gnucash-5.6-1.setup.exe and uploaded it to Github and SourceForge. 4596d431e5785ef3d80bcbea6e1c5e1df98c3b9b27314e6d8d2eae679424f56c gnucash-5.6-1.setup.exe 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] ANNOUNCE: GnuCash 5.6 Released
fo' xmlformat.conf: new element 'screeninfo' with no entry- and no exit-break New and Updated Translations: German Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. GnuCash is also available as a flatpak from Flathub.org. Instructions for installing and running: https://wiki.gnucash.org/wiki/Flatpak The SHA256 Hashes for the downloadable files are: * b4b42c626350f3e79f7ca1f2173545cc63ddee1addf2460b1a1f1bf21bd1 gnucash-5.6.tar.bz2 * 50aebe914da63c3b668c6a0b86df3d583a200c378f0f16658bec299bbbd3 gnucash-5.6.tar.gz * dc6139469696168ddd13ad617a8fbd31c2389b0960a82bc2da1c0c5606b37f46 gnucash-5.6.setup.exe * 2cc91f36d9939065dac366058aae1a6a8c41cfe84850b6b549ee87ba075d50d4 Gnucash-Intel-5.6-1.dmg * 8ad9da28199074fc5ef604d4489a82413031290a06e5f6418fe85cceb5fa3f02 gnucash-docs-5.6.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/5.6/gnucash-5.6.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.6/gnucash-5.6.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/5.6/Gnucash-Intel-5.6-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.6/Gnucash-Intel-5.6-1.dmg Getting GnuCash as source code If you want to compile GnuCash 5.5 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/5.6/gnucash-5.6.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/5.6/gnucash-5.6.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.6/gnucash-5.6.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.6/gnucash-5.6.tar.gz To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation Note that the documentation for unstable releases is not on the GnuCash website. It is built daily and may be found on the development server under the locale directory; "C" is English, "de" is German, and so on. The documentation is included in the MacOS and Windows application bundles. If you want to compile the GnuCash Documentation 5.6 for yourself, the source code can be downloaded from: Sourceforge: https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/5.6/gnucash-docs-5.6.tar.gz GitHub: https://github.com/Gnucash/gnucash/releases/download/5.6/gnucash-docs-5.6.tar.gz You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] gnucash-5.5-1.setup.exe
Having finally beaten WebKitGtk on Windows into submission so that it runs JavaScript without crashing, at least in my not very extensive tests, I've built a new Windows gnucash-5.5-1.setup.exe and uploaded it to the usual places. The sea-256 is 720a60dca57e4199f28b5449158ddc89e62012f042a62c43b16c569fa0890275. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Repeatable crashes with 4.14 on 32-bit arm Linux
> On Feb 10, 2024, at 5:19 PM, Robert Heller wrote: > > Always when hitting the reconcile button on a credit card account: > > Could not determine the accessibility bus address > ** > gnc.gui:ERROR:/home/heller/gnucash-4.14/gnucash/gnome-utils/dialog-transfer.c:2297:gnc_xfer_dialog_run_until_done: > > assertion failed: (count == 1) > Bail out! > gnc.gui:ERROR:/home/heller/gnucash-4.14/gnucash/gnome-utils/dialog-transfer.c:2297:gnc_xfer_dialog_run_until_done: > > assertion failed: (count == 1) > Could not determine the accessibility bus address > ** > gnc.gui:ERROR:/home/heller/gnucash-4.14/gnucash/gnome-utils/dialog-transfer.c:2297:gnc_xfer_dialog_run_until_done: > > assertion failed: (count == 1) > Bail out! > gnc.gui:ERROR:/home/heller/gnucash-4.14/gnucash/gnome-utils/dialog-transfer.c:2297:gnc_xfer_dialog_run_until_done: > > assertion failed: (count == 1) > > Things work fine after restarting... Restarting GnuCash or the computer? The accessibility bus message probably indicates that the DBUS session has quit for some reason. That part would be external to GnuCash. The assertion that's failing is about the result of count = g_signal_handlers_disconnect_by_func(dialog, gnc_xfer_dialog_response_cb, xferData); There should be exactly 1 handler using that gnc_xfer_dialog_response_cb connected to the signal. It there aren't either the transfer dialog is trying to run more than one instance (count > 1) or the the handler is already disconnected (count == 0). I don't think connecting or failing to connect to the accessibility bus would affect that, but I don't know what would cause it. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change Printed Invoice
> On Feb 6, 2024, at 4:01 PM, John Ralls wrote: > > Please remember to copy the list on all replies. > > The tab is actually called "Printable Invoice". I've attached a screenshot. > The screenshot apparently got eaten. Another try: ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change Printed Invoice
Please remember to copy the list on all replies. The tab is actually called "Printable Invoice". I've attached a screenshot. Regards, John Ralls > On Feb 6, 2024, at 11:20 AM, Lester Bennett wrote: > > I see no invoice report tab. I see an options button but there is no > reference to Custom Title there. > > > On 7/02/2024 3:46 am, john wrote: >> Editing the code is unnecessary. >> >> After clicking the Print button you'll get an invoice report tab with the >> invoice. Open report options and enter Tax Invoice in the Custom Title field >> of the General tab, then click Apply or OK. >> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Windows x64 release builds are missing
An x64 build will work only on 64-bit PCs, a 32-bit build works on both. Windows 11 doesn't support 32-bit and Windows 10, which does support 32-bit computers, goes end-of-life this May. We don't "officially" support operating systems after EOL so I guess at some point after that we can switch to 64-bit builds on Windows. Regards, John Ralls > On Jan 18, 2024, at 3:55 AM, * Neustradamus * > wrote: > > Dear GnuCash team, > > I would like to know when you will create the Windows x64 release builds? > > We are in 2024, x64 is here since Windows XP Pro. > > The goal is to have like other softwares, a x64 version in more x86. > > Thanks in advance. > > Regards, > > Neustradamus > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing from one gnucash file to another
It's part of CSV import. It has been there for a long time but didn't work very well until Geert rewrote the CSV importer for GnuCash 4. Use File>Export>Transactions to CSV to create a CSV file then File>Import>Import Transactions from CSV and click the Multi-Split box under File Format on the Import Preview page. Regards, John Ralls > On Jan 16, 2024, at 10:38 AM, Adrien Monteleone > wrote: > > I've never used it myself, but I recall a discussion when the feature was > added, I think for 4.x but it could have been earlier. > > Regards, > Adrien > > On 1/16/24 5:16 AM, David H wrote: >> James, >> I may be mis-remembering but I seem to recall when importing txns some time >> ago there was a checkbox or option to specify the file to be imported was >> in Gnucash format ? Do you see this? Have you selected it ? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Posting of Dividend through Stock Assist
Paras, Just include a blank split (no entries in shares, price, buy, or sell) to the mutual fund account and the APR will pick it up. Regards, John Ralls > On Jan 16, 2024, at 9:24 AM, Paras Desai wrote: > > Thanks John for your prompt feedback. > > Yes, I am posting it manually. Only down side is that i can not assign this > income to that specific Mutual fund account and hence it does not reflects in > Advance Portfolio Report, I guess. > > Of course, this is not the big deal. > > With my regards > > Paras. > > With regards > Paras > From: john > Sent: Tuesday, January 16, 2024 10:35:30 PM > To: Paras Desai > Cc: GnuCash User List > Subject: Re: [GNC] Posting of Dividend through Stock Assist > > > > > On Jan 16, 2024, at 05:41, Paras Desai wrote: > > > > Hello, > > > > Greetings! > > > > I was trying to post the Dividend income from a Mutual Fund through Stock > > Assist. But I encountered an issue. I am narrating my issue as below. > > > > When I receive the dividend, 10 % of TCS (Tax Collected at Source) is > > deducted and deposited to the Tax authority on my behalf and the remaining > > amount is paid to me. Such Tax deducted and deposited to Tax authority is > > My Tax credit and in my books of account it should reflect as Assets (Tax > > Credit) > > > > So my posting should look like this > > > > Dividend : Rs 1000 Cr (Income Account : Income from Dividend) > > > > Cash : Rs 900 Dr (Asset Account : My Bank) > > > > Tax deducted : Rs100 Dr (Asset Account : Tax Credit) > > > > There is no expense involved in the transaction. > > > > Now, when I try to post this transaction through Stock Assist, It offers me > > two options > > > > 1. Either I show the difference between the Dividend and Cash (which is Tax > > deducted) as expense, or I capitalize. There is no option to post the > > difference as tax credit in Assets account. > > > > AS a result, I need to post the transaction, with manual split, but in that > > case, I'm afraid I can not show return in form of dividend income for the > > Mutual Fund Account in portfolio report. > > > > Has anyone come across such a typical situation ? > > That's not a scenario that's coded into the stock assistant so you'll have to > enter it manually. Since dividend payments are presumably periodic it sounds > like a good candidate for a scheduled transaction. > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 5.5 Nightly Builds
> On Jan 6, 2024, at 12:37 PM, Adam Griffis wrote: > > Hello, > > Are nightly builds still being done? The latest nightly I'm seeing is > 5.4 from December 13th. > > I usually check here: > https://code.gnucash.org/builds/win32/stable/ The Windows build is broken and in order fix it we need a new WebKitGtk build, but that new build crashes in javascript when you try to run a report. I've been working on fixing that and will restore the Windows nightlies afterwards. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Windows Customer Report Crash
> On Dec 30, 2023, at 11:08 AM, Mark at Lorimark > wrote: > > Hi, > > I have a Windows 5.5 installed and ran in to a crash on opening customer > report. I then created a new data file (sql) and created a customer, created > an AR account, created an invoice for said customer, and for one thing is > said it could not write back to the database when trying to post the invoice, > but when trying to open a specific 'customer report' from the 'customers > list' screen, it crashes. > > I would like to continue testing so that I can prepare a comprehensive > report, or/and fix it. > > Where I find the logs or crashlogs for windows. That's bug https://bugs.gnucash.org/show_bug.cgi?id=799183. GnuCash 5.5 reports are broken on Windows. I suggest that you use GnuCash 5.4 instead until I can get WebKitGtk fixed and do a new Windows build. 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 - 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 5.5 (macOS) can't get quotes, because it doesn't see JSON::Parse
im,
It matters which perl is invoked, because each "minor" perl version (minor in
quotes because just like GnuCash before we truncated the version to two digits,
perl's "major" version has been fixed since the turn of the century) gets it's
own versioned directories of modules.
It might also matter that one of the Perls is MacPorts because MacPorts might
install its perl modules in the MacPorts installation tree.
You can use
perl -e 'print join("\n", @INC), "\n"`
(include the quotes) in each environment to see where that perl is looking for
modules.
The value of $PATH is different when running from the command line in Terminal
and when launching an app with LaunchServices, either by using the `open`
command from a command line prompt or double-clicking the app's icon in Finder.
Your terminal command line's PATH can be changed by your shell's startup files
(e.g. ~/.bashrc and ~/.bash_profile) but LaunchServices uses only the system's
default path, so the perl GnuCash.app sees is /usr/bin/perl and @INC will
include only the perl directories in /Library, /Network/Library, and
/System/Library. cpan, when run with sudo (and it won't work otherwise without
telling it to use a user space directory) installs to /Library/Perl//darwin-thread-multi-level, in your case
/Library/Perl/5.30/darwin-thread-multi-level.
You can force using that system perl on the command line by using the path
instead of just `perl`, e.g.
sudo /usr/bin/perl
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
will force using the system perl and its builtin @INC as long as $PERL5LIB
isn't set in the environment.
Note that if your mac is an Apple Silicon one that you need to specify arch
x86_64, as in
sudo arch -arch x86_64 /usr/bin/perl
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
(all on one line) because otherwise perl will build and install F::Q and
friends for Apple Silicon. GnuCash is built for Intel only because WebKitGtk
doesn't work when built for Apple Silicon and GnuCash will run an x86_64 perl
under Rosetta2; if a needed module isn't available for Intel then F::Q will
fail.
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnu cash Version 5.5 error message
Paras, The failure to install is probably down to the 5.4 problem of leaving the gnucash process running. The xmlIOFTPClose entry point problem is strange. It's optionally provided by libxml2 but MSYS-mingw doesn't build it in (neither does the macOS build). It's (also optionally) consumed by libxmlsec1, but again MSYS-mingw doesn't build with that option. Regards, John Ralls > On Dec 19, 2023, at 9:50 AM, Paras Desai wrote: > > Hello John > > It seems that this issue is bit adamant. > > After uninstalling and reinstalling, the message disappeared as i reported. > > But when i set to enter transactions this evening, the message again > reappeared. > > So I restarted computer and open gnucash, it opened without error message. I > tried to close gnu cash and reopen few times the error message appeared > randomly. > > Worse, i decided to update gnu cash on another laptop used by my wife. It > failed to install stating that it is unable to close service. I was forced to > abort the installation, re-start the laptop and then i only I could install > the update. > > So there seems some problem with New Version or the legacy issue of back > ground service running interfering the successful update. > > > Thanks > > Paras > > > Get Outlook for Android > From: john > Sent: Tuesday, December 19, 2023 10:37:19 PM > To: Paras Desai > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Gnu cash Version 5.5 error message > > Paras, > > Thanks for the followup. > > Regards, > John Ralls > > >> On Dec 19, 2023, at 00:17, Paras Desai wrote: >> >> Hello John >> >> I uninstalled the GNU cash completely after saving my account files. >> >> And then downloaded exe file again from sourceforge and reinstalled again. >> >> After reinstall, the problem and error message i reported earlier >> disappeared. >> >> I think some thing might have gone wrong during my earlier installation, >> though GNU cash showed successful installation. >> >> With my best regards and against thanks for your kind support as always >> >> Paras >> >> Ag >> >> Get Outlook for Android >> From: john >> Sent: Tuesday, December 19, 2023 9:43:52 AM >> To: Paras Desai >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Gnu cash Version 5.5 error message >> >> Paras, >> >> Sorry, I misinterpreted >> >>>> I find a message about lock file stating gnu cash instance is already >>>> running >> >> That's normal after a crash, which prevents GnuCash removing the lock file. >> You can safely click "Open Anyway" in that case. >> >> If you get the entry point error again could you take a screenshot? I can't >> find any references to "xmllOFTPClose" in any of our dependencies nor does >> Google find it. >> >> Regards, >> John Ralls >> >> >> >> >>> On Dec 18, 2023, at 17:57, Paras Desai wrote: >>> >>> Hello John. >>> >>> Thanks for your reply >>> >>> I did that. >>> Even I restarted the computer. >>> >>> But the problem persists. >>> >>> Paras >>> >>> Get Outlook for Android >>> From: john >>> Sent: Monday, December 18, 2023 9:24:14 PM >>> To: Paras Desai >>> Cc: gnucash-user@gnucash.org >>> Subject: Re: [GNC] Gnu cash Version 5.5 error message >>> >>> >>> >>> > On Dec 17, 2023, at 21:36, Paras Desai wrote: >>> > >>> > Hello sirs >>> > >>> > I tried to upgrade to latest version. >>> > >>> > >>> > After it uninstalled old version and reinstalled successfully, and when I >>> > tried to run the following message appeared >>> > >>> > >>> > [X] >>> > >>> > Gnucash.exe - Entry Point Not Found >>> > >>> > The procedure entry point xmllOFTPClose cloud not be located in the >>> > dynamic link library c: program files(x86)gnucash\bin\libxmlsec1.dll >>> > >>> > >>> > When I tried to ignore this message and click ok, I find a message about >>> > lock file stating gnu cash instance is already running >>> > >>> > I am on windows 10 >>> >>> Try killing the gnucash instance in Task Manager and restarting GnuCash >>> 5.5. I hope that's a leftover from 5.4. >>> >>> 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 - 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 5.5 Windows - included Net Worth Linechart report now crashes the UI
I've gotten it to crash for me in my VM. The stack trace says that it's crashing several dozen frames into the javascript engine. Unfortunately the MSYS build defaults to stripping the symbols so the trace doesn't tell me anything more. I'm rebuilding WebKitGtk with stripping turned off, but that will take a while... like a couple of days. Regards, John Ralls > On Dec 19, 2023, at 11:57 AM, WR D wrote: > > To test this, I created a new file (new account hierarchy which includes > supplied asset and liability accounts) - put a couple of dummy asset entries > (deposit cash to wallet and to the checking account). > > I then open the default Net Worth Linechart - it was empty (did not crash) so > then I went into the Config options and modified the date range to current > date, and made sure all asset and liability accounts were selected. When I > tried to apply those changes, the whole UI crashed. > > So to me it looks like having any data in that report will crash the report > and the entire UI (in Windows at least). > > Regards, > Bill > > > > -Original Message- > From: gnucash-user On > Behalf Of Adrien Monteleone > Sent: Tuesday, 19 December 2023 8:39 PM > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Gnucash 5.5 Windows - included Net Worth Linechart report > now crashes the UI > > This is the second thread about reports crashing on Windows. I'm not sure if > that is relevant, but like the other thread, I just tested the Net Worth > Linechart with a simple file using the flatpak in a Linux VM and it does not > crash. It produces the Linechart as expected. > > So this is either something Windows specific, or specific to your book. > > Regards, > Adrien > > On 12/19/23 2:04 AM, WR D wrote: >> Hi, >> >> Installed Gnucash 5.5 for Windows. >> >> I notice that running the included report Net Worth Linechart (under Assets >> & Liabilities) almost immediately crashes the UI - no message that I can >> see. The LCK file is left open as well. >> >> I found this out when I tried to run one of my saved report configurations >> which was based on this one. I deleted the custom configuration and just >> tried to run the default one but see same behaviour. >> >> This was not a problem under 5.4 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] ANNOUNCE: GnuCash 5.5 Released
an, Dutch, English (Australia), English (New Zealand), English (United Kingdom), Finnish, German, Gujarati, Hungarian, Italian, Norwegian Bokmål, Polish, Portuguese, Portuguese (Brazil), Romanian, Russian, Slovak, Spanish, Swedish Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/ Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced Documentation No changes were associated with bug reports between releases 5.4 and 5.5 The following fixes and improvements were not associated with bug reports: • EBICS: for business customers (of the bank) rather than business users. • docbook: additional entities for business GUI-elements • docbook: gnc-gui-*: Rename the scheduled edit/new/delete menus to match a change in the program. New and Updated Translations: German Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. GnuCash is also available as a flatpak from Flathub.org. Instructions for installing and running: https://wiki.gnucash.org/wiki/Flatpak The SHA256 Hashes for the downloadable files are: • b4daf67bb892b706323f62e9fa97242039d7dd0a2e1e10771e0c25817dd0ed3b gnucash-5.5.tar.bz2 • 73d2c367f7f1c2da045ce08cb7dfc619e43002ac1e17bb708e3287edff96ae47 gnucash-5.5.tar.gz • 720a60dca57e4199f28b5449158ddc89e62012f042a62c43b16c569fa0890275 gnucash-5.5.setup.exe • a27ab3dd3ada69456cb8033473f7bab5ae5874a4880416672d9b4fd2e1c26408 Gnucash-Intel-5.5-1.dmg • 93560f55d9305aef45525cf7e7143b72503365c353840dfaaa382d9dfb97c8ab gnucash-docs-5.5.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/5.5/gnucash-5.5.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.5/gnucash-5.5.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/5.5/Gnucash-Intel-5.5-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.5/Gnucash-Intel-5.5-1.dmg Getting GnuCash as source code If you want to compile GnuCash 5.5 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/5.5/gnucash-5.5.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/5.5/gnucash-5.5.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.5/gnucash-5.5.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.5/gnucash-5.5.tar.gz To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation Note that the documentation for unstable releases is not on the GnuCash website. It is built daily and may be found on the development server under the locale directory; "C" is English, "de" is German, and so on. The documentation is included in the MacOS and Windows application bundles. If you want to compile the GnuCash Documentation 5.5 for yourself, the source code can be downloaded from: Sourceforge: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.5/gnucash-docs-5.5.tar.gz GitHub: https://github.com/Gnucash/gnucash/releases/download/5.5/gnucash-docs-5.5.tar.gz You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] UI Problem with 4.14
> On Dec 13, 2023, at 11:01 AM, Manfred Usselmann wrote: > > Am 2023-12-13 19:32, schrieb Manfred Usselmann: >> Am 2023-12-12 05:23, schrieb Adrien Monteleone: >>> On 12/11/23 4:21 PM, Manfred Usselmann wrote: >>>> Yes, but then much more screen space is used. The border is there even >>>> with single lines, just without a visible border line. When you move the >>>> cursor there it changes to the double arrow indicating the possibility to >>>> resize. >>>> I believe the border is missing because the header text for the accounts >>>> column is missing. >>>> Yesterday I saw the header text for some accounts but it went away after a >>>> while. Very strange. >>> The label is there, but only in Basic View. >>> Split & Transaction Journal do not have it. >>> I'd say that is a bug. >> You are right, definitely a long standing bug. With View Double Line and >> Active Complete (Whatever it is called, I've got a different translation) >> the label is missing, with Single Line it is there. > > Bug entered: https://bugs.gnucash.org/show_bug.cgi?id=799163 > ___ Manfred didn't describe very well what he was seeing, but his screenshots on the bug make it clear. This is a feature not a bug. When the register is in split view the header changes depending on the selected row. When the selected transaction is in split view the transaction row has nothing in the account or reconcile column; those headings are accordingly blank; the transaction row has the date, the number, the description, along with the total (really net) credit or debit and the balance for the selected register and the header labels reflect that. Move the focus to a split row and the headers change to action, memo, account, reconcile status, debit, and credit reflecting the split information that's displayed in the selected row. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.
Oops, I guess you don't *quite* get how to use the mailing list: Always use reply-all so that your reply goes to the list, not just to the person you're replying to. Regards, John Ralls > On Nov 21, 2023, at 4:23 PM, sailing wrote: > > Great! Thank you. > > > > +} > > > Original message > From: John Ralls > Date: 11/21/23 6:49 PM (GMT-05:00) > To: Elven Decker > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Account reconciliation -- Gnucash's beginning balance is > incorrect. > > > > > On Nov 21, 2023, at 12:35 PM, Elven Decker wrote: > > > > Not sure how to use this help thread, but I have had a similar problem > > years ago which recently started happening again. I solve it by exiting > > the reconciliation window and then re-opening it. When the small reconcile > > information window opens, I click on the "Statement Date" drop-down and > > choose the correct date by hand. This forces some kind of re-computation of > > the beginning and ending balances. > > You seem to have figured out the mailing list. > > No need to quit and restart the reconcile, though: You can edit the reconcile > information with Reconcile>Reconcile Information... from the reconcile > window's menu. > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.
> On Nov 21, 2023, at 12:35 PM, Elven Decker wrote: > > Not sure how to use this help thread, but I have had a similar problem years > ago which recently started happening again. I solve it by exiting the > reconciliation window and then re-opening it. When the small reconcile > information window opens, I click on the "Statement Date" drop-down and > choose the correct date by hand. This forces some kind of re-computation of > the beginning and ending balances. You seem to have figured out the mailing list. No need to quit and restart the reconcile, though: You can edit the reconcile information with Reconcile>Reconcile Information... from the reconcile window's menu. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help pages not showing
> On Nov 17, 2023, at 9:06 AM, Stephen Cohoon wrote: > > When I access the help button on the account edit window or from the help | > contents menu I get a blank window. Running Flathub 5.4.1 on Pop!_OS 22.04 > LTS Linux. Is this a known problem? Not to me, and it works correctly for me on Debian 12. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash_user: rounding errors and significant digits
> On Oct 6, 2023, at 9:39 AM, Bruce McCoy via gnucash-user > wrote: > > Hi Everyone, > On Tue, Sep 26 at 12:50 PM John Ralls wrote:>GnuCash uses a pair of > stack-allocated 128-bit integers (see. . . > > Thanks. Well done. > > > What are the plans to help our users whose books are out of balance by a cent > or so? GnuCash's rounding isn't likely to put books out of balance because GnuCash forces transactions to be balance in the transaction currency. Book out of balance, meaning that the trial balance report doesn't balance with the Average Cost price source, nearly always results from not computing capital gains/losses correctly. Interpret that broadly: Computing cost of goods sold is the same calculation by a different name and often crossing more transaction steps. GnuCash automates only the simplest case via the lot scrubber so it's pretty much up to the user to be meticulous when creating those splits/transactions. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] W11-Installing Gnucash to D Drive
It does, but only if you don't have GnuCash already installed: If you do it replaces the existing installation. So if you want to change where GnuCash is installed you have to uninstall GnuCash first. Right-click on the Start icon, select Apps & Features, scroll down to GnuCash and click it, click Uninstall, approve the User Authorization Escalation, and click through the dialogs. Regards, John Ralls > On Oct 6, 2023, at 9:31 AM, kschneider bout-tyme.net > wrote: > > It’s been awhile since I installed GNC. Does the installer ask for an > installation path? > Ken Schneider > >> On Oct 6, 2023, at 12:25 PM, Veli Izzet wrote: >> >> Hi, >> >> I want to install Gnucash to D: drive, not to c: drive. Installer does not >> ask for the installation drive though. >> >> Any help? >> >> Thanks >> >> -- >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue with default invoice template
> On Oct 3, 2023, at 8:42 AM, Alan Johnson via gnucash-user > wrote: > > Hello, > > I'm using GNUCash 5.4, flathugb 5.4.1, finance quote 1.58 on Ubuntu > 23.04. > > I edited the template for invoices successfully. However, when I go to > a customer account and go to print an invoice, it changes to the > default invoice template every time. > > I've made the changes under Options and Applied / hit OK. I've tried > Save Config, but alas it does not stick. > > How can I make it so when I print an invoice it will use my selected > template every time by default? >From File>Properties select the Business tab and scroll down to Default >Invoice Report, just under the company info block. Select your custom report >from the drop down. 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 - 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 5.4 Repackaged
Right. The build ID is supposed to be "5.4+". Sorry if that wasn't clear from the announcement. The new gnucash-5.4-1.setup.exe has it right, see the attached screenshot. As I said, if this doesn't bother you you needn't do anything. > On Sep 28, 2023, at 12:46 PM, Ken Pyzik wrote: > > I'm not a Linux user (I'm Windows 11) - but here is what the splash screen > says for Windows (attached below). If the picture does not show - I have > also attached a .jpg picture. It clearly says Version 5.4 - but the Build ID > looks like 5.3 something. It is dated 9/23/2023. > > > > Not sure if this is helpful or not - but sending it on just in case. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 5.4 Repackaged
An astute flatpak user noticed that the version reflected in the splash screen and About GnuCash window wasn't quite right, showing the release commit as a revision of 5.3 instead of plain 5.4. I tracked the problem back to the tarball generation, so I've made new tarballs, AIO bundles, and flatpak release with the following names and SHA256 hashes. Nothing functional is changed so if you don't care about the version string there's no need to download except that distro packagers will probably want to use the new tarballs to avoid confusing their users. 7741165d6d652ea7b4a1e8498cf439a56b81a5cc8b653291a59054f2362abfcc gnucash-5.4-1.tar.bz2 7989c2fff67ff356e99c9a4b8d90a7759c7bde73844afb0595ee1322f4a19ced gnucash-5.4-1.tar.gz e1925591bb80b1ff8ddf0634652ef098072bd96a5bb98f000cdcc5c841ff gnucash-5.4-1.setup.exe ffe311fd2077cf1df15c253a5e062dc3801fa9db06829d3d12184184727e89c8 Gnucash-Intel-5.4-2.dmg e2a93460e7768b1b18e466e352ac13212b75094be6334ca0427b6cd4f66d8793 gnucash-docs-5.4.tar.gz 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Window resizing issues on MacOS
Adrien, I don't see any resizing issues with 5.4. Late 2013 Mac Pro/macOS 12.6 and 2022 M1 Mini/macOS 15 Developer beta from a month ago. The window shrinks to too small to be useful. Does the resize cursor change from double headed to single headed when it declines to shrink any more? Regards, John Ralls > On Sep 27, 2023, at 7:51 PM, Adrien Monteleone > wrote: > > Thanks. That is interesting. > > This appears to be perhaps an issue with MacOs then. > > Regards, > Adrien > > On 9/27/23 8:30 PM, Jediator wrote: >> I haven't encountered any window resizing issue on Ventura 13.5. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] ANNOUNCE: GnuCash 5.4 Released
ucash/ Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced Documentation Concurrent with the release of GnuCash 5.4 we're pleased to also release a new version of the companion Manual and the Tutorial and Concepts Guide: Between 5.2 and 5.4, the following bugfixes were accomplished: Bug 799074 - Incorrect note re cash page in stock-txn-assistant The following fixes and improvements were not associated with bug reports: Add a Chinese translation for the Tutorial and Concepts Guide. Update git branches for API docs Refactor the build system feature for adding customized xslt files. Bump minimum cmake version to 3.14 to keep it in sync with the gnucash repo Fix race condition in creating symlinks for the kde help system. Update GitHub actions/checkout to v3 in all actions and add nightly-build github workflow. Manual (C,de): Replace obsolete 'gnc-fq-*' with 'gnucash-cli --quotes *' Guide (C,de,ru): Repair broken links from 'help' to 'manual' Guide (C,de), ch_invest: Remove section 'Finance::Quote install' Manual (C, de) Update F::Q screens to 1.57 Change version 4 to 5, branch maint to stable, and update Finance::Quote docs to reflect changes in GnuCash. New and Updated Translations: German The SHA256 Hashes for the downloadable files are: 9a069fe2bfea7ddf8afb90a523beab02a0963e9f1d4c36da9c91aef74787f354 gnucash-5.4.tar.bz2 9d3eb3cd63730cf34d4c14dea6921bfe57f3936e0ca6e17ffc04c38dc1b40061 gnucash-5.4.tar.gz 5bfed628750fc034b56fc6285a1b7b0bf9bc8aa1d831e7a946d523be27351d48 gnucash-5.4.setup.exe bd121cc9a15368a02501462151a948b3f460effd0e4ce7f01a2d96739e64ae1b Gnucash-Intel-5.4-1.dmg e2a93460e7768b1b18e466e352ac13212b75094be6334ca0427b6cd4f66d8793 gnucash-docs-5.2.tar.gz Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. GnuCash is also available as a flatpak from Flathub.org. Instructions for installing and running: https://wiki.gnucash.org/wiki/Flatpak The SHA256 Hashes for the downloadable files are: Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/5.4/gnucash-5.4.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.4/gnucash-5.4.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/5.4/Gnucash-Intel-5.4-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.4/Gnucash-Intel-5.4-1.dmg Getting GnuCash as source code If you want to compile GnuCash 5.4 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/5.4/gnucash-5.4.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/5.4/gnucash-5.4.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.4/gnucash-5.4.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.4/gnucash-5.4.tar.gz To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation Note that the documentation for unstable releases is not on the GnuCash website. It is built daily and may be found on the development server under the locale directory; "C" is English, "de" is German, and so on. The documentation is included in the MacOS and Windows application bundles. If you want to compile the GnuCash Documentation 5.4 for yourself, the source code can be downloaded from: Sourceforge: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.4/gnucash-docs-5.4.tar.gz GitHub: https://github.com/Gnucash/gnucash/releases/download/5.4/gnucash-docs-5.4.tar.gz You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. 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 - Please remember to CC this list on all your replies. You c
Re: [GNC] Gnu Cash stopped working 2 days ago.
David, Having a 25-1-22.gnucash.LCK.gcm suggests that you might have tried to open 25-1-22.gnucash.LCK instead of 25-1-22.gnucash at some point. That obviously won't work as there's nothing in a lock file. You might also have a 25-1-22.gnucash.LCK.LCK in the folder with your book file. You should delete that as well. Regards, John Ralls > On Sep 24, 2023, at 11:53 AM, (Alan) David Smith > wrote: > > Hello John, > > I have spotted 2 files named: David Smith Money Final 25-1-22.gnucash.LCK.gcm > David Smith Money Final 25-1-22.gnucash.gcm > > I have transferred both to bin. One is a LCK file. > > Gnucash is now opening as normal. Does it matter that one is a LCK file? > > Thank you for this. > > Regards, > > David > > On 24/09/2023, 19:16, "John Ralls" wrote: > >David, > >> On Sep 17, 2023, at 6:32 AM, (Alan) David Smith >> wrote: >> >> Exception Type:EXC_BAD_ACCESS (SIGSEGV) >> Exception Codes: KERN_INVALID_ADDRESS at 0x0039 >> Exception Codes: 0x0001, 0x0039 >> >[snip] >> Thread 0 Crashed:: Dispatch queue: com.apple.main-thread >> 0 libglib-2.0.0.dylib 0x10dbebb44 >> g_hash_table_lookup + 36 >> 1 libgnc-engine.dylib 0x10d6a2335 >> gncTaxTableGetTables + 21 >> 2 libgnc-gnome.dylib 0x109dd90b2 >> gnc_simple_combo_generate_liststore + 50 >> 3 libgnc-gnome-utils.dylib 0x10a26099e >> gnc_gui_refresh_internal + 222 >> > >That seems to point to an invalid hash table in the book object, though I > don't see in the code where that would happen. Regardless, try this: >* Open a Finder window and select Go>Go to folder from the menu or press > shift-command-g. >* In the dialog type ~/Library/Application Support/Gnucash/books. >* Find the file corresponding to your data file name with a .gcm > extension, e.g. "my_file.gcm" and move it to Trash. >* Start GnuCash > >I think you have an invoice tab open and something about its Tax Table > listbox is causing GnuCash to crash. Removing the .gcm file will start > GnuCash with only the Accounts tab and if I'm right will avoid the crash. > >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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnu Cash stopped working 2 days ago.
David, > On Sep 17, 2023, at 6:32 AM, (Alan) David Smith > wrote: > > Exception Type:EXC_BAD_ACCESS (SIGSEGV) > Exception Codes: KERN_INVALID_ADDRESS at 0x0039 > Exception Codes: 0x0001, 0x0039 > [snip] > Thread 0 Crashed:: Dispatch queue: com.apple.main-thread > 0 libglib-2.0.0.dylib 0x10dbebb44 > g_hash_table_lookup + 36 > 1 libgnc-engine.dylib 0x10d6a2335 > gncTaxTableGetTables + 21 > 2 libgnc-gnome.dylib 0x109dd90b2 > gnc_simple_combo_generate_liststore + 50 > 3 libgnc-gnome-utils.dylib 0x10a26099e > gnc_gui_refresh_internal + 222 > That seems to point to an invalid hash table in the book object, though I don't see in the code where that would happen. Regardless, try this: * Open a Finder window and select Go>Go to folder from the menu or press shift-command-g. * In the dialog type ~/Library/Application Support/Gnucash/books. * Find the file corresponding to your data file name with a .gcm extension, e.g. "my_file.gcm" and move it to Trash. * Start GnuCash I think you have an invoice tab open and something about its Tax Table listbox is causing GnuCash to crash. Removing the .gcm file will start GnuCash with only the Accounts tab and if I'm right will avoid the crash. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnu Cash stopped working 2 days ago.
log.conf is not necessary to generate trace files. If it was GnuCash would automatically create a default. David may still be misled by the typos in my earlier message. Ken Farley corrected them. The tracefile can be found via Terminal with $TMPDIR/gnucash.trace. One can redirect it to somewhere else with the --logto option, e.g. /Applications/Gnucash.app/Contents/MacOS/Gnucash --logto $HOME/gnucash_errors will write it to a file named "gnucash_errors" in the user's home directory. The original error message David posted, > > (process:46072): gnc.gui-WARNING **: 20:54:04.010: [mac_set_languages()] > Language list: en:en_GB:C > Backtrace: > 3 (apply-smob/1 #) > In ice-9/boot-9.scm: > 2312:4 2 (save-module-excursion #) > In ice-9/eval-string.scm: > 36:6 1 (read-and-eval # #:lang _) > In unknown file: > 0 (read #) > > ERROR: In procedure read: > In procedure string->number: Value out of range: 9739 > is a scheme backtrace. It has nothing at all to do with the backend nor could it be emitted by a SQL server or SQLite3. Regards, John Ralls > On Sep 24, 2023, at 9:59 AM, Jediator wrote: > > David, You need to create the log.conf file manually first on your Mac to > enable tracing. Please see this thread for details > (https://lists.gnucash.org/pipermail/gnucash-user/2023-September/108759.html). > > Are you using the default sqlite as the GC database? The error message of > "procedure value out of range" you posted indicates this might be a database > problem. If you are on a Mac, your can just run /sqlite3 your_db.gnucash /to > see if this would spit out any errors. Once you are in the sqlite shell, run > the /analyze/ command to check the table/index consistency. > > Good luck! -- JC > > > On 9/24/23 8:25 AM, (Alan) David Smith wrote: >> I have tried this. Thank you very much for your help but there is still no >> trace file visible anywhere. >> >> May be version 5.4 will work on my Apple when available, otherwise it looks >> as though GNUCash has permanently stopped working on my apple computer. >> >> Regards, >> >> David >> >> On 17/09/2023, 17:13, "(Alan) David Smith" >> wrote: >> >> There is still no trace file. But you now have crash report. >> >> On 17/09/2023, 15:13, "gnucash-user on behalf of Ken >> Farley"> behalf of farle...@gmail.com> wrote: >> >> I think you might be missing some of the steps you were asked to >> perform, so here they are: >> >> (1) Run Gnucash while telling it to save a trace file. This file >> lists >> all the actions of the program. This is done with the command (on >> MacOS): >> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug >> >> This will run Gnucash, presumably until it crashes, while writing a >> trace file in the directory specified by the environment variable >> TMPDIR >> on your system. >> >> (2) To make the trace file more accessible, you copy it to your user >> directory. To be sure it's in this location, perform the following >> two >> commands: >> >> cd >> >> cp $TMPDIR/gnucash.trace . >> >> (3) Now that you have this tracefile, you want to provide it to the >> folks on the mailing list who can interpret such things. Since it's >> likely a very long file, it is not a good idea to copy and paste it's >> contents into a message. Instead, when you reply to the mailing list, >> you attach the file to the message, usually by dragging and dropping >> the >> file in Outlook, or using the "Attach File" button, etc. >> >> >> Hopefully, if you do these things, someone will be able to figure out >> where your installation is going wrong. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/ma
Re: [GNC] How to display Job Report
That's https://bugs.gnucash.org/show_bug.cgi?id=798998. It's fixed in GnuCash 5.4 that will be released this weekend. Regards, John Ralls > On Sep 22, 2023, at 2:43 AM, Jediator wrote: > > Hi GC users, I can't figure out how to display a job report. The menu item > Report->Business->Job Report shows empty content and there is no job > selection under report options. The user's manual left this part incomplete. > Is this function still under development? I am using GC version 5.3. > Thanks in advance! -- JC > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fancy Date Format in Book Options keeps resetting
No, it's a new bug, something I screwed up when rewriting the options system last year. Regards, John Ralls > On Sep 14, 2023, at 2:10 PM, Murugan Muruganandam > wrote: > > This bug was fixed earlier seems to be not working. i have requested for a fix > > > > https://bugs.gnucash.org/show_bug.cgi?id=645786 > > > Saludos Cordiales > > > Murugan > > > From: gnucash-user > on behalf of > Raghavendra Kamath via gnucash-user > Sent: Thursday, September 14, 2023 12:14 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Fancy Date Format in Book Options keeps resetting > > Hi > > I am setting up gnucash and when I set Fancy Date Format to `%d-%m-%Y` in > business section of book options. it keeps resetting to "No Fancy Date > Format" and the date is used from the option set in the preferences. > > Am I doing anything wrong? I want this format to appear on the invoices how > to achieve this? > > Thank you > > -- > Raghavendra Kamath > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Porting Auto Completion from v4 to v5
Then go look for yourself: Open your data file in a text editor and search for a transaction description. Lines beginning with are the description part of a transaction. See if you find the text anywhere else. Regards, John Ralls > On Sep 14, 2023, at 10:37 AM, sunfis...@yahoo.com wrote: > > Oh. OK. > > But that doesn't match up with the assertions that users have made that the > auto complete "resets" with the new version of GnuCash. If the auto complete > feature is regenerated as you state, then that wouldn't be happening. An > upgraded install would have a complete auto complete data set based on > existing data. Others have said that this isn't the case, though. > > So, I don't know whose experience is more true. > > David T. > On Sep 14, 2023, at 8:20 PM, john wrote: > > > On Sep 13, 2023, at 21:01, sunfish62--- via gnucash-user > wrote: > > Hello, > > In another thread, it was noted that the latest version of auto complete in > version 5 of GnuCash restarts the auto completion data store. That gave me > pause, as I make use of the feature extensively to speed the entry of > transactions for a large number of stocks and mutual funds. (I start each > transaction with the ticker symbol, making each very quick to enter) > > As a non programmer, I wonder idly whether there would be some way of > grabbing the information out of the earlier copy, and pushing that data into > the newer version. It would certainly help my use case. > > Could a normal (well, on some levels) person actually locate this data store > in a file somehow, and then-- oh, I don't know-- copy and paste that > information into another file to jumpstart their 5.x experience? > > David, > > The auto-completion data store is not and never has been saved. It's > generated from the transaction and current-account-split text fields when you > open a register tab. > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Versions after 4.13 freeze in splash screen
Yesterday's tracefile showed a successful login to the `gnucash` database, today's shows a connection failure. Notice that after the login failure it didn't do anything except load the currencies, something that's hardcoded in GnuCash. Yesterday's got into a loop trying to run a scrub on budgets; that scrub is part of the 4.x->5.x upgrade process. The "Bad or corrupt database" error can indeed come from a login failure, but there are lots of other errors that can produce it and you have to look in the tracefile to see which one. Today's tracefile says: * 06:54:25 INFO [QofSessionImpl::load_backend] Selected provider GnuCash Libdbi (MYSQL) Backend * 06:54:25 INFO [error_handler] DBI error: 1045: Access denie d for user 'gnucash'@'localhost' (using password: YES) * 06:54:25 INFO [error_handler] Note: GbcDbiSqlConnection not yet initialized. Skipping further error processing. * 06:54:25 ERROR [GncDbiBackend::session_begin()] Unable to connect to database 'gnucash' That confirms that you have an authentication problem. If you're using the same userid for both the InitFin and gnucash databases maybe you just need to grant access to that user on the gnucash db. I'd like to know the circumstances surrounding the trading accounts creating transactions with no account. That would be a pretty bad bug. Regards, John Ralls > On Sep 11, 2023, at 10:22 PM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 13:23 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 11:48 AM, John Ralls >>> wrote: >>> >>> >>> >>>> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera >>>> wrote: >>>> >>>> >>>> To answer you questions >>>> (1) other than the register I keep always open another 5 tabs ( >>>> reports, views ) no other window open. >>>> (2) No I have not uninstalled AQBanking >>>> >>>> To add more into the mystery, I installed the flatpak and when I >>>> tried >>>> to open it it asked me for credentials. Since I maintain multiple >>>> dbs, >>>> for different entities, I entered a different db this time and >>>> gnucash >>>> opened it. When I tried to change back to my main db it produced >>>> the " >>>> The server at experienced an error or encountered bad or >>>> corrupt >>>> data". I know that my db is ok since I can still access it from >>>> the >>>> 4.13 installation. >>> >>> Interesting. Does that other DB open in the debian testing build of >>> GnuCash? >>> >>> There should be more detailed error information in the tracefile >>> about the connection failure and perhaps more information in your >>> MariaDB logs. >>> >>> What version of MariaDB are you running? We've had reports of >>> problems with MariaDB 11. >> >> >> Looking some more at your tracefile I think something else is going >> on, but I don't know what it might be. It seems to be repeating the >> budget-balance scrubs in between groups of 7 or 8 sets of AQBanking >> interface complaints; that would be one per open tab. >> >> Early on there are 356 errors from the load code about splits with no >> accounts, after which there are no messages from the backend. >> >> Regards, >> John Ralls >> > To answer your questions: > (1) mariadb version is 10.3.39, so no 11 > (2) Yes, now that I tried it, the debian build of gnucash opens the > other db as well. Furthermore, when trying to change from that db to > the other one and get again the bad or corrupt data error message. I am > attaching you the gnucash_trace file from that operation. The db that > opens is called InitFin while the other one is simply called gnucash. > (3) Furthermore, I am attaching you the log from mariadb. Strangely > there is only one line denying access to the user. Question, does the > corrupt or bad data message gets produced when wrong password is > entered? I haven't changed the user password but this message implies > that there is an authentication problem. > (4) Regarding the 356 no account errors, I think those come from the > trade accounts functionality that I have enabled and is prone to > produce transactions with no accounts under some circumstances. I do > not think that those are the problem. > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where are GC log files located on Mac with remote database server?
Yes, log.conf is a user-created file, there is no default. Note that that's about the tracefile (https://wiki.gnucash.org/wiki/Tracefile), not the transaction logs. Regards, John Ralls > On Sep 11, 2023, at 12:46 PM, Jediator wrote: > > Thanks John! Apparently in version 5.3 on Mac, the data directory and config > directory of GC is the same on Mac at /Users/username/Library/Application > Support/GnuCash, and the log files are in the translog directory underneath. > However, the log.conf file is nowhere to find (supposed to be located at > GNC_CONFIG_HOME > <https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_CONFIG_HOME>/log.conf > according to https://wiki.gnucash.org/wiki/Logging). > > Should I create a log file manually if the I want to use a non-default > configuration? Thanks! > -- JC > > > On 9/11/23 12:30 PM, john wrote: >> The MySQL and PostgresQL backends write the transaction logs to >> GNC_CONFIG_DIR/translog. >> Seehttps://wiki.gnucash.org/wiki/Configuration_Locations to see where >> GNC_CONFIG_DIR is on your OS. >> >> Regards, >> John Ralls >> >> >>> On Sep 11, 2023, at 06:56, Adrien >>> Monteleone wrote: >>> >>> I'm using sqlite on Mac and I have log files. Though I don't see them >>> generated often. I'm not sure if that is because I rarely close the app >>> except for updates. >>> >>> Regards, >>> Adrien >>> >>> On 9/11/23 4:15 AM, sunfish62--- via gnucash-user wrote: >>>> Others will correct me, but my understanding is that the log files are not >>>> used with the database backend, since the changes are committed >>>> immediately. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 11:48 AM, John Ralls wrote: > > > >> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera >> wrote: >> >> >> To answer you questions >> (1) other than the register I keep always open another 5 tabs ( >> reports, views ) no other window open. >> (2) No I have not uninstalled AQBanking >> >> To add more into the mystery, I installed the flatpak and when I tried >> to open it it asked me for credentials. Since I maintain multiple dbs, >> for different entities, I entered a different db this time and gnucash >> opened it. When I tried to change back to my main db it produced the " >> The server at experienced an error or encountered bad or corrupt >> data". I know that my db is ok since I can still access it from the >> 4.13 installation. > > Interesting. Does that other DB open in the debian testing build of GnuCash? > > There should be more detailed error information in the tracefile about the > connection failure and perhaps more information in your MariaDB logs. > > What version of MariaDB are you running? We've had reports of problems with > MariaDB 11. Looking some more at your tracefile I think something else is going on, but I don't know what it might be. It seems to be repeating the budget-balance scrubs in between groups of 7 or 8 sets of AQBanking interface complaints; that would be one per open tab. Early on there are 356 errors from the load code about splits with no accounts, after which there are no messages from the backend. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 10:15 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 9:33 AM, john wrote: >>> >>> >>> >>>> On Sep 11, 2023, at 09:24, zuperkoleoptera >>>> wrote: >>>> >>>> On Mon, 2023-09-11 at 09:13 -0700, john wrote: >>>>> >>>>> >>>>>> On Sep 11, 2023, at 02:29, zuperkoleoptera >>>>>> wrote: >>>>>> >>>>>> Hi, >>>>>> >>>>>> I use gnucash under Debian testing with the mariadb backend, >>>>>> through an >>>>>> ssh tunnel to a VPS I maintain. >>>>>> Version of the mariadb is 10.3.39. >>>>>> Everything worked as normal, until I upgraded in version 5.1 >>>>>> from >>>>>> 4.13 >>>>>> where gnucash seemed to start but then remained indefinitely >>>>>> in the >>>>>> splash screen occasionally bringing forward the "Gnucash not >>>>>> responding" error with the option to wait or to force quit >>>>>> it. >>>>>> If I pressed wait nothing happened until the error screen >>>>>> appeared >>>>>> again. >>>>>> >>>>>> I waited until gnucash version 5.3 was migrated to Debian >>>>>> testing >>>>>> but >>>>>> the issue has not been resolved. >>>>>> I have an older box with Debian testing that still runs 4.13 >>>>>> and is >>>>>> still operational, so for the time being I use that one. >>>>>> >>>>>> I am attaching the gnucash_trace file from the box with the >>>>>> 5.3 >>>>>> version. >>>>>> If needed I have the gnucash_trace also from the one running >>>>>> 4.13. >>>>>> >>>>>> Any ideas? >>>>>> __ >>>>>> _ >>>>> >>>>> The tracefile shows 10 minutes of >>>>> 10:59:29 INFO >>>>> [gnc_main_window_set_vis_of_items_by_action] Found menu_item >>>>> 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting >>>>> vis to >>>>> 'true' >>>>> >>>>> For most, but not all, of the AQBanking actions registered by >>>>> the >>>>> AQBanking plugin. I haven't yet tracked down why GnuCash would >>>>> get >>>>> stuck in a loop trying to load the plugin, but I guess there's >>>>> also a >>>>> packaging problem with the 5.x .deb that you're using. I can't >>>>> tell >>>>> you what it might be until I figure out what's causing the >>>>> loop. >>>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>> Is there a way to disable AQBanking plugin in application start? >>>> I >>>> don't use it so I do not care. >>> >>> Not at runtime. GnuCash can be built without AQBanking support. >>> >>> You could try using the flatpak instead. >> >> Two more questions: Do you have a bazillion tabs or windows open? >> Have you uninstalled AQBanking because you don't use it? >> >> Regards, >> John Ralls > > To answer you questions > (1) other than the register I keep always open another 5 tabs ( > reports, views ) no other window open. > (2) No I have not uninstalled AQBanking > > To add more into the mystery, I installed the flatpak and when I tried > to open it it asked me for credentials. Since I maintain multiple dbs, > for different entities, I entered a different db this time and gnucash > opened it. When I tried to change back to my main db it produced the " > The server at experienced an error or encountered bad or corrupt > data". I know that my db is ok since I can still access it from the > 4.13 installation. Interesting. Does that other DB open in the debian testing build of GnuCash? There should be more detailed error information in the tracefile about the connection failure and perhaps more information in your MariaDB logs. What version of MariaDB are you running? We've had reports of problems with MariaDB 11. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 9:33 AM, john wrote: > > > >> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: >> >> On Mon, 2023-09-11 at 09:13 -0700, john wrote: >>> >>> >>>> On Sep 11, 2023, at 02:29, zuperkoleoptera >>>> wrote: >>>> >>>> Hi, >>>> >>>> I use gnucash under Debian testing with the mariadb backend, >>>> through an >>>> ssh tunnel to a VPS I maintain. >>>> Version of the mariadb is 10.3.39. >>>> Everything worked as normal, until I upgraded in version 5.1 from >>>> 4.13 >>>> where gnucash seemed to start but then remained indefinitely in the >>>> splash screen occasionally bringing forward the "Gnucash not >>>> responding" error with the option to wait or to force quit it. >>>> If I pressed wait nothing happened until the error screen appeared >>>> again. >>>> >>>> I waited until gnucash version 5.3 was migrated to Debian testing >>>> but >>>> the issue has not been resolved. >>>> I have an older box with Debian testing that still runs 4.13 and is >>>> still operational, so for the time being I use that one. >>>> >>>> I am attaching the gnucash_trace file from the box with the 5.3 >>>> version. >>>> If needed I have the gnucash_trace also from the one running 4.13. >>>> >>>> Any ideas? >>>> ___ >>> >>> The tracefile shows 10 minutes of >>> 10:59:29 INFO >>> [gnc_main_window_set_vis_of_items_by_action] Found menu_item >>> 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to >>> 'true' >>> >>> For most, but not all, of the AQBanking actions registered by the >>> AQBanking plugin. I haven't yet tracked down why GnuCash would get >>> stuck in a loop trying to load the plugin, but I guess there's also a >>> packaging problem with the 5.x .deb that you're using. I can't tell >>> you what it might be until I figure out what's causing the loop. >>> >>> Regards, >>> John Ralls >>> >> Is there a way to disable AQBanking plugin in application start? I >> don't use it so I do not care. > > Not at runtime. GnuCash can be built without AQBanking support. > > You could try using the flatpak instead. Two more questions: Do you have a bazillion tabs or windows open? Have you uninstalled AQBanking because you don't use it? 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock quotes hung
Unfortunately no. The Securities window can show which ones are set (click the arrow at the right end of the header row and check Get Quotes) but the control isn't sensitive so you have to double-click on each line item and change it in the Security Editor dialog box. Regards, John Ralls > On Sep 9, 2023, at 2:41 PM, Fred Tydeman wrote: > > Is there an easy way to add or remove Get Quotes for many stocks at a time? > > On Sat, Sep 9, 2023 at 11:50 AM john wrote: > > GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The > info and dump commands were added to gncuash-cli --quotes in 5.0. > > FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem isn't > with Yahoo! messing with their URI again. Most likely there's an issue with > one of your more thinly-traded securities, so repeat the triage steps from > when this happened a few weeks ago to figure out which one. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Who this "Jim" is, and intermittent delivery of gnucash-user posts [was: Re: gnucash_user: rounding errors and significant digits]
Jim,
And I'm sorry for making you waste your time investigating that. I didn't check
the archive, I searched my local mailbox on the subject ("gnucash_user:
rounding errors and significant digits") and turned up only Bruces most recent
two posts. Armed with the date from your 108251 link I looked in my mailbox on
that date and found your posts.
Regards,
John Ralls
> On Sep 9, 2023, at 2:10 PM, Jim DeLaHunt wrote:
>
> I'm sorry, I made a mistake in my message below.
>
> The Jim message which Bruce was quoting, in the Bruce message to which John
> replied, did in fact make it to the gnucash-user list archive[4], but in
> August, so of course it was not in the September archive[1].
>
> Thus, the list archive is not evidence for intermittent delivery of my
> gnucash-user posts. Maybe there is in fact no delivery problem.
>
> Sorry for the confusion,
> —Jim "Jim" DeLaHunt
>
> [1]
> <https://lists.gnucash.org/pipermail/gnucash-user/2023-September/thread.html>
> [4] <https://lists.gnucash.org/pipermail/gnucash-user/2023-August/108521.html>
>
> On 2023-09-09 13:25, Jim DeLaHunt wrote:
>> On 2023-09-09 12:36, john wrote:
>>> I don't know who this "Jim" is, their replies are not making it to the
>>> list
>> Oh dear. I spend time writing my messages to Bruce McCoy. It would be a pity
>> if they didn't make it to the list.
>>
>> This "Jim" is me, Jim DeLaHunt .
>>
>> The Jim message which Bruce was quoting, in the Bruce message to which John
>> replied, did not make it to the gnucash-user list archive[1]. However, I
>> did receive a copy of my reply via the gnucash-user email list[2] at the
>> time. The reply which I sent to the Bruce message today did in fact get to
>> the archive[3]. So maybe my messages are intermittently failing to reach
>> some gnucash-user recipients?
>>
>> Looking at the other headers, I wonder if maybe some spam detection services
>> (ARC? SPF?) are intermittently raising false positives on some of my
>> gnucash-user posts. I don't know how to interpret the headers of my
>> gnucash-user replies to investigate that.
>>
>> Best regards,
>> —Jim "Jim" DeLaHunt
>>
>> [1]
>> <https://lists.gnucash.org/pipermail/gnucash-user/2023-September/thread.html>
>> [2] Some of the mail headers of the copy of my reply which I received from
>> gnucash-user:
>>
>>> ...
>>> Received: from inbound-trex-4 (unknown [127.0.0.6])
>>> by postfix-inbound-v2-8.inbound.mailchannels.net (Postfix) with ESMTP
>>> id C524B600069
>>> for
>>>
>>> ; Mon, 21 Aug 2023 21:01:05 + (UTC)
>>> ...
>>> Received: from code.gnucash.org (code.gnucash.org [204.107.200.65])
>>> (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384)
>>> by 100.112.2.51 (trex/6.7.2);
>>> Mon, 21 Aug 2023 21:01:05 +
>>> ...
>>> Received: from seahorse.cherry.relay.mailchannels.net
>>> (seahorse.cherry.relay.mailchannels.net [23.83.223.161])
>>> (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
>>> key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest
>>> SHA256)
>>> (No client certificate requested)
>>> by code.gnucash.org (Postfix) with ESMTPS id 2FEE14B342
>>> for
>>>
>>> ; Mon, 21 Aug 2023 17:00:08 -0400 (EDT)
>>> ...
>>>
>>
>> [3]
>> <https://lists.gnucash.org/pipermail/gnucash-user/2023-September/108723.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnu Cash stopped working 2 days ago.
David, That's very strange, `string->number` is a guile function used only in the QIF importer. Please run /Application/Gnucash.app/Contents/MacOS/Gnucash --debug and attach the resulting tracefile (see https://wiki.gnucash.org/wiki/Tracefile). It may be quite long so don't try to paste in the contents. Regards, John Ralls > On Sep 9, 2023, at 12:57 PM, (Alan) David Smith > wrote: > > Dear John, > > Thank you for your suggestions: there is nothing in the crash report and this > is what the terminal output is: > > Last login: Fri Sep 8 23:30:43 on console > alandavidsmith@Alans-MacBook-Pro ~ % > /Applications/Gnucash.app/Contents/MacOS/Gnucash > Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash > > (process:46072): gnc.gui-WARNING **: 20:54:04.010: [mac_set_languages()] > Language list: en:en_GB:C > Backtrace: > 3 (apply-smob/1 #) > In ice-9/boot-9.scm: > 2312:4 2 (save-module-excursion #) > In ice-9/eval-string.scm: > 36:6 1 (read-and-eval # #:lang _) > In unknown file: > 0 (read #) > > ERROR: In procedure read: > In procedure string->number: Value out of range: 9739 > > Some deprecated features have been used. Set the environment > variable GUILE_WARN_DEPRECATED to "detailed" and rerun the > program to get more information. Set it to "no" to suppress > this message. > alandavidsmith@Alans-MacBook-Pro ~ % > > Regards, > > DAvid > > On 09/09/2023, 17:55, "john" wrote: > >Open /Applications/Utilities/Console and click Crash Reports in the > sidebar. If GnuCash is crashing there will be a detailed report there. If > there's nothing, try opening /Applications/Utilities/Terminal and running > GnuCash from the command line: > /Applications/Gnucash.app/Contents/MacOS/Gnucash > >to see if it prints an error on the terminal window. > >Regards, >John Ralls > > >> On Sep 9, 2023, at 08:25, smit...@smith54.karoo.co.uk wrote: >> >> Dear Sir, >> >> It stopped working suddenly. I then updated it to 5.3 and it still was >> shutting down on opening it. I have also only just updated to the latest >> version of Ventura. This has made no difference. I have checked the Apple >> permissions - again there is nothing obvious. >> >> Regards, >> >> David >> >> -Original Message- >> From: gnucash-user >> On Behalf Of >> G R Hewitt >> Sent: Saturday, September 9, 2023 2:57 PM >> To: (Alan) David Smith ; GnuCash User List >> >> Subject: Re: [GNC] Gnu Cash stopped working 2 days ago. >> >> Hi Alan, >> Has the MacOS been recently updated? This may have broken something or >> other. >> >> You might try getting a fresh installation of GnuCash and installing it, or >> you could use Time Machine and go back a couple of days and restore just the >> program file. >> >> If none of those work I'd look at the security settings to make sure GnuCash >> has sufficient rights. >> >> On Sat, 9 Sept 2023 at 13:18, (Alan) David Smith via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >>> Hello everyone, >>> >>> >>> I am using MacBook Pro M! And my Gnu Cash has suddenly stopped >>> opening. It looks was though it is opening up normally and then just >> switches off. >>> >>> Does anyone no why - It does not make sense to me. >>> >>> Regards, >>> >>> David Smith >>> >>> 54 Pryme Street >>> Anlaby, HU10 6SH. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange prices update issue (possibly with TSP)
Kalpesh,
Bruce posted at
https://github.com/finance-quote/finance-quote/issues/335#issuecomment-1676443182:
"While the fix did not make it into v1.58, you can download and install
BPSCHUCK/Finance-Quote-1.58_01.tar.gz from CPAN for testing/verification. It
also has what I hope is a fix for TSP. It was not returning the hash if the GET
failed or if the body of the response produced a CSV file."
That's the BSEIndia issue;
https://github.com/finance-quote/finance-quote/issues/338 is the TSP one.
If you find more problems with TSP (or anything else in F::Q) and want to help
debug it the best way to communicate with Bruce and stay up to date would be to
open an issue at https://github.com/finance-quote/finance-quote/issues/. You
can post here too if you want, but a Github issue is a better place to put
debugging results.
Regards,
John Ralls
> On Aug 14, 2023, at 1:54 PM, Kalpesh Patel wrote:
>
> Some good find in debugging ... Strawberry Perl cannot resolve the FQDN name
> one out of three times for www.tsp.gov on my system (this might be
> obfuscating the client behavior in response to real backend issue). It might
> be that I am reaching servers that are in error state (rc = 500 which is
> Internal Server Error; my observation on F::Q could be cause of concern on
> amount of data being returned). Below is the output from the failed run:
>
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>set DEBUG=1
>
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>test2.pl
>
> ### [Mon Aug 14 16:26:56 2023] YIND_URL_HEAD :
> 'https://query1.finance.yahoo.com/v8/finance/chart/'
> ### [Mon Aug 14 16:26:56 2023] YIND_URL_TAIL :
> '?interval=1d=1691440016=1692044816'
>
> ### AlphaVantage->new args : {}
>
> ### COUNT_URL: 'http://www.panix.com/~hd-fxsts/finance-quote.html?tsp'
> ### Code: '200'
>
> ### [Mon Aug 14 16:26:56 2023] url :
> 'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1'
> ### [Mon Aug 14 16:26:56 2023] reply: bless( {
> ###_content => 'Can\'t connect to
> www.tsp.gov:443 (nodename nor servname provided, or not known)
>
> nodename nor servname provided, or not known at
> C:/Strawberry/perl/site/lib/LWP/Protocol/http.pm line 50.
> ',
> ###_headers => bless( {
> ###
> '::std_case' => {
> ###
> 'client-date' => 'Client-Date',
> ###
> 'client-warning' => 'Client-Warning'
> ###
> },
> ###
> 'client-date' => 'Mon, 14 Aug 2023 20:26:56 GMT',
> ###
> 'client-warning' => 'Internal response',
> ###
> 'content-type' => 'text/plain'
> ### },
> 'HTTP::Headers' ),
> ###_msg => 'Can\'t connect to
> www.tsp.gov:443 (nodename nor servname provided, or not known)',
> ###_rc => 500,
> ###_request => bless( {
> ### _content
> => '',
> ### _headers
> => bless( {
> ###
>'user-agent' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7)
> AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36'
> ###
> }, 'HTTP::Headers' ),
> ### _method
> => 'GET',
> ### _uri =>
> bless( do{\(my $o =
> 'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1')},
> 'URI::https' )
> ### },
> 'HTTP::Request' )
> ### }, 'HTTP::Response' )
>
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>
>
> My test file (test2.pl) is as follows:
>
> #test2.pl - start
>
>use Finance::Quote;
>use Data::Dumper;
>
>$q = Fi
Re: [GNC] Chase ofx support?
> On Aug 14, 2023, at 1:33 PM, D Ducky wrote: > > Hello, > > It seems Chase does not support OFX anymore. > > https://www.banktivity.com/support/articles/banktivity-7/ofx-direct-connect-will-no-longer-be-supported-by-chase-as-of-october-6th-2022/ > > > Is it possible to use some other method in gnucash to download transactions > from gnucash? > No, there is no other method in GnuCash to download transactions from US banks. You may be able to download files from Chase's website that you can import into GnuCash using File>Import. Likely formats are OFX, QFX, QIF, and CSV. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)
Please remember to copy the list on all replies. No smackdown intended. You really need to understand basic accounting in order to use GnuCash effectively, and thinking that accounts in GnuCash are somehow equivalent to Quicken's categories is a common mistake for those new to GnuCash. Several others have answered the question already: Import small pieces, a month or two at a time, until the matcher gets it mostly right, then move to larger pieces. This is another common issue to users coming to GnuCash from Quicken and there's a longer explanation at https://wiki.gnucash.org/wiki/Quicken_Migration. Regards, John Ralls > On Aug 13, 2023, at 1:29 PM, Tom Balazs wrote: > > Well you gave me a good smack down. But are you going to answer the question > I asked? > > On Sun, Aug 13, 2023, 12:22 PM john wrote: > > >> On Aug 13, 2023, at 07:13, Tom Balazs wrote: >> >> (I know these are called accounts in GnuCash, but >> I mean "account" like "auto expenses", and "home repair expenses", not >> "account" like "Credit Card #1", and "Checking Account #1".) > > That indicates that you don't understand double-entry accounting. They're not > called accounts, they *are* accounts. You need to spend some time studying > the Tutorial and Concept Guide and perhaps a basic accounting text. > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Convert Money Market stock acnt to Bank acnt
> On Aug 12, 2023, at 12:08 PM, Fred Tydeman wrote: > > Is there an easy way to convert a money market stock account > to a bank account? > > Since the price is always $1, and each transaction has Trading splits, the > money market accounts are adding extra data to the book file and the price > history file. > The only way I can think of to do that short of editing your database: Export the transactions to CSV, edit the CSV to change the commodity, delete the account and recreate it as type BANK and currency USD, then import the edited CSV. *Almost* always $1: https://www.investopedia.com/terms/b/breaking-the-buck.asp#:~:text=What%20Is%20Breaking%20the%20Buck,operating%20expenses%20or%20investment%20losses. Last happened during the 2008 meltdown. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance quote not working
Paras, Thanks. With that I was able to diagnose the problem: It's from a source and symbol that hadn't been mentioned in the thread before. I've sent you a private reply with which stock it is. The problem was caused by the Finance::Quote BSEIndia.pm inserting an invalid string into the JSON return value, causing the parser to not parse anything. I've reported that to Finance::Quote as https://github.com/finance-quote/finance-quote/issues/335. I'll also make sure that GnuCash pops its "quotes not retrieved" message box when that happens. In the meantime you can disable quotes on that stock while you figure out how to reliably retrieve quotes for it. Regards, John Ralls > On Aug 8, 2023, at 10:55 AM, Paras Desai wrote: > > Hello John, > > Please find attached the regenerated Trace file > > Thanks > > Paras > > On 08-08-2023 23:10, john wrote: >> Prasad, >> >> Darn it, I told you the wrong log argument. It should be >> --log=gnc.price-quotes=debug. Sorry, please try again. >> >> Regards, >> John Ralls >> >> >>> On Aug 8, 2023, at 10:28, Paras Desai >>> wrote: >>> >>> >>> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance quote not working
> On Aug 7, 2023, at 7:01 AM, Paras Desai wrote: > > Hello Jin and all friends > > Thanks for your kind help and suggestion in running command prompt. GnuCash > was installed in F drive and I forgot that, so the error message was coming, > > I ran the command prompt, and it threw the result for RELIANCE, FOR EXAMPLE, > as below. So the Finance quote works, but integrated Finance quote in GnuCash > does not. What could be the next step? > > Thank you. > > Paras > > > close => 2523.85 > symbol => RELIANCE >prevclose => 2509.55 > open => 2521 > low => 2505 > last => 2523.5 > isodate => 2023-08-07 > method => nseindia > exchange => NSE > high => 2528.4 > success => 1 > currency => INR > date => 08/07/2023 > Paras, GnuCash and gnucash-cli use the same code for Finance::Quote integration, so it's not that. You reported that updating your book worked until 26 July, so something must have changed around that day. Do you remember changing anything, like updating GnuCash or Finance::Quote, that might offer a clue? There may be an error in your tracefile (see https://wiki.gnucash.org/wiki/Tracefile) that explains why the prices aren't being updated. When trying to retrieve quotes in the GUI are you getting the message box saying that it couldn't retrieve quotes for some stocks followed by a list of stocks that fail? 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] MySQL backend
https://bugs.gnucash.org/show_bug.cgi?id=798992 Reports that after upgrading to MariaDB 11 on their servers, two Windows users are unable to work with their GnuCash databases. GnuCash appears to connect but DBI thinks that numeric variables are strings and, since it's expecting numbers, declines to read them. Has anyone using GnuCash on macOS or Linux experienced this problem? 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How do I search foi empty description, notes or memo fields
> On Aug 3, 2023, at 3:35 PM, Gilberto Reis Filho > wrote: > > Hello. > > I have a fairly large database of transactions that I want to search > for empty (null) description, notes or memo fields. > > Using the provided search function I always have to type some text to > perform a search. > > Is there any way to search for "null" fields in the database using the > built in Find Transaction function? > > I am using version 5.3 in Windows and the XML backend. You can use matches regex and ^$ or doesn't match regex and .+ . In regular expressions ^ means the beginning of the string and $ means the end, so ^$ is an empty string. Conversely . means any character and + means one-or-more, so .+ matches anything. Note that * in place of + means zero-or-more so .* will match any contents or none at all. It has its uses but this wouldn't be one of them. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
It might feel the same but it's very much not the same. The quickfill is quite different on 5.x from previous versions. Regards, John Ralls > On Jul 29, 2023, at 11:21 AM, Chris Green wrote: > > On Sat, Jul 29, 2023 at 09:59:37AM -0700, john wrote: >> For bug-filing instructions see >> https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones. >> >> >> >> Chris Green and G R Hewitt, what OS/distro are you running and how did you >> install GnuCash? >> > I'm running [x]ubuntu 22.04 and 23.04 with GnuCash versions 4.13 and > 4.8 respectively, the text entry issue feels much the same on both. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
One needs a login only to edit pages, not to read. When you have time and if the problem hasn't resolved itself, try opening a terminal window and running `traceroute wiki.gnucash.org`. If it prints more than 3 lines of * * * then kill it with control-C. Regards, John Ralls > On Jul 29, 2023, at 12:57 PM, AgedLace wrote: > > I've tried Firefox, Brave and Chromium browsers ... all other sites are > working fine, just the wiki.gnucash.org site refusing connection. > > Question? Does one need to login to the wiki? > > On 7/29/23 15:51, David H wrote: >> Must be something at your end, both links are working fine for me. >> >> Cheers David H. >> >> >> On Sun, 30 Jul 2023 at 04:20, AgedLace wrote: >> Unfortunately, I'm getting the following error message. >> >> This site can’t be reached >> >> wiki.gnucash.org refused to connect. >> >> >> >> On 7/29/23 12:59, john wrote: >> > For bug-filing instructions see >> > https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones. >> > >> > >> > >> > Chris Green and G R Hewitt, what OS/distro are you running and how did >> > you install GnuCash? >> > >> > For all three of you, what Window Manager (e.g. Gnome, XFCE, Mate, >> > etc.) are you using? >> > >> > Regards, >> > John Ralls >> > >> > >> >> On Jul 29, 2023, at 05:29, AgedLace wrote: >> >> >> >> Can you point me in the direction needed in order to file the bug-report? >> >> >> >> Thank you! >> >> >> >> >> >> On 7/29/23 08:26, Adrien Monteleone wrote: >> >>> Sorry, indeed, I missed that. >> >>> >> >>> Consider stepping back to 4.14 in that case. >> >>> >> >>> But also consider filing a bug report for sure so it can be addressed. >> >>> >> >>> Regards, >> >>> Adrien >> >>> >> >>> On 7/29/23 7:09 AM, AgedLace wrote: >> >>>> As i mentioned, my repository has version 5.3-1. This is the >> >>>> version I am using. >> >>> >> >>> ___ >> >>> gnucash-user mailing list >> >>> gnucash-user@gnucash.org >> >>> To update your subscription preferences or to unsubscribe: >> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >>> - >> >>> Please remember to CC this list on all your replies. >> >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> - >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unable to enter data in "Description" field of a Transaction
That's interesting, yours is the first report of this on macOS. Regards, John Ralls > On Jul 29, 2023, at 12:59 PM, G R Hewitt wrote: > > Hi John, I am using MacOS High Sierra 10.13.6 2010 MacPro 5.1 > > On Sat, 29 Jul 2023 at 18:00, john wrote: > >> For bug-filing instructions see >> https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones >> . >> >> Chris Green and G R Hewitt, what OS/distro are you running and how did you >> install GnuCash? >> >> For all three of you, what Window Manager (e.g. Gnome, XFCE, Mate, etc.) >> are you using? >> >> Regards, >> John Ralls >> >> >>> On Jul 29, 2023, at 05:29, AgedLace wrote: >>> >>> Can you point me in the direction needed in order to file the bug-report? >>> >>> Thank you! >>> >>> >>> On 7/29/23 08:26, Adrien Monteleone wrote: >>>> Sorry, indeed, I missed that. >>>> >>>> Consider stepping back to 4.14 in that case. >>>> >>>> But also consider filing a bug report for sure so it can be addressed. >>>> >>>> Regards, >>>> Adrien >>>> >>>> On 7/29/23 7:09 AM, AgedLace wrote: >>>>> As i mentioned, my repository has version 5.3-1. This is the version >> I am using. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue with Finance::Quote
Try this: Open a Strawberry Perl shell, and run C:\Windows>set ALPHAVANTAGE_API_KEY=A1B2C3D4E5 C:\Windows>c:\Strawberry\cpan\build\Finance-Quote-1.57-0\Examples\stockdump.pl alphavantage QQQ If you still get the "Can't get an undefined value" error you have good reason to open an issue at https://github.com/finance-quote/finance-quote/issues. If not there's more to investigate here. Regards, John Ralls > On Jul 27, 2023, at 7:37 AM, bern...@deprez.biz wrote: > > Thanks for that suggestion - did that on 2 different Windows systems, both > still fail the same way... > > C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ > * 10:21:02 ERROR [parse_quotesource_error()] Unrecognized > Finance::Quote Error Can't use an undefined value as a HASH reference at > C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234. > Finance::Quote retrieval failed with error Unrecognized Finance::Quote Error: > Can't use an undefined value as a HASH reference at > C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234. > > I've even tried a new Alphavantage API key (with different email) - same issue > > Is Alphavantage the only solution? I see multiple other sources but not > googleweb for example... > > Thx, > B. > > > On 26/07/2023 23:57, john wrote: > >> It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry >> Perl cpan shell and telling it `force install Finance::Quote` to reinstall >> it. >> >> Regards, >> John Ralls >> >>> On Jul 26, 2023, at 04:48, bern...@deprez.biz wrote: >>> >>> Hi Ken, >>> >>> I tried googleweb and get a response >>> >>> C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump googleweb QQQ >>> Finance::Quote fields GnuCash uses: >>> symbol: QQQ <=== required >>> date: 07/25/2023 <=== recommended >>> currency: USD <=== required >>> last: 378.78 <=\ >>>nav: <=== one of these >>> price: <=/ >>> >>> That is indeed the last price available >>> >>> So I guess it's an issue only with alphavantage? I triplechecked my API key >>> (which is set both as an environment variable & in GnuCash) and it is the >>> correct one. >>> >>> Any other suggestions that could help me? >>> >>> Thanks, >>> Bernard >>> >>> >>> On 25/07/2023 22:01, Ken Farley wrote: >>>> Are you able to get quotes for that particular security using any of the >>>> other sources in F::Q, like googleweb, yahooweb, yahoo_json? I get prices >>>> from any one of those. >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> To update your subscription preferences or to unsubscribe: >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> - >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble building 5.3
> On Jul 22, 2023, at 5:15 PM, Liz wrote: > > On Sat, 22 Jul 2023 14:25:38 -0700 > Steve Butler wrote: > >> First I would upgrade those 191 packages. >> >> sudo apt update >> sudo apt upgrade >> >> Make sure everything upgradable was upgraded. >> >> Check that you have build-essentials. > > May I suggest checking what would happen if you did upgrade first? > sudo apt update > sudo apt -s upgrade It won't help. Ubuntu doesn't update Gwenhywfar and AQBanking post-release, and they're not in focal-backports. Gwen 5.6.0 and AQBanking 6.2.10 are in Debian's buster-backports (https://backports.debian.org/Instructions/) so you could see if you can install them from there. If that fails they're both pretty easy to build from source. Download from https://www.aquamaniac.com. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Should GNUCash allow a split to reference the same account twice
> On Jul 20, 2023, at 10:46 AM, Henry Law wrote: > > Earlier today my wife was running GNUCash to update "her" bit of the > accounts and got into a serious tangle because she (inadvertently) > changed a newly-imported transaction so that its two splits -- which > should have been our current account and her credit card account -- > both referred to the credit card account. She then reconciled one half > and not the other, which caused a cascade of issues which took me > several hours and a manual edit to the GNUCash file to fix. That's too bad. The transaction should have been readily apparent in both the credit card register and in the reconcile window because it would appear twice in both once with a debit and once with a credit: One doesn't usually have debits in a credit card account so that's an obvious red flag. The register would also show the credit card account in the transfer account column, another easily-spotted red flag. The fix is to simply change that to the current account; GnuCash would I think ask you if you really want to change a reconciled transaction, to which you'd reply that you would, and once you had finished with it you'd re-do the reconcile. > > Should GNUCash refuse to allow a transaction to have two splits into > the same account? My knowledge of accounting is scant, but with it I > can't see why one would ever legitimately do that. > It's normal in GnuCash to book both the sale and capital gains of a security or foreign currency asset in the same transaction by having two splits to the stock account. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "Mod" field in GNUCash log file
> On Jul 20, 2023, at 7:56 AM, Henry Law wrote: > > I'm trying to sort out a baffling data problem with GNUCash and I'm > looking at the logs. > > I can get most of it, thanks to the column name record at the start, > but > > 1. What do '=START" and "=END" signify? > 2. What is the "mod" field (field #1); I see values of 'B', 'C', and > 'D' but can't deduce what they mean. > They're not actually meant to be human readable. START and END delimit a single transaction edit; each line reflects the state of the transaction in that edit. 'B' lines reflect the state at the beginning of the edit, as to 'D' (for delete) and 'R' (for rollback). 'C' is for commit and the data in a C line is the new state of the transaction once it's committed. There's some documentation at https://code.gnucash.org/docs/MASTER/group__TransLog.html. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Income Statement versus Transaction Report
See https://bugs.gnucash.org/show_bug.cgi?id=797796. It has a long and detailed discussion about handling foreign-currency investments. CDB-Man is a licensed accountant practicing in Vancouver, BC. My take-away from that discussion is that GnuCash has painted itself into a corner by not enforcing the home-currency rules, particularly for Equity accounts, that CDB-Man explains there. Without that discipline it's very difficult to reconstruct the correct home-currency amounts to report, including especially the capital gains and losses from the foreign currency piece of the equation. Unfortunately I also think that imposing those restrictions in a future version of GnuCash would create discontent that would make the recent complaints about quickfill seem like meek acceptance. In any case it's not on the agenda to do so. Users who have multiple-currency books will have to go learn the rules and impose the discipline on themselves; if they do so I'm reasonably sure that the Average Cost price source will then give correct and consistent (instead of the current merely consistent) results. The PriceDB-based price sources can't, nor are they intended to, give correct results. They're what-if tools, as in "How much money in currency X would I have if I sold all of my investments and converted all of my cash to currency X today?". It's fun to do but not particularly meaningful. Regards, John Ralls > On Jul 20, 2023, at 10:24 AM, Adrien Monteleone > wrote: > > Ah. Interesting conundrum. > > Many moons ago that there was issue with some of the code for the various > price options in reports. I don't recall the details, but I seem to remember > that 'average' was thought to be the most accurate at the time, and there was > discussion of removing the other options until they could be fixed/improved. > > I'm not sure what progress has been made in that regard since. > > In the meantime, I wonder what happens if you created additional splits (or > separate transactions) between the two currencies - say from a USD income to > a COP asset, with the accounts used just for reporting purposes. I would > think you'd get your trading splits in that case, and can specify the proper > FX. Then you'd have fixed transactions for the report which wouldn't need > price conversion at all, since they would be in the transaction itself. > > Of course, with the extra accounts, you'd need to exclude them from other > reports like a Balance Sheet. > > Regards, > Adrien > > On 7/20/23 12:11 AM, Fred Tydeman wrote: >> I have Trading turned on. >> The income accounts in question are using COP as their currency. >> Transactions in those accounts do not show any splits for Trading. >> Income in those accounts is coming from an Asset account that also is in >> COP. >> So, there is no conversion between COP and USD involved in that transaction. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies
> On Jul 18, 2023, at 10:12 AM, Bruce Schuck wrote: > > On 7/17/23 9:06 PM, john wrote: > >> Well, a user wouldn't want to set GBX as their default currency, >> just to create an account in their tree denominated in it to be a >> parent for stock accounts that are priced in GBX. But you're right >> that it's not something that a user can do now because GBX isn't an >> ISO4217 currency and that's historically how we decide what's a >> currency. Implementing it would require making an exception to that >> policy and adding an entry to our currency file. > > Probably why AlphaVantage and YahooJSON convert GBX quotes to GBP. I > started to get involved with Finance::Quote after AV was added because a > Google finance API was discontinued. > >> To be pure it would also require F::Q to leave the GBX->GBP conversion to >> the client program, because while it's reasonable to expect a user who owns >> GBP.L shares to know that they trade in GBX it's not reasonable to expect >> them to know that it's one of the exceptions that doesn't get adjusted >> automatically when getting the price from AlphaVantage, but *does* get >> adjusted automatically when retrieved from Yahoo!. > > YahooJSON and now YahooWeb are already doing the GBX->GBP conversion > (not my doing). Easy because both of those sources have the pricing > currency in the data returned. I hope you are not suggesting that the > conversion is removed from both of those modules? I'm not. I'm pointing out the disadvantages of handling the pricing issue on the client side. > > There-in lies why I figure the additional lookup to get the correct > currency is needed. So the user doesn't need to worry about what modules > may or may not be doing GBX->GBP or ZAc->ZAR conversion. Consistent with > two Yahoo modules, AV would return the ISO currency. At least that was > my thinking. Roger, but slowing AV down to 5 quotes/2 minutes will make it pretty useless for anyone with even a small number of LSE stocks. Users already gripe about the 5/sec throttling. > >> And repeating myself for emphasis, that's how GnuCash could handle it >> but I have no idea if it's reasonable for other programs. From that >> standpoint the extra suffix is more straightforward: Just add it and >> F::Q will unconditionally multiply the price by 100. That will work >> for any client and is pretty easy to explain to users. > To clarify, are you suggesting have AlphaVantage check for the additional > (let's say ".X") suffix? Or any quote source? Much easier to accomplish on a > per module basis, than F::Q in general. But as stated, that means the user > needs to know to use GBP.L.X (Global Petroleum) for AV to return GBP, but > YahooJSON does not need the extra ".X". Then again, that's what man pages are > for... ;) Yes, I think that's the best alternative to asking AV for the currency. Another that we haven't discussed would be caching the results somewhere, but that conflicts with F::Q's stateless design. > > Definitely validates what I tried to explain in the F::Q issue, where the > solution is *not* just a simple "remove the adjustment". > > I may just shelve this for a while longer. Thanks for the discussion and > insight. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA OFX Direct connect stopped working
BTW, I also got the invalid signon from USAA this morning. I repeated the drill at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA and got the exact same access id and pin. Once completed I was able to retrieve my transactions. Regards, John Ralls > On Jul 18, 2023, at 9:15 AM, john wrote: > > Access id is configured in the AQBanking setup wizard accessed from > Tools>Online Banking Setup. The PIN is collected every time you run > Actions>Online>Get Transactions unless you told GnuCash to remember it. If > you did you can tell it to forget from Preferences>Online Banking. > > Regards, > John Ralls > > >> On Jul 17, 2023, at 20:41, Daffy Duck wrote: >> >> Ok, as of today, I can no longer use the online download again. >> >> 22:35:38 Status for signon request: General error (Code 2000, severity >> "ERROR") >> Error other than those specified by the remaining error codes. (Note: >> Servers should provide a more specific error whenever possible. Error code >> 2000 should be reserved for cases in which a more specific code is not >> available.) >> 22:35:38 Status for account info request: Signon invalid (Code 15500, >> severity "ERROR") >> The user cannot signon because he or she entered an invalid user ID or >> password. >> >> And the problem is, I can't find the info on how to set ACCESS ID: and >> ACCESS PIN: so I can do it over again. >> >> Any ideas? >> >> On Mon, 2022-08-22 at 09:18 -0700, John Ralls wrote: >>> >>>> On Aug 21, 2022, at 8:13 PM, john >>> <mailto:jra...@ceridwen.us>> wrote: >>>> >>>> >>>> >>>>> On Aug 21, 2022, at 7:54 PM, Daffy Duck >>>>> mailto:suffsuccot...@gmail.com>> wrote: >>>>> >>>>> Hello, >>>>> >>>>> A while back, USAA changed their OFX stuff and there had to be a >>>>> workaround with a PIN, etc. >>>>> >>>>> I did that, without a problem, but I just noticed today it has broken >>>>> again? >>>>> >>>>> This is the output: >>>>> >>>>> AqBanking v6.5.2.0stable >>>>> Sending jobs to the bank(s) >>>>> Sorting commands by account >>>>> Sorting account queues by provider >>>>> Send commands to providers >>>>> Send commands to provider "aqofxconnect" >>>>> Locking customer "1299" >>>>> Sending request... >>>>> Connecting to server... >>>>> Resolving hostname "df3cx-services.1fsapi.com" ... >>>>> IP address is "45.60.151.211" >>>>> Connecting to "df3cx-services.1fsapi.com" >>>>> Connected to "df3cx-services.1fsapi.com" >>>>> Using GnuTLS default ciphers. >>>>> TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD >>>>> Connected. >>>>> Sending message... >>>>> Message sent. >>>>> Waiting for response... >>>>> Receiving response... >>>>> HTTP-Status: 200 () >>>>> Response received. >>>>> Disconnecting from server... >>>>> Disconnected. >>>>> Parsing response... >>>>> Status for signon request: Success (Code 0, severity "INFO") >>>>> The server successfully processed the request. >>>>> Status for transaction statement request: General error (Code 2000, >>>>> severity "ERROR") >>>>> Error other than those specified by the remaining error codes. (Note: >>>>> Servers should provide a more specific error whenever possible. Error >>>>> code 2000 should be reserved for cases in which a more specific code is >>>>> not available.) >>>>> Unlocking customer "1299" >>>>> -- >>>>> >>>>> any ideas? >>>> >>>> First, try again tomorrow on the off chance USAA had a server outage over >>>> the weekend. If it still fails, turn on OFX logging (see >>>> https://wiki.gnucash.org/wiki/AqBanking#Debugging) and capture the actual >>>> OFX response. Edit it to remove your actual account number and credentials >>>> then post it here. >>> >>> BTW I was able to retrieve my USAA credit card transactions this morning >>> with no problems. >>> >>> 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies
> On Jul 17, 2023, at 11:11 AM, Bruce Schuck wrote: > > On 7/17/23 10:02 AM, john wrote: > >> It's not all non-US securities. In AlphaVantage it appears to be only >> LSE stocks; JSE stocks aren't supported and Tel Aviv stocks support >> only ILS. The Yahoo JSON module adjusts prices for Zac (South Africa) >> and ILA (Israel) as well as GBX, but Yahoo JSON apparently includes a >> currency code to make that easy. That seems to be missing from >> YahooWeb, perhaps an oversight on Vincent's part. The currency is >> available on https://finance.yahoo.com/quote/GBP.L >> <https://finance.yahoo.com/quote/GBP.L> prefixed by "Currency In" in >> div id="quote-header-info". > > The currency is being captured by YahooWeb. For GBP.L (traded in GBp/GBX) has > its price converted to GBP and currency reported as such. At the time of this > writing, GBP.L was 0.1850 GBp, F::Q v1.57 yahooweb returns 0.00185 GBP. > > % gnc-fq-dump -v yahooweb GBP.L > > stock field value > - - - > GBP.Lcurrency: GBP > GBP.Ldate: 07/17/2023 > GBP.Lexchange: LSE - LSE Delayed Price > GBP.L isodate: 2023-07-17 > GBP.Llast: 0.00185 > GBP.L method: yahooweb > GBP.Lname: Global Petroleum Limited > GBP.L success: 1 > GBP.L symbol: GBP.L > > > So for AlphaVantage it seems only .L and .IL suffix securities would > > need to be queried, and maybe only .L unless there are known > > instances where .IL-suffixed symbols are priced in GBP. > > I will change the AlphaVantage.pm fix I'm working on to only execute the > extra API call for securities ending with '.L'. > >> Rather than spending an extra query maybe AlphaVantage.pm could >> accept a special extra suffix indicating that the user wants quotes >> to be multiplied by 100, perhaps X, so a request for GBP.L priced in >> GBP would be GBP.L.X. > > If I understand, this method assumes the user knows that the data from AV for > GBP.L is priced in GBp/GBX. Correct? > >> Alternatively we could create a GBX, ZAX, and ILA pseudo-currencies >> in GnuCash and users would create parent accounts in those currencies >> for stocks quoted that way. That would take a little finessing on >> users' part because using it would depend both on the currency the >> stock is quoted in and whether F::Q converts it to the "real" >> currency. > > F::Q currently sets currency based on suffix. '.L' gets mapped to 'GBP'. I > just checked, currently no map in AV for ZAR. By chance, you don't have an > example for me? Thanks. Like the previous comment, this also expects users to > know what currencies the different securities are reports as coming from the > AV module, correct? While I like the idea on a high level, I think that is > asking for trouble reports from users having pricing issues. > Bruce, Sorry, I can't provide any examples of JSE or TASE stocks, I was going completely off of looking at the code in the three modules. Yes, both of my suggestions transfer the responsibility for knowing what currency a stock is traded in to the user. In GnuCash's case that responsibility is already there. GnuCash doesn't use the currency returned from F::Q, it assumes that the price is denominated in the currency of the nearest parent account denominated in a currency. We don't get that many users who miss that detail and it's pretty easy for them to fix their books. I don't know about other programs using F::Q. 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 - 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 5.3 autofill headaches
David, Huh. Two possibilities: I have only a few future transactions, not enough to move the blank transaction that far up the screen, and I wonder if that marker transaction (with no debit or credit value) matters. What macOS version on the iMac? Regards, John Ralls > On Jun 30, 2023, at 1:47 PM, David H wrote: > > Hi John, > > I hope I don't sound ungrateful, as always I really appreciate the work you > and the other devs/translators/etc put in on my most used app. > > Anyway here's a pic of what I'm seeing on all my pc's - haven't fired up > Ubuntu for a few days so can't say what happens there. I have standard sort > order on, future dated txns after the blank txn so they stand out for me. As > you can see from the pic's different end points. Looking at it again this > morning after a coffee I have noticed that if I close GnuCash with an account > register open that particular register exhibits the old behaviour and is > scrolled right to the bottom when GnuCash is re-opened. Otherwise I only get > the blank txn and 1 future dated txn in all open registers. Usually I close > Gnucash with the focus on the Accounts tab so it seemed like it affected all > registers. Aha, did I hear you say something about lazy tab > repainting/refreshing in a previous post - is there a connection ? > > I've also noticed some of my icons disappearing, but only on my slow old 2014 > 27" iMac - looks a bit weird - like 3 missing, 2 there, more missing and if > you move the cursor along the icon row they magically reappear. Really only > an intermittent thing that I've only seen twice on the one Mac. > > Hope this clarifies things somewhat. > > Cheers David H. > > > > > > On Sat, 1 Jul 2023 at 03:55, John Ralls wrote: > > > > On Jun 30, 2023, at 8:31 AM, Adrien Monteleone > > wrote: > > > >> I also think that the registers now display a little differently to what > >> they used to. In 5.1 any open registers always scroll all the way to the > >> end of the txns when you re-open your GnuCash data file. In 5.3 they don't > >> seem to quite get all the way to the bottom meaning you have to manually > >> page down in every register you had open to see all your future txns, which > >> in my case is sometimes 15 - 20 as I like to know what's coming up for the > >> next 60 days cash flow wise. > > > > I don't use future-dated transactions, but if it doesn't even get to the > > last transaction (and ideally the next empty one) that could get quite > > annoying. > > > > I just checked that and both open registers had the cursor in the blank > transaction just like always. There's a preference to put the blank > transaction before future transactions. Even with that set I see all the ones > I have displayed below the blank transaction, but I can imagine that if you > have more than will fit in the window then GnuCash will scroll so that the > blank transaction is at the top of the window and some of those future > transactions aren't visible. I think that's correct behavior: Ready to > perform input with the input location visible. > > 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HELP! Invoice Stylesheet, how to? V4.8
> On Jun 30, 2023, at 11:03 AM, Adrien Monteleone > wrote: > > https://wiki.gnucash.org/wiki/Flatpak > > It's in the Release Notes posted here on the list and on the website. > > Perhaps file an Enhancement Request to put that link at the top of the > Website along with the other links to binaries & sources. Good idea. I did that, and cleaned up the display of the downloads box a bit as well. 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 - 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 5.3 autofill headaches
> On Jun 30, 2023, at 8:31 AM, Adrien Monteleone > wrote: > >> I also think that the registers now display a little differently to what >> they used to. In 5.1 any open registers always scroll all the way to the >> end of the txns when you re-open your GnuCash data file. In 5.3 they don't >> seem to quite get all the way to the bottom meaning you have to manually >> page down in every register you had open to see all your future txns, which >> in my case is sometimes 15 - 20 as I like to know what's coming up for the >> next 60 days cash flow wise. > > I don't use future-dated transactions, but if it doesn't even get to the last > transaction (and ideally the next empty one) that could get quite annoying. > I just checked that and both open registers had the cursor in the blank transaction just like always. There's a preference to put the blank transaction before future transactions. Even with that set I see all the ones I have displayed below the blank transaction, but I can imagine that if you have more than will fit in the window then GnuCash will scroll so that the blank transaction is at the top of the window and some of those future transactions aren't visible. I think that's correct behavior: Ready to perform input with the input location visible. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] ANNOUNCE: GnuCash 5.3 Released
It's built and I've manually published it. It should show up at https://flathub.org/apps/org.gnucash.GnuCash in a few hours. Regards, John Ralls > On Jun 26, 2023, at 3:56 PM, Stephen Cohoon wrote: > > I don't see the flatpak update for 5.3 yet. Is that coming? > > -Stephen > > On Tue, Jun 27, 2023 at 6:36 AM John Ralls wrote: > >> The GnuCash development team announces GnuCash 5.3, the fourth release in >> the stable 5.x series. This is a snap release to fix the bug listed below. >> >> Between 5.2 and 5.3, the following bugfixes were accomplished: >> >>• Bug 798967 - Cannot Save to Any Path After Upgrading to 5.2 Fix >> inverted if statement condition for save success flag >> The following fixes and improvements were not associated with bug reports: >> >>• Some memory cleanup by Chris Lam. >>• Missing from the 5.2 release notes is that Chris streamlined the >> transaction scrubbing so that each transaction gets scrubbed only once. >> This improves--in some cases substantially--the time to load and to run >> Check and Repair. >> New and Updated Translations: Dutch, French, Hungarian, Italian, Portuguese >> >> Help translate GnuCash on Weblate: >> https://hosted.weblate.org/engage/gnucash/ >> >> Known Problems >> >> Complete list of all open bugs: >> https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced >> >> Documentation >> >> This being a snap release there is no new documentation. Please continue >> to use the 5.2 versions. >> Getting GnuCash for Windows and MacOS >> >> GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS >> 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An >> installer is provided for Microsoft Windows® while the MacOS® package is a >> disk image containing a drag-and-drop application bundle. >> >> GnuCash is also available as a flatpak from Flathub.org. Instructions for >> installing and running: https://wiki.gnucash.org/wiki/Flatpak >> >> The SHA256 Hashes for the downloadable files are: >> • 1458cb08c585eae9d724bec6f2812bcc03bbe83ed294a46a7897aaab01a6f15a >> gnucash-5.3.tar.bz2 >> • e0d04e0fd5f03f39136e1f4d941ccd0202b64a6e92418f5382cb6a6772493529 >> gnucash-5.3.tar.gz >> • 4cd66cf6c261fe7f5fc071b8e01314f33fb97e3496fe832e07bad360c1cf685a >> gnucash-5.3.setup.exe >> • 6bf4940d851b49a4edf5d6dd3cbe37a1112bc3606cdb924ed6668ce0ad7c7427 >> Gnucash-Intel-5.3-1.dmg >> • b9eb6581b403665c308b8909cc4d588c9ce483139cbc3ed3638403f61aefb49b >> gnucash-docs-5.2.tar.gz >> >> Microsoft Windows: >> >> https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.setup.exe >> >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.setup.exe >> >> Apple macOS: >> >> https://github.com/Gnucash/gnucash/releases/download/5.3/Gnucash-Intel-5.3-1.dmg >> >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/Gnucash-Intel-5.3-1.dmg >> >> Getting GnuCash as source code >> If you want to compile GnuCash 5.3 for yourself, the source code can be >> downloaded from: >> >> https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.tar.bz2 >> https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.tar.gz >> >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.tar.bz2 >> >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.tar.gz >> >> To compile GnuCash from the source code by yourself, you will need at >> least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, >> cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in >> the sources for the exact list of dependencies and versions. >> Getting the documentation >> >> Note that the documentation for unstable releases is not on the GnuCash >> website. It is built daily and may be found on the development server under >> the locale directory; "C" is English, "de" is German, and so on. >> >> The documentation is included in the MacOS and Windows application bundles. >> >> If you want to compile the GnuCash Documentation 5.2 for yourself, the >> source code can be downloaded from: >> >> Sourceforge: >> https://downloads.sourceforge
[GNC] ANNOUNCE: GnuCash 5.3 Released
The GnuCash development team announces GnuCash 5.3, the fourth release in the stable 5.x series. This is a snap release to fix the bug listed below. Between 5.2 and 5.3, the following bugfixes were accomplished: • Bug 798967 - Cannot Save to Any Path After Upgrading to 5.2 Fix inverted if statement condition for save success flag The following fixes and improvements were not associated with bug reports: • Some memory cleanup by Chris Lam. • Missing from the 5.2 release notes is that Chris streamlined the transaction scrubbing so that each transaction gets scrubbed only once. This improves--in some cases substantially--the time to load and to run Check and Repair. New and Updated Translations: Dutch, French, Hungarian, Italian, Portuguese Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/ Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced Documentation This being a snap release there is no new documentation. Please continue to use the 5.2 versions. Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. GnuCash is also available as a flatpak from Flathub.org. Instructions for installing and running: https://wiki.gnucash.org/wiki/Flatpak The SHA256 Hashes for the downloadable files are: • 1458cb08c585eae9d724bec6f2812bcc03bbe83ed294a46a7897aaab01a6f15a gnucash-5.3.tar.bz2 • e0d04e0fd5f03f39136e1f4d941ccd0202b64a6e92418f5382cb6a6772493529 gnucash-5.3.tar.gz • 4cd66cf6c261fe7f5fc071b8e01314f33fb97e3496fe832e07bad360c1cf685a gnucash-5.3.setup.exe • 6bf4940d851b49a4edf5d6dd3cbe37a1112bc3606cdb924ed6668ce0ad7c7427 Gnucash-Intel-5.3-1.dmg • b9eb6581b403665c308b8909cc4d588c9ce483139cbc3ed3638403f61aefb49b gnucash-docs-5.2.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/5.3/Gnucash-Intel-5.3-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/Gnucash-Intel-5.3-1.dmg Getting GnuCash as source code If you want to compile GnuCash 5.3 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-5.3.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-5.3.tar.gz To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation Note that the documentation for unstable releases is not on the GnuCash website. It is built daily and may be found on the development server under the locale directory; "C" is English, "de" is German, and so on. The documentation is included in the MacOS and Windows application bundles. If you want to compile the GnuCash Documentation 5.2 for yourself, the source code can be downloaded from: Sourceforge: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.3/gnucash-docs-5.2.tar.gz GitHub: https://github.com/Gnucash/gnucash/releases/download/5.3/gnucash-docs-5.2.tar.gz You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. Regards, John Ralls ___ gnucash-devel mailing list gnucash-de...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-announce mailing list gnucash-annou...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-announce ___ 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 t
Re: [GNC] ANNOUNCE: GnuCash 5.2 File Save bug
There is a bug in GnuCash 5.2 that prevents saving compressed files, see https://bugs.gnucash.org/show_bug.cgi?id=798967. If you don't compress your XML files or you use a SQL backend you're not affected, and that provides an obvious work-around. We'll get a snap release of GnuCash 5.3 out in a day or so once the cause has been isolated and fixed. 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 - 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/gnucash] Release 5.2 - GnuCash 5.2 Released
Glen, Thanks, I noticed it earlier and fixed it. Regards, John Ralls > On Jun 25, 2023, at 1:31 PM, Glenn Fowler wrote: > > Hi John - thank you and the team for the 5.2 release! Just letting you know > on GitHub the windows build has gnucash-5.0.setup.exe instead of 5.2 > > On Sun, Jun 25, 2023 at 2:42 PM John Ralls wrote: > > GnuCash 5.2 Released > > Repository: Gnucash/gnucash · Tag: 5.2 · Commit: 4bba182 · Released by: jralls > > The GnuCash development team announces GnuCash 5.2, the third release in the > stable 5.x series > > Between 5.1 and 5.2, the following bugfixes were accomplished: > > • Bug 777472 - reconcile does not work if transaction selected > Check that there's no outstanding activity in the current register page > before starting a reconciliation. It is still possible to start modifying a > transaction after the reconciliation window is open but this will stop the > most common issue with the process. Starting a reconciliation from the > account tree is left unprotected. > > • Bug 798564 - GnuCash is slow when there are a lot of open > tabs/registers (37) > Lazily load registers as is already done with reports. > > • Bug 798597 - The word "Separators" needs two separate versions > Use "Character-separated" when it's a choice between that and fixed field > width and "Select Separator Character" when it's a heading. > > • Bug 798695 - Deleting everything from the "Transfer" cell after > suggestions pop-up restricts search to the first 30 accounts > Skip the search on an empty value and return all accounts in the combo box as > it normally does if the account list is opened without searching for > something. > > • Bug 798796 - Account list incomplete in report options > Allow stock/fund accounts that are descendants of Bank accounts to be > selected for the Advanced Portfolio, Investment Lots and Investment Portfolio > reports. > > • Bug 798809 - Multicolumn report error when reopened after saving. > • Bug 798839 - Edit -> Preferences string not translatable (reopened) > • Bug 798862 - Merge identical strings (reopened) > Ensure similar strings are identical and use double line view instead of > double line mode. > > • Bug 798879 - RFE: [Transaction Report] add Running Total option > • Bug 798885 - Accented character in folder name on Account Export > (reopened) > • Bug 798899 - Gnucash crashes during CSV import when using a template > if the destination account is changed from one used in the template > • Bug 798901 - Wrong value for very small prices from Finance::Quote. > • Bug 798916 - Exchange rates fetched from openexchange off by factor > of 10 > • Bug 798919 - Inconsistent signs in creating budget > • Bug 798923 - OFX import is no longer matching security nor asking for > stock account. > • Bug 798930 - invoices won't sequence to the next number > • Bug 798948 - XML file corrupted by saving twice in extremely short > period > • Bug 798952 - Unable to set day threshold or counters in properties. > • Bug 798960 - Transaction completion horizontal scrolling opens > without the new text being visible and remembers previous position/width > • Bug 798966 - Uninitialised variable used in > dialog-account-picker.c:dialog_response_cb() > The following fixes and improvements were not associated with bug reports: > > • The type-ahead selection of transaction descriptions has been > substantially overhauled based on extensive user feedback. Matches are now > only on the beginning of words and are now sorted by age since last use. This > both substantially reduces the number of matches and prioritizes the most > recently used as being the most likely candidates for re-use. To help > distinguish cases of long descriptions where the match would be outside the > popup's viewport the viewport is automatically scrolled horizontally so that > the end of the left-most (right-most in rtl languages) matches is centered in > the view. Completion can be aborted with the key or a new Don't > autocomplete selection that's the first entry in the popup. > • Fix lockup on Windows in type-ahead selection of transaction > descriptions. > • More budget-module sign fixes and improvements. > • Lots of memory-leak fixes, GLib modernization, and code cleanup by > Richard Cohen, Simon Arlott, & Chris Lam. > • bugfix xaccTransGetTxnType: avoid returning TXN_TYPE_LINK > incorrectly: A TXN_TYPE_PAYMENT will have non-APAR splits; a TXN_TYPE_LINK > will not have non-APAR splits. This bug manifests as a regular > TXN
[GNC] ANNOUNCE: GnuCash 5.2 Released
), Croatian, English (Australia), English (New Zealand), English (United Kingdom), Estonian, French, German, Hungarian, Lithuanian, Marathi, Norwegian Bokmål, Polish, Portuguese, Romanian, Spanish, Swedish, Ukrainian Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/ Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced Documentation Concurrent with the release of GnuCash 5.2 we're pleased to also release a new version of the companion Manual and the Tutorial and Concepts Guide: There are no changes in the documentation for this release. Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. GnuCash is also available as a flatpak from Flathub.org. Instructions for installing and running: https://wiki.gnucash.org/wiki/Flatpak The SHA256 Hashes for the downloadable files are: • 4826176b7e70bb889f99c206faffadd892628d78525715e9f7128ecf48b14680 gnucash-5.2.tar.bz2 • 2d594cc889bb723746beb490f50853ccfb987b6e99e0a4587b058c51ca2a75a3 gnucash-5.2.tar.gz • 8299701f54d9b19743cbe90f1f369a4c998fd87436571d1b8fc630e7c71ffc13 gnucash-5.2.setup.exe • f7f0c82976755d228c32f71db4db8bde4e5de40c161011071dc39cac1f6f5a20 Gnucash-Intel-5.2-1.dmg • b9eb6581b403665c308b8909cc4d588c9ce483139cbc3ed3638403f61aefb49b gnucash-docs-5.2.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/5.2/gnucash-5.2.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.2/gnucash-5.2.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/5.2/Gnucash-Intel-5.2-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.2/Gnucash-Intel-5.2-1.dmg Getting GnuCash as source code If you want to compile GnuCash 5.2 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/5.2/gnucash-5.2.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/5.2/gnucash-5.2.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.2/gnucash-5.2.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.2/gnucash-5.2.tar.gz To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.22.29, Guile 2.0, Boost 1.67, WebKitGtk 2.4, GoogleTest 1.8.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation Note that the documentation for unstable releases is not on the GnuCash website. It is built daily and may be found on the development server under the locale directory; "C" is English, "de" is German, and so on. The documentation is included in the MacOS and Windows application bundles. If you want to compile the GnuCash Documentation 5.2 for yourself, the source code can be downloaded from: Sourceforge: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/5.2/gnucash-docs-5.2.tar.gz GitHub: https://github.com/Gnucash/gnucash/releases/download/5.2/gnucash-docs-5.2.tar.gz You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. Regards, John Ralls ___ gnucash-devel mailing list gnucash-de...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-announce mailing list gnucash-annou...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-announce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mutual funds total shares not showing up on Account Page.
Bill, Please remember to copy the list on all replies. It does not answer my questions. I'll try again: 1. What is the exact word or words at the top of the Accounts page over the column with the missing balances? 2. Are the balances actually missing, meaning that there is no entry at all, or does it show a zero (0) balance with the symbol for the fund? Regards, John Ralls > On Jun 18, 2023, at 3:00 PM, Bill Swanson wrote: > > Hi John, > > The number of shares purchased or sold get carried over to the Balance column > on the fund transaction page. This does not show up in the Totals on the > Account page for a few funds. > > Double clicking in the accounts name column takes me to the fund page but the > Balance amount does not show up in the Account page under Topals. > > I hope this answers your question. > > Your help is appreciated. > > Bill > > On Sun, Jun 18, 2023 at 5:53 PM John Ralls wrote: > What column heading are you using for total shares? Is the line in that > column blank or 0? > > Regards, > John Ralls > > > On Jun 18, 2023, at 1:00 PM, Bill Swanson wrote: > > > > There are a few mutual funds whose total shares do not show up on the > > Accounts page. I am using SqLite for the database. > > > > On the account page, when I double click on the fund it takes me to the > > fund page that shows the ledger but the total shares do not get carried > > back to the account page. > > > > What can cause a few funds not to show their totals on the account page? > > > > -- > > Bill Swanson > > 207-2443946 > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > -- > Bill Swanson > 207-2443946 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mutual funds total shares not showing up on Account Page.
What column heading are you using for total shares? Is the line in that column blank or 0? Regards, John Ralls > On Jun 18, 2023, at 1:00 PM, Bill Swanson wrote: > > There are a few mutual funds whose total shares do not show up on the > Accounts page. I am using SqLite for the database. > > On the account page, when I double click on the fund it takes me to the > fund page that shows the ledger but the total shares do not get carried > back to the account page. > > What can cause a few funds not to show their totals on the account page? > > -- > Bill Swanson > 207-2443946 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
> On Jun 16, 2023, at 9:42 AM, Bruce Schuck wrote: > > On 06/15/2023 12:23 -0700, Bruce S wrote: > >> Non-production release 1.56_02 is available for evaluation/testing. >> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz > > > It can be installed via cpan/cpanm as >> 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. > > The YahooWeb module currently requires the Date::Business module. Installing > it cannot be done unattended, as the Makefile.PL used requires a yes/no > question be answered. Not updated since January 2000, attempts to reach the > author have been unsuccessful so far. > Bruce, Maybe you could use Date::Manip::Date_PrevWorkDay instead? But either way it's pretty US-centric because of the holidays enumeration. What about the Monday-Friday trading days assumption? Is that valid for all of the stock markets that Yahoo can get quotes for? 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Hard-Copy Report Output
/app is an alias for that long path when you're running inside the flatpak shell, see https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools. Unless you also run a browser in the same flatpak shell--installing the browser with flatpak won't work, that will create a different container--the browser can't see the alias. I don't know offhand if there's a way for GnuCash to tell that it's running inside a flatpak or to get the outside-the-flatpak path to /app, but even if it could the URI would get invalidated the next time you update the GnuCash flatpak. Regards, John Ralls > On Jun 12, 2023, at 1:10 PM, rsbrux via gnucash-user > wrote: > > Thanks for the tiüp, Vincent, but these things don't add up in the flatpak > installation. > > In the Help - About dialog, GNC_DATA is shown as "/app/share/gnucash", which > is also the path used in the HTML file. > > However, clicking on the link leads to > "/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f/files/share/gnucash/" > which does, in fact, contain a sudirectory "chartjs", which in turn contains > both "Chart.bundle.min.js" and "Chart.bundle.js". > > Evidently the HTML generation doesn't take the possibility of a flatpak > installation into account. I suppose I should file a bug for this, but I > wouldn't know where. > > Thnaks for your help! > > On 12.06.23 20:20, Vincent Dawans wrote: >> Not that it might solve your underlying issue, but here is a reliable way to >> locate Chart.bundle.min.js assuming it was installed correctly with the rest >> of GC. This should work on any OS. >> >> 1. Open GC and go in menu Help - About >> 2. In that dialog window, look for the entry for GNC_DATA. It's the last one >> in the list. It should point to a directory path, for instance on Windows >> C:\Program Files (x86)\gnucash\share\gnucash but it will be different on >> ubuntu, etc. >> 3. Navigate to that directory using whatever means your OS gives you to do >> that (File Manager, console, etc). In that directory that GNC_DATA is >> pointing to, you should find a subdirectory called chartjs. That is where >> Chart.bundle.min.js should be located and if any html file is pointing to it >> that ia what the path should be. >> >> On Mon, Jun 12, 2023 at 11:03 AM rsbrux via gnucash-user >> wrote: >> >>> On Jun 11, 2023, at 9:56 AM, Adrien Monteleone >> wrote: >>>Is this a completely custom report or just a saved configuration? >>If completely custom, you may want to try the -dev list. >> >>This is a report I assembled from the options available in the GC >>GUI (like the pie chart you successfully tested). >>Unfortunately, I am not competent to use the programming >>facilities behind GC's report generation. >> >> >>> On Jun 11, 2023, John Ralls wrote: >>>It's most likely a javascript problem. Open the javascript >>console in your browser and see if there's an error finding >>Chart.bundle.min.js. >>>The correct location is >>/share/gnucash/chartjs/Chart.bundle.min.js where >>is where GnuCash is installed: /usr for a Linux package manager >>installation, /Applications/Gnucash.app/Contents/Resources for a >>macOS bundle, C:\Program Files (x86)\gnucash for Windows, etc. >>> >>>You can fix the link by editing the html file in your favorite >>text editor. >> >>I have tried opening the exported HTML reports in Firefox on >>Ubuntu and in Edge and Firefox on Windows. Although the browser >>consoles show errors, I don't see any pertaining to " >>Chart.bundle.min.js", nor do I find any critical errors pertinent >>to the report content. >>The new HTML reports are looking for Chart.bundle.min.js in >>/app/share/gnucash/chartjs/, but no such directory exists on the >>Ubuntu system where GnuCash is installed. In fact, there isn't >>even an /app/ directory. Perhaps this is due to GC being >>installed as a flatpak. >>Chart.bundle.min.js does not seem to exist on either system, so I >>edited the HTML as you suggested, replacing the local path with >>"https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.3.0/chart.min.js; >>but this did not improve matters. >>However, my previously saved HTML reports from GC 2.xx also don't >>display correctly, even though they contain no references to >>Chart.bundle.min.js. This suggests a more funda
Re: [GNC] Hard-Copy Report Output
It's most likely a javascript problem. Open the javascript console in your browser and see if there's an error finding Chart.bundle.min.js. The correct location is /share/gnucash/chartjs/Chart.bundle.min.js where is where GnuCash is installed: /usr for a Linux package manager installation, /Applications/Gnucash.app/Contents/Resources for a macOS bundle, C:\Program Files (x86)\gnucash for Windows, etc. You can fix the link by editing the html file in your favorite text editor. Regards, John Ralls > On Jun 11, 2023, at 9:56 AM, Adrien Monteleone > wrote: > > Is this a completely custom report or just a saved configuration? If > completely custom, you may want to try the -dev list. > > I just did a test and exported an Expense Pie Chart to HTML and opened it in > Firefox and it displayed as it should. If your chart/report isn't showing any > graphics at all, then I'd say it is an issue with the report itself, not > GnuCash. Since you were using it back in the days of version 2.19, I'd hazard > a guess that your report code needs to be updated as many changes with > respect to reports have been made since then. > > And while I could get the Expense Pie Chart to print in landscape, I couldn't > get it to break properly or scale to the page, but I also didn't try too hard > and that may still be possible. > > > Regards, > Adrien > > On 6/10/23 12:02 AM, rsbrux via gnucash-user wrote: >> Thanks for the advice, but these (custom) reports consist of pie charts and >> an accompanying legend. >> Without the graphics they are useless. >> The Html export still included them as of GC 2.19. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gunzip test.gnucash fails
I don't see any in my file. Edit a copy and load it. Regards, John Ralls > On May 28, 2023, at 10:51, Fred Tydeman wrote: > > Besides changing lines like: > tb > are there any other places I need to worry about? > > On Sun, May 28, 2023 at 4:26 AM Derek Atkins wrote: > >> For the record, yes, you can use gunzip, but you have to manually rename >> it >> first. >> Having said that, the name space is used throughout the file, so you might >> have a large editing job to do... And such editing is not supported. Make >> sure you have a good backup. >> -derek >> >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gunzip test.gnucash fails
gzip requires the compressed filename to end in `.gz`, which it will remove from the name of the uncompressed file. Just rename the file to test.gnucash.gz and unzip that: mv test.gnucash test.gnucash.gz gunzip test.gnucash.gz emacs test.gnucash Regards, John Ralls > On May 28, 2023, at 01:27, Fred Tydeman wrote: > > I am trying to unzip a copy of my gnucash file with: > gunzip test.gnucash > But, I get: unknown suffix -- ignored > I am running Fedora Linux 37 and Gnucash 4.14 > > I am trying to change the name of a parent security namespace which has > many children. I had hoped that I could edit the uncompressed XML file. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reporting currency
Reinstalling GnuCash won't change anything. There are two default currency preferences, one for reports and the other for creating new accounts. They both work the same way: They offer the locale currency, which is set from the environment, or a combo box with a currency you select. In order to enable the combo box you must first select the Choose radio item. Another option would be to change the environment so that the Locale currency is MYR. You can do that globally according to your OS or just for GnuCash, see https://wiki.gnucash.org/wiki/Locale_Settings. Finally, remember that you can change the currency in report options for each report individually. Regards, John Ralls > On May 25, 2023, at 05:29, David Long wrote: > > I have been using GnuCash on a laptop which became problematic, so I > installed it on a new laptop. Its so happened that I bought that laptop, > whilst in the UK, whereas the business I am using it for is in Malaysia, > where the currency is Malaysian MYR. > All the historic data is MYR. However, when I installed Gnucash, it seemed > to have defaulted to British Pounds as the local currency. So now the > reporting does not work, as it tries to report in Pounds. > > I have tried to change the local currency in Preferences, wherever I can > find it, but I cannot change the local currency as it is greyed out. > > What can I do?I am thinking I should reinstall GnuCash. > > Thanks > > David Long > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quotes stopped working
GnuCash crashed? What was the old source? Regards, John Ralls > On May 22, 2023, at 12:25, Bob Atwell wrote: > > OK, I think I fixed it by changing the source in the Securities Editor. > > Bob. > > > On Mon, May 22, 2023 at 10:19 AM Bob Atwell wrote: > >> I uninstalled and reinstalled Perl. I ran Install Online Price Retrieval >> for GnuCash and everything seemed fine. I opened GnuCash and ran Get Quote, >> seemed to go OK for a bit and then crashed. Re-tried with the same result. >> Not a happy camper. >> >> Bob. >> >> >> On Mon, May 22, 2023 at 9:11 AM Murugan Muruganandam < >> m.muruganan...@hotmail.com> wrote: >> >>> before uninstalling perl, from the windows - Start menu - Gnucash >>> - Install Online Price Retrieval for GnuCash >>> >>> this should automatically fetch and install Finance quote 1.54 >>> >>> if this works for you then you need not re install perl. >>> >>> uninstalling perl you can do it from control panel - Program Features >>> >>> for the latest strawberry perl you can download from >>> https://strawberryperl.com/ >>> >>> >>> >>> Saludos Cordiales >>> >>> >>> Murugan >>> -- >>> *From:* Bob Atwell >>> *Sent:* Monday, May 22, 2023 11:55 AM >>> *To:* Murugan Muruganandam >>> *Cc:* gnucash-user@gnucash.org >>> *Subject:* Re: [GNC] Finance::Quotes stopped working >>> >>> I am on Windows 11 and I think I will need to uninstall and reinstall >>> Perl. What is the right procedure for doing that? >>> >>> Bob. >>> >>> >>> On Mon, May 22, 2023 at 7:50 AM Murugan Muruganandam < >>> m.muruganan...@hotmail.com> wrote: >>> >>> >>> Bob >>> >>> please detail your operating system and the Finance Quote. >>> >>> Did you install finance quote again after installing 5.1 version >>> >>> >>> >>> Saludos Cordiales >>> >>> >>> Murugan >>> -- >>> *From:* gnucash-user >> hotmail@gnucash.org> on behalf of Bob Atwell >>> *Sent:* Sunday, May 21, 2023 2:17 PM >>> *To:* gnucash-user@gnucash.org >>> *Subject:* [GNC] Finance::Quotes stopped working >>> >>> A couple of weeks ago I started getting an error message when I tried to >>> get quotes. (Everything worked fine prior to that.) >>> After updating to 5.1 I got the same or similar message saying I needed an >>> AlphaVantage API >>> I got one and put it into the preferences but then I got a different error >>> message: >>> >>> >>> Quotes for the following commodities were unavailable or unusable >>> >>> * FUND:VTI Finance::Quote reported failure with error ... >>> >>> and then something about a premium endpoint. >>> >>> >>> Any ideas on how to solve this? Why on earth would standard Vanguard Funds >>> require a premium key? >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >>> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] report cutoffs - Trial Balance opening date
> On May 19, 2023, at 09:40, Michael or Penny Novack > wrote: > > On 5/18/2023 11:56 PM, David T. via gnucash-user wrote: >> Per the documentation: >> >> >> 10.3.5.11. Trial Balance >> >> >> Trial Balance lists the ending balances in all accounts as of a particular >> date. It is typically run at the end of an accounting period and is >> primarily used to ensure that the total of all debits equals the total of >> all credits. >> >> >> By definition, that means there *isn't* a start date. >> >> David T. > > > Also do note --- the trial balance was an important tool in the old days of > pen and ink on paper bookkeeping. All sorts of errors while entering numbers > or transcribing them during posting could lead to a condition of total debits > not equaling total credits. In other words, this was your warning that there > was an error somewhere, and that this error has a date in between the > previous date a trial balance was run and found correct and this one. > > You did not proceed with other reports, closing the books, etc. until the > error was found and corrected and the trial balance "clean". > > Might I point out that computerized accounting software like gnucash will NOT > allow entry of an out of balance transaction nor will a transcription error > be made. When I say won't allow I am including the special accounts orphan > and imbalance. In other words, you CAN enter a transaction not in balance as > far as the intended accounts are concerned; but the out of balance amount > will be a debit or credit in imbalance. So .. > > A non-zero balance in the special account imbalance is just like a trial > balance not being in balance. I have never run a trial balance using gnucash, > just confirmed that the balance of imbalance was zero. > > Michael D Novack > > PS --- a clean trial balance does NOT mean the books are free of error. Just > that free of certain kinds of error. There are many other sorts of errors > possible (like putting something in the wrong account) that will not throw a > trial balance out of balance. That's all correct *as long as there's only one commodity in the book*. As soon as you introduce a second commodity you have the opportunity for failing to record trading gains and losses and that will cause the book to be out of balance even though all of the transactions balance. This will be apparent if there's an automatically generated Realized Gains or Realized Losses line on the balance sheet report. The Trial Balance report with the price source set to average cost is the best tool for finding the accounts that need their gains or losses accounted for. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura
> On May 17, 2023, at 22:34, Bruce Schuck wrote: > > On 5/17/23 7:02 PM, John Ralls wrote: > >> That's interesting, but running your test from the end of that GitHub issue >> I get: >> ``` >> $ Hector:/Users/john> perl -MTest2::Plugin::NoWarnings -e 'print >> "$Test2::Plugin::NoWarnings::VERSION\n"' >> 0.09 >> $ Hector:/Users/john> perl -MTest2 -e 'print "$Test2::VERSION\n"' >> 1.302193 >> ``` >> DateTime::Locale also installs without error including passing all of its >> tests. Mind, I've had F::Q installed on it for a while. >> I'm running the current 13.4 developer beta. > > On the virgin OS out of the box, Test2 module is in the included Perl but its > version is 1.302162 (at least on 13.3.1). But if you look at the file > /System/Library/Perl/Extras/5.30/Test2/Plugin/NoWarnings.pm, line 9 is > > use Test2 1.302167; > > One would think that if the OS supplied bundle has a Perl module that > requires at minimum version of another module, the required module would be > that version or later. Not the case. The key here is until doing this testing > ** no other additional perl modules were installed **. > > Either 13.4 has more recent modules in the OS supplied Perl, or you updated > Test2 at some point in the past. > > I probably should have add the output of > > perl -MTest2 -e 'print "$Test2::VERSION\n"' > > in my comment, but before I installed *any* additional modules, it was > 1.302162 as noted above. > > I didn't want remove the OS supplied Test2::Plugin::NoWarnings, but I would > bet reinstalling it would trigger the correct dependency of Test2 also > getting installed. The 0.09 version already installed/included is the most > current release. Bruce, Indeed, /System/Library/Perl/5.30/Test2.pm version is 1.302167. 1.302193 is the version in /Library/Perl/5.30/Test2.pm meaning that I installed it via cpan. I added it to gnc-fq-update a couple of years ago to deal with https://bugs.gnucash.org/show_bug.cgi?id=798180. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura
> On May 17, 2023, at 15:31, Bruce Schuck wrote: > > While testing an install of Finance::Quote on a somewhat fresh out of the box > MacBook Pro running Ventura 13.3.1, some issues with the bundled Perl were > discovered. > > At first I thought it may have been prerequisites not properly defined for > DateTime::Locale, but a deeper analysis showed that the bundled Perl has > modules such as Test2::Plugin::Warnings with dependencies on modules that are > *not* part of the OS packaged Perl bundle. > > See https://github.com/houseabsolute/DateTime-Locale/issues/36 for the thread > between myself and the module's maintainer. Bruce, That's interesting, but running your test from the end of that GitHub issue I get: ``` $ Hector:/Users/john> perl -MTest2::Plugin::NoWarnings -e 'print "$Test2::Plugin::NoWarnings::VERSION\n"' 0.09 $ Hector:/Users/john> perl -MTest2 -e 'print "$Test2::VERSION\n"' 1.302193 ``` DateTime::Locale also installs without error including passing all of its tests. Mind, I've had F::Q installed on it for a while. I'm running the current 13.4 developer beta. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tax report options
> On May 14, 2023, at 19:24, flywire wrote: > > GnuCash Tax reporting feature doesn't work for Australia. Nor are they intended to be. TXF is a format invented by a US company, Intuit, to transfer information from their Quicken personal finance manager to their US tax-reporting program Turbotax. Other programs adopted the format as a defacto standard. The codes are keyed to US tax forms. The code is in a directory named libgnucash/tax/us and gnucash/report/reports/locale-specific/us. There's a maintained German interpretation in libgnucash/tax/de_DE and gnucash/report/reports/locale-specific/de_DE, but it hasn't had any substantive maintenance in 12 years. A PR for an Australian version would be welcome, but for it to be really useful somebody has to maintain it like Alex does the US one. Even that ignores the other end of the equation, the tax program to import the TXF data. FWIW I have fairly complex taxes but i find it easier to run a balance sheet and income statement for the end of the year and just fill out the Turbotax questionnaires from that than to maintain the ever-changing relationships between accounts and TXF categories. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
