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 <[email protected]> wrote: > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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" <[email protected]> > To: [email protected] > Subject: [Koha] MARC Bibliographic Test error > Message-ID: > <CAFdG+--x7k= > [email protected]> > 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 <[email protected]> > To: Alvaro Cornejo <[email protected]> > Cc: Koha <[email protected]> > 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 <[email protected]> > To: "Tanzeem M.B" <[email protected]> > Cc: koha <[email protected]> > Subject: Re: [Koha] MARC Bibliographic Test error > Message-ID: > <CABZfb= > [email protected]> > 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 (<[email protected]>) > 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 > > [email protected] > > 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)" <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [Koha] Adding randomly generated password to member entry > form using intranetuserjs > Message-ID: <[email protected]> > 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 <[email protected]> > To: Koha <[email protected]> > Subject: [Koha] Koha 10.05.10 released. Critical bug fix. > Message-ID: > <CABV14nN6P1ERVFbW1UHqH_zA0=ZbRpVDPmt_ghWV= > [email protected]> > 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 > [email protected] > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 161, Issue 7 > ************************************ > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
