[Solved] Can I view a .ofx file in Open Office?

Discuss setup / installation issues - Add a spell checker, Language pack?

[Solved] Can I view a .ofx file in Open Office?

Postby dizzy7 » Tue Aug 26, 2008 6:23 pm

I just downloaded my transaction history from my bank as a .ofx file. I can open it in Open Office, but it's in this format:

<ACCTTYPE>CHECKING
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20080725
<DTEND>20080826
<STMTTRN>
<TRNTYPE>DEBIT

Is there a way for me to view a .ofx format file properly in Open Office?

I hope this isn't too dumb of a question, but I'm new to Open Office and not exactly a computer expert in general. I couldn't find any info about it in the "Help" section, and a search of this forum didn't get any relevant hits.

Thanks for any help.
Last edited by dizzy7 on Fri Sep 05, 2008 5:27 pm, edited 1 time in total.
OOo 2.4.X on Ms Windows XP
dizzy7
 
Posts: 3
Joined: Tue Aug 26, 2008 4:44 pm

Re: Can I view a .ofx file in Open Office?

Postby doofus » Fri Aug 29, 2008 5:43 pm

It looks like what you have there is an xml type file for financial software use, i.e. Quicken/MS Money.
It is created specifically for those types of programs.

You may be able to import it into OOo Calc using XML filtering, but I am not sure as I've never tried.

Hope that helps.
"If you're not having fun, then you are probably doing it wrong, or doing the wrong thing."
OOo 3.0.X on Ubuntu 8.x + windows xp
User avatar
doofus
 
Posts: 13
Joined: Mon Aug 11, 2008 8:20 pm

Re: Can I view a .ofx file in Open Office?

Postby dizzy7 » Fri Aug 29, 2008 9:04 pm

Thanks for the help, doofus. At least now I know that there wasn't some simple and obvious way to view that type of file that I was missing. According to my bank, it is a Microsoft Money file, so that's apparently why I'm unable to view it in the correct format.
OOo 2.4.X on Ms Windows XP
dizzy7
 
Posts: 3
Joined: Tue Aug 26, 2008 4:44 pm

Re: Can I view a .ofx file in Open Office?

Postby Hagar Delest » Sun Aug 31, 2008 8:38 am

If you can download or convert it as a CSV file, you should be able to import it in Calc so that you can use the information inside.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.0.1 on Windows 7 and Xubuntu 14.04 (Trusty Tahr)
User avatar
Hagar Delest
Moderator
 
Posts: 25106
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Can I view a .ofx file in Open Office?

Postby dizzy7 » Fri Sep 05, 2008 5:26 pm

Hagar de l'Est wrote:If you can download or convert it as a CSV file, you should be able to import it in Calc so that you can use the information inside.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

------------------------------------------

Hagar,
My bank does offer the option to download the data in CSV format. I did that, and it opened in Calc with no problem at all. Thanks very much for your help. I never would have thought to try that.
OOo 2.4.X on Ms Windows XP
dizzy7
 
Posts: 3
Joined: Tue Aug 26, 2008 4:44 pm


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: skiphos and 9 guests