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

For what it’s worth, I was able to execute “sudo pip install piecash” successfully, but there is a gap for me at this point: what next? Is there a python shell? Am I supposed to write a script file (and once written, would I use some python command to run it? Which command?)? What, exactly, did

Re: Please remove me from the mailing list

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 tha

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

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 Graham  [Snip]If, rathe

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

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 Graham wrote: #yiv

Re: Need help with opening my Gnucash software

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 > wrote: > > On 02/02/2018 07:57

Re: Please remove me from the mailing list

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 20:23:21 + > Ma

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

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 16:1

Re: Online quotes fetching the wrong price

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, A

Price Retrieval Failure, Part 2

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 gene

Re: Price Retrieval Failure, Part 2

This appears at startup before the F::Q note... > On Feb 8, 2018, at 9:33 PM, John Ralls wrote: > > > >> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user >> wrote: >> >> In thread >> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074

Re: Price Retrieval Failure, Part 2

> 100-plus securities is set to Alphavantage. > > I think that tomorrow, when I have a little time, I'll create a small test > file with one security in it, and see what happens. > > Thanks, > David > > On February 8, 2018, at 10:07 PM, David Reiser wrote: >

Re: Price Retrieval Failure, Part 2

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

shudders*)? David > On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user > wrote: > > 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 onl

Re: Cash Flow View

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 th

Re: GNUCASH Free Accounting Software

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 > window then select Reports > Accoun

Re: RFP: Generic Comparison Report

Chris, I think that users would like to know what is happening on this front. Users are very interested in these developments, and there are far more readers on users, who may have additional suggestions for use-cases and features. Given the fact that there are current threads on the user list

Re: gnucash-user Digest, Vol 179, Issue 34

; >>> -- >>> >>> Message: 5 >>> Date: Fri, 9 Feb 2018 14:38:33 -0600 >>> From: Adrien Monteleone >>> To: "gnucash-user@gnucash.org" >>> Subject: Re: Duplicating Accounts? >>> Message-ID: &

Re: Installation

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 store the log and lock files i

Re: Capital Gains posting in newly imported data from quicken

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, w

Re: QFX Import and Reconciled Transactions

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 Winstead wrote: David, Thanks f

Re: General Ledger

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: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use

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 bluetooth vulnerability that

Re: Date limit on transactions / freezing transactions

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 any

Re: Unrealized loss

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, cag...@f

Re: Importing Quicken

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: Importing Quicken

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 rega

Re: Importing Quicken

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 individual

Re: Unrealized loss

I surmise from the OP that there ARE buy/sell transactions, based on the comment, "I do not enter share values into GC until the day I sell them," which was made early in the thread.  I agree that details are lacking, and I apologize for the miscommunication regarding bugs. As I don't fully unde

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

[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 wrote: > > I'd

Re: [GNC] GnuCash > 2.6.16 Reports crashing

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 decided to upgrade to 2.6.19 on Win 10 >> Pro

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

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] Addition of Mailing List Subject Prefix

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 t

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

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 fastest and easiest way

Re: [GNC] Enabling MySQL on Mac

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] Enabling MySQL on Mac

ards, > John Ralls > > >> On Apr 11, 2018, at 6:25 AM, David T. via gnucash-user >> mailto:gnucash-user@gnucash.org>> wrote: >> >> Whistler, >> You DO realize that you are responding to a message from 2011, right? >> As John Ralls wrote back th

Re: [GNC] .log files with sqlite backend

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 unclea

Re: [GNC] How do you edit the defaults for new account creation?

John, It’s not entirely clear what you’re asking for. It sounds as if you want to create year-based account trees within your main GnuCash data file. IOW: Assets:Checking:2017 Assets:Checking:2018 Assets:Investment:2017 Assets:Investment:2018 or perhaps: Assets:2017:Checking Assets:2017:Invest

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

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 sub

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

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 i

[GNC] Problem with Saved Reports

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 no

Re: [GNC] Handling VISA Debit Accounts

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 need

[GNC] Keybindings Mac OSX GC 2.6.19

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 anything),

Re: [GNC] pros/cons of storage formats

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 O

Re: [GNC] pros/cons of storage formats

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 the list here and also to look ove

Re: [GNC] Profit and Loss Spreadsheet

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&L

Re: [GNC] Ubuntu 18.04

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 the

Re: [GNC] GC keeps prompting me to create an account and it just won't away

It looks as if Art has entered descriptive information into an account field. GnuCash will always ask if you want to create the nonexistent account (that’s a feature, BTW). Based on the sample string, you’d need to tab out of the account after “bananas”, put “Hot dog” in a memo (presumably), and

Re: [GNC] Dock Icon on Mac

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 s

Re: [GNC] Why duplicate reports in 3.2?

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 expe

Re: [GNC] Future Payments

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? -- Se

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

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 ha

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

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 wrote:

Re: [GNC] Getting My Account To Trial Balance

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] Nabble Delay? (was Re: Future Payments)

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 moderat

Re: [GNC] Column widths again

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 h

[GNC] File Format Documentation (Bug 777893)

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 e

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

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

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

the 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: &g

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

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)

e 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 David T. via

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

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)

> 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 th

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

> 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 >>> route.

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

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 expertiseNoneNoneDB

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

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)

> 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 succ

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

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 ar

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

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 AP

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

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] File Format Documentation (Bug 777893)

>>>> 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] Next release of F::Q

Erik, Thanks for the update—and for your ongoing work to manage this unwieldy beast for the community! David T. > On Aug 16, 2018, at 2:20 AM, Erik Colson wrote: > > Hello all, > > I'm on some extended vacation and will be back home next week. My > intent is to release F::Q from master at t

Re: [GNC] Links in transaction reports

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 offe

Re: [GNC] Column widths again

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 G

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

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

[GNC] File Format Documentation, v. 2

I’ve attempted to incorporate the suggestions that others have made for the section on file storage formats, and I attach the resulting version 2 for further consideration. Keep in mind that this is not meant to be an encyclopedic coverage of the topic; it’s meant to outline the choices. I expec

Re: [GNC] File Format Documentation, v. 2

rn?  David On Thu, Aug 16, 2018 at 18:53, John C wrote: Please tell the reader the default file format right after installation. regards, John On 8/16/2018 5:06 PM, Adrien Monteleone wrote: > Looks good to me. > > Regards, > Adrien > >> On Aug 16, 2018, at 3:00 PM, David

Re: [GNC] Links in transaction reports

I don’t understand your assertion that this would be an “incompatible change of options.” The option to remove hyperlinks is available on the Balance Sheet, but not on the Transaction Report. What about that is incompatible? If I were going to put the option anywhere, I’d put it in the same plac

Re: [GNC] Links in transaction reports

Well, that certainly puts kinks in the hose! > On Aug 16, 2018, at 11:06 PM, Christopher Lam > wrote: > > From my understanding, adding an option to the 3.x series means that anyone > who upgrades to 3.3, creates a saved-report, and downgrades to 3.2 will > suddenly find the saved-report will

Re: [GNC] Column widths again

ys off screen. > > Cheerio > > Graham > > On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H, <mailto:gti90...@gmail.com>> wrote: > Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user < > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>> escreveu:

Re: [GNC] Report: single expense account

Try: 1) View->Filter By 2) Set Start and End Dates 3) Account Report Cheers! David P.S. - Don’t forget to re-set your View settings afterward! > On Aug 18, 2018, at 10:35 AM, Rich Shepard wrote: > > I would like to print a report for a single expense account listing > transactions and total

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

Dan, You are not alone with this problem; numerous users have lamented the ongoing saga of retrieving commodity prices online since Yahoo! decided to pull the plug on its quote system. AlphaVantage has been the solution that everyone here flocked to, and now AlphaVantage is altering its enforce

Re: [GNC] macOS gnc 3.2

Just note that if you use 3.x and go back to 2.6.x, the program and your data will still work together, but your key bindings will get changed (Command-S will be Ctrl-S, etc.). It’s a little disconcerting at first. > On Aug 27, 2018, at 4:00 PM, John Ralls wrote: > > It's a personal decision b

[GNC] Using CSV Importer and Google for Commodity Prices

Hello, I, like many others, have encountered numerous headaches over the last year due to the turmoil around retrieving commodity price quotes. I appreciated being able to retrieve prices on an occasional basis and see, broadly speaking, how my holdings were performing. I bemoaned the loss of Y

Re: [GNC] macOS gnc 3.2

I never noticed them change. Since moving to 3.2 I haven’t > tried a 2.6.x version again. > > Regards, > Adrien > >> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user >> wrote: >> >> Just note that if you use 3.x and go back to 2.6.x, the program an

Re: [GNC] GC 3.2 Import Price File CSV

Geert, I have filed Bug 796833 with both a short csv file from my copy of Excel, and a screenshot of the importer result. Cheers, David > On Aug 29, 2018, at 8:45 AM, Geert Janssens > wrote: > > If you can provide a sample file which you have verified to fail, we may be > able to debug it.

