Difference between revisions of "Pynomina/MsMoney"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
|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. |
Revision as of 08:22, 15 October 2024
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