Re: [GNC] Tweak of Memorized Transactions
I also have turned on double-line mode to deal with the notes/memo field. I use it mainly on one account. The original suggestions would be nice options to have - certainly the non-copying of the field for memorized transactions would be great. On 3/24/2019 10:22 PM, Liz wrote: On Sun, 24 Mar 2019 13:52:56 -0500 Dale Alspach wrote: I use the Memo line once in a while for purchases at some stores, but usually it is left blank. In single line mode later I will enter another purchase at the same store, the memorized transaction fills the Memo field with the memo from the earlier transaction which is not relevant for this one. Further this is hidden in single line mode so the transaction is posted with the bogus memo. This produces false positives when searching on the memo field. If you believe my books, I have bought lots of washing machines at all sorts of prices. I'm mostly using double line view now. Liz ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- -Glenn J. Christman glenn.christ...@gmail.com ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of multi-split feature of CSV importer?
Op zondag 24 maart 2019 02:47:37 CET schreef David Cousens: > Patrick, > > When the Transaction is opened with the split button, the Description field > name should change to Memo. There are other changes in the headings as > described in the documentation ( > https://www.gnucash.org/docs/v3/C/gnucash-help/trans-multi-enter.html). If > my understanding is correct, each split of a transaction has its own Memo > field while the Description field is attached to the transaction which > consists of 2 or more splits. The same description should also come up if > you open the transaction in another register that there is a split to. You > can enter different information in the Memo field if you wish. > > I think the importer matches on the Description field for the transaction by > tokenizing its content and matching to the tokenized forms of the > description field of existing transactions which is weighted along with the > matching of amounts, dates, etc. I don't think the Memo field is involved > in matching AFAIK but I haven't checked the code out to see. Geert may be > able to comment on that as he is more familiar with the code than I am. > > I think you can specify the Memo field in the multisplit format as well as > the Description field. I am away from home at the moment so I can't check > for sure. > > David That explains it very well indeed. In short: transactions have a description, splits have a memo. If you want each individual split to have some descriptive information, you can add this in the memo field (which is also supported by the importer). If you want the whole transaction to have some descriptive information, you can add this in the transaction's description field. And as David says, the csv importer will use the description field (and all other transaction related fields) to determine transaction boundaries. As the memo fields is a related to splits its contents will not affect this boundary detection. Geert ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tweak of Memorized Transactions
You can edit any field of the memorized transaction to your liking. Ken Schneider > On Mar 25, 2019, at 5:01 AM, Glenn Christman > wrote: > > > I also have turned on double-line mode to deal with the notes/memo field. I > use it mainly on one account. > > The original suggestions would be nice options to have - certainly the > non-copying of the field for memorized transactions would be great. > > > >> On 3/24/2019 10:22 PM, Liz wrote: >> On Sun, 24 Mar 2019 13:52:56 -0500 >> Dale Alspach wrote: >> >>> I use the Memo line once in a while for purchases at some stores, but >>> usually it is left blank. In single line mode later I will enter >>> another purchase at the same store, the memorized transaction fills >>> the Memo field with the memo from the earlier transaction which is >>> not relevant for this one. Further this is hidden in single line mode >>> so the transaction is posted with the bogus memo. This produces false >>> positives when searching on the memo field. >> If you believe my books, I have bought lots of washing machines at all >> sorts of prices. >> I'm mostly using double line view now. >> >> Liz >> ___ >> 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 Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -- > -Glenn J. Christman > glenn.christ...@gmail.com > > ___ > 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 Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Some chinese words can not be displayed
> On Mar 24, 2019, at 7:34 AM, Richard Zhang wrote: > > Hi Support, > I got a problem when I use the GNUCASH. > > Environment: Window 10 Enterprise > Version: 1709 > Language: English > > Symptom: some words in menu and description can not be displayed. > [cid:image001.png@01D4E22A.DB249AA0] > > Pls help. You need to configure a font with better Unicode support. See https://wiki.gnucash.org/wiki/GTK3. The hard part is figuring out which font to use. 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tweak of Memorized Transactions
Ken, You're missing the point here. Dale is pointing out an implementation that automatically copies hidden (and transaction-specific) information from one transaction to the next. This annoying feature is what Liz was referring to when she said she'd purchased many washing machines: the information about a washing machine is copied from one transaction to the next in the hidden memo field. This is a similar problem to that of the copied splits (or entries, or ledger entries, or whangdoodles, using whatever terminology is the current fad) -- i.e., people complain when the auto fill duplicates splits from one transaction to the next.I Of course, we can edit these (if we are aware they've been copied), but wouldn't it be more convenient in this instance if we didn't have to--or perhaps had the option to choose? It sounds like you're talking about scheduled transactions, which Dale was not. David On March 25, 2019, at 7:26 PM, Kenneth Schneider wrote: You can edit any field of the memorized transaction to your liking. Ken Schneider > On Mar 25, 2019, at 5:01 AM, Glenn Christman > wrote: > > > I also have turned on double-line mode to deal with the notes/memo field. I > use it mainly on one account. > > The original suggestions would be nice options to have - certainly the > non-copying of the field for memorized transactions would be great. > > > >> On 3/24/2019 10:22 PM, Liz wrote: >> On Sun, 24 Mar 2019 13:52:56 -0500 >> Dale Alspach wrote: >> >>> I use the Memo line once in a while for purchases at some stores, but >>> usually it is left blank. In single line mode later I will enter >>> another purchase at the same store, the memorized transaction fills >>> the Memo field with the memo from the earlier transaction which is >>> not relevant for this one. Further this is hidden in single line mode >>> so the transaction is posted with the bogus memo. This produces false >>> positives when searching on the memo field. >> If you believe my books, I have bought lots of washing machines at all >> sorts of prices. >> I'm mostly using double line view now. >> >> Liz >> ___ >> 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 Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -- > -Glenn J. Christman > glenn.christ...@gmail.com > > ___ > 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 Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to change register colors in gnucash 3.x?
You need to reverse the preference on your #2 back to using the GnuCash color theme. If the preference is checked, GnuCash will load its own predefined colors, or colors from a custom css file. If the preference is cleared, GnuCash will use colors from the default Gtk theme. (Adwaita in this case unless you’ve installed and activated a different one) So GnuCash is not loading your css file with the preference unchecked. This function of the preference is described in a tool tip if you hover over it. Regards, Adrien > On Mar 22, 2019, at 1:09 PM, dsp1024 via gnucash-user > wrote: > > Hi. I upgraded from gnucash v2.4 to 3.4 (Windows 7) and I read the colors > theme are gone... and to follow the instruction in > "https://wiki.gnucash.org/wiki/GTK3#Register_Appearance"; to change them in > v3.4. So I thought I did: > > 1. I got the sample file from > "https://github.com/Gnucash/gnucash/blob/maint/doc/gtk-3.0.css"; > 2. I disabled "Use GnuCash built-in color theme" in gnucash (the register > looks black font on white background, header is greyish background) > 3. Copy "gtk-3.0.css" to "C:\Users\myUserName\AppData\Roaming\GnuCash" > 4. Re-started gnucash > > Theses lines below (from "gtk-3.0.css") makes me think that the register > header should be seagreen: > > /* Register User Colors */ .header-color {background-color: seagreen;color: > white;} > > I don't see any changes in the color of anything. What am I doing wrong? > > Thanks > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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 Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
While I don’t have an issue with the use of the term ’split’ as a noun (seems quite normal to me) after looking at my Accounting textbook, I see the authors simply refer to each debit/credit as an ‘entry’ which of course makes sense in light of the phrase ‘double-entry accounting.’ They however distinguish between ‘ledger entries’ which are those individual debits and credits in their respective accounts, and ‘journal entries’ which are to proceed posting to the ledgers in a formal ink-paper system. Since formal paper systems use a journal (and GnuCash has a virtual journal and substitutes ‘registers’ instead with a ’shortcut single line entry system') and all debits and credits are always visible there, the text does not have a distinction between transactions that have only two entries (one dr./one cr.) and those that have 3 or more. Regards, Adrien > On Mar 23, 2019, at 5:39 AM, Michael Hendry wrote: > >> On 22 Mar 2019, at 19:33, aeg via gnucash-user >> wrote: > > > -- > > I agree with Michael's points.A simple transaction consists of just one split > but two parts, and saying (pretending) that a simple transaction has two > splits is misleading. > I see no problems with the use of terms like 'simple transaction' (with one > split and two parts) or with 'compound transactions' (with 2+ splits and 3+ > parts), but it doesn't make sense to refer to the parts as splits. Why not > just use the term 'parts' or 'transaction parts' or even invent a new word > 'transparts'; (after all, GnuCash is a made up word too.) > Just because GnuCash developers previously defined the 'parts' of a > transaction as 'splits' doesn't mean that the definition shouldn't be changed > to make it clearer. > Kind regards,Alan > > > ___ > > Thanks for your support, Alan, > > also for inadvertently revealing that the terminology has confused you too! > > QED > > You say “A simple transaction consists of just one split…” - this is not true > - it’s clear from everyday use of GC that there are two splits in a simple > transaction, in other words that a split maps directly to what would be > called a Ledger Entry in paper-and-ink bookkeeping. Similarly, a compound > transaction is one with more than 2 splits. > > More confusion is added to the mix by the appearance of the term “Split > Transaction” in the Basic View of a register which includes a compound > transaction. This may be the reason for your errors above. > > As every transaction involves splits, this isn’t helpful. If it said > “Compound Transaction” it would be much easier to comprehend, and would not > need to cause problems for the underlying code or data. > > I appreciate Derek’s point that removing the term “split” from the code and > data would have consequences for future developers, and that the introduction > of “Ledger Entry” would be awkward, but with some minor changes to the code > and revision of the documentation this could all be resolved. > > For example, consider this section: > > "4.3. Simple vs. Split Transactions > > "Every transaction in GnuCash has at least two splits, but a transaction can > have more than two splits. A transaction with only two splits is called a > simple transaction, since it only involves the current account and a single > remote account. A transaction with three or more accounts is called a split > transaction. > > "When the register is in Basic view, you will see a summary of the splits > affecting the current account. For a simple transaction, the Transfer column > will display the other account from which money is transferred. For a split > transaction, the Transfer column will display -- Split Transaction --. You > can see the individual splits of each transaction by clicking the Split > button in the Toolbar while selecting the appropriate transaction.” > > I would suggest: > > “4.3 Simple vs. Compound Transactions > > "Every transaction in GnuCash has at least two entries, one recording the > source account for the cash, and the other its destination. These are the > equivalent of Ledger Entries in traditional bookkeeping, and are known as > “splits” in GnuCash. A two-split transaction is called a Simple Transaction. > > "It’s also possible to have more than two splits in a transaction, which is > called a Compound Transaction. > > "When the register is in Basic view, you will see a summary of the splits > affecting the current account. For a simple transaction, the Transfer column > will display the other account from which money is transferred. For a > compound transaction, the Transfer column will display -- Compound > Transaction --. You can see the individual splits of each transaction by > clicking the Split button in the Toolbar while selecting the appropriate > transaction.” > > > I think the implications for the code would be small, but the relevant > sections of the
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
I think the confusion is arising because the default view (well intentioned for simplicity for new users) is hiding the double-entry nature of the actual data and this necessitated special terms and definitions for ’simple transaction’ and ‘compound transaction’ and then someone decided to use the term ’split transaction’ instead for one of those and then for clarification, exacerbated the confusion with ‘multi-split transaction’ as a substitute for ‘compound transaction’. If we just abandon the use of ’split transaction’ (since they are all split at least once) and ‘multi-split transaction’ (since we have the defined ‘compound transaction’ to use) things might clear up a bit. Of course, the documentation is fine, this is just a communication and comprehension failing in a list conversation. On another note, while I have long known that mnemonics and abbreviations were used by programmers to save time (and storage space), I never considered how the time saved typing an extra letter, or few, more than made up for the small amount of time spent learning the command name and mapping it in my brain to the natural language term for what I’m trying to accomplish, especially considering I use some of those cryptic (to others) commands multiple times on a daily basis. Thanks for that tid-bit. Regards, Adrien > On Mar 24, 2019, at 11:42 AM, Michael or Penny Novack > wrote: > > On 3/23/2019 6:04 PM, aeg via gnucash-user wrote: >> Thank you to those who have tried to educate me on the use of the word >> "split" in GnuCash, but whilst I believe that I understand how it is being >> used, the reason for using such an ambiguous term remains puzzling when >> better alternatives exist. > Is the objection then just to the term "split" being used when going from the > simplified method of entry (usable for the vast majority of transactions > where only two accounts are involved) to the more general "journal view" form > of entry that can be used for any transaction? > > You are right in the sense that nothing is being "split". The developers > could have used something more descriptive like "enter in journal view". > > Do you understand that gnucash would allow you to enter even simple (just two > accounts affected) transactions in this more complicated way? Instead of > entering the second account in the space provided hit the "split" button (the > "change to journal view" button) and enter the second account on its own > line. In other words, the "simple" (unsplit) method of entry is simply a work > flow shortcut making entering the vast majority of transactions much > faster/easier. > > To those of us who learned bookkeeping in the "old days", first entering > transactions in the journal, what is happening with "split" is obvious. We > are entering transactions the "old fashioned way" and with the hit of the > key at the end doing the "post". > > Those of us who know the computer language c and unix know that strange (hard > to read shortened spellings) were used by the engineers at Bell Labs who > preferred shorter (less key strokes) even if they had to be memorized. Thus > "mount" and "umount" (had to remember, no first "n"). I heard that this is > because none of them could touch type. But also how engineer minds work, in > the long run, less time spent learning that "umount" was spelled that way > than all the times afterwards hitting that extra "n". > > Just think of "enter in journal view" as being spelled "split". > > Michael D Novack ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tweak of Memorized Transactions
Interesting, but not really necessary to change. (and it would introduce more code to maintain) If you don’t want to use memos, don’t. If you do, then turn on transaction-journal view instead and use that. You’ll never encounter this problem of ‘hidden’ data. I got so tired of expanding transactions to view them I just turned it on permanently my first week of using GnuCash and haven’t looked back. (I did try it once a few years later while helping someone and quickly saw I didn’t like the basic view at all) I’ve also since turned on Double-Line mode to get the extra Notes field for transaction notes in addition to memo splits. I’d recommend to any new user to adjust these two settings. Not only does they give you an at-a-glance view of all of your data, it helps to see the debits and credits to learn double-entry accounting if you are new to it, and with these two settings you have the most access to enter as much detail as you possibly can. I’ve long ago learned it is easier to enter lots of detail as I enter transactions then to wish I still had that info months or years later and I want to analyze my activity. (more detail significantly helps with refactoring accounts which you are more likely to do as you determine exactly how you want to track things over the first few months of using the software, or even years later when you find a better method/account) Regards, Adrien > On Mar 24, 2019, at 1:52 PM, Dale Alspach wrote: > > This is really a request for enhancement but I thought I would see what > others thought before formally adding it. > > I use the Memo line once in a while for purchases at some stores, but > usually it is left blank. In single line mode later I will enter another > purchase at the same store, the memorized transaction fills the Memo field > with the memo from the earlier transaction which is not relevant for this > one. Further this is hidden in single line mode so the transaction is > posted with the bogus memo. This produces false positives when searching on > the memo field. > > I could use auto-split mode but this is annoying when most transactions do > not need the extra steps. To overcome this issue it would be convenient to > have one or both of these options in the Preferences: > 1. Automatically open the detail (split) view if any of the Memo fields of > the proposed transaction are not empty. > 2. Do not insert the contents of Memo fields in memorized transactions (in > single line mode?). > > Do other users want something like this? > > Dale ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quotes stopped working for me
Hi John, I was referring to MacHD/Library/Perl, so proceeded following your suggestions. The rm commands worked. Tried installing Date::Manip, as you suggested, which generated a long log (attached in full), but seems to have failed for the following reasons (I noticed): 'YAML' not installed, will not store persistent state .. # Test.xs:1:10: fatal error: 'EXTERN.h' file not found # #include "EXTERN.h" # ^~ # 1 error generated.(several times) .. Test Summary Report --- t/02-xsdynamic.t(Wstat: 3072 Tests: 72 Failed: 12) Failed tests: 4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64 70 Non-zero exit status: 12 Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr 0.15 sys + 25.66 cusr 9.00 csys = 35.15 CPU) Result: FAIL Failed 1/67 test programs. 12/1335 subtests failed. make: *** [test_dynamic] Error 255 BINGOS/ExtUtils-MakeMaker-7.34.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports BINGOS/ExtUtils-MakeMaker-7.34.tar.gz Running make install make test had returned bad status, won't install without force Running make for S/SB/SBECK/Date-Manip-6.76.tar.gz Warning: Prerequisite 'ExtUtils::MakeMaker => 6.67_01' for 'SBECK/Date-Manip-6.76.tar.gz' failed when processing 'BINGOS/ExtUtils-MakeMaker-7.34.tar.gz' with 'make_test => NO'. Continuing, but chances to succeed are limited. CPAN.pm: Building S/SB/SBECK/Date-Manip-6.76.tar.gz ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at Makefile.PL line 8. BEGIN failed--compilation aborted at Makefile.PL line 8. Warning: No success on command[/usr/bin/perl Makefile.PL] SBECK/Date-Manip-6.76.tar.gz /usr/bin/perl Makefile.PL -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Could not read metadata file. Falling back to other methods to determine prerequisites. sudo cpan -i Finance::Quote seems to work fine and complete w/o errors, but gc-fnc-helper and -dump keep failing with same results as before. I may have screwed up this sandbox installation, but checked contents of my desktop which worked before but fails now as well and has not been changed to the best log my knowledge: (It contains date Date, Finance, but apparently lacks DateTime, LWP, LWP.pm) 5.18 CPAN Darwin-thread-multi-2level Date ExtUtils Finance HTML JSON Mozilla Parse Test AppendToPath JSON.pm Updates 5.18.2 Darwin-thread-multi-2level Best, Bruno > On Mar 24, 2019, at 3:08 PM, John Ralls wrote: > > Bruno, > > No, there's no reason to install a fake-linux package manager. > > You said "Library/Perl", does that mean /Users/backlin/Library/Perl or > /Library/Perl? It should be the latter. If it's the former, what's in > /Library/Perl? > > Assuming that it *is* /Library/Perl, there are several packages that should > be there and aren't. I suggest > sudo rm -rf /Library/Perl/5.18/Finance > sudo rm -rf ~/.cpan/build/Finance-Quote* > sudo rm -rf -/.cpan/build/Date-Manip* > sudo cpan -i Date::Manip > sudo cpan -i Finance::Quote > > Check the output of those last two to make sure that they complete > successfully. Reinstalling Finance::Quote should pull in the other packages. > After it's done /Library/Perl/5.18 should contain Date, DateTime, Finance, > LWP, and LWP.pm in addition to the modules already there. > > Regards, > John Ralls > > >> On Mar 24, 2019, at 2:36 PM, Bruno Acklin wrote: >> >> Hi John, >> >> Sorry for the omission and delay. >> >> No, I have none of these “fake-Linux package managers”(?) installed - should >> I? >> >> The reply to backlin$ which perl is >> /usr/bin/perl >> >> In usr/bin I find two entries: >> perl and >> perl5.18 >> >> The directory Library/Perl contains >> /5.18 >> /Darwin-thread-multi-2level >> /Finance >> /HTML >> /JSON >> /Mozilla >> /AppendToPath >> /JSON.pm >> /Updates >> /5.18.2 >> /Darwin-thread-multi-2level >> >> Looking up contents of >> ~/.cpan/build/ : >> Date-Manip-6.75-JzZ9Wt ExtUtils-MakeMaker-7.34-_6iXcq >> Date-Manip-6.76-9mWyaN Finance-Quote-1.47-_BUlzK >> Date-Manip-6.76-NE8c76 Finance-Quote-1.47-nChsgf >> Date-Manip-6.76-QNnn65 HTML-TableExtract-2.15-dP4w2A >> ExtUtils-MakeMaker-7.34-695wh2 JSON-4.02-RrPsdw >> ExtUtils-MakeMaker-7.34-DVwu8U Mozilla-CA-20180117-TgJL7x >> ExtUtils-MakeMaker-7.34-U01uzs >> >> Trying your suggestion with /stockdump.pm for both fnq builds I get a >> delayed, identical result, even if I misspell aap(l) for a non-existing >> ticker: >> >> backlin$ ~/.cpan/build/Finance-Quote-1.47-_BUlzK/Examples/stockdump.pl >> yahoo_json aapl >> $VAR1 = { >> 'aaplsymbol' => 'aapl', >> 'aapl
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
aeg via gnucash-user writes: [snip] > level, so I shall continue to use it for double entry bookkeeping > rather than double split bookkeeping. It is double-entry (even in basic mode) because you are entering both debits and credits. It is still double-entry even if you have 5 splits. This is another "term-of-art". > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of multi-split feature of CSV importer?
David, Geert, Thank you for this helpful guidance. I hope to try this soon. Regards, Patrick On Mon, Mar 25, 2019 at 5:18 AM Geert Janssens wrote: > Op zondag 24 maart 2019 02:47:37 CET schreef David Cousens: > > > Patrick, > > > > > > When the Transaction is opened with the split button, the Description > field > > > name should change to Memo. There are other changes in the headings as > > > described in the documentation ( > > > https://www.gnucash.org/docs/v3/C/gnucash-help/trans-multi-enter.html). > If > > > my understanding is correct, each split of a transaction has its own Memo > > > field while the Description field is attached to the transaction which > > > consists of 2 or more splits. The same description should also come up if > > > you open the transaction in another register that there is a split to. > You > > > can enter different information in the Memo field if you wish. > > > > > > I think the importer matches on the Description field for the > transaction by > > > tokenizing its content and matching to the tokenized forms of the > > > description field of existing transactions which is weighted along with > the > > > matching of amounts, dates, etc. I don't think the Memo field is involved > > > in matching AFAIK but I haven't checked the code out to see. Geert may be > > > able to comment on that as he is more familiar with the code than I am. > > > > > > I think you can specify the Memo field in the multisplit format as well > as > > > the Description field. I am away from home at the moment so I can't check > > > for sure. > > > > > > David > > > > That explains it very well indeed. > > > > In short: transactions have a description, splits have a memo. If you want > each individual split to have some descriptive information, you can add > this in the memo field (which is also supported by the importer). If you > want the whole transaction to have some descriptive information, you can > add this in the transaction's description field. > > > > And as David says, the csv importer will use the description field (and > all other transaction related fields) to determine transaction boundaries. > As the memo fields is a related to splits its contents will not affect this > boundary detection. > > > > Geert > ___ 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 Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quotes stopped working for me
Bruno, It turns out that Apple decided to put the perl headers exclusively in the Xcode SDK but their perl patch doesn't quite work. Gory details may be read at https://rt.cpan.org/Public/Bug/Display.html?id=127028. The work-around in the last post to that bug, installing command-line tools and then installing /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg got me a clean ExtUtils::MakeMaker install without the whining about EXTERNAL.h. With that in place Date::Manip will also install correctly. I just found /System/Library/Perl/Extras/5.18/. It has DateTime and LWP, explaining why F::Q doesn't complain about not finding them when they're not in /Library/Perl. In fact in the course of installing Command Line Tools I also got a system upgrade (from 10.14.4beta to 10.14.4) and that removed DateTime and LWP from /Library/Perl/5.18 on my system. It didn't break Finance::Quote, so I guess LWP is ruled out as the source of your problem. When you say that Finance::Quote seems to work without problem does that mean that stockdump.pl works but gnc-fq-dump still reports a 500 error? Regards, John Ralls > On Mar 25, 2019, at 4:37 PM, Bruno Acklin wrote: > > Hi John, > > I was referring to MacHD/Library/Perl, so proceeded following your > suggestions. > > The rm commands worked. > Tried installing Date::Manip, as you suggested, which generated a long log > (attached in full), but seems to have failed for the following reasons (I > noticed): > 'YAML' not installed, will not store persistent state > .. > # Test.xs:1:10: fatal error: 'EXTERN.h' file not found > # #include "EXTERN.h" > # ^~ > # 1 error generated. (several times) > .. > Test Summary Report > --- > t/02-xsdynamic.t(Wstat: 3072 Tests: 72 Failed: 12) > Failed tests: 4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64 >70 > Non-zero exit status: 12 > Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr 0.15 sys + 25.66 cusr > 9.00 csys = 35.15 CPU) > Result: FAIL > Failed 1/67 test programs. 12/1335 subtests failed. > make: *** [test_dynamic] Error 255 > BINGOS/ExtUtils-MakeMaker-7.34.tar.gz > /usr/bin/make test -- NOT OK > //hint// to see the cpan-testers results for installing this module, try: > reports BINGOS/ExtUtils-MakeMaker-7.34.tar.gz > Running make install > make test had returned bad status, won't install without force > Running make for S/SB/SBECK/Date-Manip-6.76.tar.gz > Warning: Prerequisite 'ExtUtils::MakeMaker => 6.67_01' for > 'SBECK/Date-Manip-6.76.tar.gz' failed when processing > 'BINGOS/ExtUtils-MakeMaker-7.34.tar.gz' with 'make_test => NO'. Continuing, > but chances to succeed are limited. > > CPAN.pm: Building S/SB/SBECK/Date-Manip-6.76.tar.gz > > ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at > Makefile.PL line 8. > BEGIN failed--compilation aborted at Makefile.PL line 8. > Warning: No success on command[/usr/bin/perl Makefile.PL] > SBECK/Date-Manip-6.76.tar.gz > /usr/bin/perl Makefile.PL -- NOT OK > Running make test > Make had some problems, won't test > Running make install > Make had some problems, won't install > Could not read metadata file. Falling back to other methods to determine > prerequisites. > > sudo cpan -i Finance::Quote seems to work fine and complete w/o errors, but > gc-fnc-helper and -dump keep failing with same results as before. > > I may have screwed up this sandbox installation, but checked contents of my > desktop which worked before but fails now as well and has not been changed to > the best log my knowledge: (It contains date Date, Finance, but apparently > lacks DateTime, LWP, LWP.pm) > > 5.18 > CPAN > Darwin-thread-multi-2level > Date > ExtUtils > Finance > HTML > JSON > Mozilla > Parse > Test > AppendToPath > JSON.pm > Updates > 5.18.2 > Darwin-thread-multi-2level > > Best, Bruno > >> On Mar 24, 2019, at 3:08 PM, John Ralls >> wrote: >> >> Bruno, >> >> No, there's no reason to install a fake-linux package manager. >> >> You said "Library/Perl", does that mean /Users/backlin/Library/Perl or >> /Library/Perl? It should be the latter. If it's the former, what's in >> /Library/Perl? >> >> Assuming that it *is* /Library/Perl, there are several packages that should >> be there and aren't. I suggest >> sudo rm -rf /Library/Perl/5.18/Finance >> sudo rm -rf ~/.cpan/build/Finance-Quote* >> sudo rm -rf -/.cpan/build/Date-Manip* >> sudo cpan -i Date::Manip >> sudo cpan -i Finance::Quote >> >> Check the output of those last two to make sure that they complete >> successfully. Reinstalling Finance::Quote should pull in the other packages. >> After it's done /Library/Perl/5.18 should contain Date, DateTime, Finance, >> LWP, and LWP.pm in addition to the modules already there. >> >> Regards, >> John Ralls >> >> >>> On Mar 24, 2019, at 2:36