- Koha - lists.katipo.co.nz

Query Regarding MARC Records
by rohitsingh 17 Jul '10

17 Jul '10

Hello Everybody, I am working on how to create MARC records for books that do not have Library of Congress Data? and How we should be able to enter the data in to a CSV file? I have created a CSV File and saved as updated data.csv, i have written the code for creating MARC Record and saved it as rohit.pl i have saved this file in the document root directory i.e /koha/intranet/htdocs/rohit.pl and i tried to save in another locations also i.e /cgi-bin/koha/rohit.pl Rohit.pl contains the following code ## create a MARC::Record object. use MARC::Record; use Text::CSV; my $file = '/Users/keshwendu/desktop/updated data.csv'; my $csv = Text::CSV->new(); open (CSV, "<", $file) or die $!; ## To ignore the header my @columns = $csv->fields(); while (<CSV>) { if ($csv->parse($_)) { my @columns = $csv->fields(); my $record = MARC::Record->new(); ## create a title field. my $title = MARC::Field->new( '245','','', a => $columns[0], # title ); $record->append_fields($title); ##CONTROL NUMBER IDENTIFIER my $CONTROL NUMBER IDENTIFIER = MARC::Field->new( '260','', '', a => $columns[1], #place ); $record->append_fields($CONTROL NUMBER IDENTIFIER); ## DATE AND TIME OF LATEST TRANSACTION my $DATE AND TIME OF LATEST TRANSACTION = MARC::Field->new( '300', '', '', b => $columns[2], ); $record->append_fields($DATE AND TIME OF LATEST TRANSACTION); ## LIBRARY OF CONGRESS CONTROL NUMBER my $LIBRARY OF CONGRESS CONTROL NUMBER = MARC::Field->new( '942', '', '', c => $columns[3], #LIBRARY OF CONGRESS CONTROL NUMBER ); $record->append_fields($LIBRARY OF CONGRESS CONTROL NUMBER); ## ISBN my $isbn = MARC::Field->new( '020', '', '', a => $columns[4], #ISBN ); $record->append_fields($isbn); ## CONTROL NUMBER my $CONTROL NUMBER = MARC::Field->new( '942', '', '', c => $columns[5], #CONTROL NUMBER ); $record->append_fields($CONTROL NUMBER); ## create an author field. my $author = MARC::Field->new( '100', '', '', a => $columns[6], #author ); $record->append_fields($author); ## open a filehandle to write to 'record.dat'. open(OUTPUT, '>> record.mrc') or die $!; print OUTPUT $record->as_usmarc(); close(OUTPUT); } else { my $err = $csv->error_input; print "Failed to parse line: $err"; } } close CSV; and my CSV file as below: http://old.nabble.com/file/p29191222/updated%2Bdata.csv updated+data.csv when i saved this file in the document root directory i.e /koha/intranet/htdocs/rohit.pl or in some another locations i.e /cgi-bin/koha/rohit.pl i am getting the below error http://old.nabble.com/file/p29191222/Screen%2Bshot%2B2010-07-14%2Bat%2B4.27… Screen+shot+2010-07-14+at+4.27.00+PM.png http://old.nabble.com/file/p29191222/Screen%2Bshot%2B2010-07-17%2Bat%2B2.58… Screen+shot+2010-07-17+at+2.58.53+PM.png PLease help me out to how to create the MARC Records Programmatically? and How we should be able to enter the data in to a CSV file and then programaticaly create MARC records for upload in Koha eventually? Looking forward for your kind reply Thanks and Regards Rohit Singh -- View this message in context: http://old.nabble.com/Query-Regarding-MARC-Records-tp29191222p29191222.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Butte Public
by Lenora Oftedahl 16 Jul '10

16 Jul '10

Hello. Sorry, I seem to have misplaced the telephone number to call you back about SQL reports. Unfortunately, I don't think I can help as I'm not very good at getting the reports module to work as I want either. Most of the SQL reports on the custom reports page in the wiki are tried and true by other libraries. You might be able to adapt one to your needs by just replacing a search term. Lenora

1 0

Re: [Koha] Hello, 995 setup
by Zeno Tajoli 16 Jul '10

16 Jul '10

Dear Jan and all At 15.51 16/07/2010, BERNON Jean wrote: > >Fixing a common use of 995 tag is a good idea but uneasy to do. >Local fields are... local. I am not sure that there is ONE French >setup for 995. Here is the University Lyon 3 setup for 995, very >different from yours. in fact Koha is very flexible on this problem. All templates don't use marc fields/subfileds but the SQL coloums. So, with the liking between Koha and MySQL you can use the fields/subfileds that you want, for the templates. This is not tha same on XSLT views and indexes [i use code of 3.2, because in fact you are on a 3.2 as I have undestand from BibLibre] XSLT is based on marc subfield. So if you have Biblionumber and biblioitemnumber are in 999, you have also a personal version of xslt/UNIMARCslim2OPACDetail.xsl and xslt/UNIMARCslim2OPACResults.xsl. The standard version use 090 with this instruction: <xsl:variable name="biblionumber" select="marc:datafield[@tag=090]/marc:subfield[@code='a']"/> The standard indexes are 995$2 lost,lost:n,item 995$a homebranch,Host-item,item 995$b homebranch,Host-item,item 995$c holdingbranch,Record-Source,item 995$d holdingbranch,Record-Source,item 995$e location,item 995$f barcode,item 995$h ccode,item 995$j LC-card-number:s,item 995$k Call-Number,Local-Classification,lcn,Call-Number:p,Local-Classification:p,lcn:p,item 995$s popularity:n,popularity:s,item 995$n onloan:d,onloan:n,onloan:s,onloan:w,item 995$u Note,Note:p,item Your defintion of 995$2 and 995$s are not coherent with the standard indexes >2 Price -> items.price >s CallNumSource -> items.cn_source In fact is not a problem you have a different configuration, you need only to know it. In fact my proposal doesn't want to be used as is. I want only to setup a minumun tha has as many useful default as possible. Others opinions on the topic ? Cheers Zeno Tajoli Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0

Hello, 995 setup
by BERNON Jean 16 Jul '10

16 Jul '10

Hi all, My name is Jean Bernon. I am the director of a French university library, Université Jean Moulin Lyon 3. We are using Koha for circulation and catalog since April 2010. I shall send few messages to the list because my main job is not working with Koha. But an Italian librarian Zeno Tajoli sent a question about 995 setup in French libraries and asked for we reply on the general list. Here is my answer. Hi Zeno, Fixing a common use of 995 tag is a good idea but uneasy to do. Local fields are... local. I am not sure that there is ONE French setup for 995. Here is the University Lyon 3 setup for 995, very different from yours. 1 Fund 2 Price -> items.price 3 DateLastSeen -> items.datelastseen 4 IssuesNumber -> items.issues 5 StatisticCode -> items.statisticvalue 6 EntryDate -> items.dateaccessioned 7 UpdateDate -> items.timestamp 8 LastIssueDate -> items.datelastborrowed 9 itemnumber -> items.itemnumber b HomeBranch -> items.homebranch d HoldingBranch -> items.holdingbranch f BarCode -> items.barcode i CallNumSuffix j Location -> items.location k CallNum -> items.itemcallnumber l CallNumPrefix -> items.materials n DueDate -> items.onloan o Availability -> items.notforloan r LoanRule -> items.itype s CallNumSource -> items.cn_source u ItemNote -> items.itemnotes v Damaged -> items.damaged w Lost -> items.itemlost z Withdrawn -> items.wthdrawn Biblionumber and biblioitemnumber are in 999 and not 099 We use a bibliographic ccode in 319 to limit searching by document type. 319 according to the format of the University national catalog SUDOC. I like some of your fields : URI, bibliographic entry and update dates. In order to be complete, I have to say that your proposal agrees with the history of 995 tag. French librarians from public libraries first used 995 to establish a common recommandation and you can have a look at the genuine recommandation<http://www.adbdp.asso.fr/spip.php?article674> Bye Jean Bernon Université Jean Moulin Lyon3 -----Message d'origine----- De : infos-bounces(a)listes.koha-fr.org [mailto:infos-bounces@listes.koha-fr.org] De la part de Zeno Tajoli Envoyé : mardi 13 juillet 2010 16:08 À : infos(a)listes.koha-fr.org Objet : [koha-Infos] To define default 9xx fields for Unimarc setup in all languages Hi to all [Sorry for the english but I don't konw French] I sent this mail to different Koha-mailing list because the topic is quite wide. If you are also on koha-dev list, replaty to this list. Instead replay on koha general list. I send the mail also to koha-france because many user of Unimarc are French. But I don't know French, please replay to koha general list or to koha-dev. Today the complete Unimarc setups are the English and French, As I know Italian, Ukrain, Russian and Poland setups are direct translation of English or Frence setup But on local fields English and French are not compatible. Many 9xx fields need to be the same in different languages because the indexes definitions in the file etc/zebradb/marc_defs/unimarc/biblios/record.abs are based on specific 9xx values. And the file record.abs is only one for all Unimarc setup So my proposal, for 3.2 and also [if possible ] for 3.0.x We re-write English setup in 9xx fields and we use it a minimun and a standard that ALL unimarc setups need to follow. It means that we need same change also to French setup. I want to discuss with everyone about this topic. I will write all the patch to fix the situation. So my proposal: Fields: 001 Local number -> biblio.biblionumber 090$a Local number -> biblioitems.biblioitemnumber 099$c date of creation -> biblio.datecreated 099$d Date/time last modified -> biblio.timestamp 995$0 Withdrawn status -> items.wthdrawn 995$2 Lost status -> items.itemlost 995$3 Use restrictions -> items.restricted 995$5 Date acquired -> items.dateaccessioned 995$6 Copy number -> items.copynumber 995$7 URI -> items.uri 995$8 Koha collection -> items.ccode 995$9 Internal item number -> items.itemnumber 995$a Homebranch (free text) ->items.homebranch 995$b Homebranch (coded) 995$d Holding branch (free text) -> items.holdingbranch 995$d Holding branch (coded) 995$e Shelving location-> items.location 995$f Barcode -> items.barcode 995$j Inventory number -> items.stocknumber [only 3.2] 995$k Call number -> items.itemcallnumber, 995$l Numbering (volume or other part) -> items.materials 995$m Date of loan or deposit -> items.datelastborrowed 995$n Expiration of loan date -> items.onloan 995$o Circulation type (not for loan) -> items.notforloan 995$r Type of item and material -> items.itype 995$v Serial Enumeration / chronology -> items.enumchron [only serials] 995$u Copy note -> items.itemnotes 942$0 Koha issues (borrowed), all copies -> biblioitems.totalissues 942$2 Source of classification or shelving scheme -> biblioitems.cn_source 942$6 Koha normalized classification for sorting -> biblioitems.cn_sort 942$c Koha [default] item type -> biblioitems.itemtype 942$s Serial record flag -> biblio.serial 1)Fields 001 and 090$a, BIB Identifier in two places As French setup, to ahve a correct Unimarc we need BIB id in two places: 001 -> biblio.biblionumber 090 $9 -> biblioitems.biblioitemnumber biblio.biblionumber and biblioitems.biblioitemnumber must be numerir, we need to stress this fact in data conversions 2)Field 995 as item field with those subfields: This proposal is full compatible with French Unimarc setup and it has also the items subfields that are mandatory for circulation, inventory, acquisitions and serials. 3)Field 942 as biblio/item field. This field is new for all unimarc setup, in english unimarc setup there is 990 but 990 is similar, not identical. I select 942 instead of 990 because 990 is present in French setup with a specific meaning. I ask to French people to accept to put biblioitems.totalissues in 942$0, it is the base of the popularity index. Now the base of popularity index is in 995$s. This proposal is only a minimum, if you think there are others 9xx fields/subfields that MUST be present in every setup, please replay. If you want to discuss it, please replay. Bye to all Zeno Tajoli Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @) _______________________________________________ Infos mailing list Infos(a)listes.koha-fr.org<mailto:Infos@listes.koha-fr.org> https://listes.koha-fr.org/cgi-bin/mailman/listinfo/infos

1 0

Koha page not accessible on other machines on the intranet
by Mutsikiwa Admire 15 Jul '10

15 Jul '10

Hi I have successfully installed koha on Debian 5 and it is accessible only on the host machine when I type the FQDN on the browser on the host machine. However when I try to access the OPAC by typing http://FQDN/cgi-bin/koha/opac-search.pl it spits in the error logs the message " script not found or unable to stat : /usr/lib/cgi-bin/koha". And surely the file /usr/lib/cgi-bin/koha does not exist. My koha is installed in /usr/share/koha. I know I could solve the problem by syslinking /usr/lib/cgi-bin/koha to a target file/directoru but I cannot tell which one. Please assist. Kind Regards, Admire Mutsikiwa (Mr) ICT Projects Manager Library IT University of Zimbabwe Tell:+263-4-303276 Cell:+263-92239187 Alt/email:amutsikiwa@gmail.com

2 1

Authority Record Downloads
by Nicole Engard 15 Jul '10

15 Jul '10

Hi all, I remember a while ago posting to the list - or to the blog - about places to download authority records, but I am having no luck finding a record of that. Can anyone point me in the right direction? Thanks Nicole

1 0

Second Koha Open Day in London
by Andrea Chandler 15 Jul '10

15 Jul '10

Hello All, The Kings Fund and CAMLIS are pleased to announce that we will be holding another free open day for people interested in finding more about implementing or switching to Koha. All Koha users are also welcome. The event will be held in the afternoon of Friday 10th of September at CAMLIS, from 2pm-5pm. At the moment we don't have a strict schedule but we hope to include some short presentations with discussion, followed by hands-on experience in small groups at the library computers. There will be some time for existing Koha users to chat with each other. If any user is interested in giving a 10 minute presentation or demonstration of some aspect of Koha, please contact one of us. There will not be any support companies present, but if companies who serve the UK would like to update their details at: http://koha-community.org/support/paid-support/ now is a good time. Places for this event are limited so please book early by contacting Matthew Hale at the King's Fund: m.hale(a)kingsfund.org.uk. If there is sufficient interest we will repeat it at a later date, so do register your interest even if you can't necessarily make this day. A full schedule will be made public nearer to the date. -- Best wishes, Andrea *Andrea Chandler* Librarian Specialist CAMLIS- Complementary and Alternative Medicine Library & Information Service The Royal London Homoeopathic Hospital 60 Great Ormond Street London WC1N 3HR +44 (0) 20 7391 8828 a.chandler(a)camlis.eu <mailto:a.chandler@camlis.eu> http://www.cam.nhs.uk/ skype: askcamlis

1 1

Official Koha Newsletter : Volume 1, Issue 7: July 2010
by Nicole Engard 15 Jul '10

15 Jul '10

Read this newsletter online with live links: http://koha-community.org/koha-newsletter-volume-1issue-7-july-2010/ Official Koha Newsletter (ISSN 2153-8328) Volume 1, Issue 7: July 2010 Table of Contents * Tips & Tricks o Search in Koha o Amazon Content Not Appearing? * Koha in Libraries o Koha Users Forum launched in Nigeria o Archive & Access Project * Koha Events o Second Koha Open Day in London o KohaCon 2010 Program Available Tips & Tricks Search in Koha by Marilen Aretius Corciovei For people used to web searches and database oriented application Koha way of dealing with searches (since v.3) might seem a bit alien. This is a small set of notes related to some not very obvious questions which I had to answer in order to do some configurations which seemed trivial at the beginning. I am not saying this is wrong or ineffective, just different and different means time to learn. I’m writing this to help you reduce this time. [Read Part 1 & Part 2.] Amazon Content Not Working? by Nicole C. Engard Question: Why is Amazon’s enhanced content not appearing? Answer: Amazon uses your server time in its API requests and so if your system time is off you will not be able to use Amazon content. Update your server time and make sure all of your Amazon preferences are turned on, this should solve the problem. Koha in Libraries Koha Users Forum launched in Nigeria by Olugbenga Adara Projektlink Konsult Limited, the premier Koha support company in Nigeria hosted the first ever Koha Users Forum at its premises in Ibadan, Nigeria on Monday June 21, 2010. The event, which had 22 participants from 12 different institutions using Koha in Nigeria, featured tutorials, tips and tricks and discussions on challenges and solutions to problems encountered by the participants while running Koha. More details are available here. Archive & Access Project by Savitra Sirohi The Archive and Access project aims to set up a consortium of archives and libraries in India with the purpose of catalog sharing and eventual sharing of full text digitized resources. The project is supported by the Jamsetji Tata Trust and housed at the Centre or the Study of Culture and Society, Bangalore. This will be a union catalog, powered by Koha, of historical collections of libraries and archives from different parts of the India. This is an ongoing process, with the regular introduction of new institutions to the catalog. The project wishes to solicit contributions from libraries, organizations, historians and other scholars for this catalog. Those interested in participating can contact project members at: publicarchivesindia(a)gmail.com and more information can be found on the official page. Koha Events Second Koha Open Day in London by Andrea Chandler The Kings Fund and CAMLIS are pleased to announce that we will be holding another free open day for people interested in finding more about implementing or switching to Koha. All Koha users are also welcome. The event will be held in the afternoon of Friday 10th of September at CAMLIS, from 2pm-5pm. At the moment we don’t have a strict schedule but we hope to include some short presentations with discussion, followed by hands-on experience in small groups at the library computers. There will be some time for existing Koha users to chat with each other. If any user is interested in giving a 10 minute presentation or demonstration of some aspect of Koha, please contact one of us. Places for this event are limited so please book early by contacting Matthew Hale at the King’s Fund: m.hale(a)kingsfund.org.uk. If there is sufficient interest we will repeat it at a later date, so do register your interest even if you can’t necessarily make this day. KohaCon 2010 Program Available by Nicole C. Engard As we get closer to the next annual KohaCon (this year in NZ – where it all started) it’s time to check out the program for the event! We are still gathering speaker bios and program description updates, but the preliminary program is available on the conference site. Newsletter edited by Nicole C. Engard, Koha Documentation Manager. Please send future story ideas to me.

1 0

Koha and Greenstone integration
by Ashraff Shah 15 Jul '10

15 Jul '10

Good Day I would like to integrate Greenstone 2.83 with Koha 3.0.6. Have both installed on Ubuntu 10.04. Is there anyone who has been able to do this or attended the workshop - NCSI-IDRC Workshops on Library Automation Packages and Digital Library Software: July 27th to 31st and August 3rd to 7th, 2009 (http://dharmaganja.ncsi.iisc.ernet.in/workshop) There are files mentioned in the workshop presentation (3.4 Greenstone Integration with Koha) that are required for the integration, which I would like to get. Any assistance would be appreciated. Thank you Ashraff Allan Shah _________________________________________________________________ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. https://signup.live.com/signup.aspx?id=60969

1 0

koha accessible on the host machine only
by Mutsikiwa Admire 15 Jul '10

15 Jul '10

I have successfully installed Koha 3 on Debian 5. I can access the koha page on the host computer by pointing to its Fully qualified hostname (http://koha.uz.ac.zw ), which is DNS-resolvable. However, on other computer on the intranet, if I point the browser to http://koha.uz.ac.zw, I am greeted with the Apache Page, " It is working". I am new to Debian but I have been using Redhat variants for some time. I will appreciate any hints to the problem Kind Regards, Admire Mutsikiwa (Mr) ICT Projects Manager Library IT University of Zimbabwe Tell:+263-4-303276 Cell:+263-92239187 Alt/email:amutsikiwa@gmail.com

2 1