headers
glenda.claborne | 19 Jun 2013 14:29
Favicon

Generating reports of values in 001

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[ <at> 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
Permalink | Reply | 3 comments |
headers
Mesfin Teshome | 19 Jun 2013 09:33
Picon
Favicon

error on import Marc Record from z39.50 servers listed in Koha (Mesfin Teshome) - SOLVED

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
Permalink | Reply | 0 comments |
headers
Kenan Scott | 18 Jun 2013 20:56
Picon

Call Number Display

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@...
Permalink | Reply | 0 comments |
headers
Galen Charlton | 18 Jun 2013 16:50
Favicon
Gravatar

MARC21 classification format

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@...
direct: +1 770-709-5581
cell:   +1 404-984-4366
(Continue reading)

Permalink | Reply | 0 comments |
headers
Beda Szukics | 18 Jun 2013 14:59
Picon
Favicon

Re: Koha and old books

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
Permalink | Reply | 0 comments |
headers
schnydszch | 18 Jun 2013 09:51
Picon
Favicon

Koha multiple instance

I have Koha 3.10.5 installed in Debian 6.0 x64. Now, I want to install
another instance by following
http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha, I
was able to do until perl Makefile.PL but when I go 'make' part, I get
-bash: make: command not found. That's in our working server. But when I
tried it in local server with almost same config (Koha 3.10.5 - Debian 6.0),
I was able to install another instance. What could be the problem with my
working server? Thanks & have a nice day!

--
View this message in context: http://koha.1045719.n5.nabble.com/Koha-multiple-instance-tp5758848.html
Sent from the Koha-general mailing list archive at Nabble.com.
Permalink | Reply | 8 comments |
headers
Iming Chan | 18 Jun 2013 09:14
Picon

Building authority records after data migration

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-migration-tp5758845.html
Sent from the Koha-general mailing list archive at Nabble.com.
Permalink | Reply | 2 comments |
headers
glernil evangelista | 18 Jun 2013 03:39
Picon

change of domain name

Good day!

How can I change the domain name of a koha instance? I have a Koha 12.0
installed using debian repository.
Permalink | Reply | 2 comments |
headers
Paul | 18 Jun 2013 01:09

koha@...)

At 10:22 PM 6/17/2013 +0100, Elaine Bradtke wrote:
>If you don't have a gmail account,  you may need to set one up to see a 
>google doc.  Our e-mail runs on google so I just went straight in.

That's what I thought... but my paranoia à la Snowden got the better of me ;={

tnx - paul

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
Permalink | Reply | 1 comment |
headers
Elaine Bradtke | 18 Jun 2013 00:56
Favicon

Report help needed

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[ <at> tag="650"]/subfield[ <at> code="a"]') AS heading
 FROM biblioitems
 WHERE
  length(ExtractValue(marcxml,
'//datafield[ <at> tag="650"]/subfield[ <at> code="a"]')) != 0 AND
  length(ExtractValue(marcxml,
'//datafield[ <at> tag="650"]/subfield[ <at> 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
(Continue reading)

Permalink | Reply | 1 comment |
headers
Tom Obrien (Google Drive | 17 Jun 2013 20:32
Picon

koha@...)

I've shared an item with you:

koha interface after upgrade.doc
https://docs.google.com/file/d/0B4GFHQAjxjRjbVE2OTlGc3VVczQ/edit?usp=sharing&invite=CKixxo8F

It's not an attachment -- it's stored online. To open this item, just click  
the link above.
Permalink | Reply | 4 comments |

Gmane