So, I've got my .ofx file and am not worried about the download task
anymore. That's the good news.
The bad news is now I'm stuck on the import task.
bean-extract my.import fidelity_1234_july2024.ofx
Results
ERROR:root:Importer
beancount_reds_importers.importers.fidelity.Importer.identify() raised an
unexpected error: not enough values to unpack (expected 2, got 1)
Traceback (most recent call last):
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\beancount\ingest\identify.py"
, line 63, in find_imports
matched = importer.identify(file)
^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\beancount_reds_importers\libreader\reader.py"
, line 26, in identify
self.initialize_reader(file)
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\beancount_reds_importers\libreader\ofxreader.py"
, line 26, in initialize_reader
self.ofx = self.read_file(file)
^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\beancount_reds_importers\libreader\ofxreader.py"
, line 57, in read_file
return ofxparse.OfxParser.parse(fh)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\ofxparse\ofxparse.py"
, line 396, in parse
ofx_file = OfxPreprocessedFile(file_handle)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\ofxparse\ofxparse.py"
, line 155, in __init__
super(OfxPreprocessedFile, self).__init__(fh)
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\ofxparse\ofxparse.py"
, line 82, in __init__
self.read_headers()
File
"C:\Users\joshd\AppData\Local\Programs\Python\Python312\Lib\site-packages\ofxparse\ofxparse.py"
, line 95, in read_headers
header, value = line.split(six.b(":"))
^^^^^^^^^^^^^
ValueError: not enough values to unpack (expected 2, got 1)
;; -*- mode: beancount -*-
If I run ofx-summarize, it throws the same error, so I found a sample .ofx
online and tested ofx-summarize with it.
And of course, the example works, so it looks like Fidelity is providing an
incorrectly formatted file? I noticed it doesn't have a single line break
until the end of the file.
On Monday, September 16, 2024 at 11:01:14 PM UTC-5 Red S wrote:
> Glad you got it working with ofxget. bean-download is just a wrapper
> around ofxget or whatever command you have to parallelize all your
> downloads. If you don’t have several accounts you’re using it with, it’s of
> limited use. The built in template for fidelity is here, and lets you
> store your password securely in pass so it’s not stored in plaintext. You
> could simply paste your working ofxget command into the bean-download
> config file to get it to work if the parallelization is useful for you.
> Either way, that’s the last thing I’d do after I got everything else in the
> import workflow working first.
>
> And oh wow, I’d forgotten that Fidelity stopped
> <https://www.reddit.com/r/fidelityinvestments/comments/17tpgfr/why_doesnt_fidelity_support_ofx_downloads_anymore/>
> letting
> you download ofx via their website, and only let you do it via direct
> download.
>
>
> On Monday, September 16, 2024 at 7:31:34 PM UTC-7 Joshua Cabrera wrote:
>
>> Quick update:
>>
>> Installed ofxget and manage to get my ofxget.cfg updated using ofxget
>> acctinfo. Not sure if this required for bean-download.
>>
>> Also downloaded a .ofx file using:
>> ofxget stmt fidelity > c:\users\joshd\fidelity.ofx
>>
>> Struggling to my download.cfg and bean-download download working - keep
>> getting:
>> 1/1 sites failed: fidelity
>>
>> Will keep trying whenever I have time this week.
>> On Sunday, September 15, 2024 at 9:24:33 PM UTC-5 Red S wrote:
>>
>>> My reason for using .csv over .ofx is simply familiarity and ease of
>>> starting up.
>>>
>>> I have no experience with ofx and thought the learning curve would be
>>> much steeper, and I already feel like I'm drowning a bit as a layperson.
>>>
>>> I know it may seem like that, especially given ofx is not a human
>>> readable format. But might I suggest giving that a shot first, and you
>>> might be pleasantly surprised. Because there is nothing to do, no importer
>>> to write, since it is a machine format with an official spec, unlike csv.
>>> The learning curve should be close to zero. There are other benefits
>>> <https://reds-rants.netlify.app/personal-finance/a-word-about-input-formats-use-ofx-when-you-can/>
>>>
>>> too.
>>>
>>> I'll look into the csvreader changes you mentioned to try making a
>>> replacement for prepare_raw_columns() and also look further into ofx.
>>>
>>> If I were you, I’d definitely spend five minutes with ofx first. And
>>> reds-importers ships with ofx-summarize which you can use to peek
>>> inside and poke around an ofx file, which makes it a lot less opaque and
>>> easy on a layperson.
>>>
>>> Thanks for the help here and confirming I'm doing alright, and also
>>> thank you for maintaining it!
>>>
>>> Happy to, and glad its helpful!
>>>
>>>
>>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/29fcaf7e-3eb1-4b73-8c74-96ee4dd3818dn%40googlegroups.com.
