Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-10-01 Thread William Starrs
Hello Geoff, Piecash works like a charm. The gnucash-cli still will not work, but it is actually more efficient and powerful to use piecash, so I'll just go with that. Thanks for your help. On Wed, Sep 21, 2022 at 9:00 AM William Starrs wrote: > Hi Geoff, > > I had tested hard-coded dates in

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread William Starrs
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 BeautifulSo

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
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 Qua

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread William Starrs
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

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
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 ha

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread William Starrs
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

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
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/ If you

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-20 Thread William Starrs
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 wrote: > Hello, > > I would like to script a report that

[GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-19 Thread William Starrs
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 w