- Koha - lists.katipo.co.nz

Post Import of field update issue
by Roche III, Edward 24 Mar '09

24 Mar '09

Good Morning All I am writing to both groups because I am not sure which one would be the best option for this problem. I have to do a mass update of our barcode field to match up what our barcodes actually are as opposed to what Follett spits out in its export. Before I do the field update I can check out books with no problem with the current barcode format. After I do the update, when I enter the barcode to checkout for the student and hit Checkout then it automatically sends me back to the Circulation - Checkout page and never assigns the book to the patron. Here are the steps I do when updating the field: * Export data to a tab delimited file (itemnumber and barcode) * Open file in Excel and fix the barcode field (From T0012345 to T 12345) * Save as file again as Tab Delimited * Go to WebMin in the browser and create a temp table to hold the updated info * Import the data to the temp table with no issues * Run the following SQL expression to update the barcode field in the items table with the data that is in the temp table linked by itemnumber o update items a inner join temp b on a.itemnumber = b.itemnumber set a.barcode = b.barcode * Everything copies over, I spot check a couple records to make sure no issues. * I run the following script from terminal o perl /usr/share/koha/bin/maintenance/sync_items_in_marc_bib.pl --run-update * Then run: o perl /usr/share/koha/bin/migration_tools/rebuild_nozebra.pl * I go into Koha and test the checkout function (see Checkout Image Attachment) and I get the Circulation - Checkout page (see Circulation-Checkout Attachment) Should I be doing this update a different way???? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 1

Items.paidfor
by Roche III, Edward 24 Mar '09

24 Mar '09

Does anyone know what this field is for? I would like to put any Fund info in this field. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 1

Zebra Server Config
by Roche III, Edward 24 Mar '09

24 Mar '09

At some point before we go to production I will be configuring Koha to use zebra. I know during the Koha install it says you will need to config the zebra server after the install is completed. I have never dealt with a zebra server so I have no idea where to start. So my question, does anyone have instructions on how to do this? I am using Ubuntu 8.10. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

2 1

KOHA ERROR
by prajna 24 Mar '09

24 Mar '09

Hi all, I have an error while while adding a book in the koha.i am getting the error like: Tag "" is not a valid tag. at /usr/share/koha/lib/C4/Biblio.pm line 2462 CGI::Carp pls help. -- With regards Prajna.M Lecturer Chintech.

2 1

Koha 3.0.1 - Search Problems
by Akin Adigun 24 Mar '09

24 Mar '09

