Re: [GNC] Transaction regex help
Hi Geoff, Thanks for this. I have, indeed, been driving myself slightly insane with the Posix regex. I might do some more reading on the default transaction filter to see what it can do... I might have gone to Posix too soon. I'll give the searches a try. Thanks very much. Michelle. On Wed, 2023-02-08 at 23:12 +1100, Geoff wrote: > Hi Michelle > > GnuCash has implemented the "POSIX" dialect of regular expressions, > and > I don't think it supports the complex example with negation you gave > in > your earlier post:- > > https://www.ibm.com/docs/en/watson-explorer/11.0.1?topic=queries-posix-regular-expression-syntax-examples > > However, you may be able to achieve your desired result if you try > using > the Search functionality instead - this post and screenshot may be > helpful:- > > https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101780.html > > If you manage to filter the required transactions using Search (or a > series of Searches, remember that you can:- > * Refine the results of a previous Search > * Add results to the current Search > * Delete results from the current Search > ) > then you can produce a Transaction Report by choosing:- > Reports / Account Report. > > Hope this helps. > > Regards > > Geoff > = > > On 8/02/2023 9:36 pm, Michelle wrote: > > I gave a bad example. In trying to make the example simple, I > > opened up > > a solution. > > > > Consider text to be in the description which would be a negative > > for > > wanting to summarise some transactions in a series of what would > > otherwise be placed in a -Cat:Computer:Hardware line. > > > > Michelle. > > > > On Wed, 2023-02-08 at 04:14 -0600, Adrien Monteleone wrote: > > > Also, do you not split your receipts by line item? > > > > > > That would make this a cinch. > > > > > > Regards, > > > Adrien > > > > > > On 2/8/23 4:10 AM, Michelle wrote: > > > > I think part of my problem may be that in the transaction > > > > filter, > > > > the > > > > account name may not be included as part of the comparison, but > > > > even > > > > then if I try various forms of "not clothing" in the account > > > > filter, > > > > that's not working either. > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > - > > > Please remember to CC this list on all your 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 > > - > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction regex help
I gave a bad example. In trying to make the example simple, I opened up a solution. Consider text to be in the description which would be a negative for wanting to summarise some transactions in a series of what would otherwise be placed in a -Cat:Computer:Hardware line. Michelle. On Wed, 2023-02-08 at 04:14 -0600, Adrien Monteleone wrote: > Also, do you not split your receipts by line item? > > That would make this a cinch. > > Regards, > Adrien > > On 2/8/23 4:10 AM, Michelle wrote: > > I think part of my problem may be that in the transaction filter, > > the > > account name may not be included as part of the comparison, but > > even > > then if I try various forms of "not clothing" in the account > > filter, > > that's not working either. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction regex help
I think part of my problem may be that in the transaction filter, the account name may not be included as part of the comparison, but even then if I try various forms of "not clothing" in the account filter, that's not working either. Michelle. On Wed, 2023-02-08 at 10:01 +, Michelle wrote: > I've been bashing my head against this for a while. > > I'm after a grocery report, so I want everything that I buy from > Sainsburys, M&S, Iceland... but not if it is clothes. > > I've got as far as picking out all the stores using Regex in the > transaction filter... > > Sainsburys|Iceland|Marks & Spencer > > ...but I can't figure out how to include, Not Clothing. > > I have tried various variants including negative lookahead, but I'm > obviously doing something wrong... > (Sainsburys|Iceland|Marks & Spencer)(?!Clothing) > > Grateful for any advice please. > > Michelle. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Transaction regex help
I've been bashing my head against this for a while. I'm after a grocery report, so I want everything that I buy from Sainsburys, M&S, Iceland... but not if it is clothes. I've got as far as picking out all the stores using Regex in the transaction filter... Sainsburys|Iceland|Marks & Spencer ...but I can't figure out how to include, Not Clothing. I have tried various variants including negative lookahead, but I'm obviously doing something wrong... (Sainsburys|Iceland|Marks & Spencer)(?!Clothing) Grateful for any advice please. Michelle. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Demo accounts
Thanks very much all. I managed to use the CSV import, as suggested, to import CSV files with spurious values, but good enough to make it look like a basic set of accounts for an individual... at least good enough to show the reports I wanted. Michelle. On Sun, 2023-02-05 at 14:20 -0500, R. Victor Klassen wrote: > I would start by exporting some of your own stuff to .csv > > That will tell you what the native GNUCash csv input format looks > like. > > Now you can go to a spreadsheet and create transactions to your > heart’s content using dates that are based on formulae (like every 14 > days put in the same transaction). and so on. > Save that to csv, and import it into a brand new file. > > > On Feb 5, 2023, at 6:05 AM, Michelle wrote: > > > > This is going to be a bit of an odd question, but hey ho. > > > > I have a very small channel and would like to make a small video > > about > > GnuCash and reporting insights for the average home user. > > > > What I'm looking for is a set of demo accounts. > > > > Nothing serious, just a bank account and a credit card, showing > > wages > > coming into the bank account monthly, the credit card being paid > > off > > monthly, and a series of transactions on the credit card, like > > supermarket, cd, dvd, fuel, that sort of thing... covering maybe > > five > > years with some simple categories to cover the spending. > > > > So, nothing complicated like interest or multiple currencies, or > > anything like that. > > > > Is there something out there please, or something I can do to make > > creation a bit easier? > > > > Many thanks, > > > > Michelle. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Demo accounts
This is going to be a bit of an odd question, but hey ho. I have a very small channel and would like to make a small video about GnuCash and reporting insights for the average home user. What I'm looking for is a set of demo accounts. Nothing serious, just a bank account and a credit card, showing wages coming into the bank account monthly, the credit card being paid off monthly, and a series of transactions on the credit card, like supermarket, cd, dvd, fuel, that sort of thing... covering maybe five years with some simple categories to cover the spending. So, nothing complicated like interest or multiple currencies, or anything like that. Is there something out there please, or something I can do to make creation a bit easier? Many thanks, Michelle. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 9 digit is show as a dash
I do not have any customizations. I did go through and “restore defaults” on all the style sheets options just to make sure and I still have the same problem. > On Nov 13, 2021, at 2:18 PM, John Ralls wrote: > > Please remember to copy the list on all replies. > > So the issue is a font that displays a glyph that looks like a dash for > U+0039. That's really strange. Do you have any Gtk customizations installed? > If you don't know wha that means see https://wiki.gnucash.org/wiki/GTK3. > > Regards, > John Ralls > > >> On Nov 13, 2021, at 11:02 AM, Michelle Greenlee >> wrote: >> >> The 9s are restore when I copy and paste elsewhere >> >> Copied and pasted... >> Version: 4.8 >> Build ID: 4.8a+(2021-09-28) >> Finance::Quote: - >> >>> On Nov 13, 2021, at 1:16 PM, john wrote: >>> >>> >>>> On Nov 12, 2021, at 6:34 PM, Michelle Greenlee >>>> wrote: >>>> >>>> HI. I just upgrade my mac from High Sierra to Catalina. I was on Gnucash >>>> 4.2. When I opened the program after the upgrade, all mu 9s appear as >>>> dashes. Even in the About GnuCash screen, the 9s are dashes. I tried >>>> upgrading yo 4.8.2 and they are still dashes. Any suggestions? >>> >>> That is really strange. If you select and copy one of the offending strings >>> in the about dialog and paste it somewhere else--like an email compose >>> window--are the 9s restored? >>> >>> Have you customized any fonts in a gtk.css file? >>> >>> 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.
[GNC] 9 digit is show as a dash
HI. I just upgrade my mac from High Sierra to Catalina. I was on Gnucash 4.2. When I opened the program after the upgrade, all mu 9s appear as dashes. Even in the About GnuCash screen, the 9s are dashes. I tried upgrading yo 4.8.2 and they are still dashes. Any suggestions? Thanks, Michelle ___ 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.
[GNC] Can't Get Online Quotes Using GnuCash
Hello, I recently updated my GnuCash version to 4.4 and am trying the Stock feature. I am running Windows 10 on my computer. After installing Strawberry Perl manually, then clicking on "Install Online Price Retrieval for GnuCash", the command prompt seems to run for about a minute and ends with the following lines: pl2bat.bat blib\script\dm_zdump SBECK/Date-Manip-6.83.tar.gz C:\Users\Michelle\AppData\Local\Temp\c\bin\gmake.exe -- OK I'm not sure how I'm supposed to run the "gnc-fq-dump" test program, I tried dragging it into the command prompt/opening it in GnuCash software, however it didn't do anything. I reopened GnuCash and tried using the Security Editor again, however the "Get Online Quotes" checkbox is still greyed out and I can't select it. Could you help me with this? Thanks, Michelle ___ 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] Simple reporting help
Yes. By default, it selected all accounts, and I even tried deselecting all and selecting indicidual accounts, but no change. This is version 4.2 flatpak build. On Tue, 2020-10-27 at 07:50 -0500, Gal wrote: > Michelle, did you make any account selection in the report options? > > > > -- > 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] Simple reporting help
I did try. Had to get the flatpak version 4.2 as Mint is too far behind that I couldn't easily "make" it, but it still gave nothing. Michelle. On Tue, 2020-10-27 at 09:00 +1100, Geoff wrote: > Wow, that's a much better solution, it shows sub-totals for > sub-accounts, and even handles financial years not just calendar > years. > > Thanks for the tip Gal! > > Michelle - it might be worth upgrading for this feature, see > attached > screenshot. > > Geoff > = > > On 27/10/2020 3:49 am, Gal wrote: > > Another way to achieve what you're looking for is to select Reports > > --> > > Experimental --> Income Statement (Multicolumn) > > > > Then select the relevant account in the Accounts Tab, and select > > "Year" in > > the Period duration dropdown list in the General tab. > > > > > > > > -- > > 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] Simple reporting help
I guess that report is still experimental in the Linux version :-) The Mint repos still have a build from 2019-12-29. V3.8 Thanks for making me aware of it though. I'll keep an eye on it. On Mon, 2020-10-26 at 11:49 -0500, Gal wrote: > Another way to achieve what you're looking for is to select Reports > --> > Experimental --> Income Statement (Multicolumn) > > Then select the relevant account in the Accounts Tab, and select > "Year" in > the Period duration dropdown list in the General tab. > > > > -- > 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] Simple reporting help
Hi Geoff, That did the trick. Many thanks. I do wish that on the General tab, Start date drop down, that they had an option for, "Since the beginning of time." :-) But that's given me exactly what I need. Many thanks for your help, Michelle. On Mon, 2020-10-26 at 22:24 +1100, Geoff wrote: > Hi Michelle > > One way to achieve this is to use the Transaction Report. > > After selecting the relevant Account(s), stay in Options and tick > "Subtotal Table" on the Display tab, then select "Date" as the > Primary > Key and "Yearly" as the Primary Subtotal on the Sorting tab. > > You should get the subtotals at the start of the report, followed by > all > the transactions. > > See attached screenshot. > > Hope this helps. > > Regards > > Geoff > = > > On 26/10/2020 8:39 pm, Michelle wrote: > > Apologies for a newbie question. I've been using GnuCash for many > > years > > but I do little reporting with it. > > > > What I'm trying to do is look at annual expenditure for a specific > > account/catagory. > > > > eg. I have - -cat:Car:Fuel ... and I want to know how much I've > > spent > > on fuel each year, over the last ten years. > > > > I've tried a number of report options, but I'm not hitting the > > right > > report. > > > > Could someone kindly help please. > > > > ___ > > 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.
[GNC] Simple reporting help
Apologies for a newbie question. I've been using GnuCash for many years but I do little reporting with it. What I'm trying to do is look at annual expenditure for a specific account/catagory. eg. I have - -cat:Car:Fuel ... and I want to know how much I've spent on fuel each year, over the last ten years. I've tried a number of report options, but I'm not hitting the right report. Could someone kindly help please. ___ 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.
[GNC] 2 questions
I just updated to GnuCash 3.2 from 2.6.17 on MacOS X 10.13.6 I noticed to things that I don’t know if there is a preference to change or if any one else has had trouble with. 1. When I enter a date, I usually enter just the month and day and the current year populates. With this update, when I enter the month and day, the year populates as 2017. 2. Before, when I typed in the description, what I typed would overwrite the letters in the box until what I was looking for showed up. (i.e. I type p and pizza shows up. I type u and it changes to Publix). Now it take my first letter and tries to match it with something and then anything else I type gets inserted into that original finding (I type Pub and I get Pubizza because it found pizza first) Thanks, Michelle ___ 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.
stock updates of the Johannesburg Stock Exchange (JSE)?
Hello, I am new to GNUcash. I was reading the manual a few minutes ago and understand that I will need to install "Pearl Strawberry". My question however rather is - does yahoo provide stock prices for the johannesburg stock exchange? ... since I can not find it in "Table A.4. Yahoo Codes for Exchanges and Markets" of the manual - I assume they do not and therefore gnucash won't be able to automatically update my stock prices online? Thank-you Michelle ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
