F2O - Cal, you're a certifiable genius!

[Ken H]

I messed around trying to get ActiveState Python 2.7 so I'd have everything the same as you and others.  I had run into a similar issue with my python.org version implementing Jon Larssens' BoAMFP (which handles all my non-brokerage accounts).  I finally gave up and ran pip to install dateutil.  First time I executed F2O.py it ran perfectly.  Since I don't have a copy of the Fidelity position and history CSV files from 1/22, I was amazed that it produced OFX files using the F2O_DBgather.csv I created from the 1/22 OFX files and then Money updated perfectly.

I can't thank you enough for all your efforts, both for the group and for me personally.  Your DB_gather.py and F2O_beta12 are working perfectly with options. 

[Ken H]

I MEANT CERTIFIED GENIUS!!

[Dharmendra]

I have python 2.7.18 installed on Windows 10 laptop. I am using default user/documents directory. Have successfully come to the state when I am trying to run F2O.bat and its giving me error 

F2O.py line 19 in <module> from dateutil.parser. 

>py -m pip install python-dateutil

says requirement already satisfied :six=1.5 in \\\\\python\pythoncore-3.14-64

>python --version 

Python 2.7.18

What I am doing wrong? 

Thanks for your help.

[Cal Learner]

See https://microsoftmoneyoffline.wordpress.com/2024/02/03/cals-fidelity-specific-csv-to-ofx-converter/ and note the link for  Active State Python 2.7.18

I think that will already have the  dateutil installed. I don't know why your pip did not do it. Was that python from python.org?

[Cal Learner]

I am wondering if py launches python3.

If you do py --version , what do you get?

[Dharmendra]

Downloaded and installed Activate State Python 2.7.18 from the link. 

Have generated F2O_DB.csv that shows all the holdings correctly

I have account_histort.csv and portfolio_positions csv in the doanload folder

ran F2O.py and get following

F2O Fidelity-specific CSV 2 OFX converter  Dated 2026/2/7 beta13A
Fidelity csv 2 Ofx converter
Traceback (most recent call last):
  File "\Documents\F2O\F2O.py", line 827, in <module>
    ofx1b[this_account_index]+=mk_bank("OTHER") #" Actually Money ignores <TRNTYPE> tag value.
  File "\Documents\F2O\F2O.py", line 489, in mk_bank
    ofx1b_local+="<NAME>"+get_name_nos()+"\n<MEMO>"+get_memo_auto()+"\n"
TypeError: cannot concatenate 'str' and 'NoneType' objects

(removed folder user folder path)

Thanks

--
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 visit https://groups.google.com/d/msgid/microsoft-money/87f412ca-294d-4606-8d84-0e4397d7ba48n%40googlegroups.com.

[Cal Learner]

Could you try the F2O.py from beta13F.zip?

I will also put F2O401k1E.py up, not in a zip for now, which is a candidate for replacing the F2O.py in  beta13F.zip

[Dharmendra]

I got the F2O.py from beta13F and ran it without making any other change. 

I manually scrubbed the history file for FDRXX, SPAXX, QUSCQ 

It ran successfully and created ofx files in the F2O folder. I imported the simplest one for the cash management account and it went through without any problem. I will test the others later tomorrow.

Side note, I have not made any changes to F2O_cfg or F2O.py. 

Thank you for your help. 

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/9cce147d-0fe8-43e0-ab35-b7d9fc4c0c5an%40googlegroups.com.

[Cal Learner]

F2O.py can be good to have. 

The beta13E defaults to IGNORE_BEFORE_YYYYMMDD="20230128, which is good if you don't already have downloads into Money. 

If you had succesful downloads until about mid January, you would want to put something like

IGNORE_BEFORE_YYYYMMDD="20260114 into your F2O.py. 

Else you will get duplicates.

New duplicates should not happen. That is just an initial thing to set up.

In Money, your undo is to restore a backup. I set Money Sunset to keep about 20 backups.

[Dharmendra]

All generated ofx import worked very well. 

Thank you

On 2/14/2026 6:35 PM, Cal Learner wrote:

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/9cce147d-0fe8-43e0-ab35-b7d9fc4c0c5an%40googlegroups.com.