Difference between revisions of "Pynomina/MsMoney"

From BITPlan Wiki
Jump to navigation Jump to search
(Created page with "# {{Ticket |number=12 |title=add Microsoft Money support |project=pynomina |createdAt=2024-10-09 11:43:54+00:00 |closedAt=2024-10-10 03:49:15+00:00 |state=closed }} Microsoft...")
 
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
# {{Ticket
+
{{Link|target=Pynomina|title=back to Pynomina main page}}
 +
 
 +
see {{Ticket
 
|number=12
 
|number=12
 
|title=add Microsoft Money support
 
|title=add Microsoft Money support
Line 7: Line 9:
 
|state=closed
 
|state=closed
 
}}
 
}}
 +
 
Microsoft .mny files are Microsoft Jet Database / Microsoft Access files. To work with these files you'll need the [https://github.com/mdbtools/mdbtools mdbtools] installed.
 
Microsoft .mny files are Microsoft Jet Database / Microsoft Access files. To work with these files you'll need the [https://github.com/mdbtools/mdbtools mdbtools] installed.
 
Pynomina will convert the money file table contents to JSON, add a YAML header file and create a ZIP file for the results.
 
Pynomina will convert the money file table contents to JSON, add a YAML header file and create a ZIP file for the results.
Line 59: Line 62:
 
✔ Conversion complete. Output file: datevtest.zip
 
✔ Conversion complete. Output file: datevtest.zip
 
</source>
 
</source>
 +
You can now inspect the JSON files
 +
=== ACCT.json ===
 +
 +
<source lang='json'>
 +
{
 +
  "hacct": 1,
 +
  "ast": 0,
 +
  "at": 0,
 +
  "szFull": "test Girokonto",
 +
  "amtOpen": 0.0000,
 +
  "dtOpen": "01/00/00 00:00:00",
 +
  "dtEndRec": "01/00/00 00:00:00",
 +
  "dtOpenRec": "01/00/00 00:00:00",
 +
  "fFavorite": 0,
 +
  "fClosed": 0,
 +
  "fInRec": 0,
 +
  "fTaxRel": 0,
 +
  "fRetirement": 0,
 +
  "hfi": 2,
 +
  "hcrnc": 14,
 +
  "fVatEnabled": 1,
 +
  "grp": 3,
 +
  "fStmtRequested": 0,
 +
  "fAutobalance": 0,
 +
  "fDebtPlan": 0,
 +
  "cpm": -1,
 +
  "dtIntRateChg": "01/00/00 00:00:00",
 +
  "frqDebtPay": -1,
 +
  "dtNextDebtPay": "01/00/00 00:00:00",
 +
  "fEmpMatch": 0,
 +
  "fEmpMatchPost": 0,
 +
  "fAdjustAmtPost": 0,
 +
  "frq": -1,
 +
  "frqCpd": -1,
 +
  "iPmtMax": -1,
 +
  "fCanadian": 0,
 +
  "fCoupon": 0,
 +
  "fLent": 0,
 +
  "fARM": 0,
 +
  "dtNextAdj": "01/00/00 00:00:00",
 +
  "frqAdj": -1,
 +
  "ctrnPartialChecks": 0,
 +
  "fGotInterest": 0,
 +
  "fGotService": 0,
 +
  "lDebtHtrn": -1,
 +
  "dtClose": "01/00/00 00:00:00",
 +
  "grfAdvice": 0,
 +
  "dtCBPost": "01/00/00 00:00:00",
 +
  "lCB": -1,
 +
  "olatHint": 0,
 +
  "dtCBCut": "01/00/00 00:00:00",
 +
  "DATEV": "0001200"
 +
}
 +
</source>
 +
= opening Microsoft money files =
 +
<source lang='bash' highlight='1'>
 +
nomina -l -s -i datevtest.zip
 +
</source>
 +
In the browser you should see:
 +
<pre>
 +
datevtest.zip (MS-MONEY-ZIP)
 +
1999-09-11-1999-09-11
 +
1 accounts, 1 transactions
 +
