August 2004 - Koha - lists.katipo.co.nz

Importing data into MARC
by Andres Tarallo 07 Sep '04

07 Sep '04

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

2 2

Re: [Koha] Importing data into MARC
by Baljkas Family 07 Sep '04

07 Sep '04

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(a)ort.edu.uy> > Date: 2004/08/31 Tue PM 04:59:22 CDT > To: koha(a)lists.katipo.co.nz > 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(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

2 1

unsubscribe
by Zhou, Lu - OSHA CTR 01 Sep '04

01 Sep '04

please unsubscribe thank you

2 1

Problem with MARC tag structure admin (and others)
by Dana Huff 01 Sep '04

01 Sep '04

I am evaluating Koha for use in a small theological library and we want to run it on Win XP. The install of Koha went well, especially for a first time installation of all the supporting infrastructure, Apache, Perl, MySql, as well, all on Win XP. But the system is not functioning correctly. For example: 1. The "MARC tag structure admin" page does not quite work correctly. At the bottom of the page there is the button for "Add Tag" and then a right-arrow for the next page. The right-arrow does the same thing as the "Add Tag" button; both send me to the Add Tag page. By poking around I found I could get to the next page by typing the last tag number in the search box at the top of the page and then I could procede. 2. Another issue is with viewing or modifying a record. Within INTRANET I can do a catalogue search for an item and that works okay, but... When I select a title, I get a page with the MARC biblio number. But there seems to be information missing. Using the sample200 db, if I click on "1" on the index line toward the top, under "260 -PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) all I see is "c Date of publication, distribution, etc c1991", no publisher name or location, etc. Other selection produce the same results giving only partial information. Looking at the data in MySQL, it's all there. Has anyone else had the same problem with the win32 package? Should I use a different release? Does it look like a config problem, mis-matched components (see below); is the Win 32 2.0 release stable? What did I do wrong? My configuration is: OS: Win XP Pro SP2 apache_2.0.50-win32-x86-no_ssl mysql-4.0.20d-win ActivePerl-5.8.4.810-MSWin32-x86 Koha2.0.0-Win32-R0 Thanks, Dana Huff

2 1

Mapping MARC records from Athena
by Tim McMahon - West Liberty Public Library 01 Sep '04

01 Sep '04

Has anyone tried converting from Athena? I've had some success with importing patron information, but every time I seem to know less about what I'm doing every time I try mapping the marc tags. -- Tim McMahon Technical Services West Liberty Public Library http://www.wlpl.org

1 0

RE: [Koha] problem installing koha - virtual hosts configuration?
by Sims, Benjamin 01 Sep '04

01 Sep '04

Thanks for the quick reply! 1. I downloaded it recently from the website, this is 2.0.0. 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). 3. No, nothing for this port. 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. Benjamin Sims Information Services IOC/UNESCO http://ioc.unesco.org 1 rue Miollis 75732 Paris Cedex 15 FRANCE Tel: [33] (1) 45 68 39 92 Fax: [33] (1) 45 68 58 12 -----Original Message----- From: Martín Longo [mailto:jmlongo@uncu.edu.ar] Sent: 31 August 2004 17:05 To: Sims, Benjamin Subject: Re: [Koha] problem installing koha - virtual hosts configuration? Hi Benjamin... 1) Which version of KOHA did you install? 2) Did you restart Apache after the changes on httpd.conf (I got errors on the SetEnv PERL5LIB "/usr/local/koha/intranet/modules" line so I had to copy C4 directory to a directory on PERL's @INC path and all went great) 3) Does Apache's error log say something? ----- Original Message ----- From: "Sims, Benjamin" <B.Sims(a)unesco.org> To: <Koha(a)lists.katipo.co.nz> Sent: Tuesday, August 31, 2004 11:40 AM Subject: [Koha] problem installing koha - virtual hosts configuration? > Hi, > > I have just installed Koha using the installer.pl script; all seems to have > gone well. However, accessing servername:8000 gives me only the home page > for the whole server. Any ideas where I might be going wrong in my > configuration? > > I include the part of koha-httpd.conf dealing with this host below. Any help > would be much appreciated - I have to server it according to port since we > use this server for other things. > > ------------------------------------------------------- > > # 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 192.168.1.91:8000 > > > LoadModule env_module /usr/lib/apache/1.3/mod_env.so > # KOHA's OPAC Configuration > <VirtualHost 192.168.1.91:8000> > ServerAdmin b.sims(a)unesco.org > DocumentRoot /usr/local/koha/opac/htdocs > ServerName koha-ioc.unesco.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> > > > -------------------------------------------------- > > Benjamin Sims > Information Services > IOC/UNESCO > http://ioc.unesco.org > 1 rue Miollis > 75732 Paris Cedex 15 > FRANCE > Tel: [33] (1) 45 68 39 92 > Fax: [33] (1) 45 68 58 12 > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

2 1

problem installing koha - virtual hosts configuration?
by Sims, Benjamin 31 Aug '04

31 Aug '04

