Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Errors and Troubleshooting (Windows)
OL-221-A - Malformed QFX File?
dan_wilks
My bank recently updated it's on-line banking software and now I can't download my web-connect Visa account. Quicken just responds with an OL-221-A error. The connection log pointed me to:
20200412 16:47:09: Not all required fields present. Object: AVAILBAL missing tag: BALAMT
The offending bit of the downloaded qfx file is:
<AVAILBAL>
<BALAMT>
<DTASOF>20200412234009
</AVAILBAL>
Before I go complain to the bank I just wanted to make sure that the OFX spec really doesn't allow the BALAMT to be empty.
Thanks
Find more posts tagged with
Accepted answers
Rocket J Squirrel
Reading through the OFX spec is enough to make you need spectacles. But yes, BALAMT requires an
amount
.
All comments
Rocket J Squirrel
Reading through the OFX spec is enough to make you need spectacles. But yes, BALAMT requires an
amount
.
dan_wilks
I'll try to get the bank to get their provider to throw in the 0.00 for BALAMT that I'm adding in manually before importing.
Note: The OFX 1.0 DTD is slightly ambiguous.
<!ELEMENT AVAILBAL - - (BALAMT , DTASOF)>
<!ELEMENT BALAMT - o %AMTTYPE>
<!ENTITY % AMTTYPE "(#PCDATA)">
I'm pretty sure that PCDATA is allowed to be empty so as long as the BALAMT tag is present it might be legal.
Since AVAILBAL itself is optional I'll suggest that they simply leave it off if they don't want to risk the incorrect 0.00 and can't come up with the correct balance.
<!ELEMENT CCSTMTRS - - (CURDEF , CCACCTFROM , BANKTRANLIST? , LEDGERBAL , AVAILBAL? , MKTGINFO?)>
Thanks,
Dan
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Help
Best Of