Re: [Koha] Search by Title 245 subfields $a $b only
Hello, I know it is an old question but I am facing a similar issue. I need to exclude only the 780$t and 785$t. which means when I specify title in the drop down search by, I don’t want the search to look into 780$t and 785$t however I want the search to search by 780$t and 785$t when I select search by keywords. How should I edit biblio-koha-indexdefs.xml file to apply this condition? Thank you in advance, Reagrds. -Original Message- From: janus...@gmail.com [mailto:janus...@gmail.com] Sent: Saturday, December 3, 2016 10:20 PM To: Layale Bassil <l...@aub.edu.lb>; koha@lists.katipo.co.nz Subject: RE: [Koha] Search by Title 245 subfields $a $b only Hi Layale, Depending on what type of installation you have, you would probably have to edit /etc/koha/zebradb/marc_defs/marc21/biblios/biblio-koha-indexdefs.xml and then transform it into biblio-zebra-indexdefs.xsl (or directly edit biblio-zebra-indexdefs.xsl). But -- again, depending on the type of your installation -- be aware of possible problems with upcoming updates. Good luck! Janusz -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Layale Bassil Sent: Friday, December 2, 2016 5:23 PM To: 'koha@lists.katipo.co.nz' Subject: [Koha] Search by Title 245 subfields $a $b only Importance: High Hello, I need to know how can I edit the Zebra search in order to only search by subfields a and b when searching by title 245? The search is currently searching other subfields like c and returning non-relevant results. What files should I edit in this case? Thank you in advance, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Search by Title 245 subfields $a $b only
Hello, I need to know how can I edit the Zebra search in order to only search by subfields a and b when searching by title 245? The search is currently searching other subfields like c and returning non-relevant results. What files should I edit in this case? Thank you in advance, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Sorting Search Results for Arabic titles... Koha 3.14...
Hello Barton, Thank you for your reply. The below suggestions have nothing to do with the question related to sorting. I previously made these changes to make the search work in Arabic and I believe it is working. However sorting is not working for Arabic titles. I need to know how does sorting work and what should I do to make it work. Below are some answers which I didn’t know how to apply. Any help is highly appreciated. Regards. From: Barton Chittenden [mailto:bar...@bywatersolutions.com] Sent: Monday, November 28, 2016 6:21 PM To: Layale Bassil <l...@aub.edu.lb> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Sorting Search Results for Arabic titles... Koha 3.14... Layale, The first thing you need to do is make sure that you've set up ICU chains, which enables internationalization in Zebra. See https://wiki.koha-community.org/wiki/ICU_chains_configuration After that, you may need to customize words-icu.xml. See the Arabic section of https://wiki.koha-community.org/wiki/ICU_Chains_Library On Mon, Nov 28, 2016 at 9:52 AM, Layale Bassil <l...@aub.edu.lb<mailto:l...@aub.edu.lb>> wrote: Hello All, We are currently using Koha 3.14 and we have imported around 2000 records to Koha which have Arabic and transliterated titles. I have two questions: 1- When searching, the results are not sorted correctly if I select sort by Title (A-Z). I found 3 links online related to this topic: https://lists.katipo.co.nz/public/koha/2016-July/045731.html and this: http://lists.indexdata.dk/pipermail/zebralist/2015-March/002610.html and this: http://article.gmane.org/gmane.comp.misc.koha/19912/match=cyrillic+title. But I could not make it work for me. The search results are not being consistent. How does the sorting work? What is it sorting by when I select Title (A-Z)? 2- I need to tell Zebra to search only in 245 subfields a and b! I don't want it to search in 245 subfield c (Statement of responsibility) because it is returning irrelevant results. How can I specify only subfields a and b for the search by title? Thank you so much. Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha] KohaCon 15 Was Awesome
Hello Mr. Massoud, We are using Koha 3.14 in Arabic, but when we enter to the Advanced Search (opac-search.pl) page, the list of item types is still in English. Where can I fix this issue and enter the translations of the item types? Which files should I edit. I checked the version you have: http://maktabat.mu.edu.sa/cgi-bin/koha/opac-search.pl and everything is perfectly translated to Arabic. Thanks in advance, Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Massoud Alshareef Sent: Monday, October 26, 2015 4:25 PM To: Jesse Lambertson Cc: Koha Subject: Re: [Koha] Koha] KohaCon 15 Was Awesome AlayKum Assalam Jesse. Thank you for your email. You are correct. We have implemented Arabic Koha 3.18 here ( http://maktabat.mu.edu.sa/) at Majmaa University, which is about 150km north of Riyadh. My company, KnowledgeWare Technologies, is in charge of tthe ranslating task of Koha releases to Arabic. Here is a demo site of Arabic Koha integrated with EBSCO EDS: http://arkoha.maktabat-online.net/ . We have also localized VuFind 2.5 to Arabic, which is a very powerful a discovery portal that provides metasearch or federated search to all sorts of data sources, including Koha ILS, DSpace IR, EDS/Summon eJournals as is demonstrated here: VuFind: http://arkoha.maktabat-online.net/vufind2/ I too did not make it to KohaCon15 this year in Nigeria. I was just responding to Mr. Brooke's nice email missing to see someone attending the conference from the Middle East, which is unfortunate for us. Thanks, Massoud M. AlShareef, Correct. This is Koha OPAC at Majamaa University عالم الانجازات ينحاز دوماً مع المتفائلين The world of achievement has always belonged to the optimist! KnowledgeWare Technologies (P.O. Box 230-719) Riyadh 11321, Saudi Arabia Cel: +966 505 307 267 Email:mass...@kwareict.com Pinterest: http://pinterest.com/massoud/ Blog: http://massoudalshareef.wordpress.com/ CONFIDENTIALITY NOTE: This communication and any attachments hereto contain information that may be privileged, confidential and exempt from disclosure, and may be covered by the Electronic Communications Privacy Act, as well as other applicable laws. The information is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient or the employee or agent entrusted with the responsibility of delivering the message to the intended recipient, be aware that any review, disclosure, copying or distribution of this transmission is strictly prohibited. If you have received this communication by mistake, please delete and notify the sender immediately. Thank your for your compliance. On Mon, Oct 26, 2015 at 3:59 PM, Jesse Lambertson <jlambert...@sqcc.org> wrote: > AsSalam Alay Kum Massoud al-Shareef.. > > I was unable to make Kohacon this year, but your company did this > great instance of Koha, correct? http://maktabat.mu.edu.sa/ > > It looks great. > > Just wanted to share. Glad you had a good time. Maybe I will be able > to make it next year... > > Shukran, > > Jesse > > On Mon, Oct 26, 2015 at 1:56 AM, Massoud Alshareef > <mass...@kwareict.com> > wrote: > >> AsSalam Alay Kum Mr. Brooke, >> >> In behalf of all of us in the Arabic Koha Community, I would like to >> thank you for looking forward to meet some of us personally during >> KohaCon 15 which was held in Nigeria this year. Apparently we have >> missed a lot by not not attending this great gathering and seeing >> your beautiful cities, Lagos and Ibadan. I am sure the reason behind >> some of us not being there at this conference is because of the lack >> of information on our part about your save and beautiful country. >> >> I wish if possible to read more about this great Academic conference, >> and share with us some of the papers presented during KohaCon15 in Nigeria. >> >> We look forward to meet you during the coming Koha conferences/ >> meetings, and to know you in person. >> >> Thanks, >> Massoud M. AlShareef, >> >> عالم الانجازات ينحاز دوماً مع المتفائلين The >> world of achievement has always belonged to the optimist! >> >> KnowledgeWare Technologies >> (P.O. Box 230-719) >> Riyadh 11321, Saudi Arabia >> Cel: +966 505 307 267 >> Email:mass...@kwareict.com >> Pinterest: http://pinterest
Re: [Koha] Deleting items...
Thank you so much Hugo. One question, I was trying to delete one item manually from the database, I deleted the item from the biblioitems table but now Koha is messed up I don’t know why. I can’t import data or use Delete Batch item… this is because the item was not deleted properly or all its related data. Any suggestion here? Thanks. From: Hugo Agud [mailto:ha...@orex.es] Sent: Thursday, May 07, 2015 5:11 PM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Deleting items... Hi Layale Koha has it own module of delete items in batch , please take a look on http://manual.koha-community.org/3.18/en/batchdeleteitems.html 2015-05-07 16:04 GMT+02:00 Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb: Hello, I would like to know how can I delete the items/holdings (keeping bib records) of a certain library in Koha 3.14? Is there any interface for it? Can you help write a script for it if need be? Thank you. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- Hugo Agud - Orex Digital www.orex.eshttp://www.orex.es Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 ha...@orex.esmailto:ha...@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Deleting items...
Hello, I would like to know how can I delete the items/holdings (keeping bib records) of a certain library in Koha 3.14? Is there any interface for it? Can you help write a script for it if need be? Thank you. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing records into Koha 3.14
Thank you so much Indranil. However, I would like to know how can I update already existing items by doing a new import? Do I select Replace items if matching bib was found and I make sure that the barcode (952 $p) field is the same? Will this work? Thanks! Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: Indranil Das Gupta [mailto:indr...@gmail.com] Sent: Monday, April 20, 2015 2:51 PM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing records into Koha 3.14 Hello, On Mon, Apr 20, 2015 at 5:07 PM, Layale Bassil l...@aub.edu.lb wrote: Well nothing is being updated in the existing items. I would like to understand how the match on items is being done? What is the unique key that differentiate a 952 item from another. 952 $p - the barcode field hope that helps, -- 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 http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing records into Koha 3.14
Hello again, I realized that not all items in our system have barcodes. I need to do the mapping on the autogenerated itemnumber (952 $9). How can I change the mapping field on the 952? On another hand, is there a way to always delete all 952 and re-add them upon all imports? This will be more reliable when getting data from many sources. Please advise. Thanks. Layale. -Original Message- From: Indranil Das Gupta [mailto:indr...@gmail.com] Sent: Monday, April 20, 2015 2:51 PM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing records into Koha 3.14 Hello, On Mon, Apr 20, 2015 at 5:07 PM, Layale Bassil l...@aub.edu.lb wrote: Well nothing is being updated in the existing items. I would like to understand how the match on items is being done? What is the unique key that differentiate a 952 item from another. 952 $p - the barcode field hope that helps, -- 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 http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Importing records into Koha 3.14
Hello, I am performing a batch import of bib records and items into Koha 3.14. I am storing items into field 952. I would like to understand the meaning of the option under How to process items = Replace items if matching bib was found (only for existing items). Well nothing is being updated in the existing items. I would like to understand how the match on items is being done? What is the unique key that differentiate a 952 item from another. Your help is very much appreciated. Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha language field in mysql tables...
Hello, I am writing an SQL query to return the records in my Koha catalogue which are in Arabic (language code = ara). But I am not being able to know the database column and table where the language is stored? When importing into Koha, there is the 041 field that holds language info and field 008 location 35-37 that also holds the language code. Can you please tell me how can I query records written in a specific language? Thanks a lot, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha layout in Arabic...
Hello all, I know that Koha supports Arabic language in terms of searching, but I would like to know if there is a Koha layout in Arabic? Does anyone know how to develop such a layout? Or if there is any developed Arabic layout that I can get help from? Thanks in advance, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Fatal error on rebuild...
Hi Indra, No I did not make any changes... Once I faced this same problem but had to empty the database and re-enter all the data again! I do not want to redo this now. do you have any sugestions? Thank you. -Original Message- From: Indranil Das Gupta [mailto:indr...@gmail.com] Sent: Friday, August 08, 2014 10:44 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Fatal error on rebuild... Hello Layale, On Fri, Aug 8, 2014 at 7:16 AM, Layale Bassil l...@aub.edu.lb wrote: Thanks a lot Indra, I did as you suggested but the rebuild is giving now the following error: *** stack smashing detected ***: zebraidx terminated Did you make an changes / revisions to your icu config before attempting the re-build? -indra -- 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 http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fatal error on rebuild...
Dear all, I was doing a rebuild for Koha 3.14 and I got the following error for the first time. I was able to do many successful rebuilds: 16:03:35-07/08 zebraidx(28684) [fatal] Write failed for file isambC part 0 [No space left on device] Can I know the reason of this error and how to solve it as now the search is not returning any results since the rebuild did not succeed? Thanks and regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Modifying Search Result layout...
Hello All, I was wondering what should I do in order to be able to modify the layout of the Koha search result item display; i.e. I am using the regular search, I get the hits listed with some details about every hit. I want to modify the content of the Availability: Copies available for loan: etc... sentence. I do not want to show the number of copies for every university. I just want them listed with the (2) 2 copies showed between parentheses. What files should I edit and where can they be found? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Modify Holdings table layout...
Hello All, I would like to thank you for the help you provided in modifying the layout of the holding table. I was able to do all the below modifications but now the holding note is being too long, some of them contain lots of text and the display is being ugly. I was wondering if there is a way to edit the content of this column and show only one line of the text and add a (...) link in order to expand and show the rest of the text when clicked. Is this doable using javascript? Your help is very much appreciated. Best Regards. Layale. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Unauthenticated AUBnet User Sent: Friday, June 27, 2014 9:07 AM To: Liz Rea Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Modify Holdings table layout... Hello Liz, Many thanks for your quick reply! Can you please tell me were do I insert this line of code? Best Regards, Layale. On Jun 27, 2014, at 7:12 AM, Liz Rea l...@catalyst.net.nz wrote: $(#opac-detail th:contains('Notes')).text(Holding notes); would likely do it. Cheers, Liz On 27/06/14 16:04, Layale Bassil wrote: Hello Owen, Thanks a lot for your help. I will try your suggestions regarding the due date and barcode columns. As for the text of the Notes column, I need to replace it with another text; make it Holding notes instead of Notes. I'm talking about the holdings table inside the detailed view of the item in opac. Hope I made myself clear. Thanks again. Best Regards. On Jun 26, 2014, at 3:32 PM, Owen Leonard oleon...@myacpl.org wrote: I need to remove two columns (Date due and Barcode) You can use custom CSS to hide the date due column. Add this to the OPACUserCSS system preference: td.date_due, #item_datedue { display: none; } The barcode column can be hidden by turning off the OPACShowBarcode system preference. and change the text of the Notes columns? You'll have to be more specific about this one. What are you trying to do? Which file do I have to edit? Ideally you should never edit a Koha file because this makes upgrading Koha more difficult. You should always look for ways to use system preferences, custom CSS, or custom JavaScript to accomplish the changes you want. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.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 -- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7 ___ 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] Modify Holdings table layout...
Hello Liz, Many thanks for your quick reply! Can you please tell me were do I insert this line of code? Best Regards, Layale. On Jun 27, 2014, at 7:12 AM, Liz Rea l...@catalyst.net.nz wrote: $(#opac-detail th:contains('Notes')).text(Holding notes); would likely do it. Cheers, Liz On 27/06/14 16:04, Layale Bassil wrote: Hello Owen, Thanks a lot for your help. I will try your suggestions regarding the due date and barcode columns. As for the text of the Notes column, I need to replace it with another text; make it Holding notes instead of Notes. I'm talking about the holdings table inside the detailed view of the item in opac. Hope I made myself clear. Thanks again. Best Regards. On Jun 26, 2014, at 3:32 PM, Owen Leonard oleon...@myacpl.org wrote: I need to remove two columns (Date due and Barcode) You can use custom CSS to hide the date due column. Add this to the OPACUserCSS system preference: td.date_due, #item_datedue { display: none; } The barcode column can be hidden by turning off the OPACShowBarcode system preference. and change the text of the Notes columns? You'll have to be more specific about this one. What are you trying to do? Which file do I have to edit? Ideally you should never edit a Koha file because this makes upgrading Koha more difficult. You should always look for ways to use system preferences, custom CSS, or custom JavaScript to accomplish the changes you want. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.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 -- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7 ___ 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] Modify Holdings table layout...
Hello Owen, Thanks a lot for your help. I will try your suggestions regarding the due date and barcode columns. As for the text of the Notes column, I need to replace it with another text; make it Holding notes instead of Notes. I'm talking about the holdings table inside the detailed view of the item in opac. Hope I made myself clear. Thanks again. Best Regards. On Jun 26, 2014, at 3:32 PM, Owen Leonard oleon...@myacpl.org wrote: I need to remove two columns (Date due and Barcode) You can use custom CSS to hide the date due column. Add this to the OPACUserCSS system preference: td.date_due, #item_datedue { display: none; } The barcode column can be hidden by turning off the OPACShowBarcode system preference. and change the text of the Notes columns? You'll have to be more specific about this one. What are you trying to do? Which file do I have to edit? Ideally you should never edit a Koha file because this makes upgrading Koha more difficult. You should always look for ways to use system preferences, custom CSS, or custom JavaScript to accomplish the changes you want. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.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] Zebra Rebuild error...
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 and the rebuild was successful. My problem now is that the search is still not returning any hit eventhough the database contains 19000 records and the rebuild was successful! I would appreciate your suggestions on this matter! How can I fix the search in such a case? Many thanks, Layale. From: Phillip Ponchot [mailto:pponc...@live.com] Sent: Thursday, June 19, 2014 5:51 PM To: Layale Bassil; koha@lists.katipo.co.nz Subject: RE: [Koha] Zebra Rebuild error... Importance: High Have you ever rebuilt Koha Zebra before? The errors that you're getting reminds me of the first time I tried to rebuild zebra (ubuntu ). There was a rights issue. To rebuild zebra on ubuntu you have to use sudo -s with the rebuild command or you get a ton of errors and a failure. Hope this helps. Phillip From: l...@aub.edu.lbmailto:l...@aub.edu.lb To: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Date: Thu, 19 Jun 2014 13:28:44 +0300 Subject: [Koha] Zebra Rebuild error... Hello, I am using Koha 3.14 and importing data into it. Everything was working properly until I tried to rebuild zebra after having around 19000 records and I got the following error (a part of the error): *** stack smashing detected ***: zebraidx terminated === Backtrace: = /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7f9215503807] /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x0)[0x7f92155037d0] /usr/lib/libidzebra-2.0.so.0(+0x17007)[0x7f9215b5d007] /usr/lib/libidzebra-2.0.so.0(+0x1712b)[0x7f9215b5d12b] /usr/lib/libidzebra-2.0.so.0(heap_cread_item2+0xf2)[0x7f9215b5d2b2] /usr/lib/libidzebra-2.0.so.0(isamb_merge+0x5b)[0x7f9215b89c8b] /usr/lib/libidzebra-2.0.so.0(heap_inpb+0x193)[0x7f9215b5da23] /usr/lib/libidzebra-2.0.so.0(zebra_index_merge+0x258)[0x7f9215b5de38] /usr/lib/libidzebra-2.0.so.0(+0x298df)[0x7f9215b6f8df] /usr/lib/libidzebra-2.0.so.0(zebra_end_transaction+0x11d)[0x7f9215b7326d] /usr/lib/libidzebra-2.0.so.0(zebra_end_trans+0x31)[0x7f9215b733d1] zebraidx[0x401884] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f921541a76d] zebraidx[0x401a0d] === Memory map: 0040-00403000 r-xp 08:01 1479 /usr/bin/zebraidx-2.0 00602000-00603000 r--p 2000 08:01 1479 /usr/bin/zebraidx-2.0 00603000-00604000 rw-p 3000 08:01 1479 /usr/bin/zebraidx-2.0 009b9000-012d6000 rw-p 00:00 0 [heap] 7f920800-7f92082f4000 rw-p 00:00 0 7f92082f4000-7f920c00 ---p 00:00 0 7f920c25c000-7f920db5d000 rw-p 00:00 0 7f920db5d000-7f920db5e000 ---p 00:00 0 7f920db5e000-7f920fc5f000 rw-p 00:00 0 [stack:11507] I cannot search koha anymore as the rebuild is crashing. Is there any limitation on the number of records that Koha can accept? How can I fix this error? Please advise, Thanks and regards. Layale. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto: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] Zebra Rebuild error...
Hello, I am using Koha 3.14 and importing data into it. Everything was working properly until I tried to rebuild zebra after having around 19000 records and I got the following error (a part of the error): *** stack smashing detected ***: zebraidx terminated === Backtrace: = /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7f9215503807] /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x0)[0x7f92155037d0] /usr/lib/libidzebra-2.0.so.0(+0x17007)[0x7f9215b5d007] /usr/lib/libidzebra-2.0.so.0(+0x1712b)[0x7f9215b5d12b] /usr/lib/libidzebra-2.0.so.0(heap_cread_item2+0xf2)[0x7f9215b5d2b2] /usr/lib/libidzebra-2.0.so.0(isamb_merge+0x5b)[0x7f9215b89c8b] /usr/lib/libidzebra-2.0.so.0(heap_inpb+0x193)[0x7f9215b5da23] /usr/lib/libidzebra-2.0.so.0(zebra_index_merge+0x258)[0x7f9215b5de38] /usr/lib/libidzebra-2.0.so.0(+0x298df)[0x7f9215b6f8df] /usr/lib/libidzebra-2.0.so.0(zebra_end_transaction+0x11d)[0x7f9215b7326d] /usr/lib/libidzebra-2.0.so.0(zebra_end_trans+0x31)[0x7f9215b733d1] zebraidx[0x401884] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f921541a76d] zebraidx[0x401a0d] === Memory map: 0040-00403000 r-xp 08:01 1479 /usr/bin/zebraidx-2.0 00602000-00603000 r--p 2000 08:01 1479 /usr/bin/zebraidx-2.0 00603000-00604000 rw-p 3000 08:01 1479 /usr/bin/zebraidx-2.0 009b9000-012d6000 rw-p 00:00 0 [heap] 7f920800-7f92082f4000 rw-p 00:00 0 7f92082f4000-7f920c00 ---p 00:00 0 7f920c25c000-7f920db5d000 rw-p 00:00 0 7f920db5d000-7f920db5e000 ---p 00:00 0 7f920db5e000-7f920fc5f000 rw-p 00:00 0 [stack:11507] I cannot search koha anymore as the rebuild is crashing. Is there any limitation on the number of records that Koha can accept? How can I fix this error? Please advise, Thanks and regards. Layale. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello Hugo, Thanks a lot! I already split the files into two files as you are suggesting now. The point is that I have data from many different sources with different file formats and the data is not consistent and I have to migrate all them into Koha as a Union List. That was easy for the case of “004” but I have files with the case, where the bib and the item are split into two records into the same file and connected using the “001” tag, which means they have the same “001” tag where the difference is in the LDR only where the item/holding has “cy” or “ny” in its LDR. Do you have any suggestion on how can I split such a file? What search can I do to be able to export all items in this case (without having the 004 field)? One last question if I may, I will be migrating books from different universities, and we might have the same book in more than one university, is there a way to link these same books under one record when searching for the book and have the holdings list all the locations of the book? Or they will always be imported as two different bibs and will be returned in OPAC search as two different results? Many Thanks for the continuous support, Best Regards. From: Hugo Agud [mailto:ha...@orex.es] Sent: Wednesday, June 11, 2014 11:39 AM To: Layale Bassil Cc: Vinod Kumar Mishra; Koha list Subject: Re: [Koha] Importing data into Koha 3.14 Ok, then I misuderstood the question.. If they're alrady in the same file, you can easly filter the records with 004 field using marcedit, I think is from archive - select selected files then you can get a file just with records with 004, that they're the items records 952$a$b$o$p $ahomebranch $bholdingbranch $oitemcallnumber $pbarcode 2014-06-11 8:14 GMT+02:00 Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb: Hello Hugo, Thanks a lot for your response. One quick question before I follow your suggestions: how can I separate the biblio marc from the items? They are in the same file. is there any way to separate them and split them into different files or there is no need? I just want to know how can I import biblio marc into koha before importing the items. What is “952$abop”? I didn’t get what “bop” is. Many thanks, Regards. From: Hugo Agud [mailto:ha...@orex.esmailto:ha...@orex.es] Sent: Friday, June 06, 2014 11:52 AM To: Vinod Kumar Mishra Cc: Layale Bassil; Koha list Subject: Re: [Koha] Importing data into Koha 3.14 Hi There is no problem you have separate records from bib items, Koha imports tool it is able to join both without any problem. 1st import biblio marc into koha as usuarl 2nd ajust items marc records according the 952 requirements of koha, the most important fields 952$abop, you should map 852 into 952 the besto possible way, i suggest to copy items.001 to some empty firlds of 952 in order to be able to track 3rd change 004 into 001 in items.marc record 4rd create a new matching rule in koha to match the index control-number 5 import marc.items records into koha, assign match record using 001 note:make sure to not replace existing marc record in koha nota: maje sure to ignore new records (it shouldn't be new records) nota: configure add items. If you do wll all these steps, the items will be attached to the right bibliographic record I hope it helps 2014-06-06 10:40 GMT+02:00 Vinod Kumar Mishra vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com: Hello, At least second record should show the item details as it contains 952 field but check the location, item type field, better is to enter one record in koha then export it in marc format and view structure of exported record so that you can convert your all records accordingly. On Fri, 06 Jun 2014 13:11:36 +0530 wrote Hello,I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500=001 115761=005 20100208102331.0=008 740909u1972ir\grh0\\\a0eng\u=010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S=035file:///\\$a(CStRLIN)NYCX1001547S=035 \\$a(NIC)notisAAM7160=035file:///\\$a(NIC)notisAAM7160=035 \\$a(OCoLC)1001547=035file:///\\$a(OCoLC)1001547=035 \\$a115761=040file:///\\$a115761=040 \\$cPU$dNIC$dCStRLIN=050file:///\\$cPU$dNIC$dCStRLIN=050 0\$aCT1886$b.I7=082 \\$a920/.055=245file:///\\$a920\.055=245 00$aIran who's who.=260 \\$aTehran,$bEchofile:///\\$aTehran,$bEcho of Iran.=300 \\$av.$c21file:///\\$av.$c21 cm.=362 0\$a1st- ed.; 1972-=651 \0$aIran$xBiography=905 \\$a1992030912.0=948file:///\\$a1992030912.0=948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950 \\$lREF
Re: [Koha] Importing data into Koha 3.14
Hello Hugo, Thanks a lot for your response. One quick question before I follow your suggestions: how can I separate the biblio marc from the items? They are in the same file. is there any way to separate them and split them into different files or there is no need? I just want to know how can I import biblio marc into koha before importing the items. What is “952$abop”? I didn’t get what “bop” is. Many thanks, Regards. From: Hugo Agud [mailto:ha...@orex.es] Sent: Friday, June 06, 2014 11:52 AM To: Vinod Kumar Mishra Cc: Layale Bassil; Koha list Subject: Re: [Koha] Importing data into Koha 3.14 Hi There is no problem you have separate records from bib items, Koha imports tool it is able to join both without any problem. 1st import biblio marc into koha as usuarl 2nd ajust items marc records according the 952 requirements of koha, the most important fields 952$abop, you should map 852 into 952 the besto possible way, i suggest to copy items.001 to some empty firlds of 952 in order to be able to track 3rd change 004 into 001 in items.marc record 4rd create a new matching rule in koha to match the index control-number 5 import marc.items records into koha, assign match record using 001 note:make sure to not replace existing marc record in koha nota: maje sure to ignore new records (it shouldn't be new records) nota: configure add items. If you do wll all these steps, the items will be attached to the right bibliographic record I hope it helps 2014-06-06 10:40 GMT+02:00 Vinod Kumar Mishra vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com: Hello, At least second record should show the item details as it contains 952 field but check the location, item type field, better is to enter one record in koha then export it in marc format and view structure of exported record so that you can convert your all records accordingly. On Fri, 06 Jun 2014 13:11:36 +0530 wrote Hello,I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500=001 115761=005 20100208102331.0=008 740909u1972ir\grh0\\\a0eng\u=010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S=035file:///\\$a(CStRLIN)NYCX1001547S=035 \\$a(NIC)notisAAM7160=035file:///\\$a(NIC)notisAAM7160=035 \\$a(OCoLC)1001547=035file:///\\$a(OCoLC)1001547=035 \\$a115761=040file:///\\$a115761=040 \\$cPU$dNIC$dCStRLIN=050file:///\\$cPU$dNIC$dCStRLIN=050 0\$aCT1886$b.I7=082 \\$a920/.055=245file:///\\$a920\.055=245 00$aIran who's who.=260 \\$aTehran,$bEchofile:///\\$aTehran,$bEcho of Iran.=300 \\$av.$c21file:///\\$av.$c21 cm.=362 0\$a1st- ed.; 1972-=651 \0$aIran$xBiography=905 \\$a1992030912.0=948file:///\\$a1992030912.0=948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950 \\$lREF$aDS271$b.I65$e\Lastfile:///\\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N=995 \\$aHivolm$d20100208=LDRfile:///\\$aHivolm$d20100208=LDR 00742cy a22001333 4500=001 151381=004 115761=005 20060220173142.0=008 9301235u8\\\2\\\uu\\=014 1\$aAAM7160CU001=014 0\$9000148016=852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003=866 \1$a1st-2nd,4th ed. (1972-1974,1993)=952 \\$yCR$colin$2z$z-$bolin,anx$oDS271file:///\\$yCR$colin$2z$z-$bolin,anx$oDS271 .I65$acornell$p115761Many Thanks,Layale.From: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: Re: RE: [Koha] Importing data into Koha 3.14Hello, =004 115761 =952 \\$p115761file:///\\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.commailto:vinod_librar
[Koha] Importing data into Koha 3.14
Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055 =245 00$aIran who's who. =260 \\$aTehran,$bEcho of Iran. =300 \\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly. Many thanks, Regards. From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14 Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$pfile:///\\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547Sfile:///\\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160file:///\\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547file:///\\$a(OCoLC)1001547 =035 \\$a115761file:///\\$a115761 =040 \\$cPU$dNIC$dCStRLINfile:///\\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055file:///\\$a920\.055 =245 00$aIran who's who. =260 \\$aTehran,$bEchofile:///\\$aTehran,$bEcho of Iran. =300 \\$av.$c21file:///\\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0file:///\\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Lastfile:///\\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208file:///\\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com : mishrav...@gmail.commailto:mishrav...@gmail.com [http://sigads.rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatureline.htm@Middle]http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Get your own FREE website, FREE domain FREE mobile app with Company email. Know More http://track.rediff.com/click?url=___http://businessemail.rediff.com/email-ids-for-companies-with-less-than-50-employees?sc_cid=sign-1-10-13___cmp=hostlnk=sign-1-10-13nsrv1=host ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055 =245 00$aIran who's who. =260 \\$aTehran,$bEcho of Iran. =300 \\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00742cy a22001333 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$a1st-2nd,4th ed. (1972-1974,1993) =952 \\$yCR$colin$2z$z-$bolin,anx$oDS271 .I65$acornell$p115761 Many Thanks, Layale. From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: RE: [Koha] Importing data into Koha 3.14 Hello, =004 115761 =952 \\$p115761file:///\\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$pfile:///\\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547Sfile:///\\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160file:///\\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547file:///\\$a(OCoLC)1001547 =035 \\$a115761file:///\\$a115761 =040 \\$cPU$dNIC$dCStRLINfile:///\\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208file:///\\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860
Re: [Koha] Importing items problem
Hello John, I am facing the exact same problem trying to import records to Koha where the items are stored under tag 945. How can I benefit from MarcEdit to do the conversion? I can swap the fields data from 945 to 952 using the Swap Field Utility. What about the subfields? Wont they overlap? Please advise. Thanks. -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of John Palmer Sent: Friday, November 29, 2013 5:32 PM To: Željko Puškarić Cc: Koha Subject: Re: [Koha] Importing items problem You might be able to just map the fields to do the conversion. The MARCEdit (http://marcedit.reeset.net/) might have the tools to help you do the conversion. On Fri, Nov 29, 2013 at 7:29 AM, Željko Puškarić zpuska...@sabor.hr wrote: Looks like UNIMARC field 995 is equivalent of MARC21 field 952, at least according to the web page you sent. With Best Regards, Željko Puškarić On 11/29/2013 04:22 PM, John Palmer wrote: Check to see if you need create the items in the 952 field for importing data to Koha. http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) I encountered the same problem when importing our museum's MARC21 catalog records The records were placed in the reservoir, but no corresponding item was created for circulation. Adding an additional 952 field to each entry with the minimum set of Koha specific items (952$a, 952$b, 952$p, 952$y), the item record was added to circulation in addition to the catalog data. I do not know if UNIMARC has additional implications. Best, John On Fri, Nov 29, 2013 at 6:53 AM, Željko Puškarić zpuska...@sabor.hrwrote: Hi everyone, I am trying to solve a problem of importing biblio records into Koha. the problem is that after import there aren't any items created. Biblios and biblioitems get created. Based on a record that I created in Koha which looks like (MARCXML format): ?xml version=1.0 encoding=UTF-8? record xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation=http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd; xmlns=http://www.loc.gov/MARC21/slim; leader00791a22003250004500/leader controlfield tag=00121414/controlfield datafield tag=010 ind1= ind2= subfield code=a9536160-09-9/subfield /datafield datafield tag=090 ind1= ind2= subfield code=a21414/subfield /datafield datafield tag=100 ind1= ind2= subfield code=a20131126 frey50 /subfield /datafield datafield tag=101 ind1= ind2= subfield code=ahrv/subfield /datafield datafield tag=102 ind1= ind2= subfield code=aHR/subfield /datafield datafield tag=200 ind1= ind2= subfield code=aBogovi, elite, narodi/subfield subfield code=estudija/subfield subfield code=fVjeran Katunari#x107;/subfield /datafield datafield tag=210 ind1= ind2= subfield code=aZagreb/subfield subfield code=cIzdanja Antibarbarusa/subfield subfield code=d1994/subfield /datafield datafield tag=215 ind1= ind2= subfield code=a225 str./subfield subfield code=c20 cm/subfield /datafield datafield tag=225 ind1= ind2= subfield code=aBiblioteka Electa/subfield /datafield datafield tag=320 ind1= ind2= subfield code=aBibliografije: str. 247-254 i uz tekst/subfield /datafield datafield tag=610 ind1= ind2= subfield code=aKultura i civilizacija/subfield /datafield datafield tag=610 ind1= ind2= subfield code=aElite/subfield /datafield datafield tag=610 ind1= ind2= subfield code=aReligija/subfield /datafield datafield tag=610 ind1= ind2= subfield code=aDr#x17E;ava/subfield /datafield datafield tag=610 ind1= ind2= subfield code=aEtatizam/subfield /datafield datafield tag=700 ind1= ind2= subfield code=3000407/subfield subfield code=aKatunari#x107;/subfield subfield code=bVjeran/subfield /datafield datafield tag=801 ind1= ind2= subfield code=aHR/subfield subfield code=bNSB/subfield subfield code=gHR PPIAK/subfield /datafield datafield tag=901 ind1= ind2= subfield code=6M/subfield /datafield datafield tag=908 ind1= ind2= subfield code=4FND/subfield /datafield datafield tag=942 ind1= ind2= subfield code=cBK/subfield /datafield datafield tag=946 ind1= ind2= subfield code=100/subfield /datafield datafield tag=990 ind1= ind2= subfield code=aC-114/subfield /datafield datafield tag=991 ind1= ind2= subfield code=61/subfield subfield code=b24267/subfield /datafield datafield tag=998 ind1= ind2= subfield code=a941107004/subfield /datafield datafield tag=995 ind1= ind2= subfield code=f0/subfield subfield code=00/subfield subfield code=96707/subfield subfield code=cSabor/subfield
Re: [Koha] How to clean Koha imported records?
Hello All, Hope all is good. I followed the suggestion below: Before re-importing your data, organize your holdings into tag 952, using the 'items' mapping at Administration/Koha to MARC Mapping. When I import now, I get that 20 records were successfully imported and 900 items too (as an example). But when I open the table items, it is still empty! And the holdings of each record are empty too while they should show the imported items. But if I open the import_items table, I can find the imported items. Can you please advise? Do I have to commit the import of the items or what? When does Koha store the imported items into the items table? Or he keeps them in the import_items? Thanks. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Bob Birchall Sent: Monday, April 07, 2014 2:08 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? I had guessed that was the case from your last post, but I went to dinner instead of answering you. Sorry. I have not reviewed this whole thread, but I think your situation is this: - you have a Koha instance that you want to use for production; - you have imported bibliographic data into that instance, that you now wish to delete; - you did not import any items, as you had the holdings information in a field other than 952; - you have 'cleaned' the import batch, so it cannot now be reversed. Is that right? Then: - did you test any circulation transactions? If so, truncate the 'accountlines', 'issues', 'reserves', 'oldissues' and 'oldreserves' tables; - did you import any authorities? If so, truncate the auth_header table; - truncate the biblio and biblioitems tables; - truncate the zebraqueue table. That will pretty much get you back to your configured Koha with no bibliographic data. Before re-importing your data, organise your holdings into tag 952, using the 'items' mapping at Administration/Koha to MARC Mapping. And before using any more features like 'clean', read the manual. :) That should do it. Best wishes, Bob Birchall Calyx On 07/04/14 20:27, Layale Bassil wrote: Hello again dear Jerwyn, I realized that the items were not imported into Koha. In fact I was checking the mappings under: Administration Koha to MARC mapping, I realized that the items use the Tag = 952 while we are exporting them under Tag = 945. Do you think this is the reason? What should be done to fix this issue and be able to import the items when importing the records? Thanks in advance, Regards. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Saturday, April 05, 2014 2:47 AM To: Layale Bassil Cc: Fischer, Katrin; koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in Create report from SQL SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the barcode of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don't want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer - Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649tel:%2B961%20%281%29%2035%20x%203649 | M: +961 (03) 929876tel:%2B961%20%2803%29%20929876 E: l...@aub.edu.lbmailto:l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen... Save a Tree... -Original Message- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.demailto:katrin.fisc...@bsz-bw.de] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have
Re: [Koha] How to clean Koha imported records?
Hello Jerwyn, Thanks a lot for the continuous support. In fact when I ran the below SQL script after creating the report, I got 0 results. It seems the items were not imported to the items table. I modified the query, I realized that the items are in the biblio and biblioitems table but not in the items table. SELECT biblio.title, biblioitems.biblionumber, items.itemnumber, items.barcode FROM biblio LEFT JOIN biblioitems on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN items on items.biblioitemnumber=biblioitems.biblioitemnumber order by biblio.biblionumber asc This one returned all the records I imported but with itemnumber and barcode empty. They are not in the items table. Why is that? What can I do in this case? Maybe the only left solution is the clear the below 6 tables. Please advise, Regards. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Sunday, April 06, 2014 8:33 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? Hi Layale, Yes all records has itemnumber you may use that. Regards, - Jerwyn On Sat, Apr 5, 2014 at 1:02 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Jerwyn, Thanks a lot for your help! In fact we are importing data from many sources which are not consistent, so not all items have barcodes... Do you suggest that I use the itemnumber? Will all items have an itemnumber when imported? Is it generated by Koha? On another hand, I read in the wiki that I need to truncate the following tables: * bibio * biblioitems * items * auth_header * sessions * zebraqueue What do you suggest? Many Thanks, Regards. On Apr 5, 2014, at 2:46 AM, Jerwyn Fernandez jerwyn_fernan...@southville.edu.phmailto:jerwyn_fernan...@southville.edu.ph wrote: Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in Create report from SQL SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the barcode of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don't want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer - Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649tel:%2B961%20%281%29%2035%20x%203649 | M: +961 (03) 929876tel:%2B961%20%2803%29%20929876 E: l...@aub.edu.lbmailto:l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen... Save a Tree... -Original Message- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.demailto:katrin.fisc...@bsz-bw.de] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have cleaned the batch, that is no longer possible. Probably easiest now would be to delete the records from the database using SQL. Hope this helps, Katrin -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Layale Bassil Sent: Friday, April 04, 2014 2:45 PM To: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: [Koha] How to clean Koha imported records? Importance: High Hello, I am running Koha 3.14. I imported several batches for testing purposes, but I need to delete those records so I go to Manage staged MARC records and press on Clean. When I search the OPAC, I can still see those records as if they were not deleted! I rebuilt zebra as well as restarted the zebra index but still in vain. I need to delete all the previously imported records and start a fresh clean catalogue. Any suggestions would be greatly appreciated. Regards. ___ Koha
Re: [Koha] How to clean Koha imported records?
Hello again dear Jerwyn, I realized that the items were not imported into Koha. In fact I was checking the mappings under: Administration Koha to MARC mapping, I realized that the items use the Tag = 952 while we are exporting them under Tag = 945. Do you think this is the reason? What should be done to fix this issue and be able to import the items when importing the records? Thanks in advance, Regards. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Saturday, April 05, 2014 2:47 AM To: Layale Bassil Cc: Fischer, Katrin; koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in Create report from SQL SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the barcode of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don't want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer - Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649tel:%2B961%20%281%29%2035%20x%203649 | M: +961 (03) 929876tel:%2B961%20%2803%29%20929876 E: l...@aub.edu.lbmailto:l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen... Save a Tree... -Original Message- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.demailto:katrin.fisc...@bsz-bw.de] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have cleaned the batch, that is no longer possible. Probably easiest now would be to delete the records from the database using SQL. Hope this helps, Katrin -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Layale Bassil Sent: Friday, April 04, 2014 2:45 PM To: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: [Koha] How to clean Koha imported records? Importance: High Hello, I am running Koha 3.14. I imported several batches for testing purposes, but I need to delete those records so I go to Manage staged MARC records and press on Clean. When I search the OPAC, I can still see those records as if they were not deleted! I rebuilt zebra as well as restarted the zebra index but still in vain. I need to delete all the previously imported records and start a fresh clean catalogue. Any suggestions would be greatly appreciated. Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to clean Koha imported records?
Hello Bob, 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. Hope the import will work now and the data will be correctly mapped. Best Regards, Layale. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Bob Birchall Sent: Monday, April 07, 2014 2:08 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? I had guessed that was the case from your last post, but I went to dinner instead of answering you. Sorry. I have not reviewed this whole thread, but I think your situation is this: - you have a Koha instance that you want to use for production; - you have imported bibliographic data into that instance, that you now wish to delete; - you did not import any items, as you had the holdings information in a field other than 952; - you have 'cleaned' the import batch, so it cannot now be reversed. Is that right? Then: - did you test any circulation transactions? If so, truncate the 'accountlines', 'issues', 'reserves', 'oldissues' and 'oldreserves' tables; - did you import any authorities? If so, truncate the auth_header table; - truncate the biblio and biblioitems tables; - truncate the zebraqueue table. That will pretty much get you back to your configured Koha with no bibliographic data. Before re-importing your data, organise your holdings into tag 952, using the 'items' mapping at Administration/Koha to MARC Mapping. And before using any more features like 'clean', read the manual. :) That should do it. Best wishes, Bob Birchall Calyx On 07/04/14 20:27, Layale Bassil wrote: Hello again dear Jerwyn, I realized that the items were not imported into Koha. In fact I was checking the mappings under: Administration Koha to MARC mapping, I realized that the items use the Tag = 952 while we are exporting them under Tag = 945. Do you think this is the reason? What should be done to fix this issue and be able to import the items when importing the records? Thanks in advance, Regards. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Saturday, April 05, 2014 2:47 AM To: Layale Bassil Cc: Fischer, Katrin; koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in Create report from SQL SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the barcode of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don't want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer - Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649tel:%2B961%20%281%29%2035%20x%203649 | M: +961 (03) 929876tel:%2B961%20%2803%29%20929876 E: l...@aub.edu.lbmailto:l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen... Save a Tree... -Original Message- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.demailto:katrin.fisc...@bsz-bw.de] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have cleaned the batch, that is no longer possible. Probably easiest now would be to delete the records from the database using SQL. Hope this helps, Katrin -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.kat ipo.co.nz] On Behalf Of Layale Bassil Sent: Friday, April 04, 2014 2:45 PM To: koha@lists.katipo.co.nzmailto:koha
[Koha] How to clean Koha imported records?
Hello, I am running Koha 3.14. I imported several batches for testing purposes, but I need to delete those records so I go to Manage staged MARC records and press on Clean. When I search the OPAC, I can still see those records as if they were not deleted! I rebuilt zebra as well as restarted the zebra index but still in vain. I need to delete all the previously imported records and start a fresh clean catalogue. Any suggestions would be greatly appreciated. Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to clean Koha imported records?
Hello Jerwyn, Thanks a lot for your help! In fact we are importing data from many sources which are not consistent, so not all items have barcodes... Do you suggest that I use the itemnumber? Will all items have an itemnumber when imported? Is it generated by Koha? On another hand, I read in the wiki that I need to truncate the following tables: * bibio * biblioitems * items * auth_header * sessions * zebraqueue What do you suggest? Many Thanks, Regards. On Apr 5, 2014, at 2:46 AM, Jerwyn Fernandez jerwyn_fernan...@southville.edu.phmailto:jerwyn_fernan...@southville.edu.ph wrote: Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in Create report from SQL SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the barcode of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil l...@aub.edu.lbmailto:l...@aub.edu.lb wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don’t want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649tel:%2B961%20%281%29%2035%20x%203649 | M: +961 (03) 929876tel:%2B961%20%2803%29%20929876 E: l...@aub.edu.lbmailto:l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.demailto:katrin.fisc...@bsz-bw.de] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have cleaned the batch, that is no longer possible. Probably easiest now would be to delete the records from the database using SQL. Hope this helps, Katrin -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nzmailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Layale Bassil Sent: Friday, April 04, 2014 2:45 PM To: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: [Koha] How to clean Koha imported records? Importance: High Hello, I am running Koha 3.14. I imported several batches for testing purposes, but I need to delete those records so I go to Manage staged MARC records and press on Clean. When I search the OPAC, I can still see those records as if they were not deleted! I rebuilt zebra as well as restarted the zebra index but still in vain. I need to delete all the previously imported records and start a fresh clean catalogue. Any suggestions would be greatly appreciated. Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search problems
Hello All, I tried to apply the below fix, but everytime I execute the zebra rebuild function, I get the following error: 11:14:23-13/02 zebraidx(2157) [warn] default.idx:13: Failed to load ICU chain words-icu.xml Any suggestions of what might be wrong? Your help is very much appreciated. Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Witoszynskyj Stephan Sent: Monday, January 06, 2014 4:40 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Search problems Hi Katrin, thank’s a lot! This solved my problem. Apparently, the only thing that was necessary was to switch to yaz-icu and to modify zebradb/etc/default.idx accordingly. I did not create a transliteration table. Thank you very much again! Stephan Am 06.01.2014 um 11:10 schrieb Fischer, Katrin katrin.fisc...@bsz-bw.de: Hi Stephan, in order to search non latin scripts with Koha correctly you need to make sure that you are using ICU with Zebra. Then the search should work nicely. Some notes on how to activate ICU indexing can be found on the wiki - it should also work for Ukrainian: http://wiki.koha-community.org/wiki/Correcting_Search_of_Arabic_record s Hope this helps, Katrin -Ursprüngliche Nachricht- Von: koha-boun...@lists.katipo.co.nz im Auftrag von Witoszynskyj Stephan Gesendet: Mo 06.01.2014 08:42 An: koha@lists.katipo.co.nz Betreff: [Koha] Search problems Hi, I am new to Koha. I basically just set-up a fresh Koha 3.14 installation on Ubuntu 13.10 using the Debian packages from http://debian.koha-community.org/ We are a small library with mostly Ukrainian books. We want to catalogue the books in original language (Ukrainian) and therefore in Cyrillic script. After testing Koha after cataloging the first couple of books I experienced the following problem when searching in the Opac: Whenever I entered any arbitrary combination of Cyrillic characters (not even real words) in the search field Koha returned all records in the catalogue. Whether there was a match or not. If I did the same in Latin script the search only returned matching records only. Searching for authorities in the worked if I searched with the is exactly option. If I had starts with or contains it worked only for search in main entry, but not for search in keyword or any heading. Does anyone have an idea what could be wrong? Regards, Stephan ___ 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] Search problems
Thanks a lot again for your reply. I checked all the below and they were correct. I just noticed that the error is coming from the Arabic characters that define the rules inside the words-icu.xml file. For example: transliterate rule={ الا ا / Is there anything related to installing the Arabic support on the Koha server? When I remove all the Arabic characters from the file, everything works fine. Thanks again, Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Zeno Tajoli Sent: Thursday, February 13, 2014 4:53 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Search problems Hi, Il 13/02/2014 15:43, Layale Bassil ha scritto: Thank you for your reply. Yes I am trying to use Arabic alphabet with Koha. I tried the procedure in the link below but when I rebuild Zebra I get the error. The file words-icu.xml is in the same folder as default.idx. Any other suggestions? the only other suggestions that I can do are: -- check the owner of default.idx and words-icu.xml files. Is it the same ? -- check the permissions of default.idx and words-icu.xml files. -- check that words-icu.xml is a Unix file, without dos end of lines and end of file. I don't know more options. Bye Zeno Tajoli -- 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 mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha Theme
Dear All, I would like to know if there is a step-by-step guide to learn how to change the look of a Koha website? Is there any ready theme that can be downloaded and used? Does the latest version of Koha (3.14) make it easier to change the look of Koha? Thanks in advance, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Opac can't show non-latin characters correctly
Hello Peter, Were you able to solve the below problem? Well I am facing this same problem with Arabic text... when the refine your search is used, the search returns no resutls while when searching in other areas like Cataloging, results were returned. Any suggestion on how to fix this problem? Another thing, some Arabic text is split and doesn't correctly show; though I read that Koha supports Arabic characters. Regards, Thanks. -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Peter Zhao Sent: Tuesday, April 23, 2013 9:22 AM To: koha@lists.katipo.co.nz Subject: [Koha] Opac can't show non-latin characters correctly Hi, Warmly greetings. Could anyone know why in the Refine your search column area of OPAC can not show non-latin characters ? But in the other area of the OPAC can show non-latin characters. Anyone know how to fix this problem? Thanks a lot. Peter ___ 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 Help
Hello Sander, Well thanks a lot for your reply. You are right, I guess it is a database issue. In fact I got the Koha 3.8 version from this link: http://download.koha-community.org/koha-3.08.10.tar.gz. Someone helped me installing it. Can you please just explain to me how can I delete the database and make a new one and use the Web Interface to redo the installation and from where I can install all the samples? Thanks again. Regards. Layale Bassil Software Engineer – Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 35 x 3649 | M: +961 (03) 929876 E: l...@aub.edu.lb W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen… Save a Tree... -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Sander898 Sent: Wednesday, March 20, 2013 5:15 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Help Hello Bassil, it may be a problem of the database. Do you perform a new installation? If yes you can try to delete the database and make a new one, then redo the installation of Koha via the Web Interface, and install all the samples (framework, patron, etc...). Regards Sander -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Help-tp5746880p5746882.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] Koha Support
Hello All, I am new to Koha, we have downloaded version 3.10.3 found here (http://download.koha-community.org/). I have couple of questions: 1- I couldn't find any documentation or tutorials which help us to start using Koha; i.e. initial settings, etc... 2- How can we import sample data to start seeing some records in Koha? 3- We tried to create a new Framework, the code and description are always kept empty in the grid and when we try to import a certain framework into the newly created framework, we get an error even though the framework being imported has the correct format (csv or sql, etc...) 4- When we try to create a new Catalog, we select the Default framework, the new page is always empty and the fields are not being displayed to be filled. Above are some errors we were getting, I would like to know what might the problem be? Is it a problem in the installation? Are we missing any settings for Koha to start working properly? Is it a security issue? Your help is very much appreciated... Best Regards, Layale. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha