|
#11
| |||
| |||
| "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
Opened with Notepad, searched for '&', found none. No characters> 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. before first line. Saved as "account.ofx", format ANSI. Other options are Unicode, Unicode big endian, UTF-8. |
|
#10
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Chris Cowles wrote: - quote - > "Cal Learner-- wrote
Maybe. Check for any '&' characters.> > > 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." |
|
#8
| |||
| |||
| "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
| |||
| |||
| In microsoft.public.money, Chris Cowles wrote: - quote - > > See http://www.microsoft.com/money/fi/tools.mspx
Try browsing to the file rather than typing it in.> *** 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 |
|
#6
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:6vduf3de3blkld1gq11q2vpggsgq0gmac1[at]4ax.com... - quote - *** 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
| |||
| |||
| 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
| |||
| |||
| "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
| |||
| |||
| In microsoft.public.money, Chris Cowles wrote: - quote - > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
It would be as a statement.> 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. 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
| |||
| |||
| "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
| |||
| |||
| 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] > ================================================== ==== |
| | |||
| |||
| In microsoft.public.money, Chris Cowles wrote: - quote - > A financial provider offers downloads only of QFX format files. Money
First, try simply renaming the file to *.ofx and File-> Import or> 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 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
| |||
| |||
| 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 | |
| |