[GNC] Date error running report from gnucash-cli, report runs fine in GUI
William Starrs
wjstarrsiii at gmail.com
Wed Sep 21 09:00:52 EDT 2022
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 <cleanoutmyshed at 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 <cleanoutmyshed at gmail.com
> > <mailto: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>
> > > <mailto: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/
> >
> > >
> > <
> 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
> > > <wjstarrsiii at gmail.com <mailto:wjstarrsiii at gmail.com>
> > <mailto: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>
> > <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 at gnucash.org <mailto:gnucash-user at gnucash.org>
> > <mailto: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>
> > > <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.
> > >
> >
>
More information about the gnucash-user
mailing list