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
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
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
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
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
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