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

[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 help fix it, just
need to know where to look.



On Wed, Sep 21, 2022 at 7:25 AM Geoff <cleanoutmyshed at 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 <cleanoutmyshed at gmail.com
> > <mailto:cleanoutmyshed at 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/
> >
> >
> >     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>
> >
> >     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
> >     <wjstarrsiii at gmail.com <mailto:wjstarrsiii at 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>> 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 at gnucash.org <mailto:gnucash-user at 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>
> >      > -----
> >      > Please remember to CC this list on all your replies.
> >      > You can do this by using Reply-To-List or Reply-All.
> >
>