Re: [GNC] Working with dates in Postgresql DB

2020-04-28 Thread John Ralls
> 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

Re: [GNC] Gnucash logs

2020-04-28 Thread Chris Good
From: David H Sent: Wednesday, 29 April 2020 12:49 PM To: Chris Good Cc: Gnucash Users Subject: Re: [GNC] Gnucash logs Chris, How would you see this working with my 2 data files that I have in the same gnucash folder ??? Would the subdirectory(ies) include the name of the data file

Re: [GNC] Gnucash logs

2020-04-28 Thread David H
Chris, How would you see this working with my 2 data files that I have in the same gnucash folder ??? Would the subdirectory(ies) include the name of the data file to clearly identify them or would all log/backup files be lumped in together in a single subdirectory ? When I save my gnucash file

Re: [GNC] Gnucash logs

2020-04-28 Thread Chris Good
Original Message From: Michael or Penny Novack Sent: Tue Apr 28 22:11:04 GMT+05:30 2020 To: "D." Cc: Gnucash Users Subject: Re: [GNC] Gnucash logs On 4/27/2020 10:50 PM, D. wrote: > Michael, > > I take your point; we users will often create duplicated file names for different

Re: [GNC] Gnucash logs

2020-04-28 Thread Michael or Penny Novack
On 4/28/2020 1:14 PM, D. wrote: Michael, I purposefully *didn't* say in this email "almost all users have only one set of books"; I said "I believe that many users only keep one set of books," and I very specifically noted that I do not have statistics regarding the uses to which gnucash is

[GNC] Working with dates in Postgresql DB

2020-04-28 Thread finf...@gmail.com
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

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread Stu Perlman
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

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread David H
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

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread Stu Perlman
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

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread Adrien Monteleone
My understanding is it isn’t exactly ’safe’ to directly edit the data file outside of the app. (this doesn’t mean you can’t, but don’t expect much support if something breaks or data is destroyed) Since you are generating additional transactions, I’d just do that, in the form of a CSV file for

[GNC] Adding Transactions From Another Program

