[GNC] CVS import over-writing transactions?

[david whiting]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnucash-over-writing-on-csv-import.png
Type: image/png
Size: 10313 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230315/e2617ed5/attachment-0001.png>