On Feb 24, 2009, at 12:07 AM, Dave Hirsch wrote: > (I did search the archives for posts similar to this one; I hope this > isn't retreading old ground.) > > I just got Moneywell - it looks great! One thing that I wish it had > is the ability to rewrite imported transactions as they are added. > For electronic payment transactions, my bank sends payee fields that > look like this: > > "BILL PAY(907219 ORCC WW Feb 17" > "BILL PAY(089772 ORCC WW Feb 16" > "BILL PAY(019500 ORCC WW Feb 14" > > Needless to say, this is frustrating. However, the (larger) memo > fields get more useful info: > > "BILL PAY(907219 ORCC WW Feb 17 @ 12:06pm)(Comcast)" > Hi Dave,
MoneyWell already has this ability and you don't need a script. If you create a memorized transaction with an alias of "Comcast" then it will find that in the payee or memo and clean up the transactions as they are imported. Please avoid changing the database directly. > What to do? Well, I opened the Moneywell datafile in a text editor > and found it was a sqlite3 database file, which I can munge with the > command line, since I have sqlite3 installed. I can also wrap these > commands into an applescript. Now I can drag my Moneywell file onto > this applescript (saved as an application), and all my cryptic payees > are magically fixed! > > Below, I've provided this for others wanting to do something similar. > It would need to be modified to work with your particular brand of > munged data, or things you wish to alter. I hope this helps others > > -Dave > > WARNING: THIS COULD DAMAGE YOUR FILE. DON'T DO THIS UNLESS YOU KNOW > WHAT YOU ARE DOING! TEST IT THOROUGHLY ON A COPY FIRST! Peace, Kevin Hoctor [email protected] No Thirst Software LLC http://nothirst.com http://kevinhoctor.blogspot.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "No Thirst Software User Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/no-thirst-software?hl=en -~----------~----~----~----~------~----~------~--~---
