I didn't either until I thought of running :
File-> Repair Money File-> Quick File Repair

That did it for me ans able to import the ofx normally
YESSSSSSSSSSSSSSSSSSS

JM

"cpa10house" wrote:

- quote -

In microsoft.public.money, jmv wrote:

- quote -

Last post you said you had Money 2005.

Whichever it is, how is your backup file situation?

- quote -

Using "File-> Import..." and then selecting the ofx file I get the followign
error:
The file you attempted to import appears to be invalid or contains corrupt
data. Please download the file again. If this problem continues, contact your
financial institution."

I have Money 2004 ... this used to work though ???? Puzzled!

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, jmv wrote:

- quote -

I created a test file. After establishing CAD as the currency for
the account, I was able to download the OFX file you posted without
error.

I used File-> Import-> DownloadStatement.

I used to be able to download ofx files but for some reason I get a corrupt
message also now. The analyser runs fine.
Why isn't Money 2005 able to import the file?

Follows content of ofx file
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:TYPE1
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX<SIGNONMSGSRSV1<SONRS<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> OK
</STATUS<DTSERVER> 20050621230540[-5:EST]
<LANGUAGE> ENG
</SONRS</SIGNONMSGSRSV1<BANKMSGSRSV1<STMTTRNRS<TRNUID> C001006411009307
<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> OK
</STATUS<STMTRS<CURDEF> CAD
<BANKACCTFROM<BANKID> 900000100
<ACCTID> 006411009307
<ACCTTYPE> CHECKING
</BANKACCTFROM<BANKTRANLIST<DTSTART> 20050301120000[-5:EST]
<DTEND> 20050601120000[-5:EST]
<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050301120000[-5:EST]
<TRNAMT> -2.00
<FITID> 90000010020050301C00137A9A2E3
<NAME> PAIEMENT FACTURE
<MEMO> PAY-FILE FEES
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050301120000[-5:EST]
<TRNAMT> -5.00
<FITID> 90000010020050301C0012775986D
<NAME> FRAIS MENSUELS
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050401120000[-5:EST]
<TRNAMT> -5.00
<FITID> 90000010020050401C001648D8868
<NAME> FRAIS MENSUELS
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050405120000[-5:EST]
<TRNAMT> -5000.00
<FITID> 90000010020050405C0016CBD61C1
<NAME> Paiement
<MEMO> PAIEMENT W3 - 3299
</STMTTRN<STMTTRN<TRNTYPE> CHECK
<DTPOSTED> 20050407120000[-5:EST]
<TRNAMT> -172.54
<FITID> 90000010020050407C001C596E35E
<CHECKNUM> 000002
<NAME> CHEQUE N 002
</STMTTRN<STMTTRN<TRNTYPE> CHECK
<DTPOSTED> 20050408120000[-5:EST]
<TRNAMT> -74.00
<FITID> 90000010020050408C001CA001EAB
<CHECKNUM> 000003
<NAME> CHEQUE N 003
</STMTTRN<STMTTRN<TRNTYPE> ATM
<DTPOSTED> 20050415120000[-5:EST]
<TRNAMT> 8740.37
<FITID> 90000010020050415C0016D945CA7
<NAME> Dépôt
<MEMO> DEPOT LSR MB655858
</STMTTRN<STMTTRN<TRNTYPE> CHECK
<DTPOSTED> 20050427120000[-5:EST]
<TRNAMT> -298.00
<FITID> 90000010020050427C001EE64A166
<CHECKNUM> 000004
<NAME> CHEQUE N 004
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050502120000[-5:EST]
<TRNAMT> -5.00
<FITID> 90000010020050502C001A58B0761
<NAME> FRAIS MENSUELS
</STMTTRN<STMTTRN<TRNTYPE> ATM
<DTPOSTED> 20050504120000[-5:EST]
<TRNAMT> 2208.48
<FITID> 90000010020050504C001ACDA56F5
<NAME> Dépôt
<MEMO> DEPOT LSR MB654196
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050506120000[-5:EST]
<TRNAMT> -5000.00
<FITID> 90000010020050506C00189747C3A
<NAME> Paiement
<MEMO> PAIEMENT W3 - 3838
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050524120000[-5:EST]
<TRNAMT> -5000.00
<FITID> 90000010020050524C0013D8D3043
<NAME> Paiement
<MEMO> PAIEMENT W3 - 2227
</STMTTRN<STMTTRN<TRNTYPE> ATM
<DTPOSTED> 20050531120000[-5:EST]
<TRNAMT> 10424.72
<FITID> 90000010020050531C0014977DDC9
<NAME> Dépôt
<MEMO> DEPOT LSR ME557066
</STMTTRN<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20050601120000[-5:EST]
<TRNAMT> -5.00
<FITID> 90000010020050601C00153703306
<NAME> FRAIS MENSUELS
</STMTTRN</BANKTRANLIST<LEDGERBAL<BALAMT> 34064.62
<DTASOF> 20050620
</LEDGERBAL<AVAILBAL<BALAMT> 34064.62
<DTASOF> 20050620
</AVAILBAL</STMTRS</STMTTRNRS</BANKMSGSRSV1</OFX"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, John Pollard wrote:

