Re: Koha Digest, Vol 146, Issue 14

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Koha Digest, Vol 146, Issue 14

Hirak Hazarika
On Dec 6, 2017 9:50 PM, <[hidden email]> wrote:

> Send Koha mailing list submissions to
>         [hidden email]
>
> 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
>         [hidden email]
>
> You can reach the person managing the list at
>         [hidden email]
>
> 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 <[hidden email]>
> To: Katrin Fischer <[hidden email]>
> Cc: koha <[hidden email]>
> 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" <[hidden email]> 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
> >> [hidden email]
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > [hidden email]
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 06 Dec 2017 14:50:16 +0000
> From: Tomas Cohen Arazi <[hidden email]>
> To: Matthias Meusburger <[hidden email]>
> Cc: Koha <[hidden email]>
> 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 (<
> [hidden email]>) 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
> > [hidden email]
> > 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 <[hidden email]>
> To: Prof. Lisandro Laura <[hidden email]>
> Cc: koha <[hidden email]>
> 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" <[hidden email]>
> To: "Reichert, Kumiko" <[hidden email]>
> Cc: "[hidden email]" <[hidden email]>, ByWater
>         Partners <[hidden email]>
> 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, [hidden email]
> 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" <[hidden email]>
> To: Mark Alexander <[hidden email]>
> Cc: koha <[hidden email]>
> 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 <[hidden email]>:
> > 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" <[hidden email]>
> To: <[hidden email]>
> 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 <[hidden email]>
> To: Admire Mutsikiwa <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [Koha] where to set Refund lost item fee
> Message-ID:
>         <CAJzKNY4_u41r_9X-hUDyMtdmu3Ew7CuM1f_
> [hidden email]>
> 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 <[hidden email]>
> 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
> > [hidden email]
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Koha mailing list
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> End of Koha Digest, Vol 146, Issue 14
> *************************************
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha