As I noted before, I figured out how to get a clean export from Quicken 2002 that imports into Cashbox. I only exported 2007 data, nothing earlier. Of course, the next thing I noticed was that I didn't have a balance forward from 2006, so the totals were wrong. So I entered the balance forward amounts manually only to discover the frustration: the 12/31/2006 entry sorted to the most recent position, after all of the 2007 entries. Yarg, well I'm tough, so I went to the raw data (the plist files in ~/Library/Application\ Support/Cashbox/Accounts/) and started editing. First I moved the 2006 entry to the top from the bottom. No dice. Then I paid attention to the 2007 entries imported from Quicken ... the year field of the date was 0007 instead of 2007! Since I wanted to change as few entries by hand as possible, I changed 12/31/2006 to 12/31/0006 in the plist files, and now everything looks right in Cashbox. (I suspect Quicken 2002 used YY instead of YYYY, so this is probably more of a Quicken feature than a Cashbox bug.)
No comments:
Post a Comment