</pre>
 +
{{:Pynomina/Note}}

Latest revision as of 08:41, 15 October 2024

back to Pynomina main page

see Issue 12 - add Microsoft Money support

Microsoft .mny files are Microsoft Jet Database / Microsoft Access files. To work with these files you'll need the mdbtools installed. Pynomina will convert the money file table contents to JSON, add a YAML header file and create a ZIP file for the results. You might want to first theck whether this process works for you using the money-zip command line tool that comes with pynomina.


money-zip

money-zip -h
usage: money-zip [-h] [-ct] [-d] [--keep] [--version] [-o OUTPUT] [mny_file]

Convert Microsoft Money files to ZIP

positional arguments:
  mny_file              Microsoft Money file to convert

options:
  -h, --help            show this help message and exit
  -ct, --checktools     Check if required tools are installed
  -d, --debug           Enable debug output
  --keep                Keep the temporary files after conversion
  --version             show program's version number and exit
  -o OUTPUT, --output OUTPUT
                        Specify the output directory - default:
                        /tmp/[basename]_money_dump

check tools

money-zip --checktools
✔ mdb-ver is available
✔ mdb-tables is available
✔ mdb-json is available

conversion

The --keep option makes sure the temporary output files are available for inspection

money-zip datevtest.mny --keep
/tmp/datevtest_mdb_dump/nomina.yaml ...
ADDR ...
✖ ADDR → /tmp/datevtest_mdb_dump/ADDR.json
...
CAT ...
✔ CAT → /tmp/datevtest_mdb_dump/CAT.json
ACCT ...
✔ ACCT → /tmp/datevtest_mdb_dump/ACCT.json
...
TRN ...
✔ TRN → /tmp/datevtest_mdb_dump/TRN.json
...
→ Creating zip archive...
✔ Temporary files kept in /tmp/datevtest_mdb_dump
✔ Conversion complete. Output file: datevtest.zip

You can now inspect the JSON files

ACCT.json

{
  "hacct": 1,
  "ast": 0,
  "at": 0,
  "szFull": "test Girokonto",
  "amtOpen": 0.0000,
  "dtOpen": "01/00/00 00:00:00",
  "dtEndRec": "01/00/00 00:00:00",
  "dtOpenRec": "01/00/00 00:00:00",
  "fFavorite": 0,
  "fClosed": 0,
  "fInRec": 0,
  "fTaxRel": 0,
  "fRetirement": 0,
  "hfi": 2,
  "hcrnc": 14,
  "fVatEnabled": 1,
  "grp": 3,
  "fStmtRequested": 0,
  "fAutobalance": 0,
  "fDebtPlan": 0,
  "cpm": -1,
  "dtIntRateChg": "01/00/00 00:00:00",
  "frqDebtPay": -1,
  "dtNextDebtPay": "01/00/00 00:00:00",
  "fEmpMatch": 0,
  "fEmpMatchPost": 0,
  "fAdjustAmtPost": 0,
  "frq": -1,
  "frqCpd": -1,
  "iPmtMax": -1,
  "fCanadian": 0,
  "fCoupon": 0,
  "fLent": 0,
  "fARM": 0,
  "dtNextAdj": "01/00/00 00:00:00",
  "frqAdj": -1,
  "ctrnPartialChecks": 0,
  "fGotInterest": 0,
  "fGotService": 0,
  "lDebtHtrn": -1,
  "dtClose": "01/00/00 00:00:00",
  "grfAdvice": 0,
  "dtCBPost": "01/00/00 00:00:00",
  "lCB": -1,
  "olatHint": 0,
  "dtCBCut": "01/00/00 00:00:00",
  "DATEV": "0001200"
}

opening Microsoft money files

nomina -l -s -i datevtest.zip

In the browser you should see:

datevtest.zip (MS-MONEY-ZIP)
1999-09-11-1999-09-11
1 accounts, 1 transactions

Please note that nomina itself does not have a lot of features to work with your personal finance managament content yet. You might want to use the # Issue 7 - command line conversion support and start a discussion or issue to have your own needs covered.