Re: [GNC] Can one save report option defaults?

2022-05-05 Thread john
on, change some options, and save that as a new saved configuration. You'll need to work out a naming convention if you have a lot of them so that you can easily find the one you want in the saved config dialog. Regards, John Ralls ___ gnuca

Re: [GNC] Large GnuCash file very slow to write to

2022-05-08 Thread john
t you're doing and what step is taking 20 minutes. Regards, John Ralls > On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user > wrote: > > It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 > chip). > > The slow part seems to be savin

Re: [GNC] Errors after restarting GnuCash 4.10 from terminal or bash script

2022-05-10 Thread john
anything to do with getting online quotes. I do compile with -D > WITH_PYTHON+ON > when I build it. Haven't ever started GC from a script or terminal recently > but > I presume this happens from the desktop launcher as well, just isn't visible. > > Has anyone

Re: [GNC] Documentation changes needed

2022-05-13 Thread john
n install that directly with `Xcode-select --install` but since MacOS X 10.11 (El Capitan) or so there are stubs for the included commands that pop up a dialog box asking if you want to install them, so just type `git` at a terminal prompt and click OK. Regards, John Ralls

Re: [GNC] Documentation changes needed

2022-05-13 Thread john
ak-gui to get ninja build files instead of Makefiles. There's a binary available on the website or you can install it with either package manager. It's not necessary for documenters to build PDF, ePub, or MOBI documentation so don't worry about FOP. Regards, John Ralls __

Re: [GNC] unrealized gain / losses for mutual funds

2022-05-15 Thread john
> On May 15, 2022, at 8:15 AM, Andrea Borgia wrote: > > Problem is, the example applies to a painting, that is an object whose value > changes, not shares whose number remains constant but whose value changes, > thus leading to a change in total valuation. There's no accounting difference b

Re: [GNC] unrealized gain / losses for mutual funds

2022-05-15 Thread john
show_bug.cgi?id=797796 <https://bugs.gnucash.org/show_bug.cgi?id=797796>. The Balance Sheet report automatically computes an Equity:Unrealized Gains line item if you use the "price nearest to report date" price source option. You can compute that

Re: [GNC] Am I in business?

2022-05-17 Thread john
I've been using * ^TO_gnucash-user@(lists\.)?gnucash\.org in my procmail file for 15 years or so. Hasn't failed me yet. Other lists have moved infrastructure and have needed recalibration, but it's never frequent enough to be a bother. Regards, John Ralls > On May 17

Re: [GNC] Crypto trade directly - not converting to local currency first

2022-05-23 Thread john
ww.irs.gov/taxtopics/tc420 <https://www.irs.gov/taxtopics/tc420> sketches the reporting requirements for US taxpayers. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: ht

Re: [GNC] Strange incorrect due date calculated on a duplicated bill

2022-05-30 Thread john
10:59:00 the canonical "neutral" time, chosen so that the date doesn't change regardless (almost) of time zone. Regards, John Ralls > On May 30, 2022, at 4:10 PM, Adrien Monteleone > wrote: > > I'm using SQLite, but the time stamp for posting is: > > 2

Re: [GNC] Program suddenly very slow

2022-05-31 Thread john
g is just an alias for code.gnucash.org (so is wiki.gnucash.org). Try `site:lists.gnucash.org/pipermail` to restrict it to the mailing list archives. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscri

Re: [GNC] Securities Namespace

2022-06-05 Thread john
CURRENCY and NONCURRENCY are built in; the former applies to the ISO4217 currencies that are also built in, the latter is a default for everything else that a user hasn't created a namespace for. Regards, John Ralls > On Jun 5, 2022, at 6:44 AM, Fred Tydeman wrote: > > On Su

Re: [GNC] Missing 2nd entry

2022-06-09 Thread john
No, it's called a stock split. Nothing new about it at all. Regards, John Ralls > On Jun 9, 2022, at 7:46 AM, David Carlson wrote: > > That screen shot appears to show a security purchase without a price. Is > this a new way to create wealth? > > On Thu, Jun 9, 2022

Re: [GNC] Startup issue - two windows

2022-06-10 Thread john
actions" dialog from displaying. Regards, John Ralls > On Jun 10, 2022, at 7:42 AM, Fred Tydeman wrote: > > Another screen shot to show when I get when things are "hung". > Now, I can move all the windows (except splash screen) around on the screen. > The little one

Re: [GNC] Startup issue - two windows

2022-06-10 Thread john
ne you get depends on how you've set up your SXes and which ones have fired since you last ran GnuCash or Actions>Scheduled Trasnsactions>Since Last Run. Regards, John Ralls > On Jun 10, 2022, at 6:30 PM, Adrien Monteleone > wrote: > > I find it odd though that the SX window

Re: [GNC] How to reorganize the account tree

2022-06-13 Thread john
splay the account code column in the Accounts tab, and click on its header to sort by it. You can easily tell which column is used for sorting and in which direction by the arrow icon that appears on the right of the column's header. Regards, John Ralls > On Jun 13, 2022, at 12:09 PM,

Re: [GNC] GnuCash 4.11 Release

2022-06-26 Thread john
2 (for Windows) or the various Linux and BSD distros. Regards, John Ralls > On Jun 26, 2022, at 5:09 PM, Gyle McCollam wrote: > > John Ralls, > I want to thank you and the other developers for this great software (4.11). > I know I don't use many of the features availa

Re: [GNC] GnuCash 4.11 Release

2022-06-26 Thread john
I changed the wrong line in the header file. Should be fixed now. Regards, John Ralls > On Jun 26, 2022, at 4:02 PM, David H wrote: > > Try > https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.11/gnucash-4.11.setup.exe > - > there's an extra &qu

Re: [GNC] gnucash-user Digest, Vol 231, Issue 70

2022-06-29 Thread john
figure out what you're talking about otherwise. I seldom bother. Regards, John Ralls > On Jun 29, 2022, at 5:00 PM, Eric Hammond wrote: > > Resending to proper group > > I set up GnuCash as best possible by extracting what I could from my crashed > Quicken, and many

Re: [GNC] Printing Chart of Accounts WITHOUT balances

2022-07-01 Thread john
list of accounts with no actual financial information. 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 ar

Re: [GNC] 4.11 missing online banking and AqBanking in Windows

2022-07-02 Thread john
7;t yet figured out what it is. When I have a working installer I'll post an announcement to gnucash-announce, copying gnucash-user and gnucash-devel with the sha256 and download URIs. Regards, John Ralls > On Jul 2, 2022, at 7:01 AM, Gyle McCollam wrote: > > I am correct in

Re: [GNC] [GNC-dev] Questions about Import Map Data

2022-07-05 Thread john
adddbf3464875c6521582b353964. You're correct that the non-Bayesian matching is just the transaction description. You might have those in your book because at some point you disabled Bayes matching in Preferences, but more likely you imported a QIF file or a CSV file before Geert r

Re: [GNC] Transaction imports

2022-07-05 Thread john
t/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your su

Re: [GNC] Fiscal Year: Preferences vs Properties

2022-07-07 Thread john
the way various configuration data are stored--online banking and report configurations for example--it's easy to find more instances of "user" data should be "book" data. No, fiscal years aren't always 365 1/4 days: The first and last fisc

Re: [GNC] Adding a new currency

2022-07-07 Thread john
17". Everything else is a commodity. 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] Saving window position (and size)

2022-07-12 Thread john
ortunately there are at present only two core devs who know GUI coding enough to do that, Bob Fewell and me. I can't really speak for Bob but I have far too big a pile of higher priority work to put in the several hours of debugging that problem. It won't do any harm to file that bug but

Re: [GNC] MariaDB?

2022-07-15 Thread john
None known; in fact we switched the connectors in the Gnucash-built bundles and in flatpak to MariaDB's because MySQL discontinued their C one and the C++ one won't work with libdbi. Regards, John Ralls > On Jul 15, 2022, at 7:40 PM, Thomas Forrester wrote: > > Are ther

Re: [GNC] GC4.10 on Win10 Crashing

2022-07-21 Thread john
i.gnucash.org/wiki/Stack_Trace#Windows for instructions. Regards, John Ralls > On Jul 21, 2022, at 8:47 AM, A Harvey wrote: > > I have a similar problem. It occurs in both 4.10.x and 4.11. I think it > also occurred in 4.9 but can't remember. I encountered it on windo

Re: [GNC] Symbolic links (MacOSX)

2022-07-24 Thread john
e bottom of the File menu. The simplest way to migrate to the new directory is to use File>Open to open each in turn ***bottom to top***. Regards, John Rals ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] need to teak the default invoice script - new user

