Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 10-02-2007, 01:28 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

"Michael Gordon" <gordonm[at]denison.edu> wrote in message
news:e00o%233HBIHA.4444[at]TK2MSFTNGP03.phx.gbl...
- quote -

> Also, make sure the file is saved as ASCII, not UTF-16, and that
> there are no characters before the first line (OFXHEADER).
> --
> Michael Gordon
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:fec0g31h8h7no6khm6uv994o7r1o7mgp2k[at]4ax.com...
> > In microsoft.public.money, Chris Cowles wrote:
> > > > "Cal Learner-- wrote
> > > > > > > Try browsing to the file rather than typing it in.
> > > > > > > That's what I did. The error message was a result of having scanned
> > > the file. I think the key phrase is "... or unknown parse."
> > > Maybe. Check for any '&' characters.


Opened with Notepad, searched for '&', found none. No characters
before first line. Saved as "account.ofx", format ANSI. Other options
are Unicode, Unicode big endian, UTF-8.


  #10  
Old 10-01-2007, 10:54 PM
Michael Gordon
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

Also, make sure the file is saved as ASCII, not UTF-16, and that there are
no characters before the first line (OFXHEADER).
--
Michael Gordon


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:fec0g31h8h7no6khm6uv994o7r1o7mgp2k[at]4ax.com...
- quote -

> In microsoft.public.money, Chris Cowles wrote:
> > "Cal Learner-- wrote
> > > > > Try browsing to the file rather than typing it in.
> > > > That's what I did. The error message was a result of having scanned

> > the file. I think the key phrase is "... or unknown parse."

> Maybe. Check for any '&' characters.



  #9  
Old 09-30-2007, 11:33 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

In microsoft.public.money, Chris Cowles wrote:

- quote -

> "Cal Learner-- wrote
> > > Try browsing to the file rather than typing it in.

> That's what I did. The error message was a result of having scanned
> the file. I think the key phrase is "... or unknown parse."


Maybe. Check for any '&' characters.
  #8  
Old 09-30-2007, 10:56 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:mtvvf3dt27btquh99beuml3ff46s6qcbqe[at]4ax.com...
- quote -

> Try browsing to the file rather than typing it in.


That's what I did. The error message was a result of having scanned
the file. I think the key phrase is "... or unknown parse."

I'll try importing into a new file, but the one I'm importing into is
pretty new. It has only 3 accounts and a total of 4 transactions.

I'll also try reading the OFX file to figure out if I can truncate it
somewhere after one transaction. If that works, I'll do some soft of
binary exclusion on the contents; if it doesn't work, I haven't proved
anything more than I don't know where to truncate it properly.


  #7  
Old 09-30-2007, 07:58 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

In microsoft.public.money, Chris Cowles wrote:

- quote -

> > See http://www.microsoft.com/money/fi/tools.mspx
> *** 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


Try browsing to the file rather than typing it in.
  #6  
Old 09-30-2007, 05:10 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:6vduf3de3blkld1gq11q2vpggsgq0gmac1[at]4ax.com...
- quote -

> Oops... I meant OFXAnalyzer.exe
> See http://www.microsoft.com/money/fi/tools.mspx



*** 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


  #5  
Old 09-30-2007, 05:47 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

In microsoft.public.money, Chris Cowles wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:tbbuf3d5obca7s4v8mn3f8eohmhn8lbo9v[at]4ax.com...
> > > I would try testing the file with OFXAnalyze.exe.

> Available where?



Oops... I meant OFXAnalyzer.exe

See http://www.microsoft.com/money/fi/tools.mspx
  #4  
Old 09-30-2007, 05:19 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:tbbuf3d5obca7s4v8mn3f8eohmhn8lbo9v[at]4ax.com...
- quote -

> I would try testing the file with OFXAnalyze.exe.


Available where?


  #3  
Old 09-30-2007, 05:04 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

In microsoft.public.money, Chris Cowles wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:2bgrf3lrpvj3savb7jj09sqd19roq9a94c[at]4ax.com...
> > > First, try simply renaming the file to *.ofx and File-> Import or

> > double-clicking the file in WE. If that does not work, remove these
> > lines:
> > ====================================
> > <FI> > <ORG> LPL
> > <FID> 11372
> > </FI> > <INTU.BID> 11372
> > <INTU.USERID> [9999999999-revised for obscurity]
> > ================================================== ====

> I tried both approaches and attempted to import as both downloaded
> statement and recovered account. Nothing worked. The consistent result
> is:
> <filename> "cannot be imported. Please confirm that you have the
> correct file, or select another file to import."
> Not sure where to go, now.


It would be as a statement.

I would try testing the file with OFXAnalyze.exe.

You could also try importing the file, as a test, to a new empty
test file.
  #2  
Old 09-29-2007, 10:59 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:2bgrf3lrpvj3savb7jj09sqd19roq9a94c[at]4ax.com...
- quote -

> First, try simply renaming the file to *.ofx and File-> Import or
> double-clicking the file in WE. If that does not work, remove these
> lines:
> ====================================
> <FI> <ORG> LPL
> <FID> 11372
> </FI> <INTU.BID> 11372
> <INTU.USERID> [9999999999-revised for obscurity]
> ================================================== ====



I tried both approaches and attempted to import as both downloaded
statement and recovered account. Nothing worked. The consistent result
is:

<filename> "cannot be imported. Please confirm that you have the
correct file, or select another file to import."

