Stephen Hedges | 1 Sep 2004 02:42

Re: Importing data into MARC

Andres, use the regularly defined MARC tags (depending on your MARC
flavor) to store the data from your "title" database.  Store the
information from your "copy" database in holdings tags (in MARC21 either
852 or a user-defined 9xx tag).  The holdings tag is repeatable, each
repetition containing the information for one copy.  So if you have three
copies of a title, your (very abbreviated) MARC21 record might look like:

100  Author
245  Title
852  Copy 1 info
852  Copy 2 info
852  Copy 3 info

Are you using MARC::Record to build the records for import?

Stephen

Andres Tarallo said:
> We're currently finishing our mapping to import our database (CEPAL
> catalog in DOS/ISIS) to Koha. We have a question, and we want to know
> the best solution to feed data for bulkmarcimport.pl.
>
> Our library has two databases. The first one has a detailed description
> of  each title avaliable in the library; this database has one record
> for each title we have, no matter how many copies of it we have.  The
> second one has all the purchase information, in this database you have
> one record for every copy of a book you have. Both databases are releted
> via a pointer in the first one that references the records of the second
> one.
>
(Continue reading)

Scott Scriven | 1 Sep 2004 04:04

Re: Problem with MARC tag structure admin (and others)

* Dana Huff <dana@...> wrote:
> 1. The "MARC tag structure admin" page does not quite work

This sounds like a browser incompatibility.  Have you tried it in
mozilla/netscape/firefox?

> 2. Another issue ...
> When I select a title, I get a page with the MARC biblio
> number. But there seems to be information missing.

This may be related to the marc tag structure.  The only info
which will show up, I think, are fields you have set the "tab"
field for.  If you want, say, tag 357 to show up, you need to set
all its subfields to display on a tab.

-- Scott
Scott Scriven | 1 Sep 2004 05:40

Re: unsubscribe

* Zhou, Lu - OSHA CTR <Zhou.Lu@...> wrote:
> please unsubscribe
> 
> thank you

No, no.  I'd much rather that YOU unsubscribed.  I still want to
see the list messages.

:)

-- Scott  (read beneath this line for unsubscribe info)
Sims, Benjamin | 1 Sep 2004 10:42
Favicon

RE: problem installing koha - virtual hosts configuration?

Thanks, but port has to be specified since I have more than one virtual host
(for the main webserver)

Benjamin

Benjamin Sims
Information Services
IOC/UNESCO

-----Original Message-----
From: M. Longo [mailto:jmlongo@...] 
Sent: 31 August 2004 16:27
To: Sims, Benjamin
Subject: Re: [Koha] problem installing koha - virtual hosts configuration?

Sims, Benjamin escribió:
> Thanks for the quick reply!
> 
> 1. I downloaded it recently from the website, this is 2.0.0.

Ok... same as mine...  :)

> 2. Yes, restart after each change (apache graceful). The fact that the
> server is responding on these ports means that at least the Listen
> directives are working properly (otherwise I get a 404).

right...

> 3. No, nothing for this port.
> 
(Continue reading)

Sims, Benjamin | 1 Sep 2004 12:29
Favicon

sample data for 2.0.0

Thanks to all, I seem to be making some progress with the problem below (1
out of 2 working).

Next problem is with sample data - is a set available for 2.0.0 version? It
seems that the bundled set does not match the database structure.
(specifically, the more recent borrower table has more fields)

Thanks,

Benjamin Sims
Information Services
IOC/UNESCO

-----Original Message-----
From: koha-admin@... [mailto:koha-admin@...]
On Behalf Of MJ Ray
Sent: 31 August 2004 20:36
To: koha@...
Subject: RE: [Koha] problem installing koha - virtual hosts configuration?

On 2004-08-31 17:08:53 +0100 "Sims, Benjamin" <B.Sims@...> 
wrote:

> It seems to me that nothing is going wrong, I have just made an error 
> which
> causes Apache to pass requests to the default server.

I think you are probably right. The best idea is probably to read 
"Apache Virtual Host documentation" from the Apache Project at 
http://httpd.apache.org/docs/vhosts/ and see if you can spot a cause. 
(Continue reading)

Sims, Benjamin | 1 Sep 2004 12:58
Favicon

access to the librarian interface

Its all coming together now, I apologise for flooding the list with
questions.

How is access to the librarian interface possible? The Manual mentions
access through .htaccess or AuthenDBI. However, at the moment I have neither
set up and am still refused access due to incorrect user name and password.
Is there a way to work round this? The site is purely a demonstration, at
the moment the ability to show it is more important than security.

Benjamin

Benjamin Sims
Information Services
IOC/UNESCO

-----Original Message-----
From: koha-admin@... [mailto:koha-admin@...]
On Behalf Of Sims, Benjamin
Sent: 01 September 2004 12:29
To: koha@...
Subject: [Koha] sample data for 2.0.0

Thanks to all, I seem to be making some progress with the problem below (1
out of 2 working).

Next problem is with sample data - is a set available for 2.0.0 version? It
seems that the bundled set does not match the database structure.
(specifically, the more recent borrower table has more fields)

Thanks,
(Continue reading)

Sims, Benjamin | 1 Sep 2004 13:03
Favicon

port-based virtual hosting

Since it took me a little time to work this out, I thought I would post this for this archive. In order to get Apache to serve the relevant sites only according to port number on a machine which already serves websites on port 80, my koha-httpd.conf reads as follows:

 

 

--------------------------------------------------------------------------------------------------------------------------

# Ports to listen to for Koha

# uncomment these if they aren't already in main httpd.conf

Listen 8000

Listen 8001

 

# NameVirtualHost is used by one of the optional configurations detailed below

 

NameVirtualHost 111.222.333.444:8000

NameVirtualHost 111.222.333.444:8001

 

 

LoadModule env_module /usr/lib/apache/1.3/mod_env.so

 

# KOHA's OPAC Configuration

<VirtualHost v:8000>

   ServerAdmin admin-IEbV4ISQ1ORg9hUCZPvPmw@public.gmane.org

   DocumentRoot /usr/local/koha/opac/htdocs

   ServerName koha-server.domain.org:8000

   ScriptAlias /cgi-bin/koha/ /usr/local/koha/opac/cgi-bin/

   ErrorLog /usr/local/koha/log/opac-error_log

   TransferLog /usr/local/koha/log/opac-access_log

   SetEnv PERL5LIB "/usr/local/koha/intranet/modules"

   SetEnv KOHA_CONF "/etc/koha.conf"

   Options +Includes

   AddHandler server-parsed .html

 

</VirtualHost>

 

# KOHA's INTRANET Configuration

<VirtualHost 111.222.333.444:8001>

   ServerAdmin admin-IEbV4ISQ1ORg9hUCZPvPmw@public.gmane.org

   DocumentRoot /usr/local/koha/intranet/htdocs

   ServerName koha-lib.domain.org:8001

   ScriptAlias /cgi-bin/koha/ "/usr/local/koha/intranet/cgi-bin/"

   ErrorLog /usr/local/koha/log/koha-error_log

   TransferLog /usr/local/koha/log/koha-access_log

   SetEnv PERL5LIB "/usr/local/koha/intranet/modules"

   SetEnv KOHA_CONF "/etc/koha.conf"

   Options +Includes

   AddHandler server-parsed .html

 

</VirtualHost>

 

-------------------------------------------------------------------------------------------------------------------

 

Benjamin Sims

Information Services

IOC/UNESCO

 

Chris Cormack | 2 Sep 2004 13:05
Picon
Favicon

s_visanu@...: The problem of Koha]

----- Forwarded message from Visanu Sirboonrung
<s_visanu@...> -----
Hello,
   My name is Visanu Sirboonrueng. I'm a student in Thailand. Now, I'm using your program in Library of