2022-07-25 Thread john
reports according to the instructions on that page they'll appear on the Reports menu. It's not currently possible to use the Print Invoice button to run a custom invoice report, but Bob Fewell is working on adding that to GnuCash 5 that we'll release next spring, see https://github

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread john
the shares. When you get around to selling the stock you'll have to look at the original account to get the basis, but that's not that big a deal; a bigger one might be that it will probably break the Advanced Portfolio Report. I don't use that, but if you do you'll

Re: [GNC] Linked Documents on Import

2022-07-25 Thread john
guage that can link to C libraries. The API documentation can be found at https://code.gnucash.org/docs/MAINT. Regards, John Ralls > On Jul 25, 2022, at 6:54 AM, Robert Simmons wrote: > > I definitely wouldn't expect this to be supported. I did take a look at > PieCash and

Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-25 Thread john
dings.html. There are some examples in https://github.com/Gnucash/gnucash/tree/maint/bindings/python/example_scripts. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscrib

Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-26 Thread john
tions will be removed at the subsequent major release, meaning that any Scheme function that raises a deprecation warning in 4.x will be removed in 5.0. No such warnings will be made for C/C++ API nor for the Python bindings. Regards, John Ralls > On Jul 26, 2022, at 7:13 AM, Esteban Maringol

Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-26 Thread john
ithub.com/gnucash/gnucash-on-windows, https://github.com/gnucash/gnucash-on-osx, and https://github.com/gnucash/gnucash-on-flatpak. Regards, John Ralls > On Jul 25, 2022, at 9:49 PM, flywire wrote: > > TLDR: GnuCash Windows version is compiled on linux so, considering the > note

Re: [GNC] Find

2022-07-31 Thread john
No, Edit>Find is not an option for finding an account, nor is it a bug. Read the dialog's title. Regasrds, John Ralls > On Jul 29, 2022, at 1:17 PM, Alan Magnus via gnucash-user > wrote: > > What version of GnuCash and on what operating system? > > I am usin

Re: [GNC] MacOS - could not complete critical test of libdbi

2022-08-02 Thread john
st year or so too. I can't make it happen consistently enough to debug it, and it has never stopped me from being able to open a Sqlite3 file. Regards, John Ralls > On Aug 2, 2022, at 8:47 AM, km22 wrote: > > I have downloaded DB Browser for Sqlite and have been trying diff

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-07 Thread john
unless your script is going to create jobs and immediately exit. The engine loads the database into memory once at the beginning of the session and doesn't read it again, so any changes you make direct to the database like that are invisible to the current session. Regards, John Ralls >

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread john
PI. We're working on fixing that but we don't have a lot of resources so it's going to take a long time. We decided on the overall framework almost 10 years ago and haven't gotten very far. Regards, John Ralls > On Aug 8, 2022, at 5:45 AM, Robert Simmons wrote: > >

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread john
lots and the commodities to find a block that looks like 406 757 34279 4 4505 1 1 1 1 1 Regards, John Ralls > On Aug 8, 2022, at 2:43 PM, R. Victor Klassen wrote: > > Just out of curiosity, how does one determine those numbers? An SQL query? > grep | wc on the xml

Re: [GNC] How To Get Job Object?

2022-08-10 Thread john
GUIDs belong to the parent class QofInstance, so you use qof_instance_get_guid(my_job) Regards, John Ralls > On Aug 10, 2022, at 5:42 PM, Robert Simmons wrote: > > I have created a number of Jobs. Now I want to associate an invoice with > one of the jobs. I can see there i

Re: [GNC] How To Get Job Object?

2022-08-10 Thread john
And that's pretty much the way the GUI works too. BTW do you know about the Doxygen-generated docs for the C API? It's a bit patchy in parts, but there's a ton of useful info. You can build it yourself or use our nightly builds at https://code.gnucash.org/docs/MAINT. Regards, Jo

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2022-08-11 Thread john
taxes themselves, handing off the investors share of every income category to add to their own tax returns. The statement that you posted looks like it might be from one of these. As in the MLP case I don't think it's practical to try and set up account

Re: [GNC] Share Values recording

2022-08-12 Thread john
me currency. GnuCash doesn't enforce that and for personal book-keeping it may or may not matter depending on what you need to prepare your taxes. Consult with a local tax expert if you're not sure. Regards, John Ralls > On Aug 12, 2022, at 7:59 AM, Adrien Monteleone > wrote: >

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

