[Koha] FYI, Need advice of Installing Koha on openSUSE 12.1

2012-04-03 Thread Andi Sugandi
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]

[Koha] openlibrary

2012-04-03 Thread Abdulsalam Yousef
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

Re: [Koha] openlibrary

2012-04-03 Thread Robin Sheat
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

Re: [Koha] Upgrade 3.01 to 3.6 on Diff Server

2012-04-03 Thread Chris Nighswonger
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

Re: [Koha] how to get the accession number displayed in the opac search

2012-04-03 Thread Owen Leonard
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

[Koha] To-morrow and to-morrow and to-morrow

2012-04-03 Thread BWS Johnson
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

Re: [Koha] [Koha-devel] To-morrow and to-morrow and to-morrow

2012-04-03 Thread Owen Leonard
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:

Re: [Koha] [Koha-devel] To-morrow and to-morrow and to-morrow

2012-04-03 Thread Paul Poulain
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

[Koha] Need SQL query help, please

2012-04-03 Thread Carol Kresge
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

Re: [Koha] Need SQL query help, please

2012-04-03 Thread Chris Cormack
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

Re: [Koha] Need SQL query help, please

2012-04-03 Thread Chris Cormack
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

[Koha] Report help

2012-04-03 Thread Nicole Engard
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

Re: [Koha] Report help

2012-04-03 Thread Chris Cormack
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

Re: [Koha] Need SQL query help, please

2012-04-03 Thread Chris Cormack
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

Re: [Koha] Need SQL query help, please

2012-04-03 Thread Chris Cormack
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,

Re: [Koha] Report help

2012-04-03 Thread Nicole Engard
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

Re: [Koha] Report help

2012-04-03 Thread Chris Cormack
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