- quote -


That would seem to explain things: "NOTE: If you use the wrong
version of the analyzer, or try to use this utility on a computer
that does not have Money installed, you will receive the following
error: ERROR -- Parser Unable To Load"


You might load the Money 2005 trial onto that computer and then try
the analyzer.

Cal Learner-- MVP wrote:
- quote -

Nuts, I was hoping this could be used by anyone to analyze ofx
files. But that explains it; thanks for the help.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

In microsoft.public.money, John Pollard wrote:

- quote -

I should have paid better attention.

- quote -

I had not thought about it, but I suspect that is it.
http://www.microsoft.com/money/fi/forOFXPartners.mspx says
===========================================

OFXAnlyz04.exe - last updated 01/27/04
Use this utility if Money 2004 was the last version installed on
your machine.

OFXAnlyz03.exe - last updated 7/18/02
Use this utility if Money 2003 was the last version installed on
your machine.


NOTE: If you use the wrong version of the analyzer, or try to use
this utility on a computer that does not have Money installed, you
will receive the following error: ERROR -- Parser Unable To Load
================================================== =========

John Pollard wrote:

<snip
- quote -

Actually, looking at my situation with a little more thought; I
should have asked if this tool expects *any* version of money to
be installed. When I ran the test of the import of my ofx file,
I ran in on a different pc than the one where the analyzer is
installed. I have the analyzer installed on a pc with no
version of money installed ... does that matter?

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Cal Learner-- MVP wrote:
- quote -


- quote -

I'm not the op; I don't have Money2005, just 2002. I was just
trying to learn more about the analyzer (and maybe OFX); sorry
if I unintentionally misled you. Does this tool expect a newer
version of Money to be installed before it will work correctly?

- quote -

Yes.

- quote -

< snip
Tried this and it failed just like my file.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

In microsoft.public.money, John Pollard wrote:

- quote -

I think it means that you start counting with the <OFX> line. You
are not getting far enough with the analysis to get an error
associated with a line number however.

- quote -

That is odd. Yet you get an error (what error was that?) when you
File-> Import that same file into Money 2005.

Does your file end with "</OFX> "?

Here is an OFX file that passes OFXAnlyz04.exe. Copy the lines
between the "=============" lines into a file named DIS_SK4.OFX. See
if you can parse it thru OFXAnlyz04.exe successfully. It is a
special purpose OFX file, not one that was downloaded from an FI.

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

