I'm importing a csv file of books into Koha, using MarcEdit. The fields are: author, title, publisher, year, item type, barcode, and shelf location. It looks like I'm getting two items for every line in the file. One item contains the correct barcode, and the other item contains the correct shelf location. Anyone have any ideas where I'm going wrong? And this might be a related question: what is the difference between an authority record and a bib record? Thanks -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-creates-multiple-items-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
I'm having a similar problem. I have 10 attributes per excel tuple. Two attributes (the 100 and 245 fields) map correctly in the underlying MARC21 data, but each of the 952 field are imported as separate tuples instead of all into the first tuple. Correspondingly, I get eight individual items created, each only one of the 952 attributes. I found that during mapping the excel data into the appropriate 952 fields, MarcEdit 5.9 creates a separate 952 entry for each individual attribute. These separate 952 items are apparently is imported as separate books rather than a single book. I speculate that creating a single 952 cell and populating the data with the appropriate MARC data delimiters ($a, $b ...) would solve this problem, but that seems suboptimal on a large scale import. On Mon, Nov 18, 2013 at 8:13 AM, magmatic <magmatic@timkoop.com> wrote:
I'm importing a csv file of books into Koha, using MarcEdit. The fields are: author, title, publisher, year, item type, barcode, and shelf location.
It looks like I'm getting two items for every line in the file. One item contains the correct barcode, and the other item contains the correct shelf location.
Anyone have any ideas where I'm going wrong?
And this might be a related question: what is the difference between an authority record and a bib record?
Thanks -- Tim
-- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-creates-multiple-items-tp5... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I think I've found the solution. In MarcEdit, when converting from csv to .mrk, I click "Auto Generate" because my headings are the fields. Then you can select all the 952 fields in that box on the right. Then right-click on them and select "Join Items". I think that does it. -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-creates-multiple-items-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
Tim, Selecting all the 952 fields and joining them in MarcEdit definitely cleaned up the MARC record output. Unfortunately, I'm away from the museum library today. I will import it on Friday afternoon (about 48 hours from now) when I return. Did you have any luck on the import on your side? John On Wed, Nov 20, 2013 at 12:57 PM, magmatic <magmatic@timkoop.com> wrote:
I think I've found the solution.
In MarcEdit, when converting from csv to .mrk, I click "Auto Generate" because my headings are the fields. Then you can select all the 952 fields in that box on the right. Then right-click on them and select "Join Items".
I think that does it.
-- Tim
-- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-creates-multiple-items-tp5... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
John Palmer -
magmatic