Hi there, I work with an academic library, each time we try running reports for accreditation purpose we don't get holistic reports on for a particular course/ discipline. Seeking for a way out of this mess.
Thanks. On Thu, Mar 7, 2019, 12:00 AM <koha-requ...@lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha@lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. MARC Bibliographic Test error (Tanzeem M.B) > 2. Re: How to receive reports to email (SATISH) > 3. Re: MARC Bibliographic Test error (Tomas Cohen Arazi) > 4. Adding randomly generated password to member entry form using > intranetuserjs > (Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION TRUST)) > 5. Koha 10.05.10 released. Critical bug fix. (Jesse Maseto) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 6 Mar 2019 13:39:19 +0530 > From: "Tanzeem M.B" <tanzeem...@gmail.com> > To: koha@lists.katipo.co.nz > Subject: [Koha] MARC Bibliographic Test error > Message-ID: > <CAFdG+--x7k= > aatafc4amypegk3tza2rxypf2oebsf5ksahq...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Dear folks, > > Please see the attached document for the detailed specification of > errors to be fixed. Please advice how to proceed and fix the problem. > > With Thanks & Regards > > Mr. Tanzeem M B > +91 9446705956 > > Thiruvananthapuram > > > ------------------------------ > > Message: 2 > Date: Wed, 6 Mar 2019 17:23:12 +0530 > From: SATISH <lis4sat...@gmail.com> > To: Alvaro Cornejo <cornejo.alv...@gmail.com> > Cc: Koha <koha@lists.katipo.co.nz> > Subject: Re: [Koha] How to receive reports to email > Message-ID: > < > cajkm6uevgbvytudojxxeefvn7xfgdwxvxfucpjr33chizm2...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > 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. > --- > > > ------------------------------ > > Message: 3 > Date: Wed, 6 Mar 2019 09:07:49 -0300 > From: Tomas Cohen Arazi <tomasco...@gmail.com> > To: "Tanzeem M.B" <tanzeem...@gmail.com> > Cc: koha <koha@lists.katipo.co.nz> > Subject: Re: [Koha] MARC Bibliographic Test error > Message-ID: > <CABZfb= > uiot02mudbk10l3-nxeweyoadhv-kmfn1pr7wzf3w...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Your email doesn't have an attachment. > > El mié., 6 mar. 2019 a las 5:10, Tanzeem M.B (<tanzeem...@gmail.com>) > escribió: > > > Dear folks, > > > > Please see the attached document for the detailed specification of > > errors to be fixed. Please advice how to proceed and fix the problem. > > > > With Thanks & Regards > > > > Mr. Tanzeem M B > > +91 9446705956 > > > > Thiruvananthapuram > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Tomás Cohen Arazi > Theke Solutions (http://theke.io) > ✆ +54 9351 3513384 > GPG: B2F3C15F > > > ------------------------------ > > Message: 4 > Date: Wed, 6 Mar 2019 12:09:23 +0000 > From: "Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION > TRUST)" <emma.pe...@nhs.net> > To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > Subject: [Koha] Adding randomly generated password to member entry > form using intranetuserjs > Message-ID: <1551874150915.44...@nhs.net> > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > > > I work on behalf of the Base Library Consortium, a group of health > libraries in the UK. > > > > We are upgrading to Koha 18.11 soon. > > > > I wondered if anyone has added the random password generator from > member-password.tt to the OPAC/Staff login section of the memberentry > form, using JavaScript in intranetuserjs. > > > > Many thanks, > > > > Kind regards, > > > > Emma Perks > > Area Systems Librarian > > > > ******************************************************************************************************************** > > This message may contain confidential information. If you are not the > intended recipient please inform the > sender that you have received the message in error before deleting it. > Please do not disclose, copy or distribute information in this e-mail or > take any action in relation to its contents. To do so is strictly > prohibited and may be unlawful. Thank you for your co-operation. > > NHSmail is the secure email and directory service available for all NHS > staff in England and Scotland. NHSmail is approved for exchanging patient > data and other sensitive information with NHSmail and other accredited > email services. > > For more information and to find out how you can switch, > https://portal.nhs.net/help/joiningnhsmail > > > > ------------------------------ > > Message: 5 > Date: Wed, 6 Mar 2019 11:28:54 -0500 > From: Jesse Maseto <je...@bywatersolutions.com> > To: Koha <koha@lists.katipo.co.nz> > Subject: [Koha] Koha 10.05.10 released. Critical bug fix. > Message-ID: > <CABV14nN6P1ERVFbW1UHqH_zA0=ZbRpVDPmt_ghWV= > xg443w...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > The Koha community is proud to announce the release of 18.05.10. > > This is a maintenance release and contains a critical bugfix. Please review > the release notes here: > > https://koha-community.org/koha-18-05-10-released/ > > As always you can download the release from here: > > http://download.koha-community.org/koha-18.05.10.tar.gz > <http://download.koha-community.org/koha-18.05.09.tar.gz> > Thank you very much to everyone involved in this release. > > Best regards, > -Jesse and Lucas > > -------------------- > Jesse Maseto > Dev/Ops Support > ByWater Solutions > Support & Consulting for OSS > Office - Stratford,CT > T/F 888.900.8944 > http://bywatersolutions.com > je...@bywatersolutions.com > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 161, Issue 7 > ************************************ > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