2022-08-12 Thread john
that don't require human intervention that particular bit of code doesn't run. I haven't yet looked for the code that does run in that case, but I asked there if changing any of the SXes to "notify" so that that code does run causes the registers to refresh on their own. Rega

Re: [GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

2022-08-13 Thread john
ate. You can create prices with the Add button in the Price Database dialog, Tools>Price Database. Regards, John Ralls > On Aug 12, 2022, at 8:33 PM, flywire wrote: > > Despite the example in my previous post, I'm inclined to just manage the > share portfolio value rather

Re: [GNC] Crash in Trial Balance report

2022-08-13 Thread john
of the first transactions in the security's register. Hope you don't have too many securities to examine. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Zero balances in report

2022-08-13 Thread john
rizing all of the commodities held in some parent account including the zero balance ones. I'm not sure if that's a bug or a feature, but to get the display I think you want go to the Accounts tab of the report options dialog and increase the account depth so that the individual commodity

Re: [GNC] Crash in Trial Balance

2022-08-14 Thread john
Try increasing the account depth to 6 so that Acciones Open End and $cop are included. What is the report currency? Regards, John Ralls > On Aug 14, 2022, at 7:07 AM, Fred Tydeman wrote: > > As suggested in other emails, I looked at the price data base. I did find > two 0 ent

Re: [GNC] Crash in Trial Balance

2022-08-14 Thread john
ions. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your repli

Re: [GNC] Crash in Trial Balance

2022-08-14 Thread john
> On Aug 14, 2022, at 1:07 PM, Fred Tydeman wrote: > > > > On Sun, Aug 14, 2022 at 1:43 PM john <mailto:jra...@ceridwen.us>> wrote: >> Try increasing the account depth to 6 so that Acciones Open End and $cop are >> included. > > I chang

Re: [GNC] Online Currency Exchange Rates

2022-08-14 Thread john
Jim, Interesting. that would require a couple of changes to Finance/Quote/CurrencyRates/AlphaVantage.pm, so how's your Perl? PRs to https://finance-quote/finance-quote/. Regards, John Ralls > On Aug 14, 2022, at 8:25 PM, Jim DeLaHunt wrote: > > On 2022-08-14 14:42, Jo

Re: [GNC] Crash in Trial Balance

2022-08-15 Thread john
> On Aug 14, 2022, at 9:00 PM, Fred Tydeman wrote: > > On Sun, Aug 14, 2022 at 11:22 PM john <mailto:jra...@ceridwen.us>> wrote: >> When the depth is "all" does crash make the same stack trace? > > The traces are the "same" except for the h

Re: [GNC] Saving a New Book doesn't allow format selection

2022-08-16 Thread john
ernal data structure, but it's also a bit of accounting jargon. You've no doubt heard phrases like "book value", "booking an invoice", and of course the infamous "two sets of books" and "cooking the books". Regards, John Ralls > On Aug 16, 2022

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread john
t voiding your warranty or needing to unzip the file or, for that matter, caring which backend is used. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnu

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-17 Thread john
> On Aug 16, 2022, at 8:18 PM, list+gnuc...@jdlh.com wrote: > > On 2022-08-16 19:54, john wrote: > >> OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python >> bindings so you should >> be able to write a python script using them to do the

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread john
ces and there's no way to tell it the value (in the ttransaction currency), only the amount (in the account's commodity). You should supply the price instead. Ideally that will be the fraction value/amount (multiply both by the power of 10 needed to make them integers, so e.g you'

Re: [GNC] USAA OFX Direct connect stopped working

2022-08-21 Thread john
SAA had a server outage over the weekend. If it still fails, turn on OFX logging (see https://wiki.gnucash.org/wiki/AqBanking#Debugging) and capture the actual OFX response. Edit it to remove your actual account number and credentials then post it here. Regards, John Ralls _

Re: [GNC] Recording stock holdings

2022-08-22 Thread john
s? It's creating the splits because you have trading accounts enabled on the book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the rest of your book to figure out why the value of that split is so large. The price change is strange too. Does i

Re: [GNC] Recording stock holdings

2022-08-23 Thread john
Good that you've resolved the problem. Trading accounts are enabled and disabled on the first tab of File>Properties. You should make sure that it's disabled so that GnuCash doesn't create more trading accounts for you going forward. Regards, John Ralls > On Aug 23,

Re: [GNC] Price editor

2022-08-27 Thread john
Yes, we changed the name in 2.6.11 to make clear the difference between the price database window and the price editor dialog. The latter is opened with the Add and Edit buttons on the former. Regards, John Ralls > On Aug 27, 2022, at 6:53 AM, David Carlson > wrote: > >

Re: [GNC] GC 3.11 crashes during "Check & Repair"

2022-08-28 Thread john
ug on that. If it doesn't crash then you're probably good-to-go with 4.11. Regards, John Ralls > On Aug 28, 2022, at 4:25 AM, Adrien Monteleone > wrote: > > The Check & Repair is to be done after each major version upgrade. > > Since you're getting a cra

Re: [GNC] GC 3.11 crashes during "Check & Repair"

2022-08-28 Thread john
Open the file in a plain-text editor (or less on Linux) and find the 104th instance of "". Splits are part of elements. Prices are elements under and are all processed before any transactions, so whatever is causing the crash it isn't a price entry. Regards, John Ralls &g

Re: [GNC] Problems upgrading to 4.8a

2022-09-05 Thread john
on the yelp version and put it in GnuCash 4.12 that we'll release at the end of the month. BTW the Gnome 43 runtime also releases in two weeks. IIRC Flathub will force us to update our current 41 to 42 or 43 for the 4.12 release, meaning that we need that change for the flatpak buil

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-05 Thread john
> On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user > wrote: > > > > On 9/5/22 3:09 PM, John Ralls wrote: >>> On Sep 5, 2022, at 10:32 AM, Adrien Monteleone >>> wrote: >>> >>> On 9/5/22 12:13 PM, Jack Frillman via g

Re: [GNC] Problems upgrading to 4.8a

2022-09-05 Thread john
> On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger > wrote: > > Hi, > > Am 05.09.22 um 22:27 schrieb Geert Janssens: >> Op maandag 5 september 2022 19:09:06 CEST schreef john: >>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612 >>> >>

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-06 Thread john
> On Sep 6, 2022, at 5:56 AM, Jack Frillman wrote: > > > > On 9/5/22 11:53 PM, john wrote: >> >> >>> On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user >>> <mailto:gnucash-user@gnucash.org> wrote: >>> >>> &

Re: [GNC] Problems upgrading to 4.8a

2022-09-06 Thread john
ions page in Preferences. If the SLR doesn't work then look in the trace file (see https://wiki.gnucash.org/wiki/Trace_File) for errors. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription prefer

Re: [GNC] help: vs. ghelp: was: Problems upgrading to 4.8a

2022-09-07 Thread john
ble it's https://packages.debian.org/bullseye/all/gnucash-docs/filelistNote that stable has the docbook docs and testing doesn't. Might we have caused this with our cmake changes? Regards, John Ralls . > On Sep 7, 2022, at 12:48 AM, Geert Janssens > wrote: > > Op dinsdag 6 septemb

Re: [GNC] Crash when importing OFX file from Bank of America

2022-10-01 Thread john
he GNUcash trace that was not in the > ofxdump was the last line: > > free(): double free detected in tcache 2 > > I have no clue what that pertains to. > > > Any help would be much appreciated. The double-free detected error seems to be a feature of the Linux C runtime.

Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

2022-10-05 Thread john
hat's the error? Regards, John Ralls > On Oct 5, 2022, at 7:33 PM, Chris Grinton wrote: > > Good thought - but the problem still occurs even if the share count and > price are non-0. (The example transaction I've described is a simple > reduction in the cost base of

Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

2022-10-06 Thread john
a last-transaction issue, either: If one creates two transactions in a session they'll both get the Orphan and Imbalance splits created. I''l try watching the program load in the debugger next. Regards, John Ralls > On Oct 5, 2022, at 9:33 PM, Chris Grinton wrote: > > Goo

Re: [GNC] Gnucash invoicing and payment - questions on process

2022-10-07 Thread john
Imbalance, and Orphan Gains come immediately to mind; there may be others. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinf

Re: [GNC] Problem with missing balance in a parent account

2022-10-07 Thread john
t; > All the sub accounts point to the parent account and when I list my accounts > the balance appears there and is correct. > > What happened and how can I get it back? Can you attach (don't inline!) a screenshot of the problem? It's not clear from you

Re: [GNC] Problem with missing balance in a parent account **FINAL POST**

2022-10-10 Thread john
Please remember to copy the list on all replies. If you want the Reconcile button (and, contrary to what Robin Chatterjay wrote, Actions>Reconcile) to be active for your account, make it not a placeholder. Regards, John Ralls > On Oct 10, 2022, at 7:56 AM, Jay Ridgley wrote: >

Re: [GNC] Problem with missing balance in a parent account **FINAL POST**

2022-10-10 Thread john
Sorry, Robin Chattopadhyay not Chatterjay. Regards, John Ralls > On Oct 10, 2022, at 9:20 AM, john wrote: > > Please remember to copy the list on all replies. > > If you want the Reconcile button (and, contrary to what Robin Chatterjay > wrote, Actions>Reconcile)

Re: [GNC] Price update not working

2022-10-10 Thread john
ck on finance.yahoo.com <http://finance.yahoo.com/> when switching sources. Yahoo_json isn't throttled. Note that most of the other sources rely on screen-scraping and are therefore a bit brittle in the face of layout changes to the source's websites. Regards, John Ralls > On

Re: [GNC] Price update not working - Alpha Vantage's limit is five (5) API requests per one (1) minute

2022-10-10 Thread john
Alphavantage has always rate-limited free quotes to five quotes per minute. When we started using them the quote rate was the primary difference between account tiers. Regards, John Ralls > On Oct 10, 2022, at 2:34 AM, Geoff wrote: > > Thanks for letting us know Ismael. > >

Re: [GNC] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

2022-10-10 Thread john
n you start the next session. Doing a save-as writes a new database from the contents of memory that includes the newly created accounts. So I need to figure out a clean way to tell the sql backend that the new accounts aren't in the db already and that it should go ahead and write them. R

Re: [GNC] Problem with missing balance in a parent account **FINAL POST**

2022-10-10 Thread john
Ah, I misunderstood. It's disabled in the Action menu when the placeholder account's register is open and focussed. It does indeed work from the accounts page, both in the Action and the context menus. That's an oversight and should be fixed. Regards, John Ralls > On Oct 10

Re: [GNC] How to include images in the Wiki?

2022-10-10 Thread john
> On Oct 10, 2022, at 9:01 PM, Geoff wrote: > > So, how do I go about obtaining "uploadaccess", or finding a friendly and > patient Administrator to upload images on my behalf? Just ask! What's your wiki use

Re: [GNC] How to include images in the Wiki?

2022-10-11 Thread john
David, OK, done. Regards, John Ralls > On Oct 11, 2022, at 4:29 AM, David T. via gnucash-user > wrote: > > John, > > sunfish62 (that's me) is also asking for such access. > > On 10/11/2022 6:38 AM, john wrote: >> >>> On Oct 10, 2022, at 9:0

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread john
ard-coded some US stock exchanges--NYSE, NASDEX, AMEX, etc.as examples. We've found that to confuse a lot of users, making them think that those were the only choices, or that the categories had to be exchanges, so we removed them a few releases ago while working on something related. R

Re: [GNC] transaction images and failed hard drives

2022-10-14 Thread john
it can load http: or https: URIs. If you can run a local web server to serve the URIs you can use PHP to query a supported database for the desired image. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update you

Re: [GNC] Moving Securities from one Security Account to another

2022-10-14 Thread john
savings plan account and tell GnuCash to move the transactions to the regular account. You'll lose the history that the savings plan account existed but gain that all of the relevant transactions are visible in the regular account. Regards, John Ralls > On Oct 14, 2022, at 6:07 PM, R

Re: [GNC] Price database

2022-10-15 Thread john
to get the security's symbol and namespace and the currency's ISO-4217 code). Note that the actual price is saved in two fields, value_num and value_denom, that represents a fraction. Sqlite3 has a -csv option to output csv and a -o option to write a file. Regards, John Ralls >

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-16 Thread john
I've renamed that page to GnuCash SQL Examples. Regards, John Ralls > On Oct 15, 2022, at 11:54 PM, David T. via gnucash-user > wrote: > > Looks good. And this is definitely a better placement. Now, one wonders > whether the name of the page ("PostgreSQL- Req

Re: [GNC] [GNC-dev] Clear all OFX/QFX import associations

2022-10-16 Thread john
so it's also possible that that mapping got messed up by the CSV->OFX tool generated imports. You might try copying your GnuCash file and editing the copy to remove all of the online-id slots. Run xmllint on it when you're done to make sure that it's still well-formed and fix an

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread john
of a setup.exe being available is for 2.1.1 on 28 April 2007. Regards, John Ralls > On Oct 20, 2022, at 1:00 AM, Maf. King wrote: > > Just an observation, from the depths of history... > > IIRC, 2.3.x I think was a development series; unstable and for bug testing > and

Re: [GNC] Valuation of multi-currency accounts

2022-10-21 Thread john
transactions in a CAD book involving a USD brokerage account holding a US ETF, SPY, the general principles illustrated are widely applicable to multi-currency accounting. Regards, John Ralls > On Oct 21, 2022, at 5:49 AM, Patrick Pöndl wrote: > > I guess it always depends on what yo

Re: [GNC] Gnucash on MacOS 12.5 ?

2022-10-23 Thread john
on the Gnucash > site or in the text files that come with version 4.12. The only issue specific to Apple Silicon is that Finance::Quote doesn't work, see https://bugs.gnucash.org/show_bug.cgi?id=798456. Regards, John Ralls ___ gnucash-user ma

Re: [GNC] Gnucash on MacOS 12.5 ?

2022-10-24 Thread john
> On Oct 24, 2022, at 8:36 AM, David Reiser wrote: > >> >> On Oct 23, 2022, at 10:40 PM, john wrote: >> >> >> >>> On Oct 23, 2022, at 10:41 AM, Jesse Ayers wrote: >>> >>> I have been using GnuCash on Mac for several y

Re: [GNC] 4.12 ERROR: In procedure scm-error: no code for module (gnucash utilities)

2022-10-25 Thread john
cash You told CMake -DCMAKE_INSTALL_PREFIX=/opt. If you want GnuCash installed in /opt/gnucash then you have to tell cmake -DCMAKE_INSTALL_PREFIX=/opt/gnucash. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subs

Re: [GNC] Translation issues

2022-10-26 Thread john
formation at https://wiki.gnucash.org/wiki/Translation. Your issue is with other Hebrew translators, so the best thing to do is to comment on the strings that trouble you on Weblate. That way you can interact directly with the translators and per

Re: [GNC] Finance::Quote and TMX.pm

2022-11-12 Thread john
your modified TSX module to @MODULES in Quotes.pm and you've changed every instance of tmx to tsx as part of your modifications it should get added to the sources list from gnc-fq-check and enable the tsx item in GnuCash's security editor. Regards, John Ralls > On Nov 12, 2022, at 9

Re: [GNC] Finance::Quote and TMX.pm

2022-11-12 Thread john
Only if you fix it in your PR. Otherwise GnuCash needs to be updated to look for tmx instead of tsx. Regards, John Ralls > On Nov 12, 2022, at 2:23 PM, gnu Gord wrote: > > Thank you very much, that worked!! > I'm not sure how this is going to be dealt with if/when the repai

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread john
It is indeed a Gtk bug, https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320. Regards, John Ralls > On Nov 14, 2022, at 7:50 AM, Adrien Monteleone > wrote: > > I'm forever locked on Monterey so I can't test, and I don't see that problem > with Gnu

Re: [GNC] Find account on macOS Ventura

2022-11-14 Thread john
Find account works as expected for me on Ventura. Perhaps Alan can describe step-by-step what he's doing, what he expects at each step, and what actually happens. Regards, John Ralls > On Nov 14, 2022, at 10:46 AM, Adrien Monteleone > wrote: > > That is very odd indeed

Re: [GNC] compiled 4.12 get white background instead of green ruled. Also printable invoice is shown small scale.

2022-11-14 Thread john
> On Nov 14, 2022, at 3:40 PM, John Griessen wrote: > > This was compiled from the 4.12 tar.bz2 after checking the sha256sum on linux > mint 21 with guile 3.0. > > I tried this compiling since the 4.12 flatpak is not showing printable > invoice at all after a mint upd

Re: [GNC] Gnucash on macOS Ventura

2022-11-14 Thread john
> On Nov 14, 2022, at 4:07 PM, William Prescott wrote: > > I have 4-12.2 installed as wel That's interesting since I haven't built a 4.12-2 and MacPorts is still on 4.11. Are you sure you don't have GnuCash-Intel-4.12-1(2).dmg, which would just be another download o

  1   2   3   4   5   6   7   8   9   10   >