- Koha - lists.katipo.co.nz

about the research in koha
by Samuel Desseaux 20 Jun '13

20 Jun '13

Hi, Some questions about the research *date of publishing is linked to field 210$d and 305 (we use Unimarc): how can we delete the field 305? I suppose it's in zebra *we would like to make research on the date of record creation: is it possible (and how?) Thank you for your help Samuel

1 0

Koha lost and replaced by another item
by schnydszch 20 Jun '13

20 Jun '13

Good day koha users & developers! How do you deal with lost items by a patron but replaced by another item with a different title? I read up the manual, lost status is in 952$1 MARC tag and I have long overdue (lost), lost, lost and paid for, missing, replaced and withdrawn. What I did is set status for the item as replaced but to show that the item was replaced by another item is what I'm lost at. Is there a way to do this? This will show in the intranet, not the OPAC. How this is done in other Koha libraries? thanks & cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-lost-and-replaced-by-another-item-tp… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

New SQL Report - Terms not in the Authorities
by Cab Vinton 19 Jun '13

19 Jun '13

Formatted a bit strangely on the SQL Reports page; hopefully cleaned up below. Cab Vinton Sanbornton Public Library Developer: Adapted from a report by Bernardo Ganzalex Kriegel Module: Catalog Purpose: List of terms found on biblio records in 6XX fields that are not linked to authority records Status: Production SELECT DISTINCT heading FROM ( SELECT ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(marcxml,'//datafield[@tag="611"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml,'//datafield[@tag="611"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml,'//datafield[@tag="611"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading

1 0

Report help needed
by Elaine Bradtke 19 Jun '13

19 Jun '13

I'm tracking down some unauthorized subject headings and have run into a problem with a term that is far too common in our catalogue to be useful in any kind of search. I'm trying to devise a report that will look for 650 fields with a subfield a, but without a subfield 9 - But the second half of what I need - a report of not just the rogue term, but also the biblio number of the record that it is in. I have tried several things but cannot get it to work. The functional part of my report is here: SELECT DISTINCT heading FROM ( SELECT ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading This gives a list of headings in 650 fields that are not linked to authorities Can anyone help me add in the query that will return the biblionumber too? Thanks in advance -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 2

Generating reports of values in 001
by glenda.claborne 19 Jun '13

19 Jun '13

Hello, there have been previous posts on this issue but no satisfactory answers yet. I have posted the following query in Nicole Engard's ByWater Solutions website and she has referred me to this group in case the SQL queries <http://wiki.koha-community.org/wiki/SQL_Reports_Library#Withdrawn_Titles_Li st_to_Send_to_OCLC> she pointed me to don't work: "I still can't find a good way to generate a report of the values stored in the 001 tag, either from Koha's report wizard or creating SQL queries using "ExtractValue(marcxml,'//controlfield[@tag="001"]') AS OCLC Control Number". And there's no easy way to map a Koha field to 001 and/or 003 to be able to run reports that include these control fields. I would appreciate some help." Is this a data issue? Why don't the ExtractValue function work? There's data in the 'marcxml' or 'marc' fields when I simply select them in a query? Many, many thanks for any help. Glenda B. Claborne Library Director The American University of Iraq, Sulaimani (AUIS) +964 (0)53-330-1011, ext.1218 Skype: glenda.claborne

3 3

Building authority records after data migration
by Iming Chan 19 Jun '13

19 Jun '13

Dear all, Recently, I have successfully migrated all bibliographic records into Koha 3.12. I would like to find out how to build up authority records using bib. records that are in Koha? There doesn't seem to be any instruction on this that will help newbie (like myself) to achieve this. Your assistance is greatly appreciated. Thank you in advance. Regards, Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Building-authority-records-after-data-mig… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

error on import Marc Record from z39.50 servers listed in Koha (Mesfin Teshome) - SOLVED
by Mesfin Teshome 19 Jun '13

19 Jun '13

Hi all, I thought this might help some people. I asked in this forum about the import Marc Record from Z39.50 servers. The problem was not consistent. So I was out of ideas or other options. I wanted to do an in place upgrade on the existing 3.12 with the 3.12 installation files thinking this would fix if there are any database inconsistencies. But before I did that I thought I should update the system (Ubuntu 12.04). So I did sudo apt-get update and sudo apt-get upgrade. This upgraded MySQL and other python and perl components. I restarted the system and wanted to try importing the same books again before I did the in place upgrade (re-installtion). And VIOLA ...I was able to import the books. Case solved and librarians happy with the upgrade. Mesfin

1 0

Call Number Display
by Kenan Scott 18 Jun '13

18 Jun '13

Hi, my name is Kenan, I'm new to Koha and have a question regarding how Koha deals with call numbers. I've tried searching for the solution prior to mailing this. I am running Koha 3.12 on Ubuntu Server edition 12.04.2 LTS. I imported my MARC records anticipating using field 90a for my call numbers, however even though I have itemcallnumber set to 90a, the intranet and OPAC still doesn't show anything under the item listing for Call Number. I can however see values under 90a in the MARC view. Also nothing shows up when I use the quick spine label creator. Is there something I'm missing? Thank you in advance, Kenan Scott kenanscott24(a)gmail.com

1 0

MARC21 classification format
by Galen Charlton 18 Jun '13

18 Jun '13

Hi, The MARC21 authority frameworks that ship with Koha include (in the default framework) tags defined by the MARC21 classification format. [1] I'm not entirely sure that they belong there, however -- while it appears that classification records could in principle be used to authorize classification numbers found in both bibliographic and authority records, adding support for such functionality might well entail creating a separate set of MARC tables. Is there anybody making active use of the MARC21 classification format fields in their Koha database? For that matter, is there anybody making use of the MARC21 classification format, period? Is there anybody who has access to classification records who *wishes* they could use them in Koha? [1] http://www.loc.gov/marc/classification/ Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Re: [Koha] Koha and old books
by Beda Szukics 18 Jun '13

18 Jun '13

Am 12.06.2013 19:10, schrieb Elaine Bradtke: > Interesting. > Which version of MARC are you using? It might be useful to state that. > Or maybe you did and I missed it. I have managed to translate the article in english: http://wiki.koha-community.org/wiki/Koha_and_old_books Beda

1 0