On Dec 6, 2017 9:50 PM, <koha-request@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Re: Look for records with specific info in a mark field (Barton Chittenden) 2. Re: KOCT 0.4.5 (Tomas Cohen Arazi) 3. Re: Can't run auth_show_hidden_data.pl script (Mark Alexander) 4. Re: MARC field and heading validation with Koha (Hernandez, Heather) 5. Re: Can't run auth_show_hidden_data.pl script (Prof. Lisandro Laura) 6. where to set Refund lost item fee (Admire Mutsikiwa) 7. Re: where to set Refund lost item fee (Jonathan Druart)
----------------------------------------------------------------------
Message: 1 Date: Wed, 6 Dec 2017 09:45:07 -0500 From: Barton Chittenden <barton@bywatersolutions.com> To: Katrin Fischer <Katrin.Fischer.83@web.de> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Look for records with specific info in a mark field Message-ID: <CAMSJbVuS5HmAKFJib6WzytUNDrvnVaYC14hgpi0N+YroV3iBHQ@mail. gmail.com> Content-Type: text/plain; charset="UTF-8"
Good answer, Katrin!
On Dec 4, 2017 15:17, "Katrin Fischer" <katrin.fischer.83@web.de> wrote:
Hi Alvaro,
yes, Koha stores the complete record as MARCXML and only some fields are mapped to database columns. You can see the mappings in Administration > Koha to MARC mappings. Be careful, after changing it you need to run a script to populate database fields correctly. The MARC record is stored in either biblioitems.marcxml (older versions) or biblio_metadata.metadata (current versions) and can be queried using the ExtractValue function. You can find examples in the reports library on the wiki:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
Hope this helps,
Katrin
On 04.12.2017 21:03, Alvaro Cornejo wrote:
Hi
How can I do a MySQL search for all the records/items with an specific value in an specific marc field Xx?
I've looked at the bilblio and related tables but I'm unable to find a table with marcs fields info. I saw some marcxml fields however; are marc values stored there and I need to xlmparse that info to get an specific value?
Regards
Alvaro _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 2 Date: Wed, 06 Dec 2017 14:50:16 +0000 From: Tomas Cohen Arazi <tomascohen@gmail.com> To: Matthias Meusburger <matthias.meusburger@biblibre.com> Cc: Koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] KOCT 0.4.5 Message-ID: <CABZfb=XxrRm68QxTTwXvyMwFkPojqmeuHHzR30JbiRP9Js6tAg@mail. gmail.com> Content-Type: text/plain; charset="UTF-8"
Excelent work, Matthias!
El mié., 6 dic. 2017 a las 9:27, Matthias Meusburger (< matthias.meusburger@biblibre.com>) escribió:
Hi everyone,
We had a "Ship it" day during this Biblibre winter camp, and I chose to work on KOCT.
So here's what's new in v0.4.5:
- Add a "configuration test" button which will check if koha host, username and password are ok
- Retrieve branchnames and branchcodes as a dropdown list
(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16497 is available, adresses https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19689 )
- Cleaner error handling
(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19752 is available)
- Add data export in Koc format
(see https://wiki.koha-community.org/wiki/Koha_offline_ circulation_file_format )
- Add a button to jump to the configuration page.
This new version should be available at Mozilla's in a couple of days.
Enjoy :) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
------------------------------
Message: 3 Date: Wed, 06 Dec 2017 09:51:39 -0500 From: Mark Alexander <marka@pobox.com> To: Prof. Lisandro Laura <prof.llaura@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Can't run auth_show_hidden_data.pl script Message-ID: <1512571828-sup-6391@t60p> Content-Type: text/plain; charset=UTF-8
Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 -0300:
perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl
But I get the following error:
"Can't locate Koha/Authorities.pm in @INC (you may need to install the Koha::Authorities module) (@INC contains: /etc/perl
This sounds familiar. Try running the following command first:
koha-shell LIBRARY
where LIBRARY is your Koha instance name. After that, the various Koha shell scripts should work.
------------------------------
Message: 4 Date: Wed, 6 Dec 2017 07:26:01 -0800 From: "Hernandez, Heather" <heather_hernandez@nps.gov> To: "Reichert, Kumiko" <KREICHERT@bridgew.edu> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz>, ByWater Partners <partners@bywatersolutions.com> Subject: Re: [Koha] MARC field and heading validation with Koha Message-ID: <CADiPvh=zsi3r-CyFb-En_pk0PMPsbMHbn+wvZtaHTVW4VpH+qA@ mail.gmail.com> Content-Type: text/plain; charset="UTF-8"
Hi, Kumiko--
I'm not sure our workflow would be applicable since we're a very specialized museum library, but maybe you'll get some ideas?
We lacked a lot of authority capabilities in our previous catalog software (Athena), so our headings were & are pretty messy. I'm in the middle of a project to clean up the authority file and then the remaining authority controlled fields in the bib records. So, that said:
I catalog on OCLC (Connexion Client) but am experimenting with creating original records in Koha with the Advanced Editor. I manually search every single authority controlled field in the Koha authority file, and download new authority records from OCLC (or for locally created name, series, etc., records, key them very laboriously into Koha since there's no Advanced Editor for authority records--I so dearly hope one is developed!).
If I have reason to substantially edit a bib record, I'll manually search all the authority controlled fields that lack a $9 authority record link--I have to do this manually because our Koha installation doesn't validate any headings that have subfields that are not present in an authority record--that is, only authority-controlled bib fields that match every, single subfield in the authority record will validate & link. So, e.g., in our catalog, this heading in a bib record will validate & link to an authority record (which one can see with the $9): 650 _ 0 $a Women sailors. $9 17788
But this heading will not validate & link (so lacks the $9), because authority records are not created with headings with free-floating subdivisions such as "$v Fiction:" 650 _ 0 ‡aWomen sailors‡vFiction.
So with us, authority control is still a human function. We thought briefly about using a vendor for the initial cleanup (I've had this done at previous jobs & it's worked very well), but we lack the funds for such a project.
One feature that is beautiful is that *if* headings are linked to an authority record, once the authority record is edited or overlaid with a newer imported version, the linked headings are pretty instantly changed. Then it's just a matter of some searching & manual editing to update the headings that aren't linked because they have, e.g., free-floating subdivisions. Or typos...sigh...:)
Our catalog is hosted and supported by ByWater & we've chatted a bit about how we might experiment with some changes that might improve heading linking, but haven't yet got beyond that--we have yet to upgrade beyond 17.05, so have yet to implement ElasticSearch which, I imagine, might impact indexing/linking.
Hope this is helpful! Cheerio, h2 ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez@nps.gov https://www.nps.gov/safr/learn/historyculture/research-center.htm
------------------------------
Message: 5 Date: Wed, 6 Dec 2017 12:51:12 -0300 From: "Prof. Lisandro Laura" <prof.llaura@gmail.com> To: Mark Alexander <marka@pobox.com> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Can't run auth_show_hidden_data.pl script Message-ID: <CAJoiCcmR1ysfZoXYq7ox3uxBN5xpt+XTcDx7b-Rqd7q8D7aNgA@mail. gmail.com> Content-Type: text/plain; charset="UTF-8"
Perfect! That works Thank you, Lisandro
2017-12-06 11:51 GMT-03:00 Mark Alexander <marka@pobox.com>:
Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 -0300:
perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl
But I get the following error:
"Can't locate Koha/Authorities.pm in @INC (you may need to install the Koha::Authorities module) (@INC contains: /etc/perl
This sounds familiar. Try running the following command first:
koha-shell LIBRARY
where LIBRARY is your Koha instance name. After that, the various Koha shell scripts should work.
------------------------------
Message: 6 Date: Wed, 6 Dec 2017 17:56:52 +0200 From: "Admire Mutsikiwa" <amutsikiwa@uzlib.uz.ac.zw> To: <koha@lists.katipo.co.nz> Subject: [Koha] where to set Refund lost item fee Message-ID: <00b201d36eaa$d5844ef0$808cecd0$@uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii"
Hi
I would like to enquire as to where the Refund Lot Item fee is configured.
Kind Regards,
Admire Mutsikiwa (Mr)
ICT Manager
Libraries
University of Zimbabwe
Tel:+263-4-303276
Mob:+263771117777
"It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
------------------------------
Message: 7 Date: Wed, 06 Dec 2017 16:19:44 +0000 From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> To: Admire Mutsikiwa <amutsikiwa@uzlib.uz.ac.zw> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] where to set Refund lost item fee Message-ID: <CAJzKNY4_u41r_9X-hUDyMtdmu3Ew7CuM1f_ AoG2OQ6ytLXrkZg@mail.gmail.com> Content-Type: text/plain; charset="UTF-8"
Hi Admire, See on the circulation rules page: "Default lost item fee refund on return policy"
As well as the "Processing fee (when lost)" value when you edit item types.
Regards,
Jonathan
On Wed, 6 Dec 2017 at 12:56 Admire Mutsikiwa <amutsikiwa@uzlib.uz.ac.zw> wrote:
Hi
I would like to enquire as to where the Refund Lot Item fee is configured.
Kind Regards,
Admire Mutsikiwa (Mr)
ICT Manager
Libraries
University of Zimbabwe
Tel:+263-4-303276 <+263%204%20303%20276>
Mob:+263771117777 <+263%2077%20111%207777>
"It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 146, Issue 14 *************************************