- Koha - lists.katipo.co.nz

sql query / number of items
by Samuel Desseaux 18 Jan '13

18 Jan '13

Hi, I need to write a sql query to count the number of 995 field in the records which i 've imported. An idea? Best, samuel

3 2

Re: [Koha] Merge records (was add only item info for duplicate records)
by Elaine Bradtke 17 Jan '13

17 Jan '13

On Thu, Jan 17, 2013 at 8:31 AM, soulemane moumie <moumie23(a)yahoo.fr> wrote: > Hi Elaine! > Thanks for taking your precious time to answer my questions. > Please what you meant by "Once in Koha you can merge biblios, to get all > the items into one record, ". Are saying that there is an option in koha > for merging identical record ? > Or doing it manually ? > I really appreciate your help. I am new to koha and I am going to > implement/customize it for our library. > > Yes, you can merge records in Koha. This combines the information (including item records) into one biblio. To do this: Search for the title. Select the items you wish to merge and save them to a list. Go to the list and again select the titles you wish to merge Click on the button (at the bottom of the list ) "Merge selected records" You will be asked to choose a reference record - think of this as the base record into which any other information will be added (so if one record is more complete than the other, choose that one). Click the "Next" button The merging records are displayed under tabs on the left with the reference record on top and the final version on the right under Destination record. Look at the other tabs and compare them with the destination record, click on any fields you wish to add to the destination record. When you have finished adding fields to the destination record, click "Merge" It will automatically move any items from the old records over to the new record. As you can see, it takes some time and effort to do this. This is why it may be quicker to combine the records offline before uploading them. Still, sometimes my colleagues forget to search our catalogue before adding another record, and when I find the duplicates I merge them. I hope this helps Elaine Regards. > > > > > *Moumi*é* Soul*é*mane > Assistant Programmer, OCP, MCTS, JCP > Department of Computer Science Engineering > Islamic University of Technology(IUT) > Board Bazar, Gazipur-1704, Bangladesh. > Cellular: +880192-1628880,+8801921628880* > > > --- En date de : *Mer 16.1.13, Elaine Bradtke <eb(a)efdss.org>* a écrit : > > > De: Elaine Bradtke <eb(a)efdss.org> > Objet: Re: [Koha] add only item info for duplicate records > À: "soulemane moumie" <moumie23(a)yahoo.fr> > Date: Mercredi 16 janvier 2013, 22h36 > > > We moved all the item info to a single book record before importing. Our > old database allows us to run a de-duplication script and then I manually > combined the duplicate records. Yes, it's a pain. Once in Koha you can > merge biblios, to get all the items into one record, but I wouldn't want to > do this for a large number of things. > It would be nice if there were an easier way, I just don't know what it is. > Elaine > On Wed, Jan 16, 2013 at 6:45 AM, soulemane moumie <moumie23(a)yahoo.fr<http://mc/compose?to=moumie23@yahoo.fr> > > wrote: > > Hi! > I want to import my newly created marc file into koha. > Everything is imported successfully in the koha empty database and > re-indexed. > The problem is that I have duplicated titles. > e.g: > book1: introduction to koha nber of item: 1 > book2: introduction to koha nber of item: 1 > book3: introduction to koha nber of item: 1 > > but I want to have : > book: introduction to koha nber of item: 3 > > If I set a matching rule, the import stalls after staging. > > Matching rule: > Matching rule code : TITLE > Description: 245$a > Match threshold: 100 > > Match point: > Search index: Title > Score: 101 > > Matching component: > Tag: 245 > subfields: a > offset: 0 > length: 0 > Normalization rule: TITLE > > Question: > Is it possible to do this in koha ? > for each duplicate marc record : > Koha does not add it but instead add the item info under existing record > increase the number of item under the duplicate record. > Should I add only record info and add items info manually ? But with more > than 40 000 books it will be a nightmare > Thanks for helping ! > > > > > > > Moumié Soulémane > Assistant Programmer, OCP, MCTS, JCP > Department of Computer Science Engineering > Islamic University of Technology(IUT) > Board Bazar, Gazipur-1704, Bangladesh. > Cellular: +880192-1628880,+8801921628880 > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz <http://mc/compose?to=Koha@lists.katipo.co.nz> > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance > and Song Society in London, England. If you wish to phone me personally, > send an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

