Mac Quicken 2007 importing a qif file

Quicken Personal Finance Discussions - Quicken - personal finance software discussions 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Mac Quicken 2007 importing a qif file John 11-01-2008  Re: Mac Quicken 2007 importing a qif file John Pollard 11-01-2008  Re: Mac Quicken 2007 importing a qif file John Pollard 11-01-2008  Re: Mac Quicken 2007 importing a qif file John 11-01-2008  Re: Mac Quicken 2007 importing a qif file John Pollard 11-01-2008  Re: Mac Quicken 2007 importing a qif file John 11-01-2008
Posted by John on November 1, 2008, 10:45 pm Please log in for more thread options John wrote: > I'd like to start importing a qif file to a > Cash account (still allowed). I looked at the > format, cooked up the file below, but when I > import it I am able to select it, click on > "Open" and a progress bar opens for a millisecond > and goes away, and that's it. I look in the Cash > account file, nothing has been added. Nor anywhere > else as far as I can tell. I suspect I don't have > the format down yet. Anyone see what I'm doing wrong? > > [I modeled it after a sample qif export I made, and > definitions I found on the web. I did notice that > the export only used ^M line delimiters and not > <CR><LF> as my text editor uses, but I don't think > this is the problem]. > > Thanks! > > !Account > NCash Account > D > X > ^ > !Type:Cash > D10/12/08 > PFoodtown > MMemo 1 goes here > T-1.00 > A > A > A > A > A > A > LGroceries > ^ > D10/12/08 > PPayee 2 > MGasoline > T-2.00 > A > A > A > A > A > A > LAuto:Fuel > ^ > D10/12/08 > PNY Times, WSJ, tea > MMemo 3 goes here > T-3.00 > A > A > A > A > A > A > LWAWA > ^ Thanks to John Pollard for answering. I've now solved the problem. 1. I did a qif export for transactions on a selected date. 2. I verified (after deleting those in the Cash Account) that they imported just fine. 3. I examined the line feed difference. I was wrong, it is not evident in emacs, but is evident with a Unix "more". 4. I created a file verbatim to the file that worked, but with regular <CR><LF> line delimeters. 5. It still imported just fine!!! 6. I pared down this file and found that the syntax below imports just fine. (Took out the empty A lines, etc., step by step, testing at each step). 7. The difference I see is that line 5 below (TCash) was omitted in the test above. Anyway, I now have it working, with a normally created line separated file, and the two digit year dates work in Mac Quicken 2007. 8. Now I can program what I want. 9. Thanks again! !Account NCash Account D X TCash ^ !Type:Cash D10/12/08 PFoodtown MMemo 1 goes here T-1.00 LGroceries ^ D10/12/08 PGasoline MMemo 2 goes here T-2.00 LAuto:Fuel ^ D10/12/08 PNY Times, WSJ, tea MMemo 3 goes here T-3.00 LWAWA ^ Similar Threads Posted Quicken 2007 - Importing QIF files February 22, 2008, 11:54 am Importing QIF Files in Quicken 2005, 2006, 2007 January 25, 2007, 6:42 pm Importing Web Connect File January 1, 2009, 4:02 pm Missing Transactions after Importing QIF file to Cash Account August 2, 2006, 8:51 pm Importing QIF into 2007 Premier September 3, 2006, 12:32 pm Quicken 2007 & UK data file September 24, 2006, 3:41 pm Quicken 2007 - Out of memory when doing update = corrupted data file September 30, 2006, 11:12 pm Restore Quicken 4 file to Quicken H & B 2007? October 17, 2009, 10:50 am XG 2007 default file location March 25, 2007, 7:01 pm Converting 2007 file to 2008 October 5, 2007, 8:00 pm