1. hleofxquotes-team Avatar hleofxquotes-team
  2. open
  3. dist-sunriise

Wiki

Clone wiki

dist-sunriise / msmoney_file_disk_usage

View History

msmoney file disk usage

Tools to show disk usage for *.mny file

Prerequisites

You will need Java installed. You can download from https://adoptopenjdk.net/

Download

Download from Downloads link. Look for latest version of sunriise-diskusage-n.n.n-SNAPSHOT.zip

To install and run

$ unzip sunriise-diskusage-0.0.2-SNAPSHOT.zip 
Archive:  sunriise-diskusage-0.0.2-SNAPSHOT.zip

$ cd sunriise-diskusage-0.0.2-SNAPSHOT/

$ java -jar sunriise-diskusage-0.0.2-SNAPSHOT-exec.jar

# Or just double-click on the jar file
To open your *.mny file, just drag-and-drop your *.mny onto the main window.

disk-usage.png

Columns

  • Table: table name
  • Bytes: number of bytes used by the table
  • Rows: number of rows (entries) in the table
  • Columns: number of columns (attributes) in the table

You can double-click on the column name to sort the column. You can use keyboard shortcut

  • control-a: to select all the rows
  • control-c: to copy
  • control-v: to paste

into Excel on CSV file for further manipulation.

Common tables with large disk usage

  • TRN: list of transactions
  • PAY: list of payees
  • SP: security prices (stock prices)
  • LOT: security lot information
  • CAT: list of categories
  • TRN_SPLIT: split information for transaction

Updated