Re: [Koha] Report help needed

At 09:00 AM 9/28/2015 -0400, Barton Chittenden wrote: Elaine, This query should do what you're looking for: select biblionumber, from biblioitems where ExtractValue( marcxml, '//datafield[@tag=942]/subfield[@code="c"]' ) = ''; Depending on the number of bibs, this could take quite a while to r

Re: [Koha] Disable displaying items from other locations (independent branches)

At 11:26 PM 9/20/2015 +0200, le-grex wrote: Hi there, i have a question about the "independent branches"-feature. I activated it straight after a clean install on a VPS for testing purposes and it worked fine so far. Please, which version of Koha did you install? The "Library Police" page tha

Re: [Koha] Checkbox «Flagged» on subfield visi bil ity framework setup

At 05:01 PM 9/2/2015 -0300, Tomas Cohen Arazi wrote: 2015-09-02 16:54 GMT-03:00 Paul A <<mailto:pau...@navalmarinearchive.com>pau...@navalmarinearchive.com>: At 10:47 PM 8/31/2015 -0300, Tomas Cohen Arazi wrote: El 31/8/2015 2:38 p. m., "Pablo Bianchi" <<ma

Re: [Koha] Checkbox «Flagged» on subfield visibil ity framework setup

At 10:47 PM 8/31/2015 -0300, Tomas Cohen Arazi wrote: El 31/8/2015 2:38 p. m., "Pablo Bianchi" escribió: > > Hi! > > Even I read Koha manual > < http://translate.koha-community.org/manual/master/en/catadmin.html#marcbibframeworks > > (2.4.1.4. Edit Framework Subfields > Advanced constraint valu

Re: [Koha] Library of Congress online services down for maintenance this weekend

At 02:15 PM 8/27/2015 -0400, Galen Charlton wrote: Hi, Various online services of the Library of Congress will be down for maintenance this weekend, including: - catalog.loc.gov - id.loc.gov - the LC Z39.50 server From their announcement (http://z3950.loc.gov/vwebv/ui/en_US/htdocs/help/): Librar

Re: [Koha] Seeking Z39.50 targets for Portuguese material in Marc21 format

At 02:35 PM 8/27/2015 +1000, Bob Birchall wrote: [snip] A google search turned this up - I haven't checked it: http://www.bl.uk/bibliographic/usemarcon.html I just registered for the downloads (Linux and Windows), but should advise you that our antivirus software found that the downloads inclu

Re: [Koha] MARC frameworks

At 07:04 AM 5/6/2015 -0700, mansuralih wrote: Hi, In Default framework, under MARC Structure tag 100 and subfield $a there is a seealso entry such as '100b','100c','100q', etc. Could you please tell me how can i change these values? Which version of Koha are you using? And why are you using "d

Re: [Koha] Search server for children's books

At 12:51 AM 8/20/2015 +, CTS-Programmer 3 (Paul Dokken) wrote: We have been using the Seattle Public library Z39.50 server and it finds most of what we want. There are some books that are not found. Specifically this one, 978-0060573829. Does anybody know of a good server I could use for

Re: [Koha] follow up on: transfers to receive- home/holding branch issues

Disclaimer: untested; we are not a lending library so cannot double check all possible repercussions. However, if you are convinced that your problem is limited to / caused by case sensitivity of 'homebranch' and 'holdingbranch' in your *items* records, the easy solution is to edit MySql: my

Re: [Koha] Slash (/) following title

At 09:54 AM 8/13/2015 +1200, clint.deckard wrote: [snip] When I first came across the / and saw it in the OPAC I assumed it was an error with my migration. However it was in the original records and that lead me to explore its history and usage. The / might assist readability in a card catalogue

Re: [Koha] Generating dollar value reports

At 03:13 PM 7/22/2015 -0700, Michele Martin wrote: I'm a newbie, so I apologize if this is a dumb question, but I'm under a time crunch and need some help. How can I run a quick report that tells me the dollar value of our library's inventory? If you record the price in "items": SELECT SUM(pr

Re: [Koha] Display of Scrolling New Arrivals List on Koha OPAC

You seem to have "lost" your catalogue (404) at . P. At 10:19 PM 7/20/2015 +0530, vinod mishra wrote: Dear Koha users, It is nice to share one trick/Jugar to display the scrolling list of New Arrivals in your library OPAC or even at your library website. Go

Re: [Koha] 12.04 LTS to 14.04 LTS upgrade - any caveats?

At 10:49 AM 7/20/2015 +0100, Greg Ashe wrote: Hi there My Koha is currently on Ubuntu 12.04.5 LTS which is prompting me to "do-release-upgrade" to 14.04.1 LTS. Anyone done this? Is it seamless? Any issues for Koha installation? Not done a "upgrade", but certainly use 14.04 (clean install) as

Re: [Koha] Fwd: Converting MARC 21 from AACR2 to RDA

At 11:24 AM 7/7/2015 +1000, Bob Birchall wrote: On 07/07/15 04:05, Paul A wrote: On a sort of related point, our cataloguers have recently brought to my attention the "new" RDA "264 - Production, Publication, Distribution, Manufacture, and Copyright Notice" field, whic

Re: [Koha] Fwd: Converting MARC 21 from AACR2 to RDA

On a sort of related point, our cataloguers have recently brought to my attention the "new" RDA "264 - Production, Publication, Distribution, Manufacture, and Copyright Notice" field, which some of the Z39.50 imports appear to be using *instead of* 260 -- they tell me they're seeing it more and

Re: [Koha] Koha Fundraising Committee Draft Terms of Reference

thanks. The Wiki page seems to call them "terms of reference" rather than "bylaws", hence my confusion. Best -- Paul Thanks, Brendan On Sat, Jul 4, 2015 at 7:16 AM, Paul A <<mailto:pau...@navalmarinearchive.com>pau...@navalmarinearchive.com> wrote: At 05:53

Re: [Koha] Koha Fundraising Committee Draft Terms of Reference

At 05:53 PM 7/3/2015 -0700, Brendan Gallagher wrote: Hi All - Just a reminder - the general IRC meeting is in a few days - we (the committee) need your comments and thoughts on the bylaws before that meeting. Brendan, Firstly, thank you for all you are doing. A couple of points re: the draft

Re: [Koha] Swapping Addresses

At 09:03 PM 6/30/2015 +0530, Indranil Das Gupta wrote: On Tue, Jun 30, 2015 at 8:46 PM, Via Vitae Solutions wrote: > Bob Ewart writes: > >> >> In south Florida we have a lot of snowbirds who spend the winter here >> and the summer up north. >> >> Is there an easy way to swap the main and altern

Re: [Koha] handling 008 in marc21

This might also depend on MARC frameworks : {whatever} framework structure : Tag 008 subfield structure : Edit subfields constraints : Display more constraints : Advanced constraints : Default value: Best -- Paul At 12:34 PM 6/25/2015 -0300, Bernardo Gonzalez Kriegel wrote: Hi Gaetan, this

Re: [Koha] OPAC - materials specified (MARC21 952$3)

ntial data, although why anyone would do so beats me... ;=} Best -- Paul Katrin Am 21.06.2015 um 00:04 schrieb Paul A: > I'm wondering if many libraries use "materials specified" (MARC21 > 952$3)? We do, particularly for serials, but the data is only available > to sta

[Koha] OPAC - materials specified (MARC21 952$3)

I'm wondering if many libraries use "materials specified" (MARC21 952$3)? We do, particularly for serials, but the data is only available to staff and does not appear in the OPAC. So I have modified our OPAC display to add the extra column (see e.g.

Re: [Koha] new import

