Page 1 of 1

Ofx import from Mono based Command Line App

Posted: Thu Jul 17, 2014 3:25 pm
by thompsonson
Hi All,

I've updated the command line app i use to import OFX data into MMEX. It should now be cross platform with Mono (only tested on Mac OS so far).

Binaries and usage info can be found here:

https://sourceforge.net/p/mmexnet/wiki/Home/

The code can be found here:

https://github.com/thompsonson/OfxToMmex

Woud love to hear back from people if there are using it or reason why they don't use it :)

All the best,
Matt

Re: Ofx import from Mono based Command Line App

Posted: Sun Jul 20, 2014 9:35 am
by guanlisheng
If i was a end user, i don't except one standalone tool to import any thing... therefore better to integrate it with existent product.

Re: Ofx import from Mono based Command Line App

Posted: Sun Jul 20, 2014 12:37 pm
by thompsonson
guanlisheng wrote:If i was a end user, i don't except one standalone tool to import any thing... therefore better to integrate it with existent product.
I understand, I don't have the skill set or time to re-write for C++ code though.

This is just something I use to make my life easier and thought I'd share it in case it helps others. 

Re: Ofx import from Mono based Command Line App

Posted: Mon Jul 21, 2014 9:31 am
by guanlisheng
Besides programing language difference, why we need table schema modification here ? logically,  current schema is suitable.

Re: Ofx import from Mono based Command Line App

Posted: Mon Jul 21, 2014 2:28 pm
by thompsonson
guanlisheng wrote:Besides programing language difference, why we need table schema modification here ? logically,  current schema is suitable.
OFX uses a unique identifier for a transaction (per account). Using that means you can be sure to import each transaction only once. The addition is a column called FITID (named after the value in the OFX file). There isn't a field for that in the current schema.

Re: Ofx import from Mono based Command Line App

Posted: Tue Jul 22, 2014 12:00 am
by guanlisheng
In this case, transaction number is preferred here.

Re: Ofx import from Mono based Command Line App

Posted: Tue Jul 22, 2014 2:26 pm
by thompsonson
guanlisheng wrote:In this case, transaction number is preferred here.
Yeah, I'd considered that but it's editable. The FITID isn't something that should be changable.

I think the transaction number is used for cheque numbers as well; that's how I'd used it in the past at least. Hardly write a cheque now though!