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.