At 10:21 AM 6/10/2015 -0400, Scott Owen wrote: "appears to pull up a basic Koha version 3.03 -- which is somewhat out of date." --- thanks, I'll keep that in mindI've been using that version for a couple years now at another school, and it's rock solid. If it ain't broke.. [there's no

Re: [Koha] new import

At 09:36 AM 6/10/2015 -0400, Scott Owen wrote: Hi all, I just imported a collection (from Winnebago-Spectrum) to Koha for one of my schools. I have noticed that we seem to have quite a few biblios / records that we have "no items available" for. ie: one item will show as: Availability: No items a

Re: [Koha] Help! Software Error

At 01:13 PM 6/3/2015 +1200, Robin Sheat wrote: Paul A schreef op di 02-06-2015 om 19:48 [-0400]: > How do you "slow it down"? To the best of my knowledge it's an on/off > choice. See > <https://developers.google.com/webmasters/control-crawl-index/docs/robots_txt&g

Re: [Koha] Help! Software Error

At 11:30 AM 6/3/2015 +1200, Robin Sheat wrote: Paul A schreef op di 02-06-2015 om 09:27 [-0400]: > And I must admit that "google is getting my goat." Woodpeckering may > be a > fact of modern life, but at several million entries per day, there's > got to > be a

Re: [Koha] Help! Software Error

At 11:12 AM 6/2/2015 +1200, Robin Sheat wrote: schnydszch schreef op vr 29-05-2015 om 05:17 [-0700]: > And oh yes once the bloated error log was deleted and the server > restarted, > the Koha ILS was already accessible. I'm particularly curious if that > really > is the case. [snip] As for webc

Re: [Koha] help to

At 07:11 PM 5/12/2015 +0100, Elaine Bradtke wrote: Also make sure the field in each record contains the collection code exactly as you have it in the LOC authorised value list, and the CCODE authorised value list. It is case sensitive. And I would add that it is sensitive to blank spaces i.e. '

Re: [Koha] Anyone using Firefox ESR (Extended Support Release) sucessfully for staff client access?

We use ESR (currently 31.4, although I'm aware that 31.6 has been released -- just not had time to see what they've changed) and have not experienced the problem (dropdowns) you appear to have. Note that we use Koha 3.8.24 in production, but never found browser problems during testing of 3.16/3

Re: [Koha] Help 404 File Not Found / Files Missing

At 02:16 PM 3/18/2015 +, Craig Butosi wrote: Hi all, Koha 3.18.04 on Ubuntu 3.13.0. Not sure what version of Ubuntu that might be, sounds more like the recent security kernel update ;=} Regardless, are you using Apache 2.2.x or 2.4.x ? Paul I had a feeling I'd be seeing this on lists

Re: [Koha] Help - kind request

At 05:32 PM 3/11/2015 +0200, Barbara Aristidou wrote: Dear All, Hello I am Barbara from Cyprus University of Technology Library, and I would appreciate your help. I would like to know if there is a way of retrieving a report from KOHA, which will give me the amount of records completed in asso

Re: [Koha] Koha XSLT Editing - Hyperlinking the Uniform Titles Element

At 06:20 PM 3/2/2015 +, Craig Butosi wrote: Hi Everyone, Thanks to all who have replied regarding XSLT editing in Koha. It appears that the syntax is the source of my confusion - something to work on! A relatively complete "cheat sheet" can be found at

Re: [Koha] Catalogue - SQL Report Help

team could help me ?? Hoping to get some solution. Thank You Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. On Thu, Feb 26, 2015 at 8:04 PM, Paul A <<mailto:pau...@navalmarinearchive.com>pau...@navalmarinearchive.com> wrote: At 11:00 AM 2/26/2015 +0530, SATISH wrote:

Re: [Koha] Catalogue - SQL Report Help

At 11:00 AM 2/26/2015 +0530, SATISH wrote: [snip] And am looking for help for generating unique records (biblio) after merging both BK and BB. I am trying with following sql, but throwing errors. Can you please help me over here. --

Re: [Koha] Koha indexing - files

At 01:26 PM 2/20/2015 +1300, Robin Sheat wrote: Chad Roseburg schreef op do 19-02-2015 om 15:14 [-0800]: > We are considering mounting the index files to a separate high-performance > disk array in hopes of improving performance during the indexing process -- > has anyone experimented with someth

Re: [Koha] OPAC website blank

At 06:14 PM 2/17/2015 -0700, iera89 wrote: this is what i get in the system log.. We noticed that one... All you need is a 0 byte file. $ su koha (or whatever your Koha user name is) $ touch /usr/share/koha/opac/htdocs/opac-tmpl/bootst

Re: [Koha] [Koha-devel] Koha development

Marshall, Another "numbers source" that might be helpful to you is Best regards -- Paul At 11:48 AM 2/12/2015 -0300, Tomas Cohen Arazi wrote: Marshall, I don't think we can provide you with that information in that time frame. We c

Re: [Koha] Installazione non riuscita

