Re: [GNC] OFX setup
It's supposed to set up the accounts, but doesn't always. Another user reported the same problem yesterday on IRC. She created the accounts by hand and was able to retrieve transactions. AQBanking 6.1.4 does work with OFX and AFAIK there are no changes to aqofxconnect between 6.1.4 and 6.2.1. Regards, John Ralls > On Jul 4, 2020, at 5:46 AM, Fleur Dragan wrote: > > Ah! My mistake! I had 3.10 and was checking against that. > > I just tried to set up an OFX account with 4.0, which is as you said 6.2.1, > but still am having no luck. > > So when I try to set up OFX connectivity, the user is created successfully. > Then I try to retrieve accounts, which do show up in the log window, and the > log window says I may now close, but when I do, nothing happens. This was > the same behavior I saw with aqbanking 6.1.4. > > The web page implies that aqbanking should be setting up the accounts it > finds for me when it retrieves them. Is that correct, or do I have to do it > myself? There aren't instructions for that that I have found. > > > thanks, > fleur > -- > Fleur Dragan / fl...@obscure.org > > > > >> On Jul 4, 2020, at 1:20 PM, Frank H. Ellenberger >> wrote: >> >> Hello Fleur, >> >> Am 04.07.20 um 14:01 schrieb Fleur Dragan: >>> >>> Hey all, >>> >>> On https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect where it says >>> >>>> AqBanking between 5.99.0 and 6.1.4 doesn't work with OFX DirectConnect. >>> >>> are those version numbers inclusive? >>> >>> If so, are there any plans to upgrade the version packaged with the MacOS >>> release (which is at 6.1.4)? >> >> no, 3.11 and 4.0 contain AqBanking 6.2.1 >> >>> thanks, >>> fleur >>> -- >>> Fleur Dragan / fl...@obscure.org >> >> Regards >> Frank >> > > ___ > 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] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)
You're confusing reconciliation with processing paper statements. Regardless of how you get the information from the bank the fact remains that there are two sets of books--yours in GnuCash and the bank's--and they need to be reconciled periodically to ensure that they agree. One could, of course, keep one's GnuCash book by downloading transactions from the bank. In that case you're not keeping a separate book and there's no point to reconciliation. But why bother with GnuCash if you're going to do that? Regards, John Ralls > On Jul 4, 2020, at 5:38 AM, py...@cox.net wrote: > > Michael -- again - it is a matter of personal preference. Every instance you > talk about is absolutely true for banking in the old days. I, too, used to > think that bank rec's were absolutely necessary -- in fact, as an auditor for > 30 years - I recommended them as a must have! > > But, with easy, on-line, instant access to balances and statements, > all-electronic payments (I maybe wrote 3 checks all of last year), and better > and faster electronic payment systems, the need for monthly reconciliations > has gone the way of the horse and buggy - for many people (not all - and > certainly not for businesses who write hundreds of check). It does get you > where you absolutely need to go -- it just is an old and tired mode of > transportation that have been surpassed by better and faster ways to get to > the same place! > > Ken > > (PS -- my mother-in-law still uses bank by phone to call the bank for her > balance instead of going online to see her balance. She does not get paper > statements because all banks charge for them now. She still keeps a paper > register as well. She reconciles manually once a week. See the analogy?) > > -Original Message- > From: gnucash-user On Behalf > Of Michael Hendry > Sent: Friday, July 3, 2020 11:53 PM > To: Chris Good ; Gnucash > Subject: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper > Clip and Link glyphs for file/web transaction associations) > >> On 4 Jul 2020, at 02:45, Chris Good wrote: >> >> Hi Ken, >> >> I'm afraid I'm in the group that finds reconciling very useful. I want >> to know if anyone is charging me when they shouldn't be, without >> having to check my phone all the time. Admittedly it happens so >> infrequently I could probably do without it, but I sleep better with it. >> >> I know a developer is considering restructuring the columns to make >> better use of wider displays. Maybe that will help you in future. >> Myself, I don't really want to use the whole screen, but who knows, I >> often find I automatically dislike change but end up liking it. >> >> Regards, >> Chris Good > > > I agree with Chris that reconciliation is very useful, and I’d go so far as > to say essential. > > Without it, my reaction to an incoming bank or credit card statement couldn’t > be more precise than “that looks about right”, with a gradual slide away from > synchronisation. > > A few examples: > > My pension is paid net of tax and I set up a Scheduled Transaction (Sx) at > the start of the financial year. My tax code varies through the year, and the > net payment is tweaked during the year to get the whole-year tax-take correct > - reconciliation allows me to knock these small differences into line. > > Similarly, my mobile phone bill includes most of what I need in a fixed > monthly payment, recorded by Sx, but occasionally adjusted to deal with > surcharges for out-of-contract services. > > Apart from my personal accounts, I deal with the bookkeeping for two small > charities, whose accounts have to be certified by a qualified accountant for > submission to the Office of the Scottish Charity Register. “About right” is > not sufficient for this purpose, and as our accountants charge nominal sums > for the service it is a matter of common courtesy to minimise (if not abolish > altogether) any queries. One particular example from last year was an > unpresented cheque which had been sent to another charity for a joint project > and recorded through our books some months before the end-of-year. > > Regards, > > Michael Hendry > > > ___ > 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. > Y
Re: [GNC] Gnucash-User
It seems unlikely that you're being moderated; rather I think you've never subscribed. A search of the list for the last 18 months shows exactly one post from Nabble last March, also about Finance::Quote. Liz, the moderator, probably passed it in as a one-off. You may subscribe at https://lists.gnucash.org/mailman/listinfo/gnucash-user. Please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information about using Nabble with the list. Finance::Quote is a separately maintained project from GnuCash and it's installed your computer's perl module directory so upgrading GnuCash isn't going to have any affect on it. Alphavantage is a commercial service with no ties to GnuCash. Another user reported an outage last week but that seems to have been quickly fixed. I just tested it and it's working: /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage CSCO Finance::Quote fields Gnucash uses: symbol: CSCO <=== required date: 07/02/2020 <=== recommended currency: USD <=== required last: 45.6300 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Regards, John Ralls > On Jul 3, 2020, at 11:03 PM, Adrian Holbrook wrote: > > I have been trying to post on the forum but for some reason am no longer > allowed to post. I have sent a number of messages trying to get permission > but with no response from the moderator. My problem is that my stock prices > that I normally download using Finance::Quote from Alpha Vantage have stopped > working. I have not had any problems since we switched to Alpha Vantage and > normally download stock prices around once a month or maybe a bit more > frequently. My latest successful download was on June 12th. I have looked on > the forum for anyone else with this problem but there have been no posts yet. > I have updated to GNC 4.0 and I get exactly the same results. > > I apologise for contacting you directly without going through the forum as I > see you are mentioned as one of the authors of 4.0 so wondered if you could > help. > > Regards > > Adrian Holbrook ___ 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] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations
Each vendor has their own emoji-block glyphs. The one you're seeing looks
pretty similar to
https://emojipedia.org/microsoft/windows-10-may-2019-update/paperclip/.
As for why it's being drawn directly on the sheet, that's because the GnuCash
register is substantially older that GtkTreeView. You might remember Register2,
Bob Fewell's attempt to rewrite it to use GtkTreeView for GnuCash 2.6. He
wasn't able to make it stable enough and set it aside. It's still in the
codebase: Run gnucash --extra and the Extra menu has "Open Account with
Register2".
Regards,
John Ralls
> On Jul 3, 2020, at 6:05 PM, Chris Good wrote:
>
> Hi Adrien,
>
> Wow, how did I not notice I used GunCash instead of GnuCash in the subject.
>
> I wonder why the glyph is better in Linux than Windows - maybe some-one
> knows...
> I wonder if it is possible to somehow install the Ubuntu font or whatever
> contains the emoji section of Unicode into Windows.
>
> The Ubuntu 'Character Map' application shows the glyphs in Unicode category:
> 'Symbol, Other' under Unicode Block 'Miscellaneous Symbols and Pictographs'.
>
> I also wonder why GnuCash writes to the sheet directly rather than using a
> treeview?
> I'm currently trying to change it so there is a visual indication of an
> attachment without having to go into double line view.
> I cannot get it to make any difference using css but I can use code to
> change the font to Italic, so now I'm working on how to get it to do that to
> the Description only when there is an attachment. This seems the best I can
> do at the moment.
>
> Regards, Chris Good
>
> Message: 4
> Date: Fri, 3 Jul 2020 09:24:40 -0500
> From: Adrien Monteleone
> To: GnuCash Users
> Subject: Re: [GNC]
>
> Message-ID: <38e5d134-3f25-4f25-aa5b-af9ed7020...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> The glyphs are part of the emoji section of Unicode. I don?t expect changing
> the base font is going to affect them.
>
> I?m not sure how to specify just an emoji set.
>
> I?m also not sure if GTK CSS allows rotations and other transforms like web
> CSS, but you might give it a try. However, there doesn?t seem to be any CSS
> hook exposed for the cell where the glyphs are placed on the register sheet,
> so I don?t think you can target them with specificity.
>
> Regards,
> Adrien
>
>> On Jul 3, 2020 w27d185, at 3:31 AM, Chris Good
> wrote:
>>
>> Has anyone figured out how to make the new paper clip and link glyphs
>> look better in Windows 10?
>>
>> In Linux Ubuntu 18.04 they look great but in Windows 10 they look
>> pretty bad, especially the paper clip.
>>
>> Please see attached.
>>
>>
>>
>> C:\Users\cgood\AppData\Roaming\Gnucash\gtk-3.0.css contains :
>>
>> * {
>>
>> font: 16px arial, sans-serif;
>>
>> }
>>
>>
>>
>> Changing the font from 'arial' *does* effect most characters but not
>> the PaperClip or Link glyphs.
>>
>>
>>
>> Here's the definition of the glyphs from
>> src/gnucash/register/register-core/assoccell.h
>>
>> #define GLYPH_PAPERCLIP "\360\237\223\216" // Codepoint U+1F4CE
>>
>> #define GLYPH_LINK "\360\237\224\227" // Codepoint U+1F517
>
> ___
> 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] Accessing online currency rates
Did you remember to run Install Online Price Retrieval for GnuCash from the GnuCash group in the Start Menu? Regards, John Ralls > On Jul 2, 2020, at 4:29 AM, Samantha Payn > wrote: > > I have had to change computers and have installed my existing Gnucash > set-up (in which I could access online currency rates using the "fetch > rate" button) on my new computer but I cannot now access online > currency rates. > > I have installed Strawberry Perl, and added my API key at the right > place but I cannot get the currencies to update. > > Sorry to be a dunce: what am I missing? > > Many thanks for any assistance. > > Samantha > ___ > 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] Split transaction on invoices in foreign currencies
> On Jul 2, 2020, at 10:24 AM, Antonio Roberts wrote: > > Hi David, > > Yes, I think I confused you a bit with my description. Just so we're > on the same page I'll try. > > I've transferred (as an example) €200 to my GBP account and it's now > £177. I had a £10 bank charge and so I'm trying to split the £177 but > when I do this it's asking me to do a currency conversion. > > I guess 'cause the transaction I'm splitting originated from a EUR > transaction it's asking for a conversion. Yes, exactly. The important point for you to understand is what made it an EUR transaction: It was that you created it in an EUR register or if you used the Transfer Dialog it was that of the From Account (the one on the left unless you're have "use formal accounting labels" in which case it's the one on the right). Regards, John Ralls > > On Thu, 2 Jul 2020 at 18:11, D. wrote: >> >> Antonio, >> >> I think the point that John and Frank were making is that if you *entered* >> the transaction in the EUR account, then it will have EUR as its currency, >> and you will be asked to provide an exchange rate for every GBP split that >> is subsequently entered, regardless of your current register. When I read >> your original post, it looks like you created the transaction while in the >> EUR account (you stated "transferred the EUR into my GBP Bank", which >> strongly implies this). If this is in fact what you did, then you can either >> enter the same exchange rate as John suggested, or enter the transaction >> from the GBP account and avoid the subsequent request. >> >> David >> >> >> Original Message >> From: Antonio Roberts >> Sent: Thu Jul 02 12:44:26 EDT 2020 >> To: Adrien Monteleone >> Cc: GnuCash Users >> Subject: Re: [GNC] Split transaction on invoices in foreign currencies >> >>> Unless I read the original post wrong, and the OP could clarify, but it >>> looks like they were entering this split in a GBP based account (the GBP >>> bank account) and adding a GBP split for the bank charge. >> >> Yes, that is correct. I transferred the funds from EUR to GBP account >> and in that transaction line in the GBP account I'm attempting to do a >> split and it's prompting me about currency conversion. >> >> As suggested above I could just do a separate line in the GBP Bank >> Charges expense account but my preference is to split as it shows >> where the charge is inherited from. >> >> Kind regards, >> >> Antonio >> >> On Thu, 2 Jul 2020 at 17:40, Adrien Monteleone >> wrote: >>> >>> Unless I read the original post wrong, and the OP could clarify, but it >>> looks like they were entering this split in a GBP based account (the GBP >>> bank account) and adding a GBP split for the bank charge. >>> >>> Regards, >>> Adrien >>> >>> >>> >>> >>>> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts >>>>> wrote: >>>>> >>>>> I'm in the UK doing most of my accounting in GBP (£) but in this case >>>>> I invoiced someone in EUR (€). Following the advice from here I sent >>>>> up a Bank in EUR, invoiced them in EUR and then transferred the EUR >>>>> into my GBP Bank with the current exchange rate (my bank supplies the >>>>> rate at the time of transaction). >>>>> >>>>> However, this conversion incurred a bank charge in GBP. In GNUcash >>>>> I've gone to my GBP Bank balance to the transaction line to split it >>>>> to deduct the bank transfer. When I do this it's asking me to do a >>>>> currency conversion from EUR to GBP. >>>>> >>>>> The funds are already in the GBP bank so why am I being asked to do >>>>> conversion again? Is there something I've done wrong? >>>> >>>> No, you haven't done anything wrong. Every transaction has a transaction >>>> currency that's used to balance the transaction. That currency is >>>> determined by the account from which the transaction is created, and in >>>> this case it's EUR, so GnuCash needs to know the value in EUR of the bank >>>> charge. Just use the same exchange rate that you used to co
Re: [GNC] Split transaction on invoices in foreign currencies
Read > On Jul 2, 2020, at 9:39 AM, Adrien Monteleone > wrote: > > Unless I read the original post wrong, and the OP could clarify, but it looks > like they were entering this split in a GBP based account (the GBP bank > account) and adding a GBP split for the bank charge. > > Regards, > Adrien > > > > >> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls wrote: >> >> >> >>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts >>> wrote: >>> >>> I'm in the UK doing most of my accounting in GBP (£) but in this case >>> I invoiced someone in EUR (€). Following the advice from here I sent >>> up a Bank in EUR, invoiced them in EUR and then transferred the EUR >>> into my GBP Bank with the current exchange rate (my bank supplies the >>> rate at the time of transaction). >>> >>> However, this conversion incurred a bank charge in GBP. In GNUcash >>> I've gone to my GBP Bank balance to the transaction line to split it >>> to deduct the bank transfer. When I do this it's asking me to do a >>> currency conversion from EUR to GBP. >>> >>> The funds are already in the GBP bank so why am I being asked to do >>> conversion again? Is there something I've done wrong? >> >> No, you haven't done anything wrong. Every transaction has a transaction >> currency that's used to balance the transaction. That currency is determined >> by the account from which the transaction is created, and in this case it's >> EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use >> the same exchange rate that you used to convert the EUR payment to GBP. Read it again: "That currency is determined by the account from which the TRANSACTION IS CREATED." Once the transaction is created its currency is immutable. It matters not a whit in what account one modifies it from. 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] Split transaction on invoices in foreign currencies
> On Jul 2, 2020, at 9:08 AM, Antonio Roberts wrote: > > I'm in the UK doing most of my accounting in GBP (£) but in this case > I invoiced someone in EUR (€). Following the advice from here I sent > up a Bank in EUR, invoiced them in EUR and then transferred the EUR > into my GBP Bank with the current exchange rate (my bank supplies the > rate at the time of transaction). > > However, this conversion incurred a bank charge in GBP. In GNUcash > I've gone to my GBP Bank balance to the transaction line to split it > to deduct the bank transfer. When I do this it's asking me to do a > currency conversion from EUR to GBP. > > The funds are already in the GBP bank so why am I being asked to do > conversion again? Is there something I've done wrong? No, you haven't done anything wrong. Every transaction has a transaction currency that's used to balance the transaction. That currency is determined by the account from which the transaction is created, and in this case it's EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use the same exchange rate that you used to convert the EUR payment to GBP. 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] Custom invoices don't work after upgrade
> On Jul 2, 2020, at 8:37 AM, Frank H. Ellenberger > wrote: > > Hi, > > Am 02.07.20 um 17:01 schrieb lo...@clickworkorange.com: >> On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote: >>> My custom invoice template that I've used for many years stopped >>> working after upgrading to 3.4 as part of a dist-upgrade. I had to >>> remove a few things such as > : > > also 3.4 is several years old. If you prefer to stay on a distribution > shipping such old program versin, you should consider to use > https://wiki.gnucash.org/wiki/Flatpak. > >> I have compared this with the shipped reports (e.g. taxinvoice.scm) and >> it looks correct. So, a few hours killed, no progress. Any suggestions? > > Yes, you should compare the shipped reports, but of a *recent* GnuCash > version 3.11 or 4.0. ISTR they got several improvements in between. Note, however that part of those improvements have come with API deprecated in 3.x and removed outright from 4.0. Report options are implemented as vectors. The second snippet of code that you commented out created an option, so I'd guess that the exception is from an attempt to use that no-longer existing option. For the previous issue about qof-book-get-slots, if you weren't calling that where did the slots argument to (coy-info) come from? Yup, GnuCash's API changes. The release notes accompanying each release explain the changes and since 3.0 functions that are removed are first deprecated so that they emit warnings, but you have to check the trace file to see the warnings. If you don't want to keep up with GnuCash development you have two choices: Never upgrade or don't use custom reports. 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] Error retrieving price quotes
> On Jul 1, 2020, at 10:17 AM, John Haiducek wrote: > > When I try to fetch prices I get the error "There was a system error while > retrieving the price quotes". No error message is printed to the console. > > gnc-fq-dump is able to fetch quotes successfully. > > I'm running gnucash 3.10 with Finance::Quote 1.47 on Fedora 32. For the last couple of years that's most often been because there's a stock set to retrieve quotes from Yahoo! or one of its aliases (though yahoo_json still works). Go through all of your securities and make sure that all of them are set to retrieve from known good sources. If it's still failing, try disabling retrieval on half. If that succeeds, try the other half; if it fails disable half of those remaining. Keep repeating that until you've identified one security that causes the crash. The cause may be immediately apparent, like an invalid source. If not, report back with the security and source that fails. 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] Open Files Error with Chinese Path Name in V4.0
By File Explorer do you mean Windows Explorer or the File Chooser that you use from File>Open? Which ever it is, does the other way work? Regards, John Ralls > On Jun 29, 2020, at 5:25 PM, Chen Thomas wrote: > > Sorry, 3.11 instead of 3.9 mentioned below. > > -Original Message- > From: gnucash-user On > Behalf Of Chen Thomas > Sent: Tuesday, June 30, 2020 8:22 AM > To: GnuCash Users > Subject: [GNC] Open Files Error with Chinese Path Name in V4.0 > > Thanks for releasing V4.0. > Just upgraded it from V3.9 in Windows 10. When I opened GNC files from File > Explorer and an error message showed up due to there are Chinese characters > in my directories. > I usually do it well in V3.9. > > Is there any Asian user who uses non-English Windows OS having the same issue? > > Thank you. > Thomas Chen > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C561805d5b221421142ff08d81c8bd408%7C84df9e7fe9f640afb435%7C1%7C0%7C637290734161366980&sdata=29FgH0L2InBKa2oy5dfW%2BFa38V3qGGWdmllwQnE5q90%3D&reserved=0 > If you are using Nabble or Gmane, please see > https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C561805d5b221421142ff08d81c8bd408%7C84df9e7fe9f640afb435%7C1%7C0%7C637290734161376978&sdata=mSxxlZaQ%2BNrVYJB0LTMUTYbcan42jG6DMdzkVhq%2FqM8%3D&reserved=0 > 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] Gnucash 4.0 not available via Flathub
Thanks, the merge from beta didn't pick up that it needs the swig module. I've fixed that and started a new build. Regards, John Ralls > On Jun 29, 2020, at 12:48 PM, Guillermo Lopez > wrote: > > I am trying to try/use Gnucash 4.0 using Flatpak build. However, the most > recent available version in Flathub is 3.11-1 (2020-06-27). > > Both the Gnucash website and the Flatpak wiki section state that the current > stable version (4.0) is available through Flathub but that is is not (yet) > the case. > > I was trying to look into this. Maybe I am not pointing in the right > directions, but looking at: https://github.com/flathub/org.gnucash.GnuCash, > it seems that the build for 4.0 failed (see > https://flathub.org/builds/#/builders/39/builds/2694) > > I am really looking forward to see 4.0 in Flathub and use it from there until > it reaches my distro. > > Regards, > Guillermo > ___ > 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] 4.0.1 gnucash-cli seg faults on macOS Catalina
I don't think that you're doing anything wrong. GnuCash tries to read files with SQLite3 first then falls back to XML. Interestingly where your trace shows > * 12:05:12 INFO [QofSessionImpl::load_backend] Selected > provider GnuCash Libdbi (SQLITE3) Backend > * 12:05:12 INFO > [QofDbiBackendProvider::type_check] doesn't exist > (errno=2) -> DBI > * 12:05:12 WARN > [GncDbiBackend::session_begin()] Sqlite3 file � > �$� not found > * 12:05:12 INFO [QofSessionImpl::begin] Done running > session_begin on backend > * 12:05:12 ERROR [scm_cleanup_and_exit_with_failure()] Session > Error: Sqlite3 file � > �$� not found mine shows * 15:32:59 INFO [QofSessionImpl::load_backend] Selected provider GnuCash Libdbi (SQLITE3) Backend * 15:32:59 ERROR gnc_uri_get_components: assertion 'uri != NULL && strlen (uri) > 0' failed * 15:32:59 INFO [QofDbiBackendProvider::type_check] doesn't exist (errno=14) -> DBI * 15:32:59 ERROR gnc_uri_get_components: assertion 'uri != NULL && strlen (uri) > 0' failed Segmentation fault: 11 Please do file a bug report and attach the crash report from Applications>Utilities>Console to it. Regards, John Ralls > On Jun 29, 2020, at 9:09 AM, gnucash.dg...@ncf.ca wrote: > > Hi, > > First a big thank you to everyone involved in the effort to bring about the > v4 milestone. Gnucash in an amazingly full-featured and useful tool. The > team's dedication is much appreciated. > > Second, I'm having problems with the new cli tool on the latest macOS > (10.15.5). Before I file a bug, I wanted to check that I am not doing > something wrong or have things misconfigured. It seems to be looking for > sqlite. Does this feature work with the XML back-end? > > ron@Rons-MacBook-Pro MacOS % ./gnucash-cli --debug -R run --name nospace > ~/Documents/finances/CH.gnucash > Application Path /Applications/Gnucash.app/Contents/MacOS/./gnucash-cli > > (process:2067): gnc.gui-WARNING **: 12:05:11.921: [mac_set_languages()] > Language list: en:en_CA:C:es_CA > * 12:05:11 INFO [gnc_module_init_backend_dbi] 3 DBD > drivers found > * 12:05:11 INFO [gnc_module_init_backend_dbi] Driver: pgsql > * 12:05:11 INFO [gnc_module_init_backend_dbi] Driver: > sqlite3 > * 12:05:11 INFO [gnc_module_init_backend_dbi] Driver: mysql > * 12:05:11 INFO [Gnucash::CoreApp::start] System locale returned > (null) > * 12:05:11 INFO [Gnucash::CoreApp::start] Effective locale set to > en_CA. > * 12:05:11 INFO [gnc_hook_num_args] no hook lists > * 12:05:12 MESSG loading saved reports > * 12:05:12 MESSG loading stylesheets > * 12:05:12 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-days, settings_ptr: 0x7fc22700a430, handler_id: 1 > * 12:05:12 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-never, settings_ptr: 0x7fc22700a430, > handler_id: 2 > * 12:05:12 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-days, settings_ptr: 0x7fc22700a430, > handler_id: 3 > * 12:05:12 INFO [gnc_gsettings_register_cb] > schema: general, key: retain-type-forever, settings_ptr: 0x7fc22700a430, > handler_id: 4 > * 12:05:12 INFO [gnc_gsettings_register_cb] > schema: general, key: file-compression, settings_ptr: 0x7fc22700a430, > handler_id: 5 > * 12:05:12 INFO [scm_run_report] Loading datafile � > �$�... > * 12:05:12 INFO [xaccAccountRecomputeBalance] acct=Template > Root starting baln=0/1 > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0e240 template into nsp=0x7fc22700b760 template > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0ecd0 ADF into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0ee30 ADP into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0ee80 AED into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0f2a0 AFA into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0f410 AFN into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0e800 ALL into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0db20 AMD into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0e850 ANG into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0b2b0 AOA into nsp=0x7fc227014860 CURRENCY > * 12:05:12 INFO [gnc_commodity_table_insert] insert > 0x7fc226c0ef80 AON into nsp=0x7fc227014860 CURRENCY > *
Re: [GNC] 4.0.1 attachments symbol
That change is indeed in 4.0, just checked that it works. Regards, John Ralls > On Jun 29, 2020, at 12:40 PM, Adrien Monteleone > wrote: > > I have a thread on the -devel list about this. > > There is an emoji visibility issue with GTK integration on MacOS. (the > paperclip and chain-link symbols are in the emoji section of Unicode) > > I thought a change was made to skip the symbols on Mac and always use the > fall-back lettering (‘f’ and ‘w’) but perhaps that commit wasn’t included in > the release. I suspect it will appear in the first bug-fix release but a > developer would have to confirm this. > > Regards, > Adrien > >> On Jun 29, 2020 w27d181, at 11:17 AM, gnucash.dg...@ncf.ca wrote: >> >> Hi, >> >> The 4.0.1 release notes say: >>• A symbol is now displayed on transactions in the register when they >> have an attachment and the selected font supports the symbol. >> >> When I attached a file to a registry entry, I didn't see the symbol, so I >> assume the default font on macOS Catalina doesn't support it. >> >> Before I start a lot of trial-and-error trying to find a font that works >> (and looks good), does anyone have a suggestion for a sans-serif font that >> works well? >> >> And is ~/Library/ApplicationSupport/GnuCash/config/gtk-3.0/gtk.css the >> correct place to make this change? > > > ___ > 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] 4.0 and Change in Column Widths
Yes, as I explained to David yesterday we decided that that feature needed a re-think for the general registers. The primary motivation was to be able to make layout changes sticky for Bills, Invoices, and Vouchers so we limited it to those (and the new menu items are in the View instead of the Windows menu) and left the account registers as-is. We hope to sort out the issues with general registers and reintroduce it there in a few months. Unfortunately I didn't get the release notes adjusted correctly. I've since fixed them at www.gnucash.org and GitHub. Regards, John Ralls > On Jun 29, 2020, at 10:23 AM, Fross, Michael wrote: > > Hello all, > > Congrats on the 4.0 release. Just installed and I'm looking forward to > setting column width defaults and have them apply across the register > type. However, on Windows, I'm not seeing any extra options in the Windows > menu: > > [image: image.png] > > I was expecting > - Use as Default Layout for this Register Group > - Reset Default Layout for this Register Group > > Lastly, it seems to remember different register widths per account. At > least the ones I tried. > > Is there something that needs to be done to enable this or am I > misunderstanding something? > > Thanks all. > > Michael > ___ > 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] Gnucash 4.0 doesn't launch on MacOS X 10.15.4
That's unfortunately a pretty common user experience on Mac. I haven't been able to figure out where is the disconnect between Launch Services and GnuCash after Gatekeeper verification is complete. Gatekeeper also fails to remove the com.apple.quarantine xattr from the app bundle and that caused a complete failure for one user last week, though it doesn't seem to affect most users. Regards, John Ralls > On Jun 29, 2020, at 9:56 AM, w...@theprescotts.com wrote: > > Ditto on Mac OS 10.15.5. Opened without issues. > The first time it asked for the standard permission to open since it didn't > come from the App Store. > But it didn't open. > Then I opened it again and it was fine. > > Will > > On 2020 Jun 29, at 06-29 11:08:57, Jean Laroche wrote: > > I'm on 10.13.4 (High Sierra) and it launches without any problem. > J > > On 6/29/20 7:58 AM, peterb wrote: >> ...or at least, not on my instance of it. No particular user-visible error >> message, no splash screen visible, lots of stuff in the console. Happy to >> file a bug or share whatever data might help. >> Is anyone else seeing this, or am I unique? >> -P >> ___ >> 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. ___ 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] V4 installation messages/cautions
Thanks, we know about that. We've briefly discussed setting up code signing on Windows but haven't done anything about it as getting a suitable certificate is more involved than it is with Apple. Regards, John Ralls > On Jun 29, 2020, at 7:36 AM, Barry Dewhurst wrote: > > Just installed V4 on my W10Pro laptop 20H2. Thought you might like to see > them. Don't know if you want/need to legitimise GnuCash. > > Regards, > B Dewhurst > ___ > 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] GnuCash 4.0 Released
The GnuCash development team announces GnuCash 4.0 Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features • A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft Windows) for doing command-line things like updating the prices in your book. gnucash-cli gains the ability to run reports from the command line. Specify reports to run by name or guid. It also provides an export format and an output file name without which it will output the report to stdout. • gnucash-cli --report run --name=[reportname/guid] datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html --export-type=TYPE datafile.gnucash • Register Column Widths Register column widths are no longer saved per-account except for open tabs and even widths for open tabs will be reset after upgrading from 3.x or earlier. Instead widths are saved by register type group. The type groups are: • Currency: Ledgers that display amount in debit and credit columns. • APAR: Accounts Payable and Accounts Receivable accounts. • Stock: Ledgers that display amount in a single column with additional columns for Price and Value, the last in Debit and Credit columns. • Journal: Ledgers displaying transactions from multiple accounts where all accounts would be displayed with a Currency type ledger. • Portfolio: Ledgers displaying transactions from multiple accounts where one or more accounts would be displayed with a Stock type ledger. • Customer: Ledgers embedded in invoices. • Employee: Ledgers embedded in expense vouchers. • Vendor: Ledgers embedded in bills. Two menu items are added to the Windows menu when a Register, Bill, Invoice, or Voucher tab has focus: • Use as Default Layout for this Register Group • Reset Default Layout for this Register Group The first saves the currently focused register's column widths and saves them for use by all registers in the same type group. Note that currently open registers will not be affected until they are closed and reopened, and that open registers widths will persist through quitting and restarting GnuCash. The second menu item removes the customization and registers of that type group will therafter use the computed default widths. • When deleting accounts the destination accounts of moved splits will be checked to ensure that they have the same commodity as the source account. If they don't you'll get a warning and the opportunity to pick another account or to carry on regardless. • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. • Python bindings are now localized and their strings available for translation. • A new Transaction Association dialog, available from the Update Association for Transaction menu item that has replaced the two association items in 3.x, allows setting, changing, and deleting associations. • Allow Associations to be added to invoices. The actual association when present is added as a link button which is shown below the notes. • A symbol is now displayed on transactions in the register when they have an attachment and the selected font supports the symbol. • The OFX file importer can now import more than one file at a time. • A new report menu supbmenu Multicolumn contains the old custom-multicolumn report and a new Dashboard report containing Account reports for expenses and income, an income-expense chart, and an account summary. • Support for UK VAT and Australian GST added to the Income-GST report. The reports options are changed from source accounts to source sales and purchase accounts to permit proper reporting of capital purchases. N.B. Th
Re: [GNC] error message with finance::quote gnc-path-check + problems with retrieving quotes for 2 symbols.
> On Jun 22, 2020, at 6:08 PM, uhopfer@gmail wrote: > > I had to reinstall strawberry perl and finance::quote (1.49) and now can > download again all my quotes except for 2 symbols using alpha vantage, > vanguard, or yahoo_json. > > I discovered that gnc-path-check comes back with a programming error message > (below): > > perl gnc-path-check -v 2>temp.txt > > Can't use global $_ in "my" at gnc-path-check line 60, near "my $_ " > Execution of gnc-path-check aborted due to compilation errors. > > That error needs to be fixed, but I do not know any perl. > > I wondered whether the error could be related to my new problem of > retrieving 2 of 3 TIAA-CREF symbols with yahoo_json that I used to be able to > retrieve automatically, but now can only retrieve manually. In other words, > yahoo still has information on the symbols, but f::q does not retrieve it. > The automatic retrieval works for 1, but not the other 2 sumbols. gnc-fq-dump > gives the same anwer. > Dunno where you got gnc-path-check, but it wasn't from us. We have a gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and gnc-fq-update. No gnc-path-check. What same answer does gnc-fq-dump give, that the symbol isn't found? What are the two symbols? Have you tried price source tiaacref? 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] GnuCash 3.906 Released
The GnuCash development team announces GnuCash 3.906, the fifth testing release for what will soon be GnuCash 4.0. This is the release-candidate: Barring any serious bugs it's what we'll release as 4.0 next weekend. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features The intent is to have command categories with subcommands to better enable a richer command line capability as illustrated with the new report commands list and show. • A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft Windows) for doing command-line things like updating the prices in your book. gnucash-cli gains the ability to run reports from the command line. Specify reports to run by name or guid. It also provides an export format and an output file name without which it will output the report to stdout. • gnucash-cli --report run --name=[reportname/guid] datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html --export-type=TYPE datafile.gnucash The GUI command, gnucash responds to the same command line arguments. In order to provide more options its syntax (and gnucash-cli's) for quote retrieval is changed from --add-quotes to --quotes get. • When deleting accounts the destination accounts of moved splits will be checked to ensure that they have the same commodity as the source account. If they don't you'll get a warning and the opportunity to pick another account or to carry on regardless. • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. • Python bindings are now localized and their strings available for translation. • The new reports introduced in the Experimental Reports menu are moved to the main menu and the old reports hidden; the old reports can be unhidden by running GnuCash from the commandline with the --extra argument. That will cause the old reports to appear in their regular locations on the menu labeled (legacy). Note that new reports use different options and layouts and you may need to adjust your saved report configurations. • A new Transaction Association dialog, available from the new Update Transaction Association item in the register context menu, provides the ability to have multiple associations for a single transaction. Associations may now be easily removed. • Allow Associations to be added to invoices. The actual association when present is added as a link button which is shown below the notes. • A symbol is now displayed on transactions in the register when they have an attachment and the selected font supports the symbol. • The OFX file importer can now import more than one file at a time. • A new report menu supbmenu Multicolumn contains the old custom-multicolumn report and a new Dashboard report containing Account reports for expenses and income, an income-expense chart, and an account summary. • When importing, the matcher will no longer offer to match a transaction to one that has already matched in a previous import, nor will it offer to match more than one imported transaction to a single existing transaction. • Support for UK VAT and Australian GST added to the Income-GST report. The reports options are changed from source accounts to source sales and purchase accounts to permit proper reporting of capital purchases. N.B. This is incompatible with previous versions of the report and will require regenerating saved configurations. • Add option to save Layout for Business items Add two menu items under windows, one to save an existing layout for Invoices, Bills and Vouchers to their respective default layouts so the user set column widths will be used. The second menu item will reset the column widths to defaults and remove the default layout. Open Business items will also save
Re: [GNC] Question marks instead of currency in reports
Hard to tell for reports, that would be up to webkit and while I found where it's set in the webkit source I don't see any default value there. Gtk's default on MacOS is SystemDefaultFont (San Francisco on El Cap and later) 12pt. Regards, John Ralls > On Jun 19, 2020, at 4:47 AM, Gio Bacareza wrote: > > I finally solved it! Thank you Adrien. I followed your lead and examined > the style sheets. There I found out that the default style sheets has Fonts > set to NONE. I still don't quite understand what default font GNUCASH > defaults to if it is set at NONE but I experimented and created my own > style sheet and explicitly specified a font. It worked! Thanks Adrien. > > I'm just curious. What font does it default to if it's set to NONE? Thanks > > On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Also, are you using a custom/modified stylesheet for the report with a >> different font for the totals? >> >> Regards, >> Adrien >> >>> On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam < >> christopher@gmail.com> wrote: >>> >>> The only technical difference between regular lines and total lines is >> that >>> the latter is in bold. Try checking your font for bold symbol? >>> >>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote: >>> >>>> it now shows up in the reports but the total is still a question mark. >> see >>>> screenshot below >>>> [image: image.png] >> >> >> ___ >> 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. >> > > > -- > cheers, > > Gio > ___ > 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] Price Database
$ bin/gnc-fq-dump currency HKD USD 1 HKD = 0.12903193 USD Regards, John Ralls > On Jun 17, 2020, at 11:15 AM, Les wrote: > > Thanks for your reply. However, the problem is I have a Hong Kong bank > account that has multiple currencies. The default is HKD, but I need Price > Database to reflect the USD amount for tax reporting. > > (I hope I am stating this correctly.) :) > > Les > > On 6/16/20 7:59 PM, Chris Good wrote: >> Message: 6 >> Date: Tue, 16 Jun 2020 17:04:09 -0500 >> From: Les >> To: gnucash-user@gnucash.org >> Subject: [GNC] Price Database >> Message-ID: >> Content-Type: text/plain; charset=utf-8; format=flowed >> >> Hi All: >> >> For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong >> Kong dollar). >> >> Is anyone else having this problem?? Any suggestions? >> >> Thanks, >> >> Les >> >> Linux Mint 19.3? GC 3.10 (Flatpak) >> >> Hi Les, >> >> Works for me (this is in Linux): >> >> ALPHAVANTAGE_API_KEY=ATALQOFWCSKL2VZ4 ./gnc-fq-dump currency HKD AUD >> 1 HKD = 0.18765 AUD >> >> See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting >> >> Regard, Chris Good >> > ___ > 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] GnuCash 3.905 Released
The GnuCash development team announces GnuCash 3.905, the fourth testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features The intent is to have command categories with subcommands to better enable a richer command line capability as illustrated with the new report commands list and show. • A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft Windows) for doing command-line things like updating the prices in your book. gnucash-cli gains the ability to run reports from the command line. Specify reports to run by name or guid. It also provides an export format and an output file name without which it will output the report to stdout. • gnucash-cli --report run --name=[reportname/guid] datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html datafile.gnucash • gnucash-cli --report run --name=[reportname/guid] --output-file=x.html --export-type=TYPE datafile.gnucash The GUI command, gnucash responds to the same command line arguments. In order to provide more options its syntax (and gnucash-cli's) for quote retrieval is changed from --add-quotes to --quotes get. • When deleting accounts the destination accounts of moved splits will be checked to ensure that they have the same commodity as the source account. If they don't you'll get a warning and the opportunity to pick another account or to carry on regardless. • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. • Python bindings are now localized and their strings available for translation. • The new reports introduced in the Experimental Reports menu are moved to the main menu and the old reports hidden; the old reports can be unhidden by running GnuCash from the commandline with the --extra argument. That will cause the old reports to appear in their regular locations on the menu labeled (legacy). Note that new reports use different options and layouts and you may need to adjust your saved report configurations. • A new Transaction Association dialog, available from the new Update Transaction Association item in the register context menu, provides the ability to have multiple associations for a single transaction. Associations may now be easily removed. • Allow Associations to be added to invoices. The actual association when present is added as a link button which is shown below the notes. • A symbol is now displayed on transactions in the register when they have an attachment and the selected font supports the symbol. • The OFX file importer can now import more than one file at a time. • A new report menu supbmenu Multicolumn contains the old custom-multicolumn report and a new Dashboard report containing Account reports for expenses and income, an income-expense chart, and an account summary. • When importing, the matcher will no longer offer to match a transaction to one that has already matched in a previous import, nor will it offer to match more than one imported transaction to a single existing transaction. • Support for UK VAT and Australian GST added to the Income-GST report. The reports options are changed from source accounts to source sales and purchase accounts to permit proper reporting of capital purchases. N.B. This is incompatible with previous versions of the report and will require regenerating saved configurations. • Add option to save Layout for Business items Add two menu items under windows, one to save an existing layout for Invoices, Bills and Vouchers to their respective default layouts so the user set column widths will be used. The second menu item will reset the column widths to defaults and remove the default layout. Open Business items will also save their column widths to the page section so these can temporarily have different widths. • T
Re: [GNC] Can Finance::Quote look up bond prices by CUSIP?
It's actually not an "issue" with either. Like GnuCash, Finance::Quote is a Free, all-volunteer project and the fact that it doesn't meet your personal needs is your problem and nobody else's. After searching for a bit the only site I found that offers free bond lookup by cusp at all is the empirasign.com that you found. The only other free site for bond prices at all was https://finra-markets.morningstar.com/BondCenter/, but while it claims to search by cusip it wasn't able to find yours. I did eventually find that by searching for Ford, sorting the results by maturity, and binary-searching until I found it. They give F4955773 as the symbol, FWIW. Your best option seems to be to write a F::Q scraper module for empirasign.com. Regards, John Ralls > On Jun 8, 2020, at 11:40 AM, peterb wrote: > > Following up on this: I definitely am unable to look up any bonds by CUSIP > at Alphavantage. I've spot-checked a number of the other sources listed > via gnc-fq-dump and so far have had no luck, so I'd love it if someone > knows what source to use. > > To give a specific example: 34540TWD0 is the cusip for a Ford Motor Credit > bond maturing in 2025 (you can look that up here: > https://www.empirasign.com/findabond/34540TWD0/). But none of the > Finance::Quote sources I've looked at so far can resolve that. Anyone have > any ideas? > > (This is clearly an issue with Finance::Quote and not GnuCash proper, but > I'm hoping someone else has had this issue and found a solution!) > > -Peter > > On Thu, Jun 4, 2020 at 5:43 AM Chris Good wrote: > >> Message: 7 >> Date: Wed, 3 Jun 2020 10:52:18 -0400 >> From: peterb >> To: gnucash-user@gnucash.org >> Subject: [GNC] Can Finance::Quote look up bond prices by CUSIP? >> Message-ID: >>< >> camvdbj7dlfyus+fjyz0n-9hygrr-zpsabptqnggybjzmbst...@mail.gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> Can Finance::Quote be used to look up bond prices? If so, how can I >> configure the security in GnuCash to get this done? >> >> A related question is how can I use it to fetch currency prices. >> >> Thanks! >> >> -Peter >> >> Hi Peter, >> >> Yes to CUSIP. >> Please see >> >> https://wiki.gnucash.org/wiki/Online_Quotes#Finding_the_right_Source_and_Sym >> bol >> >> If you have stocks in different currencies (I think this works by checking >> the currency of the parent account as stocks have their own >> commodity/currency being the stock symbol usually), when you do 'Get >> Quotes' >> in the Price Database, GnuCash will also get any currency conversions >> necessary, and they are visible in the Price Database window. >> >> See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts for >> gnc-fq-dump commands for getting currency conversion rates. >> >> They is plenty of other info in the FAQ, see >> https://wiki.gnucash.org/wiki/FAQ >> >> If you cannot get the prices or currency conversion rates you want, please >> tell us in this mailing list which specific stocks or currencies you are >> after. >> >> Regards, Chris Good >> >> > ___ > 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] manuel en Français
Si vous voulez de l'aide en français, il vaut mieux demander sur la liste de diffusion française: https://lists.gnucash.org/mailman/listinfo/gnucash-fr. Cette liste est en anglais. Regards, John Ralls > On Jun 7, 2020, at 9:13 AM, Philippe POUMAILLOUX > wrote: > > Peut-être cette adresse est-elle préférable ? > Merci de votre aide > Philippe poumailloux > > > > >> Message du 07/06/20 12:20> De : "Philippe POUMAILLOUX" >> A : gnucash-de...@gnucash.org> Copie à : > Objet : manuel en Français > > >> Bonjour, >> >> Trésorier de petites associations, je viens de découvrir votre logiciel, je >> vous remercie pour sa qualité. >> >> Mais très peu à l'aise avec l'anglais, je souhaiterais obtenir un manuel en >> français. est-il disponible ? si oui merci de m'indiquer comment l'obtenir. >> En effet dès que j'actionne l'Aide c'est le manuel en anglais qui m'est >> proposé. Et certaines fenêtres (cloturer le livre par exemple) sont encore >> en anglais. >> >> En autre je souhaiterais clôturer l'exercie 2019. Je me suis servi des >> écritures 2019 pour tester et "apprivoiser" le logiciel mais maintenant >> je souhaite passer les écritures 2020. >> Mais je n'ai pas trouver où, comment cloturer 2019 pour démarer 2020. >> dois-je démarer un nouveau fichier de comptes? >> >> Y-a-t-il un site ou des réponses peuvent être apportée, en français, à des >> questions >> >> Merci des réponses que vous pourrez m'apporter. >> >> Bien cordialement >> >> Philippe Poumailloux > ___ > 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] Download or change GNU Cash language to Spanish
> On Jun 7, 2020, at 12:33 AM, Rafael Dartayet wrote: > > Hello, > > > I wanted to know how may I obtain GNU Cash in Spanish. I have already > downloaded program in English, but I could not change language. > > How can i obtain this software in Spanish? > You already have, though if you're using a distro that has language packs you might have to find the right one with the GnuCash Spanish message catalog. You might find https://wiki.gnucash.org/wiki/Locale_Settings helpful. 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] GnuCash 3.904 Released
The GnuCash development team announces GnuCash 3.904, the third testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features 3.903 was the feature-freeze release. However, the command-line arguments for both gnucash and gnucash-cli have been adjusted as follows: • --add-price-quotes is changed to --quotes get • --run-reports is changed to --report run --name • Added --report list to produce a list of available reports. • Added --report show --name to describe the options changed from the default values in the named report. The intent is to have command categories with subcommands to better enable a richer command line capability as illustrated with the new report commands list and show. • A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft Windows) for doing command-line things like updating the prices in your book. gnucash-cli gains the ability to run reports from the command line. Specify reports to run by name or guid. It also provides an export format and an output file name without which it will output the report to stdout. • gnucash --report run --name=[reportname/guid] datafile.gnucash • gnucash --report run --name=[reportname/guid] --output-file=x.html datafile.gnucash • gnucash --report run --name=[reportname/guid] --output-file=x.html --export-type=TYPE datafile.gnucash • When deleting accounts the destination accounts of moved splits will be checked to ensure that they have the same commodity as the source account. If they don't you'll get a warning and the opportunity to pick another account or to carry on regardless. • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. • Python bindings are now localized and their strings available for translation. • The new reports introduced in the Experimental Reports menu are moved to the main menu and the old reports hidden; the old reports can be unhidden by running GnuCash from the commandline with the --extra argument. That will cause the old reports to appear in their regular locations on the menu labeled (legacy). Note that new reports use different options and layouts and you may need to adjust your saved report configurations. • A new Transaction Association dialog, available from the new Update Transaction Association item in the register context menu, provides the ability to have multiple associations for a single transaction. Associations may now be easily removed. • Allow Associations to be added to invoices. The actual association when present is added as a link button which is shown below the notes. • A symbol is now displayed on transactions in the register when they have an attachment and the selected font supports the symbol. • The OFX file importer can now import more than one file at a time. • A new report menu supbmenu Multicolumn contains the old custom-multicolumn report and a new Dashboard report containing Account reports for expenses and income, an income-expense chart, and an account summary. • When importing, the matcher will no longer offer to match a transaction to one that has already matched in a previous import, nor will it offer to match more than one imported transaction to a single existing transaction. • Support for UK VAT and Australian GST added to the Income-GST report. The reports options are changed from source accounts to source sales and purchase accounts to permit proper reporting of capital purchases. N.B. This is incompatible with previous versions of the report and will require regenerating saved configurations. • Add option to save Layout for Business items Add two menu items under windows, one to save an existing layout for Invoices, Bills and Vouchers to their respective default layouts so the user set column widths will be used. The seco
Re: [GNC] --add-price-quotes prints nothing and always fails with no info
> On Jun 4, 2020, at 2:06 PM, Hong Xu wrote: > > Hi! > > I tried to play with automatic stock price retrieval, but it always failed > (although gnc-fq-dump works well). > > When I run "gnucash --debug --add-price-quotes /path/to/my/gnucash/file", I > got the following output: > > Found Finance::Quote version 1.49. > > Then "echo $?" prints "1". > > gnc-fq-dump works well: > > $ gnc-fq-dump yahoo_json AMZN > Finance::Quote fields Gnucash uses: > symbol: AMZN <=== required > date: 06/04/2020 <=== recommended > currency: USD <=== required > last: 2460.6 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > Is there any way to get more debug information? My system is Debian 10, and > "gnucash -v" outputs: By default GnuCash logs to a file: https://wiki.gnucash.org/wiki/Tracefile. If you want the output to go to the terminal add `--logto=stderr` to the command line. 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] Importing XLM into GNUCash
> On Jun 2, 2020, at 6:42 PM, Daming Gao wrote: > > Dear community members, > > I am very new to GNUCash and here might be a dumb question to ask. > > We are using Logitude software to keep track of our invoices. They are > exportable XML format. Is there a way to import XML into GNUCash? Since the > import function does not support that (I only saw QIF/FIX/CSV…etc). > > Any help could be appreciated! Well, GnuCash's default file format uses XML, but that doesn't mean that it can understand arbitrary XML emitted by any other program. XML is a language for creating data formats, not a format in itself. GnuCash can import invoices but they must be in something resembling a comma-separated-value format with the columns in a specific order. 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] Libboost error upon upgrade to 20.04 from 19.10
Hah! So it was your own build, not Ubuntu's. You should go close your bug report. Regards, John Ralls > On Jun 2, 2020, at 12:03 PM, Tim Kallmer wrote: > > Actually, I was able to resolve my issue just now. I resolved it by deleting > a previous build still present in my folder, /home/username/.local/bin, and > this allowed GC to run without the libboost error. > > On Tue, Jun 2, 2020 at 2:00 PM John Ralls wrote: > If you're able to build GnuCash from source that will resolve the problem. > > Regards, > John Ralls > > > > On Jun 2, 2020, at 11:53 AM, Tim Kallmer wrote: > > > > > ubuntu-bug gnucash > > > > Okay, I filed that bug. Thanks. In the meantime, would building a newer GC > > like 3.10 myself with ninja get me around that libboost error, or would I > > still run into the same road block? > > > > On Mon, Jun 1, 2020 at 9:13 PM Tommy Trussell > > wrote: > > On Mon, Jun 1, 2020 at 7:06 PM Tim Kallmer wrote: > > > The right fix is to get the Ubuntu packager to rebuild the package with > > the new library versions > > > > How do I do that? > > > > File a bug with Ubuntu, I believe. > > > > I don't see it here, though I may have missed it: > > https://bugs.launchpad.net/bugs/bugtrackers/gnucash-bugs > > > > I think if you open a terminal and type > > > > ubuntu-bug gnucash > > > > it will start the bug report process, as described here: > > > > https://help.ubuntu.com/stable/ubuntu-help/report-ubuntu-bug.html.en > > > > > > - > > 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] Libboost error upon upgrade to 20.04 from 19.10
If you're able to build GnuCash from source that will resolve the problem. Regards, John Ralls > On Jun 2, 2020, at 11:53 AM, Tim Kallmer wrote: > > > ubuntu-bug gnucash > > Okay, I filed that bug. Thanks. In the meantime, would building a newer GC > like 3.10 myself with ninja get me around that libboost error, or would I > still run into the same road block? > > On Mon, Jun 1, 2020 at 9:13 PM Tommy Trussell > wrote: > On Mon, Jun 1, 2020 at 7:06 PM Tim Kallmer wrote: > > The right fix is to get the Ubuntu packager to rebuild the package with > the new library versions > > How do I do that? > > File a bug with Ubuntu, I believe. > > I don't see it here, though I may have missed it: > https://bugs.launchpad.net/bugs/bugtrackers/gnucash-bugs > > I think if you open a terminal and type > > ubuntu-bug gnucash > > it will start the bug report process, as described here: > > https://help.ubuntu.com/stable/ubuntu-help/report-ubuntu-bug.html.en > > > - > 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] ANNOUNCE: GnuCash 3.903 Released
Please remember to copy the list on all replies. The very first line of the announcement says "The GnuCash development team announces GnuCash 3.903, the first testing release for what will soon be GnuCash 4.0." ^^^ It's actually the second, but still... Regards, John Ralls > On Jun 1, 2020, at 5:17 PM, Ed Reeder wrote: > > John, > You might want to clarify that this is an experimental/unstable release. > > Thanks for all you do! > > > On Mon, Jun 1, 2020, at 4:38 PM, John Ralls wrote: >> Several of the download links on the original announcement email had >> errors. The correct ones are: >> >> MacOS: >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/Gnucash-Intel-3.903-1.dmg >> https://github.com/Gnucash/gnucash/releases/download/3.903/Gnucash-Intel-3.903-1.dmg >> >> Microsoft Windows: >> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.setup.exe >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.903.setup.exe >> >> Sources: >> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.tar.bz2 >> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.tar.gz >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.903.tar.bz2 >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/3.903/gnucash-3.903.tar.gz >> >> Documentation Sources: >> https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-docs-3.903-1.tar.gz";> >> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-docs-3.903.tar.gz >> >> Regards, >> John Ralls >> >> >> ___ >> gnucash-announce mailing list >> gnucash-annou...@gnucash.org >> https://lists.gnucash.org/mailman/listinfo/gnucash-announce ___ 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] Libboost error upon upgrade to 20.04 from 19.10
> On Jun 1, 2020, at 4:32 PM, Tim Kallmer wrote: > > I get this message now when trying to start GC from the command line: > "gnucash: error while loading shared libraries: libboost_locale.so.1.67.0: > cannot open shared object file: No such file or directory" > > I tried uninstalling my existing build of 3.8, then installing the > Ubuntu software center 3.8. Same error. > > I tried > sudo apt remove gnucash-common gnucash python3-gnucash > sudo apt autoremove > > Any ideas to try next? Boost has the unfortunate habit (shared with ICU) of embedding the release number in their shared library names regardless of compatibility. The libraries are generally compatible as long as they're built with the same compiler so you might be able to get away with symlinks to the libraries gnucash wants to link. For boost those will be libboost_date_time, libboost_filesystem, libboost_locale, and libboost_regex. The right fix is to get the Ubuntu packager to rebuild the package with the new library versions. 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] Unable to set start and end date in Income Statement report
> On Jun 1, 2020, at 2:01 PM, Michael or Penny Novack > wrote: > > >> Yes, I have already tried that. Clicking the dot in the middle does nothing. > > Try again (you are going to laugh at yourself when you get this) > > SOMETIMES this sort of "button" is what is known as "radio", two states, on > or off, and you click on it to switch between state. > > BUT also sometimes there are paired buttons, one of which must be on while > the other is off. That is the case here. You get to change which one is "on" > by clicking whichever is "off" << that turns it on and its partner off >> You got it backwards. A radio button [1] is one of a group of buttons exactly one of which must be selected. A toggle button is called a checkbox [2]. I used w3schools.com references because they have nice demo code built in; the actual controls used in GnuCash are GtkRadioButton [3] and GtkCheckButton [4]. Regards, John Ralls [1] https://www.w3schools.com/tags/att_input_type_radio.asp [2] https://www.w3schools.com/tags/att_input_type_checkbox.asp [3] https://developer.gnome.org/gtk3/stable/GtkRadioButton.html [4] https://developer.gnome.org/gtk3/stable/GtkCheckButton.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.
Re: [GNC] GnuCash 3.903 Released
Several of the download links on the original announcement email had errors. The correct ones are: MacOS: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/Gnucash-Intel-3.903-1.dmg https://github.com/Gnucash/gnucash/releases/download/3.903/Gnucash-Intel-3.903-1.dmg Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.903.setup.exe Sources: https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-3.903.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-3.903.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/3.903/gnucash-3.903.tar.gz Documentation Sources: https://downloads.sourceforge.net/gnucash/gnucash%20%28unstable%29/gnucash-docs-3.903-1.tar.gz";> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-docs-3.903.tar.gz 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] [GNC-dev] GnuCash 3.903 Released
> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > GnuCash is now available as a flatpak from Flathub.org. Instructions for > installing and running. Are at https://wiki.gnucash.org/wiki/Flatpak Sorry. 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] [GNC-dev] GnuCash 3.903 Released
> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > The GnuCash development team announces GnuCash 3.903, the first testing > release for what will soon be GnuCash 4.0. A further note for developers: This release begins Feature Freeze, please commit only bug fix changes until we release 4.0. String freeze is in two weeks, so if you have any commits that will require new or changed translatable strings get them in ASAP! 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] GnuCash 3.903 Released
The GnuCash development team announces GnuCash 3.903, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features For 3.903 • A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft Windows) for doing command-line things like updating the prices in your book. gnucash-cli gains the ability to run reports from the command line. Specify reports to run by name or guid. It also provides an export format and an output file name without which it will output the report to stdout. • gnucash --run-report=[reportname/guid] datafile.gnucash • gnucash --run-report=[reportname/guid] --output-file=x.html datafile.gnucash • gnucash --run-report=[reportname/guid] --output-file=x.html --export-type=TYPE datafile.gnucash • When deleting accounts the destination accounts of moved splits will be checked to ensure that they're the same as the source. If they're not you'll get a warning and the opportunity to pick another account or to carry on regardless. • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. • Python bindings are now localized and their strings available for translation. • The new reports introduced in the Experimental Reports menu are moved to the main menu and the old reports hidden; the old reports can be unhidden by running GnuCash from the commandline with the --extra argument. That will cause the old reports to appear in their regular locations on the menu labeled (legacy). Note that new reports use different options and layouts and you may need to adjust your saved report configurations. • A new Transaction Association dialog, available from the new Update Transaction Association item in the register context menu, provides the ability to have multiple associations for a single transaction. Associations may now be easily removed. • Allow Associations to be added to invoices. The actual association when present is added as a link button which is shown below the notes. • A symbol is now displayed on transactions in the register when they have an attachment and the selected font supports the symbol. • The OFX file importer can now import more than one file at a time. • A new report menu supbmenu Multicolumn contains the old custom-multicolumn report and a new Dashboard report containing Account reports for expenses and income, an income-expense chart, and an account summary. • When importing, the matcher will no longer offer to match a transaction to one that has already matched in a previous import, nor will it offer to match more than one imported transaction to a single existing transaction. • Support for UK VAT and Australian GST added to the Income-GST report. The reports options are changed from source accounts to source sales and purchase accounts to permit proper reporting of capital purchases. N.B. This is incompatible with previous versions of the report and will require regenerating saved configurations. • Add option to save Layout for Business items Add two menu items under windows, one to save an existing layout for Invoices, Bills and Vouchers to there respective default layouts so the user set column widths will be used. The second menu item will reset the column widths to defaults and remove the default layout. Open Business items will also save there column widths to the page section so these can temporarily have different widths. In previous 3.9xx releases • The matcher window columns are changed from R to C and from U+R to U+C, reflecting that the matcher marks transactions cleared but doesn't reconcile them. (Bug 797338) • OFX imports having balance information will now offer to immediately reconcile, passing the balance information in the file to the reconcile info. • Improve quickfill in the account pickers to filter
Re: [GNC] Using Quicken direct connect with USAA
Ah, that would explain why the Next button was disabled: You had no accounts to assign. So the issue would seem to be that the first account download didn't take, though the AQBanking dialog box indicated that it should have. Regards, John Ralls > On May 25, 2020, at 4:41 PM, Jon Schewe wrote: > > Yes, I checked the Accounts tab after downloading the accounts the > first time and the tab was empty. I even tried backing all the way out > of the wizard and restarting GnuCash and the tab was still empty. > > On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: >> When you first set up the User in the AQBanking Wizard did you check >> the Accounts tab after downloading the accounts the first time? >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 11:47 AM, Jon Schewe wrote: >> >> It just started working "magically". I tried manually creating an >> account and associating it with a GnuCash account. Then tried getting >> the balance and got an error that I had the account number wrong. So >> I >> went back into the AQBanking Wizard and executed Retrieve Account >> List >> to get the full account number. Now when I went over to the accounts >> tab my accounts are there! I was able to associate them with the >> right >> GnuCash accounts and it seems to be working. >> >> I went back through my setup and deleted my aqbanking user and wrote >> up >> the steps that worked. It seems there is something about needing a >> dummy account created, otherwise aqbanking won't save the account >> information that it retrieved. >> >> Here are the steps, note the bit about a dummy account. >> >> * Tools -> Online Banking Setup... >> * Create User >> * Next >> * OFX-DirectConnect backend >> * Run >> * Next >> * Select >> * USAA >> * Select bank and click OK >> * Next >> * Enter USAA number with zeros on the left to make the number 9 >> digits for the User Name and the User Id >> * Next >> * Next >> * Next >> * Retrieve Account List >> * Enter PIN >> * Finish >> * Click on the Accounts tab >> * If it's empty, create a dummy account using the aqofxconnect >> backend >> * OK >> * Leave everything blank >> * OK >> * Dismiss message about unable to update >> * Users >> * Edit User >> * Bank Settings >> * Retrieve Account List >> * Close >> * Click on Accounts tab and see the new accounts, delete the dummy >> account >> * Close >> * Next >> * Associate to GnuCash accounts, looking at the account number works >> well >> * Next >> * Apply >> * Test by opening a GnuCash account that was associated with USAA >> * Actions -> Online Actions -> Get Balance >> * See the balance show up in a dialog >> >> On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: >> >> Thank you for your help thus far. >> >> I noticed that I had AQBanking and GnuCash installed both inside and >> outside flatpak. I've removed the version outside flatpak, but that >> didn't help. >> >> If there are some additional debugging steps that are suggested for >> checking aqbanking, let me know and I can see where the integration >> with GnuCash is breaking. >> >> On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: >> >> Well, that's progress. The communication with USAA is clearly >> working. >> >> Maybe the flatpak sandbox isn't letting GnuCash see the results from >> AQBanking. Unfortunately I don't have time to investigate this >> further today. >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 9:29 AM, Jon Schewe wrote: >> >> John, >> >> Using those settings got me different information in the dialog. >> However I still don't have an option to associate the accounts. When >> I close the dialogs I'm back to "Start Online Banking Wizard" and the >> match step is still grey. >> >> 11:24:16 Saving communication log to 1 >> 11:24:16 Sending request... >> 11:24:16 Using GnuTLS default ciphers. >> 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- >> GCM:AEAD >> 11:24:16 Waiting for response... >> 11:24:17 Saving communication log to 1 >> 11:24:17 Parsing response... >> 11:24:17 Status for signon request: Success (Code 0, severity "INFO") >> The server successfully processed the request. >>
Re: [GNC] Using Quicken direct connect with USAA
When you first set up the User in the AQBanking Wizard did you check the Accounts tab after downloading the accounts the first time? Regards, John Ralls > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So I > went back into the AQBanking Wizard and executed Retrieve Account List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend >* OK >* Leave everything blank >* OK >* Dismiss message about unable to update >* Users >* Edit User >* Bank Settings >* Retrieve Account List >* Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA >* Actions -> Online Actions -> Get Balance >* See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: >> Thank you for your help thus far. >> >> I noticed that I had AQBanking and GnuCash installed both inside and >> outside flatpak. I've removed the version outside flatpak, but that >> didn't help. >> >> If there are some additional debugging steps that are suggested for >> checking aqbanking, let me know and I can see where the integration >> with GnuCash is breaking. >> >> On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: >> >> Well, that's progress. The communication with USAA is clearly >> working. >> >> Maybe the flatpak sandbox isn't letting GnuCash see the results from >> AQBanking. Unfortunately I don't have time to investigate this >> further today. >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 9:29 AM, Jon Schewe wrote: >> >> John, >> >> Using those settings got me different information in the dialog. >> However I still don't have an option to associate the accounts. When >> I close the dialogs I'm back to "Start Online Banking Wizard" and the >> match step is still grey. >> >> 11:24:16 Saving communication log to 1 >> 11:24:16 Sending request... >> 11:24:16 Using GnuTLS default ciphers. >> 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- >> GCM:AEAD >> 11:24:16 Waiting for response... >> 11:24:17 Saving communication log to 1 >> 11:24:17 Parsing response... >> 11:24:17 Status for signon request: Success (Code 0, severity "INFO") >> The server successfully processed the request. >> 11:24:17 Status for account info request: Success (Code 0, severity >> "INFO") >> The server successfully processed the request. >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account (no bank code)/ ((no bank >> name)/ACCOUNT) >> 11:24:17 Operation finished, you can now close this window. >> >> Jon >> >> On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: >> >> Jon, >> >> The Application Settings I use for USAA are >> Application ID: QWIN >> Application Version: 2200 >> Header Version: 102 >> >> In Special Settings: >> HTTP Version, Client UID, and Security Type are blank, Force SSLv3 >> and Send Short Dat
Re: [GNC] Using Quicken direct connect with USAA
Well, that's progress. The communication with USAA is clearly working. Maybe the flatpak sandbox isn't letting GnuCash see the results from AQBanking. Unfortunately I don't have time to investigate this further today. Regards, John Ralls > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. However I > still don't have an option to associate the accounts. When I close the > dialogs I'm back to "Start Online Banking Wizard" and the match step is still > grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: >> Jon, >> >> The Application Settings I use for USAA are >> Application ID: QWIN >> Application Version: 2200 >> Header Version: 102 >> >> In Special Settings: >> HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send >> Short Date are checked, and Send Empty Bank ID and Send Empty FID are >> unchecked. >> >> Another user had trouble with USAA because he had entered a Client UID on >> the User Settings page, so make sure that's blank too. >> >> Yes, SSL v3 is less secure than TLS, but it's better than sending the data >> in the clear, and yes, the authentication that USAA uses on OFX >> DirectConnect is less than ideal. >> >> Regards, >> John Ralls >> >> >> On May 25, 2020, at 8:59 AM, Jon Schewe wrote: >> >> Alan, >> >> Thanks for the suggestion. I tried not setting any special settings and >> make sure the SSL v3 is unchecked. Still no change. >> >> As far as security goes, this method for getting my transactions >> appears less secure than using Web Connect. When I login to get to the >> Web Connect download I need to enter a one time password from my phone, >> but for Direct Connect I only need my PIN. >> >> Jon >> >> On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: >> Jon, >> >> Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no >> reputable financial institution should be supporting it for financial >> transactions. >> >> As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. >> Suggest not setting any of the "special settings" options, and never enable >> SSL >> v2 or v3 for any program, except for testing with non-sensitive data. >> >> -Original Message- >> From: gnucash-user >> [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of >> Jon Schewe >> Sent: Monday, May 25, 2020 10:36 AM >> To: gnucash-user >> Subject: [GNC] Using Quicken direct connect with USAA >> >> I have been using the Web Connect with USAA for years and that's worked >> great. >> However now I see that they are discontinuing support for this feature. So >> I'm >> trying to setup Direct Connect. I found the instructions for setting up USAA >> at >> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, >> however I'm not seeing the "Server Capabilities" tab to select the account >> list >> download options. >> >> I'm using GnuCash 3.10 from flatpak. >> I'm on Linux. >> >> I have the following Settings: >> "User Settings" >> User Name, User id and Client UID all set to my USAA number. I have tried >> both >> with the 00 prefix and without. >> >> "Bank Settings" >> Broker ID: 5874 >> FID: 24591 >> ORG: USAA >> Server URL: https://service2.usaa.com/ofx/OFXServlet >> >> "Application Settings" >> I've tried the default appl
Re: [GNC] Using Quicken direct connect with USAA
Jon, The Application Settings I use for USAA are Application ID: QWIN Application Version: 2200 Header Version: 102 In Special Settings: HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send Short Date are checked, and Send Empty Bank ID and Send Empty FID are unchecked. Another user had trouble with USAA because he had entered a Client UID on the User Settings page, so make sure that's blank too. Yes, SSL v3 is less secure than TLS, but it's better than sending the data in the clear, and yes, the authentication that USAA uses on OFX DirectConnect is less than ideal. Regards, John Ralls > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to the > Web Connect download I need to enter a one time password from my phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: >> Jon, >> >> Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no >> reputable financial institution should be supporting it for financial >> transactions. >> >> As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. >> Suggest not setting any of the "special settings" options, and never enable >> SSL >> v2 or v3 for any program, except for testing with non-sensitive data. >> >> -Original Message- >> From: gnucash-user >> [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of >> Jon Schewe >> Sent: Monday, May 25, 2020 10:36 AM >> To: gnucash-user >> Subject: [GNC] Using Quicken direct connect with USAA >> >> I have been using the Web Connect with USAA for years and that's worked >> great. >> However now I see that they are discontinuing support for this feature. So >> I'm >> trying to setup Direct Connect. I found the instructions for setting up USAA >> at >> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, >> however I'm not seeing the "Server Capabilities" tab to select the account >> list >> download options. >> >> I'm using GnuCash 3.10 from flatpak. >> I'm on Linux. >> >> I have the following Settings: >> "User Settings" >> User Name, User id and Client UID all set to my USAA number. I have tried >> both >> with the 00 prefix and without. >> >> "Bank Settings" >> Broker ID: 5874 >> FID: 24591 >> ORG: USAA >> Server URL: https://service2.usaa.com/ofx/OFXServlet >> >> "Application Settings" >> I've tried the default application settings and the settings that should be >> for >> Quicken 2017: >> Application ID: QWIN >> Application Version: 2600 >> Header Version: 102 >> >> Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. >> I've checked "Force SSLv3". >> >> When I go back to the "Bank Settings" tab I see the following after clicking >> on >> "Retrieve Account List". >> >> 09:26:37 Sending request... >> 09:26:37 Using GnuTLS default ciphers. >> 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD >> 09:26:37 Waiting for response... >> 09:26:37 Operation finished, you can now close this window. >> >> The AqBanking Setup never lets me get to the point of associating USAA >> accounts >> with GnuCash accounts. Can someone give me some pointers on what is wrong >> here? >> >> Thank you, >> Jon >> >> > > ___ > 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] is there a transaction limit on converting xml to mysql
> On May 25, 2020, at 2:43 AM, Jeff wrote: > > With the help of another member of the GNC users group I was able to get > MySQL (on Windoze 10) to work with book files that contain a couple of years > worth of records and basically a default checkbook register setup. I need to > convert a set of books that contains 20+ years of transactions in the > neighborhood of 100 accounts and goodness knows ow many transactions. > > But every time I try to save as a MySQL file the "save as MySql" errors out > and locks up GNC after about 15 minutes (have to kill it with task manager). > The message is encountered corrupt data, and I cannot find an error log > anywhere. > > I tried exporting as a GNC CSV file and importing it into a MySQL file. Same > problem. Also tried 5 year exports, same problem. (note could not get > PostgreSQL to work either). > > Is there a maximum number of transactions that GNC will convert to MySQL? Or > is there a setting somewhere I am missing? > > Once I can get MySQL on Windoze working I will need to get it working on a > network with Windoze and Ubuntu but that is a question for later. > > Using: Version: 3.8 Build ID: 3.8b+(2019-12-29) Finance::Quote: - on Windoze > 10 Pro and Windoze 10. Also the last stable release of Ubuntu (sorry don't > remember the version, 18.04lts I think). There's no limit programmed in, though it's possible that there might be a memory leak. However if I understand correctly that it crashed importing CSV data without GnuCash in the middle it would seem to be a problem either with the data or with your MySQL installation. We're not able to provide support for database servers, it's way beyond our competence. Administering a database server is harder than it looks so we have a simple rule: In order to use one with GnuCash you must be a competent database admin for the server you choose or must have one working for you. Anything short of that puts your data at risk. 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] What does OFX Direct Connect do?
No, OFX is a file format. Many financial/bank websites offer OFX or QFX downloads of your transaction data; more in fact than offer OFX Direct Connect. Since OFX (and it's slightly altered evil twin QFX, for Quicken Financial eXchange) are formats expressly designed for transferring consumer transaction information it's a more efficient and less error prone way to import transactions into programs like GnuCash. If your bank offers OFX Direct Connect then GnuCash can connect to your bank and get that OFX download. If not but allows downloading OFX-formatted files then you go to the bank website, log in, and get the download, then use File>Import>Import OFX/QFX to import it. Regards, John Ralls > On May 18, 2020, at 2:20 PM, Fran_3 wrote: > > Woops! No ill intent. I've seen the same response on other SIG's when someone > started a new thread that a groups member or admin thought should have been > included in a recent thread on that some related topic. Oh well. > > Back to the topic... so OFX just saves you the steps of downloading the > transactions as CSV and then having to do a bit of formatting before you > import them into GC... right? > > > > On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls > wrote: > > > Don't hijack threads, it's rude. Start a new one when you have a new question. > > OFX Direct Connect is just like importing an OFX or QFX file downloaded from > your bank's website except that it will connect to the bank and get the OFX > file for you. > > Regards, > John Ralls > > > > On May 18, 2020, at 10:27 AM, Fran_3 wrote: > > > > If I can jump in here I would like to learn more about OFX Direct Connect > > with GnuCash. > > > > Does such automatically determine what transactions occur at the bank that > > are not in GC... > > And then automatically update GnuCash? > > > > Or what? > > > > Thanks. > > > > > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls > > wrote: > > > > > > > > > > > On May 17, 2020, at 12:06 PM, Hershey wrote: > > > > > > I'm new to Gnu and am having issues setting up online downloads. > > > My first attempt is Wells Fargo and I get a 2000 error message. > > > The Tutorial show Wells Fargo in its example but I've also seen this > > > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash > > > doesn't support this authentication. > > > > That last sentence is your answer, but perhaps you need some more detail. > > There are two ways of connecting to a bank for OFX online communication, > > OFX Direct Connect and OFX Web Connect. The former collects your user name > > and password as part of the online session and the latter has you log in to > > the bank's website and launch the OFX session from there. The way that the > > bank's website connects to the financial software is proprietary to Intuit, > > the makers of Quicken, so that it works only with their products. GnuCash > > is able to work only with OFX Direct Connect. > > > > 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. ___ 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] Use of Webkit-GTK in GNC
> On May 18, 2020, at 11:51 AM, Mark Sutton wrote: > > On Mon, May 18, 2020 at 10:48:12AM -0700, John Ralls wrote: >> Don't hijack threads, it's rude. Start a new one when you have a new >> question. >> >> OFX Direct Connect is just like importing an OFX or QFX file downloaded from >> your bank's website except that it will connect to the bank and get the OFX >> file for you. > > I hope this does not seem like a hijack, but this discussion made me think > I should ask a question that has been on my mind since Jan. > What is the use profile of webkit in gnucash. I thought for some reason > it only was used to render reports created by gnucash. ie. never interacts > with foreign data. Is that correct? I wonder because of remote exploit-ability > of versions prior to 2.26.3. At least you changed the subject line, but I don't see why you didn't just create a new message instead of replying to an unrelated one. Yes, GnuCash uses webkit only for rendering reports and doesn't expose the WebKit API to scripting, though a bad actor with privs to install arbitrary files into a users directory could get WebKit to read a maliciously installed file. On the other hand if a bad actor has that kind of access to your machine there are probably less arcane ways cause trouble. 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] What does OFX Direct Connect do?
Don't hijack threads, it's rude. Start a new one when you have a new question. OFX Direct Connect is just like importing an OFX or QFX file downloaded from your bank's website except that it will connect to the bank and get the OFX file for you. Regards, John Ralls > On May 18, 2020, at 10:27 AM, Fran_3 wrote: > > If I can jump in here I would like to learn more about OFX Direct Connect > with GnuCash. > > Does such automatically determine what transactions occur at the bank that > are not in GC... > And then automatically update GnuCash? > > Or what? > > Thanks. > > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls > wrote: > > > > > > On May 17, 2020, at 12:06 PM, Hershey wrote: > > > > I'm new to Gnu and am having issues setting up online downloads. > > My first attempt is Wells Fargo and I get a 2000 error message. > > The Tutorial show Wells Fargo in its example but I've also seen this > > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash > > doesn't support this authentication. > > That last sentence is your answer, but perhaps you need some more detail. > There are two ways of connecting to a bank for OFX online communication, OFX > Direct Connect and OFX Web Connect. The former collects your user name and > password as part of the online session and the latter has you log in to the > bank's website and launch the OFX session from there. The way that the bank's > website connects to the financial software is proprietary to Intuit, the > makers of Quicken, so that it works only with their products. GnuCash is able > to work only with OFX Direct Connect. > > 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. ___ 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] wells fargo downloads
> On May 17, 2020, at 12:06 PM, Hershey wrote: > > I'm new to Gnu and am having issues setting up online downloads. > My first attempt is Wells Fargo and I get a 2000 error message. > The Tutorial show Wells Fargo in its example but I've also seen this > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash > doesn't support this authentication. That last sentence is your answer, but perhaps you need some more detail. There are two ways of connecting to a bank for OFX online communication, OFX Direct Connect and OFX Web Connect. The former collects your user name and password as part of the online session and the latter has you log in to the bank's website and launch the OFX session from there. The way that the bank's website connects to the financial software is proprietary to Intuit, the makers of Quicken, so that it works only with their products. GnuCash is able to work only with OFX Direct Connect. 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] Reordering splits in a transaction
> On May 16, 2020, at 5:26 PM, peterb wrote: > >> >> On 15 May 2020 at 9:03, peterb said: >>> >> * I have a recurring transaction with a very complicated split. At some *> >> * point, the splits in the recurring transaction seem to have organized *> >> * themselves in a confusing way - seemingly not related to the order in *> >> * which I entered them. *> >>> >> * Is there any way to reorder splits within a transaction short of "Type * >>> >> * everything over again from top to bottom?" Is the (seeming) >> self-ordering *> >> * of the splits themselves inevitable, and if so, is there some underlying >> *> >> * principle by which they are arranging themselves? *> >>> >> * -P * I also have a recurring SX with multiple splits and messy >> calculations (5 >> parameters, 8 splits). The splits mostly show up in the same order >> (modulo debits-before-credits) but not always. It seems the sort order is >> nondeterminate. I don't regard it as important. > > > Understood. The reason it matters to me is that my recurring transaction is > _almost_ identical, but not exactly - several values tend to fluctuate by a > few pennies every month. This means that I end up having to play > hunt-the-split, whereas if the order was preserved I could use that to > quickly zero in on the changed value. > > But it sounds like this is just the way the cards have been dealt, so maybe > I'll file an enhancement request on the bug tracker and go on with my > life. Thanks! Change the amount to a variable in the SX template transaction, then the SLR dialog box will ask you for the amount when it runs. 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] Is there a better way enter multi-currency split transaction?
Trading splits are ignored; they don't turn on the ---split transaction--- flag in the Transfer Account cell. I think what's causing grief is the no-value Asset:Stock:ABC split. Regards, John Ralls > On May 16, 2020, at 9:39 AM, Derek Atkins wrote: > > Arguably a transaction that has 2 trading account splits and 2 regular > account splits should be treated like a regular transaction. > > -derek > Sent using my mobile device. Please excuse any typos. > On May 16, 2020 10:07:02 AM John Ralls wrote: > >>> On May 16, 2020, at 4:48 AM, Adrien Monteleone >>> wrote: >>> >>> >>> >>>> On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: >>>> >>>> Not sure whether this is a software limitation or there is a better way to >>>> do this. For example, the following memorized transaction for recording >>>> stock dividend in USD and Dividend Income in EUR >>>> >>>> >>>> Totalal Deposit Withdrawal >>>> Asset\Citibank\USD100.00 >>>> Trading\Currency\EUR 92.00 >>>> Asset\Stock\ABC >>>> Income\Dividend 92.00 >>>> Trading\Currency\USD 100.00 >>>> >>>> My experience is the first time I enter this transaction in the Bank's USD >>>> account, the exchange rate screen will popup and convert USD 100.00 to EUR >>>> 92 in Income\Dividend. All I have to do is to add a dummy split to indicate >>>> the relevant stock for this dividend. >>> >>> You could just put the stock as a Memo in one of the relevant splits. I >>> don’t see a need for a dummy split. >>> >>>> >>>> However, if I re-enter this transaction with USD 50.00 using the memorized >>>> transaction feature, only the first split transaction will be updated with >>>> "50.00" and I have to manually change the remain >>>> 3 figures. Exchange rate windows won't popup to calculate the currency >>>> conversion. >>> >>> Hmm... Seems like a bug. If you are entering transaction with two >>> currencies GC will either ask, or make a guess, but I’ve never seen it do >>> neither. What happens if you change the Dividend amount (as if you were >>> entering this for the first time)? Does GC create new Trading or Imbalance >>> splits? Does it alter the existing Trading splits? >>> >> >> It's not autofill, that finished when it filled in the transaction with a >> copy of the other one that matched. It's because if there's more than two >> splits GnuCash doesn't know how to apportion the changed amount so the edit >> in basic view changes only the split in the current account. >> >> 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. > > > ___ 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] Is there a better way enter multi-currency split transaction?
> On May 16, 2020, at 4:48 AM, Adrien Monteleone > wrote: > > > >> On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: >> >> Not sure whether this is a software limitation or there is a better way to >> do this. For example, the following memorized transaction for recording >> stock dividend in USD and Dividend Income in EUR >> >> >> Totalal Deposit Withdrawal >> Asset\Citibank\USD100.00 >> Trading\Currency\EUR 92.00 >> Asset\Stock\ABC >> Income\Dividend 92.00 >> Trading\Currency\USD 100.00 >> >> My experience is the first time I enter this transaction in the Bank's USD >> account, the exchange rate screen will popup and convert USD 100.00 to EUR >> 92 in Income\Dividend. All I have to do is to add a dummy split to indicate >> the relevant stock for this dividend. > > You could just put the stock as a Memo in one of the relevant splits. I don’t > see a need for a dummy split. > >> >> However, if I re-enter this transaction with USD 50.00 using the memorized >> transaction feature, only the first split transaction will be updated with >> "50.00" and I have to manually change the remain >> 3 figures. Exchange rate windows won't popup to calculate the currency >> conversion. > > Hmm... Seems like a bug. If you are entering transaction with two currencies > GC will either ask, or make a guess, but I’ve never seen it do neither. What > happens if you change the Dividend amount (as if you were entering this for > the first time)? Does GC create new Trading or Imbalance splits? Does it > alter the existing Trading splits? > It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash doesn't know how to apportion the changed amount so the edit in basic view changes only the split in the current account. 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] Stock "split" exchanging shares of different currencies?
> On May 15, 2020, at 11:48 AM, Jim DeLaHunt wrote: > > > On 2020-05-15 11:21, Adrien Monteleone wrote: >> It was difficult to tell from your original post, because the >> tabbing/spacing didn’t quite line up, but I’d say perhaps you have a split >> in the wrong column. (dr/cr, buy/sell— my example above might not line up >> either, so I added the Dr/Cr labels just in case.) > > I formatted my original message using HTML tables for the transactions. My > hope was that the table would survive in the message everyone read, making it > clear which numbers were credits and which were debits. I see now that the > list flattened the table out in a way that was unclear. I will resend my > message with the transactions formatted differently. > > However, in my examples, I believe the amounts were in the correct > credit/debit columns. > >> The proper end transaction might be one with both CAD and USD currency >> account splits, or else one without either. I too would think if all splits >> otherwise balance, there shouldn’t be any currency splits. > > Then we agree. The fund trading splits otherwise balance, so I expect to see > no currency splits. But one currency split and one offsetting imabalance > split appear. > > >> You traded CAD-2800 for USD-2000, was the price 10/14 (USD/CAD) that day in >> your price db? (or since you noted, those were simplified, do the real price >> moves reflect the entry in the price db for that day?) If the price db entry >> is off, that might account for why GC is trying to balance it further. It >> sees you are conducting transactions using accounts with two different >> currencies and trying to make them balance based on a price between those >> currencies. If it doesn’t ask for a price, or for whatever reason uses the >> wrong one, you’ll get an Imbalance situation. > The prices of 10 USD / 14 CAD are simplifications I entered into the example > transaction. (More precisely: the split amounts of 2000 USD / 28000 USD are > also in the transaction, and matter more.) You make a good point that the > price database might be involved. However, the simplified transaction is set > in the future, so the only entries in the price database would be from this > example transaction. >> If you received what looked like a transfer window when entering the >> transaction, be sure to enter the price using the debit/credit radio button, >> and do not fetch the price or grab one from the db. This way, you are >> specifying the FX rate and GC will create a new entry in the price db. > > This transaction did not put up a transfer funds dialogue. I'm familiar with > that dialogue, so I'm confident it did not appear. > > I appreciate your interest in the question. I will re-send my message, with > the transactions formatted in a way better able to survive the email list. Jim, Use plain text with a fixed-width typeface to be sure that the formatting survives the list server. GnuCash only knows how to balance transactions in currency so there's always a currency involved, it's the one for the account that you start from or if that account has a non-currency commodity like a stock, it's the currency of the first parent account that has a currency. For a transfer between commodity accounts you use only the currency of the account you start in. The price doesn't really matter, it's just there so that GnuCash can make sure that the transaction is balanced, but to make things look good you probably want to use the (average) purchase price of the shares. If you try to do it in basic mode GnuCash thinks you're just selling the stock and screws it up, so start in split view and create the two splits *using the same price for each*. This is starting from DLR.U: 5/15/2020 Transfer to DLR USD:ETF:DLR.U -200 10.00 2,000.00 CAD:ETF:DLR 200 10.00 2,000.00 When you commit the transaction GnuCash will add the trading account splits: Trading:FUND:DLR.U 200 10.00 2,000.00 Trading:FUND:DLR-200 10.00 2,000.00 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] Can't open app w MacOS Catalina
The problem is that GnuCash 2.6.x was built as 32-bit to support running on MacOSX 10.5 and 10.6. Apple removed 32-bit support from Catalina. You need to upgrade GnuCash to a 3.x release. Regards, John Ralls > On May 11, 2020, at 9:30 AM, Sean Perlmutter wrote: > > Thanks so much for your reply, John. > > It's version 2.6.18. After the OS update, the app simply won't launch. I > don't know how to run it from the Terminal. > > -Sean > >> On May 11, 2020, at 9:12 AM, John Ralls wrote: >> >> >> >>> On May 11, 2020, at 9:01 AM, Sean Perlmutter >>> wrote: >>> >>> Hi Gnu brain trust, >>> >>> Forgive me: noob here. Just updated to MacOS Catalina and now I'm unable to >>> open the application. How to resolve? >>> >>> Any help is appreciated. Thanks in advance. >> >> What version of GnuCash? What happens? Have you tried running it from >> Terminal? >> >> 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] Can't open app w MacOS Catalina
> On May 11, 2020, at 9:01 AM, Sean Perlmutter wrote: > > Hi Gnu brain trust, > > Forgive me: noob here. Just updated to MacOS Catalina and now I'm unable to > open the application. How to resolve? > > Any help is appreciated. Thanks in advance. What version of GnuCash? What happens? Have you tried running it from Terminal? 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] Transaction Report Default Account
> On May 10, 2020, at 12:43 AM, flywire wrote: > > Something must have changed eg: > https://www.gnucash.org/docs/v3/C/gnucash-guide/figures/cbook_TransactionRptAssets.png > > I know I can change the report setting. Can someone point me to the guile > file on my computer for that report? I'd like to tweak it. The transaction report is in C:\Program Files (x86)\gnucash\share\gnucash\scm\gnucash\report\standard-reports\transaction.scm If you can configure the report to your liking with the options there's no need to mess with the report code, just save the report configuration. If you decide that you really do need to customize the report you'll want to read https://wiki.gnucash.org/wiki/Custom_Reports. 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] Can't find GNC_CONFIG_HOME or USER_DATA_HOME on Linux
> On May 9, 2020, at 1:18 PM, Sam Quintanar via gnucash-user > wrote: > > I read the documentation that suggests I use a gtk-3.0.css to change the > colors of the Register. > This file should be in the folder GNC_CONFIG_HOME to keep color changes > limited to GNC, but such a folder does not exist on Ubuntu 18.04. > Am I expected to create the GNC_CONFIG_HOME folder, and then create the > gtk-3.0.css inside it? No, GNC_CONFIG_HOME isn't a literal, it stands in for an OS-dependent location. See https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_CONFIG_HOME 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] Adding Transactions From Another Program
GNU BASH, a.k.a. the Bourne Again Shell (because it was originally a Free clean
room clone of SysV's Bourne Shell) is the default shell (terminal command
processor) on many Linux systems. The manual is at
https://www.gnu.org/software/bash/manual/bash.html and you'll find abundant
documentation and discussion about it on the web. It has nothing at all to do
with GnuCash and discussing it further in this list wouldn't be appropriate.
GnuCash Help is half of GnuCash's documentation and is available from
Help>Contents in the GnuCash GUI and from https://www.gnucash.org/docs.phtml.
It's focused on the details of using the GUI and won't be of much help in
writing scripts that operate on GnuCash data. The developer documentation at
https://code.gnucash.org/docs/MASTER will be more useful, they document parts
of GnuCash's C API, not all of which is exposed to Python.
If you want a summary of GnuCash's command line options use `gnucash --help`.
The only command-line batch operation GnuCash has built in is price import.
The importers are not accessible from the language bindings, though the QIF
importer is written in Guile so a proficient Schemer could import its modules
directly.
Regards,
John Ralls
> On May 7, 2020, at 10:44 PM, Hal Vaughan wrote:
>
>
>
>> Begin forwarded message:
>>
>> From: Hal Vaughan
>> Subject: Re: [GNC] Adding Transactions From Another Program
>> Date: May 8, 2020 at 1:42:28 AM EDT
>> To: david whiting
>>
>> I think that’s it!
>>
>> First, a comment: I went on and installed Homebrew and things seemed to work
>> - until I tried running pip. Nope. It looks for $PYENV_COMMAND_PATH and
>> that’s null. (Even after rebooting and using a new terminal.) And people
>> wonder why I hate those add-ons like that.
>>
>> Okay, on topic - yes, this could work. I got curious - is there a way I can
>> do more to automate this? For instance, run my Python script, have it parse
>> the GC file, then create the QIF file, save it. Then I thought, "It would
>> be nice if it could get GC to import the new QIF file, then exit GC and
>> delete the QIF file all one one shot. I did some searching and found
>> something that said to try "Gnucash help." No "—" before the "help," but I
>> tried it. GC came up, but I tried typing "help" in the console again. When
>> I quit GC, I got this:
>>
>> These shell commands are defined internally. Type `help' to see this list.
>> Type `help name' to find out more about the function `name'.
>> Use `info bash' to find out more about the shell in general.
>> Use `man -k' or `info' to find out more about commands not in this list.
>>
>> A star (*) next to a name means that the command is disabled.
>>
>> JOB_SPEC [&] (( expression ))
>> . filename [arguments] :
>> [ arg... ] [[ expression ]]
>> alias [-p] [name[=value] ... ] bg [job_spec ...]
>> bind [-lpvsPVS] [-m keymap] [-f fi break [n]
>> builtin [shell-builtin [arg ...]] caller [EXPR]
>> case WORD in [PATTERN [| PATTERN]. cd [-L|-P] [dir]
>> command [-pVv] command [arg ...] compgen [-abcdefgjksuv] [-o option
>> complete [-abcdefgjksuv] [-pr] [-o continue [n]
>> declare [-afFirtx] [-p] [name[=val dirs [-clpv] [+N] [-N]
>> disown [-h] [-ar] [jobspec ...]echo [-neE] [arg ...]
>> enable [-pnds] [-a] [-f filename] eval [arg ...]
>> exec [-cl] [-a name] file [redirec exit [n]
>> export [-nf] [name[=value] ...] or false
>> fc [-e ename] [-nlr] [first] [last fg [job_spec]
>> for NAME [in WORDS ... ;] do COMMA for (( exp1; exp2; exp3 )); do COM
>> function NAME { COMMANDS ; } or NA getopts optstring name [arg]
>> hash [-lr] [-p pathname] [-dt] [na help [-s] [pattern ...]
>> history [-c] [-d offset] [n] or hi if COMMANDS; then COMMANDS; [ elif
>> jobs [-lnprs] [jobspec ...] or job kill [-s sigspec | -n signum | -si
>> let arg [arg ...] local name[=value] ...
>> logout popd [+N | -N] [-n]
>> printf [-v var] format [arguments] pushd [dir | +N | -N] [-n]
>> pwd [-LP] read [-ers] [-u fd] [-t timeout] [
>> readonly [-af] [name[=value] ...] return [n]
>> select NAME [in WORDS ... ;] do CO set [--abefhkmnptuvxBCHP] [-o opti
>> shift [n] shopt [-pqsu] [-o long-option] opt
>> source filename [arguments]suspend [-f]
>> test [expr]time [-p] PIPELINE
>> times trap [-lp] [arg signal_spe
Re: [GNC] Adding Transactions From Another Program
Homebrew isn't necessarily irrelevant, but if you decide to build with jhbuild and gtk-osx (https://wiki.gnucash.org/wiki/MacOSX/Quartz) it gets in the way. There's another, older, turn-your-mac-into-linux system called MacPorts that provides GnuCash. You'll wind up building yourself but you may find that it's less painful than gtk-osx, particularly if you want to keep Homebrew. There are instructions for this build at https://wiki.gnucash.org/wiki/MacOSX/MacPortsDetail. GnuCash developer emeritus Mike Alexander uses this method. You might also be able to install all of the dependencies with Homebrew and then build GnuCash on top of that. I've never tried and there's no existing recipe so you'd have to figure out what are the Homebrew names for everything and get it all installed. Once you have the dependencies in place building isn't hard and doesn't require any C/C++ or Scheme programming skill, just some familiarity with build systems like Cmake. Yes, you will have to build a new GnuCash every time you want to upgrade, but once you have everything set up and working it's just running a single build script and waiting an hour or four. Regards, John Ralls > On May 7, 2020, at 11:22 AM, Hal Vaughan wrote: > > It took me time to do some research on this. (Even with staying at home now, > I have a ton going on and had to spend several full days just fixing my > tractor.) > > Homebrew looked like it wasn’t much of a problem and I installed it. > Everything still works. (That’s another part of research - I still have to > go through the folder where all my scripts are and figure out which ones I > still need that may be using oddball or outdated Perl or Python modules. I > have notes on a number of them that I use whenever I upgrade to a new > computer, so that’ll help, but it’s still a time waster!) > > So, ignoring the entertaining auto-correct issue here, if I use Homebrew, it > just installs from a stock .dmg image. So if I want Python bindings, > Homebrew is irrelevant? As in it doesn’t matter if I use it or not, I can > just get the source code for GC and compile it on my system to get the > bindings. Is that right? > > That leads to a number of questions: > 1. I’m not inexperienced as a programmer, but it’s almost all with Perl, > Python, and Java. Years ago I did some C++, but have done very little in > learning how to control compilers. How hard is compiling GC from scratch? > 2. If I compile from scratch, do I have to add anything extra to get Python > bindings, or do I just have to select the option for that when I compile? > 3. What about upgrades? Will I have to recompile GC every time I want to > upgrade it on my system? (That is, assuming I want to keep the bindings?) > > From what people are saying, trying to add entries is not good, but that I > can import from a CSV or TSV file. > > While that was on another branch of this thread, that does bring up a few > questions: > > 1. Is there any protection to keep GC from importing the same transaction > multiple times? For instance, if I have a transaction for interest in a CSV > file, then add another in the file and re-import, will GC note one > transaction it’s importing is identical to another and flag it for me? > 2. Is there any way, from within GC, to run an external script that would > create the interest entries? Then, once they’re created, I could import that > CSV file? Or would I have to run the interest calculating script from > outside GC? > > > Hal > >> On Apr 30, 2020, at 11:51 PM, D. wrote: >> >> Hal, >> >> John Ralls, the person who manages the Mac end of GnuCash, has pointed out >> that Homebrew simply uses the GnuCash dmg for its installation. That dmg >> does not include python bindings, so the answer to your question is "No, >> Homebrew does not include python. You would need to clozapine GnuCash >> yourself." >> >> David T. >> >> >> Original Message >> From: Hal Vaughan >> Sent: Fri May 01 01:32:14 GMT+05:30 2020 >> To: Gnucash >> Subject: Re: [GNC] Adding Transactions From Another Program >> >> Actually, this has me looking over what I am and am not still using. >> >> Since Mac is still using Python 2.7, but Catalina is coming up and that >> includes Python 3.x. So I’m looking over what I use and what I don’t among >> my decades of scripts. >> >> Last I looked, pretty much every system like that usurped the originals. At >> the time, when I looked them over, it became clear to me why they did that >> and it made sense. But, again, that decision was some
Re: [GNC] Gnucash logs
> On May 5, 2020, at 9:58 PM, Chris Good wrote: > > > > Does anyone else have some input? > > If this is going to be ready for GnuCash 4.0 due 20 June 2020, I need to get > started ASAP. Otherwise, it > > won’t be available till 5.0 which is not listed in > https://wiki.gnucash.org/wiki/Release_Schedule > > but 4.11 is planned for 2022-12-18. > Feature freeze is the next beta release on 31 May, and you'll need to allow some time for your PR to get reviewed. 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] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)
> On May 4, 2020, at 1:07 PM, Daffy Duck wrote: > > Hello, > > I'd been using online banking forever, but since upgrading to Fedora 32 > last week, I now get this error when I try to fetch transactions: > > error on executing job. status: enqueued (1) > > It shows in a popup. > > If I go into online banking setup and try to retrieve accounts, it just > crashes. > > gnucash-3.10-1.fc32.x86_64 > > aqbanking-6.0.1-2.fc32.x86_64 > > gwenhywfar-5.1.2-2.fc32.x86_64 > > Any ideas? Yes, AQBanking between 5.99.0 and 6.1.4 doesn't work with OFX DirectConnect. https://bugzilla.redhat.com/show_bug.cgi?id=1830609 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] How do I add stock trades?
Not quite right. While it's correct that in GnuCash's code a currency is a commodity with a special namespace, and that an account has only one commodity member variable, it's not quite right about a non-currency commodity account not having a currency. Remember that a split has two commodity fields, amount and value, and that transactions have a transaction currency field. It's called transaction currency because it *must* be a currency, and it's the currency in which all of the value fields are denominated. If you begin a transaction in an account register whose commodity is non-currency GnuCash will look up the hierarchy until it finds a parent account in currency and use the first one it finds for the transaction currency. It does the same in reports, in the Accounts page, and in the summary bar when applying prices from the pricedb. That currency of the first parent account with a currency for its commodity is sometime referred to in the documentation as that child account's currency. Regards, John Ralls > On May 2, 2020, at 10:16 AM, Adrien Monteleone > wrote: > > Yes, I misspoke. Thank you. Technically it is denominated in itself. And > technical accuracy is no minor point, especially with accounting, and leads > to clearer understanding. > > Regards, > Adrien > > >> On May 2, 2020 w18d123, at 11:42 AM, D. wrote: >> >> Adrien, >> >> I'm sure I have this wrong, but my understanding is that stock and >> currencies are both commodities, and that any given account is denominated >> in one. So a stock's "currency" is that commodity (that is, the ABC account >> is denominated in the ABC commodity). How it gets converted into a different >> currency (e.g., AUD) depends on the parent account. >> >> That is, of course, all technicalities. The rest is correct. >> >> David > > > ___ > 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] Working with dates in Postgresql DB
That's exactly what happened a few years ago to a guy from California who did some updates while visiting New Zealand. Regards, John Ralls > On May 1, 2020, at 3:16 PM, David H wrote: > > Might be a problem if you were in Perth on April 11 entering txns and then > back in California on April 10 entering further txns using today's date ? > i.e. if you travelled to a timezone that was still the previous day ? > > Cheers David H. > > > On Sat, 2 May 2020 at 04:35, D. via gnucash-user > wrote: > I understand that a lot of debate and discussion and heartache had gone into > this, so I really don't mean to be a pain, but it would seem to me that if I > entered April 10, 2020 for a transaction, and GnuCash then stored 2020-04-10 > HH:MM:SS (where HH:MM:SS represents any arbitrary time), if GnuCash then > ignored the time portion from that point forth, then I'd see April 10, 2020 > no matter how many times I crossed the date line. If I'm in California on > April 10, or in Perth on April 11, I'm presumably going to pick "today's" > date for my transaction. The two dates would be different, even if the > transactions were entered at the exact same time, but I could only see this > as a potential problem for a business with offices in both cities. > > As I said, I don't remember all the details, but I'm sure there were solid > reasons for choosing to take transaction dates and store them in UTC, to be > converted back to some arbitrary time zone at a later time. It makes my head > hurt, though. > > David > > > Original Message > From: John Ralls > Sent: Fri May 01 23:30:37 GMT+05:30 2020 > To: "D." > Cc: finf...@gmail.com, "D. via gnucash-user" > Subject: Re: [GNC] Working with dates in Postgresql DB > > David, > > You're not thinking it through: It's about 11:00 on Friday 1 May here in > California but it's 03:00 on Saturday 2 May in Western Australia. Chopping > off the time doesn't solve anything, a point illustrated by Finfort when he > pointed out that just changing the time on the errant dates would put them in > the wrong day. > > Regards, > John Ralls > > > > > > On Apr 30, 2020, at 10:24 PM, D. wrote: > > > > Thanks for the reply. I do understand the challenges this poses-- both from > > the perspective of managing it on a daily basis, and from that of the > > difficulty of changing the underlying system. At least, conceptually! > > > > Is there any option to simply ignore the time portion in these timestamps? > > It would seem to me that one could focus on that, and simplify the process > > piece by piece. Of course, not being a programmer, I'm just a silly voice > > in the wilderness. > > > > David > > > > > > Original Message > > From: John Ralls > > Sent: Fri May 01 10:32:09 GMT+05:30 2020 > > To: "D." > > Cc: "finf...@gmail.com" , "D. via gnucash-user" > > > > Subject: Re: [GNC] Working with dates in Postgresql DB > > > > David, > > > > I don't know why the decision was made to use time, it was taken long > > before I joined the project, but it probably has to do with that being the > > way computers keep time, in UTC and the accompanying date-time manipulation > > functions in the C standard library were readily available. Over the years > > various developers have piled more manipulation functions on top of it, or > > added other libraries to the side because they made doing something easier, > > and splattered it all over the code so that changing the base design would > > involve chasing down and reworking all of those disparate functions. As I > > said, no one has expressed much enthusiasm for taking it on. > > > > Knowing now that using time instead of date was a poor decision is just > > applying 20/20 hindsight to criticize Linas's decision 22 years ago. It > > can't change it. I can't say that I would have decided differently. > > > > Regards, > > John Ralls > > > > > >> On Apr 30, 2020, at 8:46 PM, D. wrote: > >> > >> John, > >> > >> I somewhat remember the discussion back in 2011 about the timestamp, but > >> do not recall all the details. Remind me why it is that GnuCash uses > >> timestamps in these date fields? All these steps and workarounds that take > >> place to present the proper date around the world. > >> > >> Wouldn't it be
Re: [GNC] Working with dates in Postgresql DB
David,
You're not thinking it through: It's about 11:00 on Friday 1 May here in
California but it's 03:00 on Saturday 2 May in Western Australia. Chopping off
the time doesn't solve anything, a point illustrated by Finfort when he pointed
out that just changing the time on the errant dates would put them in the wrong
day.
Regards,
John Ralls
> On Apr 30, 2020, at 10:24 PM, D. wrote:
>
> Thanks for the reply. I do understand the challenges this poses-- both from
> the perspective of managing it on a daily basis, and from that of the
> difficulty of changing the underlying system. At least, conceptually!
>
> Is there any option to simply ignore the time portion in these timestamps? It
> would seem to me that one could focus on that, and simplify the process piece
> by piece. Of course, not being a programmer, I'm just a silly voice in the
> wilderness.
>
> David
>
>
> Original Message
> From: John Ralls
> Sent: Fri May 01 10:32:09 GMT+05:30 2020
> To: "D."
> Cc: "finf...@gmail.com" , "D. via gnucash-user"
>
> Subject: Re: [GNC] Working with dates in Postgresql DB
>
> David,
>
> I don't know why the decision was made to use time, it was taken long before
> I joined the project, but it probably has to do with that being the way
> computers keep time, in UTC and the accompanying date-time manipulation
> functions in the C standard library were readily available. Over the years
> various developers have piled more manipulation functions on top of it, or
> added other libraries to the side because they made doing something easier,
> and splattered it all over the code so that changing the base design would
> involve chasing down and reworking all of those disparate functions. As I
> said, no one has expressed much enthusiasm for taking it on.
>
> Knowing now that using time instead of date was a poor decision is just
> applying 20/20 hindsight to criticize Linas's decision 22 years ago. It can't
> change it. I can't say that I would have decided differently.
>
> Regards,
> John Ralls
>
>
>> On Apr 30, 2020, at 8:46 PM, D. wrote:
>>
>> John,
>>
>> I somewhat remember the discussion back in 2011 about the timestamp, but do
>> not recall all the details. Remind me why it is that GnuCash uses timestamps
>> in these date fields? All these steps and workarounds that take place to
>> present the proper date around the world.
>>
>> Wouldn't it be simpler just to store a bare date?
>>
>> Or just ignore the time portion and drop the conversion between UTC and
>> locale time altogether?
>>
>> Everyone refers to them as dates ("transaction date" "invoice date" "posting
>> date"). The software arbitrarily uses the same time for everything in a
>> futile attempt to properly display dates for all timezones (the solution in
>> this thread underscores that fact, insofar as you are recommending the user
>> to arbitrarily change all other times to the "standard").
>>
>> Of what use is it to store the added detail of an arbitrary timestamp in a
>> field that is treated everywhere as a date? What is gained?
>>
>> David T.
>>
>>
>> Original Message
>> From: John Ralls
>> Sent: Fri May 01 00:48:57 GMT+05:30 2020
>> To: "finf...@gmail.com"
>> Cc: Gnucash Users
>> Subject: Re: [GNC] Working with dates in Postgresql DB
>>
>> GnuCash stores all dates as UTC but displays them as local, applying the
>> timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00
>> displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but
>> 2020-02-21 21:00:00 displays as 2020-02-21.
>>
>> Regards,
>> John Ralls
>>
>>
>>> On Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote:
>>>
>>> It is not just adding one day, it depends on the time.
>>>
>>> Looks like time 00:00:00 is the same date, not next.
>>>
>>> From 21:00:00 is the next date in most cases, but I did not check all
>>> transactions manually =)
>>>
>>> How the program converts this wrong dates to the correct ones in its GUI?
>>>
>>> I believe I have found a correct way to convert all the dates including
>>> wrong ones to correct dates in Postgresql (pgAdmin 4):
>>>
>>>
>>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS
>>> DATE_AT_timezone_EEST
>>>
>>>
Re: [GNC] Adding Transactions From Another Program
Maybe one supplied by a drug manufacturer. Google tells me that Clozapine is an antipsychotic. Regards, John Ralls > On Apr 30, 2020, at 9:54 PM, D. via gnucash-user > wrote: > > "clozapine"="compile" > > Not sure what dictionary my machine is using! > > > Original Message > From: "D. via gnucash-user" > Sent: Fri May 01 09:21:46 GMT+05:30 2020 > To: Hal Vaughan > Cc: "D. via gnucash-user" > Subject: Re: [GNC] Adding Transactions From Another Program > > Hal, > > John Ralls, the person who manages the Mac end of GnuCash, has pointed out > that Homebrew simply uses the GnuCash dmg for its installation. That dmg does > not include python bindings, so the answer to your question is "No, Homebrew > does not include python. You would need to clozapine GnuCash yourself." > > David T. > > > Original Message > From: Hal Vaughan > Sent: Fri May 01 01:32:14 GMT+05:30 2020 > To: Gnucash > Subject: Re: [GNC] Adding Transactions From Another Program > > Actually, this has me looking over what I am and am not still using. > > Since Mac is still using Python 2.7, but Catalina is coming up and that > includes Python 3.x. So I’m looking over what I use and what I don’t among > my decades of scripts. > > Last I looked, pretty much every system like that usurped the originals. At > the time, when I looked them over, it became clear to me why they did that > and it made sense. But, again, that decision was something like 10 years ago > and I haven’t had time or cause to revisit it - until now. > > Do you know if Homebrew can provide the Python bindings for GC? > > > Hal > >> On Apr 30, 2020, at 2:27 AM, Adrien Monteleone >> wrote: >> >> Have you investigated Homebrew vs. MacPorts? >> >> Just curious if the Perl issues are the same. >> >> Regards, >> Adrien >> >>> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan wrote: >>> >>> I’ve checked out the bindings - as I mentioned in my original post, the >>> problem is that using the bindings on a Mac requires MacPorts. I’ve had >>> issues before, since MacPorts (and other similar systems) usurp some of the >>> normal paths for things like Perl and Python. I don’t use Perl for coding >>> anymore, but I have Perl scripts I’ve been using for over a decade that do >>> some simple work for me. I had an important Perl script I was using that >>> used a specific Perl library. I don’t remember which one it was, but when >>> I added MacPorts and tried to run my script a week later, it crashed. >>> >>> I had no idea MacPorts, Fink, Homebrew, and similar systems usurped the >>> normal system paths for scripting languages. When I installed it, and it >>> took over for Perl, it put in a system without all the libraries my scripts >>> used and some of the libraries that were available to me with a standard >>> Perl install (libraries I had installed from CPAN) would not install in the >>> new system. I had to completely remove MacPorts to get my old scripts to >>> work. >>> >>> I’d love to use MacPorts, since it makes a lot available to me that I can’t >>> easily add now (unless I start using a Linux VM), but that experience >>> taught me never to trust such a system. >>> >>> I think it would be a lot easier for me to do this with Python bindings, >>> but I still use older scripts for things I need to do once a month or once >>> a year and I don’t want to risk breaking them again like they broke about a >>> decade ago when I installed MacPorts. >>> >>> >>> Hal >> >> >> ___ >> 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
Re: [GNC] Superannuation Co-Vid payment
No, but using the money to buy gold is. Regards, John Ralls > On Apr 30, 2020, at 9:31 PM, outlook_a062af9f159be...@outlook.com > wrote: > > The idea behind the Australian Govt. allowing early access to one’s > superannuation is economic stimulation NOT speculation. > > > Sent from [1]Mail for Windows 10 > > > From: [2]flywire > Sent: Friday, 1 May 2020 11:19 AM > To: [3]Gnucash Users > Subject: [GNC] Superannuation Co-Vid payment > > > oz > > ___ > > 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://wikignucash.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. > > > Virus-free. [4]www.avast.com > > References > > Visible links: > 1. https://go.microsoft.com/fwlink/?LinkId=550986 > 2. mailto:flywi...@gmail.com > 3. mailto:gnucash-user@gnucash.org > 4. > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient > > Hidden links: > 6. > https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient > 7. file://localhost/tmp/tmpmm8j7D.html#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2 > ___ > 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] Working with dates in Postgresql DB
David,
I don't know why the decision was made to use time, it was taken long before I
joined the project, but it probably has to do with that being the way computers
keep time, in UTC and the accompanying date-time manipulation functions in the
C standard library were readily available. Over the years various developers
have piled more manipulation functions on top of it, or added other libraries
to the side because they made doing something easier, and splattered it all
over the code so that changing the base design would involve chasing down and
reworking all of those disparate functions. As I said, no one has expressed
much enthusiasm for taking it on.
Knowing now that using time instead of date was a poor decision is just
applying 20/20 hindsight to criticize Linas's decision 22 years ago. It can't
change it. I can't say that I would have decided differently.
Regards,
John Ralls
> On Apr 30, 2020, at 8:46 PM, D. wrote:
>
> John,
>
> I somewhat remember the discussion back in 2011 about the timestamp, but do
> not recall all the details. Remind me why it is that GnuCash uses timestamps
> in these date fields? All these steps and workarounds that take place to
> present the proper date around the world.
>
> Wouldn't it be simpler just to store a bare date?
>
> Or just ignore the time portion and drop the conversion between UTC and
> locale time altogether?
>
> Everyone refers to them as dates ("transaction date" "invoice date" "posting
> date"). The software arbitrarily uses the same time for everything in a
> futile attempt to properly display dates for all timezones (the solution in
> this thread underscores that fact, insofar as you are recommending the user
> to arbitrarily change all other times to the "standard").
>
> Of what use is it to store the added detail of an arbitrary timestamp in a
> field that is treated everywhere as a date? What is gained?
>
> David T.
>
>
> Original Message
> From: John Ralls
> Sent: Fri May 01 00:48:57 GMT+05:30 2020
> To: "finf...@gmail.com"
> Cc: Gnucash Users
> Subject: Re: [GNC] Working with dates in Postgresql DB
>
> GnuCash stores all dates as UTC but displays them as local, applying the
> timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00
> displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but
> 2020-02-21 21:00:00 displays as 2020-02-21.
>
> Regards,
> John Ralls
>
>
>> On Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote:
>>
>> It is not just adding one day, it depends on the time.
>>
>> Looks like time 00:00:00 is the same date, not next.
>>
>> From 21:00:00 is the next date in most cases, but I did not check all
>> transactions manually =)
>>
>> How the program converts this wrong dates to the correct ones in its GUI?
>>
>> I believe I have found a correct way to convert all the dates including
>> wrong ones to correct dates in Postgresql (pgAdmin 4):
>>
>>
>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS
>> DATE_AT_timezone_EEST
>>
>> EEST is a correct zone in my case. CEST does not work.
>>
>> The transactions.post_date type is timestamp without timezone: 2017-12-31
>> 21:00:00
>>
>> t.post_date AT TIME ZONE 'EEST' AS timestamp_AT_timezone_EEST gives
>> 2017-12-31 21:00:00+3
>>
>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS
>> DATE_AT_timezone_EEST gives 2018-01-01
>>
>> Looks strange but works.
>>
>> 2.
>>
>> There are only 3 transactions with 22:00:00 not connected with invoices.
>>
>> There is only 1 transaction with 21:00:00 not connected with invoices.
>>
>> Thinking how to find them...
>>
>>
>>
>> On 30/04/2020 21:25, John Ralls wrote:
>>> Hmm, true. Should be always, since you're in a time zone east of the prime
>>> meridian. So you also want to increment the day on those. I think it would
>>> be safest to do it in two queries, the first one being
>>>
>>> update transactions post_date = post_date + interval '1 day' where
>>> post_date::TIME != '10:59:00';
>>>
>>> and the second to update the time as before.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>> On Apr 30, 2020, at 11:07 AM, Finfort wrote:
>>>>
>>>> If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real
>>>> date is 2018-
Re: [GNC] Working with dates in Postgresql DB
We show no times at all. The smallest useful division of time in accounting is a day. Unfortunately someone decided a long time ago to use unix time to represent dates, probably because in 1998 that was what was readily available. Naturally you want to display in local time, otherwise you have the problem of "today" not being aligned with what you think it is. This design decision has caused a great deal of pain over the years because people refuse to stay put and so the meaning of "today" changes depending on where they are. A few years ago we worked out that 10:59:00 UTC has the same date in nearly all time zones and set the time on the post_date timestamps to that value. That fixes the changing-date problem for almost everyone, the exception being timezones -11, +14, and +15. We adjust the 10:59:00 if you happen to be in one of those timezones so that today will be what you think it is, but if you then travel across the date line to a timezone more than 23 hours different you'll see the dates on your transactions change. The right solution is to change the date representation to not use time so it doesn't care about time zone, but that's a major change and so far nobody's had the appetite to take it on. Regards, John Ralls > On Apr 30, 2020, at 1:06 PM, GWB wrote: > > Curious about this. So is the goal to show all times in UTC on > invoices along with local time? I tend to default most things to UTC > (including local time on computers) and just display in some local > time if necessary. If GMT is available as a time zone, I use that > (GMT is a timezone; UTC is not). Last time I checked, GMT does not > change for DST (but some locales might try to use GMT with DST), and > displays the same as UTC. Time zones like Tehran's also differ by 30 > minutes, not 60, from adjacent time zones. I think DST is silly, but > a fourth of the planet does not, so their call in their countries. > > Cyprus *might* be a special case, but probably not. My assumption is > that the entire Island is in the same time zone, but I don't know what > you would get if you pinged a time server in Akrotiri or Dhekelia > (British Overseas Territories), which seems to be GMT +3 (during DST). > Moscow, Ankara, Sudan, Hungary, and quite a few others are not EEST, > but rather UTC +3/GMT +3, which results in the same time. > > Postgres does have a somewhat confusing way of handling timestamp > (timestamp without timezone) versus timestamptz (timestamp with time > zone): > > https://dba.stackexchange.com/questions/2796/how-do-i-get-the-current-unix-timestamp-from-postgresql > > That applies when doing conversions to and from unix time; not sure if > it affects the situation here. > > Gordon > > On Thu, Apr 30, 2020 at 2:19 PM John Ralls wrote: >> >> GnuCash stores all dates as UTC but displays them as local, applying the >> timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00 >> displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but >> 2020-02-21 21:00:00 displays as 2020-02-21. >> >> Regards, >> John Ralls >> >> >>> On Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote: >>> >>> It is not just adding one day, it depends on the time. >>> >>> Looks like time 00:00:00 is the same date, not next. >>> >>> From 21:00:00 is the next date in most cases, but I did not check all >>> transactions manually =) >>> >>> How the program converts this wrong dates to the correct ones in its GUI? >>> >>> I believe I have found a correct way to convert all the dates including >>> wrong ones to correct dates in Postgresql (pgAdmin 4): >>> >>> >>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS >>> DATE_AT_timezone_EEST >>> >>> EEST is a correct zone in my case. CEST does not work. >>> >>> The transactions.post_date type is timestamp without timezone: 2017-12-31 >>> 21:00:00 >>> >>> t.post_date AT TIME ZONE 'EEST' AS timestamp_AT_timezone_EEST gives >>> 2017-12-31 21:00:00+3 >>> >>> date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS >>> DATE_AT_timezone_EEST gives 2018-01-01 >>> >>> Looks strange but works. >>> >>> 2. >>> >>> There are only 3 transactions with 22:00:00 not connected with invoices. >>> >>> There is only 1 transaction with 21:00:00 not connected with invoices. >>> >>> Thinking how to find them... >>> >>> >>>
Re: [GNC] Working with dates in Postgresql DB
GnuCash stores all dates as UTC but displays them as local, applying the timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00 displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but 2020-02-21 21:00:00 displays as 2020-02-21. Regards, John Ralls > On Apr 30, 2020, at 11:42 AM, finf...@gmail.com wrote: > > It is not just adding one day, it depends on the time. > > Looks like time 00:00:00 is the same date, not next. > > From 21:00:00 is the next date in most cases, but I did not check all > transactions manually =) > > How the program converts this wrong dates to the correct ones in its GUI? > > I believe I have found a correct way to convert all the dates including wrong > ones to correct dates in Postgresql (pgAdmin 4): > > > date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS > DATE_AT_timezone_EEST > > EEST is a correct zone in my case. CEST does not work. > > The transactions.post_date type is timestamp without timezone: 2017-12-31 > 21:00:00 > > t.post_date AT TIME ZONE 'EEST' AS timestamp_AT_timezone_EEST gives > 2017-12-31 21:00:00+3 > > date(t.post_date AT TIME ZONE 'UTC' AT TIME ZONE 'EEST') AS > DATE_AT_timezone_EEST gives 2018-01-01 > > Looks strange but works. > > 2. > > There are only 3 transactions with 22:00:00 not connected with invoices. > > There is only 1 transaction with 21:00:00 not connected with invoices. > > Thinking how to find them... > > > > On 30/04/2020 21:25, John Ralls wrote: >> Hmm, true. Should be always, since you're in a time zone east of the prime >> meridian. So you also want to increment the day on those. I think it would >> be safest to do it in two queries, the first one being >> >> update transactions post_date = post_date + interval '1 day' where >> post_date::TIME != '10:59:00'; >> >> and the second to update the time as before. >> >> Regards, >> John Ralls >> >> >>> On Apr 30, 2020, at 11:07 AM, Finfort wrote: >>> >>> If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real >>> date is 2018-01-01. At least in cases where I manually checked the invoices. >>> Setting all times to 10:59:00 will give wrong dates in the program. >>> Now they are displayed correctly in the program somehow... >>> >>> >>> >>>> On Apr 30, 2020 at 20:59, wrote: >>>> >>>> I don't think that's necessary. >>>> >>>> To fix the wrong times just do an update query, something like >>>> >>>> update transactions set post_date::TIME = 10:59:00 where post_date::TIME >>>> != 10:59:00; >>>> >>>> I don't know Postgresql's date-time functions well enough to know if that >>>> syntax works, you might have to adjust it a bit. You might create a table >>>> with a DATETIME column and put a couple of rows in it to test against >>>> while you tweak. Make sure that GnuCash isn't connected to the database >>>> when you run that. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Apr 30, 2020, at 10:45 AM, Finfort wrote: >>>>> How can I help? >>>>> I can send you my gnucash file if it helps to find all the bugs. >>>>> And how can I change now my wrong dates in transactions? >>>>> >>>>>> On Apr 30, 2020 at 20:41, wrote: >>>>>> Yeah, it's definitely a bug. I easily found the wrong code and I'll fix >>>>>> it for 3.903 and 3.11. >>>>>> The query actually accounts for only 543 of the 547 wrong times, so >>>>>> there's another error somewhere else. >>>>>> Regards, >>>>>> John Ralls >>>>>> >>>>>>> On Apr 30, 2020, at 10:27 AM, Finfort wrote: >>>>>>> Also I tried to unpost and post again. No changes. >>>>>>> >>>>>>>> On Apr 30, 2020 at 19:44, wrote: >>>>>>>> Hi John, >>>>>>>> The result is: >>>>>>>> 22:00:00 253 >>>>>>>> 00:00:00 18 >>>>>>>> 21:00:00 250 >>>>>>>> 23:00:00 22 >>>>>>>> So wrong dates are only when I use invoices. >>>>&g
Re: [GNC] Working with dates in Postgresql DB
Hmm, true. Should be always, since you're in a time zone east of the prime meridian. So you also want to increment the day on those. I think it would be safest to do it in two queries, the first one being update transactions post_date = post_date + interval '1 day' where post_date::TIME != '10:59:00'; and the second to update the time as before. Regards, John Ralls > On Apr 30, 2020, at 11:07 AM, Finfort wrote: > > If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real > date is 2018-01-01. At least in cases where I manually checked the invoices. > Setting all times to 10:59:00 will give wrong dates in the program. > Now they are displayed correctly in the program somehow... > > > >> On Apr 30, 2020 at 20:59, wrote: >> >> I don't think that's necessary. >> >> To fix the wrong times just do an update query, something like >> >> update transactions set post_date::TIME = 10:59:00 where post_date::TIME != >> 10:59:00; >> >> I don't know Postgresql's date-time functions well enough to know if that >> syntax works, you might have to adjust it a bit. You might create a table >> with a DATETIME column and put a couple of rows in it to test against while >> you tweak. Make sure that GnuCash isn't connected to the database when you >> run that. >> >> Regards, >> John Ralls >> >> >> > On Apr 30, 2020, at 10:45 AM, Finfort wrote: >> > >> > How can I help? >> > >> > I can send you my gnucash file if it helps to find all the bugs. >> > >> > And how can I change now my wrong dates in transactions? >> > >> >> On Apr 30, 2020 at 20:41, wrote: >> >> >> >> Yeah, it's definitely a bug. I easily found the wrong code and I'll fix >> >> it for 3.903 and 3.11. >> >> >> >> The query actually accounts for only 543 of the 547 wrong times, so >> >> there's another error somewhere else. >> >> >> >> Regards, >> >> John Ralls >> >> >> >> >> >> > On Apr 30, 2020, at 10:27 AM, Finfort wrote: >> >> > >> >> > Also I tried to unpost and post again. No changes. >> >> > >> >> > >> >> > >> >> >> On Apr 30, 2020 at 19:44, wrote: >> >> >> >> >> >> Hi John, >> >> >> >> >> >> The result is: >> >> >> >> >> >> 22:00:00 253 >> >> >> >> >> >> 00:00:00 18 >> >> >> >> >> >> 21:00:00 250 >> >> >> >> >> >> 23:00:00 22 >> >> >> >> >> >> So wrong dates are only when I use invoices. >> >> >> >> >> >> >> >> >> >> >> >> On 29/04/2020 23:56, John Ralls wrote: >> >> >> > Please remember to copy the list on all replies. >> >> >> > >> >> >> > I take it that that means that you do in fact use the business >> >> >> > invoice features. Let's see if that's the source of the problem. Run >> >> >> > this query: >> >> >> > >> >> >> > select t.post_date::TIME count(t.post_date::TIME) from transactions >> >> >> > as t inner join invoices as i on i.post_txn = t.guid group by >> >> >> > t.post_date::TIME; >> >> >> > >> >> >> > Regards, >> >> >> > John Ralls >> >> >> > >> >> >> > >> >> >> >> On Apr 29, 2020, at 1:41 PM, Finfort wrote: >> >> >> >> >> >> >> >> But the program use business features like entering invoices or >> >> >> >> bills. >> >> >> >> And we have this mess. >> >> >> >> How we can manage that? >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>> On Apr 29, 2020 at 23:23, wrote: >> >> >> >>> >> >> >> >>> Dimon, >> >> >> >>> >> >> >> >>> I'm in Silicon Valley, so 10 hours behind you. >> >> >> >>> >> >> >> &g
Re: [GNC] Working with dates in Postgresql DB
I don't think that's necessary. To fix the wrong times just do an update query, something like update transactions set post_date::TIME = 10:59:00 where post_date::TIME != 10:59:00; I don't know Postgresql's date-time functions well enough to know if that syntax works, you might have to adjust it a bit. You might create a table with a DATETIME column and put a couple of rows in it to test against while you tweak. Make sure that GnuCash isn't connected to the database when you run that. Regards, John Ralls > On Apr 30, 2020, at 10:45 AM, Finfort wrote: > > How can I help? > > I can send you my gnucash file if it helps to find all the bugs. > > And how can I change now my wrong dates in transactions? > >> On Apr 30, 2020 at 20:41, wrote: >> >> Yeah, it's definitely a bug. I easily found the wrong code and I'll fix it >> for 3.903 and 3.11. >> >> The query actually accounts for only 543 of the 547 wrong times, so there's >> another error somewhere else. >> >> Regards, >> John Ralls >> >> >> > On Apr 30, 2020, at 10:27 AM, Finfort wrote: >> > >> > Also I tried to unpost and post again. No changes. >> > >> > >> > >> >> On Apr 30, 2020 at 19:44, wrote: >> >> >> >> Hi John, >> >> >> >> The result is: >> >> >> >> 22:00:00 253 >> >> >> >> 00:00:00 18 >> >> >> >> 21:00:00 250 >> >> >> >> 23:00:00 22 >> >> >> >> So wrong dates are only when I use invoices. >> >> >> >> >> >> >> >> On 29/04/2020 23:56, John Ralls wrote: >> >> > Please remember to copy the list on all replies. >> >> > >> >> > I take it that that means that you do in fact use the business invoice >> >> > features. Let's see if that's the source of the problem. Run this query: >> >> > >> >> > select t.post_date::TIME count(t.post_date::TIME) from transactions as >> >> > t inner join invoices as i on i.post_txn = t.guid group by >> >> > t.post_date::TIME; >> >> > >> >> > Regards, >> >> > John Ralls >> >> > >> >> > >> >> >> On Apr 29, 2020, at 1:41 PM, Finfort wrote: >> >> >> >> >> >> But the program use business features like entering invoices or bills. >> >> >> And we have this mess. >> >> >> How we can manage that? >> >> >> >> >> >> >> >> >> >> >> >>> On Apr 29, 2020 at 23:23, wrote: >> >> >>> >> >> >>> Dimon, >> >> >>> >> >> >>> I'm in Silicon Valley, so 10 hours behind you. >> >> >>> >> >> >>> By "simple invoices" do you mean that some of the transactions are >> >> >>> created using business invoices? >> >> >>> >> >> >>> My book goes back to 1993 and entry_dates begin in 2001. We changed >> >> >>> the transaction time from local midnight in early 2011 so `select >> >> >>> distinct time(post_date) from transactions;` returns >> >> >>> 10:59:00 >> >> >>> 07:00:00 >> >> >>> >> >> >>> If I say instead `select distinct time(post_date) from transactions >> >> >>> where post_date > '2011-01-01';` I just get 10:59:00. >> >> >>> >> >> >>> But I don't use the business features, so if that's the problem my >> >> >>> book won't show it. >> >> >>> >> >> >>> Regards, >> >> >>> John Ralls >> >> >>> >> >> >>>> On Apr 29, 2020, at 10:13 AM, Finfort wrote: >> >> >>>> >> >> >>>> Hi John! >> >> >>>> You are here finally! >> >> >>>> Waiting for you all the day :) >> >> >>>> >> >> >>>> All my data I have entered inside Gnucash 3.7, Ubuntu. No imports! >> >> >>>> Scheduled are ok! >> >> >>>> Just simple invoices inside the program! >> >> >>>> The SQL type
Re: [GNC] Working with dates in Postgresql DB
Yeah, it's definitely a bug. I easily found the wrong code and I'll fix it for 3.903 and 3.11. The query actually accounts for only 543 of the 547 wrong times, so there's another error somewhere else. Regards, John Ralls > On Apr 30, 2020, at 10:27 AM, Finfort wrote: > > Also I tried to unpost and post again. No changes. > > > >> On Apr 30, 2020 at 19:44, wrote: >> >> Hi John, >> >> The result is: >> >> 22:00:00 253 >> >> 00:00:00 18 >> >> 21:00:00 250 >> >> 23:00:00 22 >> >> So wrong dates are only when I use invoices. >> >> >> >> On 29/04/2020 23:56, John Ralls wrote: >> > Please remember to copy the list on all replies. >> > >> > I take it that that means that you do in fact use the business invoice >> > features. Let's see if that's the source of the problem. Run this query: >> > >> > select t.post_date::TIME count(t.post_date::TIME) from transactions as t >> > inner join invoices as i on i.post_txn = t.guid group by t.post_date::TIME; >> > >> > Regards, >> > John Ralls >> > >> > >> >> On Apr 29, 2020, at 1:41 PM, Finfort wrote: >> >> >> >> But the program use business features like entering invoices or bills. >> >> And we have this mess. >> >> How we can manage that? >> >> >> >> >> >> >> >>> On Apr 29, 2020 at 23:23, wrote: >> >>> >> >>> Dimon, >> >>> >> >>> I'm in Silicon Valley, so 10 hours behind you. >> >>> >> >>> By "simple invoices" do you mean that some of the transactions are >> >>> created using business invoices? >> >>> >> >>> My book goes back to 1993 and entry_dates begin in 2001. We changed the >> >>> transaction time from local midnight in early 2011 so `select distinct >> >>> time(post_date) from transactions;` returns >> >>> 10:59:00 >> >>> 07:00:00 >> >>> >> >>> If I say instead `select distinct time(post_date) from transactions >> >>> where post_date > '2011-01-01';` I just get 10:59:00. >> >>> >> >>> But I don't use the business features, so if that's the problem my book >> >>> won't show it. >> >>> >> >>> Regards, >> >>> John Ralls >> >>> >> >>>> On Apr 29, 2020, at 10:13 AM, Finfort wrote: >> >>>> >> >>>> Hi John! >> >>>> You are here finally! >> >>>> Waiting for you all the day :) >> >>>> >> >>>> All my data I have entered inside Gnucash 3.7, Ubuntu. No imports! >> >>>> Scheduled are ok! >> >>>> Just simple invoices inside the program! >> >>>> The SQL type conversions inside Postgres give better results with 22:00 >> >>>> but 21:00 show the same date again even in April - summer time where is >> >>>> for example 2018-06-04 21:00:00+03. >> >>>> 22:00+02 is 00:00 of the next day, 21:00+03 (summer time) is 00:00 of >> >>>> the next day but conversion does not work... >> >>>> So, maybe you could try this SQL to check your records and revise the >> >>>> procedure which posts the data to DB? >> >>>> >> >>>> Thank you, >> >>>> Dimon. >> >>>> >> >>>> >> >>>> >> >>>> >> >>>> >> >>>>> On Apr 29, 2020 at 19:50, wrote: >> >>>>> >> >>>>>> On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: >> >>>>>> >> >>>>>> Dear John, >> >>>>>> >> >>>>>> Thank you for your response. >> >>>>>> >> >>>>>> >> >>>>>> I have collected some statistics from my DB. >> >>>>>> >> >>>>>> My DB has 1724 records - transactions. >> >>>>>> >> >>>>>> This is my SQL query, it is pretty simple and shows all the >> >>>>>> combinations of times in posted_date times
Re: [GNC] Adding Transactions From Another Program
We don't build the python bindings in the MacOS or Windows bundles because they must be linked to libpython, and it obviously has to be the same libpython to which the python executing the user's program is linked to. You can see where that's going: We'd have to include an entire python installation in the bundle. For MacOS, Homebrew's Gnucash recipe is a fake: It just downloads our dmg. You could use it to build as many of the dependencies as it supports and then build the rest plus GnuCash. It *does* pollute your environment like MacPorts and Fink do. The simplest way around that is to create a separate user for whichever Linux-clone you want to use. That user's environment will be altered but your primary account won't be. Another possibility, and the one we recommend for the python bindings, is to build GnuCash yourself. We have pretty well automated build systems at https://github.com/Gnucash/gnucash-on-osx and https://github.com/Gnucash/gnucash-on-windows. The budget code is not wrapped for Python or Guile. Regards, John Ralls > On Apr 30, 2020, at 7:18 AM, Stu Perlman wrote: > > David, are the Python bindings not supported in Windows? I don't see any > mention of Windows setup on this page: > https://wiki.gnucash.org/wiki/Python_Bindings#Setting_things_up I do have > Python 3.8 on my Win 10 system. > > My second question is with regard to budgets. If I don't see anything > regarding GC's budget module on these two pages: > https://code.gnucash.org/docs/MAINT/gnucash__core_8py.html > https://github.com/Gnucash/gnucash/tree/master/bindings/python/example_scripts > > Does that absence of info on Python and budgets mean that bindings are not > available for the budget module at this time? > > > > On Tue, Apr 28, 2020 at 6:07 PM Stu Perlman wrote: > >> David, I did look at the Python bindings info a while back but at the time >> did not feel like getting started with Python because I just wanted to get >> done what I wanted to get done. I'm mostly a .NET & SQL guy so I stuck >> with what I knew. Fast forward a few months and add in the bounty of extra >> time that the quarantine has afforded and I have since started dipping my >> toes into Python a bit. I'm actually kind of excited now to take a fresh >> look at the Python bindings capabilities for GC. I agree with you 100% >> that there may be no need for me nor for Hal to do our own things if there >> is an existing way! >> >> >> On Tue, Apr 28, 2020 at 5:59 PM David H wrote: >> >>> Have you checked out the GnuCash Python Bindings - >>> https://code.gnucash.org/docs/MAINT/python_bindings_page.html - no point >>> in re-inventing the wheel :-) >>> >>> Cheers David H. >>> >>> What can Python Bindings be used for ? >>> >>> The python bindings supply the ability to access a wide range of the core >>> functions of GnuCash. You can read and write Transactions, Commodities, >>> Lots, access the business stuff... You gain the ability to manipulate your >>> financial data with a flexible scripting language. >>> >>> Not everything GnuCash can is possible to access though. The bindings >>> focus on basic accounting functions. Have a look at the examples to get an >>> impression. >>> >>> Some functions are broken because they have not been wrapped properly. >>> They may crash the program or return unaccessible values. Please file a bug >>> report if you find one to help support the development process. >>> >>> On Wed, 29 Apr 2020 at 07:44, Stu Perlman wrote: >>> >>>> Hal, >>>> >>>> I'm sort of doing a liter version of what you are describing. I do >>>> manipulate some GC data from outside of GC. I have GC setup with the >>>> MySQL >>>> backend and while I don't create any new transactions from outside of GC >>>> I >>>> do manipulate them. I have some SQL routines that I created to clean up >>>> data points such as the Memo & Notes attributes that are part of each >>>> transaction. I have not run into any problems or data corruption after a >>>> few months of doing this. I did put a circuit breaker into my bolt-on >>>> app >>>> that at startup the 1st thing it does it check the GC lock record and if >>>> it >>>> detects that GC may still be running it will not allow my SQL routines to >>>> do anything. >>>> >>>> INSERTING new transaction records using SQL on the surface appears like &
Re: [GNC] Working with dates in Postgresql DB
Please remember to copy the list on all replies. I take it that that means that you do in fact use the business invoice features. Let's see if that's the source of the problem. Run this query: select t.post_date::TIME count(t.post_date::TIME) from transactions as t inner join invoices as i on i.post_txn = t.guid group by t.post_date::TIME; Regards, John Ralls > On Apr 29, 2020, at 1:41 PM, Finfort wrote: > > But the program use business features like entering invoices or bills. > And we have this mess. > How we can manage that? > > > >> On Apr 29, 2020 at 23:23, wrote: >> >> Dimon, >> >> I'm in Silicon Valley, so 10 hours behind you. >> >> By "simple invoices" do you mean that some of the transactions are created >> using business invoices? >> >> My book goes back to 1993 and entry_dates begin in 2001. We changed the >> transaction time from local midnight in early 2011 so `select distinct >> time(post_date) from transactions;` returns >> 10:59:00 >> 07:00:00 >> >> If I say instead `select distinct time(post_date) from transactions where >> post_date > '2011-01-01';` I just get 10:59:00. >> >> But I don't use the business features, so if that's the problem my book >> won't show it. >> >> Regards, >> John Ralls >> >> > On Apr 29, 2020, at 10:13 AM, Finfort wrote: >> > >> > Hi John! >> > You are here finally! >> > Waiting for you all the day :) >> > >> > All my data I have entered inside Gnucash 3.7, Ubuntu. No imports! >> > Scheduled are ok! >> > Just simple invoices inside the program! >> > The SQL type conversions inside Postgres give better results with 22:00 >> > but 21:00 show the same date again even in April - summer time where is >> > for example 2018-06-04 21:00:00+03. >> > 22:00+02 is 00:00 of the next day, 21:00+03 (summer time) is 00:00 of the >> > next day but conversion does not work... >> > So, maybe you could try this SQL to check your records and revise the >> > procedure which posts the data to DB? >> > >> > Thank you, >> > Dimon. >> > >> > >> > >> > >> > >> >> On Apr 29, 2020 at 19:50, wrote: >> >> >> >> > On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: >> >> > >> >> > Dear John, >> >> > >> >> > Thank you for your response. >> >> > >> >> > >> >> > I have collected some statistics from my DB. >> >> > >> >> > My DB has 1724 records - transactions. >> >> > >> >> > This is my SQL query, it is pretty simple and shows all the >> >> > combinations of times in posted_date timestamps in transactions table, >> >> > number of repetitions for that time value, min enter_date, max >> >> > enter_date: >> >> > >> >> > SELECT >> >> > t.post_date::TIME as "POST TIME", >> >> > COUNT(t.post_date::TIME) as "REPS", >> >> > min(t.enter_date) as "MIN ENTER DATE", >> >> > max(t.enter_date) as "MAX ENTER DATE" >> >> > FROM transactions t >> >> > GROUP BY t.post_date::TIME >> >> > ORDER BY t.post_date::TIME >> >> > >> >> > Here are the results: >> >> > >> >> > >> >> > >> >> > POST TIME REPS MIN ENTER DATE MAX ENTER DATE >> >> > >> >> > "00:00:00"18"2020-01-26 18:07:14""2020-01-28 19:11:07" >> >> > "10:59:00"1177"2019-12-23 17:55:29""2020-04-23 11:24:24" >> >> > "21:00:00"251 "2020-01-08 17:43:54""2020-04-23 10:36:33" >> >> > "22:00:00"256 "2020-01-08 17:06:59""2020-04-23 11:24:08" >> >> > "23:00:00"22"2020-01-27 19:16:04""2020-01-28 19:39:49" >> >> > >> >> > >> >> > >> >> > I live in Cyprus, here is UTC +2 and summer time UTC +3, as I know. >> >> > >> >> > I started to study Gnucash in December 2019 and have entered my data of >>
Re: [GNC] Working with dates in Postgresql DB
Dimon, I'm in Silicon Valley, so 10 hours behind you. By "simple invoices" do you mean that some of the transactions are created using business invoices? My book goes back to 1993 and entry_dates begin in 2001. We changed the transaction time from local midnight in early 2011 so `select distinct time(post_date) from transactions;` returns 10:59:00 07:00:00 If I say instead `select distinct time(post_date) from transactions where post_date > '2011-01-01';` I just get 10:59:00. But I don't use the business features, so if that's the problem my book won't show it. Regards, John Ralls > On Apr 29, 2020, at 10:13 AM, Finfort wrote: > > Hi John! > You are here finally! > Waiting for you all the day :) > > All my data I have entered inside Gnucash 3.7, Ubuntu. No imports! Scheduled > are ok! > Just simple invoices inside the program! > The SQL type conversions inside Postgres give better results with 22:00 but > 21:00 show the same date again even in April - summer time where is for > example 2018-06-04 21:00:00+03. > 22:00+02 is 00:00 of the next day, 21:00+03 (summer time) is 00:00 of the > next day but conversion does not work... > So, maybe you could try this SQL to check your records and revise the > procedure which posts the data to DB? > > Thank you, > Dimon. > > > > > >> On Apr 29, 2020 at 19:50, wrote: >> >> > On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: >> > >> > Dear John, >> > >> > Thank you for your response. >> > >> > >> > I have collected some statistics from my DB. >> > >> > My DB has 1724 records - transactions. >> > >> > This is my SQL query, it is pretty simple and shows all the combinations >> > of times in posted_date timestamps in transactions table, number of >> > repetitions for that time value, min enter_date, max enter_date: >> > >> > SELECT >> > t.post_date::TIME as "POST TIME", >> > COUNT(t.post_date::TIME) as "REPS", >> > min(t.enter_date) as "MIN ENTER DATE", >> > max(t.enter_date) as "MAX ENTER DATE" >> > FROM transactions t >> > GROUP BY t.post_date::TIME >> > ORDER BY t.post_date::TIME >> > >> > Here are the results: >> > >> > >> > >> > POST TIME REPS MIN ENTER DATE MAX ENTER DATE >> > >> > "00:00:00"18"2020-01-26 18:07:14""2020-01-28 19:11:07" >> > "10:59:00"1177"2019-12-23 17:55:29""2020-04-23 11:24:24" >> > "21:00:00"251 "2020-01-08 17:43:54""2020-04-23 10:36:33" >> > "22:00:00"256 "2020-01-08 17:06:59""2020-04-23 11:24:08" >> > "23:00:00"22"2020-01-27 19:16:04""2020-01-28 19:39:49" >> > >> > >> > >> > I live in Cyprus, here is UTC +2 and summer time UTC +3, as I know. >> > >> > I started to study Gnucash in December 2019 and have entered my data of >> > 2016-2020. >> > >> > I never changed my place and time zone in the period of working with >> > Gnucash. >> > >> > >> > 1. Most of the records have time in date_posted 10:59:00 for all the >> > period of data entering. >> > >> > 2. Only 2 days of entering have the results of 00:00:00 - 18 records. >> > >> > 3. Only 2 days of entering have the results of 23:00:00 - 22 records. >> > >> > 4. 21:00:00 and 22:00:00 - 500+ records - 30% of transactions for all the >> > period of data entering. >> > >> > >> > Can you please explain that? >> > >> > Why I have so many different time stamps? When and why the system decides >> > to write time different from 10:59:00? >> > >> > I understand that the system writes real ENTERING date and time and it is >> > reasonable to use the time zone somehow. >> > >> > When I POST the document with exact date in it I suppose to see this POST >> > DATE the same wherever in Cyprus or UK or USA. But entering the same date >> > I can have 5 different results. How it works and what is the reason - I >> > have no idea... >> > >> > Maybe you can give some examples and the algorithm to convert these dates? >> > Where else I have to conv
Re: [GNC] Automatic Price Retrieval
> On Apr 29, 2020, at 9:54 AM, John Ralls wrote: > > > >> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user >> wrote: >> >> I would like GnuCah to retrieve prices automatically each time I open it. >> >> The documentation describes the "Get Quotes" feature as "automatic", but I >> still have to remember to open the Price Editor and click "Get Quotes". >> >> Is there a way to make price retrieval fully automatic? > > Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE > argument, FILE being the path to your gnucash data file. I should have added that GnuCash should not be running with that file open when the job runs. 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] Automatic Price Retrieval
> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user > wrote: > > I would like GnuCah to retrieve prices automatically each time I open it. > > The documentation describes the "Get Quotes" feature as "automatic", but I > still have to remember to open the Price Editor and click "Get Quotes". > > Is there a way to make price retrieval fully automatic? Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE argument, FILE being the path to your gnucash data 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.
Re: [GNC] Working with dates in Postgresql DB
> On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: > > Dear John, > > Thank you for your response. > > > I have collected some statistics from my DB. > > My DB has 1724 records - transactions. > > This is my SQL query, it is pretty simple and shows all the combinations of > times in posted_date timestamps in transactions table, number of repetitions > for that time value, min enter_date, max enter_date: > > SELECT > t.post_date::TIME as "POST TIME", > COUNT(t.post_date::TIME) as "REPS", > min(t.enter_date) as "MIN ENTER DATE", > max(t.enter_date) as "MAX ENTER DATE" > FROM transactions t > GROUP BY t.post_date::TIME > ORDER BY t.post_date::TIME > > Here are the results: > > > > POST TIME REPS MIN ENTER DATE MAX ENTER DATE > > "00:00:00"18"2020-01-26 18:07:14""2020-01-28 19:11:07" > "10:59:00"1177"2019-12-23 17:55:29""2020-04-23 11:24:24" > "21:00:00"251 "2020-01-08 17:43:54""2020-04-23 10:36:33" > "22:00:00"256 "2020-01-08 17:06:59""2020-04-23 11:24:08" > "23:00:00"22"2020-01-27 19:16:04""2020-01-28 19:39:49" > > > > I live in Cyprus, here is UTC +2 and summer time UTC +3, as I know. > > I started to study Gnucash in December 2019 and have entered my data of > 2016-2020. > > I never changed my place and time zone in the period of working with Gnucash. > > > 1. Most of the records have time in date_posted 10:59:00 for all the period > of data entering. > > 2. Only 2 days of entering have the results of 00:00:00 - 18 records. > > 3. Only 2 days of entering have the results of 23:00:00 - 22 records. > > 4. 21:00:00 and 22:00:00 - 500+ records - 30% of transactions for all the > period of data entering. > > > Can you please explain that? > > Why I have so many different time stamps? When and why the system decides to > write time different from 10:59:00? > > I understand that the system writes real ENTERING date and time and it is > reasonable to use the time zone somehow. > > When I POST the document with exact date in it I suppose to see this POST > DATE the same wherever in Cyprus or UK or USA. But entering the same date I > can have 5 different results. How it works and what is the reason - I have no > idea... > > Maybe you can give some examples and the algorithm to convert these dates? > Where else I have to convert dates? As those are all posted dates you've found a bug or two as posted date should always have a 10:59:00 timestamp. The 21:00 and 22:00 times are clearly midnight local, and which one is used *should* be determined by whether DST is in effect for the posted date in your locale. It seems that 40 transactions somehow used UK time instead of Cypress time. Did you enter all of the transactions from the GnuCash UI or did you import some of them? If you imported some is there any way to tell which were imported (and from where and by what method), perhaps by the accounts their splits are in or because you still have some of the import files? Were any of them created by scheduled transactions? 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] Working with dates in Postgresql DB
> On Apr 28, 2020, at 3:43 PM, finf...@gmail.com wrote: > > Hi, > > I have found a strange thing trying to create my report with SQL queries from > Postgresql Gnucash database. > > The column post_date in transactions table stores values in timestamp format > (-MM-DD hh:mm:ss). > > If I compare the post date in the transaction inside Gnucash program and in > Postgresql database, I see this: > > Gnucash programPostgresql DB > > 31/12/20172017-12-31 00:00:00 > > 31/12/20172017-12-31 10:59:00 > > 01/01/20182017-12-31 22:00:00 > > --- > > 02/01/20182018-01-01 22:00:00 > > 02/01/20182018-01-02 10:59:00 > > -- > > 31/12/20182018-12-30 22:00:00 > > 31/12/20182018-12-31 10:59:00 > > So, the same dates in DB can be different dates in Gnucash program and vise > versa. > > There are only 00:00:00, 10:59:00, 21:00:00, 22:00:00 values of time. > > Please explain how this mystics work and what is the reason to save dates > like this... > > I cannot make my reports without correct converting of dates. All date-times in GnuCash are stored in UTC but displayed in local time. Transaction posted_dates and a few others are stored at 10:59:00 UTC to produce the same date across most timezones (there are 27 hours of timezones so it's not possible for all of them. If you live along the international date line then the time is adjusted so that it matches the date in your time zone, but it will still change date on you if you go to a timezone more than 23 hours away). Some other date-times are forced to midnight local. I suppose from what you've posted that you're in a +2 with 1 hour DST so that the recorded time for those midnight dates in 2200 UTC in winter and 2100 in summer. I didn't think that it forced anything to midnight UTC though. Might you have entered data while visiting somewhere with a UTC (aka GMT) timezone? 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] GnuCash 3.902 released
The GnuCash development team announces GnuCash 3.902, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features • The matcher window columns are changed from R to C and from U+R to U+C, reflecting that the matcher marks transactions cleared but doesn't reconcile them. (Bug 797338) • OFX imports having balance information will now offer to immediately reconcile, passing the balance information in the file to the reconcile info. • Improve quickfill in the account pickers to filter the choices based on any part of the name. • The GnuCash widget hierarchy for CSS has been revised to be more consistent with Gtk practice. You may need to spend some time with the GtkInspector to get your custom CSS back the way you like it. • When creating a new account hierarchy it's now possible to load account templates from locales other than the one set for the user interface. (Bug 797472) • New Account - Online Account match list to the Import Map Editor. • New invalid maps dialog in the Import Map Editor. (Bug 797612) • Optionally include the account code option in budget view. • Account matcher will decline to match accounts with a different commodity from the imported split if the import information includes the commodity. • Ellipsize the Description and Memo fields in the account matcher. • Enable adding notes to budgets. (Bug 693180) • Support for AQBanking Version 6. This is required to support new FinTS protocols and the European Privacy Directive. • GnuCash 4.x will not migrate old gconf settings from GnuCash 2.4.x. • Reversing transactions will now pop a dialog box to request a posting date. (Bug 782455) • The Accounts page has a new optional column for the hidden property to make it easier to toggle it. Note that in order to see hidden accounts you must still enable that in the Filter by... dialog. (Bug 797486) • The Customer, Vender, and Employee overviews have a process-payment toolbar. (Bug 797605). • Account codes may now optionally be displayed in the Budget Tree View. (Bug 797489). New/Revised Reports • Owner Report Significant Code Changes • The source directories have been rearranged and most of the loadable modules (e.g. libgncmod-engine.so) are now normal dynamic libraries (libgnc-engine.so), shorn of their gnc-module adapters. Make sure that you clean and rebuild your build directory. • All functions marked as deprecated in 3.x are now removed. If you have custom reports be sure to examine gnucash.trace for deprecation warnings and update your reports before trying them in GnuCash 3.91. • libgncmod-generic-import is now libgnc-generic-import. • Scheme no longer uses libgncmodule, always do (use-modules (gnucash foo)) • Autocompletion improvements for the transfer-account field. • New test for invalid mappings for online accounts and a dialog to fix them. • jqplot is replaced by chartjs. • Separate most Guile binding code from the code that it wraps. It's now located in bindings/guile. • Improve Google test integration in cmake. CMake now requires only GTEST_ROOT and only when cmake isn't able to find Google test without help.Unit tests for Scheme code with SRFI64. Deprecations (will be removed in GnuCash 5.0 • gnc:substring-replace-from-to Between 3.10 and 3.902, the following bugfixes were accomplished. Some of these will also be fixed in GnuCash 3.11, some are for 4.0 only. • Bug 693180 - Add notes to budgeting values • Bug 773198 - Move several reports to Example directory/menu • Bug 773199 - Rename and rebuild Welcome to GnuCash Report • Bug 773200 - Rename Sample & Custom Report Group • Bug 782455 - Modify Add Reversing Transaction feature • Bug 797114 - Fixing an SX due to deleted account stuck in an error loop • Bug 797270 - Budget Chart report - translation of header and dates • Bug 797338 - Change "U+R" and "R" labels to "U+C" and "C" in Import matcher • Bug 797351 - General ledger register transaction becomes "zombie" after deletion • Bug 797415 - cannot build without libsecret-1-dev • Bug 797472 - Add option to choose account te
Re: [GNC] Net Worth Linechart report error
> On Apr 27, 2020, at 11:40 AM, Nelson wrote: > > Environment: Version: 3.10 > Build ID: 3.10+(2020-04-11) > Finance::Quote: 1.49 > Windows 10 > > How do I troubleshoot this? TIA. Start with the trace file (https://wiki.gnucash.org/wiki/Tracefile). There should be error messages and maybe a scheme stack trace with more details about the error. 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] Rule based bank account transaction allocation
> On Apr 26, 2020, at 7:39 PM, partha wrote: > > Hi, > > I have imported last financial year txn of my bank account. > > Is there a facility to write rules on the basis of the strings that are in > the description to automate posting of the transaction from suspense account > to the releveant account. > > It looks like it is possibel when you are importing transaction. But > practically it might not be possible to create rules for the all bank > transaction before starting the import. > It's not a built in capability. The built in version uses trainable matching: Import a month or two, assign the new transactions in the match window, repeat. After the first time the matcher will start to suggest matches. After 3 or 4 imports it is usually matching most imported transactions pretty accurately--though you should in general check the matches every time to make sure that it hasn't gone astray. 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] Trying to set up online banking
Jean, Not exactly. There's two "wizards" at play here, the outer Online Banking Setup Assistant and the inner AQBanking setup dialog. That inner one has two tabs, Users and Accounts. The User one, when setting up an OFX DirectConnect user (and maybe for the HBCI/FinTS one, I don't know) includes the ability to download accounts once one has successfully set up the OFX DirectConnect parameters, but not all banks support it; it might also fail for other reasons. When it does work it populates the accounts for that bank and you can quit the AQBanking setup dialog and click next in the Online Banking Setup Assistant. If it doesn't work then no accounts are set up and you have to do so manually, and that's what the Accounts tab in the AQBanking setup dialog is for. Regards, John Ralls > On Apr 26, 2020, at 10:55 AM, jean laroche wrote: > > John, are you saying there's a way to setup the aqbanking without using the > wizard? I completely missed that :( > > > On 4/26/2020 10:44 AM, John Ralls wrote: >> Probably because nobody had the same experience. If the automagic account >> download didn't work then you have to set up the accounts manually in the >> AQBanking setup window using the Accounts tab. >> >> Regards, >> John Ralls >> >> >>> On Apr 26, 2020, at 10:38 AM, jean laroche wrote: >>> >>> Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use >>> ofxclient.py since I can't get aqbanking to work and I customized it for my >>> needs). >>> It's definitely not an issue with the setup, it's a programming issue! >>> Everything starts well with the GC online banking setup wizard, I retrieve >>> the account list, successfully (according to the UI) then when I want to >>> continue with the >>> wizard, the "next" button is grayed out, and I'm stuck there. >>> This is with windows 8, and the latest GC (actually all recent versions of >>> GC). >>> >>> Where do I open a bug on this? I started a thread on the Dev list, asking >>> if anybody else on windows had the same experience and got nowhere with it. >>> Jean >>> >>> >>> On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote: >>>> Hi Jean >>>> >>>> Am 26.04.20 um 03:19 schrieb jean laroche: >>>>> Are you on windows? >>>> Gnucash & Aqbanking version? >>>> >>>>> I have to say, I have not been able to setup the >>>>> online banking thing in GC in windows. >>>> Which Bank? >>>> Did you follow John's instructions? >>>> >>>> Frank >>> ___ >>> 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] Trying to set up online banking
Probably because nobody had the same experience. If the automagic account download didn't work then you have to set up the accounts manually in the AQBanking setup window using the Accounts tab. Regards, John Ralls > On Apr 26, 2020, at 10:38 AM, jean laroche wrote: > > Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use > ofxclient.py since I can't get aqbanking to work and I customized it for my > needs). > It's definitely not an issue with the setup, it's a programming issue! > Everything starts well with the GC online banking setup wizard, I retrieve > the account list, successfully (according to the UI) then when I want to > continue with the > wizard, the "next" button is grayed out, and I'm stuck there. > This is with windows 8, and the latest GC (actually all recent versions of > GC). > > Where do I open a bug on this? I started a thread on the Dev list, asking if > anybody else on windows had the same experience and got nowhere with it. > Jean > > > On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote: >> Hi Jean >> >> Am 26.04.20 um 03:19 schrieb jean laroche: >>> Are you on windows? >> Gnucash & Aqbanking version? >> >>> I have to say, I have not been able to setup the >>> online banking thing in GC in windows. >> Which Bank? >> Did you follow John's instructions? >> >> Frank > > ___ > 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 install Gnucash 3.8 on Debian 10 "buster"?
GnuCash doesn't care what python it's linked against as long as it's >= 3.2.0. The Debian packager linked GnuCash 3.10 against python 3.8 and set it as a requirement in the .deb because that's what's on a fully up to date Debian testing. If you're fearful of updates breaking your system you should use only Debian stable. The whole point of testing is to try out version upgrades to see what breaks. Regards, John Ralls > On Apr 26, 2020, at 7:33 AM, km22 wrote: > > As a follow up I have been running Gnucash 3.8 from the Debian testing > repo for a few months now. I recently tried to update but get these > results: > > [Quote1] > > $ sudo apt list --upgradable > > ... > > gnucash-common/testing 1:3.10-1 all [upgradable from: 1:3.8b-1] > gnucash/testing 1:3.10-1 amd64 [upgradable from: 1:3.8b-1+b1] > ... > > [/Quote1] > > > [Quote2] > > $ sudo apt install gnucash > Reading package lists... Done > Building dependency tree > Reading state information... Done > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > gnucash : Depends: libpython3.8 (>= 3.8.2) but it is not going to be > installed > E: Unable to correct problems, you have held broken packages. > > [/Quote2] > > > Question: Is it normal for gnucash to change its Python version (here to > version 3.8) within a maintenance update (here to gnucash version 3.10)? > > I ask because I am hesitant to update my python version for fear of > breaking my system - but just wanted to highlight whether this increase > in Python version is expected within the Gnucash version guidelines? > > Thanks, > Ken > > > On 12/3/2020 10:48 pm, km22 wrote: >> >> As a follow up, what I did is the following to update to 3.8 on my >> Debian 10 system: >> >> 1) Created a file /etc/apt/apt.conf with the line: >> APT::Default-Release "buster"; >> >> 2) Ran sudo apt update. Then ran apt -t testing install gnucash >> >> From the /var/log/apt/history.log file these were the packages that >> were installed/updated: >> >> Start-Date: 2020-03-10 00:14:47 >> Commandline: apt -t testing install gnucash >> Requested-By: ken (1000) >> Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64 >> (10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2, >> automatic), libgcc-s1:amd64 (10-20200222-1, automatic), >> libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64 >> (3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic), >> libgwengui-gtk3-0:amd64 (5.1.3-1, automatic) >> Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), >> libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64 >> (2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2, >> 0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1), >> libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17), >> libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64 >> (3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1), >> gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3, >> 4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64 >> (2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2) >> End-Date: 2020-03-10 00:15:13 >> >> Question I have is why was it necessary for gnucash to install >> packages from the testing repo for packages such as cryptsetup >> (various) or gcc-10-base? Are these really necessary for gnucash? I >> want to maintain a system as close to the base Debian 10 as possible >> so curious to understand why these other packages were required? >> >> Thanks, >> >> Ken >> >> >> >> On 8/3/2020 11:09 pm, km22 wrote: >>> Hi all, >>> >>> Can anyone advise a very simple and safe way of install gnucash 3.8 >>> in Debian 10? >>> >>> I've read posts like this: >>> https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable >>> >>> But I am very reluctant to start messing with things like pinning or >>> temporarily enabling testing repo entirely for fear of breaking my >>> system. >>> >>> Is there a si
Re: [GNC] Trying to set up online banking
> On Apr 25, 2020, at 6:11 PM, Janet Shelby wrote: > > Hello, I am a new user migrating from many years of Quicken. I would like > to use Gnucash if it will download banking transactions, especially credit > card transactions. The tool provided does not get successful results with > no instruction on what to do upon failure. I am an accountant but not an IT > specialist! Can I get assistance here? Thanks. Check your bank's online banking setup page and make sure that it supports OFX DirectConnect. The alternative is OFX WebConnect which uses an Intuit-proprietary authentication mechanism that GnuCash's online banking library is unable to use. If it says that it does, go to https://www.ofxhome.com and search for the bank. If it's there just go to the page for it and check that it has validated recently. If it has then you should be able to use the bank selection in the AQBanking setup. If not then you'll have to try to set it up by hand using whatever information you can glean from the bank's website, which may not be much: It may just say that you need a certain version of Quicken and to go to the online banking tab in that program and select the bank. 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] A Milk Run
> On Apr 25, 2020, at 1:00 AM, flywire wrote: > > Do you realise you are commenting on a personal email sent to David Cousens > who cc'd the mailing list into the reply? I may not have made the point > about rapid changes in communication technology in the last few years > that way on a public forum. Except that you did, on https://github.com/Gnucash/gnucash-docs/pull/128. That comment is now deleted, but it wasn't exactly courteous, nor was it enlightening. Perhaps you realized that and deleted it yourself, but don't try to pretend that you didn't do it. 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] bug or bad feature: entries future-dated
> On Apr 20, 2020, at 7:06 AM, Eric Beversluis > wrote: > > Using GnuCash 3.7 on Mac 10.12.6 > > When I enter a future-dated transaction (eg, On April 15, I enter a VISA card > payment for May1, and type "5/1” into the date cell, GnuCash makes that > 5/1/19 rather than 5/1/20. This creates obvious confusion in the records. I > haven’t had this behavior problem in the past. Is that a bug? > Check the date completion window in Preferences > Date & Time. 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] Balance sheet unusable for LANG="de..."; was: Bad account setup in Guide §12
> On Apr 17, 2020, at 7:26 AM, Frank H. Ellenberger > wrote: > > David > > Am 17.04.20 um 13:00 schrieb David Cousens: >> Frank >> >> In that case you should be concerned as the trading account balances are >> currently reported under equity in the Balance sheet. >> >> The attached is a Balance sheet run on a dummy book I created >> Trading_Test_BalSheet.png >> <http://gnucash.1415818.n4.nabble.com/file/t375329/Trading_Test_BalSheet.png> >> > > Oh, that makes the balance sheet useless for german and probably other > users. Unrealized gains/losses do not belong in the balance. The user > has to manually enter value adjustments in the closing book process > according local law to reflect them, if applicable. > > That was also the reason, why the trading accounts were not implemented > over a decade. If you don't want unrealized gains change the price source to Average Cost. 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] Editing SCM quesion
> On Apr 15, 2020, at 10:57 AM, bob_summers wrote: > > Hi > > Ubuntu, gnucash 3.7 > > I need to generate invoices (I use the easy invoice template) in an > unsupported language (Basque/Euskera) so I can't just open Gnucash using the > locale options. > > Previously I've been doing this by hand editing the easy-invoice.scm file, > easy enough to find and replace words like Total, Tax, etc (although it's in > /Usr/Share it gets overwritten with each update, but I just keep a backup). > > With v3.7, the easy-invoice.scm does not work in the same way and I cannot > find where these variables are kept. You can see below the part I used to > change, and I can't find these expressions anywhere now. > > Wondering if in >3.7 it is even possible to change these expressions. > > >> (let* ((col-vector (make-vector columns-used-size #f)) >> (set-col (make-set-col col-vector))) >>(set-col (opt-val "Display Columns" "Date") 0) >>(set-col (opt-val "Display Columns" "Description") 1) >>(set-col (opt-val "Display Columns" "Charge Type") 2) >>(set-col (opt-val "Display Columns" "Quantity") 3) >>(set-col (opt-val "Display Columns" "Price") 4) >>(set-col (opt-val "Display Columns" "Discount") 5) >>(set-col (opt-val "Display Columns" "Taxable") 6) >>(set-col (opt-val "Display Columns" "Tax Amount") 7) >>(set-col (opt-val "Display Columns" "Total") 8) >>col-vector)) >> >> (define (make-heading-list column-vector) >> >> (let ((heading-list '())) >>(if (date-col column-vector) >>(addto! heading-list (_ "Data/Fecha"))) >>(if (description-col column-vector) >>(addto! heading-list (_ "Azalpena/Descripción"))) >>(if (action-col column-vector) >> (addto! heading-list (_ "Charge Type"))) >>(if (quantity-col column-vector) >> (addto! heading-list (_ "Kop./Cant."))) >>(if (price-col column-vector) >> (addto! heading-list (_ "Prezioa/Precio"))) >>(if (discount-col column-vector) >> (addto! heading-list (_ "Dtua./Dto."))) >>(if (tax-col column-vector) >> (addto! heading-list (_ "Taxable"))) >>(if (taxvalue-col column-vector) >> (addto! heading-list (_ "Tax Amount"))) >>(if (value-col column-vector) >> (addto! heading-list (_ "Zenbat./Importe"))) >>(reverse heading-list))) > We do have a Basque translation, it just hasn't been updated in 15 years: > msgfmt --statistics po/eu.po > 1527 translated messages, 2545 fuzzy translations, 1351 untranslated messages. > It's vastly easier and more robust to fix any missing or fuzzy translations, recompile it, and install it into share/locale/eu/LC_MESSAGES than to mess with the report or stylesheet code. Detailed instructions at https://wiki.gnucash.org/wiki/Translation. We'd love it if you'd share your updated translation with us. 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] Would like to use, but ....
> On Apr 15, 2020, at 7:27 AM, Geert Janssens > wrote: > > Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone: >> On 15 April 2020 at 9:02, Derek Atkins said: >>> Hi Andrew, >>> >>> First, please remember to CC gnucash-user on your replies so that others >>> may benefit from the conversation and chime in. You can do this by using >>> the Reply-To-List or Reply-All functionality in your mailer. >>> >>> If you could supply us with the URL of the page that points to WinXP, >>> there is a chance that we might be able to fix it. BUt of course it >>> depends if it is on a page that we can control or not. No way for us to >>> tell without knowing the specific page ;) >> >> The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the >> main gnucash.org page links to >> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup >> .exe > > Right, this turns out to be a typo in the link. I have fixed it now; If you > reload the gnucash home > page it should now properly download the correct package. That solves the problem of the link on our page but there's still a SourceForge problem: When you visit any of the GnuCash pages on SF there's a big green download button. What download it points to is determined by the user agent string from your browser, and if that says you're running Windows it points to the latest gnucash-xxx-setup.exe. There's no reliable way for it to know what version of Windows you have. The same is true of MacOS: Someone connecting with a PPC Mac running 10.5 will get pointed to the latest Mac bundle, which won't work. 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] Online price updating
> On Apr 13, 2020, at 11:37 AM, Mohamed Omar wrote: > > Dear All, > I am testing GnuCash personal finance program ability to update our UAE > Finantial Stock Market (Abu Dhabi – ADX & Dubai DFM) . > I followed the steps of using Finance::Qoute by downloading the file and > ActivePerl software. I become upset due to unfortunately my lack of > understand some process. > Can you advise me if I could obtain of market stock prices after complete the > installing the the patch file on my PC. AFAICT there is no module in Finance::Quote for retrieving data from either of those exchanges, but the stock quotes might be available through Yahoo. You can test that by trying to get quotes from the Yahoo finance web site. If you can figure out the right symbols to look up then you can set up your securities in GnuCash with those symbols and set the price quote source to yahoo-json. 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] Which file contains the account name map for the CSV import tool?
> On Apr 12, 2020, at 9:31 AM, Patrick wrote: > > I'd like to work on a gnucash file on a new machine. I'd like to transfer > the account name map that is used by the CSV import tool (see the bullet > "Match Import and GnuCash accounts") from the old machine to the new > machine. Is this mapping stored in a file that I can transfer to the new > machine? > > I have looked in the "Configuration Locations" section of the wiki, but it > wasn't clear to me if this contained the answer I was looking for. Those mappings are stored in your book (i.e. .gnucash) file. https://wiki.gnucash.org/wiki/Backup lists all of the files that you'll need to copy to the new machine. 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] cMakeError.log errors - building Gnucash 3.10
> On Apr 12, 2020, at 4:25 AM, finf...@gmail.com wrote:
>
> I have these errors in cMakeError.log after cmake:
>
> Can anybody explain how to fix that?
>
>
>
> Performing C++ SOURCE FILE Test HAVE_OFX_BUG_39 failed with the following
> output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_5918e"
> [1/2] Building CXX object CMakeFiles/cmTC_5918e.dir/src.cxx.o
> [2/2] Linking CXX executable cmTC_5918e
> FAILED: cmTC_5918e
> : && /usr/bin/c++ -DHAVE_OFX_BUG_39 CMakeFiles/cmTC_5918e.dir/src.cxx.o -o
> cmTC_5918e -lofx && :
> /usr/bin/ld: CMakeFiles/cmTC_5918e.dir/src.cxx.o: in function `main':
> src.cxx:(.text+0xb5): undefined reference to
> `ofxdate_to_time_t(std::__cxx11::basic_string,
> std::allocator >)'
> collect2: error: ld returned 1 exit status
> ninja: build stopped: subcommand failed.
>
> Return value: 1
> Source file was:
>
> #include
> #include
> #include
> extern time_t ofxdate_to_time_t(const std::string ofxdate);
>
> int main(int argc, char** argv)
> {
> const std::string timestr = "2016031900";
> struct tm ts;
> ts.tm_year = 116;
> ts.tm_mon = 2;
> ts.tm_mday = 19;
> #ifdef _WIN32
> putenv("TZ=PST-8PDT-7,M 4.1.0/0,M 10.6.0/0");
> #else
> setenv("TZ", "PST 08P DT 07 M 4.1.0, M 10.6.0", 1);
> #endif
> time_t t = ofxdate_to_time_t(timestr);
> if (t == mktime(&ts))
> exit(1);
> exit(0);
> }
>
> Determining if the pthread_create exist failed with the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_2d065"
> [1/2] Building C object CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o
> [2/2] Linking C executable cmTC_2d065
> FAILED: cmTC_2d065
> : && /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o -o cmTC_2d065 &&
> :
> /usr/bin/ld: CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o: in function
> `main':
> CheckSymbolExists.c:(.text+0x1f): undefined reference to `pthread_create'
> collect2: error: ld returned 1 exit status
> ninja: build stopped: subcommand failed.
>
> File
> /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp/CheckSymbolExists.c:
> /* */
> #include
>
> int main(int argc, char** argv)
> {
> (void)argv;
> #ifndef pthread_create
> return ((int*)(&pthread_create))[argc];
> #else
> (void)argc;
> return 0;
> #endif
> }
>
> Determining if compiler accepts -pthread failed with the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_12d58"
> [1/2] Building C object CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o
> FAILED: CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o
> /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused -o CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o -c
> /usr/share/cmake-3.13/Modules/CheckForPthreads.c
> /usr/share/cmake-3.13/Modules/CheckForPthreads.c:3:7: error: no previous
> prototype for ‘start_routine’ [-Werror=missing-prototypes]
> 3 | void* start_routine(void* args)
> | ^
> cc1: all warnings being treated as errors
> ninja: build stopped: subcommand failed.
>
>
> Determining if the function pthread_create exists in the pthreads failed with
> the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_59318"
> [1/2] Building C object CMakeFiles/cmTC_59318.dir/CheckFunctionExists.c.o
> [2/2] Linking C executable cmTC_59318
> FAILED: cmTC_59318
> : && /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused -DCHECK_FUNCTION_EXISTS=pthread_create
> CMakeFiles/cmTC_59318.dir/CheckFunctionExists.c.o -o cmTC_59318 -lpthreads
> && :
> /usr/bin/ld: cannot find -lpthreads
> collect2: error: ld returned 1 exit status
> ninja: build stop
Re: [GNC] Gnucash and Windows 10 Aero snap feature
There's no config for that. AeroSnap isn't fully supported by Gtk. For a somewhat technical discussion of why and whether it will change in Gtk4, see https://gitlab.gnome.org/GNOME/gtk/issues/105. Regards, John Ralls > On Apr 11, 2020, at 2:41 PM, wrote: > > Hi All, > > > > Is there a property in a gnucash config that I can edit to allow aero snap > control handed to windows 10? It seems gnucash 3.x series doesn't get along > with this feature. > > > > I have an ultrawide monitor. In default mode, if I snap gnucash to left or > right side, it snaps perfectly fine and allows me to select tiles to snap to > the opposing side. However, if I snap another window first, then gnucash > will disappear. There is no gnucash tile to select. I have to bring gnucash > back to the visible screen by clicking its icon the toolbar and then > manually moving and sizing gnucash into place. > > > > The problem is more pronounced when I chop my display into 3 or 4 splits. In > this mode, gnucash will not snap to either side or middle splits. If I snap > other apps first, gnucash will again just disappear. If I change the order > of my splits, gnucash will not follow. It just floats in its spot or it ends > up disappearing behind other apps. > > > > Cheers, > > Ameet > > > > > > > > ___ > 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] GnuCash 3.10 Released
The GnuCash development team announces GnuCash 3.10, the eleventh release of the 3.x stable release series. Changes This is a snap release to reverse the changes to the reconcile window's filtering reconciled transactions with a reconcile date after the current statement date when computing the starting balance. It seems that many users' books have accounts with reconcile dates in the future that were suddenly filtered out, creating an incorrect starting balance and making it impossible to reconcile the book. Between 3.9 and 3.10, the following bugfixes were accomplished: Bug 620848 - Transfer Funds window - add Notes field Bug 797006 - Balance is misleading in open subaccounts when different currencies are involved Bug 797318 - Amounts ending in zero displayed as fractions Bug 797666 - libgnucash/engine/test/test-recurrence.c: In function 'check_valid': 'result' may be used uninitialized Bug 797676 - Register displays amount in transaction currency instead of register currency. Bug 797674 - 3.9: "test-gnc-path-util" failed on Debian amd64 The following fixes and improvements were not associated with bug reports: Update latest translation from the Translation project. [window-reconcile] when reconciling, warn on splits having a reconcile date > statement_date [window-reconcile] when inputing statement_date, warn if it's after today [find-transactions] add search for reconciled date Show transaction value, not amount, for registers with subaccounts. If the register has subaccounts in different currencies and a transaction has splits in more than one, the transaction will incorrectly appear to be unbalanced if we total amounts because the balancing logic works on split values. Add instance argument to Session constructor Enables a python console to connect to the running GnuCash's session. Make python console less noisy without --debug. Provide locals and globals of calling context to the python console's shell on shell init Merge Jean Laroche's '797006_subaccounts' into maint. Add check to display warning dialog for mismatched commodities Replicate changes in *2 files Apply astyle to modified files Merge Chris Mayo's iPython-fixes into maint. Make pycons/ishell.py compatible with Python 3 and current IPython [eguile-utilities] Prevent crash in balsheet-eg.scm [eguile] escape-html -> gnc:html-string-sanitize [qif-to-gnc] Properly mark intra-QIF internal transfers. We have a revised Ukrainian translation. Known Issues The following are open bug reports to the 3.x series considered significant by the development team: Bug 795383 - Gnucash crashes on import of a 1400-transaction (or more) CSV file Bug 796955 - Import CSV - Single-line two-currency transactions can't be imported Bug 796992 - gnucash --add-price-quotes can't parse drive letters on Windows. Bug 796997 - Currency Conversion Dialog appears when recording transactions between same currency accounts. Bug 797037 - Counter formats not saving Bug 797064 - crash when try print report Bug 797083 - Gnucash crashes when trying to rename budget Bug 797092 - Save As fails: tries to save to reserved directory if path contains spaces Bug 797113 - Scrubbing crashes when creating small splits that round to value 0. Bug 797114 - Fixing an SX due to deleted account stuck in an error loop Bug 797115 - Can't 're-activate' an expired SX Bug 797211 - Very slow UI - dependent on window size Bug 797220 - delete account allows move of all transactions to account having non-matching currency Bug 797236 - Regression: Reconcile window transaction list resets to top when new transaction created in account Bug 797264 - 3.5 can't use Chinese IME input Bug 797283 - Permanent hang on clicking on report tabs Bug 797285 - QIF import fails and then crashes Bug 797293 - Crash when import "U+R" or "R" Bug 797294 - Billing functions freezing Bug 797325 - [Windows 7] Reports with charts will not load Bug 797329 - Using Japanese IME to enter transactions results in unexpected field jumps Bug 797334 - Crash on attempting to change account separator character Bug 797335 - Crash on subsequent Open after accidentally Opening the current file Bug 797336 - CSV Accounts import fails on UTF-8 e-acute in account name Bug 797345 - Selecting item in tax table causes gnucash to crash Bug 797348 - Wrong column order for RTL writing in GUI elements Bug 797351 - General ledger register transaction becomes "zombie" after deletion Bug 797363 - Consistent Silent Crash on Converting Saved Reports from 2.6 to 3.6 Bug 797368 - Cannot download Quantity information from a CSV to a mutual Bug 797384 - Gnucash doesn't handle commodity prices with big numerator/denominator properly Bug 797385 - Report html files NOT opening in Reports tab or window due to
Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash
Yes, you can use Homebrew, but they just wrap the Gnucash.app that I build and distribute via https://www.gnucash.org so I don't see why you'd want to. Regards, John Ralls > On Apr 9, 2020, at 12:14 PM, jess wrote: > >> Is there an "Update" software function in the program somewhere, as I > have not been able to see any obvious place to do this? > > macOS has homebrew which can be used to update. > >> I see there is GnuCash 3.9 version offered on the website, but will I >> lose all existing > data in my existing GnuCash 3.4+ > > No, your data is held in a .gnucash (or equivalent). You can open that same > file in GNUCash. > > > > -- > 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] Help!
> On Apr 9, 2020, at 5:24 AM, Adrien Monteleone > wrote: > > If I’m not mistaken, 2.6.21 is 64bit. Nope. It's 32-bit. Not a problem of Evelyn, who's only going to 10.13. 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] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash
> On Apr 8, 2020, at 11:55 AM, Patrick Farrell wrote:
>
> Is there a "Canadian Version" of GnuCash as all the documentation in the
> current version of GnuCash 3.4+ (Build 2018-12-30) that I have read relates
> to the USA Tax System?
>
> I immediately need to know how to set up automatically calculating how to add
> Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I make up and
> send out to Clients/Customers, and then how to separately account for HST
> that I pay on any invoices that I receive from our vendors and subsequently
> pay. I then need to offset the HST received from Client/Customers versus the
> HST I have paid out to Vendors and do an official Government HST filing at
> least Quarterly, and pay them the difference if any!
>
> Is there an "Update" software function in the program somewhere, as I have
> not been able to see any obvious place to do this? I see there is GnuCash 3.9
> version offered on the website, but will I lose all existing data in my
> existing GnuCash 3.4+ if I download 3.9 on top of it or have to delete 3.4+
> before I install version 3.9?
There are no national versions, and in any case even US residents would be
foolish indeed to rely on GnuCash's documentation for tax information. The
Tutorial and Concept Guide presents a very basic overview of accounting to help
new users understand how GnuCash is different from programs like KMyMoney or
Quicken. Beyond that any examples are intended to illustrate how to do tasks in
GnuCash.
No, GnuCash has no "check for updates" function. MacOS and Microsoft Windows
users can install new all-in-one packages. Linux users can either install the
flatpak or rely on their distro's package manager though most of those tend to
lag behind releases. Installing an upgrade in the same major release shouldn't
affect your data.
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] Price of gold
> On Apr 8, 2020, at 7:31 AM, Eric Coates via gnucash-user > wrote: > > Good Afternoon > > On 08/04/2020 10:08, Frank H. Ellenberger wrote: > >> The quotes are not from ISO-4217:XAU (troy ounce Gold), but from >> NASDAQ:XAU an share index of gold and silver producers. > > So, is there a relationship between this NASDAQ:XAU figure and (what might be > termed) the real price of gold (ie the mid-value retail price of a gram of > gold, using grams to avoid the confusion between troy ounces and the other > ounce)? > > Just out of interest really > It's https://en.wikipedia.org/wiki/Philadelphia_Gold_and_Silver_Index. It has a relationship to the spot price of gold but probably not close enough to be of much use. To get the current USD spot price of Gold in the Zurich Forex markets look for the XAU:USD exchange rate; that's what GnuCash will do if you have an account denominated in the XAU currency and your book currency is USD. The gold amount is Troy ounces, about 40 grams. (The "other ounce" is avoirdupois, about 28 grams each.) 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] CRIT [gnc_price_unref()] last unref while price in database
Excellent that you're back in business. What was wrong with the transaction? Regards, John Ralls > On Apr 7, 2020, at 12:15 PM, wrote: > > Many thanks for that, John. > > I'd already got the same error when I opened the last backup file, which is > why I assumed it was more than just a corrupt data file. > > I had to go back 3 versions before I found the one that loaded, but I've > then been able to import all the subsequent log files. > > There was one transaction causing the problem, a foreign currency > transaction. > > All now looks good. > > Thanks again for your help. > > Kind regards, > Rob > > -Original Message- > From: John Ralls > Sent: 07 April 2020 18:34 > To: RobBruce > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] CRIT [gnc_price_unref()] last unref while > price in database > > > >> On Apr 7, 2020, at 9:56 AM, RobBruce wrote: >> >> I'm running 3.4 on Windows 10. >> >> Until this afternoon, it's been running very smoothly. >> >> On trying to load GnuCash, I got a message that there was an error >> parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash >> >> I did look for solutions, and opened the trace log, which contains: >> >> * 12:49:21 WARN Could not spawn perl: Failed to >> execute child process (No such file or directory) >> * 12:49:21 WARN Could not read from compressed file >> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is: >> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' >> (-3) >> * 12:49:21 CRIT parse failed at: >> * 12:49:21 CRIT [gnc_price_unref()] last unref while >> price in database >> * 12:49:21 CRIT [gnc_price_unref()] last unref while >> price in database >> * 12:49:21 WARN [GncXmlBackend::load()] Syntax error in >> Xml File E:\Documents\gnucash-rob\rob-gnucash.gnucash >> >> I'm not aware of having made any change to the file structure - is >> this recoverable, please? > > It looks like you have a corrupted file. Try loading the last backup, which > should be named something like rob-gnucash.gnucash.20200405154732.gnucash; > the numbers in the middle are a date stamp, mmddhhmmss, for the > subsequent save. Depending on what work you did in the last session you may > be able to recover some of it by replaying the corresponding log file with > File>Import>Replay log file. > > You should also check the drive with `chkdsk` and `wmic diskdrive get > status` to make sure that the corruption was something random like a cosmic > ray and not the first sign of needing a new one. > > 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] CRIT [gnc_price_unref()] last unref while price in database
> On Apr 7, 2020, at 9:56 AM, RobBruce wrote: > > I'm running 3.4 on Windows 10. > > Until this afternoon, it's been running very smoothly. > > On trying to load GnuCash, I got a message that there was an error parsing > the file E:\Documents\gnucash-rob\rob-gnucash.gnucash > > I did look for solutions, and opened the trace log, which contains: > > * 12:49:21 WARN Could not spawn perl: Failed to execute > child process (No such file or directory) > * 12:49:21 WARN Could not read from compressed file > 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is: > 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' (-3) > * 12:49:21 CRIT parse failed at: > * 12:49:21 CRIT [gnc_price_unref()] last unref while price in > database > * 12:49:21 CRIT [gnc_price_unref()] last unref while price in > database > > * 12:49:21 WARN [GncXmlBackend::load()] Syntax error in Xml > File E:\Documents\gnucash-rob\rob-gnucash.gnucash > > I'm not aware of having made any change to the file structure - is this > recoverable, please? It looks like you have a corrupted file. Try loading the last backup, which should be named something like rob-gnucash.gnucash.20200405154732.gnucash; the numbers in the middle are a date stamp, mmddhhmmss, for the subsequent save. Depending on what work you did in the last session you may be able to recover some of it by replaying the corresponding log file with File>Import>Replay log file. You should also check the drive with `chkdsk` and `wmic diskdrive get status` to make sure that the corruption was something random like a cosmic ray and not the first sign of needing a new one. 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.
