[GNC] CVS import over-writing transactions?

[david whiting]

Ah, PBCK. I should have read the docs before posting:
https://code.gnucash.org/docs/C/gnucash-help/trans-import.html#trans-import-matcher


Specifically:

"If there is a lower quality match to an existing transaction, the imported
transaction may be flagged for updating of non-matching information in the
GnuCash record of the matching transaction. These decisions can be
overridden by the user."

Apologies for the noise.

David

On Wed, 15 Mar 2023 at 07:48, david whiting <dw at davidwhiting.me.uk> wrote:

> OS: Linux (NixOS)
> Gnucash: 4.12 Build ID: 4.12+(2022-09-24)
> Backend: sqlite
>
> This is a weird one, and I can't work out if it's me or gnucash. I import
> transactions from a cvs export from my bank. I check the date of the last
> transaction that I have imported and truncate the csv file so that I'm only
> importing new transactions.
>
> After the import, usually, but not always, I check to make sure that the
> ending balance on the bank account matches that in gnucash. A couple of
> times I have found that it isn't and I check through each date to see where
> I have missed a transaction. When this has happened I have assumed that I
> truncated the import file incorrectly. I then manually add the missing
> transaction(s).
>
> I'm using gnucash for a local football club. At the moment we are taking
> payments for a tournament that we are organising and for these transactions
> I have been writing a number in the num column. Each number is unique and
> identifies the team that has registered (it has the row number from the
> separate registration database and the age group). When I did an import
> today, I found that some transactions were missing again and so I started
> to enter them; then I noticed that some of the new transactions that I had
> imported already had numbers in the num column, but the numbers related to
> the teams where the transactions were missing.
>
> See attached screenshot. This shows a transaction on 14/03/2023 where the
> number is T-25-U8 but the reference contains T-89-VETS, and similarly for
> the transaction below it. The T-25-U8 payment was made on 01/03/2023 (1
> March 23), but was missing after the import. The transaction with T-89-VETS
> in the reference shouldn't have had a number yet, as I hadn't entered it.
> This looks like the transaction with T-89-VETS has overwritten the T-25-U8
> transaction, except for the num.
>
> I make daily backups, so I looked at a backup from a couple of days ago
> and the original T-25-U8 transaction on 01/03/23 (1 March 23) was there. So
> it looks like the cvs import sometimes overwrites some transactions.
>
> I have looked at https://bugs.gnucash.org/ for bugs with the word
> "import" covering the last year and can't see anything that looks like this
> and I have checked the release notes for 4.13 and see no mention of a bug
> fix for something like this.
>
> Has anyone else seen anything like this? Is there anything I could be
> doing wrong when importing the csv file?
>
> David
> --
> David Whiting
>


-- 
David Whiting