At 09:12 PM 2/8/2015 +, Michele wrote: Salve, spero ci sia qualche italofono in "ascolto": Ho seguito questa guida http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages e tutto fila liscio fino alla web installation. Apro http://library-intra.myDNSname.org:80 o localhost, ma mi dÃ

Re: [Koha] Fwd: Facets missing on fresh dev install of 3.18.3

At 01:25 PM 2/3/2015 -0500, Cindy Murdock Ames wrote: Yep, with use_zebra_facets=0 I can see author facets: http://imgur.com/lj7v0Uw And thanks Katrin, I'm sorry you're having the same problem but it makes me feel a bit better knowing that it's not just me! For what it's worth, here's my notes

Re: [Koha] Koha 3.18.3 released

At 09:40 AM 1/23/2015 +1300, Chris Cormack wrote: The Koha release team is proud to announce the release of Koha 3.18.3. Chris -- thank you and everyone involved. Installed like a dream ... Best -- Paul P.S. a little typo in the "download[s]" below -- I think it should be

Re: [Koha] FW: Acquisition Help

The question might have been more specifically about tracking donors. We put them directly into 952$e (which we've re-labeled as 'Source - donor') and have an authorized value list of donors. As a charity (we have perhaps 98% of our holdings from donors) so this also allows us to produce "tax-

Re: [Koha] Update a field using SQL

At 01:55 AM 1/9/2015 +, CTS-Programmer 3 (Paul Dokken) wrote: I was able to get the query to run in PHPAdmin after changing to the correct table name. I was not able to get the corrected query to run in MySQL Workbench though. Try: UPDATE items SET price='2.00' WHERE barcode LIKE '37

Re: [Koha] Adding accession number

At 04:48 PM 12/16/2014 +0200, Johnstone Selemani wrote: Dear All, Does this mean that it is not possible to have both the barcode and create room for the accession number in another column? Thanks, How about using 952$i -- it's defined as "inventory number" but you can easily modify that in

Re: [Koha] Catalogue - SQL Report Help (Paul A)

>',b.title,'') AS "Item Title", b.author, t.editionstatement, t.publishercode, t.isbn, count(i.itemnumber) AS "Copies" FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber ORDER BY Copies ASC Regards

Re: [Koha] Catalogue - SQL Report Help

At 12:09 AM 12/11/2014 +0530, SATISH wrote: [snip] how to achieve for the same tables, for each collection ( as per collection code). Because, at various time intervals, library inspection team here is most interested in knowing how many unique titles and counts as a whole library and also by co

Re: [Koha] CSRF issues

At 06:27 PM 12/1/2014 -0300, Larry Letelier wrote: Hi Liz, Everybody: Carlos publish the issue here: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13367 And I get a great big, red "You are not authorized to access bug #13367" even after I log in... Best -- Paul Thanks to all,

Re: [Koha] Zebra rebuild frequency

At 12:53 PM 11/15/2014 +1300, Mason James wrote: On 2014-11-15, at 9:49 AM, Paul A wrote: > At 04:20 PM 11/14/2014 +, Tomas Cohen Arazi wrote: >> Paul, I'm sorry you suffered that on your Koha, but I've never seen it. I'm >> only aware of a situation that

Re: [Koha] Zebra rebuild frequency

At 04:20 PM 11/14/2014 +, Tomas Cohen Arazi wrote: Paul, I'm sorry you suffered that on your Koha, but I've never seen it. I'm only aware of a situation that could trigger that on NORMARC (recently fixed) using DOM indexing. [snip] > > > 3.8.5 (production) and from my test notes 3.12.various

Re: [Koha] Zebra rebuild frequency

At 01:42 PM 11/14/2014 +, Tomas Cohen Arazi wrote: I see a couple situations when you could need a reindex: - An upgrade explicitly states the need for it - Changes on the index definitions - Changing from GRS-1 to DOM indexing - Weird/unexpected search results 3.8.5 (production) and from

[Koha] Saving a new item type

I'm looking for some help please having come up against a brick wall. We defined a new "Item Type" "Files and Binders" code 'FB', made a new Framework structure, and entered a few biblios/items to verify it. Appears to work, see

Re: [Koha] Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.

At 11:20 AM 10/5/2014 +, Mohamed Fekry Negm wrote: Hi i got this error Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064. in version 3.16 + ubuntu 14.04 in opac-user.pl any help Is this just for one particular name/pw? All users? Do you get the error

Re: [Koha] Shellshock

At 02:28 PM 9/26/2014 -0400, Steven Nickerson wrote: With the finding of the most recent "Shellshock" vulnerability with the BASH shell, I'm wondering If Koha uses the BASH shell in any way? I'm pretty sure it does not, but just wanted to make sure. I realize that the Linux system Koha is runn

Re: [Koha] Improving Search Results

At 04:32 PM 9/25/2014 -0500, Coehoorn, Joel wrote: [snip] The point of this is that, from our librarians perspective, without a better search experience, Koha is "broken". Those are their words, not mine. Here's the thing: when I run a search in Koha, I do get back lots of results from our catal

Re: [Koha] inclusion of a detailed typical cron jobs section in the wiki

At 05:35 AM 9/6/2014 +, Indranil Das Gupta wrote: I was reading http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git [snip] I mean, there are two sides to this - a) people running a dev install are expected to know what they are doing; and b) someone wanting to get started / simply part

