- Koha - lists.katipo.co.nz

Converting MARC records from Sagebrush Athena
by Tim McMahon - West Liberty Public Library 04 May '05

04 May '05

I'm looking for comments on my work so far. Here is the perl script I wrote to move things to different fields for Koha. Let me know if you see anything that should be changed or could be done a better way. I'm still learning perl, so this could look pretty bad. First I set up a hash for converting Athena formats to Koha item types. After I read a record, I pick the data I want from the 852 fields. 852_6 is format 852_p is barcode 852_9 is cost 852_8 is accession date 852_k is call number prefix 852_k is call number main 852_i is call number cutter 852_m is call number suffix 852_9 is changed to pull any extra characters out of the cost. Athena allows longer strings for their formats. 852_9 is changed to shorter strings using the hash made at the start of the script. Build a whole call number from the pieces in 852 by putting $k, $h, $i and $m together with spaces between and then stripping extra spaces out of it. Put 952 together with our new 852_9, our new call, a code for the home branch and holding branch and the barcode. #!/usr/bin/perl # use strict; # use warnings; ## Crate our MARC::Batch object. use MARC::Batch; my $infile = $ARGV[0]; my $outfile = $ARGV[1]; my $batch = MARC::Batch->new('USMARC',$infile); ## open a file handle to write to. open(OUT,">$outfile") or die $!; my %format = ( 'binder' => BIND, 'book' => BOOK, 'book kit' => KIT, 'books on CD' => BKCD, 'books on tape' => BKTP, 'cbook' => BOOK, 'CD' => CD, 'CD-ROM' => CD, 'DVD' => DVD, 'ebook' => BOOK, 'equipment' => EQU, 'file folder' => FILE, 'frame' => FRAM, 'hbook' => BOOK, 'magazine' => MAG, 'map' => MAP, 'sbook' => BOOK, 'tboot' => BOOK, 'vbook' => BOOK, 'video' => VID ); ## read each record. modify, then print. while ( my $record = $batch->next() ) { ## get info from 852 field. my @fields = $record->field('852'); foreach my $field (@fields) { $field852_6=$field->subfield('6'); $field852_p=$field->subfield('p'); $field852_9=$field->subfield('9'); $field852_8=$field->subfield('8'); $field852_k=$field->subfield('k'); $field852_h=$field->subfield('h'); $field852_i=$field->subfield('i'); $field852_m=$field->subfield('m'); $field852_9 =~ s/[^0-9.]//ig; ## change the format in 852 6 my $new_field=$format{$field852_6}; $field->update( 6 => $new_field ); ## Make a new call number for 952 a $call=$field852_k . ' ' . $field852_h . ' ' . $field852_i . ' ' . $field852_m; while ($call=~s/ / /ig) {} $call=~s/^ //; $call=~s/ $//; ## add 952 field from 852 tags $record->append_fields( MARC::Field->new('952','','',8=>$field852_8, 9=>$field852_9, a=>$call, b=>'WLPL', d=>'WLPL', p=>$field852_p)); print OUT $record->as_usmarc(); }} close(OUT); _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Convering patrons from Sagebrush Athena
by Tim McMahon - West Liberty Public Library 04 May '05

04 May '05

I'm looking for comments on my work so far. Here is the MySQL script I wrote to move patron data to Koha. I converted the dbf file from the Athena export to the test database in MySQL using dbf2mysql. Let me know if you see anything that should be changed or could be done a better way. insert into Koha.borrowers ( cardnumber, surname, firstname, title, streetaddress, city, phone, emailaddress, altstreetaddress, altcity, altphone, dateenrolled, borrowernotes, expiry, altnotes, zipcode) select patronid, surname, firstname, salutation, street1, concat(city,', ',provstate), phone, email, astreet1, concat(acity,', ',aprovstate), aphone, recorddate, message, expirydate, blockmsg, postalzip from test.patrons order by patronid; update Koha.borrowers set debarred = 1 where altnotes > ""; I set Debarred to 1 when the patron has a blocking message (saved as altnotes in the Athena database). _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Thailand installation
by Robyn Barker 04 May '05

04 May '05

I'm a librarian for a university near Hua Hin. I would like more information about installing Koha and converting data. We are currently using the freeware version of Athenaeum; from what I've read so far, Koha would be a massive improvement. I would especially like to visit a library in Thailand who has converted to Koha and talk to them face to face about the challenges they overcame. Our network runs Linux, so at least that is not an issue. Robyn Barker Librarian Webster University (Thailand) 143 Moo 5, Tambon Sampraya Cha-am, Thailand 76120 66-32-456-161 x. 132 barkerr(a)webster.ac.th _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

I'm trialling Koha and have some questions
by Dianna Roberts 03 May '05

03 May '05

We recently downloaded Koha 2.2 to trial as a possible replacement for our current library system, Dynix. We are a special library with a collection of about 35,000 documents, a high proportion of which are serials which is why we have been waiting for the Serials module to become available. I'm still muddling through setting up parameters and trying to understand how everything works but so far I like what I see. However, we want to make sure that we won't be losing any functionality by moving to Koha so it will be a while before we make a firm decision. In the meantime, I'm asking: - does Serials have routing/circulation lists? - what are the search capabilities of Koha - e.g. proximity, Boolean, etc. - is there an option to use synonyms e.g. color/colour? - how are spine labels printed? - is the wording of notices e.g. reminders, claims in Acquisitions and Serials, done by the library or are they default? - is there a facility for statistics-only checkouts i.e. photocopied articles - the number issued? I'd appreciate any feedback from anyone using serials. And/or from anyone who has made the switch from another library system, commenting on benefits or otherwise. Regards, Dianna Roberts *********************************************************************** Dianna Roberts, Manager Information Center Opus International Consultants, P O Box 12004, Wellington, NEW ZEALAND Ph: +64-4-4717250 Fax: +64-4-4731075 Website: http://www.opus.co.nz *********************************************************************** _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Koha 2.2.2 is available for download
by Paul POULAIN 08 Apr '05

08 Apr '05

Hello, The new version of Koha (2.2.2) is available at http://sourceforge.net/project/shownotes.php?release_id=318874 RELEASE NOTES ============= Koha is the 1st Open-Source Integrated Library System. Released at first in New zealand, in 2000 januaray, it is maintained by a team of volunteers from around the globe, the Koha system is a full catalogue, opac, circulation and acquisitions system. Koha 2.2 is more than 247 000 lines of code, developped by more than 30 differents developpers (excluding translators). With the 2.2 version, Koha is now a mature product, with a lot of nice features. It's used in more than 50 libraries, from all kinds (public, schools, search, religious...), of all size (from 1 to 8 branches, from 1000 to 300 000 items). ======== WARNINGS ======== * The librarian interface is tested only with mozilla/firefox. Should work (partially) with IE. OPAC should work fine with any navigator. ======= DIFFS ======= Diff 2.2.1 => 2.2.2 ******************* DB MODIFS : *********** (This new chapter in release notes will be in all new releases. It point any change in the DB. All changes are supposed to be handled by the DB updater, but here for your information) DB structure : none DB content : * new systempref MIME (OPENOFFICE.ORG or EXCEL) and delimiter (;). They are used by the Reports module, when exporting a report to a spreadsheet * new userflags *management* and *tools* to separate systempreferences in 3 differents permissions (see below) BUGFIXES ***** Critical & Minor mixed === ACQUISITION === * 3 bugfixes in suggestions : - major : a suggestion was not shown in acquisition except when ordered by the suggestor itself. - major : the mail to the suggestor was not sent. - minor : the name was not shown in accepted by column, in acquisition * virtual sheves in OPAC : - The user needed to have librarian rights to be able to go to the virtual shelf page. - Adding a book to an existing virtual shelf did not work * when a line was deleted, it was still counted in bookseller number of pending line order (in order.pl). * a non closed basket could be modified even if the supplier was set "inactive" === OPAC === * showing marcnotes in opac-detail (bug #920) === CATALOGUE === * some fixes in authority search (worked, but could fail to return results under certain circumstances) * libopac now works : in Koha >> parameters >> biblioframework >> modify field or subfield. If you set "opac text" to a different value than librarian text, you'll have different headers/text for MARC fields (for example : "1st responsability" for librarians, "author" for end users) * removed a limit to 255 char in field length in MARC editor (the DB can handle much more) * tabs in MARC editor : the active tab is now hilighted & in biblio modif, empty tabs are not shown (as in biblio add) * bugfixes in permissions (some pages required parameters where they should require editcatalogue) * the z3950daemon was buggy (forgotten to port a bugfix in 2.0 branch. It works again) === CIRCULATION === * renewal date was improperly calculated. Now, returndate is calculated from today, not from previous returndate * display waiting status only if item has arrived at pickup branch. Setting 'atdestination' variable if so. Changes are required in the template to take advantage of this. * in circulation, when clicking on member, the member page is opened twice (in main window & in a popup). The popup has been removed. === BORROWERS === * bugfixes in parameters (when modifying a borrower, with alternate address) * members flags (card lost, debarred, gone no address) are back in default template. === ALL === * some fixes for date & currency format IMPROVEMENTS ***** Major === STATS === * The stat module is here !!! In Reports menu, you now have 4 powerful "wizards" (for catalogue, borrowers, issues and acquisitions). You can define 3 things in a report : what you want in columns, what you want in lines, and filters you want on datas. For issues & acquisitions, you also can choose what you want in each cell (count or amount, or loan length). You can get those results in your borwser, or in your spreadsheet (MS-Excel & OpenOffice.org work fine). This module will continue to be improved to get the possibility to retrieve bulk datas in your spreadsheat. It works quite well, but has still some bugs and weaknesses. You also get some nice "top XXX" stats. === CATALOGUE === * catalogue, changed the small "search glass" behaviour. It now appears only on subfields that have a "link" value. Avoid useless glasses and removes nothing. **** WARNING **** : if you don't change you MARC parameters, glasses DISAPPEAR, because no subfields have a link value. So you MUST "reactivate" them manually. If you want to enable the search glass on field 225$a (collection in UNIMARC), just put 225a to "link" field (Koha >> parameters >> framework >> 225 field >> subfield >> modify $a >> enter 225a in link input field (without quotes or anything else) * showing item status in result list. The book status is in items.notforloan (every non 0 value meaning "book not for loan). The item status should be mapped to an item MARC subfield & this subfield should usually be connected to an authorised_value list. * in authorities search forms, adding a "main entry" field ($a), to limit the search. The "anywhere" field is still here. An option has been added to search "contains" or "start by". * item status (opac & librarian interfaces) The item status has been improved : It now can be : - on order (= item has been ordered, but not yet arrived at the library) - not for loan : if the "notforloan" field is mapped to an authorised value list, the right value is shown. Thus, an item can be "lost" or "being repaired", or whatever you put in the authorised values list. (reminder : the "notforloan" field, when 0 means 'ok, book can be issued', and all other values means 'nok, book can't be issued' (whatever the reason, that can be in the authorised value table) * in catalogue search, the user can now order asc or desc. * in catalogue search, the result list now show the itemtype in a column * in catalogue search, if there is only 1 answer, open it directly, don't show a list of results with just 1 line. * added an option to duplicate a biblio * in search before adding a biblio, the search uses the standard Koha API. It means the user don't have to write the title exactly as in biblio.title (empty words are now excluded) * changed behaviour for long fields : if a field contains more than 200 chars, the field will be edited as a textarea, not as a standard input. More conveinent. * in item MARC editor, the item list is hidden if empty. * in item MARC editor, the user can switch easily to the biblio again * UNIMARC plugin for 4xx fields. In UNIMARC, 4xx are related to links. This plugin works like the authority popup, but search in biblio instead of authorities. To set it up, you must : - define a 4xx$9 that will contain the biblio number of the linked biblio. In this 4xx$9 subfield, you must fill the "link to" with the field/subfield that is connected to biblio.biblionumber (090a by default). - define the subfield you want in the 4xx field. This plugins deals "classic link" method (one of the 2 UNIMARC possibilities for links) - choose one subfield and set unimarc_field_4xx.pl as plugin. === TOOLS === * added a tool in misc/merge_authority.pl to merge 2 authorities (and modify biblios using them) This script can also be used to update biblios that use an authority that has been modified. * added a tool in misc/migration_tools/check_marc_definition.pl that can be helpful when you migrate your datas. It compare the datas in the DB and the setting of MARC structure It show all fields/subfields that are in the MARC DB but NOT in any tab (= fields used but not visible) Usually, this means you made an error in your MARC editor. Sometimes, this is something normal. * Useful for translators only : modified tmpl_process to copy files that are not translated (like images, css... previously, they were not copied, it had to be done manually. Errors occurs because changes in english css or images were not reported to the translation directory giving a buggy translation) === ALL === * added a stylesheet for the printer (useful in acquisition basket printing. The doNotPrint style can be used anywhere to remove a part of the screen during printing) * new permissions : management & tools. You now have 2 new permissions : - management : means the user can manage library parameters, but NOT system parameters. - parameters : means the user can manage all parameters (including system parameters : marc structure, authorised values, system preferences. Was the only flag previously existing) - tools : means the user can import/export datas & edit barcodes. note that for compatibility reasons, a user having "parameters" can access everything. * new permission scheme. In every template new variables are available. They are written CAN_user_permission, with permission being one of the permission flag. templates can now show or hidde menu entries depending on user permissions. For example, a user with just circ permissions should have only the "circulation" button on home page. Templates are NOT updated in this version (except for system parameters, as proof of concept), they will be in the next ones. But the scheme is ready. **** Minor === OPAC === * added ISSN to simple biblio detail * added glasses to OPAC marc view, with same behaviour as in librarian interface. * overdues items are more visible on opac-user page * removed menu at bottom of basket page. They are badly shown in some browsers * in biblio basket, showing item info (location, callnumber and barcode) * if a search give only 1 result, the user reach it directly (without a 1 line list) === ACQUISITION === * acquisition, module, adding a button to delete a line in order (was possible by setting qty to 0, but it's more user-friendly) === CATALOGUE === * in authorities, added a "main entry" search field. Will limit the search to the main entry of the main field of the authority (the $a of the tag_to_report field) === BORROWERS === * Show the current borrower in librarian interface, normal view of a biblio (with a link to jump to borrower page) === CIRCULATION === * in circulation, adding a button to edit the borrower & go back to the circ screen directly. === TOOLS === * changes in overdue_notice.pl script : - moving all parameters at start of script => easier to maintain - sending overdues for borrowers without mail to a "koha admin mail". - ignoring borrowers with "overduenoticerequired" set to 0 (= don't send overduenotice) - removing "print" to have a silent script (ie can be put in crontab) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org) _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

