Re: [Koha] Regarding KOHA reports

2020-11-05 Thread ANJU SAINI
Thank you so much. On Fri, Nov 6, 2020 at 10:40 AM Indranil Das Gupta wrote: > Hi Anju, > > Here you go https://wiki.koha-community.org/wiki/SQL_Reports_Library > > Best wishes > > Indranil Das Gupta > L2C2 Technologies > > On Fri, 6 Nov, 2020, 10:35 am ANJU SAINI, > wrote: > >> Hello everyone

Re: [Koha] Regarding KOHA reports

2020-11-05 Thread Indranil Das Gupta
Hi Anju, Here you go https://wiki.koha-community.org/wiki/SQL_Reports_Library Best wishes Indranil Das Gupta L2C2 Technologies On Fri, 6 Nov, 2020, 10:35 am ANJU SAINI, wrote: > Hello everyone > I just installed KOHA software . Anyone send me SQL for all reports . Any > help would be very muc

[Koha] Regarding KOHA reports

2020-11-05 Thread ANJU SAINI
Hello everyone I just installed KOHA software . Anyone send me SQL for all reports . Any help would be very much appreciated! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinf

Re: [Koha] OPAC 404 errors after upgrading to 20.05

2020-11-05 Thread Father Vlasie
Hello again! It seems the problem is with the URL generated by the search results: /cgi-bin/koha/opac-detail.pl?biblionumber=&query_desc=kw%2Cwrdl%3A%20Kang You can see there is no biblionumber specified! I am not sure how to troubleshoot this... FV > On 4 Nov 2020, at 9:09 am, Father Vlasie

Re: [Koha] Downgrade to 19 from 20

2020-11-05 Thread Indranil Das Gupta
No such Downgrading HOWTO exists AFAIK. The standard technique would be as follows: 1) Keep a copy of 19.XX database handy. And note down your Koha instance name with sudo koha-list. NB if you have more than one instance, pls ensure you note down the correct instance name. 2) Format your system

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread pandian
Dear Alvaro, Thanks very much. I will check and get back should i need any clarifications and help. Regards, Pandian Quoting Alvaro Cornejo : Hi Here is the report to setup as *public*: SELECT borrowers.surname, borrowers.firstname, borrowers.email, borrowers.emailpro, borrowers.sex, bo

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread Alvaro Cornejo
Hi Here is the report to setup as *public*: SELECT borrowers.surname, borrowers.firstname, borrowers.email, borrowers.emailpro, borrowers.sex, borrowers.lang FROM borrowers WHERE DATE_FORMAT(borrowers.dateofbirth, '%m-%d') = DATE_FORMAT(CURDATE(), '%m-%d') LIMIT 50 You can add other fields to t

[Koha] Downgrade to 19 from 20

2020-11-05 Thread Father Vlasie
Hello all, Is there an official guide for downgrading Koha to the previous version? I am having some serious trouble with my 20.05.05.000 install and I would like to go back to 19. Are there any database changes between these two versions? Thank you! FV __

Re: [Koha] koha script wiki

2020-11-05 Thread rogan . hamby
Same, I can't imagine anyone objecting to more useful stuff on the wiki. On Thu, Nov 5, 2020 at 4:44 PM Michael Kuhn wrote: > Hi Alvaro > > > Would it be possible to create a koha wiki for sharing scripts? Koha > > has reports, css and js wikis for sharing them with the community. I > > guess

Re: [Koha] koha script wiki

2020-11-05 Thread Michael Kuhn
Hi Alvaro > Would it be possible to create a koha wiki for sharing scripts? Koha > has reports, css and js wikis for sharing them with the community. I > guess a way to share scripts might be an enhancement to koha > ressources. > > Sometimes, writing scripts is a fast, cheap and reliable way to

[Koha] koha script wiki

2020-11-05 Thread Alvaro Cornejo
Hi Would it be possible to create a koha wiki for sharing scripts? Koha has reports, css and js wikis for sharing them with the community. I guess a way to share scripts might be an enhancement to koha ressources. Sometimes, writing scripts is a fast, cheap and reliable way to solve very specific

Re: [Koha] Birthday Wishes email to patron any option from koha?

2020-11-05 Thread Alvaro Cornejo
Hi We have created a public report in koha that provides us the info we need to send the emails and created a script that parses the output of that report and sends the email. We finally run this script with a cronjob. I can share the report and script if you think it will help you. Regards Alv

Re: [Koha] Academic Repository

2020-11-05 Thread King, Fred
Greetings! This may not be the Best Way, but here's how I would do it. Esteemed colleagues, please add corrections and improvements. Create a MARC record for each document the same way you'd create one for any book, journal, etc. Don't worry about the record being perfect and following all the