[Koha] how to run reports for for a subject specialization.

Hawwau Moruf hawwau.moruf at gmail.com
Fri Mar 8 06:15:07 NZDT 2019


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-request at lists.katipo.co.nz> wrote:

> Send Koha mailing list submissions to
>         koha at 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-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
>         koha-owner at 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.mb at gmail.com>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] MARC Bibliographic Test error
> Message-ID:
>         <CAFdG+--x7k=
> AatAfc4AmYPeGk3Tza2rxyPf2OEBSf5KsaHQWGw at 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 <lis4satish at gmail.com>
> To: Alvaro Cornejo <cornejo.alvaro at gmail.com>
> Cc: Koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] How to receive reports to email
> Message-ID:
>         <
> CAJkM6UEvgbVYTUdojxxeEFVN7XFgDwXvxfUCPJR33Chizm2v9A at 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 <tomascohen at gmail.com>
> To: "Tanzeem M.B" <tanzeem.mb at gmail.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] MARC Bibliographic Test error
> Message-ID:
>         <CABZfb=
> UiOT02mUDbK10L3-nxeweyOAdhV-kmFn1Pr7wzF3Wt2A at 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.mb at 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 at 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.perks at nhs.net>
> To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: [Koha] Adding randomly generated password to member entry
>         form using intranetuserjs
> Message-ID: <1551874150915.44884 at 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 <jesse at bywatersolutions.com>
> To: Koha <koha at lists.katipo.co.nz>
> Subject: [Koha] Koha 10.05.10 released. Critical bug fix.
> Message-ID:
>         <CABV14nN6P1ERVFbW1UHqH_zA0=ZbRpVDPmt_ghWV=
> xG443wsrw at 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
> Jesse at bywatersolutions.com
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> End of Koha Digest, Vol 161, Issue 7
> ************************************
>


More information about the Koha mailing list