[GNC] [MAINT] Planned upstream network work July 1-2 US/EDT

2021-06-16 Thread Derek Atkins
Hi, TL;DR: There is an expected 15-minute network outage between 9pm July 1 and 3am July 2 (US/EDT) due to ISP router maintenance. Long Version: I received the following notification from my upstream network provider: Start Date: 2021-07-01 21:00 Eastern Time End Date: 2021-07-02 3:00 Eastern

[GNC] Reconciliation screw-up

2021-06-16 Thread Jeff
I may confuse myself even more here, so would appreciate some patience and guidance. I was given bank statements for 2 accounts (A and C).  Unbeknownst to me there was a transaction that was supposed to go from account A to C (A $1 -> C $1).  When the entries were made, the transactions were e

[GNC] sql query to show all changed transactions during given time interval

2021-06-16 Thread Fourhundred Thecat
Hello, I am using gnucash with mysql backend. I know how to query mysql database, to list for example all transactions for the last week: SELECT t.post_date,a.name,t.description,s.value_num FROM splits as s,transactions as t,accounts as a WHERE s.account_guid = a.guid AND s.tx_guid = t.guid AND

Re: [GNC] sql query to show all changed transactions during given time interval

2021-06-16 Thread Derek Atkins
Entered is doable (based on date entered column). Changed... Not so much. There isn't a column for that. -derek Sent using my mobile device. Please excuse any typos. On June 16, 2021 11:25:02 PM Fourhundred Thecat <400the...@gmx.ch> wrote: Hello, I am using gnucash with mysql backend. I kn

Re: [GNC] Reconciliation screw-up

2021-06-16 Thread David Carlson
Jeff, If both accounts A and C are bank accounts and you are satisfied with the same transaction appearing in both accounts, perhaps with differing split memos, just select one of the two to edit to that result. When you delete the other transaction and the edited transaction appears in that acco

Re: [GNC] GnuCash very slow to start up and quit

2021-06-16 Thread Saša Janiška
On Sun, 13 Jun 2021 09:10:42 + Tim Hume wrote: > I just ran a test. My data file is 37 MByte in SQLite format, and 52 > MByte when in XML and uncompressed. However, the compressed XML is > under 4 MByte. > > It took 1m 17s to open GnuCash with the compressed XML file, and 55s > with the SQLi