locked
Money 2007 Deluxe crash after importing OFX statement RRS feed

  • Question

  • I reinstalled Money 2007 Deluxe on my machine and now whenever I try to import bank statement in ofx format it crashes and closes. Could it be something about the format of OFX file? I remember reading something long time ago about region setting and the year-month-date format that may cause problem.
    Tuesday, December 4, 2012 6:45 PM

All replies

  • If you're running Windows 8 you may wish to look through this thread :

    http://social.microsoft.com/Forums/en/money/thread/636e154a-9693-48a0-ab38-65627d192f6a 

    Reported problems are with adding new payees and importing OFX.

    Wednesday, December 5, 2012 9:06 AM
  • I had that problem too.

    What bugged me was that when I imported the OFX file in a different .mny file, it worked fine.

    When I looked at the Preferred Payee Names table in my .mny file, there were thousands of entries, several of them identical (that part I don't understand).

    Working on a copy of my .mny file, I deleted all the entries in the table (using an Excel macro deleting a thousand at a time).

    When I tried to import the OFX file that was causing the problem, it worked fine.

    The old transactions are still allocated to the correct payee.  For the new ones, I will have to make sure there are allocated to the correct payee and rebuild the table.

    A bit complicated but it worked.

    AG

    Friday, May 24, 2013 3:57 PM
  • I hope you will read and respond to this late reply to your last week's post. I'm working on the PalOMoney Money helper application, and one of the things we had to do is find and fix a second bug (an earlier bug was fixed by Raymond Chen) that caused a crash when importing OFX files. It looks like you have found yet another bug. If so, we may be able to investigate and fix it. Can I ask a few technical questions?

    Your results suggest that deleting entries in the "Preferred Payee Names table" eliminated the crash. Did you mean that, under Account Tools, you selected "Categories and Payees" then clicked on "Preferred payee names" to display the "Set up preferred payee name list" page? (BTW this is not an actual database table by itself, rather it is a query on the payee (PAY) table, which may be part of the problem.)

    How did you get an Excel macro to delete rows in this MS Money list? Users run into this situation where they mistakenly import a ton of data to the wrong account, and could use a quick way to delete rows of data. Please let us know!

    Did you save your old file (the one that crashes) and the crash-causing import file? Is there some way you would be willing to try the existing patches to your system to see if this fixes your problem? If so, see "https://www.palomoney.com/wiki/index.php/Money_Sunset_Patch_Utility".

    I too am concerned about the bloating caused by Money adding every little transaction as an alias to whatever payee you ultimately select, and perhaps PalOMoney can deal with this issue intelligently. Nevertheless, Money should never crash, and I think we need to fix these bugs. Thank you.

    Friday, May 31, 2013 8:40 PM