Re: [Koha] Koha used 100% cpu

At 11:24 AM 8/14/2014 +1200, Robin Sheat wrote: Carlos Rodrigo Cordova Sandoval schreef op wo 13-08-2014 om 10:52 [-0400]: > have a problem with our koha 3.16.02 installed on debian 64bit 7x and > has > 45,000 records and 157,000 items, our koha uses 100% of cpu. view > image. It's hard to tell

Re: [Koha] Updated 'Koha as a CMS' instructions for bootstrap opac theme

At 06:52 PM 8/7/2014 +, Indranil Das Gupta wrote: Hi, Thanks to Nguyễn Quốc Uy's recent post on a FB Koha forum, I decided to take a look at the "Koha as a CMS" wiki page. I found the instructions are still based on the 'prog' template which is already deprecated. Are they really "depr

Re: [Koha] Biblio appears twice (absolute duplicate down to timestamp and biblio and control numbers)

At 09:59 PM 7/14/2014 +0100, Elaine Bradtke wrote: I've downloaded and deleted the good record. The bad one still appears in the search results, but when I click on the link I get Error 500 Internal Server Error Internal Server Error Guru Meditation: XID: 1250605665 Varnish cache server You'l

Re: [Koha] List compromised?

At 08:43 AM 7/11/2014 +, Indranil Das Gupta wrote: Hi, On Fri, Jul 11, 2014 at 6:52 AM, Fridolin SOMERS wrote: > I think an hotmail account has been hacked and answers to the list : > rite2cflores at hotmail dot com > > Don't know if there is a way to send a request to hotmail. ab...@outlo

[Koha] List compromised?

[off-topic to some extent] For the last few days, I have been spammed every time I post to this list -- by young ladies trying to "date" me. I'm flattered -- coming up 75 and uglier than sin -- but just wondering if it's only happening to me? Best -- Paul __

Re: [Koha] Framework does not work [was: Koha Digest, Vol 105, Issue 23]

t line so it is more specific > than "Re: Contents of Koha digest..." ^^^^ [snip] > From: Paul A > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Framework does not work > Message-ID: > <5.2.1.1.2.20140709181536.027dc...@pop

Re: [Koha] Framework does not work

At 05:51 PM 7/9/2014 -0400, Morsy, Amal wrote: Hallo all, I have downloaded a fast framework guided by Nicole Engard it look good except that all the field and the sub-fields that I added are not working which means I can’t add any text to it. Please advise as the default framework does not hav

Re: [Koha] call number sort problem

At 09:24 AM 7/8/2014 +0200, Fridolin SOMERS wrote: Yes, it's this one. Run it with "--help" for manual. paul@-:/usr/share/koha/bin/maintenance$ ./touch_all_items.pl --help You need to install the perl-doc package to use this program. My sandbox is busy with non-Koha development at the mome

Re: [Koha] call number sort problem

At 09:36 AM 7/7/2014 +0200, Fridolin SOMERS wrote: Hie, If you changed the default classification source, it will not affect the actual classification source in items, nor the items.cn_sort. You may use the script touch_items.pl to edit all items and so recompute the items.cn_sort. I can't

Re: [Koha] How to stop series title volume enter Authorities

