Cannot import transaction file from bank since I upgrated to money

Hello,
I live in Brazil. I have upgraded my money 2003 to 2007 and I can no longer
import my bank transaction files. I get a message saying that "The file you
attempted to import appears to be invalid or contains corrupted data..."
Can someone help?

Thank you,
--
Rodrigo

Cal
Sun Jan 13 18:36:25 CST 2008

In microsoft.public.money, Rodrigo wrote:

>Hello,
>I live in Brazil. I have upgraded my money 2003 to 2007 and I can no longer
>import my bank transaction files. I get a message saying that "The file you
>attempted to import appears to be invalid or contains corrupted data..."
>Can someone help?
>
>Thank you,

What kind of bank transaction files are they? If you don't know,
what does the first line look like?

Try going to Tools->Settings->OnlineServiceSetting
and select ShowStandardizedPayeeNamesForWhichANameIsNotFound.

Rodrigo
Mon Jan 14 06:31:02 CST 2008

Hi There,

they are OFX Files. I used to be able to import them using Money 2003, after
I upgraded to 2007 it no longer worked. There is one other problem that I am
not sure if it is related, but I can not change my accounts from Advanced to
Essential. it doesn't give an error message, it just doesn't do it.

Yes, I did change the online setting to
ShowStandardizedPayeeNamesForWhichANameIsNotFound, but it did not work
either. The box had already been checked.

I have uninstalled 2007 and installed the 2003 version again and it worked.
But I upgraded to 2007 and it stopped working, again.

I have my Brazilian and American bank accounts being into MS Money. I can
connect to American Express and other banking institutions and automatically
download the transactions, but if I download the OFX or QIF file and try to
import it, it doesn't work either; I get the same message.

I have also tried to install MS Money 2007, without doing an upgrade, and
setup the account from scratch too, and still it did not work.

Let me know if there is anything else I could do. Thank you for helping out.


--
Rodrigo


"Cal Learner-- MVP" wrote:

> In microsoft.public.money, Rodrigo wrote:
>
> >Hello,
> >I live in Brazil. I have upgraded my money 2003 to 2007 and I can no longer
> >import my bank transaction files. I get a message saying that "The file you
> >attempted to import appears to be invalid or contains corrupted data..."
> >Can someone help?
> >
> >Thank you,
>
> What kind of bank transaction files are they? If you don't know,
> what does the first line look like?
>
> Try going to Tools->Settings->OnlineServiceSetting
> and select ShowStandardizedPayeeNamesForWhichANameIsNotFound.
>
>

Cal
Mon Jan 14 11:09:17 CST 2008

In microsoft.public.money, Rodrigo wrote:

>Hi There,
>
>they are OFX Files. I used to be able to import them using Money 2003, after
>I upgraded to 2007 it no longer worked. There is one other problem that I am
>not sure if it is related, but I can not change my accounts from Advanced to
>Essential. it doesn't give an error message, it just doesn't do it.

I think that is normal. See help item "Switch between the Essential
and Advanced Account Registers" by entering "Essential" into the
search box and selecting the appropriate item.

See below.

>
>Yes, I did change the online setting to
>ShowStandardizedPayeeNamesForWhichANameIsNotFound, but it did not work
>either. The box had already been checked.
>
>I have uninstalled 2007 and installed the 2003 version again and it worked.
>But I upgraded to 2007 and it stopped working, again.
>
>I have my Brazilian and American bank accounts being into MS Money. I can
>connect to American Express and other banking institutions and automatically
>download the transactions, but if I download the OFX or QIF file and try to
>import it, it doesn't work either; I get the same message.
>
>I have also tried to install MS Money 2007, without doing an upgrade, and
>setup the account from scratch too, and still it did not work.
>
>Let me know if there is anything else I could do. Thank you for helping out.


When you File->Import an OFX file into Money 2003, it works. When
you File->Import an OFX file into Money 2007, you get this error:
"The file you attempted to import appears to be invalid or contains
corrupted data..."

I don't know what would cause that. If the file was an OFC file,
then I could understand that. Make sure the file has the string
"OFX" within the first 80 characters.

Rodrigo
Mon Jan 14 14:49:03 CST 2008

> I think that is normal. See help item "Switch between the Essential
> and Advanced Account Registers" by entering "Essential" into the
> search box and selecting the appropriate item.

I've tried that, it didn't work either. I thought that it could have
something to do with the problem with the import of the OFX file.