Hi, I have just installed Koha using the installer.pl script; all seems to have gone well. However, accessing servername:8000 gives me only the home page for the whole server. Any ideas where I might be going wrong in my configuration? I include the part of koha-httpd.conf dealing with this host below. Any help would be much appreciated - I have to server it according to port since we use this server for other things. ------------------------------------------------------- # 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 192.168.1.91:8000 LoadModule env_module /usr/lib/apache/1.3/mod_env.so # KOHA's OPAC Configuration <VirtualHost 192.168.1.91:8000> ServerAdmin b.sims(a)unesco.org DocumentRoot /usr/local/koha/opac/htdocs ServerName koha-ioc.unesco.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> -------------------------------------------------- Benjamin Sims Information Services IOC/UNESCO http://ioc.unesco.org 1 rue Miollis 75732 Paris Cedex 15 FRANCE Tel: [33] (1) 45 68 39 92 Fax: [33] (1) 45 68 58 12

2 1

RE: [Koha] problem installing koha - virtual hosts configuration?
by Sims, Benjamin 31 Aug '04

31 Aug '04

Yes, the conf file is being included - the server would not normally listen on that port, so I know the Listen directive is working. According to the directory I extracted, this is 2.0.0. I downloaded it last week. Benjamin Benjamin Sims Information Services IOC/UNESCO http://ioc.unesco.org 1 rue Miollis 75732 Paris Cedex 15 FRANCE Tel: [33] (1) 45 68 39 92 Fax: [33] (1) 45 68 58 12 -----Original Message----- From: koha-admin(a)lists.katipo.co.nz [mailto:koha-admin@lists.katipo.co.nz] On Behalf Of MJ Ray Sent: 31 August 2004 18:15 To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] problem installing koha - virtual hosts configuration? On 2004-08-31 15:40:36 +0100 "Sims, Benjamin" <B.Sims(a)unesco.org> wrote: > [...] However, accessing servername:8000 gives me only the home page > for the whole server. Any ideas where I might be going wrong in my > configuration? First guess (sorry if it's too basic): is there a line saying "Include /path/to/koha-httpd.conf" or similar in httpd.conf and have you run "apachectl graceful" since adding it? Also, what koha version are you using? (That doesn't look like a 2.0.1 koha-httpd.conf to me.) -- MJR/slef My Opinion Only and not of any group I know http://www.ttllp.co.uk/ for creative copyleft computing Please email about: BT alternative for line rental+DSL; Education on SMEs+EU FP6; office filing that works fast _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Greating From Cairo Egypt
by jon hill 31 Aug '04

31 Aug '04

Dear members, I just would like to thank the Members of KOHA for the developments they have made in this open source system. I am working in Cairo, Egypt for the American University in Cairo and have two projects in the works that include KOHA on a Linux (Red Hat) platform. Both projects have been modified to utilize both Arabic and English. The first project is to create a catalog of resource materials related to health issues available through the government library resources. This project is set to launch around Mid-November. The second project is for a new international law program at the American University in Cairo, and will be utilized as a database for student/faculty research on international law materials. I look forward to working with the KOHA Community and am willing to help others pursuing similar avenues as much as I can Jon (Tunemaster) Hill

1 0

Re: [Koha] average cost of a Koha install?
by Adam Steer 31 Aug '04

31 Aug '04

Hi Koha-ers Thanks for the responses so far - I realise now i should have framed things a little differently: It's more a question of 'how much work is involved', and then calculating out the relative costs from there... So far, responses have all included that kind of information - and I'll probably frame up any rough 'cost' information based on the descriptions of work involved, for people to take away and play 'choose-your-consultant-fees/salary' with. I hadn't thought much about the social effect of free software - thanks for that point, Andres. And by the way - $US20 and hour is still a decent rate in Australia [bit still below the horizon of most unix people], and EU700 a day a small fortune. But in the end, you're likely to spend as much at $US20 an hour as EU700 a day, depending on the relative experience of the consultants involved... Thanks all Adam. >>> Andres Tarallo <tarallo(a)ort.edu.uy> - 31/8/04 10:11 AM >>> Fine question, but dificult to answer. When you choose a free software based solution you may have smaller aquisiton costs in the software side (you don't pay for licences), but you might have the same cost in services or salaries. The salaries varies a lot from country to country, U$S 20 an hour is a VERY good salary in my country (Uruguay, think in argentina is the same) and 700 Euros a day is a little fortune (Who should I kill ?). For developing countries most free software solutions are far more convenient, and they have a social effect: money is earned by people who live in the country, pay taxes there and use the money there. Andres Adam Steer wrote: >Hi Koha people > >What are the average costs of a Koha install? There's plenty of >discussion about buying library systems around the traps here, and I >realised that there's no real 'throwaway' numbers out there to allow >people to make a comparison with slickly-marketed paid systems... > >So, if anyone is happy to do so, would it be possible to grab a few >rough numbers for things like initial installation and setup, and any >ongoing maintenance? > >Along with the numbers, any relevant data that affects the cost would >be useful - ie number of sites, number of records to be transferred, >time it took to move from system X to koha... > >The whole aim is to be able to say 'well, for your average school >library, it might cost something like $xxxx if you need an external >contractor to install and configure things..' - before having to go >through the quoting process. A couple of ballpark figures might be >handy.. > >If people see a useful purpose for such data, I'll compile a set of >average numbers and send it back for the FAQ... > >Cheers - and thanks! > > _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0