reindexing with zebra
by Samuel desseaux 17 Jan '13

17 Jan '13

Hi, While reindexing zebra, i've this message and some warns i don't understand. Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 090$9 BIBLIOITEMNUMBER in : 090$a ================================ ==================== exporting authority ==================== 701.................................................................................................... Records exported: 758 ==================== REINDEXING zebra ==================== 15:41:06-17/01 zebraidx(10724) [warn] /etc/koha/zebradb/authorities/etc/dom-config-marc.xml: stylesheet authority-zebra-indexdefs.xsl not found in path /etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/unimarc/authorities:/etc/koha/zebradb/lang_defs/fr:/etc/koha/zebradb/xsl 15:41:06-17/01 zebraidx(10724) [warn] /etc/koha/zebradb/authorities/etc/dom-config-marc.xml: stylesheet authority-zebra-indexdefs.xsl not found in path /etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/unimarc/authorities:/etc/koha/zebradb/lang_defs/fr:/etc/koha/zebradb/xsl ==================== exporting biblio ==================== 41801.................................................................................................... Records exported: 41805 ==================== REINDEXING zebra ==================== 15:49:11-17/01 zebraidx(10729) [warn] Unknown register type: Best, samuel

1 0

Koha - Label Creator
by Maxine Murphy 17 Jan '13

17 Jan '13

I would like to create labels for Dewey Numbers for narrow books. The Label Creator does not seem to want to print numbers/letters in a vertical line, one after each other. 1 2 3 ' A B C Has anyone used the Label Creator. cheers Maxine Murphy Technical Services and Systems Administrator Waitaki District Libraries P O Box 134 Oamaru Phone - (03)433-0850

2 1

HELP NEEDED
by Dennis Njuguna 17 Jan '13

17 Jan '13

Hello everyone, I do have a quest*ion or t*wo. 1. I am installing vmware on windows server 2008 R2 but on finishing it is disconnecting from the network *why is this?*, I needed to run ubuntu and koha in it now im forced to roll all the way back to koha 2.2.9 windows ;-( before you fry me, can someone please guide me on how to import Marc records in 2.2.9 version? Dennis K. Njuguna

1 0

check in /check out fails
by Samuel Desseaux 17 Jan '13

17 Jan '13

Hi, Upon trying to check items out to a patron this message appears: -- Software error: Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 3008. The item gets checked out (i.e. it appears in the list of items checked out to the client when you go return to the checkout page). The same happens with check in. The items get checked in, but Koha stops at the error message. What can i do? best, samuel

2 2

catalog card printing
by schnydszch 16 Jan '13

16 Jan '13

good day koha users. we are using koha but have not gone live yet, i would like to know how to print card catalog from koha for shelflist purposes. thanks. -- View this message in context: http://koha.1045719.n5.nabble.com/catalog-card-printing-tp4386976p4386976.h… Sent from the Koha - Discuss mailing list archive at Nabble.com.

4 5

automated response
by georgew 16 Jan '13

16 Jan '13

I will be away from my desk until January 29, 2013. If you need to contact someone at the library urgently please call 208-882-3925. George

1 0

About the realesed time history....
by John Herz 16 Jan '13

16 Jan '13

I would like to know where I can find the realesed time history of Koha from the beginning or aproach of it? Thank you in advance,

6 8

about records in koha pro
by Samuel Desseaux 16 Jan '13

16 Jan '13

Hi, I've a question of my colleagues. In the opac, when i'm looking for something, i've the results and when i choose one of the results, i can add a link to come back to the results and another link to the search example: i make a research and it gives the results http://koha.ecp.fr:8080/cgi-bin/koha/catalogue/search.pl?q=eau I choose one of the result and there, i 'd be able to see the next record which is in the list of results. Is it possible? I hope that you will understand my request. Best regards, samuel

1 0