At 03:04 AM 7/7/2014 -0700, Iming Chan wrote: Hi Paul, Thanks for your response. By following your suggestion, we need to predetermine whether each series title is a new heading. Our cataloguers (so I'm told), always check the 1**, 4**, 6** and 7** authority entries -- it's an intrinsic part

Re: [Koha] How to stop series title volume enter Authorities

At 04:53 AM 7/6/2014 -0700, Iming Chan wrote: [snip] At this moment, it is a pain that you have to remove volume designator on a new Series Title authority. Once this is done, you can then continue to work on subsequent volumes of the same series! Surely, there must be a way to instruct Koha no

Re: [Koha] patron categories [bulkmarcimport]

At 11:43 PM 7/4/2014 -0300, Tomas Cohen Arazi wrote: Eric, the problem seems to be MySQL 5.6, I haven't got through a detailed review (I don't have it for testing right now) but there are several changes since MySQL 5.5, notably several default configurations and other backwards incompatible chan

Re: [Koha] FW: Request to be added as Koha Support Provider

At 11:17 AM 6/29/2014 +, Martin McGovern wrote: [snip] We have a link to http://www.koha-community.org on our main Koha web page so we are fulfilling our obligations as per the "How to get listed" page on koha-community.org. On your page

Re: [Koha] Zebra Rebuild error...

.) Best -- Paul (sorry for delay; koha has been on the back-burner due to other priorities) Many thanks, Layale. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Paul A Sent: Friday, June 20, 2014 4:55 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha

Re: [Koha] Zebra Rebuild error...

At 02:41 PM 6/20/2014 +0300, Layale Bassil wrote: Hello Phillip, Thanks a lot for the support. Yes I used to be able to rebuild Zebra many times, and before getting the error, I did many rebuilds. Since I had no root privileges, I asked the support team to do the rebuild using the sudo -s an

Re: [Koha] possible bug

At 10:36 AM 6/11/2014 +0200, Hugo Agud wrote: Dear all Before opening a bug, I wish to check with you one issue with attach item. (I have checked bugzilla and we have not been able to find a bug like this) Koha 3.14.3 We have moved one item from one bib record to another using 'attach item' and i

Re: [Koha] maintenace redirect on first installation.

At 09:21 AM 6/10/2014 -0400, Mark Tompsett wrote: Greetings, It is still recommended to use Ubuntu 12.04 LTS. There are still some glitches with Ubuntu 14.04 LTS, though they have been also documented here: http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Appendix_B:_Troubleshooti

Re: [Koha] Technical help with Frameworks

You might want to consider, as a "labour saving possibility", editing a copy of the "Fast Add Framework" (add/subtract the few fields that are [ir]relevant to your needs) rather than attacking the default framework in all its glory. In this manner, you can *probably* ignore the Koha to MARC map

Re: [Koha] Report help needed

It could be just the way that my email client is formatting characters, but you may have a problem with the " and ' (double and single quote marks.) I read them below as “, ”, and ’ Maybe you used a text editor that allows "curlies" rather than "straights"? Best -- Paul At 05:57 PM 5/

Re: [Koha] Looking for help with a report

At 08:25 PM 5/1/2014 -0400, Steven Nickerson wrote: Thank you Nick, That's close...at least it gets me my list in the pull-down but none of them return results, I think because the itype field in items contains the "code" and not the "description", right? I actually prefer the description

Re: [Koha] Empty shelves

gton, DC 20011 (202) 387-0309 x1745 <mailto:kbro...@ccpcs.org>kbro...@ccpcs.org http://www.ccpcs.org/library/ On Wed, Apr 16, 2014 at 11:40 AM, Paul A <<mailto:pau...@navalmarinearchive.com>pau...@navalmarinearchive.com> wrote: Help requested, please -- the MySQL part of my brain

Re: [Koha] What is a "reservoir"

At 10:27 AM 4/17/2014 +, viktor.sa...@regionhalland.se wrote: +1 for cache (even if we maintain a swedish translation that gives us the chance to chose something that works better) I'm not too worried about what it's called, but how do you manage it? The manual suggests: To cle

[Koha] Empty shelves

Help requested, please -- the MySQL part of my brain is obviously not at the right caffeine level. Over the years, we have used a lot of "shelves" (authorized values, mostly temporary boxes) and now I need to identify the "empty" ones as a cleanup/caretaking excercise. The following SQL quer

Re: [Koha] How to clean Koha imported records?

At 04:17 PM 4/7/2014 +0300, Layale Bassil wrote: [snip] Thanks a lot for your valuable explanation... well your explained my case perfectly well. I cleaned the data by truncating the needed tables and now I am organizing my holdings into tag 952 as you suggested. That's fine for the 952s in ma

Re: [Koha] Framework Question

At 10:39 AM 4/4/2014 +1300, Robin Sheat wrote: Nicole Engard schreef op do 03-04-2014 om 09:46 [-0500]: > If I delete a framework that is being used what will happen if I go to > edit one of those bib records? Will it just use Default? [snip] If a field is made mandatory, it might reject the sa

Re: [Koha] Homebranch in biblio record

At 07:45 AM 3/29/2014 -0700, Sander898 wrote: [snip] I'm looking for a way to put the indication of the homebranch (Library1 or Library2) in the biblio record, not only in the item of the record (like the 952 field). For the logic of MARC (and Koha), the 'homebranch' is *not* a biblio attribut

Re: [Koha] Upgrading Koha from 3.06 to 3.14

At 11:25 AM 3/27/2014 +, Vinod Kumar Mishra wrote: Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-commun

Re: [Koha] Zebra Indexing and stop words

At 07:02 PM 3/26/2014 +0100, Fridolin SOMERS wrote: The stop words are indeed obsolete, they where used by NoZebra mode, which has been removed in 3.14. Is 245 second indicator not used at all? MARC definitions give it as: Second Indicator Nonfiling characters 0 - No no

Re: [Koha] Frameworks

At 11:38 AM 3/26/2014 +1300, Robin Sheat wrote: Paul A schreef op di 25-03-2014 om 18:13 [-0400]: > a) Does anyone know in the staff "Add MARC record" page > (/koha/cataloguing/addbiblio.pl), how to make the "default" framework > totally disappear? If not, how to se

[Koha] Frameworks

A dual question if I may: a) Does anyone know in the staff "Add MARC record" page (/koha/cataloguing/addbiblio.pl), how to make the "default" framework totally disappear? If not, how to set an alternate framework (say, BKS) as the "option selected" in the drop down box? Our cataloguers have,

[Koha] Nonfiling characters and sorting

I'm not sure if it's just our catalogue, so would ask for confirmation (or denial) by others before exploring further. In both OPAC and staff interface, the "sort" drop-down defaults to 'relevance', but for longer pages users and staff sort by 'title A-Z'. Normally a biblio with a 245 second i

[Koha] German Z39.50

I'm looking for a German Z39.50 server. The Deutsche Nationalbibliothek has dropped Z39.50 in favour of SRU. I can connect to Gemeinsamer Bibliotheksverbund (GBV) server z3950.gbv.de on port 20012 (UTF8), requesting Marc21/USMarc, using database gvk. This will bring me in (at least some) resul

Re: [Koha] Borrowers DB file for offline circulation

At 09:28 AM 2/20/2014 +0500, Saira Asghar wrote: Hello Everyone If we are using offline circulation, We need borrowers DB file. Any one can please tell me that how we can get this DB file from database? I am using ubuntu based koha version 3.14.01. Have you tried a report such as: SELECT * FR

[Koha] Add 952$3 to OPAC details

Is there any quick way to get the OPAC details page to show items.materials (952$3) without editing opac-detail.pl and opac-detail.tt? Thanks, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mail

Re: [Koha] SECURITY release: MARC::File::XML 1.0.2

At 06:32 PM 1/22/2014 -0500, Mark Tompsett wrote: Greetings, Paul A. asked Galen: Could you please advise on 1.0.2 versus 0.92-1 -- the devil is always in the details. You should have noted that Galen had previously given a URL: https://metacpan.org/release/GMCHARLT/MARC-XML-1.0.2 Click

Re: [Koha] SECURITY release: MARC::File::XML 1.0.2

At 12:31 PM 1/23/2014 +1300, Robin Sheat wrote: [snip] For checking what is actually installed, you want apt-cache policy, e.g. [snip] The *** indicates that I have 1.0.1 installed, libmarc-xml-perl: Installed: 1.0.2-1koha1 Candidate: 1.0.2-1koha1 Version table: *** 1.0.2-1koha1 0

