Hi Geoff, I had tested hard-coded dates in the saved reports as well, none of them work. I'm running GC 4.11 on Archlinux.
If piecash works, I"ll just go to that. I currently have other reports (also transaction reports) working this way fine, but I have to scrape the html file with BeautifulSoup to complete my summaries. If I can just directly get the data without those steps it will be better all around. I may still try to generate some logs to see why it's not playing nice. Thanks, Bill On Wed, Sep 21, 2022 at 8:06 AM Geoff <cleanoutmys...@gmail.com> wrote: > Hmmm > > I've just tested a saved report (Transaction Report) and it worked OK: > > "C:\Program Files (x86)\gnucash\bin\gnucash-cli" -R run --name "Saved > Report" --output-file "C:\Temp\SR.html" mybudget.gnucash > > I tested both hard coded specific dates, and the same relative dates as > you (Previous Quarter -> Today) - both worked OK. I am running GnuCash > v4.8 on Windows 10. > > What next? > > You could experiment with the debug settings (see the --help for > gnucash-cli) but unfortunately I lack the knowledge to tell you which > modules to debug. This worked (but told me nothing meaningful):- > > "C:\Program Files (x86)\gnucash\bin\gnucash-cli" -R run --name "Saved > Report" --output-file "C:\Temp\SR.html" --log gnc.backend.file.sx=debug > --logto "C:\Temp\SF.txt" budget2021.gnucash > > Whereas "--log gnc=debug" generated a 100MB log file before I terminated > the process. > > > This is a long shot, but you could try saving the report with hard coded > dates to see if that makes any difference. > > > Regards > > Geoff > ===== > > On 21/09/2022 9:39 pm, William Starrs wrote: > > That's exactly what I was doing, hence this thread! My report name > > should not be an issue as the -R show option finds the report and lists > > the criteria without issue. > > > > What is happening here is that a saved report runs without issue in the > > GUI and errors out in the CLI. If it's a bug I'd like to help fix it, > > just need to know where to look. > > > > > > > > On Wed, Sep 21, 2022 at 7:25 AM Geoff <cleanoutmys...@gmail.com > > <mailto:cleanoutmys...@gmail.com>> wrote: > > > > Well, in that case it should work out of the box like this: > > > > C:\BUDGET>"C:\Program Files (x86)\gnucash\bin\gnucash-cli" -R run > > --name > > "68827f48ea584054a227fbf7591a2b1b" --output-file "C:\Temp\BS.html" > > mybudget.gnucash > > > > NOTE that in this case, because I have multiple Balance Sheet > reports, > > I had to specify the report name using its GUID as I encountered an > > error when I used: -R run --name "Balance Sheet", however the error > > message kindly gave me the GUID. > > > > Hope this helps. > > > > Regards > > > > Geoff > > ===== > > > > On 21/09/2022 8:48 pm, William Starrs wrote: > > > Hello Jeff, I am au courant with Python (le Python c'est bon!) > > Thank > > > you for that suggestion, I will give it a try. > > > > > > To be clear, all of the date filtering combinations that I tried > > were > > > part of the saved report configurations, I was not trying to > > provide any > > > parameters via command line other than to run the saved report > as-is. > > > > > > Bill > > > > > > On Wed, Sep 21, 2022 at 5:36 AM Geoff <cleanoutmys...@gmail.com > > <mailto:cleanoutmys...@gmail.com> > > > <mailto:cleanoutmys...@gmail.com > > <mailto:cleanoutmys...@gmail.com>>> wrote: > > > > > > Hi William > > > > > > Based on my interpretation of the gnucash-cli --help text, > > and this > > > Reddit forum post, I don't think that it is possible to pass > date > > > parameters to reports from the command line. > > > > > > > > > https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/ > > < > https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/ > > > > > > > < > https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/ > < > https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/ > >> > > > > > > If you are au courant with Python you could probably achieve a > > > transaction list for a custom date range fairly easily using > > PieCash: > > > > > > https://github.com/sdementen/piecash > > <https://github.com/sdementen/piecash> > > > <https://github.com/sdementen/piecash > > <https://github.com/sdementen/piecash>> > > > > > > Good luck! > > > > > > Regards > > > > > > Geoff > > > ===== > > > > > > On 21/09/2022 9:38 am, William Starrs wrote: > > > > Update: I tried also setting a fixed Start Date and end of > > > "Today", as > > > > well as a fixed start and end date. All configurations > > give the same > > > > error. Again, no error in the GUI. > > > > > > > > Thanks, > > > > > > > > Bill > > > > > > > > On Mon, Sep 19, 2022 at 3:27 PM William Starrs > > > <wjstarrs...@gmail.com <mailto:wjstarrs...@gmail.com> > > <mailto:wjstarrs...@gmail.com <mailto:wjstarrs...@gmail.com>>> > > > > wrote: > > > > > > > >> Hello, > > > >> > > > >> I would like to script a report that will show me all > > > transactions on > > > >> credit cards since their last closing date. I'll maintain > > > closing dates > > > >> outside of Gnucash. I have the report set to show me all > > > transactions > > > >> since the start of the previous quarter (so it is rolling) > > > through today. > > > >> I would then filter out transactions prior to the closing > > date in > > > >> post-processing. > > > >> > > > >> The report runs fine in the GUI, but when I try to run > from > > > gnucash-cli I > > > >> get the following error: > > > >> > > > >> ERROR <gnc.engine.sx <http://gnc.engine.sx> > > <http://gnc.engine.sx <http://gnc.engine.sx>>> Bad End Date: > > > Invalid or before Start Date > > > >> > > > >> The -R show command shows options regarding the dates > > that ought > > > to work: > > > >> > > > >> General / Start Date: relative . start-prev-quarter > > > >> General / End Date: relative . today > > > >> > > > >> So I can't think of a situation where the start of > previous > > > quarter would > > > >> be missing or before today. > > > >> > > > >> Any suggestions? > > > >> > > > >> Thanks > > > >> > > > >> Bill > > > >> > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>> > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > > > <https://lists.gnucash.org/mailman/listinfo/gnucash-user > > <https://lists.gnucash.org/mailman/listinfo/gnucash-user>> > > > > ----- > > > > Please remember to CC this list on all your replies. > > > > You can do this by using Reply-To-List or Reply-All. > > > > > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
