[Koha] need an sql report
Dear All I need an sql report that can generate a list of Bib records with item count according to the shelving location. If any body has this report please send me. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] need an sql report to count notices
Dear All Is there any sql report that can count how many notices are being sent in a specific period of time? -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] email notices about hold awaiting
Dear All I am using Ubuntu Koha 3.16. I am facing an issue. When 2 or 3 persons reserved an issued book system sets priority for them. As that issued book returned in library, system send an auto generated email (Hold awaiting for pick up) to the person who is at first priority. when that person issues this book and return it in the library, system send an email for holds awaiting pick up to the person in queue and so on... But if first person cancel his hold after receiving email for holds awaiting pick up, System does not send email to the person in queue. So He can Pick it from library. Would anyone please tell what should do for this situation. If patron at first priority cancel his hold, system should send an email to the other in queue. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] email notices about hold awaiting
I am using Ubuntu based Koha version 3.16.02 On Thu, Oct 23, 2014 at 9:56 AM, Arslan Farooq arslan...@gmail.com wrote: Hi Saira, You explained your problem very nicely. Just one question while I try to confirm the behavior (and someone may answer first): what is your full Koha version? I have 3.16.04. Arslan On Thu, Oct 23, 2014 at 9:33 AM, Saira Asghar saira.asgha...@gmail.com wrote: Dear All I am using Ubuntu Koha 3.16. I am facing an issue. When 2 or 3 persons reserved an issued book system sets priority for them. As that issued book returned in library, system send an auto generated email (Hold awaiting for pick up) to the person who is at first priority. when that person issues this book and return it in the library, system send an email for holds awaiting pick up to the person in queue and so on... But if first person cancel his hold after receiving email for holds awaiting pick up, System does not send email to the person in queue. So He can Pick it from library. Would anyone please tell what should do for this situation. If patron at first priority cancel his hold, system should send an email to the other in queue. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Redirect loop Error
Dear All I am using Ubuntu based koha version 3.14.05 and have configured it on domain. Its working fine but some times its gives a message at client site Redirect loop. Can any one please tell us its solution? After deleting cookies at client system its start working but its not a suitable solution because it is not possible to everyone to dell cookies from his system's browser for using the site. Is it possible to configure its cookies at server machine. So no any user has to face this redirect loop error. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Borrowers DB file for offline circulation
Hello Everyone If we are using offline circulation, We need borrowers DB file. Any one can please tell me that how we can get this DB file from database? I am using ubuntu based koha version 3.14.01. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Sql report for list of items according to shelving location
Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this. I shall be very thankful for your kind help. Waiting for reply -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sql report for list of items according to shelving location
Dear Mr. Paul. A Thank you so much for sharing this report. This is absolutely according to my need. Thanks again On Fri, Nov 1, 2013 at 8:28 PM, Paul A pau...@navalmarinearchive.comwrote: At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this. You might try: SELECT biblio.author,biblio.title,**biblio.copyrightdate,items.** barcode,items.price,items.**dateaccessioned,items.** location,items.booksellerid FROM items, biblio WHERE items.biblionumber = biblio.biblionumber AND items.location = Pick your shelf (use auth. value) ORDER BY biblio.author ASC then modify to suit your own needs. Best - Paul __**_ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://lists.katipo.co.nz/mailman/listinfo/koha -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] email about patron account deatils
Dear All When we create any patron account in koha. Database send him an email about his account details (username and password for login at OPAC ). But in case of *import patrons* it is not sending emails to patrons. it should be send. If any one has its solution then please tell me. If any command needs to run after importing patron. So, all importing patrons receive the email about their account detail then please send that command. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asg...@namal.edu.pk Ph: 0459 236995 Ext. 138 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha