Re: [Koha] Frameworks and Their Purpose
Hello again, all! In an earlier exchange, on 7 July 2020 at 09:51, I wrote: I do have a follow-up question: Is it possible in Koha to change a framework
of a group records en masse? For example, if I have a group of 747 maps (949 $c = "MAP") but their framework is BKS, can I change the framework to MAP through Koha in one fell swoop (and if so, how so); or must I painstakingly change them one at a time?
I have tried exporting them into MarcEdit and importing them anew into Koha while selecting "Import this batch into the catalog" with "Add new bibliographic records into this framework:" (select from the dropdown menu), but the framework for each record remains as it was before the exporting and importing.
On 6 July 2020, at 21:14, Eric Bégin <eric.begin@inLibro.com> replied:
As far as I know, there is no way to change the records framework in batch editing.
If I had to do it, I would update the data directly in the database.
The framework is defined as the 'frameworkcode' column of the 'biblio' table.
I was afraid of that. Thanks for the reply. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
If you can see the 949$c in MarcEdit, you can change it there. I'm pretty sure I did this to a batch of records, but it was quite a while ago. Elaine Bradtke VWML Our income is severely diminished in these exceptionally uncertain times. Please help us to survive beyond this national crisis. Donate now <https://www.efdss.org/support-us>. English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 On Thu, Jul 9, 2020 at 12:19 AM Charles Kelley <cmkelleymls@gmail.com> wrote:
Hello again, all!
In an earlier exchange, on 7 July 2020 at 09:51, I wrote:
I do have a follow-up question: Is it possible in Koha to change a framework
of a group records en masse? For example, if I have a group of 747 maps (949 $c = "MAP") but their framework is BKS, can I change the framework to MAP through Koha in one fell swoop (and if so, how so); or must I painstakingly change them one at a time?
I have tried exporting them into MarcEdit and importing them anew into Koha while selecting "Import this batch into the catalog" with "Add new bibliographic records into this framework:" (select from the dropdown menu), but the framework for each record remains as it was before the exporting and importing.
On 6 July 2020, at 21:14, Eric Bégin <eric.begin@inLibro.com> replied:
As far as I know, there is no way to change the records framework in batch editing.
If I had to do it, I would update the data directly in the database.
The framework is defined as the 'frameworkcode' column of the 'biblio' table.
I was afraid of that. Thanks for the reply.
--
気を付けて。 /ki wo tukete/ = Take care.
-- Charles.
Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338
Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN
+1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell]
mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually. _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello, Elaine, et al! In our latest exchange, on 10 July 2020, at 3:42 AM, you wrote: If you can see the 949$c in MarcEdit, you can change it there. I'm pretty
sure I did this to a batch of records, but it was quite a while ago.
I don't believe that 949$c and the framework are exactly the same variable in the Koha code even though they are related. 949$c seems to become the default item code when adding new items; while the framework is stored in frameworkcode of each bibliographic record, and it corresponds to the different frameworks in your system. In my case, I've tried to frameworkcode to the Library of Congress bibliographic types of BK, CR, MU, etc. for the ease and convenience of my staff. Unfortunately, there are quite a few records that have the Koha default frameworkcode, and I'm trying to correct them. Since our system isn't yet live, it may be easier to export the records and upload them into the permanent system with the 949$c-to-frameworkcode correspondence. Not a perfect solution by any means, but a viable one. If it would be nice if Koha did have such a default correspondence table (to be overridden with another 949 subfield or 999 subfield). Maybe I'll submit such a feature request. Last December, I asked this question. I got a response that it may be possible to make such a mass change through Koha's SQL faculty. I know how to write SQL statements but it's been awhile since I last did so. I'll have to relearn SQL SET statements and experiment on a very small set of records before I change frameworkcode in the entire database. Thanks for your suggestion and comments. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
participants (2)
-
Charles Kelley -
Elaine Bradtke