College. [St.Theresa Inti College]. and I have some problem to ask you about How to set up the program for
calculate the charges of book if the user returnd the book after date due? and Could I use the program in my
language? [Thai language]. The last question is When I make a account for student or user, Could I make a
card number by myself?
  So, The last one we would like to say Thank you for your helps. And We would like to ask you for get permission to
use this program in our library. So Thank you for everything.

from Student of Thailand

		
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
----- End forwarded message -----

--

-- 
Chris Cormack                                                     Programmer
027 4500 789                                       Katipo Communications Ltd
chris@...                                          www.katipo.co.nz
Baljkas Family | 1 Sep 2004 01:14

Re: Importing data into MARC

Tuesday, August 31, 2004    17:48 CDT

Hi, Andres,

First off, kudos on what you were saying yesterday regarding salaries. I couldn't have agreed with you more.

As for your databases, I suppose the solution you would want would bring the copy specific information in
the second database into the title specific records of the first.

Perhaps someone else on the listserv can suggest/help write a script that could merge the databases. 

How many records are we talking about? And how many fields of information do you want/need preserved from
the second database with the purchase info?

In terms of MARC coding solutions, would the 852 field suffice alone? The $z subfield is repeating.

There is also the 541 note which is repeating and could be incorporated to contain more copy-specific
information with defined subfields. Check that out at URL <http://www.loc.gov/marc/bibliographic/ecbdnot2.html#mrcb541>.

Take a look at the Holdings information at URL <http://www.loc.gov/marc/holdings/echditem.html> ;
this gives guidance on embedding holdings information, i.e. including an 876 note within each MARC
record for an item.

You would be repeating the 852 field (and/or 541) for each different copy of the item within the item record
and (keeping in mind that I've never had to do this but from my reading) you would be linking these to their
corresponding 876 notes (which have enough fields available for fairly detailed acquisitions data)
using the $8 to clarify which item was meant (I suppose the bar code would be the natural choice).

I hope this helps a bit. Let us know how things progress.

Cheers,

Steven F. Baljkas
library tech at large
Koha neophyte
Winnipeg, MB, Canada

 
> From: Andres Tarallo <tarallo@...>
> Date: 2004/08/31 Tue PM 04:59:22 CDT
> To: koha@...
> Subject: [Koha] Importing data into MARC
> 
> We're currently finishing our mapping to import our database (CEPAL 
> catalog in DOS/ISIS) to Koha. We have a question, and we want to know 
> the best solution to feed data for bulkmarcimport.pl.
> 
> Our library has two databases. The first one has a detailed description 
> of  each title avaliable in the library; this database has one record 
> for each title we have, no matter how many copies of it we have.  The 
> second one has all the purchase information, in this database you have 
> one record for every copy of a book you have. Both databases are releted 
> via a pointer in the first one that references the records of the second 
> one.
> 
> Now, we don't want to lose information and we're facing that many of our 
> books have many copies, so we want to know whats the best way to build 
> our MARC records, A record with full information from both databases for 
> each book we have?
> 
> Thanks for your feedback
> 
> 
>                                                                          
>          Andres
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
Dana Huff | 2 Sep 2004 21:05
Picon
Favicon

Re: Problem with MARC tag structure admin (and others)

Scott,
 
The browser was the problem, and because of that I couldn't see all of the fields to set the tabs. Using Mozilla worked and then I was able to set up the MARC tab structure the way I wanted.
 
Now, I want to load my biblio data. I have it set up in MARC21 format and am ready to use the bulkmarcimport.pl script to load it. I've already tried it on a few records on the sample database and it works. But...
I want to load it into the "blank200" db and checking in that db, there is no MARC tag data. Is there a quick and safe way to import the data from the sample200 db? One that will make sure the indexes and links are kept intact?
 
And, BTW, should the IE browser incompatibility be noted as a bug?
 
Dana Huff

Gmane