| View unanswered posts | View active topics |
It is currently Sun May 19, 2013 11:50 am |
|
All times are UTC |
 
|
Page 1 of 1 |
[ 6 posts ] |
| Print view | E-mail friend | Previous topic | Next topic |
bbmmex
| Author | Message |
|---|---|
|
BBAdult  Joined: Sat Sep 20, 2008 9:13 pm Posts: 29 Location: Србија 
|
  bbmmexIf you use Money Manager Ex or RQ Money,
or anything that keeps data in (unencrypted) SQLite database, this plugin could be useful to you. Out of the box, it shows summary about currencies from Money Manager Ex, hence the name. It can be also used to show custom messages and toolbar label messages. History: ======== 14-Feb-2012 - bbmmex 0.06 ------------------------- - Added: For each query in the rc settings, you can now specify path to the database if you don't want to use the default database for that query. - Added: @bbmmex.PreviousQuery bro@m (this is now default action on ctrl+middle click) - Added: @bbmmex.ShowMenu bro@m (this is now default action on right and ctrl+right clicks) - Added: Right click, ctrl+right click, and ctrl+middle click mouse actions - Added: Another useful Money Manager Ex query to the sample rc file - Added: RQ Money (http://www.rq.sk/) query example to the sample rc file - Fixed: SQL result was refreshed unnecessarily after showing the custom/toolbar messages 29-Jan-2012 - bbmmex 0.05 ------------------------- - Added: Support for multiple queries - Added: Another useful Money Manager Ex query to the sample rc file - Default query setting is now bbmmex.Query.1 in rc file, so check out provided sample - Other queries can be selected via @bbmmex.QueryNumber bro@m (if you combine this with @bbmmex.DBpath bro@am in a script, you can use bbmmex to easily run queries on multiple sqlite databases) - Added support for cycling through provided queries with @bbmmex.NextQuery bro@m (this is now default action on middle click) - Added support for showing custom messages via @bbmmex.ShowMessage bro@m - Added support for showing toolbar label messages (can be set via menu or via @bbmmex.ShowToolbarLabelMessages bro@m) - Message duration can be set via menu or via @bbmmex.MessageTimeout bro@m 24-Jan-2012 - bbmmex 0.04 ------------------------- - Added CenterText option - Added View Readme option in menu (if Readme.txt is available) - Added support for custom OnClick, OnMiddleClick and OnDoubleClick actions - Added ClickToRefresh option if you (don't) want to refresh result in addition to custom OnClick action - Rearranged configuration menu - Error messages are drawn to the plugin window now (they were shown in message box) - Added support for custom row delimiter - Renamed column delimiter setting and bro@m from "Delimiter" to "ColumnDelimiter" - Added support for \t, \r, \n, \" and \\ in delimiter settings Attachments:
Last edited by bro on Tue Feb 14, 2012 2:12 am, edited 8 times in total. |
| Fri Jan 20, 2012 11:25 pm |
|
|
|
|
Sponsored Links  |
|
|
|
|
Site Admin  Joined: Tue Jan 25, 2005 1:13 am Posts: 741
|
Re: bbmmex Any new plugin is welcome! Thank you for your effort, bro!
 |
| Sat Jan 21, 2012 7:59 am |
|
|
|
|
BBAdult Joined: Sat Sep 20, 2008 9:13 pm Posts: 29 Location: Србија
|
Re: bbmmex Updated...
|
| Sun Jan 29, 2012 9:17 am |
|
|
|
|
BBAdult  Joined: Wed Apr 25, 2007 2:37 pm Posts: 23 Location: Houston, Texas USA
|
Re: bbmmex This is great!
Anyone who contributes to Blackbox is a superstar! _________________ Cheers, The Kingsmob |
| Fri Feb 03, 2012 3:17 pm |
|
|
|
|
BBAdult Joined: Sat Sep 20, 2008 9:13 pm Posts: 29 Location: Србија
|
Re: bbmmex Here is the query for those using RQ Money instead of Money Manager Ex:
Summary about currencies: Code: SELECT Currency || ':' as Currency, SUM(Amount) as Amount FROM ( SELECT u_code as Currency, a_startsum as Amount FROM currencies JOIN accounts on (u_code=a_currency) UNION ALL SELECT u_code as Currency, case when c_kind IN ("+", "p") then d_sum else -d_sum end as Amount FROM data JOIN categories ON (d_category = c_id), accounts ON (d_account = a_id), currencies ON (u_code=a_currency) ) GROUP BY Currency To use it with bbmmex, put this one long line into your bbmmex.rc: Code: bbmmex.Query.1: SELECT Currency || ':' as Currency, SUM(Amount) as Amount FROM (SELECT u_code as Currency, a_startsum as Amount FROM currencies JOIN accounts on (u_code=a_currency) UNION ALL SELECT u_code as Currency, case when c_kind IN ("+", "p") then d_sum else -d_sum end as Amount FROM data JOIN categories ON (d_category = c_id), accounts ON (d_account = a_id), currencies ON (u_code=a_currency)) GROUP BY Currency; |
| Tue Feb 07, 2012 12:12 pm |
|
|
|
|
BBAdult Joined: Sat Sep 20, 2008 9:13 pm Posts: 29 Location: Србија
|
Re: bbmmex Updated...
|
| Tue Feb 14, 2012 2:28 am |
|
|
|
|
Sponsored Links |
|
|
|
|
|
Page 1 of 1 |
[ 6 posts ] |
|
All times are UTC |
Who is online |
Users browsing this forum: No registered users and 0 guests |
| You cannot post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum |