[Koha] How to receive reports to email

[Katrin Fischer]

Hi Satish,

try to add multiple lines in crontab for the different reports you want
to run. I think the runreport.pl script only can only be run with one
report number at a time.

Katrin

On 06.03.19 12:53, SATISH wrote:
> Thank you Paul, Barton, Alvaro
>
> Still I am not able to run the said scripts.  I am getting same permission
> problem.
> I  tried to keep related files in /root directory and also in
> /usr/share/koha/bin directory
> same permission problem occurs. So, I did not understand it completely.
> I need some more guidance to get desired results.
>
> However, I also tried with other suggestions given in the mail,
> since runreports.pl is already defined in koha,
>
> I directly edited the file -- koha-common (etc/cron.d)
> added following line,
>
> 45 17 * * * * root koha-foreach --enabled --email
> /usr/share/koha/bin/cronjobs/runreport.pl report-id --format=html
> --to=email id
> I  am successful.
>
> But, for multiple reports, I am not successful.
> 45 17 * * * * root koha-foreach --enabled --email
> /usr/share/koha/bin/cronjobs/runreport.pl report-id1 report-id2 report-id3
> --format=html --to=email id
>
>
> Checkout report -  is taken from SQL library, developed by Sarah Cornel
> List of items issued on a date with optional limit by due date
> <https://wiki.koha-community.org/wiki/SQL_Reports_Library#List_of_items_issued_on_a_date_with_optional_limit_by_due_date>
> with little modification in the last line,  manual entry of   'issue date'
> to 'current date' to chose date on which report is run.
>
> SQL
> ------------------------------
> SELECT
> issuedate, date_due, items.barcode, items.itemcallnumber, biblio.title,
> biblio.author, CONCAT(borrowers.firstname, ' ',borrowers.surname) AS
> 'patron',
> borrowers.cardnumber, CONCAT(borrowers.borrowernumber) AS borrowernumber
> FROM issues
> LEFT JOIN items ON issues.itemnumber = items.itemnumber
> LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber
> LEFT JOIN borrowers ON issues.borrowernumber = borrowers.borrowernumber
> WHERE DATE(issuedate) =  CURDATE()
> -------------------------------
>
> Since I missed to CC koha forum, I am copying imp mails from Paul received.
> --
> The twiddle character (~) in the koha-shell command is being interpreted
> as root's home directory (/root), not as the regular user's home
> directory (/home/helm-gechlibrary or whatever).  The regular user can't
> see inside /root, hence the permission error.
>
> Try this:
>
> # koha-shell gechlibrary -c '/home/helm-gechlibrary/bin/run-reports.pl
>   /home/helm-gechlibrary/reports/checkout-report.txt'
>
> Or, equivalently:
>
> # koha-shell gechlibrary -c '~helm-gechlibrary/bin/run-reports.pl
>   ~helm-gechlibrary/reports/checkout-report.txt'
>
> This should also work:
>
> # koha-shell gechlibrary --login -c 'bin/run-reports.pl
>   reports/checkout-report.txt'
>
> That's because the command -- i.e., the COMMAND in _koha-shell INSTANCE
> --login -c COMMAND_ -- is executed by a process whose current working
> directory is /home/helm-gechlibrary.
> Good luck! Paul.
> ---
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha