- Koha - lists.katipo.co.nz

missing itemnumber in old_issues
by schnydszch 17 Apr '13

17 Apr '13

Good day koha users and developers! I have koha 3.10.4 installed in Debian Squeeze, the deb package one. Yesterday my boss requested me to have reports on all of our circulation records (current transaction where books were not yet returned and old transaction records) so the tables for this report are the issues and old_issues right and use LEFT JOIN to extract records from other tables. Now I search on the koha sql report wiki if there is an existing report for this and there is but I there is none (correct me if I'm wrong) for old issues but anyway that's a different story. When I looked at my old_issues table, there are NULL data in my itemnumber when in fact it should have (see image) <http://koha.1045719.n5.nabble.com/file/n5751283/missing_itemnumber_in_old_i…> So I tried to remember what all the things I have done. The koha database were migrated from Koha 3.2.x to 3.4.x to 3.8.x to 3.10.x. I had also done mass edit of bibliographic records some months ago but I can not overwrite bibliographic records which are currently on loan so I back up issues and deleted it and once all bibliographic records are cleaned and imported into the database thru stage marc import, I imported the issues table. That's what I can remember that could have touched the itemnumber column. But I could be wrong, maybe another institution could have experienced this. Ill try to look back at my old mysql database and old koha server once I get time. Thank you and have a nice day -- View this message in context: http://koha.1045719.n5.nabble.com/missing-itemnumber-in-old-issues-tp575128… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

505 mtg: formatted contents notes
by Paula Corman 16 Apr '13

16 Apr '13

I am cataloging a collection of several hundred CDs, each of which contains at least 12 or more songs with potentially as many different performers. A few days ago, I was cataloging a 2-volume title with 2 discs per volume and a total of 78 songs and performers! How should these be entered into a Koha record? Do I simply duplicate the 505 tag over and over again? Paula Corman The Musical Instrument Museum Phoenix, Arizona, USA

2 1

Re: [Koha] Weird textboxes in koha 3.10.4
by Paul 16 Apr '13

16 Apr '13

At 07:57 PM 4/15/2013 +0000, Sue McMillan wrote: >We found we had 4 or five boxes displaying under each other when we >upgraded to Koha 3.10.03.001 last week. Turns out that different versions >of Firefox displayed the home page differently. Upgrading Firefox fixed >the issue. We still have a number of work stations using a very old version of Firefox (3.6.13 -- the last to run on a buttoned-down Win 98SE -- terrible, but I haven't had time to find a Linux distrib that will work on a Pentium box with 256k RAM) and have no probs with them working quite brilliantly (and very fast in a kiosk environment) for Koha 3.8.x Do you have a "live" example of a 3.10 server that I could look at? Many thanks - Paul

2 1

403 Forbidden After dev installation !
by Karam Qubsi 16 Apr '13

16 Apr '13

Hi All I installed koha ( master ) using git installation instructions here : http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git and this is not the first time I do this ,I installed it before , but at this time there is something wrong after all the instructions and when I arrived to the web installation the web page gives me this : Forbidden You don't have permission to access / on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. ------------------------------ Apache/2.2.22 (Ubuntu) Server at 127.0.1.1 Port 8080 ---------------------------------- I have access to the files , and I'm not sure where is the problem located any one have an idea about this ? Thanks a lot -- *Karam Qubsi*

3 4

Re: [Koha] Problem with patrons import
by Sonia P. 16 Apr '13

16 Apr '13

Dear Katrin Thanks for your quick reply. When I open my cvs file, it's opened as a spreadsheet in a Excel-like software. I guess if you open it with notepad, you would see comas. I didn't, I trusted my software when it saved the file as a csv file. (I can't double-check now, my file is on another computer in another location) Should I really check that a cvs file is coma-separated? O_o And as mentioned in my original email, I have already downloaded the starter file and copy-paste all the headers. It is all in one row, the very first one, all in lowercase, all at the right place, etc etc. Well it is just copy-paste -- what could have gone wrong with a simple copy-paste? Plus, I have double-checked the header row, two thousands times, there is not the slightest unusual thing. If the Patrons import says it's a problem with the header row, is it really the header row? can it be that there is a problem somewhere else? Thanks a lot for your help! Sonia.

2 1

Re: [Koha] Koha Digest, Vol 90, Issue 19
by amutsikiwa 16 Apr '13

16 Apr '13

Hi In my case the MARC field 942$c (Koha [default]) is populated. It only happens with newly added records. Uploaded items are searchable. Thanks for the information Regards, Admire -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Monday, April 15, 2013 10:05 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 90, Issue 19 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. New added items not searchable on OPAC and on Staff catalog but can be checked out by barcode (amutsikiwa) 2. Re: New added items not searchable on OPAC and on Staff catalog but can be checked out by barcode (Olugbenga Adara) 3. Re: Koha universities that use ACQ (Zeno Tajoli) 4. Re: Weird textboxes in koha 3.10.4 (Martin Renvoize) 5. Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4 (Indranil Das Gupta) 6. Re: Weird textboxes in koha 3.10.4 (Sue McMillan) 7. Re: Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4 (Indranil Das Gupta) ---------------------------------------------------------------------- Message: 1 Date: Mon, 15 Apr 2013 14:29:22 +0200 From: "amutsikiwa" <amutsikiwa(a)uzlib.uz.ac.zw> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] New added items not searchable on OPAC and on Staff catalog but can be checked out by barcode Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAKVCrdksRKhLouRJ10HjXrbCgAAAEAAAAMZt0s8Cd6xCqoxpaniF oKYBAAAAAA==(a)uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii" Hi I have recently uploaded 87200 item records into Koha 3.10.3 . I can search the uploaded records on both the OPAC and the staff catalog, can check then out and so on. My challenge is with new records that I am cataloguing. They are are not searchable on both the OPAC and the Staff Catalog, but can be checked out using their barcode. I have the following cron job to re-index the browsers under the Linux Koha user: */5 * * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z -v>/dev/null 0 1 * * * /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -x 2>/dev/null Mr cron daemon is running. Even if I am to run the command manually, the newly added records are not searchable. Can anyone send me any pointers. Regards, Admire Mutsikiwa University of Zimbabwe ------------------------------ Message: 2 Date: Mon, 15 Apr 2013 05:44:40 -0700 (PDT) From: Olugbenga Adara <gbengaadara(a)yahoo.com> To: amutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw>, "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] New added items not searchable on OPAC and on Staff catalog but can be checked out by barcode Message-ID: <1366029880.30386.YahooMailNeo(a)web162002.mail.bf1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Admire, When you run the indexing manually, does the number of records index tally with the number you expect? If it does, it may be that the framework you use to catalogue may not be properly configured. I recently discover that if I do not have data in 942$c, then those records will not show up in search results, though as you said, they are found by barcode. My two cents. ? Olugbenga Adara Skype: gbengaadara Blog: http://gbengaadara.blogspot.com Twitter: http://twitter.com/gbengaadara Profile: http://www.linkedin.com/in/gbengaadara >________________________________ > From: amutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw> >To: koha(a)lists.katipo.co.nz >Sent: Monday, April 15, 2013 1:29 PM >Subject: [Koha] New added items not searchable on OPAC and on Staff >catalog but can be checked out by barcode > > >Hi > > > >I have recently? uploaded? 87200 item records into Koha 3.10.3 .? I can >search the uploaded records on both the OPAC and the staff catalog, can >check then out and so on. My challenge is with new records that I am >cataloguing. They are are not searchable on both the OPAC and the Staff >Catalog, but can be checked out using their barcode. I? have the >following cron job to re-index the browsers under the Linux Koha user: > > > >*/5 * * * *? /usr/share/koha/bin/migration_tools/rebuild_zebra.pl? -b >-a -z >-v>/dev/null > >0 1 * * *? /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r >-v -x >2>/dev/null > > > >Mr cron daemon is running. Even if I am to run the command manually, >the newly added records are not searchable. Can anyone send me any pointers. > > > >Regards, > > > >Admire Mutsikiwa > >University of Zimbabwe > >_______________________________________________ >Koha mailing list? http://koha-community.org Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ Message: 3 Date: Mon, 15 Apr 2013 15:58:53 +0200 From: Zeno Tajoli <z.tajoli(a)cineca.it> To: Mathieu Saby <mathieu.saby(a)univ-rennes2.fr> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha universities that use ACQ Message-ID: <516C079D.4070901(a)cineca.it> Content-Type: text/plain; charset=ISO-8859-1 Hi to all Il 10/04/2013 21:50, Mathieu Saby ha scritto: > Hello Zeno > Yes, we use it in Rennes 2 (3.10) > Lyon 3 is also using it (3.8) and some other libraires, but not all. > Do you have some specific question? No. In fact an Italian university asked me to find same universities that use ACQ in Koha. In fact that's all. Thank you Zeno Tajoli -- Dr. Zeno Tajoli Dipartimento Gestione delle Informazioni e della Conoscenza z.tajoli(a)cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate ------------------------------ Message: 4 Date: Mon, 15 Apr 2013 19:58:49 +0100 From: Martin Renvoize <martin.renvoize(a)ptfs-europe.com> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Weird textboxes in koha 3.10.4 Message-ID: <CAB7SL8DVxv1Fk4b2f06i_e4+hoCjHijGn1r3Zfxqzi+77c-pfw(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 I've started rolling out mod_pagespeed ( https://developers.google.com/speed/pagespeed/mod) on our apache servers to prevent just this problem. It'll re-write the css files with a unique hash in them based on their contents, so when they change, the filename sent to the browser also changes, forcing them to refresh. Just a nice little tip. Martin On 10 April 2013 07:54, schnydszch <eugenegf(a)yahoo.com> wrote: > okay got it Chris. Got rid of the weird textboxes :) > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Weird-textboxes-in-koha-3-10-4-tp5750372p5 750375.html > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)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 ------------------------------ Message: 5 Date: Tue, 16 Apr 2013 00:46:32 +0530 From: Indranil Das Gupta <indradg(a)gmail.com> To: koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4 Message-ID: <CAEm3SZ1uWMWRpGKrJJwEcMV9TmGvAX=X-8=wSv6gV8wdrNxy=A(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi all, An update on my previous mail on migrating a 2.2.x installation to 3.10.4. I had taken the db from 2.2.5 -> 3.0.0 -> 3.10.4 I seemed to have done OK, until I tried `koha-rebuild-zebra -f -v <instance_name>` on 3.10.4 I've about 30 bibs where I get the error like the one below: .error retrieving biblio 4358 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 539. The bibs are in the db, however, the biblioitems.marcxml field for these bibs are empty. I should additionally mention that I noted the same on 3.0.0 instance too for these specific. However, in that case i didnt see zebra complain. So, any way to generate the marcxml data for these bibs? I mean I could always re-enter the data as new bibs, steal their marcxml entry and transplant them into the ones which are missing and do a full zebra re-index. But that sounds very ugly. Is there any elegant solutions to be had? thanks in advance -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ------------------------------ Message: 6 Date: Mon, 15 Apr 2013 19:57:10 +0000 From: Sue McMillan <sue.mcmillan(a)STDC.govt.nz> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Weird textboxes in koha 3.10.4 Message-ID: <F080C0113CF5F741BE2B9541CA30ACDA46976886(a)STDCEXCH01.internal.stdc.govt.nz> Content-Type: text/plain; charset="iso-8859-1" We found we had 4 or five boxes displaying under each other when we upgraded to Koha 3.10.03.001 last week. Turns out that different versions of Firefox displayed the home page differently. Upgrading Firefox fixed the issue. Regards Susan McMillan Cataloguing and Systems Administrator| South Taranaki District Council 105-111 Albion St, Private Bag 902, Hawera 4610, NZ Phone: +64 6 278 0555 | www.southtaranaki.com ? This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002. <p><b>CAN'T OPEN ATTACHMENTS?</b></p> The Council has upgraded to Microsoft office 2007 suite. This may mean you cannot open attachments if you have older versions of office. <a href="http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9 -4AEE-8F43-C6BB74CD1466&displaylang=en"> Click here to access Microsoft Office 2007's compatibility website.<a/> ------------------------------ Message: 7 Date: Tue, 16 Apr 2013 01:35:10 +0530 From: Indranil Das Gupta <indradg(a)gmail.com> To: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4 Message-ID: <CAEm3SZ2gDfU9XVV5RsaeZz0OSf_jCEVqadziJGuVNkdUeQ0jcg(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi all, Please ignore my last mail. Figured it out and fixed it with ./MARC21_parse_test.pl --fix on the affected bibs *facepalm_moment* -indra On Tue, Apr 16, 2013 at 12:46 AM, Indranil Das Gupta <indradg(a)gmail.com>wrote: > Hi all, > > An update on my previous mail on migrating a 2.2.x installation to > 3.10.4. I had taken the db from 2.2.5 -> 3.0.0 -> 3.10.4 > > I seemed to have done OK, until I tried `koha-rebuild-zebra -f -v > <instance_name>` on 3.10.4 > > I've about 30 bibs where I get the error like the one below: > > .error retrieving biblio 4358 at > /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 539. > > The bibs are in the db, however, the biblioitems.marcxml field for > these bibs are empty. > > I should additionally mention that I noted the same on 3.0.0 instance > too for these specific. However, in that case i didnt see zebra > complain. > > So, any way to generate the marcxml data for these bibs? I mean I > could always re-enter the data as new bibs, steal their marcxml entry > and transplant them into the ones which are missing and do a full > zebra re-index. But that sounds very ugly. Is there any elegant > solutions to be had? > > thanks in advance > > -- > Indranil Das Gupta > > Phone : +91-98300-20971 > Blog : http://indradg.randomink.org/blog > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > For a free editor supporting ODF, please visit LibreOffice - > http://www.documentfoundation.org > -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 90, Issue 19 ************************************ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Problem with patrons import
by Sonia P. 16 Apr '13

16 Apr '13

Dear all I know it will be a silly question, it always is...I am trying to import new members and somehow it doesn't work.The import patrons tool tells me: ############## Feedback: Parsing upload file koha-new-members-march-2013-shorter.csv Content-Type : text/csv Content-Disposition : form-data; name="uploadborrowers"; filename="koha-new-members-march-2013-shorter.csv" headerrow : Error analysis: Header row could not be parsed############## My patrons file is a .csv fileMy header row is: (sorry the format will probably go crazy) ############## borrowernumber cardnumber surname firstname title address address2 city state zipcode email phone fax branchcode categorycode gonenoaddress ############## All lowercase and copy-paste from the starter .csv file. What am I doing wrong? Or should I look somewhere else in the csv file? There is no date and nothing funny... Thanks for your help! Sonia.

2 1

Weird textboxes in koha 3.10.4
by schnydszch 15 Apr '13

15 Apr '13

I have 3.10.4 installed in debian 6.x. I'm getting this weird textboxes <http://koha.1045719.n5.nabble.com/file/n5750372/weird_koha_admin.jpg> When I get to the detail of the item, I get three search textboxes instead of one. Hmm... Anybody experienced this with koha 3.10.4 Thanks and more power Koha community! -- View this message in context: http://koha.1045719.n5.nabble.com/Weird-textboxes-in-koha-3-10-4-tp5750372.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

Replacement cost deleting or changing on batch modification
by Jim Maroon 15 Apr '13

15 Apr '13

Hi, all. We are having a problem with batch modification, and I hope someone out there has found a work around or way to fix it. We have a default replacement price of $15. This is inserted in the item record when we create an item. The only time we use this is when the item is a gift and has no price attached to it. Otherwise, we use the retail price for the item. This of course flags circ when an item is lost or damaged and needs to be replaced by the patron. The problem we are having is the actual replacement price is being replaced by the default price when we do batch modification on one or multiple items. We tried taking out the default price in our settings, but then it just replaces the replacement price with nothing. Has anyone else run into this problem? If so, did you find a fix for it? I'm wondering if there is something about Koha we are missing. Thanks in advance! -- ======================================================== *Jim Maroon *

2 2

Missing biblioitems.marcxml entries while migrating from 2.2.x to 3.10.4
by Indranil Das Gupta 15 Apr '13

15 Apr '13

Hi all, An update on my previous mail on migrating a 2.2.x installation to 3.10.4. I had taken the db from 2.2.5 -> 3.0.0 -> 3.10.4 I seemed to have done OK, until I tried `koha-rebuild-zebra -f -v <instance_name>` on 3.10.4 I've about 30 bibs where I get the error like the one below: .error retrieving biblio 4358 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 539. The bibs are in the db, however, the biblioitems.marcxml field for these bibs are empty. I should additionally mention that I noted the same on 3.0.0 instance too for these specific. However, in that case i didnt see zebra complain. So, any way to generate the marcxml data for these bibs? I mean I could always re-enter the data as new bibs, steal their marcxml entry and transplant them into the ones which are missing and do a full zebra re-index. But that sounds very ugly. Is there any elegant solutions to be had? thanks in advance -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org

1 1