locked
OFX association stopped working RRS feed

  • Question

  • My computer got infected, and I reformatted my HD and reinstalled everything.  When I got to MS Money I installed the Sunset Version and everything seemed to work fine initially.  Including the Python scripts for downloading bank data.  Today, however, when I ran the Python Script, it would open the files in another program (Microsoft Office Accounting 2009) which can also use ofx files.  The sequence of events:

    • Reinstall W7x64
    • Install Money Sunset
    • Python scripts work properly, and ofx files open in Money
    • Install MS Office Accounting 2009
    • Unfortunately, I cannot recall if the OFX file association worked between that time (a few months ago) and today.

    I then tried the various methods posted here to reassociate the file.

    • Change the file association in Control Panel / Programs / Default Programs / Set Associations
         Initially this was set to MS Office Accounting 2009.  After running an "unassociate" program, I was able to associate this with C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles\mnyimprt.exe.  But double clicking the file did nothing; and running the GetData.py script likewise did not send the downloaded files to Money.
    • I checked the registry entry HKEY_CLASSES_ROOT\ofx.Document\Shell\Open\Command value is "C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles\mnyimprt.exe" %1

    Of note, I can select the individual files from File/Import in MS Money, but this is not practical with 15-20 OFX files.

    All help would be appreciated.


    Ron


    Edit:  I had not cleared the temporary internet files before the above.  After clearing them, the ability to double-click the file, with mnyimprt set as the default program, WOULD work.  However, running the GetData.py script still was not resulting the files being received by Money  (the script said it was sending them, but they never arrived), so I suspect that under that condition, mnyimprt is not be called properly.
    • Edited by Ron Rosenfeld Saturday, March 10, 2012 8:55 PM addition
    Saturday, March 10, 2012 8:46 PM