Re: [GNC] GC 3.2 Import Price File CSV

Geert, Thanks for looking into this and coming up with a fix. Just out of curiosity, what is the fix that you’ve put in? Cheers, David > On Sep 4, 2018, at 5:34 AM, Geert Janssens wrote: > > Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user: >> Tried TextEdit. It

Re: [GNC] Chart of Accounts sort order in v3.2 - Help

Alan, > On Sep 4, 2018, at 9:05 AM, Alan Maddocks wrote: > > Hi David, > > Thank you for your prompt reply to my query. > > I can add account codes and sort on them. However, that involves a certain > amount of additional work which wasn’t necessary previously. > > I just don't understand

Re: [GNC] GAU as currency

I am not an expert, but my understanding is that the currency codes are derived from the ISO standards. GAU isn't among those. David On Thu, Sep 6, 2018 at 12:19, Muhammad Bashir Al-Noimi wrote:   Hi,   How can use GAU (gold gram) as a currency in GNC instead of XAU (gold   ounce)?   I'm

Re: [GNC] GAU as currency

Of course, Michael, you are right--except for the fact that the ISO currency codes include entries for gold, silver, as well as one or two others, which is what I was referring to. I was anticipating Muhammad's next question. Muhammad, there won't be any way for you to obtain daily prices for a g

Re: [GNC] Reconciliation Question

Assuming that everything else is reconciled,  all you really need to do is add the missing transactions and re-reconcile. Ignore the starting balance, and enter the same closing balance as your last statement.  Those three items will appear in the reconciliation window,  you check them off,  and

Re: [GNC] register columns

Jim, The short answer is “No, the columns are hard-coded.” If you wanted to change the order, you could, but you’d need to rewrite the code and compile from your modified source. David > On Sep 10, 2018, at 11:24 AM, JIM <9031jbk...@att.net> wrote: > > Is there some way I can change the col

[GNC] Date Picker Info

Hello, In the course of looking at documentation improvements, I happened to look at the program code for the date cells in GnuCash, and I discovered that there are several quick keys for setting the date that I was unaware of, and I thought I’d share with the list. Most of us know about using

Re: [GNC] Advanced Portfolio Report - Fund managment fees

While I have no comment on how to get the Advanced Portfolio Report to categorize your fees as such, I will note that when you sell a commodity—regardless of the reason for which you sell it—you will have (in most cases) a capital gain element. The gain is there, even if you immediately turn th

Re: [GNC] FinanceQuote install broken on OSX

Take a look at two questions in the FAQ at https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F Are you using Yahoo!? Do you have an Alphavantage API key? The executables for terminal use are embedd

Re: [GNC] Advanced Portfolio Report - Fund managment fees

Whether a gain is taxable or not is a separate issue from whether a sale results in gain, and the usual way (AFAIK) of handling taxed versus untaxed anything is to have separate accounts for each (Income:Realized Gains:Taxable and Income:Realized Gains:Untaxed). Does creating a transaction that

Re: [GNC] Error importing quicken 2017 qif / qfx

I think it’s a little premature to refer to this bug. It’s not clear that the OP has determined that the content of their QIF file is properly structured and being properly interpreted by the GnuCash importer—and that is a more profitable avenue for them to explore at this time. The bug to whi

Re: [GNC] Error importing quicken 2017 qif / qfx

Hello, In fact, the error is quite clear: something in the QIF file is not as the importer expects. As another David has noted, the QIF importer itself is functional, and has worked for many users before you. Unfortunately, in this case, that erro message is not particularly helpful, as your QI

Re: [GNC] Omission from help manual: formulas

Stan, I neither use formulas nor scheduled transactions, so I can’t comment on the documentation. Since you do, maybe you could add some information on the wiki to assist others after you? > On Sep 17, 2018, at 8:05 AM, Stan Brown wrote: > > Thank you for the reply, Frank, but I read that be

Re: [GNC] Omission from help manual: formulas

17, 2018, at 8:37 AM, David T. via gnucash-user > wrote: > > Stan, > > I neither use formulas nor scheduled transactions, so I can’t comment on the > documentation. Since you do, maybe you could add some information on the wiki > to assist others after you? > >&

Re: [GNC] Another sort field like 'Class' in Quicken?

Paul, This is a recent addition to the program. Since the documentation is also developed by volunteers (who are not necessarily the same as the people who write the program itself) documentation often lags behind the features. We rely on users like you to provide descriptions of features and h

<    1   2   3   4   5   6   7   >