> When you File->Import an OFX file into Money 2003, it works. When
> you File->Import an OFX file into Money 2007, you get this error:
> "The file you attempted to import appears to be invalid or contains
> corrupted data..."
>
> I don't know what would cause that. If the file was an OFC file,
> then I could understand that. Make sure the file has the string
> "OFX" within the first 80 characters.

I don't know what else to do. I've been entering all transactions by hand,
very frustrating. Could there be a problem with the currency I am using? I
think MS Money 2003 dealt a little differently with the currency and date
(used to be it MM/DD/YYYY now it's DD/MM/YYYY) than MS Money 2007.

Another question:
Is there a way to import an excel file into money? or to convert an excel
file into OFX file (I would downgrade it back to 2003)?
--
Rodrigo


"Cal Learner-- MVP" wrote:

> In microsoft.public.money, Rodrigo wrote:
>
> >Hi There,
> >
> >they are OFX Files. I used to be able to import them using Money 2003, after
> >I upgraded to 2007 it no longer worked. There is one other problem that I am
> >not sure if it is related, but I can not change my accounts from Advanced to
> >Essential. it doesn't give an error message, it just doesn't do it.
>
> I think that is normal. See help item "Switch between the Essential
> and Advanced Account Registers" by entering "Essential" into the
> search box and selecting the appropriate item.
>
> See below.
>
> >
> >Yes, I did change the online setting to
> >ShowStandardizedPayeeNamesForWhichANameIsNotFound, but it did not work
> >either. The box had already been checked.
> >
> >I have uninstalled 2007 and installed the 2003 version again and it worked.
> >But I upgraded to 2007 and it stopped working, again.
> >
> >I have my Brazilian and American bank accounts being into MS Money. I can
> >connect to American Express and other banking institutions and automatically
> >download the transactions, but if I download the OFX or QIF file and try to
> >import it, it doesn't work either; I get the same message.
> >
> >I have also tried to install MS Money 2007, without doing an upgrade, and
> >setup the account from scratch too, and still it did not work.
> >
> >Let me know if there is anything else I could do. Thank you for helping out.
>
>
> When you File->Import an OFX file into Money 2003, it works. When
> you File->Import an OFX file into Money 2007, you get this error:
> "The file you attempted to import appears to be invalid or contains
> corrupted data..."
>
> I don't know what would cause that. If the file was an OFC file,
> then I could understand that. Make sure the file has the string
> "OFX" within the first 80 characters.
>
>
>
>

Cal
Mon Jan 14 15:00:23 CST 2008

In microsoft.public.money, Rodrigo wrote:

>> I think that is normal. See help item "Switch between the Essential
>> and Advanced Account Registers" by entering "Essential" into the
>> search box and selecting the appropriate item.
>
>I've tried that, it didn't work either. I thought that it could have
>something to do with the problem with the import of the OFX file.
>
>> When you File->Import an OFX file into Money 2003, it works. When
>> you File->Import an OFX file into Money 2007, you get this error:
>> "The file you attempted to import appears to be invalid or contains
>> corrupted data..."
>>
>> I don't know what would cause that. If the file was an OFC file,
>> then I could understand that. Make sure the file has the string
>> "OFX" within the first 80 characters.
>
>I don't know what else to do. I've been entering all transactions by hand,
>very frustrating. Could there be a problem with the currency I am using? I
>think MS Money 2003 dealt a little differently with the currency and date
>(used to be it MM/DD/YYYY now it's DD/MM/YYYY) than MS Money 2007.

That should not matter for OFX, but would matter with QIF. Within
OFX it is always yyyyMMdd.....

I still suggest posting maybe the first 80 characters or first two
lines of your file to make sure of what you have.


Money takes its date format info from the OS, and by changing
regional settings, you can change those.


>
>Another question:
>Is there a way to import an excel file into money? or to convert an excel
>file into OFX file (I would downgrade it back to 2003)?

See
http://xl2qif.chez-alice.fr/links_en.php

Rodrigo
Mon Jan 14 15:15:02 CST 2008

From Amex.

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<MESSAGE>Login
successful</STATUS><DTSERVER>20080114135027.792[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX

here is one form a brazilian bank; a little different format.

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>20080105100000[-03:EST]
<LANGUAGE>POR
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>1001
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<STMTRS>
<CURDEF>BRL

I cannot import either one.

thank you,
--
Rodrigo


"Cal Learner-- MVP" wrote:

> In microsoft.public.money, Rodrigo wrote:
>
> >> I think that is normal. See help item "Switch between the Essential
> >> and Advanced Account Registers" by entering "Essential" into the
> >> search box and selecting the appropriate item.
> >
> >I've tried that, it didn't work either. I thought that it could have
> >something to do with the problem with the import of the OFX file.
> >
> >> When you File->Import an OFX file into Money 2003, it works. When
> >> you File->Import an OFX file into Money 2007, you get this error:
> >> "The file you attempted to import appears to be invalid or contains
> >> corrupted data..."
> >>
> >> I don't know what would cause that. If the file was an OFC file,
> >> then I could understand that. Make sure the file has the string
> >> "OFX" within the first 80 characters.
> >
> >I don't know what else to do. I've been entering all transactions by hand,
> >very frustrating. Could there be a problem with the currency I am using? I
> >think MS Money 2003 dealt a little differently with the currency and date
> >(used to be it MM/DD/YYYY now it's DD/MM/YYYY) than MS Money 2007.
>
> That should not matter for OFX, but would matter with QIF. Within
> OFX it is always yyyyMMdd.....
>
> I still suggest posting maybe the first 80 characters or first two
> lines of your file to make sure of what you have.
>
>
> Money takes its date format info from the OS, and by changing
> regional settings, you can change those.
>
>
> >
> >Another question:
> >Is there a way to import an excel file into money? or to convert an excel
> >file into OFX file (I would downgrade it back to 2003)?
>
> See
> http://xl2qif.chez-alice.fr/links_en.php
>
>

Cal
Mon Jan 14 16:23:15 CST 2008

In microsoft.public.money, Rodrigo wrote:

Clearly they are OFX. :-)

I would check http://support.microsoft.com/kb/829143 for things not
tried yet.

I would also try File->Import to a new file without first creating
an account to receive the file.


>From Amex.
>
>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<MESSAGE>Login
>successful</STATUS><DTSERVER>20080114135027.792[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX
>
>here is one form a brazilian bank; a little different format.
>
>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>20080105100000[-03:EST]
><LANGUAGE>POR
></SONRS>
></SIGNONMSGSRSV1>
><BANKMSGSRSV1>
><STMTTRNRS>
><TRNUID>1001
><STATUS>
><CODE>0
><SEVERITY>INFO
></STATUS>
><STMTRS>
><CURDEF>BRL
>
>I cannot import either one.
>
>thank you,

Rodrigo
Tue Jan 15 10:20:04 CST 2008

Hi Cal,

At the Regional and Language Option, I changed the language to English, it
was Portuguese, and it worked. Also, one of the OFX files had several spaces
between the Tag and the Amount (<TRNAMT> -16.25), deleted the spaces and it
worked too.

Now, if I could just figure out how to convert a HTM file into a OFX or Qif
file I will be set.

Thank you very much for all the help


"Cal Learner-- MVP" wrote:

> In microsoft.public.money, Rodrigo wrote:
>
> Clearly they are OFX. :-)
>
> I would check http://support.microsoft.com/kb/829143 for things not
> tried yet.
>
> I would also try File->Import to a new file without first creating
> an account to receive the file.
>
>
> >From Amex.
> >
> >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<MESSAGE>Login
> >successful</STATUS><DTSERVER>20080114135027.792[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX
> >
> >here is one form a brazilian bank; a little different format.
> >
> >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>20080105100000[-03:EST]
> ><LANGUAGE>POR
> ></SONRS>
> ></SIGNONMSGSRSV1>
> ><BANKMSGSRSV1>
> ><STMTTRNRS>
> ><TRNUID>1001
> ><STATUS>
> ><CODE>0
> ><SEVERITY>INFO
> ></STATUS>
> ><STMTRS>
> ><CURDEF>BRL
> >
> >I cannot import either one.
> >
> >thank you,
>
>

Cal
Tue Jan 15 10:51:37 CST 2008

In microsoft.public.money, Rodrigo wrote:

>
>At the Regional and Language Option, I changed the language to English, it
>was Portuguese, and it worked. Also, one of the OFX files had several spaces
>between the Tag and the Amount (<TRNAMT> -16.25), deleted the spaces and it
>worked too.
>
Impressive!

I had thought about the language, but I didn't think that would be
it. I did not know the whitespace would matter.

>Now, if I could just figure out how to convert a HTM file into a OFX or Qif
>file I will be set.

That can be done, but if the format of the HTML changes a little, it
would probably break it. Perl might be a good language for that.