by rkm » Sat Oct 11, 2008 5:24 pm
The export file has over 9000 data rows. MSMoney exports in order of the "Num" column, so all of these entries are grouped together at the bottom:
Cashpoint,2005-07-28,Cash,R,xxxxxxxxxx,,Property : Improvements - Ford Road,-450.0000
Cashpoint,2005-07-28,Cash,R,xxxxxxxxxx,,Property : Improvements - Ford Road,-450.0000
Cashpoint,2005-08-01,Cash,R,xxxxxxxxxx,,Cash Withdrawal,-50.0000
Cashpoint,2005-08-02,Cash,R,xxxxxxxxxx,,Property : Improvements - Ford Road,-450.0000
Cashpoint,2005-08-02,Cash,R,xxxxxxxxxx,,Property : Improvements - Ford Road,-450.0000
Desired outcome is that all entries are imported, what happens is that the red rows are omitted.
I'm not convinced about the transfers justification for dupe checking - MSMoney account transfers look like this:
,2002-04-05,A Bank Plc,R,xxxxxxxxxx,,Transfer To : yyyyyyyyyy,-84.0000
,2002-04-05,B Bank Plc,R,yyyyyyyyyy,,Transfer From : xxxxxxxxxx,84.0000
I don't know what QIF data looks like and maybe the import logic you have is governed by that (I know of at least two Mac money programs I checked out failed my "evaluation" because they couldn't handle transfers), but the fact that you have a specialization for MSMoney already suggests otherwise. In addition, you put the "Transfer To/From" category text in the Payee field in My Money so I'm puzzled where dupe checking even has to enter the picture.
Anyway, it is how it is. How do we move it forward? (I only have 34 days of my trial period left)