Not sure where to go, now.


  #1  
Old 09-29-2007, 01:59 PM
Art McClinton
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

I agree with Cal. All I have done with TIAA-CREF which uses QFX files is a
save as and change the extension during the save to OFX and then open it
when file download completes. This then imports directly into Money.

Art

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:2bgrf3lrpvj3savb7jj09sqd19roq9a94c[at]4ax.com...
- quote -

> In microsoft.public.money, Chris Cowles wrote:
> > A financial provider offers downloads only of QFX format files. Money
> > doesn't recognize them. I imported the .reg file from money.mvps.org
> > but that didn't fix it, so I posted the first few lines of the file.
> > Perhaps someone can recognize a problem? The rest of the data has
> > account-specific information, so I don't want to post it as is. If
> > need be, I'll edit it to replace the personal stuff and post that.
> > > Thanks in advance.
> > > > 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> 20070928182935
> > <LANGUAGE> ENG
> > <FI> > <ORG> LPL
> > <FID> 11372
> > </FI> > <INTU.BID> 11372
> > <INTU.USERID> [9999999999-revised for obscurity]
> > </SONRS> > </SIGNONMSGSRSV1> > <INVSTMTMSGSRSV1> > <INVSTMTTRNRS> > <TRNUID> 0
> > <STATUS> > <CODE> 0
> > <SEVERITY> INFO
> > </STATUS> > <INVSTMTRS> > <DTASOF> 20070928182935
> > <CURDEF> USD
> > <INVACCTFROM> > <BROKERID> LPL.COM
> > <ACCTID> > First, try simply renaming the file to *.ofx and File-> Import or

> double-clicking the file in WE. If that does not work, remove these
> lines:
> ====================================
> <FI> <ORG> LPL
> <FID> 11372
> </FI> <INTU.BID> 11372
> <INTU.USERID> [9999999999-revised for obscurity]
> ================================================== ====



 
Old 09-29-2007, 03:09 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: QFX to OFX conversion

In microsoft.public.money, Chris Cowles wrote:

- quote -

> A financial provider offers downloads only of QFX format files. Money
> doesn't recognize them. I imported the .reg file from money.mvps.org
> but that didn't fix it, so I posted the first few lines of the file.
> Perhaps someone can recognize a problem? The rest of the data has
> account-specific information, so I don't want to post it as is. If
> need be, I'll edit it to replace the personal stuff and post that.
> Thanks in advance.
> 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> 20070928182935
> <LANGUAGE> ENG
> <FI> <ORG> LPL
> <FID> 11372
> </FI> <INTU.BID> 11372
> <INTU.USERID> [9999999999-revised for obscurity]
> </SONRS> </SIGNONMSGSRSV1> <INVSTMTMSGSRSV1> <INVSTMTTRNRS> <TRNUID> 0
> <STATUS> <CODE> 0
> <SEVERITY> INFO
> </STATUS> <INVSTMTRS> <DTASOF> 20070928182935
> <CURDEF> USD
> <INVACCTFROM> <BROKERID> LPL.COM
> <ACCTID


First, try simply renaming the file to *.ofx and File-> Import or
double-clicking the file in WE. If that does not work, remove these
lines:
====================================
<FI<ORG> LPL
<FID> 11372
</FI<INTU.BID> 11372
<INTU.USERID> [9999999999-revised for obscurity]
================================================== ====
  #-1  
Old 09-29-2007, 01:40 AM
Chris Cowles
Guest
 
Posts: n/a
Default QFX to OFX conversion

A financial provider offers downloads only of QFX format files. Money
doesn't recognize them. I imported the .reg file from money.mvps.org
but that didn't fix it, so I posted the first few lines of the file.
Perhaps someone can recognize a problem? The rest of the data has
account-specific information, so I don't want to post it as is. If
need be, I'll edit it to replace the personal stuff and post that.

Thanks in advance.


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> 20070928182935
<LANGUAGE> ENG
<FI<ORG> LPL
<FID> 11372
</FI<INTU.BID> 11372
<INTU.USERID> [9999999999-revised for obscurity]
</SONRS</SIGNONMSGSRSV1<INVSTMTMSGSRSV1<INVSTMTTRNRS<TRNUID > 0
<STATUS<CODE> 0
<SEVERITY> INFO
</STATUS<INVSTMTRS<DTASOF> 20070928182935
<CURDEF> USD
<INVACCTFROM<BROKERID> LPL.COM
<ACCTID

 

Tags
conversion, ofx, qfx
Similar Threads
Thread Forum Replies Last Post
Conversion ?
James McNulty: How do you convert Quicken 2005 Files to Money 2005 ?
Microsoft Money 1 07-18-2005 01:49 PM
Conversion ?
James McNulty: How do you convert Quicken 2005 Files to Money 2005 ?
Microsoft Money 3 06-04-2005 04:53 AM
conversion ?
James McNulty: How do you convert Quicken 2005 Files to Money 2005 ?
Microsoft Money 2 06-03-2005 06:52 PM
Conversion
Maurizio: Hi, i've money 2000 italian version and i want buy Money 2004 (only english). When i open file have problem, how can convert file? Thank's Raf
Microsoft Money 1 10-14-2004 12:44 PM
Conversion
Michael Mummert: I have been using Microsoft Money 2001 and my computer died. It was bundled software and the way compaq does it I can not access the program to...
Microsoft Money 3 11-11-2003 07:05 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 12:57 AM.