Is there a way in bean-query to dump the table of Entries (I'm referring to the code in query_env.py) containing a function called EntriesTable() which seems to be talking about directives and their attributes. I'd love to be able to dump that table after loading my beancount file. I'm feeling rather lost with trying to figure out whether BQ can help me with querying directives -- custom directives in my case.
When I fire up bean-query and it dumps me to a command prompt, if I then type help it comes up with commands that are available but there's nothing mentioned on how to use these commands.. I just get syntax errors when tying to use "describe" for instance. thx! On Saturday, September 28, 2024 at 2:40:50 PM UTC-7 Rick F wrote: > Thanks Martin! I'll keep that suggestion in mind but before I saw your > reply I started playing with the custom directive and was able to get an > example that passes muster with bean-check. The example is below: > > 2013-01-01 open Assets:US:WellsFargo:Checking4431 > institution: "Wells Fargo Bank NA" > address: "123 America Street, LargeTown, USA" > phone: "+1.012.345.6789" > > 2013-01-01 open Income:US:Donations > > ;; fields are as follows : > ;; donor-id : a string defining a unique identifier that can be used > to identify this donor > ;; donor-name : a string containing the name of the donor > ;; donor-address : a string of the address for the donor > ;; donor-city : a string containing the city the donor lives in > ;; donor -state : donor's state > ;; donor-zipcode : donor's zip code > ;; donor-phone : donors phone number > ;; donor-email : email address of donor > 2024-09-28 custom "Donor" "john-smith" "John Smith" "123 First Street" > "Palo Alto" "CA" "93501" "123-456-7890" "[email protected]" > > 2024-09-28 txn "john-smith" > Assets:US:WellsFargo:Checking4431 -100.00 USD > Income:US:Donations > > The big question for me is can bean-query search in the custom directive > fields and so forth -- such that I could potentially run a report against > my file asking for any donations by a specific donor (e.g. "john-smith")? > I did a quick internet search for bean-query and custom but didn't really > find anything. > > Thanks much!! > > On Saturday, September 28, 2024 at 9:39:42 AM UTC-7 Martin Blais wrote: > >> Just use a metadata field with a unique id per client >> and maintain a spreadsheet with all the details, >> just join the two with a script. >> You can extract that metadata using queries or a script. >> >> >> On Thu, Sep 26, 2024 at 5:27 PM Rick F <[email protected]> wrote: >> >>> Hi.. I work at a small non-profit organization and am looking at whether >>> any of the PTA apps out there (ledger, hledger or beancount primarily) can >>> be used to handle our accounting needs or not. One big area that I'm having >>> difficulty with is tracking donations that we receive with (hopefully) full >>> contact info so we can pull reports at year-end of person X's donations are >>> ... blah blah blah (report info). >>> >>> I found someone's prior work associated with Ledger (using lots of tags) >>> for much of what I'm after but still nothing that allows me to track donor >>> information aside from a simple name. >>> >>> After reading through the docs for beancount, I'm hoping that there's a >>> way to use meta-data to help with this perhaps..? >>> >>> I was hoping someone here that knows beancount way better than I do >>> could give me the 50,000ft answer of whether this will be like pushing a >>> boulder up hill or not.. Thanks much! >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Beancount" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/beancount/30808cf2-ce0f-42b3-88a7-b822c51d0cf4n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/beancount/30808cf2-ce0f-42b3-88a7-b822c51d0cf4n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/4a606f8e-dc3f-4b13-b587-bf8a50779fdfn%40googlegroups.com.