All replies

  • I plugged "file types" into Windows help (32 bit) and got something on "Change the program that opens a type of file". I then searched for a KB article. I hit this which is more involved, and it may be helpful.

    http://answers.microsoft.com/en-us/windows/forum/windows_7-files/problems-with-file-association-in-windows-7-64-bit/8a84fcec-22df-4942-8e35-d98dbe96e327

    I guess you see the OFX files fine in your xfr folder/directory. From a command window, you could try launching the OFX files by entering its name into the command window. I don't know why that would be different from double-clicking in WE, but it seems worth a test.

    I looked thru my registry for mnyimprt. Some keys had names that had to do with rights elevation. Suppose you launched a command window as administrator and ran Getdata.py from that window?

    Pretty clearly Office Accounting is what broke the OFX file associaton. Have you tried reinstalling Money after Office Accounting?



    Saturday, March 10, 2012 10:25 PM
    Moderator
  • On Sat, 10 Mar 2012 22:25:34 +0000, Cal Learner wrote:
     
    >
    >
    >I plugged "file types" into Windows help (32 bit) and got something on "Change the program that opens a type of file". I then searched for a KB article. I hit this which is more involved, and it may be helpful.
    >
    >
    >I guess you see the OFX files fine in your xfr folder/directory. From a command window, you could try launching the OFX files by entering its name into the command window. I don't know why that would be different from double-clicking in WE, but it seems worth a test.
     
    As I wrote, double-clicking in WE works now (since I cleared temp internet files), so long as I select mnyimprt for the program first, but getdata.py does not.
     
    I did try in an elevated CMD window, and neither getdata nor typing in an ofx file name did anything that I could see.
     
    >
    >I looked thru my registry for mnyimprt. Some keys had names that had to do with rights elevation. Suppose you launched a command window as administrator and ran Getdata.py from that window?
    >
    >Pretty clearly Office Accounting is what broke the OFX file associaton. Have you tried reinstalling Money after Office Accounting?
     
    Yes, I did, no change.  And several reboots along the way.
     
    ----------------------------------------
     
    Huh? 
     
    After going through the exercises you mentioned above, I went back to the xfr folder.  As I had done many times before in the past few hours, I doubleclicked on an ofx file; nothing happened; I then selected 'open with' and noted that mnyimprt was selected.  I ran it again and it did import into Money.  (I have gone through this process at least ten times today).  But 2 seconds later, the screen flickered, and all of the icons changed to the Money icon (they had been showing a generic icon before); and now everything seems to be working properly again, including getdata.py.
     
    I did nothing to cause it to start working; I did nothing I hadn't done many times previously today.  I don't know why it started to work; I just hope it continues to do so.
     
    I hate these kinds of events.
     
    Thanks for your input.  Maybe something in the cmd window that I did?  I don't see how, since there was not an immediate response.
     
    -- Ron
     
     

    Ron
    Saturday, March 10, 2012 11:39 PM
  • I hope it keeps going. I have an idea that might help if things stop working. While things are working, in regedit select Computer (the top) and do a File->Export to a *.reg file. Then if things stop working, do a similar File->Export. Suppose I name the output file abc.reg.

    I like to

    type abc.reg>abc2.reg

    So if I exported to abc.reg, it is in unicode. The above line would give me the equivilant in ASCII in abc2.reg. Some of my old favorite tools work better in ASCII.

    Anyway, after I got the *.reg files that correspond to working and non-working, I would do a diff redirected to a file. I would edit that file and look for either ofx or mnyimprt with a text editor. Only things that were different that involved those two strings would be involved in the problem I would guess. At least I think it has a reasonable chance of pointing the way.


    Sunday, March 11, 2012 6:28 AM
    Moderator
  • On Sun, 11 Mar 2012 06:28:10 +0000, Cal Learner wrote:
     
    >
    >
    >I hope it keeps going. I have an idea that might help if things stop working. While things are working, in regedit select Computer (the top) and do a File->Export to a *.reg file. Then if things stop working, do a similar File->Export. Suppose I name the output file abc.reg.
    >
    >I like to
    >
    >type abc.reg>abc2.reg
    >
    >So if I exported to abc.reg, it is in unicode. The above line would give me the equivilant in ASCII in abc2.reg. Some of my old favorite tools work better in ASCII.
    >
    >Anyway, after I got the *.reg files that correspond to working and non-working, I would do a diff redirected to a file. I would edit that file and look for either ofx or mnyimprt with a text editor. Only things that were different that involved those two strings would be involved in the problem I would guess. At least I think it has a reasonable chance of pointing the way.
    >
    >
     
    Excellent idea, Cal.  I have taken your advice and now have a registry copy (actually two), sitting on my desktop.  Hopefully I won't need them, but ...
     

    Ron
    Sunday, March 11, 2012 8:21 PM
  • Hi, I have actually the same problem. could you extract from your reg file all the OFX occurence?

    So that I can check with my own reg file.


    Here are mine (Note that importOFX.bat is my import script):

    Search "OFX" (39 hits in 1 files)
      C:\Users\#######\Desktop\all.reg (39 hits)
        Line 4822: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.ofx]
        Line 4823: @="ofx.Document"
        Line 4824: "Content Type"="text/ofx"
        Line 172096: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MIME\Database\Content Type\application/x-ofx]
        Line 172097: "Extension"=".ofx"
        Line 172247: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MIME\Database\Content Type\text/ofx]
        Line 172248: "Extension"=".ofx"
        Line 177521: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document]
        Line 177525: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\DefaultIcon]
        Line 177528: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell]
        Line 177530: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell\Open]
        Line 177532: [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell\Open\Command]
        Line 521891: "68AB67CA7DA76301B744AA0100000010"="C:\\Program Files (x86)\\Adobe\\Reader 10.0\\Reader\\Acrofx32.dll"
        Line 521896: "File"="Acrofx32.dll"
        Line 539017: "iTunes"="jQ9jsb5r0@]6YQx=3485p[-tfn}en=MCS'sfb@bLjAYOu86DTA~&^8Ekwr%jU2[p=n+7YA(D~CnWx3g?wdOFxNaCQ9KaVhoIH6(aY5U[HqIwg(s@r!!U.{{H?FI,&I]%h(NPZCj&lrLWK8dP]zE9h(itBN.,$wkR@Tl9soU]r=kj0f@?}RQ!@V[zER4cO9nDwowDX%}t_pGGkZzLh9r3NU)LvJSVSkCIHffW`@Xg7l2d2''UQCj*zCQQz8oUZ5(fRDLY0L0c.J.Pt?p^g$mCOr5odFsVxY,_3?t3axt)YZJAEkcIr]70~98ufRSxITDzVzO*_2dt,Ai@SrsbWH*hv9h@VbudQ9Vm(S-yyVM7+1*w%l]Cz=}Cm?t^oWW7!Es`1i3ph@CdCJWfQ``wmVun,Wme2@8=tSt7),`PjUmpC=k2`A8%19C]2_O4VPQzF2_U293&Qcg]4[laDdyzU_7l)?fgWNHc5QLt)='[Ll4y!@YV`riTeol&7rMC+vAJh(2`uG'-lVnY3!nmMupd^?Wl^BAMmje(EH]pPD6Hr?f'VlgR&KeqM5pfL_Ktg(l*d=J%lrLWGseJ3%dyV9_6Eha8hfVzI.=?_w*3]9wpw2TNA2j!MR(K&gwxF?)-tP6upAq$HWW$l,NNQ=NuS7sGVHdXcx{VnRa{L=1Pkrz@ZLQFDEZrMy!E19.Iikyt+X!56yhKIN5]a=v?Vp@]3L7xry2a86}Bj8ob.J.Q5S_&t2HIY=^8?9$fzxArf&rsr(7L0^QhQ=1n~3!arsg*{W{$2+6=k?e0{PX_4kuT%R1Du]MHm@cB7O_&`J&=M1ZKqWA,H?F_b-2)eg7Fa`OKY}!uB=i@!K&L2MFm-0{sx?,H$AEr7GN4WDem`@)@d?kr*@SfT5Sw$iMJ9dy(aNXGp?4TpGrYWy'Y*Z-iBb!l&AI%Ce0oF6~6*mc!d`Tr296t]ZF~%[sc?S~**v-qd@)ZN)YZJyH?drd_@mQ!EA1NIp...
        Line 1523607: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx]
        Line 1523609: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\OpenWithList]
        Line 1523610: "a"="importOFX.bat"
        Line 1523613: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\OpenWithProgids]
        Line 1523614: "ofx.Document"=hex(0):
        Line 1523616: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\UserChoice]
        Line 1523617: "Progid"="Applications\\importOFX.bat"
        Line 1525131: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\RecentDocs\.ofx]
        Line 1535105: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Classes\Applications\importOFX.bat]
        Line 1535107: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Classes\Applications\importOFX.bat\shell]
        Line 1535109: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Classes\Applications\importOFX.bat\shell\open]
        Line 1535111: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000\Software\Classes\Applications\importOFX.bat\shell\open\command]
        Line 1535112: @="\"C:\\Users\\####################################\\importOFX.bat\" \"%1\""
        Line 1606753: "C:\\Users\\####################################\\importOFX.bat"="importOFX.bat"
        Line 1606753: "C:\\Users\\####################################\\importOFX.bat"="importOFX.bat"
        Line 1607813: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000_Classes\Applications\importOFX.bat]
        Line 1607815: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000_Classes\Applications\importOFX.bat\shell]
        Line 1607817: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000_Classes\Applications\importOFX.bat\shell\open]
        Line 1607819: [HKEY_USERS\S-1-5-21-1259414696-579037011-3851528141-1000_Classes\Applications\importOFX.bat\shell\open\command]
        Line 1607820: @="\"C:\\Users\\####################################\\importOFX.bat\" \"%1\""
        Line 1679461: "C:\\Users\####################################\\importOFX.bat"="importOFX.bat"
        Line 1679461: "C:\\Users\\####################################\\importOFX.bat"="importOFX.bat"

    Thanks,

    Air

    Saturday, April 28, 2012 9:17 PM
  • This is what I get:

    TOTAL:    51 matches in 1 file
    51 matches in C:\Users\#####\Desktop\Entire.reg
        4850  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.ofx]
        4851  @="ofx.Document"
        4852  "Content Type"="text/ofx"
       95298  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Assemblies\C:|Program Files (x86)|Microsoft Small Business|Office Accounting 2009|OFXDriver.dll]
       95299  "OFXDriver,Version=\"4.0.1001.0\",PublicKeyToken=\"31BF3856AD364E35\",Culture=\"neutral\",FileVersion=\"4.0.3610.0\""=hex(7):36,\
       95305  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Assemblies\C:|Program Files (x86)|Microsoft Small Business|Office Accounting 2009|OFXObjects.dll]
       95306  "OFXObjects,Version=\"4.0.1001.0\",PublicKeyToken=\"31BF3856AD364E35\",Culture=\"neutral\",FileVersion=\"4.0.3610.0\""=hex(7):36,\
       96508  "OFXDriver,Version=\"4.0.1001.0\",ProcessorArchitecture=\"x86\",PublicKeyToken=\"31BF3856AD364E35\",Culture=\"neutral\",FileVersion=\"4.0.3610.0\""=hex(7):36,\
      208352  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MIME\Database\Content Type\application/x-ofx]
      208353  "Extension"=".ofx"
      208636  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\MIME\Database\Content Type\text/ofx]
      208637  "Extension"=".ofx"
      214594  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document]
      214598  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\DefaultIcon]
      214601  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell]
      214603  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell\Open]
      214605  [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ofx.Document\Shell\Open\Command]
      215450  @="\"C:\\Program Files (x86)\\Microsoft Small Business\\Office Accounting 2009\\SBA.exe\" /ofx \"%1\""
      544745  "OFXDriver,4.0.1001.0,,31bf3856ad364e35,x86"=hex:d8,5f,74,62,55,dd,cc,01
      667437  "926E70059678BB44DB152AB0D6CCC59C"="C?\\Program Files (x86)\\Microsoft Small Business\\Office Accounting 2009\\OFXObjects.dll"
      667442  "File"="OFXObjects.dll.FC3ED8B1_AA68_4D4D_B203_C2AF1214B6B0"
      683632  "68AB67CA7DA73301B744AA0100000010"="C:\\Program Files (x86)\\Adobe\\Reader 10.0\\Reader\\Acrofx32.dll"
      683637  "File"="Acrofx32.dll"
      696201  "926E70059678BB44DB152AB0D6CCC59C"="<\\OFXDriver,Version=\"4.0.1001.0\",ProcessorArchitecture=\"x86\",PublicKeyToken=\"31BF3856AD364E35\",Culture=\"neutral\",FileVersion=\"4.0.3610.0\""
      696206  "File"="OFXDriver.dll1.FC3ED8B1_AA68_4D4D_B203_C2AF1214B6B0"
      698968  "926E70059678BB44DB152AB0D6CCC59C"="C?\\Program Files (x86)\\Microsoft Small Business\\Office Accounting 2009\\OFXDriver.dll"
      698973  "File"="OFXDriver.dll.FC3ED8B1_AA68_4D4D_B203_C2AF1214B6B0"
      705440  "EnUS"="BjleF,Dji9w^iKpnF@o-V7WXfH]U$?6fW0*]DDWb6&?x-IA5[?r}=H[]AbmyBUTruY.W=?)s)gNav12VT~[,=gbZa@-xn$c7GDO+!}N(O@Va0=H&4~p'tneX.aJ+T,HE7AYpeE'xG9&AH]j2,wF`ZAt?BAIsG^0&a{NN8MG[i8A.7iGI!,~cRQhj^Y?ik@eV!*Sf-OuzUHli)QCkO9L@s%N$(WwYG&+mlsKH}8FcT[vrFVHWFiRr')cw]Ai5oU3j=!iIKlgTka+Oy?yW9Z^*L2&`Z,uaMy`5W=~}!=A^AUNbj9RpJpOi+?Jf8*%l2@-a42_qbw31.=Qf,`[v1vkveRkxE.=Gu?,%R42[[KM42G-A&vb$49B.l34Ug.&FCo.-k?`^1AS0NqiO^.aW6tsPx(0[q?ra86MloTchYKC{OaIFL@GawNG+k%j.*?Dp9Q@4^8d{,+F?Cu$'(Ke*SE{GZ?Ve9!?gk*$&PzUn,%?nJ@*^fv,ZNkI&}K~BEfZeM@oE~21}V%2pyh7@Ks~yu@*1ztdE)}nZ{m}rEIGop?LjqPY=bAB^hpV+zS6%eA&91Fmw7z%+fc,~uDO%l?kz!*L5aA0[ZUVZ6[5vZ?__K*0.)'A2j%gCr5+C=@yQ$~F?Vl0`'BoFx]p+I@Y{rlIC{jf*dGTSo7g[r=$0-)IK$CC+=1t5UDdLT?R%hEwCt6L(N)P_s@y(m@sUWpfF9mjw&7cmU3dqB=~M-9yzGpF!=FIvo6&EZ8=yVP$CWXf?BazaM6Re-90Y24G&UoHIg~H*C[IPu@UuWtixYHMsVe*uru%X8=G%^O!?eM+U&Q)1P-S+d?2aJ^lCz`d0~?YU$G^M^@88(Lu.njziEy(@sG+vG@PqtrQ0cVgam{2`BR51r@&_KDj0T03oSy%,S-r+8=j!BKNJCG1&"
     1030906  "C:\\Program Files (x86)\\Microsoft Small Business\\Office Accounting 2009\\OFXDriver.dll"=dword:00000001
     1030907  "C:\\Program Files (x86)\\Microsoft Small Business\\Office Accounting 2009\\OFXObjects.dll"=dword:00000001
     1143524  "BROFX01A"="SC"
     1143525  "BROFX02A"="SC"
     1143526  "BROFX03A"="SC"
     1741571  "LastKey"="Computer\\HKEY_CLASSES_ROOT\\ofx.Document\\Shell\\Open\\Command"
     1746986  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\ComDlg32\OpenSavePidlMRU\ofx]
     1754981  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx]
     1754983  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\OpenWithList]
     1754987  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\OpenWithProgids]
     1754989  "ofx_auto_file"=hex(0):
     1754990  "ofx.Document"=hex(0):
     1754992  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ofx\UserChoice]
     1754993  "Progid"="ofx.Document"
     1757503  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Microsoft\Windows\CurrentVersion\Explorer\RecentDocs\.ofx]
     1816149  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Classes\ofx_auto_file]
     1816152  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Classes\ofx_auto_file\shell]
     1816154  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Classes\ofx_auto_file\shell\open]
     1816156  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001\Software\Classes\ofx_auto_file\shell\open\command]
     1855816  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001_Classes\ofx_auto_file]
     1855819  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001_Classes\ofx_auto_file\shell]
     1855821  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001_Classes\ofx_auto_file\shell\open]
     1855823  [HKEY_USERS\S-1-5-21-1349014581-1523828388-2147348546-1001_Classes\ofx_auto_file\shell\open\command]


    Ron

    Sunday, April 29, 2012 1:57 AM