Pynomina/MsMoney

From BITPlan Wiki
Revision as of 08:21, 15 October 2024 by Wf (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  1. 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