<OFX<SIGNONMSGSRSV1<SONRS<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> SUCCESS
</STATUS<DTSERVER> 20040302
<LANGUAGE> ENG
<DTPROFUP> 20030403
<DTACCTUP> 20040201
</SONRS> </SIGNONMSGSRSV1<INVSTMTMSGSRSV1<INVSTMTTRNRS<TRNUID > ZzzzA1
<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> Success so far with stock modification of symbol and CUSIP
</STATUS<INVSTMTRS<DTASOF> 20040221
<CURDEF> USD
<INVACCTFROM<BROKERID> YourBrokerOrZzzzA2
<ACCTID> YourAccountOrZzzzA3
</INVACCTFROM<INVPOSLIST<POSSTOCK<INVPOS<SECID<UNIQU EID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<HELDINACCT> CASH
<POSTYPE> LONG
<UNITS> 1.0000
<UNITPRICE> 42.840
<MKTVAL> 42.840
<DTPRICEASOF> 20041102000000.000[-5:EST]
</INVPOS</POSSTOCK</INVPOSLIST</INVSTMTRS</INVSTMTTRNRS</INVSTMTMSGSRSV1<SECLISTMSGSRSV1<SECLIST<STOCKINFO< SECINFO<SECID<UNIQUEID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> ZzzzA4 Dissassocated stock
<TICKER> GSK
</SECINFO</STOCKINFO</SECLIST</SECLISTMSGSRSV1</OFX============endDIS_SK4.OFX===================== ==========

Cal Learner-- MVP wrote:
- quote -

< snip
- quote -


What does "*** All line number references do not include header
lines ***" mean?

The ofx file in question appears to "import" successfully into
Money2002.


--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Your isp doesn't have to carry this group. Set up msnews.microsoft.com as a
separate account.

<j_pollard[at]mchsi.com> wrote in message
news:1116945774.691764.260230[at]z14g2000cwz.googlegroups.com...
- quote -

In microsoft.public.money, cpa10house wrote:

- quote -

You might be able to just hold the shift key down in IE6 when you
click to download it.

Alternately, you can get a box with a button allowing you to save to
disk rather than feeding the OFX file directly to Money.

Start-> Settings-> ControlPanel-> FolderOptions-> FileTypes

Select OFX-- Open Financial Exchange File .

Click Advanced. Check Confirm Open After Download to get the pop-up
box. Save the file to disk, and then analyze.


- quote -

Yes, I'm downloading from the bank's website.

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, j_pollard[at]mchsi.com wrote:

- quote -

Try removing the line above, and let the following OFXHEADER line be
the first line in the file:

- quote -

- quote -

I did use browse to open the file. And the analyzer was able to "View"
it; and I did too in Wordpad ... looked like an ofx file to me, though
I did not scrutinize it closely.

Here are the contents up to the <BANKID
Content- type:application/ofx
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX<SIGNONMSGSRSV1<SONRS<STATUS<CODE> 0
<SEVERITY> INFO
</STATUS<DTSERVER> 20050523170534
<LANGUAGE> ENG
<DTACCTUP> 20050523170534.000[-5:CDT]
<FI<ORG> Bank of America
<FID> BANK OF AMERICA
</FI</SONRS</SIGNONMSGSRSV1<BANKMSGSRSV1<STMTTRNRS<TRNUID> 0
<STATUS<CODE> 0
<SEVERITY> INFO
</STATUS<STMTRS<CURDEF> USD
<BANKACCTFROM

Thanks.

In microsoft.public.money, j_pollard[at]mchsi.com wrote:

- quote -


It is certainly not normal.

I get that same pop-up message if I choose a file that is not an OFX
file, or even if I enter the filename of a file that does not exist.

I suggest you Browse to the file rather than entering it into the
box.

If that does not solve it, copy and paste the contents of the file
up to, but not including <BANKID> or <ACCTID> (so that we can see
that it looks like a proper OFX file to that point) into a follow-on
post.

If that does not provide sufficient info, you might edit a copy of
the file and overwrite each bit of potentially personal info
,amounts, etc with a "?" character. You would paste that into a
posting.

Cal Learner-- MVP wrote:
- quote -


Sorry for the previous empty post; using Google since my isp doesn't
carry this group and I unintentionally hit the wrong key.

I downloaded the analyzer and tried it on a couple of ofx files; found
the results odd.

I consistently get "File failed parse" (in a message box) then the
underlying app dialog box says:
*** All line number references do not include header lines ***
***OFX 1.02 Add ~10
***OFX 2.0 Add ~2
Running Data Through Parser
ERROR -- Parser Unable To Load

I got this from at least two ofx files downloaded from two different
fi's. Is this normal? Can you help interpret? Does it imply anything
serious?

Cal Learner-- MVP wrote:
- quote -