question on possible cleanup of stored (redundant) reconciation data

[Thomas Baumgart]

On Dienstag, 4. März 2025 22:56:21 CET Jack via KMyMoney-devel wrote:

> I'm currently working on my monthly reconciliation of most of my  
> investment accounts, and have found a potential for inconsistent (and  
> very confusing) data.
> 
> Reconciliation data is stored in three separate places within an  
> <ACCOUNT ......> entity.
> 
> First, within the <ACCOUNT .....> tag itself, there is a  
> "lastreconciled='yyyy-mm-dd'" attribute.
> Second, the <RECONCILIATIONS ...> entity within the account contains a  
> <RECONCILIATION ...> tag with date and value for each reconcilation.
> Finally, in the <KEYVAULUEPAIRS ....> for the account, there is a <PAIR  
> key="reconciliationHistory" ...> tag where the value is a semicolon  
> separated list of all the reconciliation date:value pairs for the  
> account.
> 
> It seems to me the second and third types are completely redundant, and  
> wonder if one of them should be removed.
> 
> The third one can easily be found by using the last entry in either of  
> the other two lists, so I wonder if it should also be removed as  
> redundant.

There's an easy answer: They will be consolidated once we have 5.2 out the door.
For now they are kept for backward compatibility reasons.

> ---
> 
> Irrelevant FYI as to why I went digging into this: when I reconcile an  
> Investment Account (after reconciling its associated Brokerage account,  
> I start by confirming the number of shares held of all securites in  
> that account.  For some reason, when I do this, that account closes in  
> the ledger, and I am left in the Brokerage account ledger.  On rare  
> occasion, I don't notice, and rush through the reconciiation wizard -  
> which then runs on the Brokerage account for today.  Normally, I do  
> notice this, so can either cancel that reconciliation, or undo the last  
> action, if I complete the reconciliation.  Today, I did not notice, and  
> was halfway through reconciling the next account before I noticed.  I  
> therefore went to remove the extraneous reconciliation by manually  
> editing the xml file.  That led me to all the above.
> 
> At some future time (probably not until we get to the revision of the  
> whole investment handling by KMM) I will include a way to remove old  
> reconciliation entries from the list.  I know it's not really  
> necessary, as the amount of "extra" data is small, but I would prefer  
> to be able to clean up those lists, for example removing all except the  
> end of year reconciliation for more than two or three years ago.
> 
> Jack
> 
> 

-- 

Regards

Thomas Baumgart

-------------------------------------------------------------
Real backups of your NAS can be found with the NSA
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20250305/9133745e/attachment.sig>