- Koha - lists.katipo.co.nz

Re: [Koha] Zebra rebuild error
by Paul 30 Aug '13

30 Aug '13

At 11:47 AM 8/30/2013 +0530, rocky bang wrote: >hi everyone, >I have koha 3.8 install on server. It would be helpful if you could be a little more precise: 3.8 - which release, 3.8.1 ... 3.8.17 ? server - what operating system and version? Your own? Hosted elsewhere? VM? kohaclone - why? and how set up? You say at the end of your email that you are having problems "in production", but you also state "Zebra biblio directory = /etc/conf/koha-dev-domv/var/lib/zebradb/biblios" which does not look like a "production" environment... You obviously have a fairly sizeable db (21,928 biblios). Has this been indexable on any other version of Koha? Where did it come from? And when was it last "useable"? You tried misc/migration_tools/rebuild_zebra.pl -b -r -v (obviously with partial success), but *perhaps* a more normal "production" environment would use ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x We've been running a totally stable 3.8.5 in production for about a year now (so might just be able to help) but your environment looks very, very different. Paul >I tried to reindex the zebra server using following commands. >export KOHA_CONF=/path to .xml file >export PERL5LIB=/path to kohaclone > >perl misc/migration_tools/rebuild_zebra.pl -b -r -v > >and it starts reindexing but i got following errors: > >Zebra configuration information > >================================ > >Zebra biblio directory = /etc/conf/koha-dev-domv/var/lib/zebradb/biblios > >Zebra authorities directory = >/etc/conf/koha-dev-domv/var/lib/zebradb/authorities > >Koha directory = /opt/kohaclone > >BIBLIONUMBER in : 999$c > >BIBLIOITEMNUMBER in : 999$d > >================================ > >skipping authorities > >==================== > >exporting biblio > >==================== > >21901.................................................................................................... > > >Records exported: 21928 > >==================== > >REINDEXING zebra > >==================== > >11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: 0 > >11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: n > >11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: y > >11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: d > >11:21:00-30/08 zebraidx(8646) [warn] Unknown register type: u > >11:21:29-30/08 zebraidx(8646) [warn] MARC: Bad offsets in data. Skipping >rest > >11:21:29-30/08 zebraidx(8646) [warn] Record didn't contain match fields in >(bib1,Local-number) > >==================== > >CLEANING > >==================== > >Please help me on urgent basis as I am facing problem on production. > >thanks in advance. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

Sending Overdue Notices After Import from Follett
by Sheldon Harris 30 Aug '13

30 Aug '13

Hello! We recently moved to Koha 3.12 from Follett Circulation Plus. When we imported the data, we also pulled in the circulation data from Follett. There were roughly 120 overdue items pulled into Koha from Follett. How do I trigger overdue notices to go out for these overdue items pulled in from Follett? I've researched this and haven't found any answers. Thanks! -- Sheldon Harris, M. Ed. Systems Administrator College of Education Idaho State University Phone: (208) 282-4302

1 0

Zebra rebuild error
by rocky bang 30 Aug '13

30 Aug '13

hi everyone, I have koha 3.8 install on server. I tried to reindex the zebra server using following commands. export KOHA_CONF=/path to .xml file export PERL5LIB=/path to kohaclone perl misc/migration_tools/rebuild_zebra.pl -b -r -v and it starts reindexing but i got following errors: Zebra configuration information ================================ Zebra biblio directory = /etc/conf/koha-dev-domv/var/lib/zebradb/biblios Zebra authorities directory = /etc/conf/koha-dev-domv/var/lib/zebradb/authorities Koha directory = /opt/kohaclone BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 21901.................................................................................................... Records exported: 21928 ==================== REINDEXING zebra ==================== 11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: 0 11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: n 11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: y 11:19:48-30/08 zebraidx(8646) [warn] Unknown register type: d 11:21:00-30/08 zebraidx(8646) [warn] Unknown register type: u 11:21:29-30/08 zebraidx(8646) [warn] MARC: Bad offsets in data. Skipping rest 11:21:29-30/08 zebraidx(8646) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING ==================== Please help me on urgent basis as I am facing problem on production. thanks in advance.

1 1

liblivecd
by Richard Maileseni 30 Aug '13

30 Aug '13

Hi, Im new to koha, and Ive been looking around for information about it. I came across this thing called koha liblivecd. I have found out a few things about it but could anyone please direct me to where I could get more info or help explain this. Thanks! Richard.

2 1

Re: [Koha] Koha and Microsoft Exchange?
by Quoc Uy 30 Aug '13

30 Aug '13

I don't know about Microsoft exchange, but if you want to send mail or notices to patrons, you can use google mail. It's quite easy with program Postfix on debian (or Ubuntu). More information about use google mail server is here: http://kohageek.pbworks.com/w/page/58731341/Configure%20gmail%20with%20post… Thank Vimal for finding and sharing this guide! Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn & http://vietnamlib.net Phone: +79525768182

1 0

Re: [Koha] Koha liblivecd
by Quoc Uy 30 Aug '13

30 Aug '13

It's called Koha live cd or dvd. You can check current project here: http://sourceforge.net/projects/kohalivedvd/ and here http://www.vimalkumar.info/content/koha-live-dvd Remember to read Koha manual before using this live DVD. It's just a full packages Koha installed. (Koha manual can download in koha-community.org) Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn & http://vietnamlib.net Phone: +79525768182

1 0

Re: [Koha] RDA framework
by David Cook 30 Aug '13

30 Aug '13

Hi Chris and Chris: I've actually added another RDA framework on the wiki (superseding the last two which were still missing some RDA fields, I believe). It uses the latest "marc21_framework_DEFAULT.sql" (which should be current up to Update No. 16 (April 2013), plus some slight modifications by an actual cataloguing library (More info the changes to MARC with each update available here: http://www.loc.gov/marc/status.html) Special thanks to the amazing efforts of Bernardo Gonzalez Kriegel, Mason James, Marcel de Rooy, et al. for putting that framework together! The framework might still need some alterations, but it should include all the fields and subfields available. David Cook Systems Librarian (BA,FRLS,MLIS) Prosentient Systems P/L ABN 31 078 409 168 72/330 Wattle St, Ultimo NSW 2007 tel: 02 92120899 fax: 02 92120885 dcook(a)prosentient.com.au -----Original Message----- Date: Thu, 29 Aug 2013 13:26:29 +1200 From: Chris Meech <cmeech(a)waitaki.govt.nz> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: [Koha] RDA framework Message-ID: <988CFBF8CA18774A819D6157BACB27F90736585546(a)WDCEX1.waitakidc.govt.nz> Content-Type: text/plain; charset="us-ascii" Hi, The Koha RDA framework here http://wiki.koha-community.org/wiki/MARC_frameworks#RDA_Framework seems to be lacking a 264 field. Has anyone got an RDA framework that includes 264? Cheers Chris Christopher Meech Reference and Heritage Librarian Waitaki District Libraries P.O. Box 134,Oamaru 9444 62 Thames St, Oamaru 9400 03 433 0850 cmeech(a)waitaki.govt.nz<mailto:cmeech@waitaki.govt.nz> www.library.waitaki.govt.nz ------------------------------ Message: 2 Date: Thu, 29 Aug 2013 13:55:37 +1200 From: Chris Cormack <chris(a)bigballofwax.co.nz> To: Chris Meech <cmeech(a)waitaki.govt.nz> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] RDA framework Message-ID: <CA+95qVTrb+gjKPHEh_=gkFGs4xwS6jbHh9en6MiYAwSNxZGjhQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 On 29 August 2013 13:26, Chris Meech <cmeech(a)waitaki.govt.nz> wrote: > Hi, > The Koha RDA framework here > http://wiki.koha-community.org/wiki/MARC_frameworks#RDA_Framework > seems to be lacking a 264 field. > > Has anyone got an RDA framework that includes 264? > We could have pretty fast, If you grab that, import it, add the 264, export the framework and add it to the wiki :) Chris

1 0

Re: [Koha] Enhanced messages
by Olugbenga Adara 30 Aug '13

30 Aug '13

Hi Liz, This is good to know, and would be easier for people to run than going to the MySQL cli, which also worked. Olugbenga Adara Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara >________________________________ > From: Liz Rea <liz(a)catalyst.net.nz> >To: Olugbenga Adara <gbengaadara(a)yahoo.com> >Sent: Thursday, August 29, 2013 6:12:39 PM >Subject: Re: [Koha] Enhanced messages > > > >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >Hi Olugbenga, > >There is also a script which, once you have set your messaging defaults, >will go through all borrowers and set the messaging preferences to the >defaults for every borrower. > >It's in misc/maintenance/borrowers-force-messaging-defaults > >Hope this helps, >Liz >On 30/08/13 01:58, Olugbenga Adara wrote: >> Hello Jonathan, >> >> Thanks. I will try your suggestion. >> >> Regards >> >> >> Olugbenga Adara >> >> >> Skype: gbengaadara >> Blog: http://gbengaadara.blogspot.com >> Twitter: http://twitter.com/gbengaadara >> Profile: http://www.linkedin.com/in/gbengaadara >> >> >>> ________________________________ >>> From: Jonathan Druart <jonathan.druart(a)biblibre.com> >>> To: Olugbenga Adara <gbengaadara(a)yahoo.com> >>> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> >>> Sent: Thursday, August 29, 2013 3:35:42 AM >>> Subject: Re: [Koha] Enhanced messages >>> >>> >>> Hello Olugbenga, >>> >>> You have to switch on the EnhancedMessagingPreferences for theses >>> messages to be sent. >>> >>> If you want to enable options for all patrons, you must do that in the >>> cli of your dbms. >>> >>> For example, for Item checkout and Item check-in: >>> >>> insert into >borrower_message_preferences(borrowernumber,message_attribute_id) >>> select borrowernumber, 5 from borrowers; >>> insert ignore into >>> borrower_message_transport_preferences(borrower_message_preference_id, >>> message_transport_type) select borrower_message_preference_id, 'email' >> >from borrower_message_preferences where message_attribute_id = 5; >>> >>> insert into >borrower_message_preferences(borrowernumber,message_attribute_id) >>> select borrowernumber, 6 from borrowers; >>> insert ignore into >>> borrower_message_transport_preferences(borrower_message_preference_id, >>> message_transport_type) select borrower_message_preference_id, 'email' >> >from borrower_message_preferences where message_attribute_id = 6; >>> >>> The 5 and 6 values correspond to the message_attribute_id in the >>> message_attributes table (select * from message_attributes;) >>> >>> Regards, >>> Jonathan >>> >>> 2013/8/28 Olugbenga Adara <gbengaadara(a)yahoo.com>: >>>> >>>> >>>> Hello all, >>>> >>>> Is it possible to have all Koha patrons get messages like checkin, >checkout etc without setting the >>>> EnhancedMessagingPreferences to Allow? I had assumed that this was >not necessary but Koha was not sending messages until I turned this on >and enabled it for the patron. >>>> >>>> If the EnhancedMessagingPreferences must be set, is there any way to >auto enable the messaging options for all patrons who are already on the >system as a default? >>>> >>>> I am running 3.12.3 on Debian 7 >>>> >>>> >>>> Thanks >>>> >>>> Olugbenga Adara >>>> >>>> >>>> Skype: gbengaadara >>>> Blog: http://gbengaadara.blogspot.com >>>> Twitter: http://twitter.com/gbengaadara >>>> Profile: http://www.linkedin.com/in/gbengaadara >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> >>> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha > >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v1.4.11 (GNU/Linux) >Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > >iQEcBAEBAgAGBQJSH8dWAAoJELbCpJ03Jji3DFQH/2qCaZT4v07lJbwYdHkmAGfv >D9IfU2zsNCELm+SJe1AfWbSSlqhkXCGzQZzqbgNl7YT33+4EWBQZShfHQk9nWjw8 >1ObTXezOKY7W8eRDm0G4YOdFyabAH5f+y+jSMIadfy6cPgQQ+CYaK6Plmv0c/R+R >GPPlZxYRtNrHpoO4OWwGFirxx1Oh66H4aAezGWA6XI4C7xNzm6+xzLXvgKTuJjYN >F4UYWLJJaSNCiQegClI1RBsPUICKOWPFMx43NJxnyipqXx3XOH5NV7bZWQ4QlTEm >dsLbotZBUDArYV48CCizpdHdssYxKLf/zVJO0EW6Gf+M3RfoJenoQgCyxbTidrM= >=rM74 >-----END PGP SIGNATURE----- > > > >

1 0

Serials - uploading data and setting up, suggestions and advice needed
by Elaine Bradtke 30 Aug '13

30 Aug '13

We're coming to the point in our conversion process where I need to start thinking about serials. We have a database that I will need to convert to MARC. That's the easy part. We have analytics already in Koha with 773 (Host Item Entry) fields, with the host Record control number in place, ready to link to the parent serial records once they are uploaded. We have both current subscriptions and serials that have lapsed or ceased publishing in the same database. All our holdings are in plain text in one field in the database. Some of our holdings are complicated, which is why we used plain text. The plan is to import past holdings for both current and non current serials into a notes field and then start setting up frequency details as new issues come in. I think we have to do this in two steps (upload as biblios and then add subscription info)? Some questions - * Create an item record when receiving this serial: I don't think we want to create an item record for each issue, they never circulate, they're always kept in the same place. Has anyone done this, and why would it be a useful thing to do? *Vendors - we don't use vendors, but we do want to know when an issue is overdue so we can follow up on it. Will we be notified even though we've opted out of 'claiming' missing or late issues? Or will we have to set up each publisher as a vendor? *How many issues appear by default on bibliographic records: Is there a way to set this to 'all'? What do they look like? It would be useful if I could see Koha catalogues with serials records in them to understand what it will look like. . . Thanks in advance for any advice. -- 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)

2 1

Overdue notices - how to get all categories of patrons being sent emails!
by Nicholas van Rheede van Oudtshoorn 29 Aug '13

29 Aug '13

Hi all! Got a bit of an interesting one here.... We've got overdue notices set up and working BUT it doesn't seem to be working for one of our categories - (A)dministrative users. Any clues as to what might be going on??? Nick

5 5