Re: [GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

2020-09-22 Thread John Ralls
Looks like it's https://bugs.gnucash.org/show_bug.cgi?id=797514. Regards, John Ralls > On Sep 22, 2020, at 2:29 PM, Adrien Monteleone > wrote: > > Want a bug filed or is there one already? > > Regards, > Adrien > > On 9/22/20 4:26 PM, John Ralls wrote: >>

Re: [GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

2020-09-22 Thread John Ralls
also able to reproduce it on 4.0, 3.11, and 3.10 on Windows. It's been around for a while. Regards, John Ralls > On Sep 22, 2020, at 1:45 PM, Adrien Monteleone > wrote: > > I can confirm the same behavior on MacOS. > > (however, which field do you mean by: "The only

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread John Ralls
SQLite3 is incredibly widely used so it's already on just about everything except Windows. libdbi and libdbd-sqlite are tiny, less than 100K for both. Regards, John Ralls > On Sep 21, 2020, at 11:15 AM, Adrien Monteleone > wrote: > > The disadvantage would be for those users wh

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread John Ralls
ct which transactions based on the entered string or regular expression [1] matching the transaction description or notes, or a split memo. Regards, John Ralls [1] https://en.wikipedia.org/wiki/Regular_expression ___ gnucash-user mailing list gn

Re: [GNC] Standard chart of accounts?

2020-09-21 Thread John Ralls
ning-gnucash.html#basics-acct-hierarchy. 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 Nab

Re: [GNC] Error with Advanced portfolio report

2020-09-19 Thread John Ralls
ere and > while the first one got a reply from the dev team, the report one seemed > ignored. > > I am still on 3.11, hopefully 4.2 will allow me to move forward. Any idea > what's the ATA for the new release? https://wiki.gnucash.org/wiki/Release

Re: [GNC] Error with Advanced portfolio report

2020-09-19 Thread John Ralls
eports after that will indeed get no attention from the dev team as none will be necessary. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash

Re: [GNC] OFX log location

2020-09-17 Thread John Ralls
structure is replaced. It's a way to set environment variables so that they apply only to GnuCash and are loaded without reference to the shell resource files like .bash_profile, very convenient for all desktop launchers that don't read the shell resource files. Regards, John Ralls > On

Re: [GNC] SQLite File crashes Gnucash on opening after upgrade to 4.1 on Macos

2020-09-17 Thread John Ralls
likely a damaged file since there weren't any SQL backend changes between 4.0 and 4.1. Please open a bug report and attach the crash report from Console. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub

Re: [GNC] Banner Bank - OFX setup question

2020-09-16 Thread John Ralls
ok for other things that might affect those messages like the bank URL. Yes, the sandbox might be blocking writing the ofx log. Try specifying a full path as David suggested. On the other hand if it's not connecting to the server there won't be any ofx messages to log, so maybe you should tes

Re: [GNC] Banner Bank - OFX setup question

2020-09-16 Thread John Ralls
ps://docs.flatpak.org/en/latest/sandbox-permissions.html might be helpful. 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 I

Re: [GNC] Currency exchange rates inconsistencies for invoices

2020-09-16 Thread John Ralls
that i don't need an average, but the exact price on the exact > date. > There's a very long discussion on this topic in https://bugs.gnucash.org/show_bug.cgi?id=797796. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To upd

Re: [GNC] Negative numbers

2020-09-12 Thread John Ralls
he code away > for free and charge for maintenance > There is no "pony up". GnuCash is a *gift* of tens of thousands of hours work by a few dozen *unpaid* individuals over 20 years. All of the people on this list who have helped you are also unpaid volunteers. All of the infrastructur

Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread John Ralls
at are $HOME/Library/Application Support/Gnucash/gtk-3.0.css and $HOME/Library/Application Support/Gnucash/config/gtk-3.0/gtk.css Note that your attempt to use that last path isn't right because you named the file gtk-3.0.css. Regards, John Ralls > On Sep 11, 2020, at 7:29 PM, John Ralls wr

Re: [GNC] Location of gtk css file on MacOS

2020-09-11 Thread John Ralls
Will, No, macOS since 10.11 won't let a program from one app bundle look at anything in another one. That's why the old Update Finance Quote applet stopped working. Regards, John Ralls > On Sep 11, 2020, at 2:50 PM, w...@theprescotts.com wrote: > > John, > > I'm ju

Re: [GNC] Finance quote troubleshooting

2020-09-11 Thread John Ralls
\Examples\stockdump.pl alphavantage CSCO to make sure that you can successfully query alphavantage. Regards, John Ralls > On Sep 9, 2020, at 10:27 PM, Andreas Vyrides wrote: > > Dear Mr Ralls, > > Thank you for your prompt response > > Yes I have been through both gn

Re: [GNC] I'm still a bit confused about when things get saved.

2020-09-10 Thread John Ralls
Tried that with GnuCash? It isn't a macOS native app and probably doesn't benefit from those features. I'd go for the UPS, but since recent financial activity is generally pretty easy to recover and re-enter maybe the risk/payback works out differently for you. Regards, John Ralls > On Sep

Re: [GNC] Can't input alphabet under Windows 10 (Japanese)

2020-09-10 Thread John Ralls
. Today's nightly, https://code.gnucash.org/builds/win32/maint/gnucash-4.1-2020-09-10-git-4.1-125-g15f3faf04+.setup.exe, is built with Gtk-3.24.23. Please test and update the bug with whether it did fix the problem. Regards, John Ralls ___ gnuca

Re: [GNC] Finance quote troubleshooting

2020-09-09 Thread John Ralls
rrently using F::Q v1.49, and gnucash v4.1 > > Thank you for your time and all your support Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in particular https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Regards, John Ralls _

Re: [GNC] Gnc 4.1 Make Fail - MX-LINUX (Debian Buster)

2020-09-04 Thread John Ralls
you're using so we can't really help you with the details of rolling back ICU to version 63; another reason for ensuring that you copy the list is that there are others there who know more than I do about the details of managing any of them. Regards, John Ralls > On Sep 4, 2020, at 9:30

Re: [GNC] Gnc 4.1 Make Fail - MX-LINUX (Debian Buster)

2020-09-03 Thread John Ralls
ake sure that you didn't pin the boost version; if you did either remove the pin or roll ICU back to ICU63 and pin it too. If not then the Boost packager for your distro needs a kick to get a recompiled package linked with the right ICU version. Regards, John Ralls ___

Re: [GNC] Crash attempting to import transactions from CSV on W10

2020-09-01 Thread John Ralls
few volunteers and while we like to know about every crasher (especially new ones in nightly builds) we have nowhere near enough time to respond in detail to every report. Regards, John Ralls > On Sep 1, 2020, at 7:40 PM, David H wrote: > > Hi Arthur, > > You sent it to

Re: [GNC] Location of gtk css file on MacOS

2020-09-01 Thread John Ralls
a leftover somewhere overriding the one you want to use. Regards, John Ralls > On Sep 1, 2020, at 7:33 PM, David H wrote: > > Will, > > The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css > that you said also existed only exists as an empty folder on my system ???

Re: [GNC] How do I add notes to my columns?

2020-08-30 Thread John Ralls
See https://wiki.gnucash.org/wiki/Development#Submitting_Patches. Regards, John Ralls > On Aug 29, 2020, at 8:45 PM, azalea4va wrote: > The code is already developed. I have been using it for 3 years. For > production use it would need production testing and I would be willing

Re: [GNC] GNUcash crashes on autocomplete

2020-08-28 Thread John Ralls
lated issues. I hope to have those resolved in time for 4.3 at the end of September. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/li

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread John Ralls
rshell it didn't work, but did without it. This morning it works both ways. The actual fail was my copy and paste lost the trailing quote mark. The >> Samantha got was powershell asking for it. Yes, it works fine with GBP/EUR: * 09:29:36 WARN [gnc_numeric_to_decimal()] Rounding required when 'neveround' s

Re: [GNC] Old-New user with an upgrade problem: GTK CSS issue

2020-08-25 Thread John Ralls
By default gtk.css will be in $HOME/.config/gtk-3.0/ Regards, John Ralls > On Aug 25, 2020, at 7:29 AM, John Angelico wrote: > > Thanks for the clue, Frank. > > I am not sure if I have that set. > > However, where is gtk supposed to be in a Debian system? I can see >

Re: [GNC] Difficulty with online price retrieval

2020-08-24 Thread John Ralls
x86)\gnucash\bin\gnc-fq-helper Should produce something like (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") (last . #e0.7658) (currency . "GBP"))) Regards, John Ralls > On Aug 24, 2020, at 3:16 AM, Samantha Payn > wrote: >

Re: [GNC] FSFE into Berlin bunker

2020-08-21 Thread John Ralls
GTI, What has this or the debian.community/fsfellowship.eu conspiracy theory to do with GnuCash? Regards, John Ralls > On Aug 21, 2020, at 7:02 AM, GTI .H wrote: > > -- Forwarded message - > De: Debian Community News Team > Date: qui., 20 de ago. de 2020 às

Re: [GNC] Help files missing Was: Re: (no subject)

2020-08-18 Thread John Ralls
Dang. OK, I know what step I missed and I double checked to make sure they're there this time. Gnucash-Intel-4.1-4.dmg, sha256: 9c3685e79027d12b370e9fa79a569f7c532968be91ecfd3b81660d39abe50ab3 Regards, John Ralls > On Aug 18, 2020, at 6:16 PM, Frederick Bambrough > wrote: > >

Re: [GNC] mysql gnucash

2020-08-18 Thread John Ralls
In the alias there *should* be a space in 'local host' to keep the OS from mistaking it for the hardcoded 'localhost' in the networking code. Regards, John Ralls > On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote: > > Probably should not be a space in &

Re: [GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-18 Thread John Ralls
stigate graphics and see if the adapter is "not claimed" or > something else is weird. > > Regards, > Adrien > > On 8/18/20 3:43 PM, John Ralls wrote: >> Never mind the patch, I mis-interpreted the code. It's not that the cursor >> shouldn't be NULL: NULL i

Re: [GNC] Help files missing Was: Re: (no subject)

2020-08-18 Thread John Ralls
Thanks for noticing. I've fixed that and uploaded a new dmg, who's sha256 is 44117d2a0d86f7be6015c47441bdab373c835e6adcf646911a8d93dcc8babb67. Regards, John Ralls > On Aug 18, 2020, at 2:49 PM, Frederick Bambrough > wrote: > > In message I wrote: > >> The 'GnuCash Gui

Re: [GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-18 Thread John Ralls
be possible. Regards, John Ralls > On Aug 18, 2020, at 1:19 PM, John Ralls wrote: > > Two mistakes: When you start gdb you tell it the executable to run. > Everything you add to the run command is passed as an argument to that > executable and environment variables aren't arguments GnuC

Re: [GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-18 Thread John Ralls
cursor); + gdk_window_set_cursor (win, cursor); if (update_now && type != GNC_CURSOR_NORMAL) But it would be nicer to have a fallback for when the theme doesn't define GDK_WATCH. Regards, John Ralls > On Aug 18, 2020, at 11:33 AM, Adrien Monteleone > wrote: > > What I

Re: [GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-18 Thread John Ralls
/Stack_Trace. Regards, John Ralls > On Aug 17, 2020, at 10:14 PM, Adrien Monteleone > wrote: > > That didn't get very far. Not sure if this is a GnuCash bug, or an Inspector > bug: > > ``` > mint@mint:~$ GTK_DEBUG=interactive /usr/bin/gnucash > Found Finance::Quote ver

Re: [GNC] help increasing size of font in GnuCash?

2020-08-18 Thread John Ralls
updating to the documentation. Sadly another characteristic of developers is that we'd generally prefer to spend our time writing code than documentation so there are lots of holes in the documentation and lots of obsolete stuff as well. Regards, John Ralls > On Aug 18, 2020, at 4:13 AM, Pe

Re: [GNC] help increasing size of font in GnuCash?

2020-08-17 Thread John Ralls
as XDG_CONFIG_HOME, most of which are for backward compatibility: ~/.gtk-3.0.css, ~/.gtk-3.0/gtk.css, and ~/.config/gtk-3.0/gtk.css, ~/.gtk-3.0/setting.ini, ~/.config/gtk-3.0/settings.ini. Regards, John Ralls > On Aug 17, 2020, at 11:56 AM, Adrien Monteleone > wrote: > > Peter,

Re: [GNC] help increasing size of font in GnuCash?

2020-08-17 Thread John Ralls
k.css. > > I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, > in spite of the wiki. >> >> The location should be: >> >> ~/Library/Application Support/GnuCash > Where does the wiki say that one can use ~/.local/share for anything

Re: [GNC] help increasing size of font in GnuCash?

2020-08-16 Thread John Ralls
your home one is selected. Regards, John Ralls > On Aug 16, 2020, at 3:53 PM, David Reiser via gnucash-user > wrote: > > That’s the wrong library folder. There’s another one in /Users/[your user > name]/Library. > > Dave > -- > Dave Reiser > dbrei...@icloud.c

Re: [GNC] Finance::Quote stock code with ampersand

2020-08-16 Thread John Ralls
<=/ timezone: <=== optional and echo '(yahoo_json "M%26M.NS")' | gnc-fq-helper (("M%26M.NS" (symbol . "M%26M.NS") (gnc:time-no-zone . "2020-08-14 12:00:00") (last . #e614.45) (currency . "INR"))) I tried it in Gn

Re: [GNC] Difficulty with online price retrieval

2020-08-15 Thread John Ralls
ste them into a reply. Regards, John Ralls > On Aug 15, 2020, at 6:42 AM, Samantha Payn > wrote: > > I am sorry John, do what? > I am afraid I just do not understand "Please run from the PowerShell command > line with the --log gnc.scm=debug option as before, try both a

Re: [GNC] Help with mult-currency multi-split import

2020-08-15 Thread John Ralls
Gio, Can you fake up a CSV and gnucash file to demonstrate the problem? You could attach them to a bug report. Regards, John Ralls > On Aug 14, 2020, at 11:16 PM, Gio Bacareza wrote: > > Thanks John. That's really weird because I swear the csv contains a 2nd > transaction t

Re: [GNC] Help with mult-currency multi-split import

2020-08-14 Thread John Ralls
t 3 in PHP,56286.85,0,,note- conversion price stored in gnucash is is > 33.54241157. That is the same price I use to pre-convert. So > 1678.08*33.54241157 = 56286.85 > BZZZT! That's not what your first screen shot says. It says the second transaction is Account 1 DR AUD 1468.00, Accoun

Re: [GNC] Stock split assistant fail

2020-08-13 Thread John Ralls
created (that I have found). Is this a known > problem or is it just me? > I just booked (maybe a little ahead of time) the AAPL split and it worked fine. Must be you. ;-) What did you put in the Shares box? Regards, John Ralls ___ gnucash-user mailing list g

Re: [GNC] Help with mult-currency multi-split import

2020-08-13 Thread John Ralls
is to specify a price in multi-commodity imports, but I'm not as familiar with the csv importer as I should be so I can't say authoritatively that it will work. Regards, John Ralls > On Aug 13, 2020, at 4:16 AM, Gio Bacareza wrote: > > I maintain multi-currency accounts. I rely on mon

Re: [GNC] Difficulty with online price retrieval

2020-08-12 Thread John Ralls
Samantha, OK. Please do it when running GnuCash from Powershell with the --log gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log. Regards, John Ralls > On Aug 12, 2020, at 6:54 AM, Samantha Payn > wrote: > > John, I am so sorry, I have slightl

Re: [GNC] Difficulty with online price retrieval

2020-08-11 Thread John Ralls
R.) Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file. Regards, John Ralls > On Aug 11, 2020, at 5:00 AM, Samantha Payn > wrote: > > I'm afraid the problem

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread John Ralls
Good. It succeeded in finding Finance::Quote from the command line. That should be sufficient to enable the Fetch Rate button. Was it enabled? Regards, John Ralls > On Aug 10, 2020, at 12:06 PM, Samantha Payn > wrote: > > Hi John > I did what you suggest and this is what I

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread John Ralls
is case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020 > 11:46 Samantha, Specifically, run Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log and paste the results into a reply. Regards, John Ralls ___ gnucash-user ma

Re: [GNC] reconcile in 4.1

2020-08-09 Thread John Ralls
't obtain the lock" dialog box. Regards, John Ralls > On Aug 9, 2020, at 8:28 PM, Chris Tsuji wrote: > > John > Just a personal checking account > chris > > Sent: Sunday, August 09, 2020 at 8:25 PM > From: "John Ralls" > To: "Chris Tsuji"

Re: [GNC] reconcile in 4.1

2020-08-09 Thread John Ralls
> On Aug 9, 2020, at 4:28 PM, Chris Tsuji wrote: > > Hi > I just upgraded to 4.1 and want to reconcile my accounts. > the item is grayed out? > What happen? Are you trying to reconcile sub accounts with different currencies/commodities? R

Re: [GNC] GnuCash and Swedish accounting legislation

2020-08-09 Thread John Ralls
> On Aug 9, 2020, at 3:59 PM, Stan Brown wrote: > > > On 2020-08-09 11:58, John Ralls wrote: > >>> On Aug 9, 2020, at 11:04 AM, Stan Brown wrote: >>> You probably know this, but just on the off chance that you don't: >>> >>> In th

Re: [GNC] GnuCash and Swedish accounting legislation

2020-08-09 Thread John Ralls
; it's better than nothing. Really? ISTM that would be painful to use because you'd have to frequently change the date. I could understand if you wanted to be able to set a period selector, e.g. all transactions before the beginning of the current month are read-only. Regards, John Ralls __

Re: [GNC] GnuCash and Swedish accounting legislation

2020-08-09 Thread John Ralls
sactions afterwards). > > Here is the last post in the old thread from 2016: > > --- > On 2 February 2016 at 15:39, John Ralls > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> wrote: >> >>> On Feb 2, 2016, at 8:17 AM, Colin Law >

Re: [GNC] Difficulty with online price retrieval

2020-08-08 Thread John Ralls
Sort-Object -Property Date and display it (substitute the most recent file name from your listing) Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.RSHPO0.log Regards, John Ralls > On Aug 8, 2020, at 6:00 AM, Samantha Payn > wrote: > > John, thank you for these correction

Re: [GNC] Help with AqBanking Wizzard after accounts list retrieval

2020-08-07 Thread John Ralls
lines. Is that a problem? This is a bug, we think in AQBanking. I've documented the work-around and what to do if it fails on https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@

Re: [GNC] Windows 10 Installation Drive/Folder

2020-08-07 Thread John Ralls
> On Aug 7, 2020, at 11:38 AM, Rajbal Balan wrote: > > Hello! > > Is it possible to specify a different drive/folder (e.g. D:\Applications) and > override the default C: drive to install GnuCash on Windows 10? Yes. It's one of the first panels in the setup wizard. R

Re: [GNC] WikiOFX direct page Broken link AqB-getaccountsuccess.png

2020-08-07 Thread John Ralls
qB-getaccountsuccess.png on that > page. > Thanks for the report. We've uploaded a new screenshot to replace it. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: htt

Re: [GNC] Recently Opened list not updated until Gnucash restarted

2020-08-07 Thread John Ralls
Michael, That seems to be new (mis)behavior in 4.1. I noticed the same thing yesterday as I went through my monthly reconciles: The MRU list in the file menu didn't update at all until I quit and restarted GnuCash. Regards, John Ralls > On Aug 7, 2020, at 1:48 AM, Michael Hendry wr

Re: [GNC] Version 4.1 - Check & Repair problem and segfault on close GnuCash

2020-08-07 Thread John Ralls
Michael, Yes, please do file a bug report. Regards, John Ralls > On Aug 6, 2020, at 11:41 PM, Michael Hendry wrote: > >> On 7 Aug 2020, at 05:05, John Ralls wrote: >> >> To be sure I understand, it crashed after you told GnuCash to quit. How did >> you do

Re: [GNC] Difficulty with online price retrieval

2020-08-07 Thread John Ralls
t; and sea green (after the lime green text) or white at the start of each line. > > In CMD window: > C:\Users\User>cd C:\Program Files (x86)\gnucash\bin > C:\Program Files (x86)\gnucash\bin>set ALPHAVANTAGE_API_KEY > The syntax of the command is incorrect. Sorry, that should

Re: [GNC] Version 4.1 - Check & Repair problem and segfault on close GnuCash

2020-08-06 Thread John Ralls
tor, select Gnucash, and run a spin dump from the gear menu. Attach it to a bug report. You might run with --debug and attach the resulting trace file as well. Regards, John Ralls > On Aug 6, 2020, at 9:46 AM, Michael Hendry wrote: > > I’ve just installed version 4.1, and opened each of

Re: [GNC] Difficulty with online price retrieval

2020-08-06 Thread John Ralls
are part of the substitution. Regards, John Ralls > On Aug 5, 2020, at 2:17 AM, Samantha Payn > wrote: > > Hi John > Sorry for my lengthy silence. I have attempted to follow your instructions > but so far without success. > This is as far as I have got: > C:\Pro

Re: [GNC] Matcher for qfx files

2020-08-03 Thread John Ralls
Dale, ISTR a commit from last fall by Mike Alexander addressing exactly this issue, though I cannot now find it. Try GnuCash 3.9 or later. Regards, John Ralls > On Aug 3, 2020, at 12:23 PM, Dale Alspach wrote: > > The first stage of the import does not appear to be using

Re: [GNC] non-currency liabilities

2020-08-02 Thread John Ralls
ith an equal negative balance. However, if what you're modeling is your kid's college fund it would be more correct to create a separate book for it, particularly if it's a tax-advantaged fund like a US 529 fund or a court-supervised entity like a trust or guardianship. Regards, John Ralls _

Re: [GNC] Can't find file

2020-07-31 Thread John Ralls
Will, /Applications/Gnucash.app/Contents/MacOS/Gnucash --nofile & works just fine here. Repeat as many times as you have files you want to open, and you may substitute the path to a gnucash file for --nofile. Regards, John Ralls > On Jul 31, 2020, at 11:14 AM, w...@theprescotts.co

Re: [GNC] Can't find file

2020-07-31 Thread John Ralls
macOS does not, and one must use the command line to launch subsequent instances of gnucash. Regards, John Ralls > On Jul 31, 2020, at 3:50 AM, Frank H. Ellenberger > wrote: > > You can avod the warning by starting all except the first with > gnucash --nofile > or explici

Re: [GNC] Charles Schwab investment accounts and OFX

2020-07-28 Thread John Ralls
cified by the remaining error codes. > Unlocking customer "" According to https://microsoftmoneyoffline.wordpress.com/money-ofx-error-codes-messages/ it means something was wrong with the account number passed to the server. Try again with AQOFX_LOG_COMM=1 (see https://wiki.gnu

Re: [GNC] Import Transaction Matcher issue in v4

2020-07-27 Thread John Ralls
ement download applications, where every transaction (not just those that are client-originated or serveroriginated) requires a unique ID." Regards, John Ralls > On Jul 27, 2020, at 2:20 PM, Christopher Lam > wrote: > > As I understand the ofx spec*, the fitid

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread John Ralls
cd 'C:\Program Files\' You can then backspace out the \', type a space and again and it will fill in the (x86)\' for you. Regards, John Ralls > On Jul 27, 2020, at 12:01 PM, Samantha Payn > wrote: > > Sorry John (and everyone). I can't get it to accept (x86) now: > > C

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread John Ralls
Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP The Powershell terminal color-codes errors in red on black, variables and special values (e.g. $true, $false) in green, and command names in yellow. Regards, John Ralls > On Jul 27, 2020, at 2:30 AM, Samantha Payn > wrote: > >

Re: [GNC] $0 total balances wrongly appearing on Balance Sheet.

2020-07-27 Thread John Ralls
I'd go for the second. Account balances are on amounts (i.e. shares if that's what the account commodity is) and AFAIK nothing in the account code looks at split values. Regards, John Ralls > On Jul 27, 2020, at 10:24 AM, David Carlson > wrote: > > I am curious. Is

Re: [GNC] Postgres SSL Solution?

2020-07-27 Thread John Ralls
GnuCash itself doesn't have SSL support, so there is indeed no clear way to do it. You might be able to set up a proxy of some sort. Regards, John Ralls > On Jul 26, 2020, at 12:25 PM, Gregory Patricoski > wrote: > > Hey team, > > I am using a postgres database for

Re: [GNC] Import Transaction Matcher issue in v4

2020-07-26 Thread John Ralls
If there's no matching transaction already in the account then there's nothing to clear. In that case only adding or not makes sense. Regards, John Ralls > On Jul 26, 2020, at 1:56 PM, Fross, Michael wrote: > > Hello all, > > I sent this earlier this month and didn't see

[GNC] GnuCash 4.1 Released

2020-07-26 Thread John Ralls
The GnuCash development team announces GnuCash 4.1, the second release in the stable 4.x series Between 4.0 and 4.1, the following bugfixes were accomplished: • Bug 775582 - Change "Petrol" (or Gas if seen in USA) to "Fuel" • Bug 797759 - Some transactions are not highlighted in

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-26 Thread John Ralls
r three cases of embezzlement a year where it's obvious that a two-person control would have prevented the crime. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists

Re: [GNC] Sales Ledger Account Is Blank

2020-07-25 Thread John Ralls
ctual transactions are in the three sub accounts. You can get a consolidated view by right-clicking and picking Open SubAccounts from the context menu. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread John Ralls
Powershell. I don't think that there is a Poweshell, please excuse my hasty typing. Since you use only those 3 currencies try all three combinations, i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. Regards, John Ralls > On Jul 25, 2020, at 10:27 AM, Samantha Payn > wr

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-25 Thread John Ralls
it would be very much to your advantage to have followed the rules. Regards, John Ralls [1] R.F. Salmonson, James Don Edwards, Roger H. Hermanson; A Survey of Basic Accounting, Fourth Edition; Richard D. Irwin, Inc., Homewood IL; 1985; ISBN 0-256-03203-3; p144ff > On Jul 25, 2020, at 11:02

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-25 Thread John Ralls
r own or hire someone to do so; any distribution would be subject to the GPL, but someone who writes a module for their own use is under no obligation to share it. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread John Ralls
? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls > On Jul 25, 2020, at 5:22 AM, Samantha Payn > wrote: > > Thank you for your help John. > I have done as you instruct (including restarting Gnucash after the install) > but there is no

Re: [GNC] Difficulty with online price retrieval

2020-07-24 Thread John Ralls
PI key in my gnucash > preferences. > I have checked for the presence of the perl software using the > Troubleshooting method John Ralls directed me to and received the > response that I should install the Finance::Quote. The only way I have > done this in the past is by clicki

Re: [GNC] Online Quotes

2020-07-23 Thread John Ralls
financial > managing needs, but at this point I find it quite cumbersombe. Neither GnuCash nor Finance::Quote can magic up a response for a query that the website doesn't understand. Both of those queries on the respective websites produce "not found" errors. That aside, GnuCash is an

Re: [GNC] Balances on Accounts Page

2020-07-19 Thread John Ralls
accompanying ERD helpful. No, balances aren't stored, but you should be able to write a query that will calculate them. Just beware that the amount denominators aren't necessarily all the same. Regards, John Ralls ___ gnucash-user mailing list

Re: [GNC] Bug in account selection section of register

2020-07-19 Thread John Ralls
to select an item from the drop down. Whatever is selected will be put in the entry when you tab out. The backspace problem is probably https://bugs.gnucash.org/show_bug.cgi?id=797845 that I fixed a few minutes ago. Regards, John Ralls ___ gnuca

Re: [GNC] Database Manipulation

2020-07-18 Thread John Ralls
Please remember to copy the list on all replies. The only supported way to access and especially modify data is using the GnuCash API; in addition to C we provide Scheme and Python bindings that are a bit friendlier for scripting. Regards, John Ralls > On Jul 18, 2020, at 7:01 PM,

Re: [GNC] Database Manipulation

2020-07-18 Thread John Ralls
--and of course that will be recursive. Note that GnuCash doesn't set any relations in the database so you won't be able to use the usual referential integrity tools. Regards, John Ralls > On Jul 18, 2020, at 2:47 PM, Jon Griffith wrote: > > If I'm in the middle of creating an invoi

Re: [GNC] Unhide column

2020-07-18 Thread John Ralls
esize this column please, so that I can see what it is. I might > not want it even when I have resized it, but I'd like to see what it is. You actually do want that column to remain hidden. It's for GnuCash's internal use. Regards, John Ralls ___ gnucash-u

Re: [GNC] Check printing via the command line?

2020-07-17 Thread John Ralls
the printing functions are internal to dialog-print-check so there's no way for you to script them or even call them from another C program. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription pref

Re: [GNC] Difficulty with online price retrieval (John Ralls)

2020-07-16 Thread John Ralls
currency, so the only thing you'd affect by clearing the pricedb is reports on past dates, especially time series reports. You may also enter prices manually as a temporary measure until you get online quotes working properly. Regards, John Ralls > On Jul 16, 2020, at 5:08 AM, Samantha P

Re: [GNC] Get Online Quotes

2020-07-16 Thread John Ralls
#Trouble_Shooting. Regards, John Ralls > On Jul 16, 2020, at 3:38 AM, Ruaraidh Sackville Hamilton > wrote: > > (Or maybe a better option would be to be able to get price quotes only for > selected stocks/funds. Then I could troubleshoot one without turning off > the others) > > On T

Re: [GNC] gnucash cannot see printer

2020-07-16 Thread John Ralls
gt; https://bugs.gnucash.org/show_bug.cgi?id=797831 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

Re: [GNC] GnuCash 4.0 printing on MacOS

2020-07-15 Thread John Ralls
ntil now, but after 2 days the light > hasn’t dawned on me; feels like I’m missing something obvious. https://bugs.gnucash.org/show_bug.cgi?id=797831 On which you'll find a workaround. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@

Re: [GNC] Difficulty with online price retrieval

2020-07-15 Thread John Ralls
But not for currency rates, which F::Q has hard-coded to use alphavantage. Plus Alphavantage currency rates seem to still be working: /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency USD GBP 1 USD = 0.79411 GBP Regards, John Ralls > On Jul 15, 2020, at 9:44 AM, E

Re: [GNC] Reconcile also opens Interest Payment box?

2020-07-15 Thread John Ralls
That would be a rather unconventional way to trigger a dialog box. I doubt that many users would like it. Regards, John Ralls > On Jul 15, 2020, at 4:33 AM, fleur wrote: > > > I meant entering anything in the box would then pop up the dialog on > continue, instead of havi

Re: [GNC] Status: enqueued (1) ???

2020-07-14 Thread John Ralls
Debian unstable has 6.2.1, as does the future Ubuntu 20.10. Regards, John Ralls > On Jul 14, 2020, at 9:05 AM, Elmar wrote: > > On 7/14/2020 11:27 AM, John Ralls wrote: > ... >> If it's a US bank then you need to upgrade AQBanking to 6.1.4 or later. > > That s

Re: [GNC] Status: enqueued (1) ???

2020-07-14 Thread John Ralls
all did nothing. How do I clear > this error? If it's a US bank then you need to upgrade AQBanking to 6.1.4 or later. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Reconcile also opens Interest Payment box?

2020-07-14 Thread John Ralls
transaction. Quickfill will do most of the work, but you will have to enter the amount you paid. Regards, John Ralls > On Jul 13, 2020, at 12:15 PM, Adrien Monteleone > wrote: > > I suppose if the SX contained a variable, the user could be prompted for that > reconciled balanc

Re: [GNC] Reconcile also opens Interest Payment box?

2020-07-14 Thread John Ralls
that would be a better design since it would provide no cues about what one is supposed to do and the user can do it themselves anyway, no button required. Regards, John Ralls > On Jul 13, 2020, at 3:42 AM, fleur wrote: > > > No compelling reason either way, but a suggestion

<    1   2   3   4   5   6   7   8   9   10   >