November 2009 - Koha-devel - lists.koha-community.org

data import question & 008 use in Koha
by Christopher Curry 03 Nov '09

03 Nov '09

Hello all, We're in the middle of migrating MARC data to Koha. We tried importing serials data into Koha and a record that had 1900+ items attached did not import. I found the record and tested importing it, removing items until it would import and found out that 1238 was the maximum number of items I could import with one MARC record. Can anyone tell me if there is a way to configure the import to accept more items? I used bulkmarcimport.pl on Koha 3.0.1, running on Debian Lenny. Also, our old ILS has a database issue that results in incomplete export of records created from original cataloging. These records are missing 008 fields. We're working out a method of exporting the data from the back end and splicing it back into the MARC before import, but the data imports into Koha without announced or noticeable errors. I wonder if we're wasting our time. Does Koha use the 008 field for anything? -- Cheers, Christopher Curry Assistant Technical Librarian / Assistant IT Officer American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299 ccurry(a)amphilsoc.org <mailto:ccurry@amphilsoc.org> *For technical support, please use helpdesk(a)amphilsoc.org <mailto:helpdesk@amphilsoc.org>* Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org

3 3

Default Koha to MARC Mappings on nonexistent table fields?
by Kyle Hall 03 Nov '09

03 Nov '09

Hey All, We have set up a plain Koha 3 install which we are using for import testing. I wrote a script to rebuild the biblio, biblioitems, and items tables from biblioitems.marcxml using the data stored in marc_subfield_structure. What I have found is that some of the framework code seems to reference table columns that do not exists. The columns referenced are: * bibliosubject.subject ( there is no bibliosubject table ) * biblioitems.cn_edition * biblioitems.cn_prefix Can anyone provide any insight to this situation? Are these dead columns, or columns that were never added, or just bugs? Thanks, Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )

3 2

Migrating from Sirsi to Koha
by Lee Phillips 02 Nov '09

02 Nov '09

Hello all, I would like to hear from any libraries or consortia that migrated to Koha from Sirsi. I am most interested in the ease of gaining access to bibliographic and user records for conversion into Koha. I know of one school district in Montana that had trouble accessing their records and had to pay for extraction from Sirsi. If your library has made this migration and would share your experience with me I would be grateful. Best Lee Phillips Butte Silver Bow Public Library Butte, MT

1 0