Re: [Koha] Importing Item Types from Excel Spreadsheet

2021-01-18 Thread Charles Kelley
Hi, all! It's been awhile since I initially wrote on this topic, so please forgive me for this late response. In my original question, I asked whether it was possible to import the item types (DVD for 'DVD', PDF for 'Portable Document Format', BK for 'Book', etc.) because my library is

Re: [Koha] Importing Item Types from Excel Spreadsheet

2021-01-16 Thread Michael Kuhn
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

Re: [Koha] Importing Item Types from Excel Spreadsheet

2021-01-16 Thread Katrin Fischer
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

Re: [Koha] Importing Item Types from Excel Spreadsheet

2021-01-14 Thread vikram zadgaonkar
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 wrote: > Hi, all! > > I see there is a means to export the item types (BKS for books, PER for > periodicals, etc.) into

[Koha] Importing Item Types from Excel Spreadsheet

2021-01-14 Thread Charles Kelley
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