Thanks, Kevin- Aliasing will work for my Bill Pay transactions (the ones that repeat), but not for POS transaction (Point of Sale) where I use my ATM card. Those have equally cryptic messages, and may not repeat over time, so I would need to manually edit each one. Also my ATM withdrawals work the same way. As far as I can tell, aliasing cannot deal with such scenarios. -Dave
On Feb 24, 5:41 am, Kevin Hoctor <[email protected]> wrote: > 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 LLChttp://nothirst.comhttp://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 -~----------~----~----~----~------~----~------~--~---
