OfxToMmexConsoleApp

The ImportOfx tool is a command line utility for Money Manager Ex

Please back up your database before doing anything below

Schema change

The utility needs an additional column in the CheckingAccount_V1 table to store the unique (to that transaction in that account) transaction ID.

ALTER TABLE CHECKINGACCOUNT_V1 ADD COLUMN FITID STRING;

it also uses a table to process payee references (more documentation to come).

CREATE TABLE OfxToMmexPayeeNameRegex(ID INTEGER PRIMARY KEY,regex STRING,GroupIndex INTEGER, Active INTEGER);

Currently the utility doesn't add this if it's not present - you will need to add this before using it. To run this in you'll need to use the sqlite3.exe command line - the tool is available from SQLite's download page.

cd DIRECTORY\WHERE\MMB\DATABASE\IS
sqlite3.exe Test.mmb "ALTER TABLE CHECKINGACCOUNT_V1 ADD COLUMN FITID STRING;"
sqlite3 Test.mmb "CREATE TABLE OfxToMmexPayeeNameRegex(ID INTEGER PRIMARY KEY,regex STRING,GroupIndex INTEGER, Active INTEGER);"

This will add the column to store the ID.

Configuration

You will need to change the path in the OfxToMmexConsoleApp.exe.config file. The entry is

<add name="mmex_db" connectionString="Data Source=.\Test.mmb;" providerName="Mono.Data.SQLite" />

change the Data Source value to point to your database. eg: if your DB is located at c:\mmex\mmex.mmb

<add name="mmex_db" connectionString="Data Source=c:\mmex\mmex.mmb;" providerName="Mono.Data.SQLite" />

You can set up logging by changing the following path - set it to the location of your exe

<add key="log4net" value="./log4net.config"></add>

Leave the rest of the entry as it already is.

Importing Data

Once the database path is set you can import the data, just run the command passing the ofx you wish to import.

mono OfxToMmexConsoleApp.exe c:\path\to\my\bank.ofx

Voila - open mmex and there are your transactions.