Importing Item Types from Excel Spreadsheet
Hi, all! I see there is a means to export the item types (BKS for books, PER for periodicals, etc.) into various formats, e.g., CVS and Excel spreadsheet. Is there a way to import them? I can't find documentation, and my library is migrating to a new machine. I have looked at the Tools but I see authority records and bibliographic records but not other types of data. Many thanks! -- 気を付けて。 /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.
Hello Charles, You need to convert the file into .mrk . You may try marcedit tool for conversion . Vikram Zadgaonkar On Fri, Jan 15, 2021 at 10:08 AM Charles Kelley <cmkelleymls@gmail.com> wrote:
Hi, all!
I see there is a means to export the item types (BKS for books, PER for periodicals, etc.) into various formats, e.g., CVS and Excel spreadsheet. Is there a way to import them? I can't find documentation, and my library is migrating to a new machine.
I have looked at the Tools but I see authority records and bibliographic records but not other types of data.
Many thanks!
--
気を付けて。 /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
Hi Charles, the export is provided by the tools we use for presenting data in tables. Import is a different matter. For some data there are existing tool, but itemtypes can only be imported using SQL at the moment. Katrin On 15.01.21 05:37, Charles Kelley wrote:
Hi, all!
I see there is a means to export the item types (BKS for books, PER for periodicals, etc.) into various formats, e.g., CVS and Excel spreadsheet. Is there a way to import them? I can't find documentation, and my library is migrating to a new machine.
I have looked at the Tools but I see authority records and bibliographic records but not other types of data.
Many thanks!
Hi Charles Katrin wrote:
the export is provided by the tools we use for presenting data in tables. Import is a different matter. For some data there are existing tool, but itemtypes can only be imported using SQL at the moment.
Maybe the content of file "sample_itemtypes.sql" (which imports some sample item types during the initial configuration of Koha) will be of some help to you when creating your own SQL file: INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES ('BK', 'Books',0,0,'bridge/book.gif',''), ('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''), ('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''), ('MP', 'Maps',5,0,'bridge/map.gif',''), ('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''), ('MU', 'Music',5,0,'bridge/sound.gif',''), ('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''), ('REF', 'Reference',0,1,'bridge/reference.gif',''); Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
participants (4)
-
Charles Kelley -
Katrin Fischer -
Michael Kuhn -
vikram zadgaonkar