Re: [GNC] GnuCash 4.4 Announcement/GnuCash 4.3 Announcement
Following up, Derek reconfigured his network so that code.gnucash.org supports IPv6. This is a first test to see if that changes the way my mail gets routed. If it goes through I'll try resending the 4.4 announcement with the copies. Regards, John Ralls > On Dec 30, 2020, at 8:41 AM, John Ralls wrote: > > > >> On Dec 30, 2020, at 6:24 AM, D. via gnucash-user >> wrote: >> >> Thanks, but the point is that the Gnucash project's standard practice-- that >> is, to post release announcements on the user and devel lists-- did not >> occur in this instance. >> >> @Frank: I didn't notice that your link was to a message in gnucash-announce. >> I don't know what the information flow typically is, but would assume that >> there is some script that repackages the announcement message and sends it >> along to the other lists as appropriate. Clearly, that didn't happen with >> these messages. I'd hazard a guess that most users only subscribe to the >> users list, and won't know about the new release otherwise. > > David, > > Nothing that fancy. I write the release notes for the website using the git > log and a previous release notes, copy & paste it from a browser window into > a blank email, address the email to gnucash-announce cc gnucash-devel and > gnucash-user with reply to gnucash-user, and send it. > > That usually works fine, but this time it went into the bit-bucket somewhere > between my ISP's smtp server (which my logs show acknowledging receiving it) > and Derek's. No bounce or error messages, just poof. Same with 3 resends on > the 4.3 announcement and one on the 4.4, so I sent the referral email to > gnucash-user that begins this thread. On a whim I tried resending without the > cc's and that went through, though only users who're subscribed to > gnucash-announce will have gotten them. That's what Frank linked to. > > Regards, > John Ralls > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 4.4 Released
The GnuCash development team announces GnuCash 4.4, the fifth release in the stable 4.x series. This is an unscheduled snap release to fix bug 798063. Between 4.3 and 4.4, the following bugfixes were accomplished: • Bug 798038 - Incorrect spelling in german account templates 'common' and 'full' part 2: AT • Bug 798063 - Crash when opening SX Editor No other improvements were made. Deprecations • xaccAccountCountSplits: use gnc_account_has_child_splits • gnc:html-table-append-column!: Build a new table with all of the columns and copy in the rows. Updated Translations: German, Italian, Japanese Known Problems Complete list of all open bugs. . Documentation Concurrent with the release of GnuCash 4.4 we're pleased to also release a new version of the companion Help and Tutorial and Concepts Guide Between 4.3 and 4.4, the following bugfixes were accomplished: • Bug 798038 - Incorrect spelling in german account templates 'common' and 'full', part 3: docs 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. The SHA256 Hashes for the downloadable files are: • d91e0d126b461d71de1bc1b20d9cf142704353dec07d3e6599d138422759e67a gnucash-4.4.tar.bz2 • 521ad979f0d59c3568a6300644d7cf435ebd829b1c2eea88752e983b2fce08b5 gnucash-4.4.tar.gz • 34879ef4957a2768f96747ca4f6f8732107d23cac5132d6dc655ae8e53e3798c gnucash-4.4.setup.exe • e6627feea1eb4aa6eafb05dd434fc2bc6954322152d8559f78901848c64631ca Gnucash-Intel-4.4-1.dmg • 298977e7dddce83335e1f988e6977cb010e37b289c31d09b15df4af526e4ba35 gnucash-docs-4.4.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/4.4/gnucash-4.4.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/gnucash-4.4.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/4.4/Gnucash-Intel-4.4-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/Gnucash-Intel-4.4-1.dmg GnuCash is now available as a flatpak from Flathub.org. Instructions for installing and running may be found at https://wiki.gnucash.org/wiki/Flatpak. Getting GnuCash as source code If you want to compile GnuCash 4.4 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.4/gnucash-4.4.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/4.4/gnucash-4.4.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/gnucash-4.4.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/gnucash-4.4.tar.gz You can also checkout the sources directly from the git repository, see https://wiki.gnucash.org/wiki/Git for instructions. To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.24, Guile 2.0, Boost 1.54, WebKitGtk 2.4, GoogleTest 1.7.0, cmake 3.10 and SWIG 2.0.12 if compiling from git. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation If you want to compile the GnuCash Documentation 4.4 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.4/gnucash-docs-4.4.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.4/gnucash-docs-4.4.tar.gz Note that the documentation for stable 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. 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't get GNUCASH to work on OSX
Adrien, Please don't tell users to change the priority or severity of bugs in bugzilla except to mark enhancements. That's the only thing we use those fields for. Regards, John Ralls > On Jan 2, 2021, at 10:49 AM, Adrien Monteleone > wrote: > > Crashes should be filed at bugs.gnucash.org, put 'Crash' at the beginning of > your subject line for the bug and mark it as 'critical' severity. > > Be sure to attach the crash report from Console.app to your bug report. > > Also, check the wiki concerning TraceFiles while it gets overwritten on each > use, if you can get the crash to repeat, also attach the TraceFile before > re-opening GnuCash post crash. > > Regards, > Adrien > > On 1/1/21 2:57 PM, Yves Forget via gnucash-user wrote: >> Hello, >> First, I’m a few days late. Second, the crash seems to happen only the >> first time after the app has been installed, so fixing this bug may not be >> the top priority of Gnucash developers. Anyways, here’s what I found. >> I’m running High Sierra 10.13.6. I’m using GnuCash for a couple of years >> now. Back in September, I saw GnuCash version 4 was out, and downloaded >> 4.1.2, but didn’t install it at that time. Last week I installed it >> (4.1.2). The first time I started the app, the icon bounced for a few >> seconds, then nothing. I started the app again, and it worked. >> After seeing this thread I looked in my Console app, and found a crash of >> GnuCash 4.1.2 on Dec 26. The app did not crash since then, so this must be >> the crash on the first run after installing it. Apple generated a crash >> file in ~/Library/Logs/DiagnosticsReports. The file is human readable. On >> the top of the file I can see that the app crashed on an exception >> EXC_BAD_ACCESS (SIGSEGV). Termination Signal 11 : Segmentation Fault. I >> can provide the file if needed. >> My Gnucash file is in SqLite format. I don’t know if the problem is related >> to that. >> I use VmWare Fusion on my Mac. It allows me to run a copy of OSX as a « >> Virtual Machine ». It allows me to run something in the VM, and then >> restore the VM to the original state. Since the problem occurs only the >> first time the app is run after installing, restoring the VM might help. If >> someone is interested with this issue, I could see if the bug is random or >> if I can reproduce it every time I start Gnucash after installing the new >> version, try with various file formats, etc. >> If I can help further please let me know ! > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't get GNUCASH to work on OSX
Yves, Thanks for the report. 4.1-2 is pretty old, but please open a bug report at https://bugs.gnucash.org and attach the crash report. Thanks, Regards, John Ralls > On Jan 1, 2021, at 12:57 PM, Yves Forget via gnucash-user > wrote: > > Hello, > > First, I’m a few days late. Second, the crash seems to happen only the first > time after the app has been installed, so fixing this bug may not be the top > priority of Gnucash developers. Anyways, here’s what I found. > > I’m running High Sierra 10.13.6. I’m using GnuCash for a couple of years > now. Back in September, I saw GnuCash version 4 was out, and downloaded > 4.1.2, but didn’t install it at that time. Last week I installed it (4.1.2). > The first time I started the app, the icon bounced for a few seconds, then > nothing. I started the app again, and it worked. > > After seeing this thread I looked in my Console app, and found a crash of > GnuCash 4.1.2 on Dec 26. The app did not crash since then, so this must be > the crash on the first run after installing it. Apple generated a crash file > in ~/Library/Logs/DiagnosticsReports. The file is human readable. On the > top of the file I can see that the app crashed on an exception EXC_BAD_ACCESS > (SIGSEGV). Termination Signal 11 : Segmentation Fault. I can provide the > file if needed. > > My Gnucash file is in SqLite format. I don’t know if the problem is related > to that. > > I use VmWare Fusion on my Mac. It allows me to run a copy of OSX as a « > Virtual Machine ». It allows me to run something in the VM, and then restore > the VM to the original state. Since the problem occurs only the first time > the app is run after installing, restoring the VM might help. If someone is > interested with this issue, I could see if the bug is random or if I can > reproduce it every time I start Gnucash after installing the new version, try > with various file formats, etc. > > If I can help further please let me know ! > > Thanks, > > Yves > >> Le 29 déc. 2020 à 15:58, David H a écrit : >> >> Ralph, >> >> Go to system prefs under Security and Policy and see if there's a prompt >> to allow Gnucash to run - working from memory here so I think that's where >> it used to show up for me. >> >> Michael, >> >> Check your system prefs under Security and Policy - I have "Allow apps >> downloaded from:" set to "App Store and identified developers" and don't >> get prompted to allow a new version to run. All I ever do is mount and >> open the dmg, CTRL-A to select all files and in Applications CTRL-V to >> paste and select copy over if I already have Gnucash installed. >> >> Cheers David H. >> >> >> On Tue, 29 Dec 2020 at 22:16, Michael Hendry >> wrote: >> >>>> On 29 Dec 2020, at 12:08, Ralph Musto via gnucash-user < >>> gnucash-user@gnucash.org> wrote: >>>> >>>> HI all, >>>> I have been trying to install GNUCASH on OSX 10.14.6 but with no >>> success. New set-up, fresh install. >>>> >>>> After download and moving the app to Applications. When I run it the >>> Icon bounces in the dock for a second or two and then just disappears. No >>> error messages, nothing. >>>> >>>> Anybody know how I can find out and fix what is wrong? >>>> >>>> Thanks, >>>> Ralph >>> >>> Just try running it again - this appears to be a “feature” of MacOS. >>> >>> I downloaded, installed and ran “Check and Repair” on all my books this >>> morning, but I did have to run the new version twice. >>> >>> Michael >>> >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/
Re: [GNC] Support message:// for transaction associations
No, mailto: is different. It tells the mail client to create a new message with the header filled in with the URI. message: [1] opens a received message-id. However, it's apparently supported only by Apple mail on macOS, so it doesn't really make sense to support it in GnuCash. One can easily use File>Export as PDF in Apple Mail and link to the saved PDF in GnuCash. Regards, John Ralls [1] https://www.iana.org/assignments/uri-schemes/prov/message > On Jan 2, 2021, at 6:15 AM, Derek Atkins wrote: > > Hi. > First, the more cross-platform uri would be mailto: > Second, the issue is that gnucash catches all uris internally so there are no > external bindings. > > -derek > Sent using my mobile device. Please excuse any typos. > On January 2, 2021 9:42:48 AM Ira Fuchs wrote: > >> I am running Gnucash for under MacOS mojave. On MacOS it is possible to get >> a URL that takes you to a mail message(in mail.app). The URL is of the form >> >> . If I >> enter this URL as the location for an association and then try to go to it >> in gnucash, I get the error message that the file cannot be found. (If the >> URL is pasted into Safari, it opens the email message directly). It would be >> very helpful if Gnucash associations could point to email invoices directly. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Does GNUCash support IRR in 2021?
> On Jan 4, 2021, at 7:01 AM, G Simba wrote: > > > I have seen some thread discussed IRR in 2011 and 2015. > But when I use GNU Cash 4.4, the Rate of Return in Advanced Portfolio still > work without IRR support. > > Does GNUCash support IRR in 2021? Any suggestions for calculating IRR in > GNUCash, or export my data to other program which can easily solve IRR from > exported from GNUCash? > No, GnuCash does not provide an IRR function. The only way I can think of to do an IRR is to fashion a query in the Find dialog that collects all of the relevant transactions and run a transaction report on the resulting ledger. From the report you can copy-and-paste into a spreadsheet and set up an IRR calculation. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] What does OFX Direct Connect do?
Please remember to copy the list on all replies. GnuCash does not have such a list, but the website http://ofxhome.com maintains a directory of US financial institutions that do or did support OFX Direct Connect. Be sure to check the bottom of the institution's page to see when the ofxhome test script last ran successfully. If your existing FI decides to support only Quicken then your options are to switch to somewhere that still supports OFX Direct Connect (a steadily dwindling list), switch to manually downloading your transactions in one of the formats GnuCash supports, or getting Quicken. Regards, John Ralls > On Jan 4, 2021, at 1:19 PM, Steve Cohen wrote: > > and if your financial institution, like American Express, forces you to > maintain an account with Quicken in order to download QFX files, what, short > of closing your account with them, are your options? Does GNUCash maintain a > list of institutions that do or don't support import of data? > > I quit Quicken several years ago because I was tired of being forced to > upgrade every 2 or 3 years to get a bunch of features I had no need of, yet > bug fixes I did have need of were never made. > > On Mon, May 18, 2020 at 10:09 PM John Ralls wrote: > No, OFX is a file format. Many financial/bank websites offer OFX or QFX > downloads of your transaction data; more in fact than offer OFX Direct > Connect. Since OFX (and it's slightly altered evil twin QFX, for Quicken > Financial eXchange) are formats expressly designed for transferring consumer > transaction information it's a more efficient and less error prone way to > import transactions into programs like GnuCash. > > If your bank offers OFX Direct Connect then GnuCash can connect to your bank > and get that OFX download. If not but allows downloading OFX-formatted files > then you go to the bank website, log in, and get the download, then use > File>Import>Import OFX/QFX to import it. > > Regards, > John Ralls > > > On May 18, 2020, at 2:20 PM, Fran_3 wrote: > > > > Woops! No ill intent. I've seen the same response on other SIG's when > > someone started a new thread that a groups member or admin thought should > > have been included in a recent thread on that some related topic. Oh well. > > > > Back to the topic... so OFX just saves you the steps of downloading the > > transactions as CSV and then having to do a bit of formatting before you > > import them into GC... right? > > > > > > > > On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls > > wrote: > > > > > > Don't hijack threads, it's rude. Start a new one when you have a new > > question. > > > > OFX Direct Connect is just like importing an OFX or QFX file downloaded > > from your bank's website except that it will connect to the bank and get > > the OFX file for you. > > > > Regards, > > John Ralls > > > > > > > On May 18, 2020, at 10:27 AM, Fran_3 wrote: > > > > > > If I can jump in here I would like to learn more about OFX Direct Connect > > > with GnuCash. > > > > > > Does such automatically determine what transactions occur at the bank > > > that are not in GC... > > > And then automatically update GnuCash? > > > > > > Or what? > > > > > > Thanks. > > > > > > > > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls > > > wrote: > > > > > > > > > > > > > > > > On May 17, 2020, at 12:06 PM, Hershey wrote: > > > > > > > > I'm new to Gnu and am having issues setting up online downloads. > > > > My first attempt is Wells Fargo and I get a 2000 error message. > > > > The Tutorial show Wells Fargo in its example but I've also seen this > > > > statement on the web: Wells Fargo has switched to OFX Web Connect. > > > > GnuCash > > > > doesn't support this authentication. > > > > > > That last sentence is your answer, but perhaps you need some more detail. > > > There are two ways of connecting to a bank for OFX online communication, > > > OFX Direct Connect and OFX Web Connect. The former collects your user > > > name and password as part of the online session and the latter has you > > > log in to the bank's website and launch the OFX session from there. The > > > way that the bank's website connects to the financial software is > > > proprietary to Intuit, th
Re: [GNC] What does OFX Direct Connect do?
See the list in File>Import. OFX/QFX, QIF, and CSV are what US banks use, the others are European. Regards, John Ralls > On Jan 4, 2021, at 1:33 PM, Steve Cohen wrote: > > "steadily dwindling list" - doesn't sound good. I never got direct > connection to work, but I was happy enough downloading my Amex card > transactions via QFX. Now I can't even do that. :-( Hmm. What options > besides .QFX does GnuCash support? As I recall, QFX was best. > > On Mon, Jan 4, 2021 at 3:28 PM John Ralls wrote: > Please remember to copy the list on all replies. > > GnuCash does not have such a list, but the website http://ofxhome.com > maintains a directory of US financial institutions that do or did support OFX > Direct Connect. Be sure to check the bottom of the institution's page to see > when the ofxhome test script last ran successfully. > > If your existing FI decides to support only Quicken then your options are to > switch to somewhere that still supports OFX Direct Connect (a steadily > dwindling list), switch to manually downloading your transactions in one of > the formats GnuCash supports, or getting Quicken. > > Regards, > John Ralls > > > > On Jan 4, 2021, at 1:19 PM, Steve Cohen wrote: > > > > and if your financial institution, like American Express, forces you to > > maintain an account with Quicken in order to download QFX files, what, > > short of closing your account with them, are your options? Does GNUCash > > maintain a list of institutions that do or don't support import of data? > > > > I quit Quicken several years ago because I was tired of being forced to > > upgrade every 2 or 3 years to get a bunch of features I had no need of, yet > > bug fixes I did have need of were never made. > > > > On Mon, May 18, 2020 at 10:09 PM John Ralls wrote: > > No, OFX is a file format. Many financial/bank websites offer OFX or QFX > > downloads of your transaction data; more in fact than offer OFX Direct > > Connect. Since OFX (and it's slightly altered evil twin QFX, for Quicken > > Financial eXchange) are formats expressly designed for transferring > > consumer transaction information it's a more efficient and less error prone > > way to import transactions into programs like GnuCash. > > > > If your bank offers OFX Direct Connect then GnuCash can connect to your > > bank and get that OFX download. If not but allows downloading OFX-formatted > > files then you go to the bank website, log in, and get the download, then > > use File>Import>Import OFX/QFX to import it. > > > > Regards, > > John Ralls > > > > > On May 18, 2020, at 2:20 PM, Fran_3 wrote: > > > > > > Woops! No ill intent. I've seen the same response on other SIG's when > > > someone started a new thread that a groups member or admin thought should > > > have been included in a recent thread on that some related topic. Oh well. > > > > > > Back to the topic... so OFX just saves you the steps of downloading the > > > transactions as CSV and then having to do a bit of formatting before you > > > import them into GC... right? > > > > > > > > > > > > On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls > > > wrote: > > > > > > > > > Don't hijack threads, it's rude. Start a new one when you have a new > > > question. > > > > > > OFX Direct Connect is just like importing an OFX or QFX file downloaded > > > from your bank's website except that it will connect to the bank and get > > > the OFX file for you. > > > > > > Regards, > > > John Ralls > > > > > > > > > > On May 18, 2020, at 10:27 AM, Fran_3 wrote: > > > > > > > > If I can jump in here I would like to learn more about OFX Direct > > > > Connect with GnuCash. > > > > > > > > Does such automatically determine what transactions occur at the bank > > > > that are not in GC... > > > > And then automatically update GnuCash? > > > > > > > > Or what? > > > > > > > > Thanks. > > > > > > > > > > > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls > > > > wrote: > > > > > > > > > > > > > > > > > > > > > On May 17, 2020, at 12:06 PM, Hershey wrote: > > > > > > > > > > I'm new to Gnu and am having
Re: [GNC] Linked document indicator not appearing.
> On Jan 5, 2021, at 6:24 AM, peterb wrote: > > I just linked a file to a transaction for the first time. The link is there > and seems to work mostly correctly (I can open it, and so on), but unlike > what the manual describes in Section 6.3, I see no "A" indicator in the > reconciliation cell. I am in the double-entry transaction journal view, as > required. Anyone else seeing this? > > I'm running GnuCash 4.2 (build 4.2+(2020-09-26), and have the register font > set to 24 pt arian narrow. It's not in the reconciliation cell, it's in the cell *under* the reconciliation cell in double-line view. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] balance sheet - eguile version: cannot change fonts
> On Jan 5, 2021, at 11:15 AM, Jürgen Jatzkowski wrote: > > I'm using Gnucash on two Macs (both running BigSur 11.1 and the same version > of GNC): > > Gnucash Version: 4.2 > Build ID: 4.2+(2020-09-26) > Finance::Quote: - > > Recently I updated (using brew) and noticed that the report "balance sheet - > eguile version" (I think it is stored as balsheet-eg.scm in the Gnucash app > folder) differs on both machines. Unfortunately one of the host renders the > report in a not-so-good-to-read font. > > Now I did some research and tried to understand the root cause for this > behaviour. After some hours struggling now I think it is time to ask here for > some help. Changing the font family in the options dialog didn't help - I was > not able to change the rendering. No matter which value I enter for the font > family it doesn't change. Changing the font size works pretty well. > > Any hint or help is highly appreciated :) The Homebrew recipe just downloads our Gnucash-Intel-4.x.dmg. You can prove that to yourself by running spctl --assess -vv /Applications/Gnucash.app in Terminal. You might want to do that anyway because if something's gotten corrupted on either machine that will tell you. Are both machines running 4.2? Have you assigned the same stylesheet to the report on both machines? Do you have any customizations on either? Perhaps a screenshot of each report would be helpful; it's hard to make useful comments based only on "one of them looks ugly". Remember to attach the screenshots to the very bottom of your reply so that the list server doesn't discard 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] balance sheet - eguile version: cannot change fonts
OK, that's the fontconfig bug. Upgrading to 4.4 will fix it. For a workaround, edit /Applications/Gnucash.app/Contents/Resources/etc/fonts/fonts.conf: - /Library/Fonts - + /System/Library/Fonts/Supplemental + /System/Library/Fonts /Library/Fonts fonts ~/.fonts You can use TextEdit or any other editor that can write plain text. Don't use a word processor like LibreOffice Write. Regards, John Ralls > On Jan 5, 2021, at 1:47 PM, Jürgen Jatzkowski wrote: > > $ spctl --assess -vv /Applications/Gnucash.app > /Applications/Gnucash.app: accepted > source=Notarized Developer ID > origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) > $ > >> Are both machines running 4.2? Have you assigned the same stylesheet to the >> report on both machines? Do you have any customizations on either? >> > > Yes, both machines are running 4.2. I've assigned the default stylesheet on > both machines. No customizations. > > Here is the screen shot from 1rst machine: > > > Here is the screenshot from 2nd machine (which is fine for me - although I > cannot change): > > > > > Best, > Jürgen > > > On 05.01.21 22:23, John Ralls wrote: >>> On Jan 5, 2021, at 11:15 AM, Jürgen Jatzkowski >>> wrote: >>> >>> I'm using Gnucash on two Macs (both running BigSur 11.1 and the same >>> version of GNC): >>> >>> Gnucash Version: 4.2 >>> Build ID: 4.2+(2020-09-26) >>> Finance::Quote: - >>> >>> Recently I updated (using brew) and noticed that the report "balance sheet >>> - eguile version" (I think it is stored as balsheet-eg.scm in the Gnucash >>> app folder) differs on both machines. Unfortunately one of the host renders >>> the report in a not-so-good-to-read font. >>> >>> Now I did some research and tried to understand the root cause for this >>> behaviour. After some hours struggling now I think it is time to ask here >>> for some help. Changing the font family in the options dialog didn't help - >>> I was not able to change the rendering. No matter which value I enter for >>> the font family it doesn't change. Changing the font size works pretty well. >>> >>> Any hint or help is highly appreciated :) >>> >> The Homebrew recipe just downloads our Gnucash-Intel-4.x.dmg. You can prove >> that to yourself by running >> spctl --assess -vv /Applications/Gnucash.app >> in Terminal. You might want to do that anyway because if something's gotten >> corrupted on either machine that will tell you. >> >> Are both machines running 4.2? Have you assigned the same stylesheet to the >> report on both machines? Do you have any customizations on either? >> >> Perhaps a screenshot of each report would be helpful; it's hard to make >> useful comments based only on "one of them looks ugly". Remember to attach >> the screenshots to the very bottom of your reply so that the list server >> doesn't discard them. >> >> Regards, >> John Ralls >> >> > > -- > juergen jatzkowski > > j...@patagonics.de ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Best way to upgrade from an old version (2.6.14) to current
> On Jan 8, 2021, at 8:53 AM, Tfastle via gnucash-user > wrote: > > A few years back I was going to switch from using Quicken to GnuCash. I > downloaded and spent a fair amount of time reading about GnuCash and getting > my Quicken Account imported. For me, it was a bit of a learning curve and a > lack of time thwarted my effort. I now hope to make the move for good. > > My plan is to initially run GnuCash on my old laptop which is where I have > the 2.6.14 version now and concurrently run Quicken on my new laptop > (basically entering all the same transactions) until I feel comfortable and > adept enough to abandon Quicken. I really only use Quicken as a glorified > register and tool to balance my main checking account but do have over 20 > years of those transactions with regard to it. The file I have in GnuCash > from my attempt a few years ago was imported from Quicken and represented > where that account was at that time. That GnuCash file is not of any value > or importance so abandoning it is an option and no problem at all. > > So my questions are: > > Should I "update" to the most current stable version of GnuCash or should I > just uninstall ver 2.6.14 and start over with the current stable version and > then import my current Quicken file? I suspect this is the best route to go > but, if for some reason updating is better, how might I best go about that? > > I tried to figure this from reading various post online but it was pretty > confusing. It appeared that files save in older versions often don't run in > newer versions so, to "update" (if it's even possible) I would need to go > through a series of updates to get current and still have my file read. If > I end up just starting over then I don't really care about that from a > "getting to current" perspective but it does bring one question to mind. > Once using the current version of GC how to avoid the problem of updating > but not being able to read your file from the prior version? Is it just a > matter of updating in a timely manner as new stable versions become > available and then your prior version file will always be able to be read? > I have to assume this is the case but would like to know before I put the > effort in to making this switch. I intend to use it for a long time and > would hate to one day just be out of luck but (I can't imagine that would > ever be the case). > > Lastly, it looks like the most recent stable release is 4.4, is that what I > should start with (or end up with via upgrade(s) )? > > Sorry for how long this is or for being so ignorant on the subject. The old GnuCash file still has a bunch of imports and starting with it will save you some time importing and perhaps training the import-matcher. Make a separate backup of it for an extra layer of safety. Since you didn't actually use GnuCash much it's probably safe to just install 4.4. The installer will take care of uninstalling your old 2.6.14. There's a bunch of upgrading that GnuCash will do on its first run and a bunch more on the first import, so be patient! If your existing file is large and your old laptop is slow or doesn't have a lot of memory it may take more than an hour--someone reported several hours for a very large file--to run all of the startup scrubs and then more hours to update the import maps, so plug in the laptop, turn off energy savers (it's OK to blank the screen but you don't want it to go to sleep), and plan to leave it running for a while. As you bring the GnuCash file up to date do small imports--a month or two worth of transactions--to begin. If most of the imported transactions are matched correctly then you can go to larger import batches, but if they're not then you'll want to do a half dozen or so small batches to train the matcher. Note that there's a recently added feature that allows you to select several transactions in the matcher window and assign all of them to the same transfer account; just right-click after selecting and pick Assign Account from the context menu (it's the only option). Remember to save frequently so that you can easily go back if something goes wrong. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to use/add GAU currency?
> On Jan 11, 2021, at 1:16 AM, Muhammad Bashir Al-Noimi > wrote: > > Hello, > > In my country we use GAU instead of XAU as a currency. How can I > add/use it in GnuCash? > > GAU = Gold Grams > > Ex. [1]https://goldprice.org/gold-price-per-gram.html > > I tried to add it as a new security with NASDAQ type but it only works > in stock accounts while I want it to works as Bank/Asset account. GnuCash supports only national currencies and a few precious metal commodities like XAU recognized by the ISO-4217 standard as currencies that you can have in a bank account. In practice it's unlikely that one should use the precious metal commodities that way; one can't pay for groceries in XAU or GAU so you *should* book them in a stock type account. The only significant restriction on stock accounts is that they can't be used in the business modules. GnuCash does not support barter. Your next problem is that the symbol GAU represents the stock Galliano Gold Inc. [1] that trades on the NYSE and that would be the quote you'd get from Finance::Quote. That doesn't mean you can't use GAU for gold priced in grams, just that you shouldn't turn on online quotes for 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Commission sales
Sorry Adrien, my ISP bounced the list cc so you get to see this twice. > On Jan 15, 2021, at 10:13 AM, Adrien Monteleone > wrote: > > the devs seem to take the approach that it is extremely rare for customers to > also be vendors and/or employees, or all three. From personal mom & pop small > biz experience, I beg to differ, but I understand trying to accommodate such > cases might be a bit messy for the code.) Adrien, I think that's mostly a justification of the internals, wherein a particular entity can be one of Customer, Employee, or Vendor and each of those types is closely coupled to the corresponding Invoice, Voucher, or Bill respectively. The workaround is straightforward: If the same entity is both a customer and a vendor then create an entry for each role. If you want to "wash out" payables and receivables you can make an asset account for the other part of the 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrade from portable 2.6 to 4.4
> On Jan 15, 2021, at 3:24 PM, W. Michael Schoel via gnucash-user > wrote: > > I am presently using GnuCash Portable 2.6.19 on win-10 and am attempting to > upgrade to GnuCash Portable 4.4 which is already installed and with the > accounts transferred from the older version. The accounts are all empty and > all my attempts to transfer the entry data have failed. I am concerned that > if my computer died I would loose all my GnuCAsh Data. > assistance would be appreciated 1. Make a proper backup of your GnuCash data (and any other data that you value) to at least two separate disks, one local and one as remote as you can manage so that you can recover if your disk or computer fails or your house burns down. 2. Set up a routine so that backup happens frequently. 3. To safeguard against data corruption, keep old backups. Now to the GnuCash issues: Portable Apps has in the past patched GnuCash sources, so we generally don't support their port. Supported GnuCash binaries are available from links at the top of https://www.gnucash.org. No "transfer" is needed, GnuCash is able to open files from a previous version. For absolute safety we strongly recommend that you load into the last dot release of each major series and run check and repair, then save and move to the next major. Since your' starting at 2.6.19 you should first install 3.11 and load your book(s), run check and repair, and save before trying to load them in 4.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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Recent list in file menu
You can also use the domain directly, e.g. defaults read org.gnucash.Gnucash Regards, John Ralls > On Jan 18, 2021, at 6:08 AM, w...@theprescotts.com wrote: > > Note: If you have Gnucash in a non-standard location like I do, you probably > will have to give the full path to the application. e.g. > > defaults read -app /Applications/Gnucash/Gnucash-4.4/Gnucash.app > > On 2021 Jan 18, at 01-18 04:20:33, Michael Hendry > wrote: > >> On 17 Jan 2021, at 20:11, David H wrote: >> >> You can easily check the mru details by doing the following... >> >> defaults read -app Gnucash >> >> or >> >> defaults read -app Gnucash | grep history >> >> Cheers David H > > Yes, I discovered how to read and write the relevant plist using “defaults”, > via the man page, and have also inspected it with Xcode. > > Here is the output from the command you suggested: > > => defaults read -app Gnucash | grep history > "/org/gnucash/history/file0" = > "/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash"; > "/org/gnucash/history/file1" = > "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash"; > "/org/gnucash/history/file2" = > "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash"; > "/org/gnucash/history/file3" = > "/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash"; > "/org/gnucash/history/file4" = > "/Users/michaelhendry/Documents/Accounts/MDH.gnucash"; > "/org/gnucash/history/file5" = > "/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash"; > "/org/gnucash/history/file6" = > "/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash"; > "/org/gnucash/history/file7" = > "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash.20200316161155.gnucash"; > "/org/gnucash/history/file8" = > "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash.20200108210937 > copy.gnucash"; > "/org/gnucash/history/file9" = > "/Users/michaelhendry/Documents/Accounts/Test_2019-10-26.gnucash"; > "/org/gnucash/history/maxfiles" = 6; > > I recently created “TestMRU.gnucash”, the following 4 files are those I > regularly use, and the final 5 are not currently in use. > > I still get only the 4 most recently opened files in the File menu, so if I > want to open MDH.gnucash, I have to use File->Open. > > After opening this file, your command yields the following: > > => defaults read -app Gnucash | grep history > "/org/gnucash/history/file0" = > "/Users/michaelhendry/Documents/Accounts/MDH.gnucash"; > "/org/gnucash/history/file1" = > "/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash"; > "/org/gnucash/history/file2" = > "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash"; > "/org/gnucash/history/file3" = > "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash"; > "/org/gnucash/history/file4" = > "/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash"; > "/org/gnucash/history/file5" = > "/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash"; > "/org/gnucash/history/file6" = > "/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash"; > "/org/gnucash/history/file7" = > "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash.20200316161155.gnucash"; > "/org/gnucash/history/file8" = > "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash.20200108210937 > copy.gnucash"; > "/org/gnucash/history/file9" = > "/Users/michaelhendry/Documents/Accounts/Test_2019-10-26.gnucash"; > "/org/gnucash/history/maxfiles" = 6; > > …which is as expected. > > If there’s another Mac user with more than four files in use, perhaps s/he > could report on what after the command: > > defaults write -app Gnucash "/org/gnucash/history/maxfiles” 6 > > (preferably with a before-and-after run of the "defaults read…” command). > > Regards, > > Michael > > PS I noticed that the values associated with the various keys are enclosed in > double-quotes, and tried > > defaults write -app Gnucash "/org/gnucash/history/maxfiles” “6” > > but the double-quotes don’t appear in the plist. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update
Re: [GNC] Recent list in file menu
And that turns out to be necessary: Unless you tell defaults -int it writes a string and GSettings decides that's the wrong type and won't use it. Incidentally, someone wondered how to do this on other OSes. In Linux you'd just use the DConf tool to create the key /org/gnucash/history/maxfiles. In Windows you must use Regedit. Find the key Computer\HKEY_CURRENT_USER\SOFTWARE\GSettings\org\gnucash\history and add to it a DWord value named maxfiles and set it to whatever value you like between 0 and 10. I've updated https://wiki.gnucash.org/wiki/FAQ#Q:_I_have_deleted_a_gnucash_file_from_my_computer._How_can_I_remove_that_file_from_the_File_menu.27s_short_list_.28MRU.29_as_well.3F with those instructions. Regards, John Ralls > On Jan 18, 2021, at 8:32 AM, Chris Graves wrote: > > If you open the plist file with Xcode or bbedit or ... you may see that the > maxfiles key is of type string, instead of integer. It may look like: > /org/gnucash/history/maxfiles > 6 > > Instead of > /org/gnucash/history/maxfiles > 6 > > You can manually change string to integer or do this: > defaults delete -app Gnucash "/org/gnucash/history/maxfiles" > defaults write -app Gnucash "/org/gnucash/history/maxfiles" -int 6 > > >> On Jan 18, 2021, at 2:20 AM, Michael Hendry wrote: >> >>> On 17 Jan 2021, at 20:11, David H wrote: >>> >>> You can easily check the mru details by doing the following... >>> >>> defaults read -app Gnucash >>> >>> or >>> >>> defaults read -app Gnucash | grep history >>> >>> Cheers David H >> >> Yes, I discovered how to read and write the relevant plist using “defaults”, >> via the man page, and have also inspected it with Xcode. >> >> Here is the output from the command you suggested: >> >> => defaults read -app Gnucash | grep history >> "/org/gnucash/history/file0" = >> "/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash"; >> "/org/gnucash/history/file1" = >> "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash"; >> "/org/gnucash/history/file2" = >> "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash"; >> "/org/gnucash/history/file3" = >> "/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash"; >> "/org/gnucash/history/file4" = >> "/Users/michaelhendry/Documents/Accounts/MDH.gnucash"; >> "/org/gnucash/history/file5" = >> "/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash"; >> "/org/gnucash/history/file6" = >> "/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash"; >> "/org/gnucash/history/file7" = >> "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash.20200316161155.gnucash"; >> "/org/gnucash/history/file8" = >> "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash.20200108210937 >> copy.gnucash"; >> "/org/gnucash/history/file9" = >> "/Users/michaelhendry/Documents/Accounts/Test_2019-10-26.gnucash"; >> "/org/gnucash/history/maxfiles" = 6; >> >> I recently created “TestMRU.gnucash”, the following 4 files are those I >> regularly use, and the final 5 are not currently in use. >> >> I still get only the 4 most recently opened files in the File menu, so if I >> want to open MDH.gnucash, I have to use File->Open. >> >> After opening this file, your command yields the following: >> >> => defaults read -app Gnucash | grep history >> "/org/gnucash/history/file0" = >> "/Users/michaelhendry/Documents/Accounts/MDH.gnucash"; >> "/org/gnucash/history/file1" = >> "/Users/michaelhendry/Documents/Accounts/TestMRU.gnucash"; >> "/org/gnucash/history/file2" = >> "/Users/michaelhendry/Documents/Accounts/ESJE.gnucash"; >> "/org/gnucash/history/file3" = >> "/Users/michaelhendry/Documents/Accounts/RotaryClub.gnucash"; >> "/org/gnucash/history/file4" = >> "/Users/michaelhendry/Documents/Accounts/RotaryCharity.gnucash"; >> "/org/gnucash/history/file5" = >> "/Users/michaelhendry/Documents/Accounts/CrashTest/A.gnucash"; >> "/org/gnucash/history/file6" = >> "/Users/michaelhendry/Documents/Accounts/CrashTest/B.gnucash"; >> "/org/gnucash/history/file7" = >> "/Users/michaelhendry/Document
Re: [GNC] Upgrade from portable 2.6 to 4.4
Thanks for the kind words, but please remember to copy the list on all replies. Regards, John Ralls > On Jan 18, 2021, at 9:58 AM, W. Michael Schoel wrote: > > Dear John > Thanks for your help and that from the rest of Gnucash, I am a strong > supporter of the open source community ( I prefer the term giftware as > generosity is the primary foundation of the community and what keeps it > going). Because of the particulars of my current life situation I am pretty > much on the receiving end of this generosity but also most appreciative of it. > To sum up : In the end I was able to move directly to Gnucash 4.4 Portable > with minimal effort. A number of years ago I made the decision to move to > using portable apps as much as possible possible as this greatly simplified > backup and maintenance of my computer system and data. I could demonstrate > that I could be up and running from a complete computer crash or move to a > new computer in less than an hour with no data loss and the new system being > a perfect mirror of the old. To do this I use a number of procedures but the > main one is having a PortableApps folder nest to my as empty as possible > Programs folder. Over the years portable versions of applications have become > more common and a number of Windows installers now have to option of choosing > a portable install come up at the start of the installation (no need to go > looking for a portable version). More recently I have been switching to linux > for more and more of my computing and am finding that the linux offerings to > this approach is not nearly as clean or simple. I have no appreciation of the > effort required but it would be nice if GnuCash fully adopted the Portable > and AppImage approach. This is particularly useful when using something like > Gnucash where preventing data loss and speeding up recovery from computer > problems are so important. > Just my opinion so far things have worked well for me and I thank you all for > your great work and support I like using the software and have minimal issues > even though I only use it for my personal finances which means only a few > times a month. > Best Regards > Michael > > > > > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 15, 2021 9:30 PM, John Ralls wrote: > >> >> >>> On Jan 15, 2021, at 3:24 PM, W. Michael Schoel via gnucash-user >>> gnucash-user@gnucash.org wrote: >>> I am presently using GnuCash Portable 2.6.19 on win-10 and am attempting to >>> upgrade to GnuCash Portable 4.4 which is already installed and with the >>> accounts transferred from the older version. The accounts are all empty and >>> all my attempts to transfer the entry data have failed. I am concerned that >>> if my computer died I would loose all my GnuCAsh Data. >>> assistance would be appreciated >> >> 1. Make a proper backup of your GnuCash data (and any other data that you >> value) to at least two separate disks, one local and one as remote as you >> can manage so that you can recover if your disk or computer fails or your >> house burns down. >> 2. Set up a routine so that backup happens frequently. >> 3. To safeguard against data corruption, keep old backups. >> >>Now to the GnuCash issues: >> >>Portable Apps has in the past patched GnuCash sources, so we generally >> don't support their port. Supported GnuCash binaries are available from >> links at the top of https://www.gnucash.org. >> >>No "transfer" is needed, GnuCash is able to open files from a previous >> version. For absolute safety we strongly recommend that you load into the >> last dot release of each major series and run check and repair, then save >> and move to the next major. Since your' starting at 2.6.19 you should first >> install 3.11 and load your book(s), run check and repair, and save before >> trying to load them in 4.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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Where does gnucash put the lock file on Linux?
Do I remember correctly that you're using the SQL backend? That works a bit differently because there's no way to have a lock file if you're connected to a DB server. Instead of a lock file it has a lock table inside the database. If you copy the database (and with SQLite3 it looks just like a file) when there's a lock record in the lock table then GnuCash will put up the "unable to obtain the lock" dialog box. Regards, John Ralls > On Jan 20, 2021, at 6:24 AM, Chris Green wrote: > > On Wed, Jan 20, 2021 at 09:04:52AM -0500, Derek Atkins wrote: >> Hi, >> >> On Wed, January 20, 2021 8:33 am, Chris Green wrote: >>> On Wed, Jan 20, 2021 at 08:23:23AM -0500, Derek Atkins wrote: >>>> Hi, >>>> >>>> The lock file is created in the same directory as the data file. >>>> Is that directory not writeable? That would cause the error. >>> >>> The directory is definitely writeable and there definitely isn't any >>> sort of lock file in the directory:- >>> >>>chris$ cd tmp/pcc/2020 >>>/home/chris/tmp/pcc/2020 >>>chris$ ls >>>building.gnucash building.gnucash.20210120121447.log general.gnucash >>>chris$ ls -al >>>total 504 >>>drwxrwxr-x 2 chris chris 4096 Jan 20 12:14 . >>>drwxrwxr-x 3 chris chris 4096 Jan 20 12:13 .. >>>-rw-r--r-- 1 chris chris 212992 Jan 20 12:14 building.gnucash >>>-rw-rw-r-- 1 chris chris381 Jan 20 12:14 >>> building.gnucash.20210120121447.log >>>-rw-r--r-- 1 chris chris 290816 Jan 20 12:14 general.gnucash >>>chris$ gnucash general.gnucash >>>Found Finance::Quote version 1.49. >>>chris$ >>> >>> The above sequence pops up the can't create lock file error. >> >> The "cannot obtain lock" error has multiple causes. Have you checked the >> Tracefile to see if there is anything printed that might suggest which >> error is happening? >> >> The error occurs when: >> 1) There is a lock file already there, or >> 2) There is NOT a lock file already present, but gnucash cannot create a >> new lock file >> >> If you're in case #2, then you won't see a lock file listed. >> >> Is your disk full? What do you get from: >> df /home/chris/tmp/pcc/2020 >> df -i /home/chris/tmp/pcc/2020/ >> > No, my disk isn't full:- > >Filesystem Type 1M-blocks Used Avail Use% Mounted on >/dev/nvme0n1p2 ext4 48174 13344 32315 30% / >/dev/nvme0n1p3 ext4896193 308524 542077 37% /home >/dev/sdb1 ext4 10016181 9307 2% /boot >/dev/sdb2 ext4109596 27675 76313 27% /scratch >/dev/sda1 ext4938772 225049 666014 26% /bak > >> Also, what kind of filesystem underlies /home/chris/tmp/pcc/2020 ? >> > Standard linux ext4 (as you can see above). > > >>>> If GnuCash cannot create (and lock) the lock file then it will throw the >>>> error. >>>> If you are SURE that there is not another process running, you can "Open >>>> Anyways" and that will clear the error. >>>> >>> Yes, I realise that, but it's not "right". :-) >> >> It depends on the underlying error. If the lock file is actually there >> but, say, gnucash crashed, then "Open Anyways" *is* the right solution. >> Obviously that's not the case here. >> > Yes, OK, there are cases where "Open anyway" is the right solution, > but there seems to be something else going on here. > > >>>> NB that gnucash may mix the metadata for two versions of the same-named >>>> file located in different directories. The GCM file does not contain >>>> the >>>> file location information. >>>> >>> I'm not quite sure I follow that, I do have general.gnucash in two >>> different places. Are you saying that this may cause problems and >>> that I should rename my 'previous year' accounts to (for example) >>> general2020.gnucash as well as moving them to a suitably named >>> sub-directory? >> >> If you open a file foo.gnucash, gnucash creatres a metadata file >> foo.gnucash.gcm in $HOME/.local/share/gnucash/books. Now, if you copy >> foo.gnucash from DIR1/foo.gnucash to DIR2/foo.gnucash, when you open >> DIR2/foo.gnucash it will use the same foo.gnucash.gcm file, because DIR1 >> vs DIR2 is not encoded anywhere. >> >> So yes, IF you decide to arc
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user
> wrote:
>
> Hello everyone,
>
> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big Sur
> (11.0). Despite not being officially supported, GnuCash itself works great,
> with the exception of Finance::Quote. The "get quotes" button in the Price
> Database is grayed out and the Security Editor has the warning
> "Finance::Quote isn't installed properly." When running Gnucash-cli, there is
> a similar error:
>
>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get
>> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>>
>
>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()]
>> Language list: en:en_US:C
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] 3 DBD
>> drivers found
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> pgsql
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> sqlite3
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> mysql
>> * 22:01:17 INFO [Gnucash::CoreApp::start] System locale returned
>> (null)
>> * 22:01:17 INFO [Gnucash::CoreApp::start] Effective locale set to
>> en_US.UTF-8.
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430, handler_id:
>> 1
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430,
>> handler_id: 2
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430,
>> handler_id: 3
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430,
>> handler_id: 4
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430,
>> handler_id: 5
>> No quotes retrieved. Finance::Quote isn't installed properly.
>> * 22:01:17 INFO [gnc_hook_lookup] no hook lists
>
> The error message above isn't particularly useful. It gets printed here:
> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>
> I'm pretty sure that Finance::Quote itself is installed properly. I'm not
> really sure why GnuCash does not recognize it.
>
>> $ sudo gnc-fq-update
>> Reading '/Users/username/.cpan/Metadata'
>> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>> Date::Manip is up to date (6.83).
>> Finance::Quote is up to date (1.49).
>
> A basic query shows that it does work:
>
>> $ echo '(yahoo_json "CSCO")' |
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00") (last
>> . #e45.19) (currency . "USD")))
>
BigSur absolutely is supported. What's not yet available yet is a native build
for Apple Silicon, but I've found so far that the Intel build of GnuCash works
fine with Rosetta2.
The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to get
it working after I upgraded, but one could also set $PERL5LIB in the
environment to include the old /Library/perl/5.18 as a workaround. If you did
that in a shell rc file it would make gnc-fq-helper work from terminal but not
from GnuCash when run from LaunchServices.
Does F::Q work when starting GnuCash from the terminal?
Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Updates on Windows
> On Jan 21, 2021, at 5:53 AM, David T. via gnucash-user > wrote: > > Hello, > > I've used GnuCash for a very long time, under different operating systems > (currently GC4.4 on WIndows 10), and I have a minor question about the > upgrade process under Windows. > > When I updated under MacOS, I was able to install multiple versions in > parallel simply by renaming the app bundle in Applications (for example, from > Gnucash.app to Gnucash-3.11.app). It was then possible to run either version, > if needed. Under Windows, however, the installation process begins by > removing the earlier version from the system. > > Setting aside the wisdom or folly aspect of having or running multiple > versions of GnuCash, I am curious why it is that the Windows installer always > removes the previous version before installing the next. While this is a > minor point, it *does* have an effect in my daily usage. I pin the Gnucash > icon to the taskbar, to make it easy to find and run (Aside: one of the > things I like least about Windows 10 is its management of the Apps menu). > When the new version gets installed, this is not preserved, and I have to > re-pin the icon after every update. As I've already noted, this is a minor > point, but it's the kind of oddity that sticks in my brain. > > Could someone explain this oddity to me? As Derek says, macOS is the odd one out because it alone has self-contained application bundles. Windows hard-codes paths in all sorts of metadata that make it difficult-to-impossible to have more than one installation of any particular program. Package managers, including MacPorts and Fink on macOS (Homebrew just downloads our dmg), have a fixed directory heirarchy that affords only one installation of any particular program. Users with enough knowledge of GnuCash's pieces can move things around and set up different environments to have more than one version installed, but that's beyond the average user. I suspect what's going on is that the pinned shortcut in the taskbar is a pointer or flag of some sort on the Start menu shortcut. The uninstaller deletes that and the installer makes a new one that doesn't have the flag set. You might try creating a separate shortcut that the installer doesn't know about and pinning that to the taskbar. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Justin, To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from terminal. I've been sticking print statements into price-quotes.scm and gnc-fq-check and looking at the results. It seems that there's something about the final printf in gnc-fq-check that chokes the guile read. I haven't figured out what yet and I'm out of time for today. But you've confirmed my suspicion about having a non-Apple-supplied perl. That will never work with the bundle launched from Finder because your shell environment, which includes the path to the Homebrew-installed perl, isn't read when launching an app bundle from Finder. You may be able to get it to work from the terminal that way. Regards, John Ralls > On Jan 22, 2021, at 4:48 PM, Justin via gnucash-user > wrote: > > So... it doesn't actually work quite yet, but GnuCash does recognize it. > Attempting to get quotes via the GnuCash-cli program results in a "unable to > retrieve quotes for these items" message, followed by all of my securities. > > The following will not work. It shows a bunch of missing dependency errors. > This is because I installed F::Q manually, and its dependencies were not > installed. > >> echo '(yahoo_json "FSKAX")' | perl -w gnc-fq-helper > > So I reinstalled perl (and wiped all of the modules). Then tried to install > F::Q via the Perl shell. If I do: > >> sudo perl -MCPAN -e shell >>> install Finance::Quote > > It will fail with the following error messages: > >> Result: PASS >> > >> ECOCODE/Finance-Quote-1.49.tar.gz >> > >> Tests succeeded but one dependency not OK (LWP::Protocol::https) >> > >> ECOCODE/Finance-Quote-1.49.tar.gz >> > >> [dependencies] -- NA >> > >> Failed during this command: >> > >> CHRISN/Net-SSLeay-1.90.tar.gz : make NO >> > >> SULLR/IO-Socket-SSL-2.068.tar.gz : make_test NO one dependency not OK >> (Net::SSLeay); additionally test harness failed >> > >> OALDERS/LWP-Protocol-https-6.10.tar.gz : make_test NO 2 dependencies >> missing (IO::Socket::SSL,IO::Socket::SSL::Utils); additionally test harness >> failed >> > >> ECOCODE/Finance-Quote-1.49.tar.gz : make_test NO one dependency not OK >> (LWP::Protocol::https) > > Net::SSLeay fails because it cannot find the "openssl/err.h" header. I've > installed openssl (with brew) and added the include directory to > $LIBRARY_PATH, but it still doesn't find it. This is the root of the problem. > I'm pretty sure if Net::SSLeay could be installed, everything else would fall > in place. If anyone knows how to get this working, please let me know. I'll > probably spend a little more time trying to figure it out tomorrow. > > Regards, > Justin > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 22nd, 2021 at 5:17 PM, Justin wrote: > >> Woo. I've made progress. So I manually installed the latest F::Q from there >> GitHub release (following their instructions): >> https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 >> > >> This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q >> v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by >> itself, it still prints F::Q v1.49. >> > >> Next, I tried running GnuCash from the ApplicationLauncher (or whatever it's >> called) but alas, F::Q didn't work. Then, I tried running GnuCash from the >> terminal. This **does** work! The GUI application shows F::Q v1.50. >> > >> I'm going to mess around with it a little more. I'm unsure why there's a >> discrepancy. >> > >> ‐‐‐ Original Message ‐‐‐ >> On Friday, January 22nd, 2021 at 5:07 PM, Justin wrote: >> > >>> Alright. I think I might have found part of the issue. >>> > >>> According to this line in GnuCash source, gnc-fq-check is run as an >>> argument to perl: >>> https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 >>> > >>> So I tried that out and it says F::Q is not installed. >>> > >>>> $ perl -w gnc-fq-check >>>> You need to install the following Perl modules: >>>> Finance::Quote >>>> Use your system's package manager to install them, >>>>
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Justin, Following up, I've worked out that gnc-fq-check is quitting (not crashing, there's no crash report in Console) in the call to Finance::Quote->new(). The only artifact is a message in Console on the Mac Analytics page "perl getgroupcount called triggering group enumeration". If I turn on message streaming on the main console (the tab with the system name) I also get "perl5.28 Too many groups requested (2147483647). Can cause performance issues when network directories are involved." 4 times. That same number is given as the com.apple.message.value in the getgroupcount message and happens to be the signed int representation of 0x8000. Regards, John Ralls > On Jan 22, 2021, at 5:10 PM, John Ralls wrote: > > Justin, > > To answer your earlier question, no, F::Q doesn't work for me either on my > DTK. I hadn't actually even tried to install it. It took two passes through > sudo gnc-fq-update to get a good install so that I could run gnc-fq-check > successfully from terminal. > I've been sticking print statements into price-quotes.scm and gnc-fq-check > and looking at the results. It seems that there's something about the final > printf in gnc-fq-check that chokes the guile read. I haven't figured out what > yet and I'm out of time for today. > > But you've confirmed my suspicion about having a non-Apple-supplied perl. > That will never work with the bundle launched from Finder because your shell > environment, which includes the path to the Homebrew-installed perl, isn't > read when launching an app bundle from Finder. You may be able to get it to > work from the terminal that way. > > Regards, > John Ralls > > > >> On Jan 22, 2021, at 4:48 PM, Justin via gnucash-user >> wrote: >> >> So... it doesn't actually work quite yet, but GnuCash does recognize it. >> Attempting to get quotes via the GnuCash-cli program results in a "unable to >> retrieve quotes for these items" message, followed by all of my securities. >> >> The following will not work. It shows a bunch of missing dependency errors. >> This is because I installed F::Q manually, and its dependencies were not >> installed. >> >>> echo '(yahoo_json "FSKAX")' | perl -w gnc-fq-helper >> >> So I reinstalled perl (and wiped all of the modules). Then tried to install >> F::Q via the Perl shell. If I do: >> >>> sudo perl -MCPAN -e shell >>>> install Finance::Quote >> >> It will fail with the following error messages: >> >>> Result: PASS >>> >> >>> ECOCODE/Finance-Quote-1.49.tar.gz >>> >> >>> Tests succeeded but one dependency not OK (LWP::Protocol::https) >>> >> >>> ECOCODE/Finance-Quote-1.49.tar.gz >>> >> >>> [dependencies] -- NA >>> >> >>> Failed during this command: >>> >> >>> CHRISN/Net-SSLeay-1.90.tar.gz : make NO >>> >> >>> SULLR/IO-Socket-SSL-2.068.tar.gz : make_test NO one dependency not OK >>> (Net::SSLeay); additionally test harness failed >>> >> >>> OALDERS/LWP-Protocol-https-6.10.tar.gz : make_test NO 2 dependencies >>> missing (IO::Socket::SSL,IO::Socket::SSL::Utils); additionally test harness >>> failed >>> >> >>> ECOCODE/Finance-Quote-1.49.tar.gz : make_test NO one dependency not OK >>> (LWP::Protocol::https) >> >> Net::SSLeay fails because it cannot find the "openssl/err.h" header. I've >> installed openssl (with brew) and added the include directory to >> $LIBRARY_PATH, but it still doesn't find it. This is the root of the >> problem. I'm pretty sure if Net::SSLeay could be installed, everything else >> would fall in place. If anyone knows how to get this working, please let me >> know. I'll probably spend a little more time trying to figure it out >> tomorrow. >> >> Regards, >> Justin >> >> ‐‐‐ Original Message ‐‐‐ >> On Friday, January 22nd, 2021 at 5:17 PM, Justin wrote: >> >>> Woo. I've made progress. So I manually installed the latest F::Q from there >>> GitHub release (following their instructions): >>> https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 >>> >> >>> This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q >>> v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by >>> itself, it s
Re: [GNC] USAA FSB requires newer QWIN support
Bob White already posted a sanitized OFX log file yesterday morning. The response from USAA is a fancy web page saying "Server Error" with no details about what kind of error. Regards, John Ralls > On Jan 29, 2021, at 6:57 PM, David Reiser via gnucash-user > wrote: > > There’s a note on Quicken’s pages that some USAA customers need to get a new > ID and PIN for transaction downloads (different from the rest of the USAA web > page credentials). I didn’t see any definitive info on who or why. > > The next step would be to look at the ofx log file — something you have to > turn on in Gnucash via environment variables. Directions are somewhere on the > wiki. > > The ofx log will tell you if your login was declined. Sometimes, you even get > an ofx error as partial indication of why. > -- > Dave Reiser > dbrei...@icloud.com > > > > > >> On Jan 29, 2021, at 9:16 PM, Jon Schewe wrote: >> >> Some additional data points. I was using appVer 2200 and got no >> transactions. I edited the aqbanking config file and changed the appVer >> to 2700, still no transactions. I changed the headerVer to 103, still >> no transactions. I tried adding a clientUid and that didn't help >> either. >> >> However I do not see any errors in the log window. >> >> According to the log I'm using AqBanking v6.2.1.0stable. >> >> >> On Thu, 2021-01-28 at 10:40 -0500, David Reiser via gnucash-user wrote: >>> The first thing to try is setting the appVer to 2700 (nine years >>> newer than 1800). >>> >>> If that doesn’t work on its own, try setting headerVer to 103 and >>> creating a clientUid >>> -- >>> Dave Reiser >>> dbrei...@icloud.com >>> >>> >>> >>> >>> >>> >>>> On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user < >>>> gnucash-user@gnucash.org >>>>> wrote: >>>> >>>> As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800 >>>> support. Can connect, but transactions are no longer downloaded. >>>> >>>> I confirmed with USAA. I am trying to get details on newer >>>> requirements from USAA but it is difficult--they will only >>>> troubleshoot with the actual Quicken app, which I do not have. >>>> >>>> Waiting on a callback from USAA. >>>> >>>> Has anyone else experienced these issues or know of a resolution? >>>> >>>> Thanks, >>>> >>>> Bob >>>> >>>> >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> >>>> To update your subscription preferences or to unsubscribe: >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> >>>> If you are using Nabble or Gmane, please see >>>> https://wiki.gnucash.org/wiki/Mailing_Lists >>>> for more information. >>>> - >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists >>> for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Description Field
David should have mentioned that there is a second text field available called Notes and that you select View>Double Line to access it, and yet another, Memo, that's associated with each split in a transaction; click the Split button in the toolbar or choose auto split or journal view in the View menu to access those. All of those names are indeed hard-coded. Regards, John Ralls > On Jan 31, 2021, at 7:13 AM, David Carlson > wrote: > > That's getting into an area that is hard coded. Some field names will > change depending on your language settings, but that's about it. > > On Sun, Jan 31, 2021 at 5:20 AM Gary Stewart > wrote: > >> Hi, I'm new to GnuCash and I was wondering if it is possible to change the >> Description Column heading to another name and then add an extra >> Description >> Field under a different heading to the main page? >> >> >> >> Thank you >> >> >> >> Gary >> >> >> >> -- >> This email has been checked for viruses by AVG. >> https://www.avg.com >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Run GNUcash from Mac Cloud iDrive
> On Feb 4, 2021, at 10:15 AM, John Donnee wrote: > > Hi Everyone. > > I am going to Florida for six weeks and will only have mu iPad with me. > > Question: > > Is there a way to have the App in the Mac Cloud so that I can run it from my > iPad since I have my Mac Cloud iDrive on my iPad. > I suppose you mean on some hosted macOS virtual machine connect to your iPad with VNC. Nobody's reported trying, but I don't see any reason that it wouldn't work: It does fine on VMWare Fusion VMs. Hosted macOS VMs tend to be expensive so keep in mind that GnuCash works on Linux and MSWindows too. Regards, JOhn Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Run GNUcash from Mac Cloud iDrive
No, nor would it make sense to do so: An invoice template is a combination of Scheme programming code and Cascading Style Sheet (aka CSS) style data. If you've created a custom stylesheet to apply to your invoices you'll find it in ~/Library/Application Support/Gnucash/stylesheets-2.0. Regards, John Ralls > On Feb 4, 2021, at 10:44 AM, John Donnee wrote: > > Thanks John,, Im just going to print out some invoices with advanced dates on > them. > > is there anyway to take a invoice template and save as an XL or CVS file. > > That would work for me until I gat hime and update my CUCash application. > > Thanks > > John > John Donnee > > 910.622.8111 > 317 Mount Eden Place > Cary, NC 27518 > >> On Feb 4, 2021, at 1:34 PM, John Ralls wrote: >> >> >> >>> On Feb 4, 2021, at 10:15 AM, John Donnee wrote: >>> >>> Hi Everyone. >>> >>> I am going to Florida for six weeks and will only have mu iPad with me. >>> >>> Question: >>> >>> Is there a way to have the App in the Mac Cloud so that I can run it from >>> my iPad since I have my Mac Cloud iDrive on my iPad. >>> >> >> I suppose you mean on some hosted macOS virtual machine connect to your iPad >> with VNC. Nobody's reported trying, but I don't see any reason that it >> wouldn't work: It does fine on VMWare Fusion VMs. Hosted macOS VMs tend to >> be expensive so keep in mind that GnuCash works on Linux and MSWindows too. >> >> Regards, >> JOhn Ralls >> >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled Transaction Mystery?
When you say you opened GnuCash, does that mean that you started it? Or has it been running since before 2 February and you switched to its window? If the former, when you started it for the first time did the Since Last Run window come up, what did it say about that transaction, and what did you do? Does the scheduled transaction have a variable that requires user input? Regards, John Ralls > On Feb 4, 2021, at 10:48 AM, Jack Slater wrote: > > It should be listed in the register for sure regardless and I have not > deleted it. I simply opened GnuC and looked and its not there. > > On Thu, Feb 4, 2021 at 12:42 PM Jean Laroche wrote: > >> I think if you set it up to create x days in advance, when the >> transaction is created, the "last occurrence" is set to the day of the >> transaction (no to the day it was created). So that would explain why >> you see "Last occurrence 2/5/21". >> >> Is it possible that you somehow deleted the occurrence that was created? >> >> J. >> >> On 2/4/21 10:19 AM, Jack Slater wrote: >>> Today is 2/4/21. >>> Transaction scheduled for the 5th of every month. >>> Looking at Scheduled Transactions, it reads Last Occurance 2/5/21. >>> Transaction options are set to Create Automatically and Create 3 days in >>> advance. >>> No transaction listed in register. >>> >>> Seems pretty illogical to me. What am I missing? >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 4.4 slow
Does it beachball long enough to get a process sample out of Activity Monitor? Better yet, do you know your way around Xcode well enough to get a time profile? Regards, John Ralls > On Feb 5, 2021, at 9:57 AM, R. Victor Klassen wrote: > > I should also say I’m using the SQLite back end. 90% or more of what I do > passes though the business features. When I say entering an invoice line is > slow I mean that when I hit tab to get past the last entry and start a new > one I sometimes see the spinning lollipop. > > Trying check and repair to see if it makes a difference > > Sent from my iPhone > >> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone >> wrote: >> >> And on that note, it is always recommended when stepping between major >> versions to run Actions > Check & Repair > Check & Repair All. (which should >> accomplish such data translations all in one go) >> >> I forgot to add that I'm using the SQLite backend. Not sure if that makes a >> difference. >> >> Regards, >> Adrien >> >>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote: >>> My memory is a bit fuzzy, but version 4 made some significant changes to (I >>> think) a number of key-value structures in the database. The first time you >>> open version 4, it has to convert all the old values (if you have done lots >>> of transaction importing, that’s a big contributor). If you quit gnucash >>> before it’s done with the conversion, it has to start over the next time. >>> I think it took something like 45 minutes before my Mac was done updating >>> everything internally in the database. >>> After that it has been fine. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to record in-kind transfers?
> On Feb 5, 2021, at 6:42 PM, David Newman wrote: > > Greetings. How to record in-kind transfers of stock shares between > brokerages? > > I've read the "Concept of Lots" document on the wiki multiple times, > especially the "lot transfer" section, but don't understand how this > applies to in-kind transfers of stocks. Probably because it doesn't. You can transfer the shares in a regular two-split transaction but depending on the circumstances it might make more sense to just re-parent the account to the new broker. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA aqbanking stopped working
A user on gnucash-devel has worked out what USAA changed and even better how to get connections working, see https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html. If that's gibberish you'll need to be patient for a while until Martin can get it integrated into a new release of AQBanking. Regards, John Ralls > On Feb 7, 2021, at 8:34 PM, Daffy Duck wrote: > > Hello, > > I have been using multiple USAA accounts for years, and it seems they > stopped working just recently through gnucash. > > gnucash-4.4-1.fc33.x86_64 > aqbanking-6.1.4-2.fc33.x86_64 > > Now, no matter what I do, I get no results for transactions. > > > First, it seems to force all of my USAA accounts to use the wrong user. > So I updated that user, since I don't use it, to the USAA user. Same > problem. > > When I go to aqbanking wizard, and do retrieve account list, I just > get: > > 22:26:06 Sending request... > 22:26:06 Using GnuTLS default ciphers. > 22:26:06 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 22:26:06 Waiting for response... > 22:26:07 Parsing response... > 22:26:07 Operation finished, you can now close this window. > > When I try to get transactions for any usaa account, it says: > > Locking customer "7" > Sending request... > Connecting to server... > Resolving hostname "service2.usaa.com" ... > IP address is "23.199.3.79" > Connecting to "service2.usaa.com" > Connected to "service2.usaa.com" > Using GnuTLS default ciphers. > TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > Connected. > Sending message... > Message sent. > Waiting for response... > Receiving response... > HTTP-Status: 200 (OK) > Response received. > Disconnecting from server... > Disconnected. > Parsing response... > Unlocking customer "7" > > --- > > any ideas? > > Thank you, > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Get no suitable back end found
> On Feb 8, 2021, at 12:34 PM, David Cousens wrote: > > AFAIK GnuCash on Windows 10 uses the Cygwin Linux emulator so > the cygwin version of these should work if they are not already installed. If you mean GnuCash installed by gnucash-4.4-setup.exe from our download sites, it doesn't and they won't, but they're already included along with the necessary MySQL, Postgresql, and SQLite3 libraries in c:\Program Files (x86)\gnucash\bin. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] flatpak 4.4 reports anomaly
Elmar, A fair amount of Scheme API was deprecated in 3.x and removed in 4.x. Look through the NEWS file for which ones. There should be Scheme backtraces in the trace file that will help identify the source of the crash. Regards, John Ralls > On Feb 9, 2021, at 3:01 PM, Elmar wrote: > > I just took the 2.4 file, copied it (CTRL-C/CTRL-V) and renamed it to 2.8. > Opened GC, tried to delete one report, and got a crash to desktop. So no joy > there, unless I have misunderstood what you suggested. > > On 2/9/21 4:38 PM, David H wrote: >> Elmar, >> >> Since you say they seem to run, why don't you try closing gnucash and then >> copying your saved-reports-2.4 to saved-reports-2.8, re-opening Gnucash and >> opening each saved report in turn and then if everything looks ok saving the >> config of each of your reports ? I've upgraded over the years and am also >> using the flatpak version 4.4 on Ubuntu and have both a saved-reports-2.4 >> and a saved-reports-2.8 in the .var/app/org.gnucash.GnuCash/data/gnucash/ >> folder and the 2.4 version is just ignored. >> >> Just backup your files first of course. >> >> Cheers David H. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Blurry Font Issue on Windows
HiDPI Display? Make sure that application scaling is enabled in System>Display>Advanced settings. If that doesn't do it there are some more settings that you can get to on the compatibility tab of the start menu shortcut properties: There's a button called Change high DPI settings. Regards, John Ralls > On Feb 13, 2021, at 2:30 PM, David Carlson > wrote: > > I seem to recall that GnuCash uses a couple of fonts that are not available > in Windows, so Windows substitutes something else. If you can find those > and make your own substitutions that may solve your problem. I am not sure > if those are hard coded in the program or how to implement them. > > On Sat, Feb 13, 2021 at 2:58 PM Taull Boi wrote: > >> Hi, >> >> I have just started using gnucash 4.4 (after upgrading from 2.6.21) on >> Windows 10. While most text has sharp fonts, I see a few locations (header >> row of the gnucash register, calendar in the scheduled transactions window) >> that have blurry fonts, as shown in the attached images. I have not made >> any changes via CSS to the default fonts that gnucash is using (I think it >> is using the "Segoe UI" font). >> >> I am wondering why most fonts in gnucash look sharp but a few are blurry. >> Is this a known problem/is there a way to fix this problem? >> >> My default laptop display resolution is 2560x1440. I am using 200% scaling >> on Windows. When I use 100% scaling, the blurry font issue goes away, but >> then all fonts on my laptop are really small and unreadable, and so this is >> not a viable solution. >> >> Thanks for your help. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
Well, there's a UUID in that URL, but I just tried using it for the ClientUUID
and got "The user cannot signon because he or she entered an invalid user ID or
password." Using the one scraped from Quicken for MacOS and reported in
https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html
works.
That leads me to believe that USAA is using the ClientUUID as an API key.
Quicken may have registered one or many. I think the only way to find that out
is for more users to set up MITMs with different versions of Quicken and
retrieve the ClientUUIDs for comparison.
This makes me a bit leery of publishing it on the wiki, because if Quicken or
USAA catch on that it's been compromised they might change it and lock us out
again.
Regards,
John Ralls
> On Feb 13, 2021, at 9:06 PM, Randy Johnson wrote:
>
> The CLIENTUID is also part of the URL that you get sent to after completing
> https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid ,
> not sure which is preferred), hopefully avoiding the need to install
> Quicken.
>
> -Randy
>
> On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel <
> gnucash-de...@gnucash.org> wrote:
>
>> I got new USAA OFX download working with GNC 4.4.1.
>>
>> It's mainly a configuration task.
>>
>> -- User config --
>> int uniqueId=""
>> char backendName="aqofxconnect"
>> char userName=""
>> char userId=""
>> char customerId=""
>> char country="us"
>> char bankCode="314074269"
>> int lastSessionId="0"
>>
>> data {
>> backend {
>>char bankName="USAA Federal Savings Bank"
>>char org="USAA Federal Savings Bank"
>>char fid="67811"
>>char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com
>> %2Fcasm%2Fusaa%2Faccess.ofx"
>>char appId="QMOFX"
>>char appVer="2300"
>>char headerVer="103"
>>char clientUid=""
>>int httpVMajor="0"
>>int httpVMinor="0"
>>char httpUserAgent="InetClntApp%2F3.0"
>> } #backend
>> } #data
>> -
>>
>> Notes:
>> -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, but
>> it works when included in the file. It has been added in newer AqBanking,
>> look for support in next GNC release.
>> -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. Signup
>> for trial and cancel within 30 days no charge.
>> -- 'your new USAA access id' can be found at
>> https://www.usaa.com/accessid
>>
>> You will need to disconnect accounts from within the AqBanking Wizard,
>> download accounts with new user configuration, then reconnect accounts. In
>> my case, the new credit card account numbers in the accounts list are not a
>> 100% match to the number found on your credit card. There were enough
>> common digits to know which was which, just be aware. I was able to
>> successfully download and update 2 checking accounts, a savings account,
>> and a credit card account.
>>
>> I hope this helps.
>>
>> Regards,
>>
>> Bob
>>
>> PS. I did clone the AqBanking repo and build and install the latest
>> libraries on the same machine I am running GNC. I am not sure if the
>> GNC used the libraries distributed with it or the ones I built so YMMV.
>> ___
>> gnucash-devel mailing list
>> gnucash-de...@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA
Richard, For your first lesson, GnuCash developers don't accept personal emails. All communications goes through the lists. Second lesson: Everything you're asking is already explained in the 3 or 4 threads about USAA, one on gnucash-user and the other on gnucash-devel. I'll summarize them on https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings soon. Regards, John Ralls > On Feb 14, 2021, at 3:44 PM, Richard wrote: > > John, > > I read your message on the GNUCash digest email. I am brand new to gnu so I > have a lot to learn. > > Having said that, when I am trying to establish a connection to download my > transactions, I do not know which selections to make when creating a new user. > > Can you clue me in on the steps. > > I am also a Quicken user and I am trying to migrate away from it. I have > spent days trying to get Quicken and USAA to fix account download issues. > > Both tech supports are weak at best. > > Turns out USAA without telling customers ahead of time just change the user > ID and issued their own password. Don't know if that is going to be an issue > with the GNUcash app or not. Guess I will be finding out > > > > Thanks for any help you may offer, > > Richard > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
I tried it both ways, capitalized and not.
Regards,
John Ralls
> On Feb 14, 2021, at 11:31 AM, Randy Johnson wrote:
>
> I ended up with two during my experimentation - I ended up requesting access
> twice, I got the same access is and password both times but different client
> uuids. Both client uuids I got as well as the published one worked for me.
> Quick check, did you capitalize the letters in the uuid? Someone mentioned it
> earlier and I just confirmed with my own, lower case uuids will return an
> error.
> -Randy
>
> On Sun, Feb 14, 2021, 2:12 PM John Ralls wrote:
> Well, there's a UUID in that URL, but I just tried using it for the
> ClientUUID and got "The user cannot signon because he or she entered an
> invalid user ID or password." Using the one scraped from Quicken for MacOS
> and reported in
> https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html
> works.
>
> That leads me to believe that USAA is using the ClientUUID as an API key.
> Quicken may have registered one or many. I think the only way to find that
> out is for more users to set up MITMs with different versions of Quicken and
> retrieve the ClientUUIDs for comparison.
>
> This makes me a bit leery of publishing it on the wiki, because if Quicken or
> USAA catch on that it's been compromised they might change it and lock us out
> again.
>
> Regards,
> John Ralls
>
>
> > On Feb 13, 2021, at 9:06 PM, Randy Johnson wrote:
> >
> > The CLIENTUID is also part of the URL that you get sent to after completing
> > https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid ,
> > not sure which is preferred), hopefully avoiding the need to install
> > Quicken.
> >
> > -Randy
> >
> > On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel <
> > gnucash-de...@gnucash.org> wrote:
> >
> >> I got new USAA OFX download working with GNC 4.4.1.
> >>
> >> It's mainly a configuration task.
> >>
> >> -- User config --
> >> int uniqueId=""
> >> char backendName="aqofxconnect"
> >> char userName=""
> >> char userId=""
> >> char customerId=""
> >> char country="us"
> >> char bankCode="314074269"
> >> int lastSessionId="0"
> >>
> >> data {
> >> backend {
> >>char bankName="USAA Federal Savings Bank"
> >>char org="USAA Federal Savings Bank"
> >>char fid="67811"
> >>char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com
> >> %2Fcasm%2Fusaa%2Faccess.ofx"
> >>char appId="QMOFX"
> >>char appVer="2300"
> >>char headerVer="103"
> >>char clientUid=""
> >>int httpVMajor="0"
> >>int httpVMinor="0"
> >>char httpUserAgent="InetClntApp%2F3.0"
> >> } #backend
> >> } #data
> >> -
> >>
> >> Notes:
> >> -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, but
> >> it works when included in the file. It has been added in newer AqBanking,
> >> look for support in next GNC release.
> >> -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. Signup
> >> for trial and cancel within 30 days no charge.
> >> -- 'your new USAA access id' can be found at
> >> https://www.usaa.com/accessid
> >>
> >> You will need to disconnect accounts from within the AqBanking Wizard,
> >> download accounts with new user configuration, then reconnect accounts. In
> >> my case, the new credit card account numbers in the accounts list are not a
> >> 100% match to the number found on your credit card. There were enough
> >> common digits to know which was which, just be aware. I was able to
> >> successfully download and update 2 checking accounts, a savings account,
> >> and a credit card account.
> >>
> >> I hope this helps.
> >>
> >> Regards,
> >>
> >> Bob
> >>
> >> PS. I did clone the AqBanking repo and build and install the latest
> >> libraries on the same machine I am running GNC. I am not sure if the
> >> GNC used the libraries distributed with it or the ones I built so YMMV.
> >> ___
> >> gnucash-devel mailing list
> >> gnucash-de...@gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> >>
> > ___
> > gnucash-devel mailing list
> > gnucash-de...@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
I tried again with a second visit to accessid so I'd get a fresh UUID. It
worked to get the accounts but failed when I tried to retrieve transactions.
I've summarized the setup process in
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, though for
my experience the Client UID instructions, which reflect getting them from the
URL, are not correct.
Regards,
John Ralls
> On Feb 14, 2021, at 3:59 PM, John Ralls wrote:
>
> I tried it both ways, capitalized and not.
>
> Regards,
> John Ralls
>
>
>> On Feb 14, 2021, at 11:31 AM, Randy Johnson wrote:
>>
>> I ended up with two during my experimentation - I ended up requesting access
>> twice, I got the same access is and password both times but different client
>> uuids. Both client uuids I got as well as the published one worked for me.
>> Quick check, did you capitalize the letters in the uuid? Someone mentioned
>> it earlier and I just confirmed with my own, lower case uuids will return an
>> error.
>> -Randy
>>
>> On Sun, Feb 14, 2021, 2:12 PM John Ralls wrote:
>> Well, there's a UUID in that URL, but I just tried using it for the
>> ClientUUID and got "The user cannot signon because he or she entered an
>> invalid user ID or password." Using the one scraped from Quicken for MacOS
>> and reported in
>> https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html
>> works.
>>
>> That leads me to believe that USAA is using the ClientUUID as an API key.
>> Quicken may have registered one or many. I think the only way to find that
>> out is for more users to set up MITMs with different versions of Quicken and
>> retrieve the ClientUUIDs for comparison.
>>
>> This makes me a bit leery of publishing it on the wiki, because if Quicken
>> or USAA catch on that it's been compromised they might change it and lock us
>> out again.
>>
>> Regards,
>> John Ralls
>>
>>
>>> On Feb 13, 2021, at 9:06 PM, Randy Johnson wrote:
>>>
>>> The CLIENTUID is also part of the URL that you get sent to after completing
>>> https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid ,
>>> not sure which is preferred), hopefully avoiding the need to install
>>> Quicken.
>>>
>>> -Randy
>>>
>>> On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel <
>>> gnucash-de...@gnucash.org> wrote:
>>>
>>>> I got new USAA OFX download working with GNC 4.4.1.
>>>>
>>>> It's mainly a configuration task.
>>>>
>>>> -- User config --
>>>> int uniqueId=""
>>>> char backendName="aqofxconnect"
>>>> char userName=""
>>>> char userId=""
>>>> char customerId=""
>>>> char country="us"
>>>> char bankCode="314074269"
>>>> int lastSessionId="0"
>>>>
>>>> data {
>>>> backend {
>>>> char bankName="USAA Federal Savings Bank"
>>>> char org="USAA Federal Savings Bank"
>>>> char fid="67811"
>>>> char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com
>>>> %2Fcasm%2Fusaa%2Faccess.ofx"
>>>> char appId="QMOFX"
>>>> char appVer="2300"
>>>> char headerVer="103"
>>>> char clientUid=""
>>>> int httpVMajor="0"
>>>> int httpVMinor="0"
>>>> char httpUserAgent="InetClntApp%2F3.0"
>>>> } #backend
>>>> } #data
>>>> -
>>>>
>>>> Notes:
>>>> -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, but
>>>> it works when included in the file. It has been added in newer AqBanking,
>>>> look for support in next GNC release.
>>>> -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. Signup
>>>> for trial and cancel within 30 days no charge.
>>>> -- 'your new USAA access id' can be found at
>>>> https://www.usaa.com/accessid
>>>>
>>>> You will need to disconnect accounts from within the AqBanking Wizard,
>>>> download accounts with new user configuration, then reconnect accounts. In
>>>> my case, the new credit card account numbers in the accounts list are not a
>>>>
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
What flavor of Quicken did you use? Regards, John Ralls > On Feb 14, 2021, at 6:19 PM, Keith Bellairs wrote: > > My USAA checking and credit card seem to be working. My users/0.conf is > using this client UID: I got it from quicken's OFXlog.txt file. > > char clientUid="39E0E763-4E1E-4918-9528-D6EBAC94EF5D" > > Notably when the online action in GNC challenges for the account password the > required response is now the "Access PIN". No longer the web site account > password. Yet another password to track. > > I cannot believe its working again. Thanks everyone. > > Keith > > _____ > > Date: Sun, 14 Feb 2021 11:12:26 -0800 > From: John Ralls > To: Randy Johnson > Cc: gnucash-de...@gnucash.org, gnucash-user@gnucash.org > Subject: Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support > Message-ID: > Content-Type: text/plain; charset=us-ascii > > Well, there's a UUID in that URL, but I just tried using it for the > ClientUUID and got "The user cannot signon because he or she entered an > invalid user ID or password." Using the one scraped from Quicken for MacOS > and reported in > https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html > works. > > That leads me to believe that USAA is using the ClientUUID as an API key. > Quicken may have registered one or many. I think the only way to find that > out is for more users to set up MITMs with different versions of Quicken and > retrieve the ClientUUIDs for comparison. > > This makes me a bit leery of publishing it on the wiki, because if Quicken or > USAA catch on that it's been compromised they might change it and lock us out > again. > > Regards, > John Ralls > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tab Rendering Flaw
> On Feb 15, 2021, at 8:51 AM, Tommy Trussell wrote: > > I noticed this morning John Ralls pushed an update to the Flatpak so I > installed the update. I am now running the latest flatpak version (Version: > 4.4 Build ID: Flathub 4.4-4). It's still behaving similarly It's still the 4.4 release, the change is that it has some dependency updates, the motivating one being the latest AQBanking for USAA members. You know that we have flatpak nightlies at https://code.gnucash.org/builds/flatpak/maint, right? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA online setup
That might be a older AQBanking6 issue. Try creating a dummy account on the AQBanking Setup Dialog's Accounts tab then go back to Users and retrieve your USAA accounts again. Regards, John Ralls > On Feb 15, 2021, at 12:28 PM, Richard via gnucash-user > wrote: > > I followed the instructions at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings > > It did not work for me. I don't know if I missed some little input or what. I > did not understand a lot of the labels for input. > > I did not receive an error message. It appear to go through the process of > downloading the account list. It said finished. If it downloaded anything, I > don't know where it is. > > Anyone have an additional suggestion? > > Richard > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote not Working on Macbook
> On Feb 15, 2021, at 5:47 PM, bdp3 wrote: > > Is anyone else having trouble making F:Q work on a Mac? If not, maybe you > can help me—I’m new here and I just don’t ‘get it’! > > I’m using GnuCash_4.4 on Mac OS 10.14 (Mojave). > > I downloaded version 1.49 from SourceForge. There’s an ‘Applications’ folder > at the hard-drive level, and an ‘Applications’ folder at the User folder > level; I’ve tried unzipping FQ into both directories and still have no > success. I read the GnuCash wiki on Online Quotes; I have perl installed; I > used CPAN; I’m getting lost in the weeds. The ‘Security Edit’ page (for any > given security which I have set up) shows the Online Checkbox greyed-out with > the same message familiar to us: “Warning: Finance::Quote not installed > properly”. I also tried running “gnc-fq-check“ and “gnc-fq-update” – No > Joy! > > What am I missing? > > > > Thanks much for anything you can tell me!! (Pictures help – preferably in > crayons or watercolors.) The only thing you tried that's right is gnc-fq-update. It needs sudo as shown in https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
Sorry, it's AQBanking 6.2.6. I've fixed the wiki page and added links for macOS and flathub users to the exact version of GnuCash they need. There's no 4.4.1: We changed to a two-digit versioning system 4 years ago. However the all-in-one bundles on macOS and Windows can have suffixes as do flathub packages. I didn't do a rebundle of the 4.4 release on Windows as we have nightly builds for that and users are accustomed to using them. The flathub version you need is 4.4-4 and the macOS one is 4.4-2. For the latter use the new link on the wiki page; I don't intend to change the link on the website nor to add the 4.4-2 dmg to the Github release because this affects only a few users. Regards, John Ralls > On Feb 16, 2021, at 6:07 AM, John Haiducek wrote: > > The instructions on the wiki say that GnuCash 4.4 and aqbanking 6.1.6 are > required to connect, but some of the comments on this thread refer to GnuCash > 4.4.1. I tried with GnuCash 4.4 and aqbanking 6.2.5 and found that the > aqbanking UI is slightly different than described in the wiki and there is no > field to set the HTTP User Agent. Is GnuCash 4.4.1 and/or aqbanking 6.2.6 > required to make this work? > > John > > On Sun, Feb 14, 2021 at 7:54 PM John Ralls wrote: > I tried again with a second visit to accessid so I'd get a fresh UUID. It > worked to get the accounts but failed when I tried to retrieve transactions. > > I've summarized the setup process in > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, though > for my experience the Client UID instructions, which reflect getting them > from the URL, are not correct. > > Regards, > John Ralls > > > > On Feb 14, 2021, at 3:59 PM, John Ralls wrote: > > > > I tried it both ways, capitalized and not. > > > > Regards, > > John Ralls > > > > > >> On Feb 14, 2021, at 11:31 AM, Randy Johnson wrote: > >> > >> I ended up with two during my experimentation - I ended up requesting > >> access twice, I got the same access is and password both times but > >> different client uuids. Both client uuids I got as well as the published > >> one worked for me. > >> Quick check, did you capitalize the letters in the uuid? Someone mentioned > >> it earlier and I just confirmed with my own, lower case uuids will return > >> an error. > >> -Randy > >> > >> On Sun, Feb 14, 2021, 2:12 PM John Ralls wrote: > >> Well, there's a UUID in that URL, but I just tried using it for the > >> ClientUUID and got "The user cannot signon because he or she entered an > >> invalid user ID or password." Using the one scraped from Quicken for MacOS > >> and reported in > >> https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html > >> works. > >> > >> That leads me to believe that USAA is using the ClientUUID as an API key. > >> Quicken may have registered one or many. I think the only way to find that > >> out is for more users to set up MITMs with different versions of Quicken > >> and retrieve the ClientUUIDs for comparison. > >> > >> This makes me a bit leery of publishing it on the wiki, because if Quicken > >> or USAA catch on that it's been compromised they might change it and lock > >> us out again. > >> > >> Regards, > >> John Ralls > >> > >> > >>> On Feb 13, 2021, at 9:06 PM, Randy Johnson wrote: > >>> > >>> The CLIENTUID is also part of the URL that you get sent to after > >>> completing > >>> https://df3cx-services.1fsapi.com/casm/usaa/enroll (or usaa.com/accessid , > >>> not sure which is preferred), hopefully avoiding the need to install > >>> Quicken. > >>> > >>> -Randy > >>> > >>> On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel < > >>> gnucash-de...@gnucash.org> wrote: > >>> > >>>> I got new USAA OFX download working with GNC 4.4.1. > >>>> > >>>> It's mainly a configuration task. > >>>> > >>>> -- User config -- > >>>> int uniqueId="" > >>>> char backendName="aqofxconnect" > >>>> char userName="" > >>>> char userId="" > >>>> char customerId="" > >>>> char country="us" > >>>> char bankCode="314074269" > >>>> int lastSessionId
Re: [GNC] Crash when updating scheduled template amount, repeatedly.
The screenshot shows a git master build from September 2019, presumably this flatpak nightly: https://code.gnucash.org/builds/flatpak/master/gnucash-master-C3.7-222-gae3bb9892-D3.7-39-g4b85e45.flatpakref You should *never* use anything from master for production, and there's no point at all in testing or reporting bugs in an 18-month-old snapshot. https://wiki.gnucash.org/wiki/Ubuntu has information on obtaining GnuCash 4.4 from the Debian repository. Of course since GnuCash 3.8 seems to work for you you might as well keep using it unless there's something about GnuCash 4 that you find appealing, for example if you're a USAA member who wants to download transactions. Regards, John Ralls > On Feb 17, 2021, at 6:16 AM, David G. Pickett via gnucash-user > wrote: > > I hope it is fixed, does not happen in 3.8, no 4.4 for ubuntu 20.04 lts yet. > > > -Original Message- > From: David Carlson > To: David G. Pickett > Cc: gnucash-user@gnucash.org > Sent: Wed, Feb 17, 2021 8:41 am > Subject: Re: [GNC] Crash when updating scheduled template amount, repeatedly. > > What about it? > > On Wed, Feb 17, 2021 at 3:15 AM David G. Pickett via gnucash-user > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] OFX connections
I'm pretty sure David was being facetious. There's approximately zero chance that any bank is going to undertake developing a new transfer protocol. The trend is that Quicken's propietary Web Connect authentication is what's supported. We've kept USAA going only because USAA decided to stick with DirectConnect and Quicken made it easy to reverse-engineer the new authentication arrangement. Now if somebody can reverse engineer Web Connect I'm sure Martin would be willing to implement it if it's feasible. He has the advantage of being largely beyond the reach of the DMCA. Ideally Congress would mandate something like Germany's FinTS for the US. That campaign would need some very wealthy donors to bankroll it, the lobbying against such a mandate from the banking industry and from Intuit will be intense and they have a lot of money and lobbyists. Regards, John Ralls > On Feb 18, 2021, at 3:09 PM, David Carlson > wrote: > > -- Forwarded message - > From: Richard > Date: Thu, Feb 18, 2021 at 3:22 PM > Subject: Re: [GNC] OFX connections > To: David Carlson > > > How do I go about that? > > I use several banks for credit cards, etc. > > I am not afraid to ask them. > On 2/18/2021 4:03 PM, David Carlson wrote: > > Maybe your bank would sponsor you to develop one. > > On Thu, Feb 18, 2021, 2:54 PM Richard via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> I saw a long list of banks that do not support OFX connections. >> >> That being said, is there a newer bank access protocol under development >> for gnucash. >> >> Richard >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] OFX connections
Tom, The security implications of enabling the webkit instance in GnuCash to connect to the network are dire, especially on Microsoft Windows where WebKit is stuck on a 10 year old release with hundreds of CVEs. I suppose someone might write a browser plugin to initiate the CSV downloads from bank websites once the user has authenticated but I suspect it would be difficult and wouldn't contribute much. It's generally only a couple of clicks on any particular website. GnuCash already has a CSV import facility: Use File>Import>Import Transactions from CSV. There you can associate columns in the CSV with GnuCash fields and adjust CSV parameters. Once you have it set up you can save the configuration for reuse. The configs are saved in the book state file and aren't amenable to sharing. Regards, John Ralls > On Feb 19, 2021, at 8:36 AM, Tom Browder wrote: > > On Thu, Feb 18, 2021 at 23:27 John Ralls wrote: > I'm pretty sure David was being facetious. There's approximately zero chance > that any bank is going to undertake developing a new transfer protocol. > > How many banks and financial houses still allow CVS download? All of ours do: > TD Ameritrade (recently bought by Schwab), Fidelity, Fidelity Credit Card, > Synovus Bank, Synovus Card Services, USAA (recently integrated software-wise > with Schwab), and American Express Credit Card. > > How much effort to add a hook to GNU Cash to initiate the download? > > How much effort to add a CVS to GNU Cash converter? > > All of those CSV converters would probably require help from users having > accounts, and maybe a first step would be a Perl (or Raku) CSV => OFX (or > some other useful format) converter which I could help with. > > I already have some converters from CSV to other formats for Fidelity and TD > Ameritrade products (in Raku), but I haven't looked at OFX in a long time (I > do not enjoy working with XML in the least, but converting to XML is not so > bad). > > I would also be willing to donate to the effort if it were deemed feasible > and of interest. > > -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Blurred titles and Language issues
macOS isn't Windows. On Windows the problem is generally with display scaling of HiDPI displays because Windows allows fractional scaling while cairo supports only integral scaling (which is x2 on macOS). > On Feb 23, 2021, at 6:33 AM, Taull Boi wrote: > > I believe I have the same issue regarding the column headers and had > reported it here: > > https://lists.gnucash.org/pipermail/gnucash-user/2021-February/095301.html > > It appears the problem has something to do with gtk, cairo, pango and font > rendering. I have this problem on Windows. > > On Mon, Feb 22, 2021 at 8:56 PM Gabriele Venturato < > venturato.gabri...@outlook.com> wrote: > >> Hello everyone, >> >> I hope this is the right place where to discuss this, otherwise please >> point me to the right resource. >> >> I’ve just installed GnuCash in MacOs, but I see a couple of problems. You >> can see them on the screenshot attached. >> >> 1. The titles of all the account tables are blurred. Is there a reason for >> that? In linux (Fedora) I can see them neat. Moreover, all the other text >> in the interface looks fine. >> >> 2. At the bottom you can see the date is not in English. I’m currently in >> Belgium (I suspect this is the problem), but I set everything in the system >> to be in English. The only thing related to Belgium is the region, but I >> don’t want to change it because it is where I actually am and therefore I >> think it’s correct that it remains like that. >> >> I tried to search both on the preferences/settings and online, but I >> couldn’t find answers to these problems. >> >> Best regards, >> Gabriele >> >> [cid:1106E031-4E7C-4541-8A97-67EB681F23F5] >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Blurred titles and Language issues
Adrien, Open the screenshot in Preview and zoom in: You'll see that the column headings are a lower res font than the tab labels. I was able to get the same effect with a screenshot on my MBP Retina. Interestingly it's only the headings: The data rows are as sharp as the tab labels. Regards, John Ralls > On Feb 22, 2021, at 7:04 PM, Adrien Monteleone > wrote: > > Unless I'm looking at a different screenshot, or my eyesight is terrible > (certainly possible) I read all of the column headings the same, and just > fine. They are slightly more bold than other parts of the UI, but no less > 'sharp'. > > Note, I'm using a standard DPI monitor with a large screen. (1920x1080 @ > 27in) That looks fairly crummy by most modern standards, but normal if you > grew up with worse and never had better. > > If Gabriele is using an IPS/Hi-DPI display, I could understand there might be > an issue. I think there are some bugs on this already, but they might also be > GTK related, rather than GnuCash. > > Regards, > Adrien > > On 2/22/21 8:53 PM, Peter West wrote: >> I think it’s the column headings Gabriele’s referring to. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Blurred titles and Language issues
> On Feb 24, 2021, at 9:51 AM, Adrien Monteleone > wrote: > > On 2/23/21 9:05 AM, Gabriele Venturato wrote: >> Hi, >> For some reason I didn’t receive the emails with the answers form Adrien and >> Peter. Can you please check if you put me in cc? I’ve discovered them just >> because Taull answered and I casually checked the whole thread from the >> browser. > > I only reply to the list, I generally do not CC individual users. To see my > replies, you need to be subscribed to the list, and be set to receive mail > from the list. (either individually or in digest form) > >> About the language problem instead, I played a lot with system settings, but >> nothing helps. I can’t see anything else in dutch except from that date in >> the bottom of the interface, so it’s really hard to understand where it’s >> getting that information. >> Moreover, I’ve also noticed that the settings about the numbers format are >> not synced with the system settings. Usually in euros we use the comma to >> separate decimals, and the dot to group each 10^3 digits. However, in my >> settings I put the dot for decimals, and the comma for grouping, and indeed >> in the calculator I use the dot as a decimal separator, but in GnuCash that >> is not reflected, nor I have any option to change this behaviour. Any idea? > > I'm presuming if you've gone that far, you've already discovered the Advanced > button in System Preferences > Language and Region. > > The only other thing I could recommend is to make sure English is listed as > your primary language there, and in GnuCash > Preferences > Numbers, Date, > Time > Date Format is listed as 'Locale' > > If that is still showing non-English terms, something might be amiss with > your GnuCash config files. (It has its a plist file that might be stuck on a > non-English locale somehow.) GnuCash's localization is limited to the way it works on Linux, which is the old POSIX locales method. Customizing in System Preferences doesn't work; GnuCash looks for a locale to use. The best you can do is edit Gnucash.app/Contents/Resources/etc/gnucash/environment and add LC_NUMERIC=en_US and LC_TIME=en_US to set those particular localizations to locales that present numbers and dates the way you like. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] currency symbol problem in reports
Not in settings, in the security editor. Open the Currencies namespace, find and select the currency, and select Edit. There's a spot for Display Symbol. Deleting it will get the default but a space will replace it. That might make amounts look odd in some places but should be OK on most. Regards, John Ralls > On Feb 27, 2021, at 1:37 PM, D. via gnucash-user > wrote: > > ISTR that there is a place in the settings to choose the character to display > with each currency. Never tried it though. > > > Original Message > From: Gio Bacareza > Sent: Sat Feb 27 09:18:47 EST 2021 > To: Jim DeLaHunt > Cc: GnuCash Users > Subject: Re: [GNC] currency symbol problem in reports > > I use Arial which should have it. But for some reason Gnucash does not > render it. > > If you copy paste the report to another program like a text editor or > excel, the peso sign shows up. > > But to be honest I really just want to eliminate currency symbols. I mostly > work in pesos so there is no added information it gives me. > > Is there a way to configure such that no currency symbol is displayed or > printed? > > thanks > > On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt wrote: > >> On 2021-02-26 17:21, Gio Bacareza wrote: >> >>> This seems to be a nagging problem with currencies in reports. I thought >> I >>> had solved this in previous versions of mac that I'm using but it's back >>> again with Big Sur and the remedies that worked before no longer works >> now. >>> >>> My currency is Philippine Peso. Reports show a square looking symbol >> which >>> could probably mean it could not find the right font. >> >> According to Wikipedia, the Philippine Peso symbol is "₱". It looks like >> a capital "P" with two horizontal lines through the upper bowl. The >> Unicode code point is U+20B1. >> >> What font are you using to format the report? I suspect that not all >> fonts contain this character. On my Mac, the main system fonts like >> Arial and Courier have it, the pan-Unicode fonts like Noto Sans have it, >> but more specialised text fonts like Calibri do not. >> >> [1] https://en.wikipedia.org/wiki/Philippine_peso_sign >> >> Hope this helps, >> >> —Jim DeLaHunt >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > cheers, > > Gio > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] entry point error after recent automatic windows 10 update
> On Feb 25, 2021, at 2:46 PM, pholck wrote: > > DIrectly following latest automatic update of Windows 10, I have the exact > same error pop up (I am using gnucash 4.4). Fortunately in my case, after I > click "OK" to the "Entry Point Not Found" error, and then reclick about 10 > times, GnuCash starts up for me (apparently despite the missing > libgncmod-app-utils.dll). I have not give a full test that it is running > properly, but so far no issues. > > If anyone has any fixes for this issue (as I am concerned that at some point > multiple clicking of the OK button will cease to work for me) do let me > know! > > At any rate, given Laurel's issues, I think it's pretty certain this error > is a result of something updating Windows 10 causes... libgncmod-app-utils.dll was renamed to libgnc-app-utils.dll in GnuCash 4.x so if something is trying to link it it's a leftover from GnuCash 3.x or earlier. It seems unlikely that Windows updates would have anything to do with it. As Geert mentioned back in November, the uninstaller doesn't always get everything. That may be because its manifest is incomplete or because the file in question is left over from a previous installation whose uninstaller has been removed. I just checked the registry and user directory on my Windows VM for mentions of libgnc-app-utils or libgncmod-app-utils and found nothing, so I think that both you and Ms. Hargis must have artifacts from previous installations on your system. Please try the following: Uninstall GnuCash using Apps and Features (right-click on the start icon, it's the first item in the menu). Open Windows File Explorer and navigate to Local Disk (C:) > Program Files (x86). Delete the gnucash directory if there is one. If you have ever installed GnuCash to some other location check that as well and make sure that the gnucash directory is deleted. If you're not sure about that use Windows File Explorers search to search all disks for libgnc*.dll. Delete any that you find. Empty the trash. Install GnuCash 4.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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong numeric separators in new file
That's for accounts, e.g. Assets:Current:Bank of America:Checking. Tony is asking about ',' and '.' to separate parts of a number. That's driven by locale settings, so have a look at https://wiki.gnucash.org/wiki/Locale_Settings. Remember that GnuCash is *not* a native Windows app and doesn't understand custom settings in Region & Language. Regards, John Ralls > On Feb 28, 2021, at 7:28 PM, Adrien Monteleone > wrote: > > Preferences > Accounts > Separator Character > > Regards, > Adrien > > On 2/28/21 9:11 PM, Tony Vanson wrote: >> Hi All, >> On Windows 10 and Gnucash 4.4 >> After a catastrophic failure of my laptop, which also took out my external >> backup drive, I found a 2 year old backup on another drive. >> The data loss is not a huge problem as it is solely for my own use. >> I closed that old file and used it to create a new file hierarchy with >> every account in the new file showing zero - all good. >> However I notice when entering amounts now that the thousands separator is >> a decimal point and the decimal point is a comma e.g. $10.000.000,00. >> I've dug around some but haven't been able to find where I can change the >> separators. >> Any advice is much appreciated >> Cheers > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash finance quote not installed properly
Note that 3.900 isn't 3.9. 3.900 was an unstable build from git master before 4.0; the git version corresponds to the flatpak nightly build of the master branch on 2019-09-29. A current git master nightly would be version 4.900. Regards, John Ralls > On Mar 3, 2021, at 7:53 PM, David H wrote: > > Perhaps cos 4 days ago you told us "It is 3.900 build id: git > 3.7-222-gae3bb9892+(2019-09-29)," - it seems flatpak list is showing the > git version for you which you are assuming is the Gnucash version ? > > Cheers David H. > > > On Thu, 4 Mar 2021 at 07:57, David G. Pickett wrote: > >> Well, gnucash is down there as 3.7, so why do I run 3.9? >> >> dgp@dgp-p6803w:~ >> $ sudo flatpak list >> [sudo] password for dgp: >> … … Version Branch >> Origin Installation >> … … 1.6 1.6 >> flathub system >> … … 19.08.1319.08 >> flathub system >> … … 19.08 >> flathub system >> … … 1.4 >> flathub system >> … … 1.4 >> flathub system >> … … 1.6 >> flathub system >> … … 18.08 >> flathub system >> … … 19.08 >> flathub system >> … … 2.1.0 2.0 >> flathub system >> … … 2.10.22 stable >> flathub system >> … … 2.102.10 >> flathub system >> … … 3.32 >> flathub system >> … … 3.34 >> flathub system >> … … 3.36 >> flathub system >> … … 3.7-222-gae3bb9892+ master-C3.7-222-gae3bb9892-D3.7-39-g4b85e45 >> gnucash system >> … … 3.22 >> flathub system >> … … 3.22 >> flathub system >> dgp@dgp-p6803w:~ >> $ >> >> >> >> -Original Message- >> From: Tommy Trussell >> To: David G. Pickett >> Cc: hell...@gmail.com ; gnucash-user@gnucash.org < >> gnucash-user@gnucash.org> >> Sent: Wed, Mar 3, 2021 11:26 am >> Subject: Re: [GNC] gnucash finance quote not installed properly >> >> Here's what I have on my system: >> >> $ flatpak list >> NameApplication ID Version Branch >> Installation >> default …sktop.Platform.GL.default 19.08 system >> Intel …ktop.Platform.VAAPI.Intel 19.08 system >> openh264…desktop.Platform.openh264 2.1.0 2.0system >> GNOME Application Plat… org.gnome.Platform 3.36 system >> GnuCash org.gnucash.GnuCash4.4 stable system >> Ambiance Gtk theme org.gtk.Gtk3theme.Ambiance 3.22 system >> Yaru Gtk Theme org.gtk.Gtk3theme.Yaru 3.22 system >> $ >> >> A few days ago I noticed some outdated runtimes, so I used >> $ flatpak remove >> and they're gone now. There may be a more efficient way to do it. >> >> Maybe the version of GnuCash you're using is "pinned" to the highest >> version of GNOME you have? >> >> You might try removing all the packages flatpak is warning about and >> reinstalling GnuCash. It will definitely bring in whatever other flatpak >> packages it needs when you do that. >> >> Again, if there's a more efficient way to do it, maybe someone with more >> flatpak experience will weigh in. >> >> On Wed, Mar 3, 2021 at 9:09 AM David G. Pickett wrote: >> >> OK, flatpak not updated by the other updater, so I ran, but no mention of >> gnucash: >> >> dgp@dgp-p6803w:~ >> $ sudo flatpak update >> [sudo] password for dgp: >> Looking for updates… >> Info: org.gnome.Platform is end-of-life, with reason: The GNOME 3.34 >> runtime is no longer supported as of 14th August 2020. Please ask your >> application developer to migrate to a supported platform. >> Info: org.gnome.Platform is end-of-life, with reason: The GNOME 3.32 >> runtime is no longer supported as of 11th March 2020. Please ask your >> application developer to migrate to a supported platform. >> Info: org.gnome.Platform.Locale is end-of-life, with reason: The GNOME >> 3.34 runtime is no longer supported as of 14th August 2020. Please ask your >> application developer to migrate to a supported platform. >> Info: org.gnome.Platform.Locale is end-of-life, with reason: The GNOME >> 3.32 runtime is no longer supported as of 11th March 2020. Please ask your >> application de
Re: [GNC] gnucash finance quote not installed properly
Ubunutu 20.04 provides GnuCash 3.8. They don't update GnuCash versions so the only way to get a newer version that way is to upgrade to a newer Ubuntu release. As Geert explained at length, you don't have a flathub flatpak so you can run flatpak update every second of every day for a year and the version you have installed won't change. There aren't two revisions in the same executable. The overall version, 3.900, means that it's an unstable build from the master branch of our sources. "git 3.7-222-gae3bb9892+" means that it was built from commit ae3bb9892 that's 222 commits past the last tag, 3.7. To make sense of that you need to know that we keep the source code in a revision control system in two main branches: maint and master. maint contains the current stable code and master contains work-in-progress code for the next major release. Each change to the code is bundled up in a commit in the revision control system. A tag is a marker on a commit; we use them exclusively to designate releases on the maint branch and while we periodically merge the maint branch's commits into the master branch and it gets release tags from those merges. Of those 222 commits noted above some will be bug-fixes made on the maint branch and the rest will be development work on the master branch. That development work has a good chance of being incomplete and an even better chance of not being well tested: You'd only want to run such a build to test some new feature not for everyday use. Please follow Geert's instructions to remove that flatpak, it was for testing and is now thoroughly obsolete. Regards, John Ralls > On Mar 4, 2021, at 5:36 AM, David G. Pickett wrote: > > So why, on Ubuntu 20.04.2 LTS (the latest LTS offered by the system > https://wiki.ubuntu.com/Releases), do both apt-get update and flatpak update > leave me back here on 3.8/3.7, while the latest is 4.4, never mind with the > task bar favorite launching hidden flatpak version 3.9? and > On Mar 4, 2021, at 5:39 AM, David G. Pickett wrote: > > PS: Yes, the 3.9 splash says git 3.7.222, so who decided to have 2 > conflicting revisions on the same executable? and On Feb 27, 2021, at 6:25 AM, David G. Pickett via gnucash-user wrote: Good question! I have been running it for so long, I am not sure! It is 3.900 build id: git 3.7-222-gae3bb9892+(2019-09-29), and software update may have installed changes. I was trying to get past a crash in update scheduled template transaction recently, may have installed some deb, and finally found an older version to run to do the update on. Maybe I can point the quotes to an older version. That was 2/23-2/24, btw. > > > -Original Message- > From: John Ralls > To: David H > Cc: David G. Pickett ; gnucash-user@gnucash.org > > Sent: Wed, Mar 3, 2021 11:42 pm > Subject: Re: [GNC] gnucash finance quote not installed properly > > Note that 3.900 isn't 3.9. > > 3.900 was an unstable build from git master before 4.0; the git version > corresponds to the flatpak nightly build of the master branch on 2019-09-29. > A current git master nightly would be version 4.900. > > Regards, > John Ralls > > > > On Mar 3, 2021, at 7:53 PM, David H wrote: > > > > Perhaps cos 4 days ago you told us "It is 3.900 build id: git > > 3.7-222-gae3bb9892+(2019-09-29)," - it seems flatpak list is showing the > > git version for you which you are assuming is the Gnucash version ? > > > > Cheers David H. > > > > > > On Thu, 4 Mar 2021 at 07:57, David G. Pickett wrote: > > > >> Well, gnucash is down there as 3.7, so why do I run 3.9? > >> > >> dgp@dgp-p6803w:~ > >> $ sudo flatpak list > >> [sudo] password for dgp: > >> … … VersionBranch > >> Origin Installation > >> … … 1.61.6 > >> flathub system > >> … … 19.08.1319.08 > >> flathub system > >> … …19.08 > >> flathub system > >> … …1.4 > >> flathub system > >> … …1.4 > >> flathub system > >> … …1.6 > >> flathub system > >> … …18.08 > >> flathub system > >> … …19.08 > >> flathub system > >> … … 2.1.0 2.0 > >> flathub system > >> … … 2.10.22stable > >> flathub system > >> … … 2.102.10 > >> flathub system > >> … …3.32 > >> flathub system > >> … …3.34 > >> flathub system > >
Re: [GNC] Access GNUCash From Different Devices
Unfortunately no. The GUI framework GnuCash is built on doesn't support iOS. Regards, John Ralls > On Mar 4, 2021, at 2:27 PM, John Donnee wrote: > > Hi, I’ve been using GNYCash for nine years. > > Question: I run my GNU system from a iMac. Is there a way to also access > my GNU system from my iPad? > > Thanks > > John Donnee > -- > John J Donnee > > 317 Mount Eden Place > Cary, NC 27518 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Access GNUCash From Different Devices
This just in: A developer just now requested a wiki editing account because he's created a simple GnuCash data-entry app for iOS and iPadOS. See https://apps.apple.com/us/app/gnucash-mobile/id1556325950 Regards, John Ralls > On Mar 5, 2021, at 4:58 AM, John Donnee wrote: > > Thanks > > John > > On Thu, Mar 4, 2021 at 9:28 PM John Ralls wrote: > Unfortunately no. The GUI framework GnuCash is built on doesn't support iOS. > > Regards, > John Ralls > > > > On Mar 4, 2021, at 2:27 PM, John Donnee wrote: > > > > Hi, I’ve been using GNYCash for nine years. > > > > Question: I run my GNU system from a iMac. Is there a way to also access > > my GNU system from my iPad? > > > > Thanks > > > > John Donnee > > -- > > John J Donnee > > > > 317 Mount Eden Place > > Cary, NC 27518 > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -- > John J Donnee > > 317 Mount Eden Place > Cary, NC 27518 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch wrote: > > [ move this thread from gnucash-devel to gnucash-user, the original gnucash- > devel thread is here > https://lists.gnucash.org/pipermail/gnucash-devel/2021-March/045777.html ] > > Am Sonntag, 7. März 2021, 17:51:19 CET schrieb John Ralls: >> You're on the wrong list, please use gnucash-user for this sort of question. >> >> GnuCash can't use the quotes because Fondsweb.pm doesn't make a field >> "symbol" in its return array. You should raise an issue at >> https://github.com/financequote/financequote. > > If I understand you right, the field "symbol" is that same symbol which > gnucash > supplied. I added this locally here. > > rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump fondsweb > LU0119891520 LU2027374805 > Finance::Quote fields Gnucash uses: >symbol: LU0119891520 <=== required > date: 03/05/2021 <=== recommended > currency: EUR <=== required > last: 708.99 <=\ > nav: 708.99 <=== one of these > price: <=/ > timezone: <=== optional > = > > Finance::Quote fields Gnucash uses: >symbol: LU2027374805 <=== required > date: 03/05/2021 <=== recommended > currency: USD <=== required > last: 68.39<=\ > nav: 68.39<=== one of these > price: <=/ > timezone: <=== optional > rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ > > I also opened a bug report and cross-referenced it: > > https://github.com/finance-quote/finance-quote/issues/179 > >> As for your complaint about duplicate prices, your pasted-in results don't >> show that. > > Many thanks for your quick reply, John. I move the discusion to gnucash-user. > > There are two things which I think are strange from the gnucash side: > > 1. gnc-fq-dump reports that stock quote cannot be used, but gnucash uses it > 2. duplicate prices: I do not see them with gnc-fq-dump but gnucash shows them > > Ist gnucash using gnc-fq-dump in the same way I did? No. gnc-fq-dump is a user-convenience tool. GnuCash uses gnc-fq-helper, which formats its results so that they can be fed directly to Scheme. Instructions for using it by hand are in its POD. apparently there are others that don't pass a "symbol" element so if it doesn't find the "symbol" entry in the F::Q results hash it uses the user-supplied symbol instead. There's probably something about the Fondweb.pm results hash that messes up retrieving the right entry. You can use .cpan/build/Finance-Quote-1.49-0/Examples/stockdump.pl (.cpan is probably in your $HOME) to see exactly what F::Q is sending. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
>
> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
>>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch wrote:
>>>
>>> [ move this thread from gnucash-devel to gnucash-user, the original
>>> gnucash- devel thread is here
>>> https://lists.gnucash.org/pipermail/gnucash-devel/2021-March/045777.html
>>> ]>
>>> Am Sonntag, 7. März 2021, 17:51:19 CET schrieb John Ralls:
>>>> You're on the wrong list, please use gnucash-user for this sort of
>>>> question.
>>>>
>>>> GnuCash can't use the quotes because Fondsweb.pm doesn't make a field
>>>> "symbol" in its return array. You should raise an issue at
>>>> https://github.com/financequote/financequote.
>>>
>>> If I understand you right, the field "symbol" is that same symbol which
>>> gnucash supplied. I added this locally here.
>>>
>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump
>>> fondsweb
>>> LU0119891520 LU2027374805
>>>
>>> Finance::Quote fields Gnucash uses:
>>> symbol: LU0119891520 <=== required
>>>
>>> date: 03/05/2021 <=== recommended
>>>
>>> currency: EUR <=== required
>>>
>>> last: 708.99 <=\
>>>
>>> nav: 708.99 <=== one of these
>>>
>>>price: <=/
>>>
>>> timezone: <=== optional
>>>
>>> =
>>>
>>> Finance::Quote fields Gnucash uses:
>>> symbol: LU2027374805 <=== required
>>>
>>> date: 03/05/2021 <=== recommended
>>>
>>> currency: USD <=== required
>>>
>>> last: 68.39<=\
>>>
>>> nav: 68.39<=== one of these
>>>
>>>price: <=/
>>>
>>> timezone: <=== optional
>>>
>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
>>>
>>> I also opened a bug report and cross-referenced it:
>>>
>>> https://github.com/finance-quote/finance-quote/issues/179
>>>
>>>> As for your complaint about duplicate prices, your pasted-in results
>>>> don't
>>>> show that.
>>>
>>> Many thanks for your quick reply, John. I move the discusion to
>>> gnucash-user.
>>>
>>> There are two things which I think are strange from the gnucash side:
>>>
>>> 1. gnc-fq-dump reports that stock quote cannot be used, but gnucash uses
>>> it
>>> 2. duplicate prices: I do not see them with gnc-fq-dump but gnucash shows
>>> them
>>>
>>> Ist gnucash using gnc-fq-dump in the same way I did?
>>
>> No. gnc-fq-dump is a user-convenience tool. GnuCash uses gnc-fq-helper,
>> which formats its results so that they can be fed directly to Scheme.
>> Instructions for using it by hand are in its POD.
>>
>> apparently there are others that don't pass a "symbol" element so if it
>> doesn't find the "symbol" entry in the F::Q results hash it uses the
>> user-supplied symbol instead. There's probably something about the
>> Fondweb.pm results hash that messes up retrieving the right entry.
>>
>> You can use .cpan/build/Finance-Quote-1.49-0/Examples/stockdump.pl (.cpan is
>> probably in your $HOME) to see exactly what F::Q is sending.
>
> I run stockdump.pl, but did not see anything wrong or unexpected in there:
>
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ ./stockdump.pl
> Fondsweb
> LU2027374805
> $VAR1 = {
> 'LU2027374805success' => 1,
> 'LU2027374805name' => 'Morgan Stanley INVF Global Endurance Fund
> (USD) Z',
> 'LU2027374805isin' => 'LU2027374805',
> 'LU2027374805isodate' => '2021-03-05',
> 'LU2027374805method' => 'fondsweb',
> 'LU2027374805nav' => '68.39',
> 'LU2027374805date' => '03/05/2021',
> 'LU2027374805type' => 'fund',
> 'LU2027374805currency' => 'USD',
> 'LU2027374805last' => '68.39',
>
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 11:39 AM, John Ralls wrote:
>
>
>
>> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
>>
>> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
>>>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch wrote:
>>>>
>>>> [ move this thread from gnucash-devel to gnucash-user, the original
>>>> gnucash- devel thread is here
>>>> https://lists.gnucash.org/pipermail/gnucash-devel/2021-March/045777.html
>>>> ]>
>>>> Am Sonntag, 7. März 2021, 17:51:19 CET schrieb John Ralls:
>>>>> You're on the wrong list, please use gnucash-user for this sort of
>>>>> question.
>>>>>
>>>>> GnuCash can't use the quotes because Fondsweb.pm doesn't make a field
>>>>> "symbol" in its return array. You should raise an issue at
>>>>> https://github.com/financequote/financequote.
>>>>
>>>> If I understand you right, the field "symbol" is that same symbol which
>>>> gnucash supplied. I added this locally here.
>>>>
>>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump
>>>> fondsweb
>>>> LU0119891520 LU2027374805
>>>>
>>>> Finance::Quote fields Gnucash uses:
>>>> symbol: LU0119891520 <=== required
>>>>
>>>>date: 03/05/2021 <=== recommended
>>>>
>>>> currency: EUR <=== required
>>>>
>>>>last: 708.99 <=\
>>>>
>>>> nav: 708.99 <=== one of these
>>>>
>>>> price: <=/
>>>>
>>>> timezone: <=== optional
>>>>
>>>> =
>>>>
>>>> Finance::Quote fields Gnucash uses:
>>>> symbol: LU2027374805 <=== required
>>>>
>>>>date: 03/05/2021 <=== recommended
>>>>
>>>> currency: USD <=== required
>>>>
>>>>last: 68.39<=\
>>>>
>>>> nav: 68.39<=== one of these
>>>>
>>>> price: <=/
>>>>
>>>> timezone: <=== optional
>>>>
>>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
>>>>
>>>> I also opened a bug report and cross-referenced it:
>>>>
>>>> https://github.com/finance-quote/finance-quote/issues/179
>>>>
>>>>> As for your complaint about duplicate prices, your pasted-in results
>>>>> don't
>>>>> show that.
>>>>
>>>> Many thanks for your quick reply, John. I move the discusion to
>>>> gnucash-user.
>>>>
>>>> There are two things which I think are strange from the gnucash side:
>>>>
>>>> 1. gnc-fq-dump reports that stock quote cannot be used, but gnucash uses
>>>> it
>>>> 2. duplicate prices: I do not see them with gnc-fq-dump but gnucash shows
>>>> them
>>>>
>>>> Ist gnucash using gnc-fq-dump in the same way I did?
>>>
>>> No. gnc-fq-dump is a user-convenience tool. GnuCash uses gnc-fq-helper,
>>> which formats its results so that they can be fed directly to Scheme.
>>> Instructions for using it by hand are in its POD.
>>>
>>> apparently there are others that don't pass a "symbol" element so if it
>>> doesn't find the "symbol" entry in the F::Q results hash it uses the
>>> user-supplied symbol instead. There's probably something about the
>>> Fondweb.pm results hash that messes up retrieving the right entry.
>>>
>>> You can use .cpan/build/Finance-Quote-1.49-0/Examples/stockdump.pl (.cpan is
>>> probably in your $HOME) to see exactly what F::Q is sending.
>>
>> I run stockdump.pl, but did not see anything wrong or unexpected in there:
>>
>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ ./stockdump.pl
>> Fondsweb
>> LU2027374805
>> $VAR1 = {
>> 'LU2027374805success' => 1,
>> 'LU2027374805name' => 'Morgan Stanley INVF Global Endurance Fund
>> (USD) Z',
>> 'LU2027374805isin' => 'LU2027374805',
>> 'LU2027374805isod
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 2:25 PM, Rainer Dorsch wrote: > > Am Sonntag, 7. März 2021, 22:00:04 CET schrieb John Ralls: >>> On Mar 7, 2021, at 11:39 AM, John Ralls wrote: >>>> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote: >>>> >>>> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls: >>>>>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch wrote: >>>>>> >>>>>> [ move this thread from gnucash-devel to gnucash-user, the original >>>>>> gnucash- devel thread is here >>>>>> https://lists.gnucash.org/pipermail/gnucash-devel/2021-March/045777.htm >>>>>> l >>>>>> ]> >>>>>> >>>>>> Am Sonntag, 7. März 2021, 17:51:19 CET schrieb John Ralls: >>>>>>> You're on the wrong list, please use gnucash-user for this sort of >>>>>>> question. >>>>>>> >>>>>>> GnuCash can't use the quotes because Fondsweb.pm doesn't make a field >>>>>>> "symbol" in its return array. You should raise an issue at >>>>>>> https://github.com/financequote/financequote. >>>>>> >>>>>> If I understand you right, the field "symbol" is that same symbol which >>>>>> gnucash supplied. I added this locally here. >>>>>> >>>>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump >>>>>> fondsweb >>>>>> LU0119891520 LU2027374805 >>>>>> >>>>>> Finance::Quote fields Gnucash uses: >>>>>> symbol: LU0119891520 <=== required >>>>>> >>>>>> date: 03/05/2021 <=== recommended >>>>>> >>>>>> currency: EUR <=== required >>>>>> >>>>>> last: 708.99 <=\ >>>>>> >>>>>>nav: 708.99 <=== one of these >>>>>> >>>>>> price: <=/ >>>>>> >>>>>> timezone: <=== optional >>>>>> >>>>>> = >>>>>> >>>>>> Finance::Quote fields Gnucash uses: >>>>>> symbol: LU2027374805 <=== required >>>>>> >>>>>> date: 03/05/2021 <=== recommended >>>>>> >>>>>> currency: USD <=== required >>>>>> >>>>>> last: 68.39<=\ >>>>>> >>>>>>nav: 68.39<=== one of these >>>>>> >>>>>> price: <=/ >>>>>> >>>>>> timezone: <=== optional >>>>>> >>>>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ >>>>>> >>>>>> I also opened a bug report and cross-referenced it: >>>>>> >>>>>> https://github.com/finance-quote/finance-quote/issues/179 >>>>>> >>>>>>> As for your complaint about duplicate prices, your pasted-in results >>>>>>> don't >>>>>>> show that. >>>>>> >>>>>> Many thanks for your quick reply, John. I move the discusion to >>>>>> gnucash-user. >>>>>> >>>>>> There are two things which I think are strange from the gnucash side: >>>>>> >>>>>> 1. gnc-fq-dump reports that stock quote cannot be used, but gnucash >>>>>> uses >>>>>> it >>>>>> 2. duplicate prices: I do not see them with gnc-fq-dump but gnucash >>>>>> shows >>>>>> them >>>>>> >>>>>> Ist gnucash using gnc-fq-dump in the same way I did? >>>>> >>>>> No. gnc-fq-dump is a user-convenience tool. GnuCash uses gnc-fq-helper, >>>>> which formats its results so that they can be fed directly to Scheme. >>>>> Instructions for using it by hand are in its POD. >>>>> >>>>> apparently there are others that don't pass a "symbol" element so if it >>>>> doesn't find the "symbol" entry in the F::Q results has
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 8, 2021, at 2:37 AM, Geert Janssens wrote: > > Hmm, my mail client insists on munging part of my original message on re- > sending, so here's a manually edited one with my full comment... > > Op zondag 7 maart 2021 20:39:00 CET schreef John Ralls: >> Not offhand, but it's quite possible that adding symbol fixes the problem. >> Did you try gnc-fq-helper, and if so what was its output? >> > On a tangent, why does gnucash require a symbol key ? The full hash keys also > have the symbol name, albeit in a weird format that can be converted into a > proper two-dimensional hash without too much trouble. I'm doing that in my > work in progress branch: > https://github.com/gjanssens/gnucash/blob/ > c847fa3aa4a5f90fa4dbf93673d3668e9ddc9e22/libgnucash/quotes/finance-quote- > wrapper.in#L107 > > What would be the potential issues if we decided to make the symbol key > optional, assuming we also fix the code to use the symbol part of the hash > keys of course ? gnc-fq-helper already does do that, see https://github.com/Gnucash/gnucash/blob/maint/libgnucash/quotes/gnc-fq-helper.in#L241. I guess we should remove the warning from gnc-fq-dump, it seems to be misleading. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 9, 2021, at 1:08 PM, Rainer Dorsch wrote:
>
> Hi John,
>
> it seems currency retrieval does not work with finance-quote 1.50rc1 in
> gnucash. currency-lookup.pl works though. I understand it is using
> alphavantage.
>
> Can you have a quick look at https://github.com/finance-quote/finance-quote/
> issues/173 ?
>
> Is that because of lack of support for the alphavantage key? For stocks this
> seem to work though
>
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(alphavantage
> "MSFT")' | gnc-fq-helper
> (("MSFT" (symbol . "MSFT") (gnc:time-no-zone . "2021-03-08 12:00:00") (last .
> #e227.3900) (currency . "USD")))
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump
> alphavantage
> MSFT
> Finance::Quote fields Gnucash uses:
>symbol: MSFT <=== required
> date: 03/08/2021 <=== recommended
> currency: USD <=== required
> last: 227.3900 <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
Ranier,
You need to set ALPHAVANTAGE_API_KEY in the shell in order to use gnc-fq-dump
or gnc-fq-helper. To use it in GnuCash you set it in Preferences>Online Quotes.
Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange message on launching app
You don't say what version of GnuCash, but GnuCash 4.x renamed libgncmod-app-utils.dll to libgnc-app-utils.dll, so it seems that you have some leftover bits from an earlier installation. Try uninstalling GnuCash with Apps & Settings then delete the installation directory--it defaults to C:\Program Files (x86)\gnucash--before reinstalling GnuCash 4.4. Regards, John Ralls > On Mar 12, 2021, at 3:20 AM, Mahon Finbar wrote: > > Oops the screen grab didn't transfer - > > "the procedure entry point gmc_scm_call_1_symbol_to_string could not be > located in the dll C:\programfiles(x86)\gnucash\libgncmod-app-utils.dll" > > On 12/03/2021 10:52, Mahon Finbar wrote: >> Sorry, sent this with the wrong email address. >> >> A Windows message? Using W10, no recent change with Gnucash. >> >> Needs task manager to get rid of the message. >> >> Finbar >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving to Linux
> On Mar 13, 2021, at 2:14 AM, Stephen C. Camidge wrote: > > I am moving my data from Mac OS to Linux Manjaro. > > I copied over the datafile, no problem. > > How do I copy over my Saved Reports? > > Also, since the Mac creates invisible '._*' files for each datafile, is there > a Linux terminal command I can issue to get rid of all of them? https://wiki.gnucash.org/wiki/Backup#Related_Files I've never encountered ._* files, but you can get rid of them all with `find path -name ._* -delete`, substituting the actual path you wand to search for path. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange message on launching app
The important thing is to make sure that you don't restore an old version of GnuCash dlls. The most straightforward way is to leave executables out of the backup plan because you can always download them again from their respective sources. A bit less simple is to have a separate backup set for them so that you can easily roll back after an update or restore more quickly after a disk failure. Regards, John Ralls > On Mar 13, 2021, at 6:06 AM, Mahon Finbar wrote: > > OK, I'll try that, thanks. > > I have the most recent version for Windows 10, afaik. Haven't recently > downloaded any update and have been using the current version for a while, > like since last q 2020. Could be a storage glitch, I suppose. > > Should I make a specific backup? I have backblaze for backup, but do I need > to ensure files are the latest? > > Finbar > > On 12/03/2021 21:08, John Ralls wrote: >> You don't say what version of GnuCash, but GnuCash 4.x renamed >> libgncmod-app-utils.dll to libgnc-app-utils.dll, so it seems that you have >> some leftover bits from an earlier installation. Try uninstalling GnuCash >> with Apps & Settings then delete the installation directory--it defaults to >> C:\Program Files (x86)\gnucash--before reinstalling GnuCash 4.4. >> >> Regards, >> John Ralls >> >> >>> On Mar 12, 2021, at 3:20 AM, Mahon Finbar wrote: >>> >>> Oops the screen grab didn't transfer - >>> >>> "the procedure entry point gmc_scm_call_1_symbol_to_string could not be >>> located in the dll C:\programfiles(x86)\gnucash\libgncmod-app-utils.dll" >>> >>> On 12/03/2021 10:52, Mahon Finbar wrote: >>>> Sorry, sent this with the wrong email address. >>>> >>>> A Windows message? Using W10, no recent change with Gnucash. >>>> >>>> Needs task manager to get rid of the message. >>>> >>>> Finbar >>>> >>>> ___ >>>> gnucash-user mailing list >>>> gnucash-user@gnucash.org >>>> To update your subscription preferences or to unsubscribe: >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> If you are using Nabble or Gmane, please see >>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>> - >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange message on launching app
The trace file associated with a crash just means that GnuCash got far enough
into the program to open it before trying to load the library linked to
libgncmod-app-utils.dll. That's not meaningful.
"GNU FEB 12 2019.gnucash" is a very odd name for a book, but OK. The existence
of a lock file from the 8th means that that's when you last successfully opened
the file, and that the full name is "GNU FEB 12
2019.gnucash.20210219151108.gnucash.LCK" means that you've been working with a
backup file since mid-afternoon on 19 February. The other two files aren't from
GnuCash; perhaps they're download or cache files from your browser?
Navigate to the folder where "GNU FEB 12
2019.gnucash.20210219151108.gnucash.LCK" is and look for "GNU FEB 12
2019.gnucash", "GNU FEB 12 2019.gnucash.20210219151108.gnucash", and files of
the form "GNU FEB 12
2019.gnucash.20210219151108.gnucash.MMDDHHMMSS.gnucash" which will be
backups of your GnuCash sessions since you opened the backup file instead of
the original.
Regards,
John Ralls
> On Mar 15, 2021, at 7:13 AM, Mahon Finbar wrote:
>
> OK, I appreciate that, thank you.
>
> However, in trying to find the last backup file before uninstalling, I am
> finding some very strange file dates and times in the list.
>
> For example - gnucash.trace.3JC5Z0.log - on 14.3.2021 - a time when I could
> not get the app to load, [with the same message as originally].
>
> I don't seem to have any backups, which according to the help file should
> read as .MMDDHHMMSS.gnucash
>
> The 'latest' file in the list is GNU FEB 12
> 2019.gnucash.20210219151108.gnucash.LCK on 8.3.2021 and I have several -
> https___bugs_gnucash_org_enter_bug_cgi_product=GnuCash files on the same
> date, as well as several -
> {7C5A40EF-A0FB-4BFC-874A-C0F2E0B9FA8E}_gnucash_doc_gnucash_README_win32-bin_txt
> files dated the same date, 8.3.2021.
>
> The file names don't seem to align with the help file data.
>
> Any ideas?
>
> Thanks Finbar
>
> On 13/03/2021 19:47, John Ralls wrote:
>
>> The important thing is to make sure that you don't restore an old version of
>> GnuCash dlls. The most straightforward way is to leave executables out of
>> the backup plan because you can always download them again from their
>> respective sources. A bit less simple is to have a separate backup set for
>> them so that you can easily roll back after an update or restore more
>> quickly after a disk failure.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>> On Mar 13, 2021, at 6:06 AM, Mahon Finbar
>>> wrote:
>>>
>>> OK, I'll try that, thanks.
>>>
>>> I have the most recent version for Windows 10, afaik. Haven't recently
>>> downloaded any update and have been using the current version for a while,
>>> like since last q 2020. Could be a storage glitch, I suppose.
>>>
>>> Should I make a specific backup? I have backblaze for backup, but do I need
>>> to ensure files are the latest?
>>>
>>> Finbar
>>>
>>> On 12/03/2021 21:08, John Ralls wrote:
>>>
>>>> You don't say what version of GnuCash, but GnuCash 4.x renamed
>>>> libgncmod-app-utils.dll to libgnc-app-utils.dll, so it seems that you have
>>>> some leftover bits from an earlier installation. Try uninstalling GnuCash
>>>> with Apps & Settings then delete the installation directory--it defaults
>>>> to C:\Program Files (x86)\gnucash--before reinstalling GnuCash 4.4.
>>>>
>>>> Regards,
>>>> John Ralls
>>>>
>>>>
>>>>
>>>>> On Mar 12, 2021, at 3:20 AM, Mahon Finbar
>>>>> wrote:
>>>>>
>>>>> Oops the screen grab didn't transfer -
>>>>>
>>>>> "the procedure entry point gmc_scm_call_1_symbol_to_string could not be
>>>>> located in the dll C:\programfiles(x86)\gnucash\libgncmod-app-utils.dll"
>>>>>
>>>>> On 12/03/2021 10:52, Mahon Finbar wrote:
>>>>>
>>>>>> Sorry, sent this with the wrong email address.
>>>>>>
>>>>>> A Windows message? Using W10, no recent change with Gnucash.
>>>>>>
>>>>>> Needs task manager to get rid of the message.
>>>>>>
>>>>>> Finbar
>>>>>>
>>>>>> ___
>>>>>> gnucash-user ma
Re: [GNC] Error on report over time
Michael, Please do not contradict core developers when they request that a user submit a bug report. Regards, John Ralls > On Mar 15, 2021, at 11:27 AM, Michael or Penny Novack > wrote: > > On 3/15/2021 11:48 AM, Christopher Lam wrote: >> This is a strange report indeed. May I suggest a bug report at Bugzilla. >> >> On Mon, 15 Mar 2021, 3:00 am , wrote: >> >>> Hello, >>> >>> My "Expenses over time" report and also the "Income over time" report >>> from last year (2020) is showing November 2019 instead of November 2020 >>> and the amounts appear as the sum of those two months (Nov/2019 and >>> Nov/2020). > > No, the FIRST step should not be a "bug report". He did the right thing > asking on the user list because BEFORE thinking something wrong is a bug need > to find out if other people are experiencing it. > > If these "Expenses over time" and "Income over time" reports are working > correctly for other people the problem is unlikely to be a bug. Our > developers are volunteers and should not have to spend their time figuring > what somebody entered wrong, had the wrong options set, etc. That's what we > here do. > > Michael D Novack > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Missing file messages when starting Gnucash
> On Mar 16, 2021, at 6:54 AM, avigr...@juno.com wrote: > > Version: 4.4 > Build ID: 4.4+(2020-12-28)Windows 10 When I start GnuCash, I am now receiving > a series of error messages telling me that I am missing a lot of files. > After I respond OK to all of the messages, it finally opens GnuCash and > everything appears to be okay. How do I get rid of these error messages? What files are missing? As a first guess you have leftovers from a previous installation. Try uninstalling GnuCash using Apps & Features (right-click the Windows Start button, it's at the top of the menu), then navigate to C:\Program Files (x86) in File Explorer and delete the gnucash folder. Finally re-run gnucash-4.4-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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange message on launching app
That's probably not the file you want unless you haven't entered anything since
19 February. You had a lock on "GNU FEB 12 2019.gnucash.20210219151108.gnucash"
suggesting that might not be the case.
https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_...
explains how GnuCash organizes your data files. If they're spread out over
several folders that's your doing, not GnuCash's.
Regards,
John Ralls
> On Mar 16, 2021, at 7:08 AM, Mahon Finbar wrote:
>
> OK, I found the GNU FEB 12 2019.gnucash file saved on 19.2.2021, but not the
> others. Anyway if that is the "good" backup that should be OK? It only has
> 362kb in it.
>
> As it happens the file wasn't in a GnucashLCK folder, there were two
> files on 8.3.2021 with the same name and time and date, but in different
> folders, one of which was empty and lots of other stuff on an around that
> date.
>
> The storage of GNU files has always been a bit of a mystery to me, they seem
> to shuffle around, a search of files with .gnucash results in more than 600
> answers!!
>
> OK, if I uninstall and reinstall will it find the 'good' backup mentioned?
>
> Thanks so much for your patience and help.
>
> Finbar
>
> On 15/03/2021 17:03, John Ralls wrote:
>> The trace file associated with a crash just means that GnuCash got far
>> enough into the program to open it before trying to load the library linked
>> to libgncmod-app-utils.dll. That's not meaningful.
>>
>> "GNU FEB 12 2019.gnucash" is a very odd name for a book, but OK. The
>> existence of a lock file from the 8th means that that's when you last
>> successfully opened the file, and that the full name is "GNU FEB 12
>> 2019.gnucash.20210219151108.gnucash.LCK" means that you've been working with
>> a backup file since mid-afternoon on 19 February. The other two files aren't
>> from GnuCash; perhaps they're download or cache files from your browser?
>>
>> Navigate to the folder where "GNU FEB 12
>> 2019.gnucash.20210219151108.gnucash.LCK" is and look for "GNU FEB 12
>> 2019.gnucash", ", and files of the form "GNU FEB 12
>> 2019.gnucash.20210219151108.gnucash.MMDDHHMMSS.gnucash" which will be
>> backups of your GnuCash sessions since you opened the backup file instead of
>> the original.
>>
>> Regards,
>> John Ralls
>>
>>
>>> On Mar 15, 2021, at 7:13 AM, Mahon Finbar wrote:
>>>
>>> OK, I appreciate that, thank you.
>>>
>>> However, in trying to find the last backup file before uninstalling, I am
>>> finding some very strange file dates and times in the list.
>>>
>>> For example - gnucash.trace.3JC5Z0.log - on 14.3.2021 - a time when I could
>>> not get the app to load, [with the same message as originally].
>>>
>>> I don't seem to have any backups, which according to the help file should
>>> read as .MMDDHHMMSS.gnucash
>>>
>>> The 'latest' file in the list is GNU FEB 12
>>> 2019.gnucash.20210219151108.gnucash.LCK on 8.3.2021 and I have several -
>>> https___bugs_gnucash_org_enter_bug_cgi_product=GnuCash files on the same
>>> date, as well as several -
>>> {7C5A40EF-A0FB-4BFC-874A-C0F2E0B9FA8E}_gnucash_doc_gnucash_README_win32-bin_txt
>>> files dated the same date, 8.3.2021.
>>>
>>> The file names don't seem to align with the help file data.
>>>
>>> Any ideas?
>>>
>>> Thanks Finbar
>>>
>>> On 13/03/2021 19:47, John Ralls wrote:
>>>
>>>> The important thing is to make sure that you don't restore an old version
>>>> of GnuCash dlls. The most straightforward way is to leave executables out
>>>> of the backup plan because you can always download them again from their
>>>> respective sources. A bit less simple is to have a separate backup set for
>>>> them so that you can easily roll back after an update or restore more
>>>> quickly after a disk failure.
>>>>
>>>> Regards,
>>>> John Ralls
>>>>
>>>>
>>>>
>>>>> On Mar 13, 2021, at 6:06 AM, Mahon Finbar
>>>>> wrote:
>>>>>
>>>>> OK, I'll try that, thanks.
>>>>>
>>>>> I have the most recent version for Windows 10, afaik. Haven't recently
>>>>> downloaded any update and have been using the current version f
Re: [GNC] Importing Accounts with non-English Characters
Looks like option is getting used as part of shortcuts, intercepting its use for extending the keyboard. Option-u-u opens that weird entry box and option-o operates the OK key. Option-e still works to create an accent-grave so it's just modifier key overloads. In the transfer dialog option-u-u makes a ü as it should, but option-o still operates the OK button. Regards, John Ralls > On Mar 16, 2021, at 7:39 PM, w...@theprescotts.com wrote: > > On MacOS, you can access all those special characters from the Keyboard menu. > One of the tabs in the Keyboard System Preference has an option to 'Show > Input menu in the menu bar'. Then from any app you can open up an 'Emoji and > Symbol Viewer' that will allow you to insert any symbol or character anywhere. > > Will > > On 2021 Mar 16, at 03-16 19:02:36, prl wrote: > > On 17/3/21 11:47, prl wrote: >> On 17/3/21 05:20, viking wrote: >>> Liz wrote >>>> On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) >>>> viking < >>>> viking2ev@.rr >>>> > wrote: >>>> >>>>> Quite an old bug from 2017. Is there a workaround to be able to import >>>>> accounts with non-English characters? >>>>> >>>>> I am also not able to /manually/ create a new account including >>>>> non-English characters. For example, the letter "å" can be typed here >>>>> by pressing "Alt-0229". However, it doesn't work when trying to type >>>>> this letter in the Account name for a New Account. >>>>> Is this another bug? >>>> Can you copy and paste the correct characters into place? >>>> >>>> Liz >>> @Liz, >>> Yes. copy/paste works but not typing the character directly. I guess this is >>> a bug. >> I can't enter non-ACSII characters in the Account name in Gnucash 4.4/MacOS >> 11.2.3 either (viking is having the issue on Windows GC 4.4). Normally on >> the Mac, OPTION-"u", "u" should enter ü (u-umlaut), but when I type the "u" >> after the OPTION-"u", a small text entry popup is displayed that covers the >> New Account popup's Help button, and a single "u" (without umlaut) appears >> in the text entry popup. >> >> After that text entry popup appears, all text entry goes into that popup. >> The Cancel button on the New Account popup still works to get out of it. >> >> Maybe GTK is grabbing the keyboard codes before the normal keyboard text >> entry processing is done on them. >> >> Peter >> > Curiouser and curioser. If in MacOS GC 4.4, I type OPTION-"u", "u" into the > little text entry popup that appears after I first enter OPTION-"u", "u", > that does enter ü (u-umlaut) into the popup text box. However, there's > something that causes the popup text box to time out, and there's no way I > could find to get the text out of the popup text box and into the AccountName > box, not even using copy-paste before the timeout. > > Peter > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing Accounts with non-English Characters
Resent to the list because of a server bounce. Sorry for the dupe, Adrien. There's a checkbox in System Preferences>Keyboard>Input Sources to show input menu in the menu bar. Turn that on: It includes two items, Show Emoji & Symbols, that actually gives access to all code points, and Show Keyboard Viewer, which shows what keys do what; it's interactive so if you hold down option it shows what characters it makes available. With the US English keyboard there are some combining keys, circled in orange: `, e, u, i, and n for accent aigue, accent grave, dieresis, circumflex, and cedilla respectively. Regards, John Ralls > On Mar 17, 2021, at 8:26 AM, Adrien Monteleone > wrote: > > Not sure if this is related with the overload, but I noticed that when > triggering the accented character selector/pop-up in MacOS, I can't type the > number for the character I want like in other apps. I still can use the arrow > keys though. Otherwise, I can get most characters by remembering the specific > Option sequence, but all of mine are simple two-key presses so I've yet to > know if more complicated combos are an issue. > > Regards, > Adrien > > On 3/16/21 11:21 PM, John Ralls wrote: >> Looks like option is getting used as part of shortcuts, intercepting its use >> for extending the keyboard. Option-u-u opens that weird entry box and >> option-o operates the OK key. Option-e still works to create an accent-grave >> so it's just modifier key overloads. In the transfer dialog option-u-u makes >> a ü as it should, but option-o still operates the OK button. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Editing "Import Map Editor"
> On Mar 18, 2021, at 12:10 PM, viking wrote: > > I understand that there is currently no way to add new rows/criteria in the > "Import Map Editor". > However, is the information stored in some file that could be manually > modified to add new rows/criteria? Well, it's stored in a file and you can edit it. Whether you can successfully add new criteria would depend upon how well you understand how the matcher works. No, it's not documented, you'll have to study the C code in gnucash/import-export. Note that we strongly discourage editing your data directly and won't provide any support at all if you do. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
This is all very good but it would be a heck of a lot more useful as an issue
or pull request at https://github.com/finance-quote/finance-quote.
Regards,
John Ralls
> On Mar 18, 2021, at 10:35 PM, Peter West wrote:
>
> It works because there is now a linebreak in there within the text of the
> -0.21%. I wouldn’t rely on that.
>
> Change the RE to
>
> m[NAV />([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*Day
> Change[^%]*>([0-9\.\-]+)]
>
> to stop the first ‘.*’ at ‘Day Change, and to stop the second ‘.*’ before it
> gobbles a % sign. Basically, you insert 'Day Change[^%]*’ after the ‘.*’ and
> before the ‘>’.
>
> Peter
> —
> p...@ehealth.id.au
> “…you refuse to come to me that you may have life.”
>
>> On 19 Mar 2021, at 11:18 am, Geoff wrote:
>>
>> Hi Peter
>>
>> This is the URL:
>>
>> https://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=f0gbr04aoc
>>
>> Note that Morningstar use their own Security IDs (f0gbr04aoc), the initial
>> lookup is via ISIN (LU0067412154) done from here:
>>
>> https://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=LU0067412154
>>
>> Hope this helps.
>>
>> Regards
>>
>> Geoff
>> =
>>
>> On 19/03/2021 11:00 am, Peter West wrote:
>>> Can you provide the html again, as is, without any inserted linefeeds?
>>> Peter
>>> —
>>> p...@ehealth.id.au
>>> “…you refuse to come to me that you may have life.”
>>>> On 19 Mar 2021, at 3:45 am, Andrea Borgia wrote:
>>>>
>>>> Il 18/03/21 14:41, D. via gnucash-user ha scritto:
>>>>> Well, considering that the NAV in the example is "USD 2150.31" and the
>>>>> 5366.43 in the example actually represents the fund size, I'd imagine you
>>>>> should get the former as the NAV.
>>>>>
>>>> Yes, and at the moment it is working again.
>>>>
>>>> In the attached screenshot, first two runs are from the time of the
>>>> original post and the third one just now.
>>>>
>>>>
>>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Had to download application again
> On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user > wrote: > > I had to reboot my MacBook Air. This caused my Gnucash application/program > file (is that the correct description?) to be deleted. I had to re-download > the application. Did I do something wrong when I re-booted? > > My Gnucash “drive” appears to as an external drive……see attached screen shot. No, rebooting did not cause anything to be deleted. Your screenshot didn't come through, but your external drive comment leads me to guess that you were running GnuCash from the mounted disk image. You didn't need to re-download it, you could remount it by double-clicking on Gnucash-Intel-4.4-1.dmg in your Downloads folder. But GnuCash doesn't work all that well from the dmg (no mac application does) so you're supposed to drag it from there to the Applications folder before running it. Once you've done that you can eject the disk image (control click and select eject or use the eject symbol next to the disk image name in Finder's sidebar). Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] namespaces vs import prices
Please don't reply when you want to start a new thread, especially not to a digest. No problem, you can arrange non-currency commodities in namespaces however you like and you can change a non-currency commodity's namespace in Tools>Security Editor. Regards, John Ralls > On Mar 21, 2021, at 7:09 PM, Steven Anter wrote: > > The newer releases of gnucash now require a namespace to import prices from > a csv file. This is rather cumbersome because my securities are spread out > over a few namespaces. The notion of "namespace" is irrelevant to the > way I use gnucash; if I could bypass I would. Perhaps there is a way I can > change all securities to have the same namespace of "MISC" If there is, > please let me know > > > On Sun, Mar 21, 2021 at 7:40 AM wrote: > >> Send gnucash-user mailing list submissions to >>gnucash-user@gnucash.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >>https://lists.gnucash.org/mailman/listinfo/gnucash-user >> or, via email, send a message with subject or body 'help' to >>gnucash-user-requ...@gnucash.org >> >> You can reach the person managing the list at >>gnucash-user-ow...@gnucash.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of gnucash-user digest..." >> >> >> Today's Topics: >> >> 1. Re: Had to download application again (David Ridell) >> 2. Re: CSV matching produces duplicates? (David Cousens) >> 3. mortgage refinance (Parker Graham) >> 4. Re: mortgage refinance (py...@cox.net) >> 5. Re: mortgage refinance (Parker Graham) >> 6. Re: mortgage refinance (D) >> 7. Re: mortgage refinance (Peter West) >> 8. Re: mortgage refinance (Derek Atkins) >> 9. Re: mortgage refinance (Derek Atkins) >> 10. Re: mortgage refinance (Peter West) >> 11. Re: mortgage refinance (py...@cox.net) >> >> >> -- >> >> Message: 1 >> Date: Fri, 19 Mar 2021 12:57:19 -0400 >> From: David Ridell >> To: John Ralls >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Had to download application again >> Message-ID: <19e7dc05-6e5c-4e23-9cc5-fb238f5fe...@aol.com> >> Content-Type: text/plain; charset=utf-8 >> >> Thank you! >> >> David >> >> Sent from my iPhone >> >>> On Mar 19, 2021, at 12:30 PM, John Ralls wrote: >>> >>> ? >>> >>>> On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user < >> gnucash-user@gnucash.org> wrote: >>>> >>>> I had to reboot my MacBook Air. This caused my Gnucash >> application/program file (is that the correct description?) to be deleted. >> I had to re-download the application. Did I do something wrong when I >> re-booted? >>>> >>>> My Gnucash ?drive? appears to as an external drive??see attached screen >> shot. >>> >>> No, rebooting did not cause anything to be deleted. Your screenshot >> didn't come through, but your external drive comment leads me to guess that >> you were running GnuCash from the mounted disk image. You didn't need to >> re-download it, you could remount it by double-clicking on >> Gnucash-Intel-4.4-1.dmg in your Downloads folder. >>> >>> But GnuCash doesn't work all that well from the dmg (no mac application >> does) so you're supposed to drag it from there to the Applications folder >> before running it. Once you've done that you can eject the disk image >> (control click and select eject or use the eject symbol next to the disk >> image name in Finder's sidebar). >>> >>> Regards, >>> John Ralls >>> >> >> >> >> -- >> >> Message: 2 >> Date: Sun, 21 Mar 2021 01:09:25 -0500 (CDT) >> From: David Cousens >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] CSV matching produces duplicates? >> Message-ID: <1616306965440-0.p...@n4.nabble.com> >> Content-Type: text/plain; charset=us-ascii >> >> The matching of the account names in the input records (whether transfer >> accounts or the main account for the transaction) to the GnuCash internal >> accounts only happens for the first time those accounts occur in an input >> data file. After that GnuCash remembers the assignment of external account >> names to its internal acco
Re: [GNC] asset discrepancy in change of year
Andrea, The most likely reason is that you failed to book a capital gain/loss from a stock sale or a currency exchange. Regards, John Ralls > On Mar 27, 2021, at 9:39 AM, Andrea Borgia wrote: > > Hi. > > > As previously mentioned, each year I close the current gnucash book and open > a new one. > > For 2020: "Initial capital of 2020" = "Asset of 2019" - "Expenses of 2019" > + "Income of 2019" (there are no liabilities) > > > For 2021 things are not right, apparently: > > * "assets of 2020" - "Expenses of 2020" + "Income of 2020" ends in ...418,08 > > * the sum of all assets (cash, bank account, paypal, prepaid card, you name > it...) ends in ...440,28 > > > I can't find the error: all income / expense accounts in 2020 have been > closed to a "results" account so it's pretty easy to see they're all zero and > the "results" account goes to "capital". > > Each individual asset has been cross-checked and marked "OK" in the new > book's "Capital" account where I recorded the opening balances. Since those > are verifiable values not depending on income / expenses, I'm inclined to > believe this is the true value for capital at end of 2020. > > > How do I go about fixing this? If my reasoning is correct, the fault must lay > somewhere in the 2020 book, right? > > By the way, even before the recent thread with David on multiple currencies I > had exactly the same mismatch and "repair" finds no issues in either book, > > > Thanks, > > Andrea. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 4.5 Released
The GnuCash development team announces GnuCash 4.5, the sixth release in the stable 4.x series Between 4.4 and 4.5, the following bugfixes were accomplished: • Bug 783283 - Multi-Currency payments use wrong date Also properly handles the user clicking the cancel button on the transfer dialog. It will now just return to the payment window, waiting for further user input. • Bug 797621 - GnuCash freezes temporarily and sometimes crashes when selecting Sales Tax Table in Invoices • Bug 797630 - Check for missing dependencies of 'Get Quotes' to avoid Gnucash crash. • Bug 797906 - GnuCash data file is locked after a "save-as" to mysql database. It's more general, any save-as to a different backend type, i.e. xml->sql or sql->xml, left the previous book locked. • Bug 797924 - Crash when searching for customer to process payment. • Bug 797997 - File gnucash could note be found On Microsoft Windows when run from a CMD shell and passing a path that contains non-ASCII characters. • Bug 798019 - Currency rates in OFX file are ignored Use currency_rate information from OFX file if available. Requires LibOFX v 0.10.0 or later. • Bug 798044 - Adding splits to a lot is extremely slow • Bug 798060 - Invoices are missing on Customer report after upgrade • Bug 798070 - Opening balance does not update when creating account from Account Hierarchy • Bug 798078 - Report 'Income Chart' prints stacktrace when end date before start date • Bug 798085 - Incorrect transactions import of entires with large number amount Quicken 2005 introduces U amount which sometimes differs from T amount. U amount has larger range, and must override T amount whenever they're not equal. • Bug 798093 - Changing the symbol/abbreviation of a security after the trading account was created breaks GnuCash. Makes it possible for the user to rename trading accounts or securities independent of each other. • Bug 798096 - can't duplicate TX previous to red line threshold • Bug 798098 - Crash popup show when have 3 Windows in OSX • Bug 798100 - Equity totals calculating incorrectly Prevents creation of non-currency opening balance accounts. • Bug 798101 - Do not #undef __STRICT_ANSI__ Remove defines and undefines for Windows, they were needed with MinGW classic but are not with MinGW-w64. • Bug 798104 - Menu item for "Import Account" is wrong in danish • Bug 798112 - An error occurred while processing mysql ... A "Feature" of MYSQL is that it allows C-style backslash escapes in string constants and replaces them with the actual character (e.g. \n is converted to 0x0a). This causes round trip problems if the escape is one of the allowed ones and a MYSQL error if it isn't. Disable the feature so that MYSQL follows the SQL standard. • Bug 798132 - Invoice Importing crashes when importing low quantity values. • Bug 798135 - GtkEntry text with search list: shows selected entry again for no reason • Bug 798147 - Notes entry crashes program • Bug 798149 - CSV transaction Import setting loses account name if it is changed after setting is memorized Account guid is saved as well as the full account name and when recalled the account is looked up first by guid, if this fails the full account name is checked which if successful immediately updates the saved base account setting with the account guid for future use. If unsuccessful the account combo is blank with a error message as before. When save CSV settings button is used, both the Guid and full paths are saved so previous versions can still use the full path as before. • Bug 798150 - Error on report over time Caused by incorrect handling of Daylight Savings beginning at midnight. • Bug 798154 - Tooltips wrong when multiple charts in one report The following fixes and improvements were not associated with bug reports: • Fix building based on unix makefiles • Make the chart on the report page icon larger to align better with the account page icon. • Allow the context menu when GncCellRendererTextView is in edit mode. • Restructure early locale initialization • Move macOS specific bits to its own source file. As this is objective-c use .mm extension • Use common function signature for macOS and Windows init function and include via common header file • Fix GncDateTime::format_zulu to emit the UTC timezone instead of the GncDateTime's timezone with the UTC timestamp. • Fix the implementations of gnc_foo_get_day_neutral. As implemented these returned 10:59 AM local on the day but neutral time is 10:59 UTC. • gnc_invoice_window_print_invoice return NULL if invoice is NULL. • [dialog-invoice] invoice editor reuses invoice report tab. • Allow for Header Bar use in CSV t
Re: [GNC] Trading accounts functionality
On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: > > which by the way it > does not use the default security fraction which is 1/ but > 1/. The price is in Euro, so it displays as 1/100 of the Euro's fraction. That's for display only, the actual calculated price is as exact a fraction as can be represented with two 64-bit integers. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: > > On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: >> >> which by the way it >> does not use the default security fraction which is 1/ but >> 1/. > > The price is in Euro, so it displays as 1/100 of the Euro's fraction. That's > for display only, the actual calculated price is as exact a fraction as can > be represented with two 64-bit integers. Sorry, you meant that the BTC amount in the trading split is rounded to 1/1000. Maybe there's a 1/100 clamp left somewhere in the balancing logic? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
> On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: > > On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: >> >> >>> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: >>> >>> On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: >>>> >>>> which by the way it >>>> does not use the default security fraction which is 1/ >>>> but >>>> 1/. >>> >>> The price is in Euro, so it displays as 1/100 of the Euro's >>> fraction. That's for display only, the actual calculated price is >>> as exact a fraction as can be represented with two 64-bit integers. >> >> Sorry, you meant that the BTC amount in the trading split is rounded >> to 1/1000. Maybe there's a 1/100 clamp left somewhere in the >> balancing logic? >> >> Regards, >> John Ralls >> > Yes you are right, the account created by the trading subsystem, > Trading:Crypto Currency:BTC-EUR, is in BTC which is a security in the > system not in eur which is a currency. > Although I have switched to use "commodity value" in the "smallest > fraction" switch it still uses 1/ instead the 1/. > But this is somehow minor issue as I assume it does not affect the > actual value of the account, it's just visual. No, it's pretty clearly keeping the transaction from balancing because .0012 != .00115652. As for the trading splits miraculously appearing, did that happen to all cross-commodity transactions in your book or just ones that you touched? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trading accounts functionality
> On Apr 2, 2021, at 12:23 PM, zuperkoleopt...@gmail.com wrote: > > On Fri, 2021-04-02 at 11:58 -0700, John Ralls wrote: >> >> >>> On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: >>> >>> On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: >>>> >>>> >>>>> On Apr 2, 2021, at 8:37 AM, John Ralls >>>>> wrote: >>>>> >>>>> On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: >>>>>> >>>>>> which by the way it >>>>>> does not use the default security fraction which is >>>>>> 1/ >>>>>> but >>>>>> 1/. >>>>> >>>>> The price is in Euro, so it displays as 1/100 of the Euro's >>>>> fraction. That's for display only, the actual calculated price >>>>> is >>>>> as exact a fraction as can be represented with two 64-bit >>>>> integers. >>>> >>>> Sorry, you meant that the BTC amount in the trading split is >>>> rounded >>>> to 1/1000. Maybe there's a 1/100 clamp left somewhere in the >>>> balancing logic? >>>> >>>> Regards, >>>> John Ralls >>>> >>> Yes you are right, the account created by the trading subsystem, >>> Trading:Crypto Currency:BTC-EUR, is in BTC which is a security in >>> the >>> system not in eur which is a currency. >>> Although I have switched to use "commodity value" in the "smallest >>> fraction" switch it still uses 1/ instead the 1/. >>> But this is somehow minor issue as I assume it does not affect the >>> actual value of the account, it's just visual. >> >> No, it's pretty clearly keeping the transaction from balancing >> because .0012 != .00115652. >> >> As for the trading splits miraculously appearing, did that happen to >> all cross-commodity transactions in your book or just ones that you >> touched? >> >> Regards, >> John Ralls >> >> > To all cross-commodity transactions, I haven't touched - balanced any > transaction yet. > I turned on trading accounts just a few days a go and still trying to > evaluate my situation, whether I will keep the feature on or not. Well, you've touched at least the one from the screenshot. You can't get that dialog box unless you've opened the transaction for editing. If you open the register for Trading:BTC-EUR are there lots of transactions listed? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tax deferred account transfers suggestion
> On Apr 2, 2021, at 1:02 PM, Michael or Penny Novack > wrote: > > On 4/2/2021 2:44 PM, David G. Pickett via gnucash-user wrote: >> It'd be nice if the transfers from tax deferred accounts (401k, IRA) to not >> tax deferred showed as taxable income on the tax report. Reverse transfers >> might also be listed as tax deductions. > > It would help you to understand the issues if you tried to record this > transaction without gnucash (do it the old fashioned way, on paper). > > This is not the only "interesting" situation involving taxable income. In > this case, money WAS being transferred, debit some bank account, credit the > 401k account. But take an example where you received NOTHING tangible but > were informed you had some taxable income. You need an example? > > As an employee benefit, an employer is allowed to pay the premiums on a life > insurance policy on the employee's life, the employee getting to choose the > beneficiary. Generally the employer makes this benefit "one year's salary" of > life insurance. By US tax code, this is not considered taxable income to the > employee up to $50,000 of insurance coverage. But suppose that employee made > $60,000 per year so the insurance coverage was for that amount. The premium > on $10,000 of that (the amount over $50,000) would taxable income to the > employee. > > << this is really the same problem -- the issue is, what is the debit side of > that credit >> > If there are any non-USA-citizens reading you can stop now, this is all about US tax and retirement law. Michael, I thought you were old enough to be experiencing this directly! ;-) With so-called traditional (i.e. non-Roth) IRAs and most 401K plans once you attain age 65 you may begin withdrawing and once you reach 72 you *must* begin withdrawing. In most cases the contributions and in all cases the gains and earnings in the retirement account were not taxed, so the withdrawals are taxed as part of ordinary income. No capital gains. As David T. observes from an accounting standpoint there's no income account involved, you're transferring from the IRA/401K account to your regular bank/brokerage account. However, I'd think it possible for the Tax Report Options to tag the account and notice credits to it. Whether and how that might be wired into the TXF format I have no idea, I don't use the TXF report. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Preferences reset
I haven't noticed anything and so far everyone who's reported this uses the flatpak build. My guess for the most likely cause is that we upgraded the Gnome runtime and there's some change to GSettings in there. Regards, John Ralls > On Apr 3, 2021, at 9:33 AM, David Carlson wrote: > > So your file history was gone too. I wonder if there is a comparable > problem with Mac computers? > > On Sat, Apr 3, 2021, 11:05 AM Mike wrote: > >> Yeah, that's exactly what I mean. I forgot to add that when I clicked on >> the desktop icon to start GC it opened a new database with no entries as if >> I were starting GC from scratch. I had to find the file and start it from >> the file manager. I was worried that my data would be gone, but it was only >> my preferences that were gone. >> >> Mike >> >> On 4/3/21 9:49 AM, David Carlson wrote: >> >> Do you mean that GnuCash reset your preferences for you without any action >> on your part? >> >> That sounds like a bug to me. >> >> >> >> On Sat, Apr 3, 2021, 8:38 AM Mike via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >>> I just opened GC today and discovered that I had to reset all of my >>> preferences. None of the entries were affected. Very strange, I've not >>> had that happen before. I'm using GC Flatpak version 4.5 on Linux Mint >>> 20.1 for those who are interested. >>> >>> Mike >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnc 4.5 report charts do not render (blank screen)
> On Apr 4, 2021, at 9:18 AM, Tommy Trussell wrote: > > On Thu, Apr 1, 2021 at 3:07 PM Mike Commissaris > wrote: > >> MX-Linux 19.3_64 >> Built release 4.5. Textual reports work fine. However any report that >> involves graphics does not render. Report loads and settings are available >> but screen renders blank. >> I also have versions 4.3 and 4.4 installed in their own directories - they >> both render normally. >> > > Hi -- The first thing I suggest is running GnuCash from a terminal and > watch for error messages on the console. I might suspect a problem with the > charting library (is it still jqplot ?) and it may be as simple as making > sure the jqplot library files are in the right place when you compile it. > OR it may be something more complicated having to do with webkit (which > renders reports) in your distribution OR... > > Be sure to report back to the list because others are likely to know a lot > more than I do. We don't use jqplot any more because it was no longer maintained. We use chartjs now. Graphs not drawing has in the past been down to the javascript thread that renders the chart not sending the bits back to the GtkWebKitWebView thread for drawing. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Keyboard shortcut to open split dialog—Mac
> On Apr 5, 2021, at 8:01 AM, Eric Beversluis > wrote: > > Is there a keyboard shortcut on Mac to open the split dialogue? It bogs down > the workflow to have to grab the mouse, right click, and then click “split”. > > The alt-[menu item] method doesn’t seem to work on Mac. No, but you can make one easily enough: https://wiki.gnucash.org/wiki/GTK3#Menu_Keyboard_Shortcuts The action is SplitTransactionAction. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] asset discrepancy in change of year
> On Apr 9, 2021, at 9:37 AM, Andrea Borgia wrote: > > Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam < > christopher@gmail.com> ha scritto: > > >> >> There is some discussion in an unusually detailed bug report >> https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in >> GnuCash's transaction currency being permitted to be any currency. e.g. if >> your home currency is USD, but transfer GBP to EUR, the UI will record only >> GBP/EUR fx. The new method would enforce the transaction currency to be USD >> therefore your GBP->EUR would require GBP/USD and EUR/USD fx rates. Thus, >> w.r.t. USD, all fx gains/losses are recorded accurately. >> >> To fix this would be an enormous amount of work and invalidate a lot of >> code, but would definitely simplify and fix a lot of code too IMHO. >> > > Does it apply also to mutual funds purchased in a foreign currency? > For example,I operate in EUR, I change a given amount to USD and use it to > purchase a USD-denominated fund. > Will gnucash with the "trading account" option enabled record everything > correctly or is it just the scenario mentioned in the bugreport? > > > Also, by enabling trading account in the 2020 file, I managed to precisely > account for the discrepancy in capital at end of year / beginning of year. > Should I close this amount to my Capital:EUR account or can I just carry it > forward in the trading account for 2021? I've tried entering a transaction > in the trading account but it was left unbalanced, so I gave up. > That's exactly the scenario discussed in bug 797796 except that the primary interlocutor's home currency is CAD rather than EUR. You need to create a capital gains transaction as explained in https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tracking Precious Metals
> On Apr 9, 2021, at 1:36 PM, Jack Frillman via gnucash-user > wrote: > > > What's the best way of tracking the value of your silver and gold holdings in > GNUCash? > > I guess I would have a Asset account but what do you when the process of an > oz. varies like a stock does? You treat it just like a stock. https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help with Gnucash 4.5 installation problem
> On Apr 8, 2021, at 3:22 AM, David Jaggar wrote: > > Hello to Whom this concerns: > I just installed Gnucash 4.5 (latest) on my Windows 10 computer. However, > it does not show up in the start menu and list of Windows installed > programmes. I have restarted the computer and reinstalled several times but > still cannot see Gnucash in the list of software programmes. What can I do > to start the programme? (I have IOBit Uninstaller installed and this > programme gave me a message onscreen that Gnucash 4.5 was installed after I > performed the installation.) > Is this a bug or can anyone offer some help? The installer has two checkboxes in the last frame to create shortcuts on the desktop and the start menu. Having unchecked both of them would explain why the shortcuts are there but not why GnuCash 4.5 doesn't appear in Settings>Apps & Features. Is the program installed where you told the installer to put it (the default is C:\Program Files (x86)\gnucash)? If it is you can launch it by navigating there in Windows File Explorer and double-clicking on bin\gnucash.exe. As long as that works you can create your own shortcut and put it wherever you like. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] asset discrepancy in change of year
> On Apr 10, 2021, at 9:24 AM, Andrea Borgia wrote: > > Il 09/04/21 18:59, John Ralls ha scritto: >>> On Apr 9, 2021, at 9:37 AM, Andrea Borgia wrote: >>> >>> Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam < >>> christopher@gmail.com> ha scritto: >>> >>> >>>> There is some discussion in an unusually detailed bug report >>>> https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in >>>> GnuCash's transaction currency being permitted to be any currency. e.g. if >>>> your home currency is USD, but transfer GBP to EUR, the UI will record only >>>> GBP/EUR fx. The new method would enforce the transaction currency to be USD >>>> therefore your GBP->EUR would require GBP/USD and EUR/USD fx rates. Thus, >>>> w.r.t. USD, all fx gains/losses are recorded accurately. >>>> >>>> To fix this would be an enormous amount of work and invalidate a lot of >>>> code, but would definitely simplify and fix a lot of code too IMHO. >>>> >>> Does it apply also to mutual funds purchased in a foreign currency? >>> For example,I operate in EUR, I change a given amount to USD and use it to >>> purchase a USD-denominated fund. >>> Will gnucash with the "trading account" option enabled record everything >>> correctly or is it just the scenario mentioned in the bugreport? >>> >>> >>> Also, by enabling trading account in the 2020 file, I managed to precisely >>> account for the discrepancy in capital at end of year / beginning of year. >>> Should I close this amount to my Capital:EUR account or can I just carry it >>> forward in the trading account for 2021? I've tried entering a transaction >>> in the trading account but it was left unbalanced, so I gave up. >>> >> That's exactly the scenario discussed in bug 797796 except that the primary >> interlocutor's home currency is CAD rather than EUR. >> >> You need to create a capital gains transaction as explained in >> https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html. > > Thanks, John. I suppose you're replying only to the question in the first > paragraph. > > > A few more questions: > > 1) is the "trading account" option (already enabled) compatible with such a > scenario? > > 2) am I correct that purchases and sales of a fund quoted in my primary > currency (EUR in my case) will be properly recorded simply by virtue of the > trading accounts being enabled and do not require an additional transaction? > > 3) the capital gain to be recorded for the USD funds: I'm not sure I > understand where this occurs, perhaps when I am selling the USD to pay for > the shares in the fund? > > > > It's quite frustrating that I seem to understand the general idea but then I > get lost in the details of the transactions to be entered! > > I've tried looking at those generated by the trading accounts but it didn't > really help :( 1) No, but that's separate from trading accounts. That's the point of the bug report. 2) No, the trading accounts just make it obvious that you haven't booked the gain/loss. 3) That's back to the discussion in the bug. When you trade securities in a foreign currency you have *two* sources of gains/losses: The gain or loss realized in the foreign currency from the sale of the security and the gain or loss from converting the foreign currency back into your home currency. Study that bug and the spreadsheets that CDB-Man has attached. The basic point that CDB-Man (an actual accountant licensed in Canada) makes is that every time you touch an asset denominated in something other than your home currency the change must be converted back to your home currency and the change in home currency value booked as a gain/loss. It's possible, but difficult, to do this in GnuCash. Trading Accounts don't really help. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Changing Currency in Price Data
> On Apr 10, 2021, at 6:25 AM, Ingo Planz wrote: > > Hi everyone, > > in my price data, the currency for one of the stocks has changed. It used to > be in EUR, which is also the default currency and reporting currency. Since > recently that stock price is stored in JPY. > I also do have the corresponding exchange rate in the price database as well. > > However, both the values computed for both the Accounts tab as well as > reports (method: nearest in time) ignore the newer JPY prices and use the > final EUR price. > > If I do delete all the EUR prices, it works as expected and computes values > by converting the JPY prices with the exchange rate. > > Am I missing something or am I doing it wrong? Can I change the currency in > the stock price data like this? GnuCash understands the currency in which the stock is priced to be the currency of the stock account's immediate parent, so you would create a parent account of type ASSET denominated in JPY and make that new account the stock account's parent. But why exactly did the stock's quote currency change? That's not a common occurrence. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] asset discrepancy in change of year
> On Apr 11, 2021, at 5:01 AM, Andrea Borgia wrote: > > Il 10/04/21 20:33, John Ralls ha scritto: > > >> 1) No, but that's separate from trading accounts. That's the point of the >> bug report. >> >> 2) No, the trading accounts just make it obvious that you haven't booked the >> gain/loss. >> >> 3) That's back to the discussion in the bug. When you trade securities in a >> foreign currency you have *two* sources of gains/losses: The gain or loss >> realized in the foreign currency from the sale of the security and the gain >> or loss from converting the foreign currency back into your home currency. >> Study that bug and the spreadsheets that CDB-Man has attached. The basic >> point that CDB-Man (an actual accountant licensed in Canada) makes is that >> every time you touch an asset denominated in something other than your home >> currency the change must be converted back to your home currency and the >> change in home currency value booked as a gain/loss. It's possible, but >> difficult, to do this in GnuCash. Trading Accounts don't really help. > > So, as an "executive summary" of sorts: I can't win and even a tie is out of > the question ;) > > > I'm trying to think how to handle it as simply as possible; I'll study the > bug report because I'd like to understand it but I'd rather avoid complicated > manual work to be carried out each time I buy or sell funds, because that > will happen seldom enough that I'd basically have to relearn the whole > process each time :( > > > Would keeping the books open, without "trading accounts", across years > actually help? I'd still be calculating a profit / loss by closing the income > / expense accounts, but that's all. Somehow I think this would just hide the > problem, though. > > Alternatively, I could keep "trading accounts" enabled, see how much > unrealized profit / loss I have for the year and factor in that when > calculating the initial capital for the following year. That's actually the > situation I am in right now: the discrepancy between initial capital in 2021 > and end capital of 2020 is precisely the amount listed by the trading > account, for both EUR and USD. The bug report documents a significant shortcoming in GnuCash's design. There's no simple workaround, only the manual work described in the bug report. Closing your book and starting a new file every year makes for additional work for tracking investments as you must re-create the buy transactions in the new file so that you can keep track of the basis and holding period. Aside from that there's no difference in booking realized gains/losses. You may be confusing "recognized gains" and "realized gains". A realized gain (or loss) is the change in value between a buy and a sell transaction. In contrast an unrealized gain is the change in the value of an asset that you still own. If you update prices in GnuCash then you can display the value of your assets at the latest price on the Accounts page and in various reports if you select "latest" as the price source. A recognized gain is a realized gain that you've correctly recorded with a pair of splits. A balance in a trading account indicates that you have unrecognized realized gains. Your statement about recalculating the initial capital each year suggests marking to market, that is creating a transaction that recognizes the unrealized gain at the end of the year, changing the basis of the stocks. That's generally required only of banks and investment companies and it has substantial tax consequences. You should do so only with the advice and guidance of a locally-licensed accountant or tax advisor. The problem described in the bug report is that even those trading account balances don't tell the whole story because they don't convert your USD realized gains to EUR and recognize the gain/loss on converting USD->EUR. As long as the amounts are small enough to not concern your tax authorities the discrepancy is somewhat academic, but if the amounts aren't small you should get professional advice about how to handle 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock Account Type Not Listed
> On Apr 11, 2021, at 8:07 PM, Steven Anter wrote: > > ver 4.5 > unable to change account type to stock. Stock account type not listed > among account types. Please help > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> > Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > On Sun, Apr 11, 2021 at 6:45 PM wrote: > >> Send gnucash-user mailing list submissions to >>gnucash-user@gnucash.org 1. Please do not reply to a thread when starting a new topic. Send a new email. 2. That goes double for digests. 3. When you want to reply to a thread in a digest quote only the one message you're replying to and change the subject back to the one you're replying to. You can't create accounts of type STOCK with a parent of type EQUITY, EXPENSE, or INCOME. For best results the parent should be of type ASSET and be denominated in the currency in which the stock is priced. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock Account Type Not Listed
That's weird. What happens if you set the parent to be "New top-level account"? What account types are visible when the parent is set to an ASSET account? What did the upgrade change the STOCK and MUTUAL FUND to? Regards, John Ralls > On Apr 12, 2021, at 4:06 PM, Steven Anter wrote: > > John, > I tried using ASSET, but STOCK was still unavailable as an option for > children of that account. Also, when I upgraded from 2.6 to 4.5, it changed > my account many of my account types which were originally setup as STOCK or > MUTUAL FUND > > On Mon, Apr 12, 2021 at 9:16 AM John Ralls wrote: > > > > On Apr 11, 2021, at 8:07 PM, Steven Anter wrote: > > > > ver 4.5 > > unable to change account type to stock. Stock account type not listed > > among account types. Please help > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> > > Virus-free. > > www.avast.com > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > > > On Sun, Apr 11, 2021 at 6:45 PM wrote: > > > >> Send gnucash-user mailing list submissions to > >>gnucash-user@gnucash.org > > 1. Please do not reply to a thread when starting a new topic. Send a new > email. > 2. That goes double for digests. > 3. When you want to reply to a thread in a digest quote only the one message > you're replying to and change the subject back to the one you're replying to. > > You can't create accounts of type STOCK with a parent of type EQUITY, > EXPENSE, or INCOME. For best results the parent should be of type ASSET and > be denominated in the currency in which the stock is priced. > > Regards, > John Ralls > > Virus-free. www.avast.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] asset discrepancy in change of year
> On Apr 17, 2021, at 8:01 AM, Andrea Borgia wrote: > > Il 11/04/21 18:41, John Ralls ha scritto: > > >> You may be confusing "recognized gains" and "realized gains". A realized >> gain (or loss) is the change in value between a buy and a sell transaction. >> In contrast an unrealized gain is the change in the value of an asset that >> you still own. If you update prices in GnuCash then you can display the >> value of your assets at the latest price on the Accounts page and in various >> reports if you select "latest" as the price source. A recognized gain is a >> realized gain that you've correctly recorded with a pair of splits. A >> balance in a trading account indicates that you have unrecognized realized >> gains. > > If I still hold all of the assets across year end, the trading account > balance is most definitely pointing to unrealized gains only; in this > context, what's the point in booking a split simply to recognize a gain which > is not even realized? > > Of course, the moment I sell some shares and hopefully make a profit I will > have to record it explicitly. > > But for the moment, that is for closing 2020, I think I'll use the trading > account balance as a quick shortcut :) My claim that a balance in a trading account indicates an unrealized gain is only true when the position has been completely closed and of course in that case the balance is in the home currency because in the simple case of conversions only to the home currency the other commodity is zeroed out and to balance it so will be the trading account. That simple case is well illustrated in https://www.mscs.dal.ca/~selinger/accounting/gnucash.html, which is the basis of the Trading Account design. Sticking with the simple case, when you buy 100 shares of XYZ @€10/share Trading:EUR has a balance of €1000 and Trading:XYZ has a balance of -100. The following year you sell the 100 shares for €12/share and Trading:XYZ has a balance of 0 and Trading:EUR has a balance of -€200, reflecting the realized capital gain. But if you sold only 50 shares Trading:XYZ would have a balance of -50 and Trading:EUR has a balance of €400. To find the capital gain you have to compute the basis of the remaining 50 shares and subtract it from the Trading:EUR balance. >> Your statement about recalculating the initial capital each year suggests >> marking to market, that is creating a transaction that recognizes the >> unrealized gain at the end of the year, changing the basis of the stocks. >> That's generally required only of banks and investment companies and it has >> substantial tax consequences. You should do so only with the advice and >> guidance of a locally-licensed accountant or tax advisor. > > AFAIK in my case it has basically no tax consequences because: > > 1) my employer acts as a tax proxy: whatever sum the ministry of finance has > to give back after tax declaration flows through them. > > 2) the bank handles taxes on capital gains: this actually happened to my > father, the CG tax was directly debited with the sale. So rather than getting you in trouble with the tax authorities the consequences would be in the time spent on figuring out why your numbers and theirs are different. > > > >> The problem described in the bug report is that even those trading account >> balances don't tell the whole story because they don't convert your USD >> realized gains to EUR and recognize the gain/loss on converting USD->EUR. As >> long as the amounts are small enough to not concern your tax authorities the >> discrepancy is somewhat academic, but if the amounts aren't small you should >> get professional advice about how to handle it. > > John, I appreciate your care in pointing out that I need professional > assistance tailored to my tax jurisdiction but, to the best of my knowledge, > how I record stuff in gnucash has no effect on my taxes: I don't get to > calculate those, only to record the amounts. Clearly, the moment this changes > I'll have to be more rigorous, just not now. > > > This whole discussion had an unexpected side effect: after years of working > with SAP (as a programmer) I finally understood why the accounting tables > have two separate amount fields, DMBTR (amount in document currency, saved in > another field) and WRBTR (amount in company currency). This way the exchange > rate for each transaction is implicitly recorded, allowing for proper > recognition of forex gains & losses. Interestingly the accountant who's driving the discussion of bug 797796 is an experienced SAP user and brings
Re: [GNC] asset discrepancy in change of year
> On Apr 20, 2021, at 2:51 PM, Andrea Borgia wrote: > > Il 17/04/21 19:47, John Ralls ha scritto: > > >> But if you sold only 50 shares Trading:XYZ would have a balance of -50 and >> Trading:EUR has a balance of €400. To find the capital gain you have to >> compute the basis of the remaining 50 shares and subtract it from the >> Trading:EUR balance. > > Yes, that's why I said "for closing 2020": I understood it was a special case > and I actually wrote to my future self a memo explaining why the year-end > closing is the way it is. > > For 2021, especially if a sale occurs, I'll try to record it properly. > > >> So rather than getting you in trouble with the tax authorities the >> consequences would be in the time spent on figuring out why your numbers and >> theirs are different. > > Why would that be the case? I have no way to calculate the tax amount from > within gnucash, I'm simply going to take what the bank debits and record it. > > > The one issue I have with the way the bank records costs (not taxes) is that > the fixed fee paid on purchase of a fund is lumped together with the > investment amount, so they have a slightly different share price from mine. > > I chose to record the expense the moment it is incurred, that is at purchase > time. > > I might as well follow their lead, if else to make my life easier still, but > this should be just a matter of preference, right? If you're just keeping memorandum books then it's all preference, eh? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] difficulties I am having
> On Apr 21, 2021, at 3:51 PM, Jay Bouxsein wrote: > > I have been using GNUCASH for several years to basically track income and > expenses for rental properties my wife and I own. I do not use it for any > other purposes, I enter all of our expenses and income and then produce a P > $ L report and send that to our accountant who keeps our historical books > and prepares our tax returns. Obviously I could use a spreadsheet as my > accountant suggested, but I really like your aids in completing the entry > process, the plus and minus feature, and typing just the first few > characters and so forth. > > In the past, we have done all of the data entry in March of the next > year and it goes fast because we do not have a lot of units (less than 10 ) > and limited suppliers (less than 30). My procedure is to call up the > program and it opens to a register automatically, displaying all of our > transactions from the previous year and all I need to do is update the date > of the first transaction which by default is the current date. For > example, the date displayed was April 21, 2021 and our first transaction > was for January 2, 2020. All was going well until we got to March of 2020 > when I could not find an expense account and tried to add a new expense > account and all hell broke loose. I could not get back to the account > register data entry screen we always used. Eventually I figured out that > the account that I thought was missing actually was not and what I had done > was to create a nearly duplicate account so I deleted the account that I > had just created and then I was able to get a screen that looked just like > the one we always had, but we noticed some differences. > > On our old register screen we used to have a column for deposits to our > checking account and checks written out of that account. Now our screen > shows "Expense" in the column which used to have "Deposit" and "rebate" has > been substituted for the check amount. That does not seem right to me. I > am 72 years old and actually was pretty good with the software which was > available back in the 70's, 80's & 90's but not so much any more. I have a > feeling that my problem should be a simple one to fix, but my weakness in > dealing with accounting software is holding me back. I should add that I > do have a hard copy of a "transction report, Income statement and P&L which > I have attached to this email in the hope it will give you enough > information to understand my missive. > > I thank you in advance for your attention to this matter. > IIUC the difference is in the column headings in a register view. If that's the case you're looking at an Expense (not Bank, which is what a checking account should be) account in Register2 view. That's hard to do: You have to start GnuCash with the --extra command-line option and open registers from the Extensions>Reg2>Open Account menu item. But you chose to illustrate the problem with transaction reports from 2018 and 2019 instead of a screen shot so I wonder if you really mean something else. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Command Line Args
> On Apr 22, 2021, at 2:30 PM, Derek Atkins wrote: > > That is very VERY odd. It works for me. I wonder if this is a Windows bug? Not odd at all, and not a bug in the sense that Microsoft did it on purpose [1]. Windows executables have a couple of bytes in their preambles that say what type they are. Console apps have stdin, stdout, and stderr and so they require a shell window of some sort (CMD and Powershell being the most common) and will open one for you if you launch them from Windows File Explorer. The others redirect the basic FDs to NULL and so they don't need a shell window. gnucash is a Windows program (no basic FDs) and gnucash-cli is a Console program (has basic FDs). Regards, John Ralls [1] https://answers.microsoft.com/en-us/ie/forum/ie11-iewindows_10/what-is-difference-between-console-application/f8bd3d4f-7c2c-4c86-a64b-41a046a38be4 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] difficulties I am having
"IIUC" means "if I understand correctly". No, Register2 is an attempt to rewrite of the register code to use GtkTreeView[1]. It didn't work out but its remains, er, remain. But I see that I'm wrong about that anyway, Expense and Rebate are the informal labels on the debit and credit columns for expense accounts on the regular register too. The screenshot is perfect. I'll guess that you've managed to change the account named "Expenses' from type Bank to Expense. Select Edit>Edit Account... from the menu and in the lower left of the dialog box that pops up see if you can select Bank, then click OK. That should put your column headings back. While you're at it I suggest that you change the account name (first line in the dialog box) to something more descriptive of a checking account, maybe "Business Checking" or "Bank Name Checking". Regards, John Ralls > On Apr 22, 2021, at 3:48 PM, Jay Bouxsein wrote: > > Dear John > > At the outset I would like to sincerely thank you and the other members who > have weighed in on my problem. I must admit that I am confused because of my > lack of technical understanding of the matters you guys have been discussing. > Firstly what does IICU mean? Is "Register 2 a technical term of art? > Secondly I illustrated the problem with transaction reports because they were > the easiest things I could attach. I am not so good at screenshots, links and > the like. Windows as an operating system has expanded so much that I really > have not been able to keep up with it. > > I think that I have attached a screenshot of the register which I have been > dealing with. What I really want, which is what you suggested, is our > checking account. I don't want to change the view, I want to open our > checking account in the standard Account Register view we have always had in > the past so we can add our new data. I just can't figure out how to do that. > I hope that you can forgive me. > > Kindest regards, > > Jay Bouxsein > > PS If you would like to speak with me to make life easier at your end, let > me know off list and I will be happy to provide you with my telephone number. > I live in the Chicago Metro area and am thus in the central daylight time > zone. > > > > On Thu, Apr 22, 2021, 11:34 AM John Ralls wrote: > > > > On Apr 21, 2021, at 3:51 PM, Jay Bouxsein wrote: > > > > I have been using GNUCASH for several years to basically track income and > > expenses for rental properties my wife and I own. I do not use it for any > > other purposes, I enter all of our expenses and income and then produce a P > > $ L report and send that to our accountant who keeps our historical books > > and prepares our tax returns. Obviously I could use a spreadsheet as my > > accountant suggested, but I really like your aids in completing the entry > > process, the plus and minus feature, and typing just the first few > > characters and so forth. > > > > In the past, we have done all of the data entry in March of the next > > year and it goes fast because we do not have a lot of units (less than 10 ) > > and limited suppliers (less than 30). My procedure is to call up the > > program and it opens to a register automatically, displaying all of our > > transactions from the previous year and all I need to do is update the date > > of the first transaction which by default is the current date. For > > example, the date displayed was April 21, 2021 and our first transaction > > was for January 2, 2020. All was going well until we got to March of 2020 > > when I could not find an expense account and tried to add a new expense > > account and all hell broke loose. I could not get back to the account > > register data entry screen we always used. Eventually I figured out that > > the account that I thought was missing actually was not and what I had done > > was to create a nearly duplicate account so I deleted the account that I > > had just created and then I was able to get a screen that looked just like > > the one we always had, but we noticed some differences. > > > > On our old register screen we used to have a column for deposits to our > > checking account and checks written out of that account. Now our screen > > shows "Expense" in the column which used to have "Deposit" and "rebate" has > > been substituted for the check amount. That does not seem right to me. I > > am 72 years old and actually was pretty good with the software which was > > available back in the 70's, 80's & 90's but not so much any mor
Re: [GNC] Command Line Args
Glenn, I know, and that's what Derek posted and what I added to the wiki page. Regards, John Ralls > On Apr 22, 2021, at 4:35 PM, Glenn Fowler wrote: > > Hi John, I was referring to gnucash command line switches, not gnucash-cli > command line switches as you mentioned earlier starting GnuCash with --extra > earlier in the post. > > On Thu, Apr 22, 2021 at 6:42 PM John Ralls wrote: > I've just added the current output of `gnucash --help` to > https://wiki.gnucash.org/wiki/Logging#Command_Line_Options. It's the same as > Derek posted. > > Regards, > John Ralls > > > > On Apr 22, 2021, at 3:25 PM, Glenn Fowler wrote: > > > > Thank you, in that case is there documentation on the command line switches? > > > > On Thu, Apr 22, 2021 at 6:06 PM John Ralls wrote: > > > > > > > On Apr 22, 2021, at 2:30 PM, Derek Atkins wrote: > > > > > > That is very VERY odd. It works for me. I wonder if this is a Windows > > > bug? > > > > Not odd at all, and not a bug in the sense that Microsoft did it on purpose > > [1]. Windows executables have a couple of bytes in their preambles that say > > what type they are. Console apps have stdin, stdout, and stderr and so they > > require a shell window of some sort (CMD and Powershell being the most > > common) and will open one for you if you launch them from Windows File > > Explorer. The others redirect the basic FDs to NULL and so they don't need > > a shell window. gnucash is a Windows program (no basic FDs) and gnucash-cli > > is a Console program (has basic FDs). > > > > Regards, > > John Ralls > > > > [1] > > https://answers.microsoft.com/en-us/ie/forum/ie11-iewindows_10/what-is-difference-between-console-application/f8bd3d4f-7c2c-4c86-a64b-41a046a38be4 > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] difficulties I am having
That's not what I hoped to see. It looks like instead of changing the type of the checking account you deleted it and told GnuCash to move all of its transactions to Expenses. It's possible to fix this but it will be a little tedious. If you have a backup from before all of this happened (see https://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F if you don't know about GnuCash's automatic backups) then you can just quit GnuCash without saving, rename the backup to the working name, and start over. Otherwise you'll need to: 1. Leave the current Expenses account as type Expense but rename it to Checking. 2. Make a new top level expenses account 3. Edit each direct child account of Checking and change its parent to Expenses. 4. When Checking has no more children edit it, change its type to Bank, and change its parent to Assets:Current Assets. Regards, John Ralls > On Apr 22, 2021, at 5:21 PM, Jay Bouxsein wrote: > > Thanks so much for such a prompt reply. I have attached a couple of photos of > the screens that I have up on my computer right now which should answer your > question and give you more understanding about the way my system is set up. > > I thank you again for all your help. > > Jay BOUXSEIN > > > On Thu, Apr 22, 2021, 7:09 PM John Ralls wrote: > Whether you want to change the children depends on how you've structured your > accounts. What are the children? > > Regards, > John Ralls > > > On Apr 22, 2021, at 5:04 PM, Jay Bouxsein wrote: > > > > Thanks so much. I am at the computer right now and made the change you > > recommended in the lower left hand corner of the edit account screen to > > bank. I pressed OK and got a pop-up screen that says "give the children the > > same type ?" And wonder whether I should accept this change. I'm going to > > try to give you a screenshot of what I'm looking at right now. > > > > No go on the screenshot I can't figure out how to do it from my phone which > > is what I am using to send this email. > > > > If you can answer based on the earlier paragraphs in this email please do > > so and I'll hit okay and if it doesn't work out well I can get back to you. > > > > Many thanks > > > > Jay > > > > On Thu, Apr 22, 2021, 6:13 PM John Ralls wrote: > > "IIUC" means "if I understand correctly". > > > > No, Register2 is an attempt to rewrite of the register code to use > > GtkTreeView[1]. It didn't work out but its remains, er, remain. > > But I see that I'm wrong about that anyway, Expense and Rebate are the > > informal labels on the debit and credit columns for expense accounts on the > > regular register too. > > > > The screenshot is perfect. I'll guess that you've managed to change the > > account named "Expenses' from type Bank to Expense. Select Edit>Edit > > Account... from the menu and in the lower left of the dialog box that pops > > up see if you can select Bank, then click OK. That should put your column > > headings back. While you're at it I suggest that you change the account > > name (first line in the dialog box) to something more descriptive of a > > checking account, maybe "Business Checking" or "Bank Name Checking". > > > > Regards, > > John Ralls > > > > > On Apr 22, 2021, at 3:48 PM, Jay Bouxsein wrote: > > > > > > Dear John > > > > > > At the outset I would like to sincerely thank you and the other members > > > who have weighed in on my problem. I must admit that I am confused > > > because of my lack of technical understanding of the matters you guys > > > have been discussing. Firstly what does IICU mean? Is "Register 2 a > > > technical term of art? Secondly I illustrated the problem with > > > transaction reports because they were the easiest things I could attach. > > > I am not so good at screenshots, links and the like. Windows as an > > > operating system has expanded so much that I really have not been able to > > > keep up with it. > > > > > > I think that I have attached a screenshot of the register which I have > > > been dealing with. What I really want, which is what you suggested, is > > > our checking account. I don't want to change the view, I want to open our > > > checking account in the standard Account Register view we have always had > > > in the past so we can add our new data. I just can't figure o