Re: [Koha] SECURITY release: MARC::File::XML 1.0.2

At 03:22 PM 1/22/2014 -0800, Galen Charlton wrote: Hi, On Wed, Jan 22, 2014 at 3:15 PM, Paul A wrote: > Could you please advise on 1.0.2 versus 0.92-1 -- the devil is always in the > details. All versions of MARC::File::XML prior to 1.0.2 are subject to the vulnerability, includi

Re: [Koha] SECURITY release: MARC::File::XML 1.0.2

At 10:32 AM 1/21/2014 -0800, Galen Charlton wrote: Hi, I have uploaded [1] version 1.0.2 of MARC::File::XML, a Perl module which is used by Koha. This is a security release that repairs an XML external entity (XXE) vulnerability. [snip] Hi Galen - I've been keeping an eye open for this release

Re: [Koha] only logged users open digital documents

At 10:41 AM 1/14/2014 +0100, Fischer, Katrin wrote: Hi Izar, you can catalog digital resources in Koha, but it's currently not possible to control access to the files. Correct ... but you can put the files in a "protected" directory (.htaccess, LDAP, whatever.) Best - Paul Katrin > --

Re: [Koha] Enlist As Koha Support Vendor

At 05:52 PM 1/9/2014 +0530, Hemant Shetye wrote: Hi MJ, We added the visible link of Koha community website on our website http://www.informindia.co.in/iil_productServices.htm#Koha Please check and add our Company name on Koha paid service provider list. Maybe trivial, but why not make the Ko

Re: [Koha] how do I use z3590 with coha for shared cataloguing from Italian libraries?

At 11:05 PM 1/8/2014 +0100, La Biblioteca del Garibaldi wrote: [snip] For example how do I get to do shared cataloguing through z3590 protocol? After setting up I only see a few US libraries. Famous, prestigious but at the moment of no help to me. I need to catalogue Italian books from Italian

Re: [Koha] KOHA [no encuentra ningún registro]

At 03:25 PM 12/23/2013 +, augusto recuero wrote: Buenas Tardes escribo debido a que tengo un problema al buscar las catalogaciones, al buscar me dice que no encuentra ningún registro , revise los logs de base de datos y del sistema y nada, e incluso ingreso con mi usuario y lo autentica en

Re: [Koha] Importing Koha Database to a new install

At 01:37 AM 12/23/2013 -0800, Phillip Ponchot wrote: Thanks David, you've been very kind to help me. This gives me some idea of what to do and I'm not against trial and error which I will have time to do now that I figured out a way to recover the old server. Probably anathema, certainly 1-2

Re: [Koha] Koha Rebuild - Looking for the man behind the curtain

At 02:44 PM 12/18/2013 -0800, Phillip Ponchot wrote: I'm installing a new Koha Server on Unbuntu o replace a dying server and I thought I could get some pointers here concerning the process. I have loaded Unbuntu 12.04 LTS Server and will be installing the Koha package on the server tomorrow. Af

Re: [Koha] Koha Users of North America Email List

At 02:44 PM 12/16/2013 -0600, Nicole Engard wrote: Can we also get this list added to the list of mailing lists on the Koha site? No suggestion of a "fictional conspiracy theory", but a couple of days ago we were happy to see that Koha belongs to the international Koha community, and that [Am

Re: [Koha] Koha wins trademark stoush with US defence contractor

At 11:52 PM 12/13/2013 +0800, 毛慶禎 wrote: Hi, According iTWire, it is a good news to keep Koha free. http://www.itwire.com/business-it-news/open-source/62619-koha-wins-trademark-stoush-with-us-defence-contractor My congratulations to the Horowhenua Library Trust, Katipo, Chris Cormack a

Re: [Koha] Problems with z39.50 search results from Library of Congress

At 12:06 PM 12/12/2013 -0500, Owen Leonard wrote: > 978-1594631764 > 978-0316176484 For what it's worth, I get results for these numbers if I manually remove the hyphen. I too get no results from the 10-digit version. Also, for what it's worth, title: And the Mountains Echoed (Hosseini, Khale

<    1   2   3   >