Re: [Koha] how to run reports for for a subject specialization.
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@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-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] MARC Bibliographic Test error Message-ID: <CAFdG+--x7k= AatAfc4AmYPeGk3Tza2rxyPf2OEBSf5KsaHQWGw@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@gmail.com> To: Alvaro Cornejo <cornejo.alvaro@gmail.com> Cc: Koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] How to receive reports to email Message-ID: < CAJkM6UEvgbVYTUdojxxeEFVN7XFgDwXvxfUCPJR33Chizm2v9A@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_issue...
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@gmail.com> To: "Tanzeem M.B" <tanzeem.mb@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] MARC Bibliographic Test error Message-ID: <CABZfb= UiOT02mUDbK10L3-nxeweyOAdhV-kmFn1Pr7wzF3Wt2A@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@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.perks@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.44884@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@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= xG443wsrw@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@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 ************************************
participants (1)
-
Hawwau Moruf