i am using koha 3.0.1 on Suse 11.0. I have a little problem in searching. as it I can not search a for a specific titles, Author, Subject rather this version search for related titles,subjects & Authors. It brings out all the titles, subjects and Authors that contains part of the or all the search word, but not specific on that title. Pls kindly help on how to search to specific title in the database. Akin Adigun (MCP) Akinomatics Tel: +2348035565348, +2348029219271 --- On Mon, 3/23/09, koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> wrote: From: koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> Subject: Koha Digest, Vol 41, Issue 68 To: koha(a)lists.katipo.co.nz Date: Monday, March 23, 2009, 4:00 PM Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Koha Workshops at Mysore (9-10 Apr) & Mumbai (17-18 Apr) (savitra sirohi) 2. Re: Adding new item type icons (Nicole Engard) 3. Re: serial not showing in OPAC search (Nicole Engard) 4. Re: Cataloguing articles within serials (Nicole Engard) 5. Re: Installer not creating database tables (Galen Charlton) 6. Re: Adding new item type icons (Paul Yachnes) 7. EDI, automated purchasing process (Ivan Lee) ---------------------------------------------------------------------- Message: 1 Date: Mon, 23 Mar 2009 16:19:50 +0530 From: savitra sirohi <savitra.sirohi(a)osslabs.biz> Subject: [Koha] Koha Workshops at Mysore (9-10 Apr) & Mumbai (17-18 Apr) To: koha koha <koha(a)lists.katipo.co.nz> Message-ID: <8cf6c9ba0903230349p1e3ccbfcm4bf7e25e73d6b679(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 All, We have 2 workshops planned in April here in India, more information here: http://www.osslabs.biz/koha_library_management_system/workshop.html Those who wish to register please fill this form: http://spreadsheets.google.com/viewform?formkey=cFJnR0JMMEF4cHpwT0MyWUxQTm9… Thanks, Savitra Sirohi Nucsoft OSS Labs http://www.osslabs.biz ------------------------------ Message: 2 Date: Mon, 23 Mar 2009 07:08:05 -0400 From: Nicole Engard <nicole.engard(a)liblime.com> Subject: Re: [Koha] Adding new item type icons To: Paul Yachnes <yach(a)cox.net> Cc: koha <koha(a)lists.katipo.co.nz> Message-ID: <9128d7f00903230408s44fe95abr6535d9b08becf8b5(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 I too would like to know what has changed so I can update the documentation since I say in the documentation that you just have to add a folder ... --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Fri, Mar 20, 2009 at 10:52 PM, Paul Yachnes <yach(a)cox.net> wrote: > How do I add new item type icons to my selection in Koha 3.0.1? In Koha > 3.0, all I had to do was add a new folder of icons to the itemtypeimg > folder and they would show up under a separate section on the Add Item > Type and Modify Item Type pages. In 3.0.1 where there is a separate tab > on these pages for each folder of icons, no tab appears for my new > folder. What else do I need to do? Thanks. > > Paul > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 3 Date: Mon, 23 Mar 2009 07:11:04 -0400 From: Nicole Engard <nicole.engard(a)liblime.com> Subject: Re: [Koha] serial not showing in OPAC search To: mallikarjun dora <dora.mallikarjun(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Message-ID: <9128d7f00903230411t540bf94bqff55950256b1f80b(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Are other items showing up in your search? If not you may need to reindex zebra. If that's not the case - did you link your subscription to an existing biblio record? That is necessary for the subscription to show in the search - see this document: https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/S… --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ 2009/3/22 mallikarjun dora <dora.mallikarjun(a)gmail.com>: > Dear All, > > i have add a new subscription , but its not showing? while i am searching in > OPAC. what may be the reason. > > > Thanks > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------ Message: 4 Date: Mon, 23 Mar 2009 07:13:18 -0400 From: Nicole Engard <nicole.engard(a)liblime.com> Subject: Re: [Koha] Cataloguing articles within serials To: Nelson Fredsell -CCE <nelson(a)cfce.org.za> Cc: Koha list <koha(a)lists.katipo.co.nz> Message-ID: <9128d7f00903230413kf45de84w75431d52780abbac(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 That is what it means - but the patron should be able to figure out which is which based on what you have as the title of the entry. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Sun, Mar 22, 2009 at 7:42 AM, Nelson Fredsell -CCE <nelson(a)cfce.org.za> wrote: >> -----Original Message----- >> From: Veronica Lencinas [mailto:verolencinas@yahoo.com.ar] >> Sent: 17 March 2009 02:29 PM >> To: Nelson Fredsell >> Subject: Re: [Koha] Cataloguing articles within serials >> >> >> Hello Nelson, >> > > [see question 1 below] > >> what you need is analytical cataloging. It's quite simple. Use 1XX and >> 245 as usual for author and title of the article. The information about >> the serial is recorded in the field 773 - Host Item Entry >> (http://www.loc.gov/marc/bibliographic/bd773.html) You can add subject >> headings as usual in 650. > > Does this mean I would first catalogue the serial as an item, then I would > catalogue each article separately, as an additional item in our catalogue, > and reference the serial using 773? ?So, a serial with 10 articles would > result in 11 items in the ILS, both with subject and keywords? > > This way when a patron searches, both the serial and the specific article > within that serial edition would be found? ?The patron would then have to > figure out that the two are connected. > > Thanks, > Nelson > >> >> Ver?nica Lencinas >> C?rdoba, Argentina >> >> >> --- El mar 17-mar-09, Nelson Fredsell <nelson(a)cfce.org.za> escribi?: >> >> > De: Nelson Fredsell <nelson(a)cfce.org.za> >> > Asunto: [Koha] Cataloguing articles within serials >> > Para: "Koha list" <koha(a)lists.katipo.co.nz> >> > Fecha: martes, 17 de marzo de 2009, 5:29 am >> > Dear all, >> > >> > >> > >> > 1) ? ? ?We would like to catalogue individual >> > articles/chapters within some >> > of our serials/journals/periodicals. ?I understand that >> > using MARC 5xx or >> > 6xx is a preferred method. ? I've been unable to find >> > examples of this on >> > the liblime demos thus far, and would like to see how this >> > works both from >> > an administrator's standpoint and from a patron's. >> > >> > >> > >> > >> > 2) ? ? ?After seeing an article, I'd also love to be >> > able to Search for this >> > article to see whether I could find it in the catalogue, >> > alongside books. >> > >> > >> > >> > 3) ? ? ?I'd like for patron searches to include books, >> > serials and articles >> > within serials, *within a single search of keyword, subject >> > and title*. ?I'd >> > perhaps like this to be the default search, rather than an >> > Advanced Search. >> > Is Koha configurable in this way (without lots and lots of >> > effort)? >> > >> > >> > >> > Could anyone point me to an example or two, especially >> > relating to point 1? >> > >> > >> > >> > >> > (We're a small NGO/non-profit in the field of >> > independent education.) >> > >> > >> > >> > Thanks! >> > >> > Nelson >> > >> > >> > >> > Administration >> > >> > Centre for Creative Education >> > >> > Cape Town | South Africa >> > >> > www.cfce.org.za >> > >> > >> > >> > _______________________________________________ >> > Koha mailing list >> > Koha(a)lists.katipo.co.nz >> > http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> ? ? ? Yahoo! Cocina >> Recetas pr?cticas y comida saludable >> http://ar.mujer.yahoo.com/cocina/ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ------------------------------ Message: 5 Date: Mon, 23 Mar 2009 10:29:42 -0400 From: Galen Charlton <galen.charlton(a)liblime.com> Subject: Re: [Koha] Installer not creating database tables To: Chris Alfano <calfano(a)scienceleadership.org> Cc: Koha Mailing List <koha(a)lists.katipo.co.nz> Message-ID: <4659947d0903230729oc307fe5o24c1bd1ac5a1cf25(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, 2009/3/21 Chris Alfano <calfano(a)scienceleadership.org>: > When exactly should Koha be creating the database tables? During configure? > make install? or when I visit the install script via the intranet site? The tables get created when you run the web installer. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt ------------------------------ Message: 6 Date: Mon, 23 Mar 2009 12:15:58 -0400 From: Paul Yachnes <yach(a)cox.net> Subject: Re: [Koha] Adding new item type icons To: Nicole Engard <nicole.engard(a)liblime.com> Cc: koha <koha(a)lists.katipo.co.nz> Message-ID: <49C7B5BE.5040604(a)cox.net> Content-Type: text/plain; charset="us-ascii" An HTML attachment was scrubbed... URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090323/7ac6606a/atta… ------------------------------ Message: 7 Date: Mon, 23 Mar 2009 14:12:29 -0400 From: "Ivan Lee" <ilee(a)lsc.on.ca> Subject: [Koha] EDI, automated purchasing process To: <koha(a)lists.katipo.co.nz> Message-ID: <C53FAB5C518D594090DE911D7F2F09EC01F01A2C(a)exchange.LSC.LOCAL> Content-Type: text/plain; charset="us-ascii" Good Afternoon, A customer of ours is looking at implementing KOHA. However, as far as I can see, EDI has not been implemented yet. Is there any other form of electronic or automated ordering available in KOHA? Is there a timeframe as to when EDI would be implemented? Koha 3.0 Roadmap Status: Planning Feature: EDI or related technology for automating the purchasing process, etc. Who: CC, RH, MJ Note: Baker and Taylor support; Ebsco support. Thanks, Ivan Lee ilee(a)lsc.on.ca

1 0

corrections to previous message with apologies
by Carmel Young 24 Mar '09

24 Mar '09

Using Koha 3.0.0 on Linux. We had trouble with a failed file - you sent us some advice to use gedit, and we recovered this file. Unfortunately, another problem has arisen - cannot log into "kohadbuser" because of too many authentication failures - the exact message reads "Access denied for 127.0.0.1. The host has been blocked because of too many authentication failures." Also cannot log into kohaadmin. "" WE CAN LOG INTO KOHADMIN. Apologies for this wrong information - Caramel"" The question is how can we retrieve the passwords? At the same time we can't log into the local hosts. I hope this is not too many problems for you to solve... Thanks heaps Carmel Young Catholic University Malawi

2 1

offline koha 3 manual
by Amir Seni 24 Mar '09

24 Mar '09

Greetings, Does anyone know where i can download the complete koha manual from sites.google.com? Bandwidth is expensive and limited, i've tried httrack to mirror the site but it doesn't get the pages. The pdf pages are not uptodate and are not ordered.

2 2

login failure
by Carmel Young 24 Mar '09

24 Mar '09

Using Koha 3.0.0 on Linux. We had trouble with a failed file - you sent us some advice to use gedit, and we recovered this file. Unfortunately, another problem has arisen - cannot log into "kohadbuser" because of too many authentication failures - the exact message reads "Access denied for 127.0.0.1. The host has been blocked because of too many authentication failures." Also cannot log into kohaadmin. The question is how can we retrieve the passwords? At the same time we can't log into the local hosts. I hope this is not too many problems for you to solve... Thanks heaps Carmel Young Catholic University Malawi

1 0

Which item tag in Unimarc setup
by Zeno Tajoli 24 Mar '09

24 Mar '09

Hi to all, for test I need to setup Koha with Unimarc and insert data in a bulk mode. No problem with biblographic data but, for Unimarc, is not clear where to insert item informations. For MARC21 the manual is clear: item data into tag 952 <https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/C…> But the Unimarc definitions in english (.../installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql) and in french ( .../installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql) in stable version 3.0.1 don't have the tag 952. So, do I need to use a different tag for Unimarc ? Cheers Zeno Tajoli Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0

Adding new item type icons
by Paul Yachnes 23 Mar '09

23 Mar '09

How do I add new item type icons to my selection in Koha 3.0.1? In Koha 3.0, all I had to do was add a new folder of icons to the itemtypeimg folder and they would show up under a separate section on the Add Item Type and Modify Item Type pages. In 3.0.1 where there is a separate tab on these pages for each folder of icons, no tab appears for my new folder. What else do I need to do? Thanks. Paul

2 2