Awesome, thanks! I hadn't figured out the exact relationship between the zbucket, ztransaction, and zmoneyflow tables.
I used it to create my own script, so I thought I'd share it as well. I found that to make my balances match what's displayed in the UI I had to discount pending transactions and negate flows associated with zbucketout. I also pulled the cash flow start date from the zrollover table and didn't cap the end date. Attached is the script, it just outputs the bucket names and their amounts in tabular format. It can be run with a command similar to: > sqlite3 moneywellfile.moneywell < bucketreport.sql Hopefully this list doesn't strip attachments ... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
bucketreport.sql
Description: Binary data
matt. On Mar 29, 2009, at 1:47 AM, Lance wrote: > > I should clarify that in my queries above, the starting date > (2009-03-31 in my examples) should actually be your cash flow starting > date, not the first date of the month. > > In my case those dates are the same since I started using MoneyFlow > this month, but obviously it will be different for others. > > -Lance > > > --~--~---------~--~----~------------~-------~--~----~ > 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 > -~----------~----~----~----~------~----~------~--~--- >
