[Koha] FYI, Need advice of Installing Koha on openSUSE 12.1
Hi all, I made a small note of installing Koha 3.6.4 on openSUSE 12.1[0] so hopefully we can make an update information on the wiki page[1] and its manual in Koha package (./INSTALL.opensuse file)[2]. Really need advice how we can improve those documentations. Thanks in advance. [0] andi.opensuse-id.org/2012/03/12/dependency-packages-for-koha-3-6-4-on-opensuse-12-1/ [1] wiki.koha-community.org/wiki/Koha_3.0.0_on_openSUSE_11.3 [2] http://download.koha-community.org/koha-latest.tar.gz Best regards, -- Andi Sugandi. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] openlibrary
Hello every body we would like to know if we can get Openlibrary reviews instead of amazon reviews(which is useless now after changing their APIs)?? And, If that is possible where are that APIs and documentation?? thanks so much. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] openlibrary
The short answer is yes, if you figure out the api that's needed then implementing that won't be too hard at all. I'm currently planning some related work, though not exactly this, but the openlibrary APIs tens to be pretty straightforward. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. Abdulsalam Yousef ayou...@kwareict.com wrote: Hello every body we would like to know if we can get Openlibrary reviews instead of amazon reviews(which is useless now after changing their APIs)?? And, If that is possible where are that APIs and documentation?? thanks so much. _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrade 3.01 to 3.6 on Diff Server
On Mon, Apr 2, 2012 at 6:34 PM, Josh Mikow joshmi...@gmail.com wrote: The koha-upgrade-to-3.4 command kept returning a bunch of Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 2953 messages. It's still running and I'm not sure if that is a problem or not. You may safely ignore those warnings. Before I had created brdglibrary I had tried creating a few other instances and now would like to remove them but the koha-remove doesn't work. It appears that when it tries to drop the mysql user, it fails because it doesn't pass the name of the instance properly to the DROP statement. Do you know how I can fix that to make the removal of an instance easier? I'm not sure about this. Someone more familiar with the packages will have to answer. Kind Regards, Chris (another one) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] how to get the accession number displayed in the opac search
Regarding OPAC Search in Koha 3.6.2, it does not show the Accession Number in the basic search by default. This is by design. The accession number is considered to be information of interest only to librarians, thus not displayed by default in the public interface. It might be possible to do a customization of your XSLT view. Otherwise it would require changes to your templates, something which is not recommended. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] To-morrow and to-morrow and to-morrow
Salvete! If you only make 2 IRC Meetings a year, tomorrow's is one to catch. 4 April at 10 UTC we're voting on roles for 3.10. There's still time to visit the wiki, step up, and volunteer in advance of the meeting. So have your +1s at the ready! See you soon, Brooke ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] To-morrow and to-morrow and to-morrow
4 April at 10 UTC Time and date conversion: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+Meetingiso=20120404T10 Agenda: http://wiki.koha-community.org/wiki/General_IRC_meeting,_4_April_2012 Volunteers for Roles for 3.10: http://wiki.koha-community.org/wiki/Roles_for_3.10 -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] To-morrow and to-morrow and to-morrow
Le 03/04/2012 18:29, Owen Leonard a écrit : 4 April at 10 UTC Time and date conversion: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+Meetingiso=20120404T10 http://wiki.koha-community.org/wiki/Roles_for_3.10 Just a comment: if it's 3AM for you, as there is only 1 volunteer for each role, we won't complain if you stay in your bed ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Need SQL query help, please
I have a query to find borrowers with late books that do not have email addresses or mobiles. Now I am trying to modify it so it will show their school from attributes if they have one but won't knock them off the list if they don't. My modification below shows only those with no email and no mobile and a school but knocks people off the list who have no school attribute. How can I modify it so it includes no mobile no email and lists school for those who have one but still includes those who don't? SELECT borrowers.surname,borrowers.firstname,borrowers.mobile,borrowers.email,borrowers.city, biblio.title,biblioitems.itemtype,issues.date_due,borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' AND borrower_attributes.code = 'School' ORDER BY borrowers.surname asc; Thanks for your help! Carol -- supporting Lao youth in their quest for a brighter future The Language Project…an American 501(c)3 charity Website: www.thelanguageproject.org Gallery: http://laophotographers.zenfolio.com Lao address: PO Box 905, Luang Prabang, Laos Lao mobile: 856 20 97122771 US address: PO Box 13201, Tallahassee, FL 32317 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need SQL query help, please
On 4 April 2012 00:32, Carol Kresge carol.kre...@gmail.com wrote: I have a query to find borrowers with late books that do not have email addresses or mobiles. Now I am trying to modify it so it will show their school from attributes if they have one but won't knock them off the list if they don't. My modification below shows only those with no email and no mobile and a school but knocks people off the list who have no school attribute. How can I modify it so it includes no mobile no email and lists school for those who have one but still includes those who don't? SELECT borrowers.surname,borrowers.firstname,borrowers.mobile,borrowers.email,borrowers.city, biblio.title,biblioitems.itemtype,issues.date_due,borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' AND borrower_attributes.code = 'School' ORDER BY borrowers.surname asc; Hi Carol I think this will do it SELECT surname, firstname, mobile, email, city, biblio.title, biblioitems.itemtype, issues.date_due, (select borrower_attributes.attribute from borrower_attributes where code = 'School') as School FROM borrowers LEFT OUTER JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' ORDER BY borrowers.surname asc; Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need SQL query help, please
Ohh, This will actually work better SELECT surname, firstname, mobile, email, city, biblio.title, biblioitems.itemtype, issues.date_due, (select borrower_attributes.attribute from borrower_attributes where code = 'School' group by borrowernumber) as School FROM borrowers LEFT OUTER JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' GROUP BY borrowers.borrowernumber,items.itemnumber ORDER BY borrowers.surname asc; And avoid double ups Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Report help
I think this requires some regex magic :) So, if anyone can help me out that would be great: How do I create a report for all records that have both of the following items? A 942|c field that says Photographs and a leader fields that shows item type as book? I know that the 94$c is mapped to biblioitems.itemtype - so that's not the issue, it's the Leader bit I need help with. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
On 4 April 2012 14:38, Nicole Engard neng...@gmail.com wrote: I think this requires some regex magic :) So, if anyone can help me out that would be great: How do I create a report for all records that have both of the following items? A 942|c field that says Photographs and a leader fields that shows item type as book? I know that the 94$c is mapped to biblioitems.itemtype - so that's not the issue, it's the Leader bit I need help with. What chars in the leader tell me if its a book? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need SQL query help, please
On 4 April 2012 14:53, Carol Kresge carol.kre...@gmail.com wrote: Thanks, but I get an error with both and it won't run error: 1242 subquery returns more than 1 row Maybe that is because I should have mentioned that the User attribute school goes to an authorised value category and has a lot of different values (they go to many different schools...Phongkham, Pasatipatai, Phasabandith...) Sorry, do you have another idea? Ah my bad, The do only go to one school each though right? Or can one student be at more than one? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need SQL query help, please
On 4 April 2012 15:12, Carol Kresge carol.kre...@gmail.com wrote: They only go to one school each. another possibility is they do have more than 1 item checked out Writing this without the data to test, but I *think* this will do it. SELECT surname, firstname, mobile, email, city, biblio.title, biblioitems.itemtype, issues.date_due, (select borrower_attributes.attribute from borrower_attributes where code = 'School' and borrower_attributes.borrowernumber=borrowers.borrowernumber) as School FROM borrowers LEFT OUTER JOIN borrower_attributes on (borrower_attributes.borrowernumber = borrowers.borrowernumber) LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due DATE_SUB(now(), INTERVAL 8 DAY) AND issues.returndate IS NULL AND borrowers.mobile = ' ' AND borrowers.email = ' ' GROUP BY borrowers.borrowernumber,items.itemnumber ORDER BY borrowers.surname asc; Fingers crossed Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html leader6 = a (and one of the leader7 values below) leader7 = a leader7 = c leader7 = d leader7 = m leader6 = t On Tue, Apr 3, 2012 at 7:43 PM, Chris Cormack ch...@bigballofwax.co.nz wrote: On 4 April 2012 14:38, Nicole Engard neng...@gmail.com wrote: I think this requires some regex magic :) So, if anyone can help me out that would be great: How do I create a report for all records that have both of the following items? A 942|c field that says Photographs and a leader fields that shows item type as book? I know that the 94$c is mapped to biblioitems.itemtype - so that's not the issue, it's the Leader bit I need help with. What chars in the leader tell me if its a book? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
On 4 April 2012 15:19, Nicole Engard neng...@gmail.com wrote: From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html leader6 = a (and one of the leader7 values below) leader7 = a leader7 = c leader7 = d leader7 = m leader6 = t Something like this then SELECT * FROM biblioitems, (SELECT biblioitemnumber,SUBSTR(marcxml,INSTR(marcxml, leader)+8+6,1) AS leader6,SUBSTR(marcxml,INSTR(marcxml, leader)+8+7,1) AS leader7 FROM biblioitems) AS leaders WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND (leaders.leader6 = 'a' AND (leader7 IN ('a','c','d','n')) OR leader6 = 't') AND itemtypes = 'your_itemtype goes here' Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha