locked
Problem with qfx file*** All line number references do not include header lines *** ***OFX 1.02 Add ~10 ***OFX 2.0 Add ~2 Running Data Through Parser ERROR -- File not found, File empty, Out of Memory, or Unknown Parse Failure RRS feed

  • Question

  • My wife's 403(b)  broker stopped producing ofx files but does provide qfx files.  But the files they produce seem to have some problem with Money.  I tried everything (registry fix; manually associating qfx file types with msmoney.exe and then with msimprt.exe; changing the filetype to ofx; Importing...Downloaded statement)  Each time money recognizes that it is trying to bring in a statement but it always fails.  Here's a typical error message from an import attempt: 

    C:\Users\xxxx\Desktop\transactions.qfx cannot be imported.  Please confirm that you have the correct file or select another file to import"  I've tried Microsoft's OFX analyzer but that too fails with the messages:

    I have also run the file through Microsoft's OFX Analyzer, but that too fails with the following message:

    *** All line number references do not include header lines ***
    ***OFX 1.02 Add ~10
    ***OFX 2.0 Add ~2
    Running Data Through Parser
    ERROR -- File not found, File empty, Out of Memory, or Unknown Parse Failure

    So obviously something is wrong with the file.  We've made several attempts to download the files, some with other date periods but they all fail the same way.

    Here is the text of a typical file of a 3 month period with several buy transactions of the same fund.  I think I have replaced all identifying data with asterisks.  If anything jumps out please let me know.  But no need to spend much time on it, as manual entry is not that much of an effort:

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

    <OFX>
    <SIGNONMSGSRSV1>
    <SONRS>
    <STATUS>
    <CODE>0</CODE>
    <SEVERITY>INFO</SEVERITY>
    </STATUS>
    <DTSERVER>20130421</DTSERVER>
    <LANGUAGE>ENG</LANGUAGE>
    <FI>
    <ORG>******************************</ORG>
    <FID>101</FID>
    </FI>
    <INTU.BID>10766</INTU.BID>
    </SONRS>
    </SIGNONMSGSRSV1>

    <INVSTMTMSGSRSV1>
    <INVSTMTTRNRS>
    <TRNUID>0</TRNUID>
    <STATUS>
    <CODE>0</CODE>
    <SEVERITY>INFO</SEVERITY>
    </STATUS>
    <INVSTMTRS>
    <DTASOF>20120331</DTASOF>
    <CURDEF>USD</CURDEF>
    <INVACCTFROM>
    <BROKERID>***********</BROKERID>
    <ACCTID>********  *****/****</ACCTID>
    </INVACCTFROM>
    <INVTRANLIST>
    <DTSTART>20120101</DTSTART>
    <DTEND>20120331</DTEND>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-01-2420020120124503939142953494666500063867941136665000</FITID>
    <DTTRADE>20120124</DTTRADE>
    <DTSETTLE>20120124</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>*********</UNITS>
    <UNITPRICE>*********</UNITPRICE>
    <TOTAL>****</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-01-3120020120131501817142953494666500063867941136665000</FITID>
    <DTTRADE>20120131</DTTRADE>
    <DTSETTLE>20120131</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>*******</UNITS>
    <UNITPRICE>*******</UNITPRICE>
    <TOTAL>********</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-02-1620020120216501566142953494666500063867941136665000</FITID>
    <DTTRADE>20120216</DTTRADE>
    <DTSETTLE>20120216</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>*********</UNITS>
    <UNITPRICE>***********</UNITPRICE>
    <TOTAL>**********</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-02-2320020120223504875142953494666500063867941136665000</FITID>
    <DTTRADE>20120223</DTTRADE>
    <DTSETTLE>20120223</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>*******</UNITS>
    <UNITPRICE>********</UNITPRICE>
    <TOTAL>******</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-03-0920020120309517896142953494666500063867941136665000</FITID>
    <DTTRADE>20120309</DTTRADE>
    <DTSETTLE>20120309</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>*********</UNITS>
    <UNITPRICE>********</UNITPRICE>
    <TOTAL>*******</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    <BUYOTHER>
    <INVBUY>
    <INVTRAN>
    <FITID>2012-03-2220020120321502968142953494666500063867941136665000</FITID>
    <DTTRADE>20120322</DTTRADE>
    <DTSETTLE>20120322</DTSETTLE>
    </INVTRAN>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <UNITS>********</UNITS>
    <UNITPRICE>********</UNITPRICE>
    <TOTAL>********</TOTAL>
    <SUBACCTSEC>CASH</SUBACCTSEC>
    <SUBACCTFUND>CASH</SUBACCTFUND>
    </INVBUY>
    </BUYOTHER>
    </INVTRANLIST>
    <INVPOSLIST>
    <POSOTHER>
    <INVPOS>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <HELDINACCT>CASH</HELDINACCT>
    <POSTYPE>LONG</POSTYPE>
    <UNITS>
                        ***********
                </UNITS>
    <UNITPRICE>
                        **********
                </UNITPRICE>
    <MKTVAL>**********</MKTVAL>
    <DTPRICEASOF>20120331</DTPRICEASOF>
    </INVPOS>
    </POSOTHER>
    </INVPOSLIST>
    <INV401K>
    <EMPLOYERNAME>***********************</EMPLOYERNAME>
    <PLANID>****************</PLANID>
    </INV401K>
    <INV401KBAL>
    <TOTAL>**********</TOTAL>
    </INV401KBAL>
    </INVSTMTRS>
    </INVSTMTTRNRS>
    </INVSTMTMSGSRSV1>
    <SECLISTMSGSRSV1>
    <SECLIST>
    <MFINFO>
    <SECINFO>
    <SECID>
    <UNIQUEID>1429534946665000</UNIQUEID>
    <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
    </SECID>
    <SECNAME>************</SECNAME>
    <FIID>KEY4</FIID>
    </SECINFO>
    </MFINFO>
    </SECLIST>
    </SECLISTMSGSRSV1>
    </OFX>

    Tuesday, April 23, 2013 6:19 PM

Answers

  • Changing the header to change ": " to ":" 9 places changed the error message to something else. Maybe if you do that in the un-scrubbed file, you will find that it tests as OK.
    • Marked as answer by bobjbkln Tuesday, April 23, 2013 8:11 PM
    Tuesday, April 23, 2013 7:42 PM
    Moderator

All replies

  • Changing the header to change ": " to ":" 9 places changed the error message to something else. Maybe if you do that in the un-scrubbed file, you will find that it tests as OK.
    • Marked as answer by bobjbkln Tuesday, April 23, 2013 8:11 PM
    Tuesday, April 23, 2013 7:42 PM
    Moderator
  • Perfect.  Sorry I wasted all the bandwidth since I only needed the first nine lines to get my question answered.  (Also I screwed up the title of this thread with an ill placed Copy and Paste.  It should just have been: qfx import problem

    • Edited by bobjbkln Tuesday, April 23, 2013 8:17 PM
    Tuesday, April 23, 2013 8:13 PM