New extension: 'Accounts Categories Mega Search Window'
Enhances the internal MD menu Tools>Accounts and Tools>Categories popup windows. It combines both accounts and categories in one list and provides a quick search capability. The new window only activates if you call it from the Extensions menu and once you close it, it's gone (unless you request it again).
Download here:
https://github.com/yogi1967/MoneydancePythonScripts/raw/master/acco...
Do have a play and let me know any feedback?
Mr Toolbox
My Site: https://yogi1967.github.io/MoneydancePythonScripts/
accounts_categories_mega_search_window
Showing page 2 out of 2. View the first page
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
31 Posted by Stuart Beesley ... on 30 Mar, 2023 03:50 PM
It should still be there?
32 Posted by RJron on 30 Mar, 2023 04:25 PM
On Moneydance ? Cannot find it there.
Can find on your site - is build 1005 dated 17 Nov 2022 the latest ? Seems like a long time - cos I thought it was updated later.
https://yogi1967.github.io/MoneydancePythonScripts/ :
33 Posted by RJron on 30 Mar, 2023 04:30 PM
just updated my note above. apologies...
34 Posted by Stuart Beesley ... on 30 Mar, 2023 04:42 PM
Ah yes, that one is never on the internal MD menu list of extensions..
Under the heading PREVIEW is latest preview unsigned.
Under the heading "Signed Versions (hosted on this site" is the latest signed version
35 Posted by RJron on 30 Mar, 2023 06:29 PM
So.. The latest is not there ?
The 'preview' version - please advise version and date ? <<=====
The 'signed on this site' version is 1005 dated 17-Nov-2022.
If the preview version is must later and has a lot more changes/features ( now that I can rely on these ) I would not mind installing :-) in the hope that it would be signed soon.
36 Posted by Stuart Beesley ... on 30 Mar, 2023 06:36 PM
The latest signed - 1005 17th Nov 2022 is there.. That's the latest in terms of functional changes.. There is a later preview which holds no new features that you can use....
37 Posted by RJron on 30 Mar, 2023 06:49 PM
Thanks - installed and working !
Looking forward to more improvements and updates...
38 Posted by RJron on 04 May, 2023 06:59 AM
Hi Stuart,
The inability to type and find ( I often call it 'drill down search' ) is getting more and more annoying each day. As such, I have to ask again - especially in relation to the Mega Search.
I realise Mega Search uses Moneydances in house screen/codes/whatever to help create or edit accounts. However, I would REEEEEEALLY appreciate if you could do something to help the DEFAULT CATEGORY and PARENT ACCOUNT selection options in the add/edit screens. Are you able to somehow magically incorporate that drill down search there as well ? Or even if Mega Search can have its own form that will eventually pass it on to Moneydance to create/edit the account ?
Am repeatedly having to go through 100s of categories and accounts and stuff line-by-line using a mouse to find something so simple.. is just getting the best of me.
If it is not possible - ok. But I just had to ask... thanks for listening..
39 Posted by Stuart Beesley ... on 04 May, 2023 06:08 PM
You're in luck. Easy...
Grab PREVIEW build 1010 from my site:
https://yogi1967.github.io/MoneydancePythonScripts/
In the search filter box enter codes:
{pa:} for parent account search {dc:} for default category search Replace the * with your search
e.g. {pa:bob's account} or {dc:tax category}
you can use both together for AND.
anything outside the {}s will still search as before and again you can AND.
Let me know how it goes?
40 Posted by RJron on 04 May, 2023 07:12 PM
Hey there Stuart.. thanks a bunch. I am away.. and wasnt expecting a
favourable reply ( even if I desperately wanted one ) but I am happy chappy
that you actually did it.
I will get cracking on this as asap.. and will surely provide feedback..
its the least I can do.
Thanks again...
41 Posted by Stuart Beesley ... on 04 May, 2023 08:57 PM
If it works well, then I can easily incorporate more search options if they are useful.
42 Posted by RJron on 05 May, 2023 07:52 AM
Hi Stuart,
Apologies - perhaps I got this wrong or may be I was not clear. I could not understand where to put those codes. But just to be clear - here is what I'm trying to achieve:
Example of creating a new bank account:
OPTION-1 (default moneydance): Menu->Accounts->NewAccount->Bank
OPTION-2 (MegaSearch): Menu->Extensions->Accounts&CategoriesMega...-> NEW -> Bank
See screenshot with items highlighted in RED.
We have to make a selection for these two items - but there is no search functionality here. You have to use your mouse and go through an extensive list of items. What I am hoping is to have some sort of type-search/drill-down functionality here. (This is also a problem is numerous other places in moneydance)
The same goes for other options to open/edit.
Possible ?
----------------------------------------------
PS. The MegaSearch main search field works exceptionally well already I think ( even without these codes). If you remember, we(YOU) created the EXPAND ALL (button) and COLLAPSE ALL ( minus sign button). Search currently finds only items that are expanded and visible. But once expanded/visible, search would pretty much find anything ( although I would like to think that better UI for it would be to:
- Start with a default collapsed view ( unless user requests full expanded view by pressing the exand-all-button )
- Type-search/Drill-down and find item ( even in fully collapsed view ). Search would locate its finds - auto-expand all its higher branches all the way to its root - while all other non-relevant roots & branches remain fully collapsed.
)
43 Posted by Stuart Beesley ... on 05 May, 2023 08:26 AM
In the mega window, search field, bottom row, just type
{dc:text} This will search all accounts and filter/include when it’s default account name = text
44 Posted by RJron on 05 May, 2023 09:28 AM
ok. I'm not catching this well.
I tried as you mentioned - results are:
typing {pa:} in the search field:
-- lists the parent accounts and also lists all categories. Adding any further text indeed finds the particular account. But this already works without the {pa:} entry ? Selecting an account and clicking NEW does not automatically populate the form with this account.
{dc:} does not work the same as {pa:}. This actually removes all categories from the list and only displays accounts. Also, adding further text does not result in displaying the categories. This needs correction. But then, it works without the {dc:} entry field as well.
Great idea about combining them using an AND or TO operand. That makes sense. I suppose you were planning on the ability to find, select/highlight both parent account and default category - then click NEW and it would throw the form with the parent account and default category already populated ? Is that what you had in mind ? I guess that will work for creating an account - but not for editing...
The most ideal wouild perhaps be to somehow inject a search field into the form itself - if that is possible. If this is possible - then this can be replicated in several other areas as well i guess ( eg. on the dashboard, Reports ( in the forms themselves - but also to find a report )...
45 Posted by Stuart Beesley ... on 05 May, 2023 11:17 AM
I don't understand..
I have an account called FRED that has a 'default category' of xxx
In the filter box I type
{dc:xxx} it lists the account called FRED.
Is this not what you wanted? To show accounts (e.g. FRED) with a default category of xxx
?
46 Posted by Stuart Beesley ... on 05 May, 2023 11:20 AM
Ah - as for {pa:*}, then I assume you are searching for parent accounts with a name that also exists in categories?
e.g.
Account
Fred
sub: John
Cat
Fred
sub: fuel
{pa:FRED} will return both cat and acct's which are both parents called FRED?
NOTE: categories ARE ALSO accounts...
Is this what's happening?
If so, I can adjust, but depends on requirements...?
47 Posted by Stuart Beesley ... on 05 May, 2023 11:21 AM
.... and you already know that I cannot do this....
"The most ideal wouild perhaps be to somehow inject a search field into the form itself - if that is possible. If this is possible - then this can be replicated in several other areas as well i guess ( eg. on the dashboard, Reports ( in the forms themselves - but also to find a report )..."
48 Posted by RJron on 05 May, 2023 11:37 AM
Hi Stuart. Yes - I am aware you cannot do this.. but I just put that there
- so you know what I am aiming for. The method does not matter as long as
we get the same result.
Perhaps this is just too daunting - but allow me to try to explain again:
I often create new accounts ( mainly bank accounts from a moneydance
perspective). I do this regularly - so becoming daunting to repeatedly find
the PA (parent account) and also DC ( Default category ) to be used in this
form.
So, I would like to use mega search to create the bank account. Can I use
your methods {pa:} AND {dc:} in the mega search field to find both items (
yes - they are separate items ). And then select both items and click NEW
and (somehow) both PA and DC get added to the new account form ?
Your example of fred and xxx - is fine. But you are finding something that
is already created. I am trying the opposite - I need to create the account.
PS. If it helps, is there somehow I can send you info direct ?
49 Posted by Stuart Beesley ... on 05 May, 2023 07:25 PM
My email is
…
50 Posted by Stuart Beesley ... on 05 May, 2023 07:29 PM
Ok. I get what you want, but I really can’t see how it’s quicker.
You want to type pa and dc search strings for these to appear, so you can select two, so that you can create a new account with these two preset.
How is that quicker than using the normal create account and then searching and selecting the pa and dc manually?
51 Posted by Stuart Beesley ... on 06 May, 2023 09:29 AM
Thoughts on my comments?
52 Posted by RJron on 06 May, 2023 12:40 PM
Hi Stuart. Apologies.. i am driving most of yesterday and today.. so taking
time to respond.
Well.. its just easier.. a lot LOT easier.. especially when I often create
new accounts. Eg. I place/break/renew deposits and the like which are all
created as bank accounts in a heirarchy based on family member -> banks ->
account type -> currency -> account list.
Perhaps this might seem more like a 'want' than a 'need' to many.. . Which
is why i also keep circling back to the type-search/drill-down feature
missing in MD..