Wells Fargo Bank imports into MS Money Sunet

[Jana]

My Wells Fargo Bank Imports will not work with Import into MS Money Sunset.  They are qfx files and I have changed the file name to ofx, AND associated qfx files with MS Money, following all the guidelines I can find here. This hasn't helped.

However, someone said in a previous post that WELLS FARGO needed a line inserted. I took that to mean I had to edit the Sites.template. I pulled up the information for Wells Fargo from the OFX home directory and copied the Wells Fargo info into sites.template. I cannot get the Setup.py to open, but I am not use direct import, just import downloaded file. So I don't think I need Setup.py.

This did not work. Still same error message. I am ready to change banks over this.  

Could somone maybe walk me through how to fix this? And Is money sunset exe suppose to be in same folder as the Python script to work?   I have used this program for imports every since MS stopped making new versions. But over many computers, I am not sure I have everything set up correctly and I have backups and duplicates.  

I just need my Wells Fargo Credit Card data to go into MS Money.

Thanks for any help. BTW, I have researched all the files I could here in last hour, and not understanding what it is I need to do to make this work. 

[Patrick Sewell]

I use ProperConvert now as it works well with qfx files from WF.

However, I used to edit the header of the qfx file manually and then save it as an ofx.  Money would import these without issue.

Here is the unmodified header of the WF qfx file...

Here is the modified header...

Save the modified file as an ofx.  Money will accept this ofx file.

[First Name Last Name]

A work-around

Use the attached python script to re-format the download file
The python script takes two arguments: input (download file), output (re-format file)

python fixWellsFargo.py  -i Checking1.qfx -o out.qfx

Then import the re-format file. In above example, you want to import file out.qfx

You can get a copy from https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/misc/fixWellsFargo.py

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/d0280ef0-0476-4b43-a649-6c1ccc074ac1n%40googlegroups.com.

[Jana]

Thanks for the solutions!

I was  able to change the header and get the file to import in my MS Money. So super helpful.  

As far as downloading the python script, I did download it, and extracted the files into a folder. But then I am not sure how to proceed from there. I do not know how to make the script work to reformat the file. 

I do not know what to do with this:

python fixWellsFargo.py  -i Checking1.qfx -o out.qfx

Please explain in more detail.  I am a complete novice on scripts and how they even work.

Thanks so much to both of you!

[Cal Learner]

I am not following the whole thing, but will comment on this:

python fixWellsFargo.py  -i Checking1.qfx -o out.qfx

Instead of that, I would do python fixWellsFargo.py  -i Checking1.qfx -o out.ofx since Money automatically is associated with *.ofx during install, and you have to do something different if you want *.qfx to also associate with Microsoft Money.

If you really don't understand, note that the -i parameter is the Input file, and the -o parameter is the modified output file. You can "run" the output file to have Money process it.

[Jana]

Cal, 

Thanks for your help. I tried copying the text below into RUN, but it didn't work, so I am doing something wrong.

My steps were:

I clicked on the downloaded py file  and it flashed on the screen. I assume it installed?

I put the Wells Fargo qfx file into it's own folder for clarity and copied the path. 

Next I typed the text below into the run box (replacing the -i with the path I copied, as well as a new file name for -o with same location) and hit enter. It flashes on screen, but nothing happens. I do not get a reformatted import file and nothing to import comes up in MS Money.

What am I doing wrong? 

python fixWellsFargo.py C:\Users\ME\OneDrive\Documents\_Python Scripts\CreditCard1 (6).qfx  Checking1.qfx C:\Users\ME\OneDrive\Documents\_Python Scripts\WFCC1 out.ofx

[Dan Adkins]

remove the checking1.qfx

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/d8fe5b47-ed72-4f50-9685-11bff0a8afdfn%40googlegroups.com.

[First Name Last Name]

Jana,

I've made a quick fix to make it easier for you to use. New version is attached.

Save it somewhere. From File Explorer, you will see an icon like this

 

Download Wells Fargo QFX file. For example, I put a copy into the same folder.

Now just drag-and-drop file 'Checking1 (37).qfx' on top of 'fixWellsFargo.py', you should then see a generated file named 'Checking1 (37)-fixed.ofx'

If you so choose, you can just double-click on file 'Checking1 (37)-fixed.ofx' to import.

New version is also available at: https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/misc/fixWellsFargo.py

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/d8fe5b47-ed72-4f50-9685-11bff0a8afdfn%40googlegroups.com.

[Jana]

hleofx,

That works perfectly!  Thank you so much for the directions, pictures and the PY file.  That will make things so much easier. I appreciate everyone who answered to help. Thank you.

[potatoe dave]

I doesn't seem to work with drop and drop. Am I missing something?

On Friday, September 22, 2023 at 5:02:55 PM UTC-4 hleofx...@gmail.com wrote:

[S P]

I discovered the following over the holidays:

If I download the qfx file from Wells Fargo website with the hleofxquotes program and MS Money both running, the transactions in the qfx file are automatically imported into Money.  Running the fixWellsFargo Python script does not seem to be required with this workflow - and the behavior in Money after import is the same as when you download or import an OFX file.

You do have to run the Python script to fix the qfx and convert to OFX (you can do both in the same run by passing in the appropriate parameters on the command line) if hleofxquotes is not running.

So it appears hleofxquotes is taking care of both the fix to the downloaded qfx file and conversion to OFX. 

hleofxquotes (or anyone else who uses or is familiar with the hleofxquotes program):  It would be great if you can confirm the above is a feature of the program and if any settings need to be configured for the above to work (if there are, they are probably set by default - I dont remember setting any options specifically for this).

If anyone else tries the above, it would be great to hear if it works for you.

[Jana]

Last year hleofx made a python fix script for me I copied onto my computer and dropped my downloaded Wells Fargo file on top of.  Then I was able to import that into Money. This isn't working for me any longer.  I haven't tried it in some months, but now trying to catch up on my Money transactions and it isn't working.  Is there a new file for a Wells Fargo Fix? Guessing something has changed.
 

On Friday, September 22, 2023 at 5:02:55 PM UTC-4 hleofx...@gmail.com wrote:

[S P]

I havent seen any updates from Cal Learner or hleofxquotes regarding the Wells Fargo fix script - I am sure someone will chime in if there is one. 

Could you elaborate on the behavior you are expecting - and actually seeing - when you drop the file on the script?

Note - When I was using the script, I used to invoke it in a MS Windows command prompt.  

Also, it has been quite a while since I have have had to run that script.  I now download the qfx file from Wells Fargo with the hleofxquotes program and MS Money running - the qfx file is automatically imported into Money without any other preprocessing (as I reported in my previous post in this thread).  If you can't get the script to work - I would suggest trying this approach.

[M B II]

I'm not sure if it's the same issue, but WF CC downloads have a mistake with the header.  I think it is and issue with the end of line character.   I use a bat file and a header text file to grab my WellsFargo.qfx download, delete the current header, merge the header from the txt file and create a new WellsFargo.qfx file.

The only requirement is that all of the files must be in the same folder before running the batch file.  1) downloaded qfx that is named WellsFargo.qfx.   2) The bat file.     3) the txt file, names WellsFargoHeader.txt

:::::::::::::::Content of bat file:::::::::::::::

powershell -Command "(gc WellsFargo.qfx) -replace 'OFXHEADER:100DATA:OFXSGMLVERSION:102SECURITY:NONEENCODING:USASCIICHARSET:1252COMPRESSION:NONEOLDFILEUID:NONENEWFILEUID:NONE<OFX>', ' ' | Set-Content WFfixed.txt"
powershell -Command "Get-Content WellsFargoHeader.txt, WFfixed.txt | Set-Content WFmerged.txt"

del WellsFargo.qfx
del WFfixed.txt
ren "WFmerged.txt" "WellsFargo.qfx"

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:::::::::::::Contents of WellsFargoHeader.txt::::::::::::::::::

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
:::::::::::::::::::::::::::::::::::::::::::::::