2020-04-28 Thread Hal Vaughan
I’ve done some research on this issue and I’m trying to determine if it’s worth doing more or if I’d just spend time on this topic and find it won’t work. I have a situation I’ve been told GnuCash can’t handle, but I have a Python library that can handle it. (It has to do with calculating

Re: [GNC] Gnucash logs

2020-04-28 Thread D. via gnucash-user
Michael, I purposefully *didn't* say in this email "almost all users have only one set of books"; I said "I believe that many users only keep one set of books," and I very specifically noted that I do not have statistics regarding the uses to which gnucash is put. Neither do you. Your use

Re: [GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-28 Thread Keith Fetterman
Hi Chris, Thanks for the help. I’ll take a look at the last bank import QFX file to see if that’s the issue. Double thanks for sharing the Java code. I’ll test it on MacOS and let you know if it works. It will be a few days before I can test it. Keith > On Apr 27, 2020, at 10:15 PM,

Re: [GNC] Gnucash logs

2020-04-28 Thread Michael or Penny Novack
On 4/27/2020 10:50 PM, D. wrote: Michael, I take your point; we users will often create duplicated file names for different content. I believe that many users only keep one set of books. I don't have any statistics on general GnuCash usage to be able to say whether more users have one file

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread wheelercsg-lists--- via gnucash-user
Actually, Windows 7 is not out of support yet. Microsoft is currently providing Extended Security Updates with purchase of the necessary license. I don't think I am the only one applying ESU updates to my Win 7 machines... On 2020-04-28 11:41 a.m., gnucash-user-requ...@gnucash.org wrote:

Re: [GNC] Reconcile on Import Quick Question

2020-04-28 Thread Jean Laroche
I would think you're right, you're not the only one. I think aqbanking lets you decide whether you want to reconcile upon import or not... On 4/28/20 9:20 AM, Fross, Michael wrote: Thanks Jean.  I'm sure I'm not the only one that imports without reconciling.  I appreciate you looking into it.

Re: [GNC] Reconcile on Import Quick Question

2020-04-28 Thread Fross, Michael
Thanks Jean. I'm sure I'm not the only one that imports without reconciling. I appreciate you looking into it. Have a great day. Michael On Tue, Apr 28, 2020 at 10:42 AM Jean Laroche wrote: > It cannot be turned off at the moment, but I think given your > experience, there should be an

[GNC] GnuCash 3.902 - Saved Reports

2020-04-28 Thread Chris Graves
When opening a saved report created in an earlier version of GnuCash, I receive the following popup message: "This report was saved using a later version of GnuCash. One of the newer multichoice options 'zzz' is not available, fallback to the option 'Default'." Wouldn't better wording be

Re: [GNC] notify when new version is available?

2020-04-28 Thread Bruce Irving via gnucash-user
On platforms with an app store or package manager this doesn't make sense. It's the responsibility of those to inform the user of application updates. And on these platforms it would be silly for each app to reinvent that wheel. I am aware many applications on Windows will notify you when a

Re: [GNC] Reconcile on Import Quick Question

2020-04-28 Thread Jean Laroche
It cannot be turned off at the moment, but I think given your experience, there should be an option to disable it. I'll look into adding that if other devs agree. Jean On 4/28/20 8:35 AM, Fross, Michael wrote: Hello everyone. I installed 3.902 this morning (after uninstalling the previous

[GNC] Reconcile on Import Quick Question

2020-04-28 Thread Fross, Michael
Hello everyone. I installed 3.902 this morning (after uninstalling the previous version) and had a quick question. I tend to download and import from my bank accounts every day. When I was doing so today, after the import, the reconcile dialog appeared. I only reconcile monthly when I get my

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread Mahon Finbar
Oh, so can I assume that GnuCash 5.x will be for Windows 11? only joking, keep up the great work. On 28/04/2020 14:41, Gary Holtum wrote: Why will it not run on Win7 64 bit? Gary -Original Message- From: gnucash-user

Re: [GNC] notify when new version is available?

2020-04-28 Thread Geert Janssens
Op dinsdag 28 april 2020 16:16:36 CEST schreef Robert Heller: > If anyone every implements this, *PLEASE* provide a configuration or CLI > option to disable it. *I* don't want any application I use to "phone home" > on start up everytime (or to phone home *ever* for any reason). Or at > worst,

Re: [GNC] notify when new version is available?

2020-04-28 Thread Robert Heller
At Tue, 28 Apr 2020 09:57:40 -0400 "Derek Atkins" wrote: > > On the other hand, implementing it wouldn't be too hard to do. Not > everyone updates their systems every day/week, so just knowing there is a > more recent version if, for no other reason than to notify their > distribution or look

Re: [GNC] notify when new version is available?

2020-04-28 Thread Robert Heller
At Tue, 28 Apr 2020 15:46:55 +0200 Geert Janssens wrote: > > On platforms with an app store or package manager this doesn't make sense. > It's the > responsibility of those to inform the user of application updates. And on > these platforms it would > be silly for each app to reinvent that

Re: [GNC] notify when new version is available?

2020-04-28 Thread Adrien Monteleone
And most apps I use that employ this also provide the option to not automatically check. So if a user doesn’t want their app ‘phoning home’ without their explicit request, it won’t. Regards, Adrien > On Apr 28, 2020 w18d119, at 8:57 AM, Derek Atkins wrote: > > On the other hand, implementing

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread Geert Janssens
Op dinsdag 28 april 2020 14:55:07 CEST schreef Stan Brown: > On 2020-04-27 17:58, John Ralls wrote: > > The GnuCash development team announces GnuCash 3.902, the first testing > > release for what will soon be GnuCash 4.0. > > > > > > Baseline requirements > > > > Operating Systems: > > •

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread Geert Janssens
Op dinsdag 28 april 2020 14:41:20 CEST schreef Gary Holtum: > Why will it not run on Win7 64 bit? > Gary > Windows 7 is beyond its support date. Hence we no longer support it. If you continue to use Windows 7, that's at your own risk, both in terms of not getting Windows bug fixes and one day

Re: [GNC] notify when new version is available?

2020-04-28 Thread Derek Atkins
On the other hand, implementing it wouldn't be too hard to do. Not everyone updates their systems every day/week, so just knowing there is a more recent version if, for no other reason than to notify their distribution or look there, isn't a BAD thing. I'll note that there are other systems,

Re: [GNC] notify when new version is available?

2020-04-28 Thread Geert Janssens
On platforms with an app store or package manager this doesn't make sense. It's the responsibility of those to inform the user of application updates. And on these platforms it would be silly for each app to reinvent that wheel. I am aware many applications on Windows will notify you when a

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread Stan Brown
On 2020-04-27 17:58, John Ralls wrote: > The GnuCash development team announces GnuCash 3.902, the first testing > release for what will soon be GnuCash 4.0. > > Baseline requirements > > Operating Systems: > > • Linux: Ubuntu 18.04LTS > • MacOS: 10.13 > • Windows: 8.1 Out

Re: [GNC] GnuCash 3.902 released

2020-04-28 Thread Gary Holtum
Why will it not run on Win7 64 bit? Gary -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On Behalf Of John Ralls Sent: Monday, April 27, 2020 8:58 PM To: gnucash-annou...@gnucash.org Cc: gnucash-devel; Gnucash Users Subject:

Re: [GNC] Counters have stopped incrementing in recent versions of GC

2020-04-28 Thread gnucash . dgr9z
I had created a ticket about a year ago when new counter formats would not save in 3.4. That issue was resolved. The problem here is that they no longer increment in 3.10 in my working file (XML format). However, I did test this on a new file using 3.10 and it worked as expected in that

Re: [GNC] Volunteers for a triage teem; was: Gnucash logs

2020-04-28 Thread D. via gnucash-user
Frank, I don't understand; comment number 2 on https://bugs.gnucash.org/show_bug.cgi?id=638858 was written by Jeff on 2016-04-28, and reads in its entirety: Yes this would be a great option! Is is also listed on the GnuCash Feature Requests here: