Friday, March 24, 2017

New version released

Updated:  10-Apr-2017

Spurred by recent OFX server changes at Discover (and apparently others), the script package has been updated, and is posted for download @ https://sites.google.com/site/pocketsense/home/msmoneyfixp1/p2.  Thanks to everyone for feedback and help!  I think we're in good shape for a while, but it would be really nice if the bank developers would abide by the OFX standard ;)

Summary of Changes

  • Updated url requests to work with recent changes at Discover and others.
  • Added support for OFX 2.x (tested with ofxVer=211 @ Discover, but they support 102 and 103 too).
  • Added support for user-specific clientUID pairs (by site url + username).
  • Added skipZeroTransactions option to sites.dat configuration.  If Yes, remove $0.00 transactions from downloaded statements.
  • Minor code updates and bug patches.

10 comments:

  1. Hi Robert. With the end of the month I was finally able to test the sign fix for Net Benefits in the new version. It turns out it doesn't work, but I've spotted the reason why.

    INVBUY and INVSELL transactions have the following order

    REINVEST has a different order (of course, why not, why have a standard?):

    As a result the regex that's used in _scrubINVsign does not pick up REINVEST transactions

    Thanks
    Carlos

    ReplyDelete
    Replies
    1. Thanks Carlos. I think something's missing from the post above?

      Delete
    2. Ugh. I forgot tags get interpreted by the comment engine.
      INVBUY and INVSELL transactions have the following order: UNITS, UNITPRICE, TOTAL
      REINVEST order is: TOTAL, UNITS, UNITPRICE

      I can provide you with an example, if you want. It's a trivial change, but a different scrubber is needed for REINVEST than for INVBUY/INVSELL.

      Delete
    3. Gotcha. Pretty sure I know what's needed, but since I can't test, it would be quickest if you send me the scrub routine you're using for REINVEST transactions, and I'll add it. Send to pocketsense1/at/gmail/dot/com.

      Delete
  2. Thank you so much for your work on this Robert!

    -ameridan

    ReplyDelete
  3. New version posted, including scrubber update provided by Carlos. Specifically, malformed REINVEST transactions should now be handled correctly.

    ReplyDelete
  4. Um, _scrubREINVESTsign is not actually called anywhere, is it?

    ReplyDelete
    Replies
    1. Well... that's embarrassing. Fixed.

      Delete
  5. Yeah Robert, thanks for maintaining this site. This has been a great tool to keep MSMoney alive.
    So, I was wondering if it would be a challenge to add a feature in SETUP to re-arrange the Site list order of execution. Thanks again!

    ReplyDelete