Hi Charles, You probably know this already, possibly because I posted something similar a few weeks ago, but MarcEdit has a Delimited Text Translator that makes converting from a spreadsheet to MARC absurdly easy. You can see a very short example in my "MarcEdit in three minutes" presentation at http://avengingchicken.online/misc/king_marcedit_in_three_minutes_with_notes_mla2019.pdf and get MarcEdit at https://marcedit.reeset.net/
Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.k...@medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org As we neared our sixties the cloaks we had wrapped about our essential selves were wearing thin. --Robertson Davies, Fifth Business -----Original Message----- From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Katrin Fischer Sent: Wednesday, December 04, 2019 2:15 AM To: koha@lists.katipo.co.nz Subject: [EXTERNAL] Re: [Koha] Source of Acquisition ** ATTENTION: This email originated from outside the MedStar network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. Hi Charles, in German libraries an acquisition number like this is very common. There is a specific Koha item subfield for it already: 952$i = stocknumber or inventory number. It is indexed in Zebra and there are some value builders (like stocknumberAV.pl) to generate different sequential number patterns that can be used with it or could be adapted to generate what you currently have. Hope this helps, Katrin On 04.12.19 05:58, Charles Kelley wrote: > Hello, all! > > I have been asked to add a new indexed item field (subfield, that is). > Here's the story. > > My library keeps track of its acquisitions in an old Access database. > Each acquisition is given a unique ID number consisting of two parts: > the year of acquisition and its sequence in the acquisition scheme for > the year. > > <acquisition year>-<sequence number> > > For example the acquisition number of *A dictionary of Japanese > and English idiomatic equivalents*, ISBN 0870111116, c. 1, is > 1986-1003. The acquisition number of the same title, c. 2, ordered in the > same batch as c. > 1, is 1986-1003. This means, as you might already induce, that in 1986, c. > 1 and c. 2 were the 1003rd books ordered. A third copy ordered later > in the year would get the acquisition number 1986-1657. If a fourth > copy is ordered in two years, it might get acquisition number > 1988-0384; meaning it was the 384th work ordered in 1988. > > I am building a Koha catalog this library's from a spreadsheet > and Access database, I have been asked to preserve this acquisition > number. It is very important to the staff, and I am too new to > challenge the staff about it. I am confident that in a few years, > we'll have a better different system in operation; but for the present, I > think I ought to keep it. > > Well, I can insert the number into the 952$e field. I could > repurposed the 952$k field since that field is not in use. If I do the > former (952$e), I can rely on the regular Koha indexing handle the > number, the indexing, and so on. If I do the latter (952$k), I have to > create and build a new > index;* and I run the risk that Koha will dedicate 952$k to a function > in the future. > > Have libraries in this discussion list done 952$e? Have libraries > in this discussion list done $952$k? Is there an alternative solution? > Abandoning the porting is not, at this stage, an option although I > concede that in the future, we will likely end up dropping this > version of the acquisition number. > > * I have read the sections on building an index on the Koha wiki. > > Thanks for your help, everyone. > _______________________________________________ Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=KCAnAY3AP7uDiyrHhOm4gguZT8eWTy_nkUw2w1cKrpE&s=BNhM0OiJVScgg7HIKl1aGiRY3olBhaR7_8_iST3vQBw&e= Koha@lists.katipo.co.nz https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=KCAnAY3AP7uDiyrHhOm4gguZT8eWTy_nkUw2w1cKrpE&s=83JHLLssho9Ny9_7TJQAw5Vn9VgUGqMdXncGcBoq2dc&e= ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha