Re: [GNC] Porting Auto Completion from v4 to v5

2023-09-14 Thread john
; information into another file to jumpstart their 5.x experience? David, The auto-completion data store is not and never has been saved. It's generated from the transaction and current-account-split text fields when you open a register tab. Regards, John Ralls

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-12 Thread John Ralls
he gnucash db. I'd like to know the circumstances surrounding the trading accounts creating transactions with no account. That would be a pretty bad bug. Regards, John Ralls > On Sep 11, 2023, at 10:22 PM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 13:23 -0700, John Ralls

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread john
, John Ralls > On Sep 11, 2023, at 17:40, Jediator wrote: > > I am glad you pointed out the difference btw trace and transaction logs. Is > there anyway to configure the transaction logging? I'd like to dump the > transaction logs to a different directory and back them up as

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread John Ralls
Yes, log.conf is a user-created file, there is no default. Note that that's about the tracefile (https://wiki.gnucash.org/wiki/Tracefile), not the transaction logs. Regards, John Ralls > On Sep 11, 2023, at 12:46 PM, Jediator wrote: > > Thanks John! Apparently in version 5

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-11 Thread John Ralls
> On Sep 11, 2023, at 11:48 AM, John Ralls wrote: > > > >> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera >> wrote: >> >> >> To answer you questions >> (1) other than the register I keep always open another 5 tabs ( >> r

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-11 Thread John Ralls
> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 10:15 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 9:33 AM, john wrote: >>> >>> >>> >>>> On Sep 11, 2023, at 09:24, z

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-11 Thread John Ralls
> On Sep 11, 2023, at 9:33 AM, john wrote: > > > >> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: >> >> On Mon, 2023-09-11 at 09:13 -0700, john wrote: >>> >>> >>>> On Sep 11, 2023, at 02:29, zuperkoleoptera >>>&g

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-11 Thread john
> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: > > On Mon, 2023-09-11 at 09:13 -0700, john wrote: >> >> >>> On Sep 11, 2023, at 02:29, zuperkoleoptera >>> wrote: >>> >>> Hi, >>> >>> I use gnucash under Debi

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread john
The MySQL and PostgresQL backends write the transaction logs to GNC_CONFIG_DIR/translog. See https://wiki.gnucash.org/wiki/Configuration_Locations to see where GNC_CONFIG_DIR is on your OS. Regards, John Ralls > On Sep 11, 2023, at 06:56, Adrien Monteleone > wrote: > > I'm

Re: [GNC] Versions after 4.13 freeze in splash screen

2023-09-11 Thread john
s there's also a packaging problem with the 5.x .deb that you're using. I can't tell you what it might be until I figure out what's causing the loop. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription p

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-10 Thread john
attach button or menu selection and pick gnucash.trace from the chooser dialog. Send the reply. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash

Re: [GNC] Using GnuCash as an Accounting Tutor

2023-09-09 Thread john
The only book I know about is https://www.packtpub.com/product/gnucash-24-small-business-accounting-beginners-guide/9781849513869. The GnuCash version is obviously a bit old but the general operation of GnuCash hasn't changed. Regards, John Ralls > On Sep 9, 2023, at 19:44, wr

Re: [GNC] Stock quotes hung

2023-09-09 Thread John Ralls
Unfortunately no. The Securities window can show which ones are set (click the arrow at the right end of the header row and check Get Quotes) but the control isn't sensitive so you have to double-click on each line item and change it in the Security Editor dialog box. Regards, John Ralls

Re: [GNC] Who this "Jim" is, and intermittent delivery of gnucash-user posts [was: Re: gnucash_user: rounding errors and significant digits]

2023-09-09 Thread John Ralls
251 link I looked in my mailbox on that date and found your posts. Regards, John Ralls > On Sep 9, 2023, at 2:10 PM, Jim DeLaHunt wrote: > > I'm sorry, I made a mistake in my message below. > > The Jim message which Bruce was quoting, in the Bruce message to which John &g

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread John Ralls
ste in the contents. Regards, John Ralls > On Sep 9, 2023, at 12:57 PM, (Alan) David Smith > wrote: > > Dear John, > > Thank you for your suggestions: there is nothing in the crash report and this > is what the terminal output is: > > Last login: Fri Sep 8 23:30:

Re: [GNC] gnucash_user: rounding errors and significant digits

2023-09-09 Thread john
at GnuCash matches whatever rounding got applied at your financial institution. Regards, John Ralls > On Sep 9, 2023, at 10:59, Bruce McCoy via gnucash-user > wrote: > > Jim, > > Thank you for your response of Mon, Aug 21, 2023 at 5:00 PM via GnuCa

Re: [GNC] Gnu Cash stopped working 2 days ago.

2023-09-09 Thread john
/Gnucash to see if it prints an error on the terminal window. Regards, John Ralls > On Sep 9, 2023, at 08:25, smit...@smith54.karoo.co.uk wrote: > > Dear Sir, > > It stopped working suddenly. I then updated it to 5.3 and it still was > shutting down on opening it. I have also

Re: [GNC] Stock quotes hung

2023-09-09 Thread john
e from yahoo_json just now, so the problem isn't with Yahoo! messing with their URI again. Most likely there's an issue with one of your more thinly-traded securities, so repeat the triage steps from when this happened a few weeks ago to figure out which one. Regards, John Ralls _

Re: [GNC] Android Companion App, Export CSV

2023-09-08 Thread john
You should have read the details on Financisto Pro: "This is forked version of financisto as the original one is not maintained for a long time. The project is hosted on github (https://github.com/BlueCatMe/financisto)." That repo shows a commit last week. Regards, John Ralls > O

Re: [GNC] Transaction inconsistency when deleting account

2023-09-05 Thread john
than a configurable number of days read-only that gets you most of the way there. A bit of self discipline will take care of the rest. But not everyone wants GnuCash to work that way and it's up to each user to choose the point where they trade off convenience against the risk of making a

Re: [GNC] Transaction inconsistency when deleting account

2023-09-05 Thread john
good accounting practice they can choose to move the splits to another account. Regards, John Ralls > On Sep 5, 2023, at 08:18, Gyle McCollam wrote: > > No Mark, it is not a bug. If you made credit card purchases and subsequent > payments to that card, those transactions have alrea

Re: [GNC] Ajuda na Tradução da Documentação para Português Brasil

2023-08-27 Thread john
/Documentation_Translation for detailed information. Regards, John Ralls > On Aug 27, 2023, at 02:13, Adrien Monteleone > wrote: > > Marcondes, > > Há uma lista de usuários brasileiros que pode ser mais útil para você: > > https://lists.gnucash.org/mailman/listinfo/gnucash-br > &

Re: [GNC] get quotes via gnucash-cli for unknown quote source

2023-08-23 Thread john
and Flatpak version 5.3, F::Q versions > 1.54, 1.56 and 1.58, on Ubuntu 22.04. Not desired behavior but not surprising either: In order to know about the unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q and it doesn't do that. Shouldn't be too hard to fix,

Re: [GNC] Update F::Q in flatpak GC?

2023-08-21 Thread john
-coded lists, but there are still a few details to work out and the contributor doesn't seem to have a lot of time to work on it. Regards, John Ralls > On Aug 21, 2023, at 05:12, rsbrux via gnucash-user > wrote: > > Still one problem (perhaps better handled on the F::Q mailing list

Re: [GNC] NAV of pension fund from India

2023-08-18 Thread john
s://github.com/finance-quote/finance-quote/. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P & Balance Sheet reports

2023-08-17 Thread john
/wiki/Roadmap) never mind the several hundred open enhancement requests, several hundred more open bugs, paying down GnuCash's huge burden of technical debt, and keeping up with technology changes in dependency packages. Regards, John Ralls > On Aug 17, 2023, at 02:43, Brad Morrison wr

Re: [GNC] Update F::Q in flatpak GC?

2023-08-17 Thread john
in the sidebar on the left on the IO::String page) and install it in the flatpak's perl directory as IO/String.pm * Install a recent nightly build and apply the F::Q update to that * If you don't need the IndiaMutual module you can restore the 1.56 version that doesn't need IO::String. Regards, John

[GNC] Fwd: Balance sheet shows 1c imbalance when JPY foreign currency accounts are present

2023-08-16 Thread john
ridwen.us > > Thanks John, I have applied your solution and edited each test transaction to > hard-code the amounts and let the price be auto-calculated (sample file > attached). > > I have also turned on trading accounts and let Gnucash rebalance each > tra

Re: [GNC] Update F::Q in flatpak GC?

2023-08-15 Thread john
Look in the tracefile (https://wiki.gnucash.org/wiki/Tracefile) or run `gnucash-cli -Q info` (see https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools for how to run that from a flatpak) to see what the errors are. Regards, John Ralls > On Aug 15, 2023, at 08:26, rsbrux wr

Re: [GNC] Strange prices update issue (possibly with TSP)

2023-08-14 Thread John Ralls
elp debug it the best way to communicate with Bruce and stay up to date would be to open an issue at https://github.com/finance-quote/finance-quote/issues/. You can post here too if you want, but a Github issue is a better place to put debugging results. Regards, John Ralls > On Aug 14, 202

Re: [GNC] Chase ofx support?

2023-08-14 Thread John Ralls
kely formats are OFX, QFX, QIF, and CSV. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC th

Re: [GNC] Update F::Q in flatpak GC?

2023-08-14 Thread john
repo then copy Quote.pm and the contents of Quote/ into the right places in your flatpak. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailma

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

2023-08-13 Thread John Ralls
/Quicken_Migration. Regards, John Ralls > On Aug 13, 2023, at 1:29 PM, Tom Balazs wrote: > > Well you gave me a good smack down. But are you going to answer the question > I asked? > > On Sun, Aug 13, 2023, 12:22 PM john wrote: > > >> On Aug 13, 2023, at 07:13,

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

2023-08-13 Thread john
g Account #1".) That indicates that you don't understand double-entry accounting. They're not called accounts, they *are* accounts. You need to spend some time studying the Tutorial and Concept Guide and perhaps a basic accounting text. Regards, John Ralls _

Re: [GNC] Convert Money Market stock acnt to Bank acnt

2023-08-12 Thread John Ralls
*Almost* always $1: https://www.investopedia.com/terms/b/breaking-the-buck.asp#:~:text=What%20Is%20Breaking%20the%20Buck,operating%20expenses%20or%20investment%20losses. Last happened during the 2008 meltdown. Regards, John Ralls ___ gnucash-user mailing li

Re: [GNC] Strange prices update issue (possibly with TSP)

2023-08-11 Thread john
* changed the location between XP and Vista. Unless you first create c:\temp trying to write there will just raise an error. The current working directory (just give it a filename, no path) is usually the most convenient. Regards, John Ralls > On Aug 11, 2023, at 09:30, Kalpesh Patel wr

Re: [GNC] Bug in GnuCash 5.3 Stock Assistant

2023-08-11 Thread john
ken, um Ihre Eingaben zu überprüfen oder »Abbrechen«, um diesen " "Dialog zu beenden, ohne die Änderungen zu speichern. " I guess that needs a translator comment that "splits" means transaction splits. "Buying stock long" is a programming error: It's marked fo

Re: [GNC] Balance sheet shows 1c imbalance when JPY foreign currency accounts are present

2023-08-10 Thread john
, John Ralls > On Aug 9, 2023, at 20:11, socket-grips0c--- via gnucash-user > wrote: > > Hello, I am encountering some rounding discrepancies when using foreign > currency bank accounts. This means balance sheet total assets don’t match > balance sheet total liabilities. >

Re: [GNC] Strange prices update issue (possibly with TSP)

2023-08-10 Thread john
p C S L2030 I) > > * 10:03:17 DEBUG results: #f [snip] > * 10:03:37 DEBUG handling-request: (tsp C S L2030 I) > > * 10:03:43 DEBUG results: #f Regards, John Ralls > On Aug 10, 2023, at 12:13, Kalpesh Patel wrote: > > John, > > Appreciate that details

Re: [GNC] Bug in GnuCash 5.3 Stock Assistant

2023-08-10 Thread john
you about buy vs. shares split. Perhaps you're mislead by the paragraph at the top of the dialog where Aktientelung refers to transaction splits? That's explaining what's represented in that page of the dialog, not the transaction type. Regards, John Ralls > On Aug 10, 2023, at 07:57, C

Re: [GNC] Strange prices update issue (possibly with TSP)

2023-08-10 Thread john
at would be to write a wrapper script in your favorite scripting language that does the filename substitution. Regards, John Ralls > On Aug 10, 2023, at 07:50, Kalpesh Patel wrote: > > So I am seeing a strange issue updating prices on my system. For each try, > every third

Re: [GNC] Finance quote not working

2023-08-08 Thread John Ralls
ble quotes on that stock while you figure out how to reliably retrieve quotes for it. Regards, John Ralls > On Aug 8, 2023, at 10:55 AM, Paras Desai wrote: > > Hello John, > > Please find attached the regenerated Trace file > > Thanks > > Paras > > On 08-08-202

Re: [GNC] Finance quote not working

2023-08-08 Thread john
ore detail, including the JSON in each direction, into the tracefile and should help diagnose the problem. If you'd rather not publish your stock portfolio to the world you can send me the file directly. Regards, John Ralls > On Aug 8, 2023, at 00:12, Paras Desai wrote: > > Thanks Jon, &g

Re: [GNC] Finance quote not working

2023-08-07 Thread John Ralls
GnuCash or Finance::Quote, that might offer a clue? There may be an error in your tracefile (see https://wiki.gnucash.org/wiki/Tracefile) that explains why the prices aren't being updated. When trying to retrieve quotes in the GUI are you getting the m

Re: [GNC] gnucash complaining about libdbi version

2023-08-06 Thread john
MariaDB 11 is even possible: One of the participants in the bug report used the latest version of MariaDB connector and it still tells libdi that numbers are strings so libdbi is unable to use query results. Regards, John Ralls > On Aug 6, 2023, at 02:21, Joost van Hooren wrote: > > Yes.

Re: [GNC] finance Quote Not working

2023-08-06 Thread john
Paras, If you're on Windows or Mac you need to give the full path. Windows: " C:\Program Files (x86)\gnucash\bin\gnucash-cli" ***Including the quotes!*** Mac: /Applications/Gnucash.app/Contents/MacOS/gnucash-cli Regards, John Ralls > On Aug 6, 2023, at 01:21, Paras Desai wrot

Re: [GNC] Use again GnuCash

2023-08-05 Thread john
by keeping my GnuCash data in a dmg that lives in a Google Drive folder. I can mount the dmg and access it from /Volumes, which is visible to Gtk file chooser. Regards, John Ralls > On Aug 5, 2023, at 07:54, Derek Atkins wrote: > > Sorry, that's beyond my Mac knowledge. > Hopefull

[GNC] MySQL backend

2023-08-04 Thread John Ralls
, declines to read them. Has anyone using GnuCash on macOS or Linux experienced this problem? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman

Re: [GNC] Stock assist not working : GNUcash ver 5.3, on Windows 10

2023-08-04 Thread john
I can replicate that. Please file a bug report, see https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones for instructions. Regards, John Ralls > On Aug 4, 2023, at 06:29, Paras Desai wrote: > > Deal all, > > I am having an issue when I am

Re: [GNC] How do I search foi empty description, notes or memo fields

2023-08-03 Thread John Ralls
and .+ . In regular expressions ^ means the beginning of the string and $ means the end, so ^$ is an empty string. Conversely . means any character and + means one-or-more, so .+ matches anything. Note that * in place of + means zero-or-more so .* will match any contents or none at all. It has its uses

Re: [GNC] Small amount

2023-08-02 Thread john
of a penny and buying 1/10 "B" for that amount, you're trading (bartering) the 76 "A" for 1/10 "B". Regards, John Ralls > On Aug 2, 2023, at 13:28, Fred Tydeman wrote: > > I am trying to record a sale of a crypto coin and a purchase with that cash. > &g

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-08-02 Thread john
at the position of "test" in that string might have something to do with it, so what about "Car Annual Test Foo", both in the original and in a new transaction? Regards, John Ralls > On Aug 2, 2023, at 13:02, G R Hewitt wrote: > > I'm not so sure. > Your re

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-08-01 Thread john
h the last character in the string. I'll experiment with that a bit. Regards, John Ralls > On Jul 31, 2023, at 23:16, G R Hewitt wrote: > > With regards to my previous answer, I decided to delete the word 'Test' from > 'Car Annual Test' and replaced it with 'NCT'. I could, in the f

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-31 Thread john
tes that aren't tesco. If it's too many to look through try "[[:<:]]tes[^a-z]"; that will show only entries where tes is followed by something that isn't a letter. Regards, John Ralls > On Jul 31, 2023, at 01:19, G R Hewitt wrote: > > John, > forgot to add, I typed

Re: [GNC] Currency conversion

2023-07-30 Thread john
hs old. Your report will use that even though there's a COP->USD quote from yesterday. That will make your report appear to be off. Regards, John Ralls > On Jul 30, 2023, at 13:09, Fred Tydeman wrote: > > I have noticed that my Price Database has both > COP -> USD > an

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-30 Thread john
GnuCash Freeze. 3. Back in Activity Monitor, click the gear icon and select "Sample Process" from the resulting menu. 4. Attach the resulting file to a reply. Regards, John Ralls > On Jul 29, 2023, at 14:03, John Ralls wrote: > > That's interesting, yours is the first repo

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-29 Thread John Ralls
It might feel the same but it's very much not the same. The quickfill is quite different on 5.x from previous versions. Regards, John Ralls > On Jul 29, 2023, at 11:21 AM, Chris Green wrote: > > On Sat, Jul 29, 2023 at 09:59:37AM -0700, john wrote: >> For bug-filing instruction

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-29 Thread John Ralls
One needs a login only to edit pages, not to read. When you have time and if the problem hasn't resolved itself, try opening a terminal window and running `traceroute wiki.gnucash.org`. If it prints more than 3 lines of * * * then kill it with control-C. Regards, John Ralls > On Jul 29, 2

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-29 Thread John Ralls
That's interesting, yours is the first report of this on macOS. Regards, John Ralls > On Jul 29, 2023, at 12:59 PM, G R Hewitt wrote: > > Hi John, I am using MacOS High Sierra 10.13.6 2010 MacPro 5.1 > > On Sat, 29 Jul 2023 at 18:00, john wrote: > >> For bug-filing i

Re: [GNC] Unable to enter data in "Description" field of a Transaction

2023-07-29 Thread john
using? Regards, John Ralls > On Jul 29, 2023, at 05:29, AgedLace wrote: > > Can you point me in the direction needed in order to file the bug-report? > > Thank you! > > > On 7/29/23 08:26, Adrien Monteleone wrote: >> Sorry, indeed, I missed that. >>

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread John Ralls
to open an issue at https://github.com/finance-quote/finance-quote/issues. If not there's more to investigate here. Regards, John Ralls > On Jul 27, 2023, at 7:37 AM, bern...@deprez.biz wrote: > > Thanks for that suggestion - did that on 2 different Windows systems, both > still fail the

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-27 Thread john
. Or you can keep right up to date with flatpak. Regards, John Ralls > On Jul 26, 2023, at 21:41, Scott Ellsworth wrote: > > Hi John, > > It turns out that I had the latest version of GnuCash that's supported by my > version of Ubuntu (v3.8b). I installed Flatpak and used it

Re: [GNC] Issue with Finance::Quote

2023-07-26 Thread john
It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry Perl cpan shell and telling it `force install Finance::Quote` to reinstall it. Regards, John Ralls > On Jul 26, 2023, at 04:48, bern...@deprez.biz wrote: > > Hi Ken, > > I tried googleweb and get a

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-26 Thread john
schema. Can you open your files by navigating to them with File>Open? Have you modified your preferences (via Edit>Preferences) from the defaults enough to motivate you to try to recover them, and if so are you comfortable with using regedit? Regards, John Ralls > On Jul 26, 2023, at 19:

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-25 Thread john
Yeah, it's gotten a lot faster since Chris Lam figured out it was checking every transaction for every split in the transaction and fixed it to only traverse the transactions once. Regards, John Ralls > On Jul 25, 2023, at 19:13, R Losey wrote: > > Is this still working? I'm ru

Re: [GNC] Help with counters problem

2023-07-25 Thread john
The counters problem is a bug in 5.0 and 5.1. Upgrade to 5.3. Regards, John Ralls > On Jul 24, 2023, at 04:46, Carlin Partnerships > wrote: > > Hi Jim > > Thanks for the reply. > > I installed Gnucash 5.0 from an installer. Build ID: 5.0+(2023-03-25) > I use

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-25 Thread john
ber for the first and a decimal number (editing the one the Transfer dialog presented; that was before I changed the Force prices to decimal preference. The book does not have Trading accounts enabled. GnuCash is v5.3. Regards, John Ralls > On Jul 25, 2023, at 00:57, Scott Ellsworth

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-07-24 Thread john
in splits actually exist, and make data changes for older files needed by the current GnuCash version. Check and repair runs those scrubs (again) plus a few more. Regards, John Ralls > On Jul 24, 2023, at 19:54, larry johnston wrote: > > Is running 'Check and Repair' what upgr

Re: [GNC] Issue with Finance::Quote

2023-07-24 Thread john
Does gnucash-cli -Q dump alphavantage QQQ work? (It does for me, GnuCash 5.3 and F::Q 1.56) What version of F::Q are you using? Regards, John Ralls > On Jul 23, 2023, at 12:30, bern...@deprez.biz wrote: > > Hi all, > > since a few days, I've been unable to use the quotes fr

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-24 Thread john
the transaction currency is VND, hence the price of ₫1.00. The $0.00 is a display issue: The default price display is 2 more digits than the currency's smallest fraction, .00 for both USD and VND, so ., and 1/23600 rounded to 4 places is 0. Regards, John Ralls > On Jul 23, 2023, at 22

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-23 Thread john
Scott, > On Jul 23, 2023, at 03:11, Scott Ellsworth wrote: > > ...sorry, accidentally didn't reply to all, so I'm forwarding my reply to the > list > > - Original message - > From: Scott Ellsworth > To: john > Subject: Re: [GNC] strange lack of excha

[GNC] Transaction line debit/credit in split view

2023-07-23 Thread john
proposes that the transaction line in split view should also show the value in the transaction currency, that is shares * price. Does anyone have an opinion about this? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Trouble building 5.3

2023-07-22 Thread John Ralls
s. Gwen 5.6.0 and AQBanking 6.2.10 are in Debian's buster-backports (https://backports.debian.org/Instructions/) so you could see if you can install them from there. If that fails they're both pretty easy to build from source. Download from https://www.aquamaniac.com. Regards, John Ralls __

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-22 Thread john
, date entered, accounts, shares, and prices with one line per split? Leave off description, memo, and account to keep confidential what you spent the money on, that's irrelevant here. Regards, John Ralls > On Jul 22, 2023, at 01:34, Scott Ellsworth wrote: > > Hi John, &

Re: [GNC] strange lack of exchange rates in a new currency cash account

2023-07-21 Thread john
at the price database entries to see if any of the earlier transactions recorded prices. Regards, John Ralls > On Jul 21, 2023, at 01:14, Scott Ellsworth wrote: > > Another strange thing: It might be starting to work normally now: I just > entered a couple of transactions and accident

Re: [GNC] Should GNUCash allow a split to reference the same account twice

2023-07-20 Thread John Ralls
the sale and capital gains of a security or foreign currency asset in the same transaction by having two splits to the stock account. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] "Mod" field in GNUCash log file

2023-07-20 Thread John Ralls
of the transaction in that edit. 'B' lines reflect the state at the beginning of the edit, as to 'D' (for delete) and 'R' (for rollback). 'C' is for commit and the data in a C line is the new state of the transaction once it's committed. There's some documentation at https://code.gnuca

Re: [GNC] Income Statement versus Transaction Report

2023-07-20 Thread John Ralls
results. They're what-if tools, as in "How much money in currency X would I have if I sold all of my investments and converted all of my cash to currency X today?". It's fun to do but not particularly meaningful. Regards, John Ralls > On Jul 20, 2023, at 10:24 AM, Adrien Montele

Re: [GNC] Reconciliation Dates

2023-07-20 Thread john
> On Jul 20, 2023, at 08:03, Gyle McCollam wrote: > > Is there a way to delete the reconciliation date from accounts you no longer > wish to reconcile? > Not in the UI or even the API. Why would you care that there's a reconciliation date on the account? Rega

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-18 Thread John Ralls
> On Jul 18, 2023, at 10:12 AM, Bruce Schuck wrote: > > On 7/17/23 9:06 PM, john wrote: > >> Well, a user wouldn't want to set GBX as their default currency, >> just to create an account in their tree denominated in it to be a >> parent for stock accounts that

Re: [GNC] USAA OFX Direct connect stopped working

2023-07-18 Thread John Ralls
BTW, I also got the invalid signon from USAA this morning. I repeated the drill at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA and got the exact same access id and pin. Once completed I was able to retrieve my transactions. Regards, John Ralls > On Jul 18, 2023, a

Re: [GNC] USAA OFX Direct connect stopped working

2023-07-18 Thread john
Access id is configured in the AQBanking setup wizard accessed from Tools>Online Banking Setup. The PIN is collected every time you run Actions>Online>Get Transactions unless you told GnuCash to remember it. If you did you can tell it to forget from Preferences>Online Banking. R

Re: [GNC] Cannot alter Trading value

2023-07-18 Thread john
the price. Remember that doing it that way avoids rounding issues that can arise when you enter the price and have GnuCash calculate the amount. Regards, John Ralls > On Jul 18, 2023, at 08:49, David Carlson wrote: > > Fred, > > Are you starting from the security acc

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread john
Bruce forgot to copy the list on this and couldn't find it to resend, and then so did I on the reply! > On Jul 17, 2023, at 18:57, Bruce Schuck wrote: > On 7/17/23 5:28 PM, John Ralls wrote: > >> Sorry, I can't provide any examples of JSE or TASE stocks, I was >>

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread John Ralls
> On Jul 17, 2023, at 11:11 AM, Bruce Schuck wrote: > > On 7/17/23 10:02 AM, john wrote: > >> It's not all non-US securities. In AlphaVantage it appears to be only >> LSE stocks; JSE stocks aren't supported and Tel Aviv stocks support >> only ILS. The Yahoo JSON

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread john
ted that way. That would take a little finessing on users' part because using it would depend both on the currency the stock is quoted in and whether F::Q converts it to the "real" currency. Regards, John Ralls ___ gnucash-user mailing list g

Re: [GNC] Online Banking Setup

2023-07-16 Thread John M. Thornton
institutions. Cheers, John John Sent from Gmail for Android On Sun, Jul 16, 2023, 19:12 Jim DeLaHunt wrote: > Hello, John, and welcome to GnuCash! > > On 2023-07-16 15:39, John M. Thornton wrote: > > > Good afternoon, > > > > I just wanted to inquire if anybody is able to

[GNC] Online Banking Setup

2023-07-16 Thread John M. Thornton
to download either QIF or OFX files and do that, just was looking for something maybe a little easier similar to how Quicken used to do it. I am using Windows 11, GnuCash 5.3 for reference Regards, John M Thornton Lee's Summit, MO ___ gnucash-user mailing list

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-14 Thread john
> On Jul 13, 2023, at 23:52, Tomer Altman wrote: > > On 7/13/23 8:55 AM, john wrote: >> >> >>> On Jul 13, 2023, at 01:34, Tomer Altman wrote: >>> >>> On 7/12/23 6:26 PM, john wrote: >>>> >>>> >&g

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-13 Thread john
> On Jul 13, 2023, at 01:34, Tomer Altman wrote: > > On 7/12/23 6:26 PM, john wrote: >> >> >>> On Jul 12, 2023, at 16:16, Tomer Altman wrote: >>> >>> Hi everyone, >>> >>> Due to filesystem errors, I had to reinstall MacO

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-12 Thread john
s a SQLite file you can open it with sqlite3, provided by macOS. Just open Terminal and run sqlite3 /path/to/my/gnucash/file You can use the `.tables` command to list the tables and `.schema ` to show the structure and compare it with https://wiki.gnucash.org/wiki/SQL. 99% of

Re: [GNC] Matchmakers import filters lost with upgrade of GC

2023-07-10 Thread john
ere running GnuCash 5.1 and had the preferences set to your liking and they went back to the defaults when you started 5.3 something else is going on. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subsc

Re: [GNC] Gnucash chat only by invite

2023-07-03 Thread john
ki/IRC#Usage for why. Regards, John Ralls > On Jul 2, 2023, at 21:38, Alex Dorsch wrote: > > Hey! > > Seems like the #gnucash chat on gnome is now by invite only. > > What happened? > And how can I join the party? > > Best, > > Alex

Re: [GNC] How to revert to previous input mode?

2023-07-02 Thread john
on-visible character issues... That was the work-around for before 5.0 if you wanted a description that happened to be a partial match for an old one. In 5.x you can hit instead and it will dismiss the match popup and leaving you with what you've typed already. Note that 5.2 and later matches only on t

Re: [GNC] 2FA in Direct Connect

2023-06-30 Thread john
Nope. If somebody's added 2FA to OFX DirectConnect AQBanking doesn't know how to handle it. BTW, Intuit sold Quicken to Rocket Mortgage a couple of years ago; they operate it as Quicken Inc. See the fine print at the bottom of https://www.quicken.com. Regards, John Ralls > On Jun 30, 2

Re: [GNC] GnuCash 5.3 autofill headaches

2023-06-30 Thread john
David, OK, so not the marker transaction. I've got only 5 future transactions. The read line in Vincent's file is because he has read-only after N days set in File>Properties. The transactions above the red line are read-only. Regards, John Ralls > On Jun 30, 2023, at 17:43, David H

Re: [GNC] GnuCash 5.3 autofill headaches

2023-06-30 Thread John Ralls
David, Huh. Two possibilities: I have only a few future transactions, not enough to move the blank transaction that far up the screen, and I wonder if that marker transaction (with no debit or credit value) matters. What macOS version on the iMac? Regards, John Ralls > On Jun 30, 2023, a

Re: [GNC] HELP! Invoice Stylesheet, how to? V4.8

2023-06-30 Thread John Ralls
along with the other links to binaries & sources. Good idea. I did that, and cleaned up the display of the downloads box a bit as well. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription prefe

Re: [GNC] GnuCash 5.3 autofill headaches

2023-06-30 Thread John Ralls
top of the window and some of those future transactions aren't visible. I think that's correct behavior: Ready to perform input with the input location visible. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org T

Re: [GNC] gnucash 5.3 compile errors

2023-06-29 Thread John Griessen
On 6/28/23 22:24, john wrote: I don't see the boost checks in you CMake output and the error is complaining that it can't find boost filesystem. Make sure that's installed by your package manager, remove any existing installed gnucash so that the linker doesn't get confused, and start from

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