Re: [GNC] A way to disable autofill entries? or am I doing it wrong?

2018-08-16 Thread David T. via gnucash-user
For the first, see https://bugs.gnucash.org/show_bug.cgi?id=796734 . This explains the problem and a workaround. It sounds as if your second problem is related to https://bugs.gnucash.org/show_bug.cgi?id=796741

Re: [GNC] Column widths again

2018-08-16 Thread David T. via gnucash-user
Graham, If your problem is specifically that the Balance column is too narrow, then you’ve encountered a Known Idiosyncrasy: the Balance column is a challenge to resize. In fact, the only way I know to get it to resize is to double-click the column heading. This is documented in a note in the

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
Christopher, Is there some reason why the Transaction report doesn’t have the option to display as hyperlinks, as I see for accounts under the Balance Sheet report (Options->Display->Display accounts as hyperlinks)? Forcing a user to edit style sheets to achieve this in one report, while

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
not >>>> have to perform any additional driver installations when I choose either >>>> XML or SQLite. Your note that SQLite is also available in Windows makes it >>>> a clean sweep for availability by default. >>>> >>>> David >>>>

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
gt;>> On Aug 15, 2018, at 11:27 AM, Derek Atkins wrote: >>> >>> SQLite uses libdbi, too. >>> >>> -derek >>> >>> On Wed, August 15, 2018 1:49 pm, David T. via gnucash-user wrote: >>>> Here is a newer version of the table: >&

Re: [GNC] Installing F::Q on Ubuntu

2018-08-15 Thread David T. via gnucash-user
Tim, Numerous people have reported troubles using AlphaVantage to retrieve quotes recently, with several noting that the site appears to be unreliable (perhaps purposefully so). You don’t mention your GnuCash version; on GC3.2, there is supposedly a user preference slot for the AlphaVantage

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
As you note, backups are not a germane topic here. I will note that Section 2.6 of the Guide is titled “Backing Up and Recovering Data.” Perhaps that section could include further discourse on data backups. David > On Aug 15, 2018, at 3:04 PM, David Carlson > wrote: > > While file backups

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
> On Aug 15, 2018, at 1:35 PM, Adrien Monteleone > wrote: > > Looks pretty clear. > > Though I’m noticing sqlite does generate log files too. Note, these are > transaction replay logs from what I understand in case of a crash. As I > believe John Ralls noted, any of these past the last

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
XML or SQLite. Your note that SQLite is also available in Windows makes it a clean sweep for availability by default. David > On Aug 15, 2018, at 11:27 AM, Derek Atkins wrote: > > SQLite uses libdbi, too. > > -derek > > On Wed, August 15, 2018 1:49 pm, David T. v

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
Here is a newer version of the table: Storage Comparison Table XML SQLite MySQL PostgreSQL InstallationDefault Default libdbi libdbi File extension gnucash gnucash N/A N/A Additional software NoneNoneMySQL PostgreSQL Additional expertiseNoneNone

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
> On Aug 15, 2018, at 10:08 AM, Adrien Monteleone > wrote: > > >> On Aug 15, 2018, at 10:59 AM, David T. wrote: >> >>> >>> Additionally, the comparison table might serve better with each SQL backend >>> represented, since that’s the next question for someone contemplating that >>>

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone > wrote: > > But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain > text and trying to view it is going to be met with tag soup they’ve never > seen before and might very well not know how to read it. Not to mention

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
instance incurs. I am not sure how to include this, if not in the text of the Guide. While I see your point about summarizing this information, I must ask how (and where) we should address these other issues? David > On Aug 15, 2018, at 8:59 AM, David T. via gnucash-user > wrote: >

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
the biggest confusion for users on the mailing list is the > question: “Where is my data?”. Pointing out that all your accounts and > transactions are in a simple file might reduce that problem. > > Cheers, > Christoph > >> Am 15.08.2018 um 00:05 schrieb D

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-15 Thread David T. via gnucash-user
modification as well. > > Regards, > Adrien > >> On Aug 15, 2018, at 12:09 AM, David T. via gnucash-user >> wrote: >> >> Stephen, >> >> >>> On Aug 14, 2018, at 4:50 PM, Stephen M. Butler wrote: >>> >>> On 08/14/20

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
file immediately. This is in contrast to the XML back end, which only writes to the data file when the user invokes the Save command. ——— Better? David > > > Hope this helps. > > --Steve > >> >>> On Aug 14, 2018, at 3:50 PM, Stephen M. Butler wrote: >>

Re: [GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
more accurately reflect the direction that GC is headed? David > On Aug 14, 2018, at 3:50 PM, Stephen M. Butler wrote: > > On 08/14/2018 03:05 PM, David T. via gnucash-user wrote: >> Hello, >> >> In response to Bug 777893 (https://bugs.gnucash.org/show_b

[GNC] File Format Documentation (Bug 777893)

2018-08-14 Thread David T. via gnucash-user
Hello, In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 ), I have written a more detailed description of the storage choices available to users for insertion into the Tutorial & Concepts Guide at section 2.5. Given the

Re: [GNC] Column widths again

2018-08-13 Thread David T. via gnucash-user
Nope, that “feature” is still intact. The Tutorial & Concepts Guide notes this behavior at 2.3.3. To date, no developer has felt the need to change the behavior of the Description column, as idiosyncratic as it may be. Personally, I’d welcome a change to make this column behave as most users

Re: [GNC] Nabble Delay? (was Re: Future Payments)

2018-07-26 Thread David T. via gnucash-user
Huh??? Adrien, I do not use Nabble. Never have. Never will. I find everything about Nabble annoying.  One big issue with Nabble is that messages from people who use Nabble, but are NOT subscribed to gnucash-user get delayed in appearing on gnucash-user, since they must pass through the

Re: [GNC] Getting My Account To Trial Balance

2018-07-25 Thread David T. via gnucash-user
David, I imagine that the number of GnuCash users who only have accounts in a single currency (i.e., without any investments in stocks, mutual funds, or other commodities) is probably pretty small. For those who *do* have such holdings, a balanced transaction will still fail the trial balance

Re: [GNC] How to change the order of the account list in pul

2018-07-20 Thread David T. via gnucash-user
Roger,  The OP indicated that they were interested in changing the sort order of drop down lists. Your method does nothing for drop down lists.  Embedding the sort code in the account name itself fixes the drop down list sort order.  David On Fri, Jul 20, 2018 at 12:10, Roger Oliver

Re: [GNC] How to change the order of the account list in pul

2018-07-17 Thread David T. via gnucash-user
Of course, one could embed prefixes in account names to force a particular sort order,  e.g., "1.0 Assets" "2.0 Liabilities" "3.0 Expenses", etc. David On Tue, Jul 17, 2018 at 10:55, Adrien Monteleone wrote: They should be sorted by alpha. I’m not sure you can change that. (easily) I

Re: [GNC] Future Payments

2018-07-14 Thread David T. via gnucash-user
Not that I know of. You can either post date a real transaction, or create a scheduled transaction, which will create a real transaction N days before the scheduled date. David T.  On Sat, Jul 14, 2018 at 10:53, adb34 via gnucash-user wrote: I guess there must be another way? --

Re: [GNC] Why duplicate reports in 3.2?

2018-07-12 Thread David T. via gnucash-user
As I understand it, the two menu items call the same report file with different title flags, so there is no overhead in storage or codebase. Your concern boils down to the fact that both names appear in the menu.  While this is annoying, it has come up on the lists before that a person has

Re: [GNC] Dock Icon on Mac

2018-06-13 Thread David T. via gnucash-user
My dock works, and has worked for a decade. Perhaps you are using GnuCash from two places: Applications, and the dmg? I say this because the “?” could happen after restart if the dock item were linked to a dmg file, and the dmg weren’t reloaded on restart. Similarly, a second dock item would

Re: [GNC] Ubuntu 18.04

2018-06-12 Thread David T. via gnucash-user
David, The main wiki page has limited edit access, but https://wiki.gnucash.org/wiki/Installation would be a good place to hook build instructions into. David T. > On Jun 12, 2018, at 3:19 AM, DaveC49 wrote: > > Hi Geert, > > I think one of

Re: [GNC] Profit and Loss Spreadsheet

2018-06-03 Thread David T. via gnucash-user
Indeed. And once your data are in a spreadsheet, you can run all sorts of sophisticated functions on it. ;) David > On Jun 3, 2018, at 10:07 AM, Adrien Monteleone > wrote: > > John, > > I’ll have to interpret a bit, but my guess is you want a report that shows > multiple months worth of P

Re: [GNC] pros/cons of storage formats

2018-05-17 Thread David T. via gnucash-user
And, as I noted in January, the sql format does not get compressed, so the files are much larger.  On Thu, May 17, 2018 at 10:37, Adrien Monteleone wrote: Keith, The SQL backends are having a few issues at the moment. It would be a good idea to search

Re: [GNC] pros/cons of storage formats

2018-05-16 Thread David T. via gnucash-user
Keith,  I'm not sure how you looked,  but this topic had been discussed for many years on the list. A recent one was  https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074315.html. Another was  https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050410.html. David

[GNC] Keybindings Mac OSX GC 2.6.19

2018-05-12 Thread David T. via gnucash-user
Hello, I don’t know if I am going crazy, but I thought that GnuCash used typical Mac key bindings (CMD-S, CMD-P, etc.). In the last few weeks, though, most of these key bindings use the CTRL key. Although I haven’t changed 2.6 in a while, I have downloaded and run 3.1 (without saving

Re: [GNC] Handling VISA Debit Accounts

2018-05-07 Thread David T. via gnucash-user
In my experience (admittedly limited), a debit card is a means to extract funds from an account—not an account on its own. Considered this way, it is simply a variant of a check, or of writing a withdrawal slip and handing it over to a teller (for those who remember those days). There is no

[GNC] Problem with Saved Reports

2018-05-07 Thread David T. via gnucash-user
Hello, I have encountered now a couple of times the unpleasant experience of calling up my saved reports configurations, only to find all but 5 or 7 completely gone. When I examine the saved-reports-2.4 file stored on my hard drive, it has been reduced in size to about 30k. This has happened

Re: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

2018-05-06 Thread David T. via gnucash-user
Sorry I’ve been delayed in responding. I’ll try to reply to the various suggestions. Adrien: The COA is perfectly fine, except that it’s not possible to embed the one figure in a multi-column report, so that doesn’t work for me. As for what I had in 2.6.19, I included verbatim what I have had

[GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

2018-05-02 Thread David T. via gnucash-user
Hello, Before I submit a bug report, I’d like to see whether there has been some change to the reports system that causes the degradation I am seeing, and if there is a different way to achieve my same goal. I have a custom report that is set to display a single figure for YTD totals for a

Re: [GNC] .log files with sqlite backend

2018-04-18 Thread David T. via gnucash-user
Alen, I think you have identified a potentially significant issue with log files and sql data files.  Specifically, with xml files, full snapshots are saved periodically, and log files are paired with these snapshots to enable a user to "replay" actions to recover a previous state.  It is

Re: [GNC] Enabling MySQL on Mac

2018-04-11 Thread David T. via gnucash-user
Whistler,  You DO realize that you are responding to a message from 2011, right?  As John Ralls wrote back then, those who wish to use mysql as their back end should be ready and comfortable with being database managers. Trained db admins should be undaunted with the installation and setup steps

Re: [GNC] future of custom reports in 3.x

2018-04-10 Thread David T. via gnucash-user
Or consult https://wiki.gnucash.org/wiki/SQL and https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png David T. > On Apr 10, 2018, at 8:45 PM, Amish wrote: > > May be

Re: [GNC] Addition of Mailing List Subject Prefix

2018-04-10 Thread David T. via gnucash-user
Hello, I am responding to the original email because there have been quite a few responses to this thread. I have tallied up the responses regarding subject prefixes thus far, and it appears that 7 people are in favor of this change. In contrast, 20 people (including three of the development

Re: [GNC] 3.0 UI broken under W8.1

2018-04-09 Thread David T. via gnucash-user
Are you saying it doesn’t behave according to Section 2.3.3 of the Tutorial and https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F

Re: [GNC] GnuCash > 2.6.16 Reports crashing

2018-04-07 Thread David T. via gnucash-user
John, If the user is on Windows, could this be a matter of the "Initial Report Taking Forever" bug? > On Apr 8, 2018, at 8:25 AM, John Ralls wrote: > > > >> On Jan 7, 2018, at 5:23 PM, Ron Burek wrote: >> >> I am currently using ver. 2.6.12 and

Re: [GNC] GNC Addition of Mailing List Subject Prefix

2018-04-07 Thread David T. via gnucash-user
[GNC] +1 to this and to Frank’s objections. [GNC] I find such prefixes exceedingly annoying. [GNC] And making the change because of one or two people’s preference is rather autocratic. [GNC] David T. [GNC] See what I did there? [GNC] :) > On Apr 8, 2018, at 6:03 AM, Dave H

Re: Importing Quicken

2018-04-04 Thread David T. via gnucash-user
When I did my import (over a decade ago, I believe), I had no problem with transfers. Since I was importing all in one pass, there were no duplicates created by transfers. I believe the duplication problem you describe specifically arises when you opt to import transaction data from

Re: Importing Quicken

2018-04-04 Thread David T. via gnucash-user
Alen, What you’ve done with the Benefits section is better, but I still feel that any mention of benefits of migration is misplaced here. Someone looking for ways to migrate from Quicken presumably has already come to this conclusion. * I have edited the tips portion further. I added a tip

Re: Importing Quicken

2018-04-03 Thread David T. via gnucash-user
cicko, I also like what you’ve done. I will add some edits there. Personally, I think the “Benefits” section is pointless; this page is about the migration from Quicken—not why someone should use GnuCash. I would recommend deleting it altogether, but I defer to you, since you created it. You

Re: Unrealized loss

2018-04-02 Thread David T. via gnucash-user
Alain, Your new transaction is balanced, and won't affect the imbalance in another transaction.  I personally find the unrealized gains issue to be exceedingly difficult to understand. Since you say you don't care about this, just ignore it.  David T  On Mon, Apr 2, 2018 at 17:02,

Re: Date limit on transactions / freezing transactions

2018-03-23 Thread David T. via gnucash-user
Stan,  There is a setting that might help you: File->Properties->Day threshold for read-only transactions  I'm not sure whether it will help in your use case, but it's worth mentioning.  On a side note, I recall you saying you are planning to merge these two files at a later date. Do you have

Re: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use

2018-03-17 Thread David T. via gnucash-user
Folks,  Thus is no longer a thread about gnucash. Perhaps you could take it to another venue.  David T. On Sat, Mar 17, 2018 at 20:57, Adrien Monteleone wrote: Avoiding updating the kernel can leave you with security vulnerabilities. Last summer there was a

Re: General Ledger

2018-02-23 Thread David T. via gnucash-user
Try https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html "The General Journal defaults to showing only the previous month of transactions. This is changeable by using the "Filter By..." on the View menu."

Re: QFX Import and Reconciled Transactions

2018-02-16 Thread David T. via gnucash-user
RW, The QFX specification includes an ID field against which gnucash matches. If subsequent imports keep trying to match existing transactions, it may be that your bank is reusing the IDs. This has been seen before.  David On Fri, Feb 16, 2018 at 14:59, R

Re: Capital Gains posting in newly imported data from quicken

2018-02-14 Thread David T. via gnucash-user
snrm, It has been a long time since I migrated from Quicken, but I know that my biggest headaches came from how Quicken did (or didn't) handle gains.  That said, gnucash includes a lot management tool that you can use to generate gains transactions. It is far from perfect, however. For example,

Re: Installation

2018-02-12 Thread David T. via gnucash-user
Adrien,  Log files have to be visible to the user, so that when they have to recover from an error state in their files, they can use them to restore.  David On Tue, Feb 13, 2018 at 9:05, Adrien Monteleone wrote: It would seem to me the ‘cleaner’ option to

Re: GNUCASH Free Accounting Software

2018-02-08 Thread David T. via gnucash-user
Or run a transaction report and set the dates accordingly. > On Feb 9, 2018, at 5:20 AM, David Carlson wrote: > > If you want to do a register report for a certain time range open the > register window and choose View > Filter by.. > Date to select your time >

Re: Cash Flow View

2018-02-08 Thread David T. via gnucash-user
Matt, The wiki can always use help, so thank you! I think your approach makes sense. I will note that there already is a set of installation pages, and it may be most useful simply to move the relevant questions and answers to them. I suspect that there are similar overlaps in other areas of

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
shudders*)? David > On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user > <gnucash-user@gnucash.org> wrote: > > Unfortunately, adding these lines to my config.user did not result in any > further information. I am stumped, and disappointed. > > > It se

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Unfortunately, adding these lines to my config.user did not result in any further information. I am stumped, and disappointed. It seems that an upgrade of GnuCash not only tanks one’s customized environment file in the application bundle (understandable), but also any additional files that a

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Reiser <dbrei...@icloud.com> wrote: > > >> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user >> <gnucash-user@gnucash.org> wrote: >> >> In thread >> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html >> <

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
at startup before the F::Q note... > On Feb 8, 2018, at 9:33 PM, John Ralls <jra...@ceridwen.us> wrote: > > > >> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user >> <gnucash-user@gnucash.org> wrote: >> >> In thread >> https://lists.gnuca

Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
In thread https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html , I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac (OS X 10.13.3), Price retrieval was failing with the

Re: Online quotes fetching the wrong price

2018-02-08 Thread David T. via gnucash-user
Justin, I see the same command line result. I will note that the date listed there is for 2017 (mine is the same), which suggests something is out of whack. Looking online, I see that NAB was at 33.14 on 03/13/2017, so that doesn’t work. I’ve tried various versions of the exchange (ASX, ASE,

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread David T. via gnucash-user
Roger,  You stay by stating that you are able to generate a report that tells you "the current value of everything."  Then, you ask how you can add another layer of complexity to accomplish the same thing? I don't understand: what's wrong with the report?  David On Thu, Feb 8, 2018 at

Re: Please remove me from the mailing list

2018-02-03 Thread David T. via gnucash-user
Liz, Looks good. Just a brief question on terminology: I had never heard the term “reflector” used for these sites. It’s always been called a “mirror.” Which is considered the proper term for these? David > On Feb 3, 2018, at 11:18 AM, Liz wrote: > > On Wed, 31 Jan 2018

Re: Need help with opening my Gnucash software

2018-02-02 Thread David T. via gnucash-user
Rick, It is far easier for the OP simply to click the “Close” button (which continues starting GnuCash, but without loading the missing file) and then using the GnuCash File->Open command to locate their file. David > On Feb 3, 2018, at 11:10 AM, Rick Copple

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-31 Thread David T. via gnucash-user
Matt,  I have to admit that I misread the tally; I did not see that the first $500 (AllocatedCash) was balancing the others. My apologies.  I'll let you and Adrien work this out, since I don't have a lot of background in this.  David On Wed, Jan 31, 2018 at 8:58, Matt

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-30 Thread David T. via gnucash-user
Matt, I see one huge problem: where are you balancing the funds for the allocated accounts? They need balancing, and once you add something to balance them, you might as well male them Subaccounts of checking anyway.  Cheers,David  On Wed, Jan 31, 2018 at 4:06, Matt

Re: Please remove me from the mailing list

2018-01-30 Thread David T. via gnucash-user
We have spent a heck of a lot of bandwidth on this topic, and we seem to do so every time someone sends one of these unsubscribe requests. I personally agree with Derek that it is a hopeless and thankless task to account for all the possibilities, and I would rather find a different solution

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread David T. via gnucash-user
Sebastien, The problem isn’t with Python (I am told that Macs already have Python on them). The problem as I understand it (John will no doubt correct me when my statements prove ill-informed or flat out wrong) has to do with the fact that GnuCash requires a specific version of Python, which

Re: Reports very slow to open

2018-01-23 Thread David T. via gnucash-user
Yes.  https://bugzilla.gnome.org/show_bug.cgi?id=790789 On Wed, Jan 24, 2018 at 11:37, David Carlson wrote: OK, I missed the reference.  Has a bug been submitted? David C On Wed, Jan 24, 2018 at 12:32 AM, David T. wrote: David, 

Re: Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user
at 10:25 PM, david amaral <dejama...@yahoo.com> wrote: > > Verify security editor for your investments have get quotes checked > and AlphaVantage  listed as source for each entry. > > > > From: David T. via gnucash-user <gnucash-user@gnucash.org> > To: Gnucash Us

Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user
Hello, I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the Alphavantage key, added the same key to /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed all my

Re: Money Market Accounts

2018-01-22 Thread David T. via gnucash-user
Hello,  I think you have two options, depending on your preference.  1) Use the parent brokerage account to hold these funds. This works best when the funds are basically just held by the brokerage until they can be transferred to another asset. 2) Create a separate subaccount for them.  This

Re: info about action field in double-line view

2018-01-22 Thread David T. via gnucash-user
Geert, What is the current status on the File Association feature set? I know that there was a wave of activity a few years back when the feature was first added, but I haven’t seen anything about it since. My recollection of the traffic at the time was that it had potential to be very useful,

Re: Gnucash freezes while loading data

2018-01-21 Thread David T. via gnucash-user
Those don’t sound like large files, so it sounds like there might be something wrong. Do they ALL hang, or only some of them? I will admit that I am not one to advise on importing, as I don’t do it much. That being said, I would take a close look at the source files—especially the date

Re: Filtered account report

2018-01-16 Thread David T. via gnucash-user
Sure. I understand. My experience with my own accounts was different (even with multiple loans over multiple years). Personally, I find the burden of changing transactions--evens hundreds of them--to be minor.  And the results have been consistent and reliable ever since. But you do what you

Re: Year end issues

2018-01-15 Thread David T. via gnucash-user
No, there isn’t. The Close book feature simply creates a transaction that zeroes out your income and expense accounts as of a given date. In a double entry accounting system, if you delete the expense side of the transaction, what do you suggest doing for the Checking account side? If you are

Re: How to deal with RRSP's (Canada)

2018-01-05 Thread David T. via gnucash-user
that is earned in 2017, but which is counted as taxable income only in 2035? Cheers, David > On Jan 5, 2018, at 7:42 PM, Mike or Penny Novack > <stepbystepf...@dialup4less.com> wrote: > > On 1/5/2018 1:05 AM, David T. via gnucash-user wrote: >> David— >> >

Re: How to deal with RRSP's (Canada)

2018-01-04 Thread David T. via gnucash-user
David— I see where you are coming from on this. For reference, I accept your 5 assumptions; I believe they are accurate for many US retirement accounts as well. The Income/Equity splits in Cam’s example are a mechanism that allow distributions to appear as income on reports, without

Re: Re: finance-quote error

2017-12-27 Thread David T. via gnucash-user
Ismael, You will generally get better results sending requests to the list, for a number of reasons.  First, you will get advice from the combined group knowledge. This is especially helpful in this case because I don't know a heck of a lot about F::Q. Second, normal list etiquette is not to

Re: Reports Not Responding Windows 10

2017-12-22 Thread David T. via gnucash-user
I had to check on my own machine (Mac OS X 10.11.6 GC 2.6.14), but there are no delays here. I had to check because, for me, the first report is always run at startup, when I am not really paying attention. If the problem really is a delay on the first-run report only, perhaps a workaround

Re: A BASH script to help get tax-related data from gnucash

2017-12-16 Thread David T. via gnucash-user
I’m sorry. Your original characterization was vague, and I didn’t understand what your issue with that report was. I see what you are noting, although it’s not something that bothers me. FWIW, I would probably dump the report into a spreadsheet and munge the data there if the redundancies were

Re: A BASH script to help get tax-related data from gnucash

2017-12-15 Thread David T. via gnucash-user
If you have set the accounts as tax-related, why wouldn't you use the Tax Schedule Report?   This works rather well, especially if you assign specific tax lines to your accounts. See chapter 10 of the help for detailed instructions.  David On Fri, Dec 15, 2017 at 13:17,

RE: finance-quote error

2017-12-15 Thread David T. via gnucash-user
Are you sure your alphavantage key is properly set in your environment?  David On Fri, Dec 15, 2017 at 13:12, batwell wrote: I am still having problems after updating to 1.47.  I have not found any source that returns a usable response. Any Idea what I am doing

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread David T. via gnucash-user
So, that sounds like a problem with a change in locale settings, and not a problem with Sierra.  I doubt the original poster is encountering the same problem as you.  David On Wed, Dec 13, 2017 at 16:39, Pam Dooner wrote: yes, definitely 2.6.18. Just tried again and

Re: Report error An error occurred while running the report.

2017-12-13 Thread David T. via gnucash-user
Are you sure that there are any transactions for the period you selected? I'm not certain, but I believe that an empty return set gives this. This is an unfortunate communication.  David On Wed, Dec 13, 2017 at 13:18, Dane Dormio wrote: I am running the latest

Re: GnuCash: Docs: Where to document?

2017-12-11 Thread David T. via gnucash-user
Chaz, Seems like that sort of write up might go on the wiki. I'll note that neither python nor the sql aspects of gnucash are consistently available to the average user, so your write up may have limited utility. Python is only available to Mac users if they compile gnucash themselves, for

Re: Cannot edit opening balance

2017-12-11 Thread David T. via gnucash-user
I would suggest reading section 4.4 of the tutorial, where the issue regarding handling starting balance problems is addressed directly.  David On Mon, Dec 11, 2017 at 11:48, John R. Sowden wrote: My suggestion is to never use the opening balance in an

Re: gnucash file could not be found

2017-12-07 Thread David T. via gnucash-user
Mike, GnuCash automatically attempts to open the last file you used, even if that file is no longer where GnuCash thinks it is. Moreover, on Macs, GnuCash tries to open that last file *even if you double click on another GnuCash file from Finder.* The workaround is that you use File-> Open to

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
You should have a file named “mydata.gnucash” (where “mydata” is whatever you called it. That’s your data file. The other is a log of changes since your last save. You can go to the wiki page I referenced and learn all about Gnucash’s various files. David T. > On Dec 3, 2017, at 12:31 AM,

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
John, Glad to hear. Just as a final note: the files in your home folder aren’t “backups.” They are your actual data files. If you want backups, you’ll have to make them yourself. David T. > On Dec 2, 2017, at 11:53 PM, John Donnee wrote: > > I dragged the application to

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
John, You don’t say what you did when you downloaded “the latest version” (presumably 2.6.18, yes?). Once you downloaded it, did you open the dmg file and drag Gnucash.app into your applications folder? I ask this because you say there are two Gnucash apps in Applications. As the different

Re: Accounts Capicity

2017-12-01 Thread David T. via gnucash-user
Bevan, I haven’t heard of anyone “exceeding capacity,” so I doubt that is your problem. What operating system, what version of GnuCash? Has anything else changed on your system? At what point do you discover you can’t enter data? David > On Dec 1, 2017, at 9:39 AM, Bevan Twidale

Re: recover GNUcash data after windows crash

2017-11-27 Thread David T. via gnucash-user
Ian, Gcm files are not your data files. They are metadata files. Similarly, the “.gnucash” folder is the system folder that holds this metadata. Your data files (AccontsBusiness.gnucash and Personal.gnucash) are somewhere else on your backup. Put those on your new machine (not in the “.gnucash

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-25 Thread David T. via gnucash-user
John, I know you and the other developers are doing huge service to the rest of us with your work. I truly wish I had the skills that allowed me to help with this; years of attempts have shown me that this is beyond me, however. Thank you all. David > On Nov 25, 2017, at 9:32 PM, John Ralls

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-23 Thread David T. via gnucash-user
This has long been an issue with GnuCash on the Mac, such that most of us have simply gotten used to it. I will add something to the wiki FAQ shortly. It has been entered as a bug (https://bugzilla.gnome.org/show_bug.cgi?id=761024 ), so it has

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-23 Thread David T. via gnucash-user
John, GnuCash on the Mac ALWAYS opens the last file it had open—even when you double-click on another GnuCash file. This is a long-known issue with how the Mac handles the GnuCash startup. File->Open will get you to your second set of accounts. David > On Nov 24, 2017, at 8:00 AM, John

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David T. via gnucash-user
I’ll assume that you mean /Applications/Gnucash.app/Contents/Resources/environment (note the lower case ‘e’; case matters in MacOS). If not, then that will be the problem. To run gnc-fq-dump, you need to be in /Applications/Gnucash.app/Contents/Resources/bin David > On Nov 12, 2017, at 7:10

Re: API Key

2017-11-10 Thread David T. via gnucash-user
Les, Dave, Thanks for airing this out a little more. I had not succeeded in getting this to work, mostly because I didn’t understand the FAQ, which tells us to add the environment key to "/etc/gnucash/environment where prefix is:” in one spot, and then says

Re: Finance-Quote 1.44 released!

2017-11-09 Thread David T. via gnucash-user
Does the TIAA-CREF module not work? David > On Nov 9, 2017, at 7:31 PM, davel...@mac.com wrote: > > >> On Nov 9, 2017, at 4:46 AM, Erik Colson wrote: >> >> >> davel...@mac.com writes: >> >>> Thanks for all your work on this. A symbol I cannot get to work is QREARX >>> (a

Re: F::Q 1.40 uploaded

2017-11-08 Thread David T. via gnucash-user
If I were going to try to change all my quote sources quickly, I would do it with SQL. ! NOTE THAT THIS SUGGESTION IS NOT/NOT PROMOTED BY THE DEVELOPMENT TEAM BECAUSE IT CHANGES YOUR DATA FROM OUTSIDE THE GNUCASH API!! !!! USE AT YOUR OWN RISK 1) Make a

RE: Can gnucash add Virtual currency?

2017-11-08 Thread David T. via gnucash-user
Technically, adding bitcoin as a security isn't the same as adding it as a currency,  which the OP requested.  Gnucash bases its currencies list on the ISO standard, which does not include bitcoin. That said, treating it like any other commodity should work, except that the ongoing valuation

<    1   2   3   4   5   6   7   >