Difference between revisions of "FerretMyMoney"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(saving work)
 
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:
 
==About==
 
==About==
 
[[FerretMyMoney]] (FMM) is a [[MediaWiki]] extension which is intended to fill in some missing or poorly-implemented functions in [[KMyMoney]] (KMM). It works with a KMyMoney database which has been exported to [[MySQL]] (later versions of KMyMoney are capable of working with the data in this format, so the export only needs to be done once).
 
[[FerretMyMoney]] (FMM) is a [[MediaWiki]] extension which is intended to fill in some missing or poorly-implemented functions in [[KMyMoney]] (KMM). It works with a KMyMoney database which has been exported to [[MySQL]] (later versions of KMyMoney are capable of working with the data in this format, so the export only needs to be done once).
 +
==Obstacles==
 +
Apparently KMM renumbers the IDs for its transactions at export time, which means that there is no rigorous way to keep external data synchronized with KMM's transaction data. It's not clear whether this is true if KMM is using MySQL data directly. Given this problem, however, FMM needs to generate its own unique transaction IDs and keep a fingerprint of the KMM transaction records to which those IDs apply, so that they can be re-linked any time KMM renumbers the transation IDs.
 
==Features==
 
==Features==
* (under construction) tracking of the date on which the '''bank''' shows each transaction (separate from either the actual date of the transaction and the date on which the transaction was entered in KMM), so KMM's data can be shown sorted in the same order the bank shows it, allowing for easier [[balance reconciliation]]
+
* tracking of the date on which the '''bank''' shows each transaction (separate from either the actual date of the transaction and the date on which the transaction was entered in KMM), so KMM's data can be shown sorted in the same order the bank shows it, allowing for easier [[balance reconciliation]]
* (planned) ability to force the balance to a certain figure at a certain point in the calculations, allowing better handling of missing bank records and statements
+
* ability to force the calculated balance to match the bank's balance at any point, allowing better handling of missing bank records and statements
 
==Documentation==
 
==Documentation==
 
* '''Tables''':
 
* '''Tables''':
 
** [[/sql/fmmTrxacts|Transactions]]
 
** [[/sql/fmmTrxacts|Transactions]]
 +
** [[/sql/fmmBankBals|Bank Balances]]

Latest revision as of 17:05, 15 March 2012

About

FerretMyMoney (FMM) is a MediaWiki extension which is intended to fill in some missing or poorly-implemented functions in KMyMoney (KMM). It works with a KMyMoney database which has been exported to MySQL (later versions of KMyMoney are capable of working with the data in this format, so the export only needs to be done once).

Obstacles

Apparently KMM renumbers the IDs for its transactions at export time, which means that there is no rigorous way to keep external data synchronized with KMM's transaction data. It's not clear whether this is true if KMM is using MySQL data directly. Given this problem, however, FMM needs to generate its own unique transaction IDs and keep a fingerprint of the KMM transaction records to which those IDs apply, so that they can be re-linked any time KMM renumbers the transation IDs.

Features

  • tracking of the date on which the bank shows each transaction (separate from either the actual date of the transaction and the date on which the transaction was entered in KMM), so KMM's data can be shown sorted in the same order the bank shows it, allowing for easier balance reconciliation
  • ability to force the calculated balance to match the bank's balance at any point, allowing better handling of missing bank records and statements

Documentation