Re: [Koha] How to receive reports to email

Hi Satish, thx for the update. Good to know! Katrin On 08.03.19 12:37, SATISH wrote: Hi Katrin, I verified for multiple reports today. It is working fine. The correct syntax:  * *  * * * root koha-foreach --enabled --email  /usr/share/koha/bin/cronjobs/runreport.pl  

Re: [Koha] How to receive reports to email

Hi Katrin, I verified for multiple reports today. It is working fine. The correct syntax: * * * * * root koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/runreport.pl report-id1 report-id2 report-id3 --format=html --to=email id (report ids separated by one space only, no

Re: [Koha] How to receive reports to email

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

Re: [Koha] How to receive reports to email

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

Re: [Koha] How to receive reports to email

note that the format should be --format=csv (comma separated values) not --format=cvs On Mon, Feb 18, 2019 at 9:33 AM Alvaro Cornejo wrote: > Hi > > You need to specify all time fields in your command. If you do not want to > specify one, you must insert an * > > Time fields are >

Re: [Koha] How to receive reports to email

Hi You need to specify all time fields in your command. If you do not want to specify one, you must insert an * Time fields are [minute] [hour] [day] [month] [day of week] 30 17 * * * __KOHA_USER__ $KOHA_CRON_PATH/runreport.pl 141 --format=cvs --to=lis4sat...@gmail.com As per above, your

Re: [Koha] How to receive reports to email

Hi I guess you should use --format=cvs ... and maybe --cvs-header Regards, Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en

Re: [Koha] How to receive reports to email

Hi Caroline, Thank you for your email. Could you please confirm, the format I am using in cron is it correct? #test report 30 17 __KOHA_USER__ $KOHA_CRON_PATH/runreport.pl 141 --format=text --to= lis4sat...@gmail.com Also, I would like to get the report in - tab delimited format or csv

Re: [Koha] How to receive reports to email

There is already the runreport.pl cronjob that can do this. https://koha-community.org/manual/18.11/en/html/cron_jobs.html#run-report Le 19-02-15 à 10 h 28, Alvaro Cornejo a écrit : Hi Satish Always CC koha list so you can have more feedbacks and others can profit from discussion. You can

Re: [Koha] How to receive reports to email

Hi Satish Always CC koha list so you can have more feedbacks and others can profit from discussion. You can start with the example Paul provided. I don't know perl but seems complete; however you need to define/create your query. If you don't know perl, you can use any language you know. You

Re: [Koha] How to receive reports to email

Hi, I think it might not be well known, but Koha has already a command line script that you can run as a cronjob to email you the results of any report: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=misc/cronjobs/runreport.pl Hope this helps! Katrin On 14.02.19 18:33, Paul

Re: [Koha] How to receive reports to email

On Thu, Feb 14, 2019 at 12:30:59PM +0530, SATISH wrote: > I need to keep print copy of daily transactions (cumulative) report for > check-out & check-in transactions that is from library > opening hours to closing hours every day. Currently I am running sql for > date range for check-in &

Re: [Koha] How to receive reports to email

Hi If already have an report for this, you can define it as public and create a small script -in the language of your choice- that runs it and insert an entry in cron jobs. You can even create the whole report in your script accessing directly to your database. Regards, Alvaro

Re: [Koha] How to receive reports to email

Hi, There is bug (3935) registered for the same problem already ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to receive reports to email

Hi, I am not referring to check-out and check-in messages through email for a single or multiple transactions of a particular user. We are getting email notifications to check-in/check-out/reminders/ etc. I need to keep print copy of daily transactions (cumulative) report for check-out &

[Koha] How to receive reports to email

Hi, I would like to receive check-out and check-in report in CSV or tab separated text - format on daily basis to my email automatically on daily basis. How to set cron entry to get such report automatically. Kindly share your best practices if any of the library has implemented same feature.