From Marrakech-MAROC- to KOHA community
by ZAHRAOUI Maati 08 Apr '05

08 Apr '05

Hi! I'm very happy and proud to be among the KOHA Community!and very sory for my bad english! I'm trying to use KOHA in our Library(FACULTY OF MEDICINE OF MARRAKECH -MOROCOO-) We 've been using the INMAGIC DBTextworks. We think KOHA 'is more untersting for us.It's just one mount that we 've started that project... Can you please indicate a listing of KOHA supporters speaking FRENCH. Thank you very much. Long life to KOHA! ___________________________________________________ Share diaries and photos with your friends and family. http://www.homemaster.net - Homemaster. Come Together. Online. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Problem with Z3950 Lookups - GRS1
by Jim Skon 07 Apr '05

07 Apr '05

Hello, I am evaluating Koha for possible deployment in Manila. I cannot get the Z3950 feature to work. After tracing the internal operations, I can see the query going out, and the results coming back in (to process3950queue), and being placed into the z3950results table. They, however are being dropped by processz3950queue before making it to the marc_breeding table. The reason is that the queries are coming back with an encoding type of GRS1, which the processing loop in processz3950queue siliently drops. I am using "zed.natlib.govt.nz", port 210, database pinz. I set the server entry set for MARC21 encoding. Any idea what is going on here? Thanks! James Skon, Ph.D. Professor of Computer Science Mount Vernon Nazarene University www.mvnu.edu _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

importing marc
by Christopher M. Jones 07 Apr '05

07 Apr '05

I imported a file using Koha's import MARC facility this afternoon. I noticed a few things. First, my marc file contains an 852 field for barcodes. I had hoped that Koha would use these barcodes to put items into the catalog, but it didn't. Second, records for items that were already in the catalog were not overwritten by records in the imported file. The marc records are incomplete in some places, for instance =852 01 $p00002401,00002402,00002403$t1,2,3$aLaNODSA$x<enter accession number>$cMain/Fiction/other$e3600 Desire Parkway, New Orleans, LA 70126, USA $h classif part AX### $i item part .### $k call no prefix $m call no suffix Is this preventing me from getting what I want? Is there another way to achieve the opposite of the above two behaviors? Aside: I noticed that going to item types in system preferences returns an internal server error using the npl template. Is there something missing from the template? _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

importing marc
by Christopher M. Jones 07 Apr '05

07 Apr '05

I imported a file using Koha's import MARC facility this afternoon. I noticed a few things. First, my marc file contains an 852 field for barcodes. I had hoped that Koha would use these barcodes to put items into the catalog, but it didn't. Second, records for items that were already in the catalog were not overwritten by records in the imported file. The marc records are incomplete in some places, for instance =852 01 $p00002401,00002402,00002403$t1,2,3$aLaNODSA$x<enter accession number>$cMain/Fiction/other$e3600 Desire Parkway, New Orleans, LA 70126, USA $h classif part AX### $i item part .### $k call no prefix $m call no suffix Is this preventing me from getting what I want? Is there another way to achieve the opposite of the above two behaviors? _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

installer.pl on FDC3
by kent 07 Apr '05

07 Apr '05

Hello, I've been trying to install Koha database on a FDC3 machine running Apache. The database server is running on another server running RedHat 8.0. I am having problems creating the connection to the MySQL server. I run the installer.pl, all goes well till I get to the Database host where I put in the IP address. Creating the MySQL database for Koha... ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 256ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! The above is what I get when it get's to the databse creation part. It appears that it is trying to connect to the localhost instead of the remote MySQL server. Any suggestions? Kent L. Nasveschuk _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0