Re: [Koha] Permission to delete cover image?
Thanks all!! On Wed, Mar 26, 2014 at 12:20 PM, Hernandez, Heather heather_hernan...@nps.gov wrote: Thanks for mentioning this, Galen--I hadn't noticed the separate permission in the patron permissions under Tools! I obviously need to do some reviewing! (Our Reference Librarian doesn't have that permission turned on--I'll have to ask her if she'd like it, since she does a lot of scanning of content!) Cheerio, h2 ~~ Heather Hernandez Technical Services Librarian Cultural Resources and Museum Management Division San Francisco Maritime National Historical Park heather_hernan...@nps.gov 415-561-7032 (voice) 415-556-3540 (fax) http://www.nps.gov/safr/historyculture/library-collections.htm The sailor does not pray for wind, he learns to sail.--Gustaf Lindborg ___ 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] Report Help - With Rollup
Nick, I figured it out - we needed to limit to LOC authorized values: SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS Circulations FROM (select i.location as loction, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=Check out/renewal branch|branches and s.datetime between Checked out or renewed between (-mm-dd)|date and and (-mm-dd)|date group by i.location with rollup ) AS thingy LEFT JOIN authorised_values a on thingy.loction=a.authorised_value where a.category='LOC' On Tue, Mar 25, 2014 at 1:08 PM, Nick Clemens n...@quecheelibrary.org wrote: Here's a thought, it might be an error in the authorized values., and I think it is a bug I recreated it on our system by adding an authorized_value in a different category with the same value as one in the LOC: i.e. I added AFIC to our Vendor category, with description Error! The system doesn't throw an error, and I can't see that value in the listing, but it is then 'Adult Fiction' is duplicated in my report Is the issue clear? On Thu, Mar 20, 2014 at 7:04 PM, Nicole Engard neng...@gmail.com wrote: Okay, any idea why the Juveasy might be showing 2 times? http://screencast.com/t/6dbByW4eZ I added the location code in case that was it - they're identical as are their numbers. On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard neng...@gmail.com wrote: Thank you so much Nick!! Nicole -- Nick Clemens Quechee Wilder Libraries n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] New patron restrictions data
Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New patron restrictions data
Yup, and 1 of the restrictions is stored there, but I have 2 restrictions on the patron record and the other isn't anywhere in the borrowers table that I can see. Nicole On Thu, Mar 20, 2014 at 9:49 AM, Heather Braum (NEKLS) hbr...@nekls.org wrote: If it's the old restrictions data (from before the library upgraded to 3.14) the data is located in the borrowers table, in the borrowers.debarred and borrowers.debarred comment fields. Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ 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] New patron restrictions data
Thank you all! Nicole On Thu, Mar 20, 2014 at 9:55 AM, Heather Braum (NEKLS) hbr...@nekls.org wrote: Thank you Jonathan for correcting me. I completely misread Nicole's question as the data she had was in the borrower_debarments table and she was asking where was the other data was. :) I need much more coffee this morning! Heather Braum NExpress Coordinator Resource Sharing Librarian Northeast Kansas Library System hbr...@nekls.org The illiterate of the 21st century will not be those cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler, *Rethinking the Future* On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart jonathan.dru...@biblibre.com wrote: Hello Nicole, It is in the borrower_debarments table. Regards, Jonathan 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com: Hi all, I'm wondering where in the DB the new restrictions data is stored for patrons. I have a patron with 2 restrictions on her account and when I look at borrowers.debarred I only see 1 of them. The other shows when I view the record in the staff client so the data has to be somewhere ... where is it? :) Thanks Nicole ___ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help - With Rollup
Thank you so much Nick!! 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 - With Rollup
Okay, any idea why the Juveasy might be showing 2 times? http://screencast.com/t/6dbByW4eZ I added the location code in case that was it - they're identical as are their numbers. On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard neng...@gmail.com wrote: Thank you so much Nick!! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] To whom it may concern
Woo hoo! Congrats Nicole C. Engard VP of Education ByWater Solutions Sent from my Nexus 7 tablet. Please excuse typos and brevity. On Mar 14, 2014 5:16 PM, Ed Veal ed.v...@bywatersolutions.com wrote: Congrats to you both! Please forgive typos, this was sent from my Galaxy S3. On Mar 14, 2014 4:57 PM, Rocio Jordan ro...@bywatersolutions.com wrote: Little Daria has arrived Congratulations Kyle!!! You are officially a Daddy On Fri, Mar 14, 2014 at 4:56 PM, Kyle Hall k...@bywatersolutions.comwrote: Daria Michelle Hall was born on pi day! 9 pounds 2 ounced! -- *Rocio D. Jordan* *Migrations Specialist* ByWater Solutions http://bywatersolutions.com/ Support and Consulting for Open Source Software What is Koha? http://bywatersolutions.com/what-is-koha/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] OPAC view link from staff interface doesn't open new window
I know it used to, but I see that it doesn't anymore either. It's a bug :( And I'll go ahead and fix it. Nicole On Wed, Mar 12, 2014 at 4:38 PM, Elaine Bradtke e...@efdss.org wrote: I just noticed this quirk, and am wondering if it's the same for others (in which case, I'll file a bug). Looking at a normal view bib record, if we click on the Opac view: Open in new window, it doesn't open a new window, it just goes to the URL while still in the current tab/window. Koha 3.14.03 in Chrome, and Firefox on MacBook Pro running Maverick, also Chrome on Windows XP I checked Global preferences on the off there was a setting that needed adjusting, but couldn't find a relevant preference. It used to work. . . -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ 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] OPAC view link from staff interface doesn't open new window
I lied - I can't fix it because it makes no sense, the code is right. So I submitted a bug: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11937 Nicole On Thu, Mar 13, 2014 at 12:27 PM, Nicole Engard neng...@gmail.com wrote: I know it used to, but I see that it doesn't anymore either. It's a bug :( And I'll go ahead and fix it. Nicole On Wed, Mar 12, 2014 at 4:38 PM, Elaine Bradtke e...@efdss.org wrote: I just noticed this quirk, and am wondering if it's the same for others (in which case, I'll file a bug). Looking at a normal view bib record, if we click on the Opac view: Open in new window, it doesn't open a new window, it just goes to the URL while still in the current tab/window. Koha 3.14.03 in Chrome, and Firefox on MacBook Pro running Maverick, also Chrome on Windows XP I checked Global preferences on the off there was a setting that needed adjusting, but couldn't find a relevant preference. It used to work. . . -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ 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] Patron Info on Circ Screen
Not sure how to make them show up over there, but what I usually recommend is that people use the patron attributes instead if they want them to show on the side. The attributes allow you set them to show there. Nicole On Thu, Mar 13, 2014 at 9:10 AM, Katelyn Browne kbro...@ccpcs.org wrote: Hi everyone, Is there a way to change the fields that display in the left-hand sidebar (under a patron's picture) during circulation? I would like to have sort1 and sort2 show up there, but my feeble attempts at adding scripts to intranetuserjs have all failed. (I've successfully modified other patron screens, but not that sidebar.) Thanks, Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ ___ 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
[Koha] Help with report on percentage of Circ
I got this request today and I have to admit it's a bit over my head in terms of the math involved. Can someone help me with this report? - May we have a report that will give us the total circulation for a specific time frame and what percentage was attributed to a specific JUR Code? I ran this report and for example it gave me 128% as the percentage of total circ for JUR Code M814. SELECT x.attribute as 'Attribute', x.issues as 'Circ for this attribute', (x.issues * 100)/( SELECT COUNT(s.datetime) as 'total' FROM statistics s WHERE type = 'issue' AND s.datetime BETWEEN Date BETWEEN (-mm-dd) AND and (-mm-dd) ) as 'Percentage of total circ' FROM (SELECT ba.attribute as 'attribute', COUNT(s.datetime) as 'issues' FROM statistics s JOIN borrower_attributes ba ON s.borrowernumber = ba.borrowernumber WHERE ba.code = 'JUR' AND s.datetime BETWEEN Enter the same dates again BETWEEN (-mm-dd) AND and (-mm-dd) GROUP BY attribute) x ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Docbook to HTML/PDF Question
I figured this out on my own. I'm not using this syntax: 45904 sectioninfo 45905 authorgroup 45906 author 45907 firstnameD. Ruth/firstname 45908 surnameBavousett/surname 45909 affiliation 45910 orgnameByWater Solutions/orgname 45911 /affiliation 45912 /author 45913 45914 editor 45915 firstnameNicole C./firstname 45916 surnameEngard/surname 45917 /editor 45918 /authorgroup 45919 45920 pubdate2012/pubdate 45921 /sectioninfo and it appears like this: http://manual.koha-community.org/3.12/en/oclcappendix.html I'll update the other areas soon. Nicole On Mon, Mar 10, 2014 at 8:30 AM, Nicole Engard neng...@gmail.com wrote: Hi all, I'm not sure who manages the Docbook to HTML script (I do know that Bernardo does the PDF one) but I'd love to see the 'authors' broken down by role. For example: http://manual.koha-community.org/3.12/en/oclcappendix.html The sectioninfo is: 45887 sectioninfo 45888 author 45889 firstnameD. Ruth/firstname 45890 45891 surnameBavousett/surname 45892 /author 45893 45894 affiliation 45895 orgnameByWater Solutions.com/orgname 45896 /affiliation 45897 45898 othercredit role=copyeditor 45899 firstnameNicole C./firstname 45900 45901 surnameEngard/surname 45902 45903 contribChanged content where necessary./contrib 45904 /othercredit 45905 45906 pubdate2012/pubdate 45907 /sectioninfo It'd be nice if the 'copyeditor' or 'other credit' info shows so that it was clear who was the author and who was the editor in some of these chapters/appendices. Anyone up for the challenge? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Manual 3.14 Possible Error
The manual has been updated. Sorry about that. Nicole On Tue, Feb 25, 2014 at 11:17 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Hi Anthony, you are right. Manual is differ from Koha system. Manual said patron, system said item. It seems that the Manual is wrong, but just that word. In the code the preference is used with item barcodes and not borrower cardnumbers And it's also old. On 3.2 Manual (oldest I have) it said patron barcodes! Good catch, Bernardo ___ 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] AllowOfflineCirculation question
I guess my question is how does http://your-koha-staff-client/ work if you're offline and can't get to http://your-koha-staff-client/ because it's hosted outside of your local network? Nicole On Tue, Mar 4, 2014 at 12:54 AM, Josef Moravec josef.mora...@gmail.com wrote: Hello Nicole, as I know, that is for built-in offline circulation client, which can be accessed from link http://your-koha-staff-client/cgi-bin/koha/circ/offline.pl the link is also presented on main page of circulation module Best regards Josef Moravec On Mon, Mar 3, 2014 at 11:36 PM, Nicole Engard neng...@gmail.com wrote: Documentation question: If I have AllowOfflineCirculation set to allow, then when I go offline what URL do I go to to circulate? Or is it the regular URL I always used for check in / check out? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] AllowOfflineCirculation question
Okey dokey - manual updates coming! :) Thanks all On Tue, Mar 4, 2014 at 7:26 AM, Jared Camins-Esakov jcam...@cpbibliography.com wrote: You have to use a bookmark you created (or just remember the URL, I suppose). In order for offline circ to work, you will need to have visited the offline circ page while logged in. Ideally offline circ would be done from the same page as regular online circ, but that would require a massive amount of refactoring in the current circ page. On Tue, Mar 4, 2014 at 8:13 AM, Nicole Engard neng...@gmail.com wrote: I guess my question is how does http://your-koha-staff-client/ work if you're offline and can't get to http://your-koha-staff-client/ because it's hosted outside of your local network? Nicole On Tue, Mar 4, 2014 at 12:54 AM, Josef Moravec josef.mora...@gmail.com wrote: Hello Nicole, as I know, that is for built-in offline circulation client, which can be accessed from link http://your-koha-staff-client/cgi-bin/koha/circ/offline.pl the link is also presented on main page of circulation module Best regards Josef Moravec On Mon, Mar 3, 2014 at 11:36 PM, Nicole Engard neng...@gmail.com wrote: Documentation question: If I have AllowOfflineCirculation set to allow, then when I go offline what URL do I go to to circulate? Or is it the regular URL I always used for check in / check out? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Josef Moravec josef.mora...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Another documentation question: suggest_status
I just found the suggest_status authorized value and this enhancement: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10519 I added a value to suggest_status but I don't see it on master as an option to apply to a suggestion or as a filter on the left. Can someone tell me what this authorized value is supposed to to? Is it supposed to allow you to apply different statuses to purchase suggestions? and if so, how? and also if you do how does that effect the emails that are sent out to patrons when the status changes on a suggestion? Thanks in advance, Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] AllowOfflineCirculation question
Documentation question: If I have AllowOfflineCirculation set to allow, then when I go offline what URL do I go to to circulate? Or is it the regular URL I always used for check in / check out? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] First public library in Norway to choose Koha
Woo Hoo!! Welcome Anne Lena, so happy to see you here as part of our community now :) Nicole On Thu, Jan 16, 2014 at 9:53 AM, Anne Lena Westrum anne-lena.west...@kul.oslo.kommune.no wrote: Dear Community! Oslo Public Library (a.k.a. Deichmanske bibliotek or just Deichman) is happy to announce that we have decided to move to Koha as the first public library in Norway. We are the largest public library in Norway, situated in the capital Oslo. We are fully automated with RFID and self checkout stations in most of our 17 branches. In 2017 we will move into a new building with a brand new book sorting system. The move to Koha is the first step in a total makeover of all our IT systems. There will be a lot of work to do on the migration, development of missing features and integrations with other systems, so we have a lot of fun in front of us :) You can read more about the library and the process on our blog: http://digital.deichman.no/blog/2014/01/16/oslo-public-library-chooses-the-free-and-open-koha-integrated-library-system/ We have hired long time community member Magnus Enger in a part time temporary position to help us with migration and development and look forward to becoming an active part of the Koha Community. We can't wait to work together with all of you in the Community to make Koha even better! We also look forward to meeting some of you at hackfests and conferences in the not too distant future! Best regards, All the hackpeeps at Oslo Public Library ___ 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] Koha wins trademark stoush with US defence contractor
And don't forget the bibliography we shared on Zotero: https://www.zotero.org/groups/koha/items/collectionKey/RR77I3HT/order/dateModified/sort/desc Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Users of North America Email List
Can we also get this list added to the list of mailing lists on the Koha site? Thanks a ton! Nicole On Mon, Dec 16, 2013 at 11:58 AM, Nora Blake nbl...@masslibsystem.orgwrote: Greetings all, A new Koha-related email list has been created. This list will facilitate discussion for Koha users based in North America. Everyone from anywhere is invited to join this list but please know that discussion will at times related to issues more important to users in North America. Information about the email list, including instructions on joining can be found here: http://lists.bywatersolutions.com/mailman/listinfo/kohana Thank you, Nora Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 508-357-2121 x123 866-627-7228 Email: nbl...@masslibsystem.org AIM: noraatmls ___ 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
[Koha] Acquisitions Permissions Question
There are two permissions in Acquisitions that have the same description: order_manage order_receive Is the first one for placing orders and the second for Receiving? Or is there not a permission for placing and is one for Editing and one for receiving? Can someone please clarify for me, the libraries and the manual :) Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report: patrons with recent checkouts
On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg croseb...@ncrl.org wrote: SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN old_issues i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate '2012-12-05'; Yes, but it won't include people with things currently checked out - those people are still in the issues table. So you might want (and this will slow it down a bit) to query that table too: SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN (select borrowernumber, issuedate from old_issues union all select borrowernumber, issuedate from issues) i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate '2012-12-05'; ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha and photographs
This library : http://catalog.shasta.bywatersolutions.com/cgi-bin/koha/opac-search.pl?q=stevensonis doing just that. You could contact them maybe or get ideas from their collection. Nicole On Thu, Dec 5, 2013 at 7:47 PM, schnydszch eugen...@yahoo.com wrote: Hello Koha community! I'm working now on photograph collections, records will be imported into the Koha ILS. Anybody here who have worked with similar collection/s? Any tips you can provide me. Thankd in advance! -- View this message in context: http://koha.1045719.n5.nabble.com/koha-and-photographs-tp5780278.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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
[Koha] New Serials Documentation
I need some help on the serials documentation after the upgrade to 3.14. Here's what I have: http://manual.koha-community.org/3.14/en/serials.html#newsubscription but I'm not sure what the Locale is for at all .. and I'm not sure I explained the inner counter right - the word Rollover made a lot more sense. I also need an example of what the options for 'When there is an irregular issue' do so I can explain that better. In general if those in the know could review what I wrote and either submit a patch to the manual to make it clearer or send me some notes to clear it up that would be great. Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KohaCon13 Videos
I'm sorry, I was looking for your video as well, but there wasn't a video recorded of that session. The ones that Washoe sent me are the only ones :( Nicole On Tue, Dec 3, 2013 at 8:53 AM, adetomiwa bashiru tommybash...@yahoo.comwrote: I can't find my own video there please? Adetomiwa Basiru (CLN), Reference Services Librarian Redeemer's University (RUN), Km 46/48, Lagos/Ibadan Expressway, P. M. B. 3005, Redemption City. Ogun State. Nigeria. Mobile: 234-8067098922 On Monday, December 2, 2013 9:41 PM, Nicole Engard neng...@gmail.com wrote: 13 videos from KohaCon13 have been uploaded to the Internet Archive. You can see them here: https://archive.org/search.php?query=subject%3A%22kohacon13%22 (the site is still indexing so they aren't all showing just yet). I don't know if this is the entire program, but it's all the videos I was given so we'll start there and if there are others that appear I will gladly add them Thanks Nicole ___ 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
[Koha] KohaCon13 Videos
13 videos from KohaCon13 have been uploaded to the Internet Archive. You can see them here: https://archive.org/search.php?query=subject%3A%22kohacon13%22 (the site is still indexing so they aren't all showing just yet). I don't know if this is the entire program, but it's all the videos I was given so we'll start there and if there are others that appear I will gladly add them Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KohaCon13 Videos
Turns out that those are the only ones that were recorded. Sorry all. Nicole On Mon, Dec 2, 2013 at 3:40 PM, Chris Cormack ch...@bigballofwax.co.nzwrote: On 3 December 2013 09:40, Nicole Engard neng...@gmail.com wrote: 13 videos from KohaCon13 have been uploaded to the Internet Archive. You can see them here: https://archive.org/search.php?query=subject%3A%22kohacon13%22 (the site is still indexing so they aren't all showing just yet). I don't know if this is the entire program, but it's all the videos I was given so we'll start there and if there are others that appear I will gladly add them Yeah there are quite a few not there yet, my guess is about the same amount again. But thanks heaps for putting up what you have. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Printing overdue notices or bills for Patrons from Koha with NO Email
Lisa, Most libraries I have helped set up use the 3rd overdue as the bill and Koha then emailed the libraries the notices for printing for people who don't have email addresses. You should get that email each night for printing. Nicole On Mon, Nov 25, 2013 at 11:39 AM, Lisa Gugliotti l...@hchlibrary.orgwrote: How do other Koha libraries deal with sending bills to patrons that do not have an email on file? I've tried to use various Directory/Catalog Mail Merge techniques and tutorials using Microsoft Word 2010, a Word Add-In called Many to One, but it's just not working out the way it's supposed to work. Short of sending 5 or 6 mail merged sheets per cardnumber, how do other libraries get around this? Thank you, Lisa Gugliotti Reference Librarian The Henry Carter Hull Library 10 Killingworth Turnpike Clinton, CT 06413 860-669-2342 l...@hchlibrary.org www.hchlibrary.org Like Us on Facebook https://www.facebook.com/hchlibrary Follow Us on Twitter https://twitter.com/hchlibrary ___ 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] Question re 3.12
Denise, In answer to #1 the 264 is an RDA field and all you need to do is ask us (ByWater Solutions) to install the RDA frameworks for you and you'll have that field - regardless of the version you're on. Joy wrote about that here: http://bywatersolutions.com/2013/02/08/rda/ Thanks Nicole On Fri, Nov 22, 2013 at 5:17 AM, Denise Gavio d.ga...@aarome.org wrote: Hello all, I would like to introduce myself, my name is Denise and my Library migrated to Koha in August. We are still trying to sort things out as you can imagine. I have 2 specific questions I would like to ask: 1. Does version 3.12 carry the 264 field? (we should be upgraded soon) 2. We want to monitor our standing orders for monographic series (i.e. order is for the series but volumes are catalogued separately each with its own item) in Koha. We would like to register invoices/payments under a single master record for the series rather than under the individual volumes so that we can have a single view of its status. In our previous system we created a suppressed record for this maintenance function, clunky but workable. Has anyone out there found a good working solution in Koha? Thanks in advance for your help! Denise Denise Gavio Assistant Librarian American Academy in Rome via Angelo Masina 5 00183 Rome ITALY Tel: 39-06-5846418 Fax: 39-06-5810788 website: www.aarome.org ___ 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] KohaCon 2014 Dates?
Awesome! Thanks for the info! :) We should get the pages started on the wiki with this information. On Thu, Nov 21, 2013 at 7:49 AM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Hi, this was sent to Daniel Grobani to be included in next Newsletter (we thought that the newsletter is the natural way) Dear Daniel, We have made our decision on the dates for KohaCon14. We'd like that to be on the newsletter. KohaCon14 will be held in Córdoba, Argentina on October 6th through 13. As happened in Reno, we might concentrate on the conference during the first three days and hackfest the rest. Some fun during the weekend and more hackfest for those who stay longer. ... Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Nov 20, 2013 at 5:15 PM, John Palmer writing2...@gmail.com wrote: It certainly would help to know the dates, if possible. We generally schedule all our conferences by the end of the previous year. On Wed, Nov 20, 2013 at 11:31 AM, Nicole Engard neng...@gmail.com wrote: Hello all, I'm wondering if we have set dates for KohaCon14? I would like to get this on my calendar (and I'm sure others would as well) so as to not book any other conferences/meetings. Thanks Nicole ___ 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 ___ 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
[Koha] KohaCon 2014 Dates?
Hello all, I'm wondering if we have set dates for KohaCon14? I would like to get this on my calendar (and I'm sure others would as well) so as to not book any other conferences/meetings. Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Notices Documentation Question
Sorry I didn't hit reply to all -- Forwarded message -- From: Nicole Engard neng...@gmail.com Date: Wed, Nov 6, 2013 at 9:14 AM Subject: Re: [Koha] Notices Documentation Question To: MJ Ray m...@phonecoop.coop On Mon, Oct 28, 2013 at 8:19 AM, MJ Ray m...@phonecoop.coop wrote: advance_notices.pl notices (and any others I think) are like that. overdue_notices.pl notices use the item.../item tags. Hope that helps, It does help - but which notices are generated by advance_notices.pl ? I don't think hold notices are controlled by that .. so what code do we use on those? As far as I know overdue_notices.pl controls overdues advance_notices.pl controls advance notice (predue) and item due notices (due) That leaves holds, checkin and check out notices ... Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Report Help
Hi all, I have a library that wants to alter this report to allow us to limit on the item's home branch: SELECT concat(b.title, ' ', ExtractValue(m.marcxml, '//datafield[@tag=245]/subfield[@code=b]')) AS title, b.author, count(h.reservedate) AS 'holds' FROM biblio b LEFT JOIN biblioitems m USING (biblionumber) LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber) GROUP BY b.biblionumber HAVING count(h.reservedate) = Min number of holds The problem as I see it is that the hold is placed on the bib level - not the item level most of the time. Can you tell me how to bring the items table in here even if the hold is on the bib level and get the right numbers? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Notices Documentation Question
Hello all, Up til now I thought (and I forget who told me thing) that all notices with the exception of the overdues needed to have the items.content notation to show the items the notice was talking about. Today I learned that this isn't true for the check out digest - and maybe others. Instead you need this notation: biblio.title /b by biblio.author (items.itype). Due Date: issues.date_due The dashes included ... so what I need to know is what notices need to be like this and what use items.content and which use the item /item tags? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Looking for some report help
Hi all, I have this request for a report: Can you develop a report that would provide: all the holds for a chosen owning library's titles (also showing the item barcodes) on which the same chosen library's patrons have holds but which titles are “in transit to another library? The hold is placed on the biblio level most of the time and and transfer on the item level - so this report will not be comprehensive because it will only find item specific holds. SELECT b.title, b.author, i.itemcallnumber, i.barcode, t.tobranch, COUNT(h.biblionumber) AS 'holds' FROM reserves h LEFT JOIN borrowers p using (borrowernumber) LEFT JOIN branchtransfers t USING (itemnumber) LEFT JOIN items i ON (t.itemnumber=i.itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE i.homebranch = Item's branch|branches and p.branchcode=i.homebranch and p.branchcode != t.tobranch GROUP BY h.biblionumber HAVING COUNT(h.biblionumber) 0 ORDER BY b.title ASC Is there a way to make it more comprehensive that I'm missing? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Looking to Query Indicators
Hi all, Anyone know if there is a way to query a marc field based on the indicator value. I have this report (which works): select b.title, b.author, ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') AS lexile from biblio b left join biblioitems m using (biblionumber) where ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') between Lexile between and and But I want to only query 521s that have a 8# in the indicators. My report will find all of the below: 521 2# - TARGET AUDIENCE NOTE Target audience note 4-8. 521 0# - TARGET AUDIENCE NOTE Target audience note 8.8. 521 8# - TARGET AUDIENCE NOTE Target audience note 1150 But I only want the last one. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can't upgrade Koha
Oops! That was me running that on my Mac and not on Koha :) Built under linux Compiled at Jan 7 2011 12:15:46 %ENV: PERL5LIB=/home/nengard/kohaclone @INC: /home/nengard/kohaclone /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl On Sun, Oct 13, 2013 at 12:06 AM, Victor Pang vict...@netmedia.com.sgwrote: nengard wrote I don't know much (or anything) about debian - I just know the few commands I need to manage Koha. I don't think I have anything out of the normal in my install - since I haven't had a problem like this with other modules in the past. Here's what I get: @INC: /Library/Perl/5.12/darwin-thread-multi-2level /Library/Perl/5.12 /Network/Library/Perl/5.12/darwin-thread-multi-2level /Network/Library/Perl/5.12 /Library/Perl/Updates/5.12.4 /System/Library/Perl/5.12/darwin-thread-multi-2level /System/Library/Perl/5.12 /System/Library/Perl/Extras/5.12/darwin-thread-multi-2level /System/Library/Perl/Extras/5.12 Unless you wanted the entire thing that perl -V produced ... I can send that too. Do you see a clue? This looks much like OS X 10.8 (Mountain Lion) install of Perl. Are you running a SSH session from a Debian or Mac OS X system mixing up the intended result? -- View this message in context: http://koha.1045719.n5.nabble.com/Can-t-upgrade-Koha-tp5774275p5774328.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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] Can't upgrade Koha
On Sat, Oct 12, 2013 at 7:25 PM, Mark Tompsett mtomp...@hotmail.com wrote: sudo apt-get install libcrypt-eksblowfish-perl libclass-mix-perl That did it!! Thanks Mark. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Voting for the Kohacon 2014 location
On Tue, Oct 1, 2013 at 10:47 AM, MJ Ray m...@phonecoop.coop wrote: Actually, I think the example makes the opposite clear. Look at the possible outcomes: If Argentina wins, 100 people go to the conference. If Nigeria wins, 190 people go to the conference. So it seems like Nigeria should win, doesn't it? I'm pretty sure that voting system was adopted in order to maximise the number of people who get the opportunity of attending a kohacon. I think there used to be an instruction not to rank venues there was no chance you would attend. Of course, it's not perfect and there may be better ways, but that's my understanding of what the points-based voting system was trying to do. Hope that explains, MJ is exactly right, that is why I did the survey the way I did in past years. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Why three levels in ACQ (Order, Basket. Basket group) ?
On Thu, Sep 5, 2013 at 5:23 AM, Zeno Tajoli z.taj...@cineca.it wrote: I don't' understand well the use of Basket group. The manual is not very clear on this point. That would be because I too am not really clear on the purpose of basket groups :) So I didn't document it very throroughly. Great question!! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Attaching Patron Files in Koha 3.12
You have to turn on the system preference to allow this: http://manual.koha-community.org/3.12/en/administration.html#EnableBorrowerFiles On Thu, Sep 5, 2013 at 7:48 AM, Andi Sugandi andisuga...@gmail.com wrote: Hi Koha experts, I see attaching patron files feature is available in Koha 3.10: http://www.youtube.com/watch?v=RxYNp3E76yI But seems not in Koha 3.12 (?) http://goo.gl/9DJYAq Is it disabled by default or removed on purpose? Thanks advance. 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 mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] about patronimages and photo of borrowers
The answer to all three (I think) is that the images are in the patronimages folder: http://schema.koha-community.org/tables/patronimage.html Nicole On Tue, Sep 3, 2013 at 7:49 AM, Samuel Desseaux samuel.desse...@ecp.fr wrote: Hi, I've a question: When i enabled the system preferences patronimages, photo of borrower can be imported in koha but 1)where these photos are located in koha? 2)where i have to define the source where i dowload photos? 3)How is made the link between the borrower and his photo (all the borrowers com from our ldap)? Thank you. Best regards, Samuel ___ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] JQuery Help
Bernardo, Sorry ... it didn't work on /cgi-bin/koha/tools/modborrowers.pl , but it did on the other. Nicole On Tue, Aug 27, 2013 at 7:19 PM, Nicole Engard neng...@gmail.com wrote: Thank you! On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Nicole, one more line is needed to change sort1 on those two places, the last one $(document).ready(function(){ $(#memberentry_library_management label[for='sort1']).html(Jurisdiction :); $(#patron-library-details .label:contains('Sort field 1:')).html('Jurisdiction:'); $(fieldset.rows label[for='sort1']).html(Jurisdiction :); }); Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard neng...@gmail.com wrote: I'd like to update this jquery http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_Record to also change sort1 on these pages: /cgi-bin/koha/tools/modborrowers.pl /cgi-bin/koha/tools/import_borrowers.pl Any help would be appreciated. ___ 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
[Koha] need manual confirmation
Hello all, I have never done this before, but I got an email telling me to update this: $ zebraidx -c /etc/koha/zebradb/zebra-authorities-dom.cfg -g iso2709 -d authorities init $ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init on this page: http://manual.koha-community.org/3.12/en/resetzebra.html to this: $ sudo zebraidx -c /etc/koha/sites/*library*/zebra-authorities-dom.cfg -g iso2709 -d authorities init $ sudo zebraidx -c /etc/koha/sites/*library*/zebra-biblios.cfg -g iso2709 -d biblios init where *library* was the koha site (installation) name. Can I get some confirmation that this is how it is for everyone and not just a local setup thing? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] URL link checker
Koha has a broken link checker cron job that can be run on a schedule to check links for you. More here: http://manual.koha-community.org/3.10/en/cronjobsch.html#checkurlcron Nicole On Mon, Jun 3, 2013 at 8:47 AM, Tomas Cohen Arazi tomasco...@gmail.comwrote: On Mon, Jun 3, 2013 at 8:53 AM, Maria Okonska maria.okon...@brooklaw.edu wrote: Hi there, We would like to install a URL link checker in our OPAC. Could anyone recommend us one that works well. Can u elaborate on what you want to do? What type of integration? Regards To+ ___ 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] need manual confirmation
On Mon, Jun 3, 2013 at 7:55 PM, Robin Sheat ro...@catalyst.net.nz wrote: Nicole Engard schreef op ma 03-06-2013 om 13:03 [-0400]: This is what Jared recommended I do: http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ceca7766b638435aeba4cd87a4349d1d10addfc7 This may still end up with permission errors on a packaged system. Galen's comment about having rebuild_zebra.pl being able to do this is the best method. We could also add it to koha-rebuild-zebra to make it easy for the packages. As an aside, probably the best way to do this at the moment with the packages would be to use koha-shell to get an environment set up for the particular Koha instance. Okay, that was mostly jibberish to me :) How (specifically) should I update the manual to make this clear? :) Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What are the actions / events that support SMS notification
On Fri, May 24, 2013 at 7:08 AM, David Nind david.n...@gmail.com wrote: http://manual.koha-community.org/3.12/en/cronjobsch.html#noticescron + http://manual.koha-community.org/3.12/en/administration.html#EnhancedMessagingPreferences Also this: http://manual.koha-community.org/3.12/en/circfaq.html#smsnoticefaq and this for a later release: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9021 Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KohaCon13 Preliminary Program
The program has been updated: http://wiki.koha-community.org/wiki/KohaCon13_Program Nicole On Tue, May 21, 2013 at 4:27 PM, Nicole Engard neng...@gmail.com wrote: Hi all, This is the preliminary program for KohaCon13 (please excuse typos or mess ups in time). I know you have all been waiting for this so I wanted to get it out to you all ASAP. I will fix the styling and the typed times (or if you feel like formatting this better you're free to do so). http://wiki.koha-community.org/wiki/KohaCon13_Program Nancy will be in touch with speakers to make sure that everything is still okay as far as speaking and coming to the conference. We did have to shorten some ideas so that we could fit everyone (we didn't want to leave anyone talking about something relevant out of the program). Thanks Nicole C. Engard ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistical patron and In House Use statistics
Jim, The data goes in to the statistics table with a type of 'local' use. So depending on how your reports are written they may or may not be included. Usually when I write reports I ask what you want to include - sometimes just checkouts, sometimes renewals and checkouts and sometimes localuse as well. More here: http://manual.koha-community.org/3.10/en/reportsfaq.html#statscodefaq Hope that helps, Nicole On Mon, May 20, 2013 at 3:48 PM, Jim Maroon storyp...@gmail.com wrote: Hi, all. I have been poking around in the manual and online, but can't find an answer to this. Where do these statistics show up? Are they included in our general circulation statistics, or someplace else? When we run our reports, there is no place I can see them. Thanks much! Jim ___ 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] Report Help
Thank you! That's a step in the right direction :) I have shared it (in your name) on the Koha wiki for others to benefit from. Nicole On Mon, Apr 22, 2013 at 9:19 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Nicole, you want for each guarantor it's guarantees, Q: it's ok to repeat guarantor information on each guarantee tuple? you could use something like this (put any data you want in first select, and change order by if needed) SELECT IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber, ')'),'') AS guarantor, IFNULL(concat(p.surname, ', ', p.firstname, ' (',p.cardnumber, ')'),'') AS guarantee FROM ( SELECT * FROM borrowers WHERE guarantorid IS NOT NULL ) AS p LEFT JOIN borrowers AS g ON p.guarantorid = g.borrowernumber ORDER BY g.borrowernumber ; Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Apr 22, 2013 at 4:18 PM, Nicole Engard neng...@gmail.com wrote: I'm looking to change this report around. It shows patrons with their guarantor information. I want a report that shows me the guarantees for each guarantor instead. SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') AS guarantor, p.relationship, ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) WHERE p.dateexpiry NOW() GROUP BY p.borrowernumber ORDER BY p.dateexpiry ASC Nicole ___ 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
[Koha] Report Help
I'm looking to change this report around. It shows patrons with their guarantor information. I want a report that shows me the guarantees for each guarantor instead. SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') AS guarantor, p.relationship, ifnull(FORMAT(SUM(a.amountoutstanding),2),'0.00') AS due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) LEFT JOIN borrowers g ON (p.guarantorid=g.borrowernumber) WHERE p.dateexpiry NOW() GROUP BY p.borrowernumber ORDER BY p.dateexpiry ASC Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help With Preferences Manual
Hi all, I got this question today and I realized that the manual is not clear and now I am second guessing myself - can someone help me out with updating the manual and answering this question? - What we want to have happen is that if an item is returned to the checkout library (which is not the owning library for the item) then we want the checkout library to be able to fill a hold on that item by a patron of the checkout library without having to send the item back to the owning library, have the owning library ship it back and then check it out to the patron with the hold. That seems to be what the description in Section 1.1.5.2.11 of the manual ( http://manual.koha-community.org/3.10/en/administration.html#HomeOrHoldingBranch) is describing. However the manual states that this setting Asks: Use the checkout and fine rules of_ and That does not seem to make sense in relation to the description. Since there is such a caution against changing this setting after the initial setup, we want to get it right. Also, I believe that we concluded during training that we would have the IndependentBranches preferences set to prevent so this setting would apply. However I am now confused about the IndependentBranches settings which I thought only applied to what staff can do. When I get to the part of the description in section .1.2.3.2 of the manual ( http://manual.koha-community.org/3.10/en/administration.html#IndependantBranches) that says Prevent will, preventing users from other branch locations from placing holds or checking out materials from library branches other than their own I am left wondering if this will stop all holds by patrons of one library from placing holds on items for other libraries. Or is it just that staff of one library cannot place a hold on another libraries items ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Report Help
I'm trying to get a report to show patrons with overdues and if there is a guarantor I want that to show too. But what's happening is the Guarantees are showing as the Guarantors and the Guarantor is showing 2 times cause he has 2 Guarantees - can someone help me with my SQL: SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') as guarantor, p.relationship, FORMAT(SUM(a.amountoutstanding),2) as due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) left join borrowers g on (g.guarantorid=p.borrowernumber) WHERE p.dateexpiry NOW() and p.surname = 'Meave' group by p.borrowernumber, g.borrowernumber ORDER BY p.dateexpiry asc ; +--+-++-+---++-+--++ | categorycode | dateofbirth | cardnumber | surname | firstname | dateexpiry | guarantor | relationship | due| +--+-++-+---++-+--++ | TRES | 1996-08-24 | P0012129 | Meave | Melina-Maria | 2008-12-04 | | parent | 5.90 | | TRES | 2000-08-30 | P0012128 | Meave | Phoenix-Jonas | 2008-12-04 | | parent | 2.30 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Melina-Maria (P0012129) | | 351.53 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Phoenix-Jonas (P0012128) | | 351.53 | +--+-++-+---++-+--++ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Sorry - I was wrong - not patrons with overdues, but expired patrons - that's what I'm looking for. On Wed, Apr 10, 2013 at 1:25 PM, Nicole Engard neng...@gmail.com wrote: I'm trying to get a report to show patrons with overdues and if there is a guarantor I want that to show too. But what's happening is the Guarantees are showing as the Guarantors and the Guarantor is showing 2 times cause he has 2 Guarantees - can someone help me with my SQL: SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') as guarantor, p.relationship, FORMAT(SUM(a.amountoutstanding),2) as due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) left join borrowers g on (g.guarantorid=p.borrowernumber) WHERE p.dateexpiry NOW() and p.surname = 'Meave' group by p.borrowernumber, g.borrowernumber ORDER BY p.dateexpiry asc ; +--+-++-+---++-+--++ | categorycode | dateofbirth | cardnumber | surname | firstname | dateexpiry | guarantor | relationship | due| +--+-++-+---++-+--++ | TRES | 1996-08-24 | P0012129 | Meave | Melina-Maria | 2008-12-04 | | parent | 5.90 | | TRES | 2000-08-30 | P0012128 | Meave | Phoenix-Jonas | 2008-12-04 | | parent | 2.30 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Melina-Maria (P0012129) | | 351.53 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Phoenix-Jonas (P0012128) | | 351.53 | +--+-++-+---++-+--++ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help
Thank you so much - so simple!! :) On Wed, Apr 10, 2013 at 2:45 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Nicole, what you need to match is p(atron).guarantorid with g(uarantor).borrowernumber, not g(uarantor).guarantorid with p(atron).borrowernumber that is what causing you to get an inverted list. For example this query will list all guarantees with corresponding guarantor (if not null), SELECT patron.surname, patron.firstname, patron.relationship, patron.guarantorid, guarantor.borrowernumber, guarantor.surname, guarantor.firstname FROM borrowers as patron LEFT JOIN borrowers as guarantor ON ( patron.guarantorid = guarantor.borrowernumber ) WHERE patron.guarantorid IS NOT NULL; Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Apr 10, 2013 at 2:28 PM, Nicole Engard neng...@gmail.com wrote: Sorry - I was wrong - not patrons with overdues, but expired patrons - that's what I'm looking for. On Wed, Apr 10, 2013 at 1:25 PM, Nicole Engard neng...@gmail.com wrote: I'm trying to get a report to show patrons with overdues and if there is a guarantor I want that to show too. But what's happening is the Guarantees are showing as the Guarantors and the Guarantor is showing 2 times cause he has 2 Guarantees - can someone help me with my SQL: SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.firstname, ' (', g.cardnumber, ')'),'') as guarantor, p.relationship, FORMAT(SUM(a.amountoutstanding),2) as due FROM borrowers p LEFT JOIN accountlines a USING (borrowernumber) left join borrowers g on (g.guarantorid=p.borrowernumber) WHERE p.dateexpiry NOW() and p.surname = 'Meave' group by p.borrowernumber, g.borrowernumber ORDER BY p.dateexpiry asc ; +--+-++-+---++-+--++ | categorycode | dateofbirth | cardnumber | surname | firstname | dateexpiry | guarantor | relationship | due| +--+-++-+---++-+--++ | TRES | 1996-08-24 | P0012129 | Meave | Melina-Maria | 2008-12-04 | | parent | 5.90 | | TRES | 2000-08-30 | P0012128 | Meave | Phoenix-Jonas | 2008-12-04 | | parent | 2.30 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Melina-Maria (P0012129) | | 351.53 | | STRICT | 1956-09-23 | P0012127 | Meave | Jose | 2008-12-04 | Meave, Phoenix-Jonas (P0012128) | | 351.53 | +--+-++-+---++-+--++ ___ 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] Question on Cataloguing Graduate Thesis
Chris, I don't know how in depth you want me to go here. Your best bet is to use Analytics (which are meant for this very thing). So you catalog the bound edition as '2013 graduate theses' or some such title). Then you catalog each individual theses and link them to the whole. Here's a start on how that works: http://manual.koha-community.org/3.12/en/cataloging.html#cataloganalytics Nicole On Fri, Apr 5, 2013 at 11:45 AM, Chris Nighswonger cnighswon...@foundations.edu wrote: Every year our library receives a single binding which includes copies of all graduate theses submitted and accepted for various degree programs. The question has arisen: Where/how do you catalog multiple graduate theses in a single binding in dewey/loc/foobar? Although the immediate problem begs separate bindings for each thesis, this will probably not happen. Besides, there would be nearly 40 volumes which would not follow that format in any case. Our cataloguers would be very appreciative of any pointers, suggestions, etc. Kind Regards, Chris ___ 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] Holiday Fines
This was a bug that was fixed in 3.8.5 (I think I have the version right). You should upgrade to the latest stable 3.8.x release and see if that does the trick. Nicole On Tue, Apr 2, 2013 at 4:35 AM, Tonny Mwiti tit...@gmail.com wrote: Hi All, Our library is using koha 3.0803000 and we have issues with holiday fines. When I set the calendar to include a unique holiday, users still get a fine inclusive the unique holiday. I have set global system preferences as described in the koha document but the issue still persists. Kindly assist. Regards, Andrew. ___ 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] TEST
Got it. On Sun, Apr 7, 2013 at 7:41 PM, Disney IT Support Center Inquiry disney.it.support.center.inqu...@disney.com wrote: TEST ___ 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] How often do upgrades happen to Koha?
Koha has minor updates every month and major updates every 6 months. Minor updates include bug fixes and small changes. Major updates have new features and enhancements. Nicole On Mon, Apr 8, 2013 at 8:37 AM, Hartman, David W. - GBTS Library david.w.hart...@disney.com wrote: One final question... on average, how frequently is Koha updated (so I can determine support requirements if we have to move to Red Hat as opposed to Debian)? It looks from the schedule I see that every month there is an update. Is that true? As we mentioned in previous thread, our Corporate IT support will only support Red Hat so if I only need to update every 6 months or over, then that would be fine to have them support for that long interval. We are also looking at a hosted solution Thanks again for your time and patience! David W. Hartman ___ 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] Help with Serial Prediction Pattern
Actually, I still have a problem - the volume isn't rolling over. So here's what we want: v. 41, no. 3, iss. 302 (first issue using the serials module) v. 41, no. 4, iss. 303 v. 41, no. 5, iss. 304 v. 41, no. 6, iss. 305 v. 41, no. 7, iss. 306 v. 41, no. 8, iss. 307 v. 41, no. 9, iss. 308 v. 42, no. 1, iss. 309 v. 42, no. 2, iss. 310 v. 42, no. 3, iss. 311 v. 42, no. 4, iss. 312 And here are the three images: pattern: http://screencast.com/t/yeDlMhqAu received: http://screencast.com/t/CkI0VIfMa3S more received: http://screencast.com/t/CecKl1cs On Tue, Mar 12, 2013 at 9:40 AM, Francois Charbonnier francois.charbonn...@biblibre.com wrote: Hi Nicole, I will work on this during the hackfest in Marseille next week. François Le 2013-03-11 02:21, Nicole Engard a écrit : That was it!! Thank you so very much. How would you explain the inner counter in the manual? I'll need to add that info to help others in the future. Nicole On Sun, Mar 10, 2013 at 5:03 PM, Francois Charbonnier francois.charbonnier@**biblibre.com francois.charbonn...@biblibre.com wrote: Hi Nicole, Your inner counters look wrong. Set O and it should work. You have to set up the inner counter only when you start receiving in the middle of a cycle. Here is how the inner counter works with your example : inner counter = 0 vol. 4, no. 1, iss. 796 inner counter = 1 vol. 4, no. 2, iss. 797 inner counter = 2 vol e class=gmail_quote style=ma ex;border-left:1px #ccc solid;padding-left:1ex vol. 4, no. 4, iss. 799 inner counter = 4 vol. 5, no. 1, iss. 802 inner counter = 1 vol. 5, no. 4, iss. 805 inner counter = 4 vol. 5, no. 6, . 796, you need to set up counter = 0 But if it's vol. 4, no. 2, iss. 797, the inner counter should be 1. This way koha knows where the sues because you told Koha to s issue he would have received if you started at the beginning of the receiving cycle. Hope it works! ;^) François Links: -- [1] http://koha-community.org [2] http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://lists.katipo.co.nz/mailman/listinfo/koha [3] http://www.biblibre.com/ [4] http://screencast.com/t/**rtBUMABdEhttp://screencast.com/t/rtBUMABdE [5] http://screencast.com/t/**kW5UcMHF http://screencast.com/t/kW5UcMHF -- François Charbonnier http://www.biblibre.com/ Expert en Logiciels Libres pour l'info-doc Tél: 06 17 45 57 76 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha website slooowww
Hi all, I thought it was my hotel wifi yesterday, but today I'm at a library and the Koha website is crawling - and often timing out. Can someone (I forget who hosts it) look in to that? Thanks a bunch, Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha website slooowww
Yes, I was. I tried it in a different browser and it's loading fine - so I guess this is a browser issue - something is blocking the site :( Nicole On Mon, Mar 11, 2013 at 8:51 AM, Martin Renvoize martin.renvo...@ptfs-europe.com wrote: I assume your talking about http://koha-community.org/ Nicole? If so, it's flying for me... super quick (in the UK at least)? Martin On 11 March 2013 12:42, Nicole Engard neng...@gmail.com wrote: Hi all, I thought it was my hotel wifi yesterday, but today I'm at a library and the Koha website is crawling - and often timing out. Can someone (I forget who hosts it) look in to that? Thanks a bunch, Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Martin Renvoize Software Engineer, PTFS Europe Ltd Content Management and Library Solutions Skype: Mobile: 07725985636 http://www.ptfs-europe.com ___ 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
[Koha] Help with Serial Prediction Pattern
Hi all, I need some help getting a serial to work. The pattern goes like this: vol. 4, no. 1, iss. 796 vol. 4, no. 2, iss. 797 vol. 4, no. 3, iss. 798 vol. 4, no. 4, iss. 799 vol. 4, no. 5, iss. 800 vol. 4, no. 6, iss. 801 vol. 5, no. 1, iss. 802 vol. 5, no. 2, iss. 803 vol. 5, no. 3, iss. 804 vol. 5, no. 4, iss. 805 vol. 5, no. 5, iss. 806 vol. 5, no. 6, iss. 807 Where the volume changes once a year. The issues arrive irregularly throughout the year. I set up the subscription like this : http://screencast.com/t/rtBUMABdE and this: http://screencast.com/t/kW5UcMHF But when I generate serials I get the volume rolling over after number 2: http://screencast.com/t/mG8wS4IX and http://screencast.com/t/e5zfnqkY (ignore the missing dates that's cause I didn't actually receive them). So my question is - what does everyone thing I need to change to get the volume to roll over after 6 instead of after 1? Thanks in advance! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Favor for School Kids in New Jersey, USA
Hi all, This isn't Koha related, but I'd love it if those of you who can would help my cousin learn about geography. Her class in school is collecting postcards from around the world and using the Horton Hears a Who books as the theme. So if you could (before the end of March) mail a postcard to: East Amwell Township School Mrs. Orlando's Class 43 Wertsville Rd. Ringoes, NJ 08551 United States of America And write on the postcard: Hello class, I have spotted Horton for you in (city, state, country etc.) From, YOUR NAME (a friend of Nicole, Amanda's cousin) That would be awesome. I will be sending them from all the places I train this coming month and cards from all states, cities and countries are welcome. Thanks all! Nicole PS. If you participate email me off list and let me know just so I can thank you! :) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Next IRC Planning Meeting for KohaCon 13
This might be a bit easier for converting your time: http://www.timeanddate.com/worldclock/fixedtime.html?msg=KohaCon+Planning+Meetingiso=20130219T19ah=1 Nicole On Thu, Feb 14, 2013 at 6:04 PM, Keener, Nancy nkee...@washoecounty.uswrote: Hello everyone. We will be having our next IRC planning meeting for KohaCon 13 on Tuesday Feb. 19th at 19 UTC. http://weatherarc.com/utc-time-conversion join in here http://koha-community.org/get-involved/irc AGENDA Overview of proposed schedule and discussion How many we are expecting, and what the hotel will provide for free Nevada Library Association Further discussion on what should be presented Plans for a trip somewhere fun Suggestions anyone? When do we need to meet next? We are working on getting information on the wiki and KohaCon 13 web page. I plan to send more emails as we make progress. It is all looking good! Nancy Keener Systems Librarian I.T.O.S.C. Chair Washoe County Library System Reno, Nevada nkee...@washoecounty.us ___ 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
[Koha] Inventory Problems Column
Hi all, I'm wondering what kinds of things might show in the 'Problems' column on the inventory report? I've only ever seen it say 'None'. This comes from a comment on one of my tutorial videos: http://bywatersolutions.com/2012/05/30/inventory-in-koha-3-8/#comment-10075so feel free to reply there or here so everyone can learn the answer. Once I have an answer I will of course update the manual accordingly. Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha Community Survey
Hello all, I was inspired by a recent post on Smashing Magazine ( http://wp.smashingmagazine.com/2013/02/01/wordpress-community-offers-advice-beginners/) about being a part of the WordPress community to write up a similar post for Koha. I'd love to have your input/quotes to share. I will use your responses as the basis for my post. All questions are optional so only fill in the fields that you feel you have something to contribute to. Of course all responses (anonymized) will be shared publicly and opening in the Koha community. I'd love if you'd particpate here: http://survey.web2learning.net/limesurvey/index.php?sid=61682lang=en The survey will only be open for a week so I can get writing, so please answer soon if you want. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Paid For Question
Just checking in on this ... any ideas? Nicole On Fri, Jan 25, 2013 at 9:53 AM, Nicole Engard neng...@gmail.com wrote: I have a question about the paid for notation on the item record. If you see here: http://screencast.com/t/AKOcYNiPBy3n it says that it was paid for by a patron on the 24th of Sept. Then if you look at the patron's record http://screencast.com/t/UzKqgaPayou see that they did make a payment related to that item, but it wasn't a payment for the lost item - it was a processing fee. I'm wondering what makes this note appear in the first place? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Usage Examples
Mark, I am one of the people who updated you via Twitter (Thanks for touching base and the quick response!). I am heading out to a meeting so I can' give you the whole story, but there is a bibliography that might interest you: https://www.zotero.org/groups/koha/items you can search for keywords in the top right and find articles about the different versions of Koha. The Feminist Library is a library in the UK that is using Koha: http://feministlibrary.co.uk/ Once again I'm sure those in the UK can give you more examples. Thanks Nicole C. Engard Documentation Manager On Tue, Jan 29, 2013 at 7:18 AM, Mark Johnson mark.john...@it.ox.ac.ukwrote: Hello Koha Community My name's Mark Johnson, and I work for OSS Watch at the University of Oxford. Recently, we published a document entitled Open Source Options for Education[1] which includes a mention of Koha. After we announced the document's publication, we received some feedback from the Koha community via Twitter that we'd given the wrong link and a misleading example of Koha's usage, so I've come here to make sure that we can set it right. We've not changed the link for Koha to point to koha-community.org, as requested by a message on Twitter[2]. We were also informed that our example of Koha being used at the University of the West of England was in fact LibLime Academic Koha, which is not FOSS, nor has it ever been[3]. This is obviously a misunderstanding on my part. It was my understanding that LibLime was simply a company providing commercial support for the open source Koha product. Am I now correct in believing that it (also?) produces a separate, closed-source product called LibLime Academic Koha? Any background to this would be very much appreciated. Finally, if anyone would be willing to share an example of the open source Koha system being used in their educational institution for me to use in place of the UWE example, particularly if they are based in the UK, I would be very grateful indeed! Many Thanks Mark Johnson [1] http://www.oss-watch.ac.uk/**resources/ossoptionseducationhttp://www.oss-watch.ac.uk/resources/ossoptionseducation [2] https://twitter.com/nengard/**status/293088894000451585https://twitter.com/nengard/status/293088894000451585 [3] https://twitter.com/KohaAloha/**status/293313158410534913https://twitter.com/KohaAloha/status/293313158410534913 -- Mark Johnson Development Manager OSS Watch http://oss-watch.ac.uk __**_ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What notes fields show
Great! Thanks for the clarification. Nicole On Mon, Jan 28, 2013 at 4:23 AM, Zeno Tajoli z.taj...@cineca.it wrote: Hi Nicole, Il 25/01/2013 18:50, Nicole Engard ha scritto: Bug 9162 says that all 5xx (MARC21) or 3xx (UNIMARC) fields show in the title notes tab, but that's not the case, I know that we have had people ask to add notes fields to that. Can someone tell me what fields show in that tab by default - or tell me where to look in the code to find out? I'm documenting the new NotesBlacklist preference and want to say what fields show by default so you know which ones you can exclude. in fact the bug description now is true. The place to check is the routine GetMarcNotes in C4::Biblio. With the line 1712 my $scope; 1713 if ( $marcflavour eq UNIMARC ) { 1714 $scope = '3..'; 1715 } else {# assume marc21 if not unimarc 1716 $scope = '5..'; 1717 } we take all the notes fields. Bye Zeno -- Dr. Zeno Tajoli Dipartimento Gestione delle Informazioni e della Conoscenza z.taj...@cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Paid For Question
I have a question about the paid for notation on the item record. If you see here: http://screencast.com/t/AKOcYNiPBy3n it says that it was paid for by a patron on the 24th of Sept. Then if you look at the patron's record http://screencast.com/t/UzKqgaPayou see that they did make a payment related to that item, but it wasn't a payment for the lost item - it was a processing fee. I'm wondering what makes this note appear in the first place? Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] koha as a cms
I have updated the manual and those changes will be live tomorrow. Nicole On Wed, Jan 2, 2013 at 11:44 AM, Galen Charlton g...@esilibrary.com wrote: Hi, On Wed, Jan 2, 2013 at 2:30 AM, Samuel desseaux samuel.desse...@ecp.frwrote: Hi, I try to use koha as cms, in waiting for our new website. I've followed these links http://manual.koha-community.** org/3.8/en/kohacms.htmlhttp://manual.koha-community.org/3.8/en/kohacms.html and http://wiki.koha-community.**org/wiki/Koha_as_a_CMShttp://wiki.koha-community.org/wiki/Koha_as_a_CMS The instructions in the manual are a bit out of date and work (as written) only for Koha 3 before version 3.4. For more recent versions of Koha, use the instructions in the wiki ( http://wiki.koha-community.org/wiki/Koha_as_a_CMS). I've no error but the content can't be displayed. What i don't understand is pages.tmpl. In /usr/share/koha/opac/htdocs/**opac-tmpl/prog/fr-FR/modules , i've only pages.tt. Do i have to change tt in tmpl? The correct name is pages.tt -- I've fixed an ersatz reference to pages.tmpl in the wiki instructions. Please look at the wiki page again and double-check that your system is referencing pages.tt instead of pages.tmpl. Regards, Galen -- Galen Charlton Director of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web:http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org http://evergreen-ils.org ___ 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] Who at Bywater knows Novelist Select?
Agnes, A few of our partner libraries are using it. I'm not sure how many of them are on this list, but I'll forward your message to them. I can tell you that the feature is documented (with some images) here: http://manual.koha-community.org/3.10/en/administration.html#novelistselect Thanks Nicole C. Engard On Fri, Dec 21, 2012 at 8:01 PM, Agnes Rivers-Moore a...@hanover.ca wrote: Dear all I heard that Bywater created the Novelist integration patch. If I wanted to learn more about how that works, who might I contact? Many thanks Agnes -- CEO/ Chief Librarian Hanover Public Library. 451 10th Ave, Hanover, ON N4N 2P1 Tel: 519-364-1420 Email: a...@hanover.ca Please consider the environment before printing this message or attachments. Support your library! Please consider making a donation, joining the Friends of the Library, or remembering us in your will. -- This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com ___ 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] Help with documentation errors
On Tue, Nov 20, 2012 at 1:29 PM, Chris Cormack chr...@catalyst.net.nzwrote: I don't see any encoding errors just invalid xml, caused by missing tags or badly formed entities. And can you tell me what those missing tags or badly formed entities are? I see properly nested tags in the 3.8 english manual - in fact they're identical to the 3.10 manual at that line and it's not throwing errors. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Do you like the way Koha is sorting facets and facets results ?
Facets used to be sorted on popularity, but that was confusing people because the numbers weren't showing. I did some Amazon and Kohls shopping this weekend and the facets were sorted alphabetically when it came to things like brands. The problem is that Koha doesn't use all pages of results to figure out the facets and popular sites do! So if we only use the first page of the results we can't show true popularity and so I think that's why it was changed to alphabetical a while back. Nicole On Mon, Nov 19, 2012 at 8:00 AM, Mathieu Saby mathieu.s...@univ-rennes2.frwrote: Hello Could some librairians and vendors tell me if they like the way Koha is sorting facets and facets results, on a UX point of view ? Currently, - Results for each facets are sorted alphabeticly. - I can't explain the way factets (Authors, Title, Topics...) are sorted, maybe by popularity, but it is not always the same, depending of the request ! If we look at other catalogues, or non library websites (Amazon...), we don't see the same behavior. - Facets sorting does not change in the same catalogue - Facets results are sorted according to popularity (decrescent occurences), or sometime in a predefined order, sometime both, but never alphabeticly. (in amazon.com , Author and Book series are sorted according to popularity order, but Departement and Format facets in a predefined order. cf. http://www.amazon.com/s/ref=**nb_sb_noss_2?url=search-alias%** 3Dstripbooksfield-keywords=**gamehttp://www.amazon.com/s/ref=nb_sb_noss_2?url=search-alias%3Dstripbooksfield-keywords=game in worldcat, Content and Public in a predefined order, and the others by popularity : http://www.worldcat.org/**search?qt=worldcat_org_allq=** proust http://www.worldcat.org/search?qt=worldcat_org_allq=proust ) If you agree, I can make a patch for sorting facets results by popularity (easy to do) and sorting facets according to a defined order (more complicated for me but I will try...). Regards, M. Saby Rennes 2 University -- Mathieu Saby Service d'Informatique Documentaire Service Commun de Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.s...@univ-rennes2.fr __**_ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Amazon API Changes (again)
On Thu, Nov 15, 2012 at 2:06 AM, Magnus Enger mag...@enger.priv.no wrote: I think after the patch on http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8679 got pushed we are only using the images from Amazon, which is a matter of constructing URLs to the images? Not sure if using the images would be affected by these changes, though. That's what I thought - that the images weren't coming from the API ... but wanted to check. Owen might know best since he made most of these changes. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help needed with report - how to extract subtitle and edition?
This should do the trick: SELECT b.biblionumber, b.author ,b.title, ExtractValue(m.marcxml, '//datafield[@tag=245]/subfield[@code=b]') as subtitle, b.copyrightdate, m.place, m.publishercode, m.isbn FROM items i LEFT JOIN biblioitems m on (i.biblioitemnumber=m.biblioitemnumber) LEFT JOIN biblio b on (m.biblionumber=b.biblionumber) WHERE i.itype='BK' AND i.holdingbranch='VWML' ORDER BY b.author asc Thanks Nicole On Wed, Oct 24, 2012 at 5:51 PM, mh_zalab...@hotmail.com mh_zalab...@hotmail.com wrote: I think in this case you need to make the report using the xml field in biblio items table because the rest of sub fields you will find there Sent from my HTC - Reply message - From: Elaine Bradtke e...@efdss.org To: koha koha@lists.katipo.co.nz Subject: [Koha] Help needed with report - how to extract subtitle and edition? Date: Wed, Oct 24, 2012 11:23 pm I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioitems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 3.8 manual as a single PDF?
Awesome! I'm going to add a link to this to the official page. Thanks so much for this!! Nicole On Wed, Oct 17, 2012 at 5:09 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: On Wed, Oct 17, 2012 at 8:00 AM, Karam Qubsi karamqu...@gmail.com wrote: Hi I think you can download (unofficial ) pdf from the manual translation project here : http://es.koha-community.org/manual/ direct pdf download link : http://es.koha-community.org/manual/files/en/manual.pdf Steve, I also added an updated PDF file for every (english) version of the manual, including master, at http://es.koha-community.org/manual/ Hope that helps, Bernardo ___ 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] 3.8 manual as a single PDF?
We have yet to get the Docbook to PDF script working so there is not yet a PDF of the manual. That said, printing the entire manual (if that's why you want a printer) isn't practical because it's over 500 pages and changes daily :) Nicole On Tue, Oct 16, 2012 at 5:29 PM, Steve Campbell stephen.t.campb...@dartmouth.edu wrote: On the Koha Community Documentation web page (http://koha-community.org/documentation/) one can retrieve the full version 3.2 manual as a single PDF. I have found this handy for global searches of the manual. Does anyone have a link to a similar full PDF for version 3.8? Thanks. Steve Campbell Converse Free Library Lyme, New Hampshire US ___ 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] notifying patrons about holds
Karen, If the patron has subscribed to enhanced messages they do get an email when a hold is ready to be picked up at the library. However you need to have a cron job running to grab and send these holds. More here: http://manual.koha-community.org/3.8/en/opacmyaccount.html#opacmymsgs and here: http://manual.koha-community.org/3.8/en/cronjobsch.html#noticescron Hope that helps, Nicole On Tue, Oct 16, 2012 at 6:01 PM, Kohn, Karen ko...@arcadia.edu wrote: Hello, I just got a note from a student worker who oversees circulation with a question about holds. She said, Question: in Koha we are able to place books on hold so the patron should get an email when the book is checked in and placed on the hold shelf, but this system doesn't actually work. I didn't think Koha was supposed to email the patron automatically that their hold was available. I checked the manual at koha-community.org, and it also didn't sound like there were automatic emails being generated. Can someone confirm this? Thanks. -- *Karen Kohn* Collection Development Manager Education and Sociology Librarian Landman Library Arcadia University 450 S. Easton Road Glenside, PA 19038 ph: 215-572-8528 fax: 215-572-0240 ___ 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] How can I see the Z39.50 sever info for my library in the admin
I also found this: http://manual.koha-community.org/3.8/en/systemfaq.html#publicztarget (that I forgot was in the manual). Nicole On Fri, Oct 5, 2012 at 4:07 PM, Lori Bowen Ayre lori.a...@galecia.com wrote: Have you seen this: http://manual.koha-community.org/3.8/en/additionaladmin.html#z3950admin and this: http://wiki.koha-community.org/wiki/Troubleshooting_Koha_as_a_Z39.50_server =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group Oversight Board Communications Committee / Evergreen (707) 763-6869 // lori.a...@galecia.com Availability: http://doodle.com/loriayre lori.a...@galecia.comSpecializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= On Fri, Oct 5, 2012 at 11:22 AM, Lee Miller lmil...@buttepubliclibrary.info wrote: All, I know that this may sound remedial, but I need some assisatance. I need the following info for my Z39.50 server - can some one please point me in the correct direction? Target Hostname/Port DatabaseUserid PasswordChecked Rank Syntax Encoding Thank you, Lee in Butte Butte Public Library -- Lee Miller Library Director BSB Public Library 226 W. Broadway Butte, MT 59701 406-723-3361 x6301 __**_ 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 ___ 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] Place hold in opac-detail.pl
It needs sign off: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7710 Nicole On Fri, Oct 12, 2012 at 11:16 AM, Hillyard, Cecil chilly...@washoecounty.us wrote: Hi And what about more than 1 specific copy. How is that going? __ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8330 fax: 775-327-8334 -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of kamild Sent: Friday, October 12, 2012 4:55 AM To: koha@lists.katipo.co.nz Subject: [Koha] Place hold in opac-detail.pl Hi, Is in KOHA an option to do reserve a specific copy from opac-detail.pl in table Holdings? greets -- View this message in context: http://koha.1045719.n5.nabble.com/Place-hold-in-opac-detail-pl-tp5729488.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Approve Patron's contact information
An email should be sent to you so that you can see what changes your patron wants to make and then you have to copy and paste the edits from your email in to Koha. There is no automatic update of patron's records as of yet (but I think it's in development). Nicole On Mon, Oct 8, 2012 at 7:58 AM, sheikh303 sheikh...@gmail.com wrote: When a patron edits his/her contact information, it shows that approval is required by the librarian. Need help on how to approve this update request. Or is possible to disable this approval process. thanks. -- View this message in context: http://koha.1045719.n5.nabble.com/Approve-Patron-s-contact-information-tp5729159.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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
[Koha] Thank you oXygen!
Hello all, An update on the manual XML editor situation. I sent an email to the folks at oXygen and explained that I needed a tool for an open source product manual and without any questions or sales pitch they provided me with a license that I will be using to write our Koha manual!! I will write up a blog post about this thanking the kind folks at oXygen, but I wanted to let you all know that I have found a solution to our problem and hopefully won't need another tool ever again (since oXygen is so powerful!). Thanks Nicole C. Engard Koha Documentation Manager ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Approve Patron's contact information
On Mon, Oct 8, 2012 at 11:54 AM, sheikh303 sheikh...@gmail.com wrote: Thanks Nicole. due to lack of manpower for server administration, email service is currently disabled. Perhaps that's why i couldn't find the approval procedure. Is there any other way? No, not at this time. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Restrict Continuous Checking Out
Unfortunately there is no way to set such a rule right now. It might be something to suggest as an enhancement to Koha though. Thanks Nicole On Sun, Oct 7, 2012 at 8:30 AM, sheikh303 sheikh...@gmail.com wrote: Hi there, Is possible to restrict a patron from checking same item twice back to back? A book must be checked by at least one patron before s/he can check it out again. I am using koha 3.02 thanks in advance. -- View this message in context: http://koha.1045719.n5.nabble.com/Restrict-Continuous-Checking-Out-tp5729117.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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] WYSIWYG XML Editor Help
On Sat, Oct 6, 2012 at 7:23 AM, Mason James m...@kohaaloha.com wrote: have you tried increasing the memory, following these instructions? Q: XXE freezes when I try to open large XML files. Is there a workaround for this problem? A: This is probably an out-of-memory error due to the fact that your XML file is very, very, large or contains loads of high-resolution images. By default, XXE is configured to use at most 512 megabytes. This limit can be increased but this requires you to edit a script file using a text editor http://www.xmlmind.com/xmleditor/faq.html#outofmemory Thanks Mason, I'll give that a whirl. Everyone else, I did install Serna but it too has some trouble with the manual and is very hard to read when in WYSIWYG mode. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] WYSIWYG XML Editor Help
Mason's tip seemed to do the trick for now!! :) I will continue to use XXE since it has been good to me (up until now). Thanks again for all the help and recommendations!! Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] WYSIWYG XML Editor Help
Hello all, Back when I started working on the manual someone here recommended XXE Personal Edition which was free for those working on open source projects. Well this is no longer the case. Either because of this, or the size of the manual, I can no longer save the manual when editing it in XXE (or I guess it could be a problem on my computer). Without commentary on my operating system ... I need a recommendation for a free (or cheap) WYSIWYG XML/Docbook editor that will run on Mac OSX. I got some recommendations - one for Lyx, which actually doesn't open or edit XML or Docbook (I have it installed and did try). Another was for Vex which I was able to install, but can't get to open the manual XML file I have. Others have said Oxygen but that's $500+ and I can't afford that. So, my criteria is simple - I need to be able to edit the manual as one document (because of the linking between sections) and the editor has to be WYSIWYG (I don't have time to write out the Docbook Code) and it has to validate Docbook and finally it has to run on Mac. As 3.10 looms closer I really need to get back to editing the manual and adding all of the new features, so send those ideas ASAP! Thanks in advance for any recommendations. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] WYSIWYG XML Editor Help
I'm not sure it's working right for me. Did you have an extension installed? I opened the manual.xml file and I can read and edit it, but it doesn't look right. I'm not able to tell what's a section heading and what's a paragraph. Am I missing something? Nicole On Fri, Oct 5, 2012 at 12:12 PM, Marc Véron ve...@veron.ch wrote: Nicole, I just downloaded a Koha manual snapshot (English) and opened it with LibreOffice. I could edit, add images, save it. However, I did not do much testing, but I think it is worth a try. http://www.libreoffice.org Marc Am 05.10.2012 17:08, schrieb Nicole Engard: Hello all, Back when I started working on the manual someone here recommended XXE Personal Edition which was free for those working on open source projects. Well this is no longer the case. Either because of this, or the size of the manual, I can no longer save the manual when editing it in XXE (or I guess it could be a problem on my computer). Without commentary on my operating system ... I need a recommendation for a free (or cheap) WYSIWYG XML/Docbook editor that will run on Mac OSX. I got some recommendations - one for Lyx, which actually doesn't open or edit XML or Docbook (I have it installed and did try). Another was for Vex which I was able to install, but can't get to open the manual XML file I have. Others have said Oxygen but that's $500+ and I can't afford that. So, my criteria is simple - I need to be able to edit the manual as one document (because of the linking between sections) and the editor has to be WYSIWYG (I don't have time to write out the Docbook Code) and it has to validate Docbook and finally it has to run on Mac. As 3.10 looms closer I really need to get back to editing the manual and adding all of the new features, so send those ideas ASAP! Thanks in advance for any recommendations. Nicole ___ 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Barcodes
Dennis, Just go to Admin Marc Bibliographic Frameworks and alter the subfields on the 952 to say whatever you want. More info here: http://manual.koha-community.org/3.8/en/catadmin.html#marcbibframeworks Nicole On Wed, Oct 3, 2012 at 6:03 AM, Dennis Njuguna cknjug...@gmail.com wrote: Hello Good people I want to change the (label or field) p - Accession Number to read p - Barcode especially when editing/adding items for a book, how do I do that? * * -- Dennis K. Njuguna ___ 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] Lost item statues
There is a long story behind this, but this video hopefully will help you: http://bywatersolutions.com/2012/01/11/managing-lost-statuses-in-koha-3-6/ You can add Lost back in to the framework I think by editing your 952 field. Nicole On Mon, Sep 24, 2012 at 2:22 AM, Dagne Woldie, MS/HS Library Assistant dagne.wol...@icsaddis.edu.et wrote: Hello, i have a problem with editing item, lost, long overdue, lost and paid. as you have seen below the lost statues option is not available. is there a way to add or enable that option Thank you Dagne Woldie Edit item #30145 1. 0 - Withdrawn status 2. 3. 2 - Source of classification or shelving scheme 4. 3 - Materials specified (bound volume or other part) 5. 4 - Damaged status 6. 5 - Use restrictions 7. 7 - Not for loan 8. 8 - Collection code 9. a - Permanent location 10. b - Current location 11. c - Shelving location ___ 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] We need your help
The answer to your question lies in the system preferences :) There is an FAQ about this very problem here: http://manual.koha-community.org/3.8/en/catfaq.html#authorityfaq Nicole C. Engard On Fri, Sep 21, 2012 at 3:28 AM, Dagne Woldie, MS/HS Library Assistant dagne.wol...@icsaddis.edu.et wrote: Hello all, we are using koha 3.8. when we add new records to koha, the personal name text box is not enabled in 100a tag. is there a way to enable or how do we add personal author name. The same problem for adding series statement i.e 440a, Subject add enty personal name 600a, add entry for personal name 700a, Dagne Woldie ICS library Addis Ababa ___ 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
[Koha] Language confusion on the Circ Fine Rules
I recently emailed our partner libraries to ask for some help on http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8366 which asked for some language suggestions and I got this reply from Steve that I thought I should share with you all - I didn't feel that it fit just with the bug report, because it's a bigger issue that he's talking about and I didn't want his comments to get lost. So, here's what Steve (a librarian using Koha) has to say on the topic of the language on the circulation and fine rules: Hi, Nicole, Whew! What a can o' worms. The underlying mechanism at the Home Administration Circulation and fines rules page is very powerful and flexible. The flip side is that it is very complicated. I think you have to look at the whole function: the settings (page) for all libraries and the settings (pages) for individual libraries. I hate to say it, but I'm not sure the difficulty described in these tickets can be fully resolved by a change in wording. I think the pages themselves - all libraries and individual libraries - may need to be revised. Here is a cut at how it might be done. (I know this is not what you are asking for. I apologize for that. But maybe you can get some language changes from this for now, and later someone can look at revising the pages.) When you change the Select a library drop-down menu, you are changing the whole page - a whole set of tables. The set that shows up on the page currently called All libraries sets defaults. I would change the phrase in the selection drop-down from All libraries to Defaults. Then I would change the titles of the tables on this Defaults page as follows: Defining circulation and file rules for all libraries gets changed to Default circulation and fine rules Default checkout, hold and return policy for all libraries gets changed to Default checkout, hold and return policy I would move this table to the top of the page and somehow require some value in the allowed box. Checkout limit by patron category for all libraries gets changed to Default checkout limit by patron category Holds policy by item type for all libraries becomes Default holds policy by item type Then on the pages for when you select a specific library, I would change the tables as follows: Defining circulation and file rules for Your Library does not change except to remove the quotation marks, which are not used elsewhere. Default checkout, hold and return policy for Your Library does not change. Checkout limit by patron category for Your Library does not change. Holds policy by item type for Your Library does not change. Along with these changes, I would add plenty of explanatory text. The rule order text at the top of the page is a very good start. But more explanation is better. And don't forget to update the help screen and the manual, too. Steve Campbell Converse Free Library Lyme, New Hampshire ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] sms configuration
To use SMS you need an SMS Driver. More info on that can be found here: http://manual.koha-community.org/3.8/en/circfaq.html#smsnoticefaq Nicole On Fri, Sep 7, 2012 at 6:19 AM, KLib Tech Support kalib.techk...@gmail.com wrote: Hi, I am using koha 3.8 and I want to activate auto sms for overdue/rent due. Is this possible, if yes please guide me with process. ___ 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] Add filter to patron fines
Thanks Christopher for sharing with us all!! Nicole On Fri, Sep 7, 2012 at 1:25 PM, BRANNON, CHRISTOPHER cbran...@cdalibrary.org wrote: I just posted this on the JQuery library. Hope this is helpful to others. Add a filter to the patron Fines screens * Developer: Christopher Brannon (Coeur d'Alene Public Library), based of original code by Kobi Lidershnider at http://kobikobi.wordpress.com/2008/09/15/using-jquery-to-filter-table-rows/ * Purpose: To help find information in the Account and Pay fines portions of patron Fines. * Status: Completed * Intranet or OPAC?: Intranet * Version: Any //Add filter to fines $(#yui-main div[class='tabs-container'] table).attr(class,filterable); $(iFilter: /iinput type='text' id='FilterTextBox' name='FilterTextBox' /a href='#' class='clear' rel='nofollow' Clear/a/p).insertBefore(#yui-main table[class='filterable']); $(.filterable tr:has(td)).each(function(){var t = $(this).text().toLowerCase(); $(td class='indexColumn'/td).hide().text(t).appendTo(this); });//each tr $(#FilterTextBox).keyup(function(){ var s = $(this).val().toLowerCase().split( ); //show all rows. $(.filterable tr:hidden).show(); $.each(s, function(){ $(.filterable tr:visible .indexColumn:not(:contains(' + this + '))).parent().hide(); });//each });//key up. $(.clear).click(function(){ $(#FilterTextBox).val().keyup(); return false; }); //end fines filter Christopher Brannon ___ 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] Interested in Open Source ILS?
I too replied when they emailed me directly (before it hit the list) and have not heard back as of yet. I'll keep you posted. Nicole On Fri, Sep 7, 2012 at 6:02 AM, MJ Ray m...@phonecoop.coop wrote: Lori Bowen Ayre FYI, I sent them a note commenting on a couple issues that I thought should be corrected (related to how Liblime was presented). As did I, cc'd here so others knew. Anyone had a reply yet? I'm very mixed about it. I'm glad to see more resources like that, but I'm unhappy about several aspects of the presentation. It may be a sign that we need to be more active in our marketing, or it may be wilful misunderstanding, such as they way only three US vendors are called major. Hope that helped, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ 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] Question about Report on Wiki
Checking in again - anyone have any ideas? Nicole On Wed, Aug 29, 2012 at 6:13 PM, Nicole Engard neng...@gmail.com wrote: This question might be for Ian (since he wrote the report) but anyone can probably answer. On this report (http://wiki.koha-community.org/wiki/SQL_Reports_Library#Patrons_with_Staff_Permissions) why doesn't it show staff with edit_catalogue permissions? Is there a change I need to make? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] values for syspref QueryRemoveStopwords
On Tue, Sep 4, 2012 at 11:52 AM, Tomas Cohen Arazi tomasco...@gmail.com wrote: It doesn't have any effect whether you choose one or the other. NoZebra is hard deprecated in Koha 3.8, and that syspref only applies on NoZebra installs. So, should we remove the preference? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha