Re: [Koha] MARC export - not exporting everything?
Manual updated with a note about this : http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ea69b89c05f316f8b39e1238d479f8f0212569f6 Nicole On Mon, Mar 24, 2014 at 7:19 PM, Elaine Bradtke e...@efdss.org wrote: Thank you again Bernardo. It is currently set to specific item. That explains at least some of the strange behaviour. I'll change it and test it tomorrow but I think this may solve the problem. On Mon, Mar 24, 2014 at 9:25 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Elaine, what's the value of your syspref item-level_itypes? (Admin System preferences Cataloguing) If it's set to 'specific item' then you won't get any results from the export unless there is a item on the bibliographic records. If you set it to 'biblio record' then you can export records without items. Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Mar 24, 2014 at 2:43 PM, Elaine Bradtke e...@efdss.org wrote: With a feeling of deja vu. . . it's a bug I filed two years ago http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7425 On Mon, Mar 24, 2014 at 4:43 PM, Elaine Bradtke e...@efdss.org wrote: l looked at bug 11940. Our records aren't usually very large, and my first attempt was for a subset of records that do not have any items attached. The problem reported in 11940 seems to be something that happens when there are too many items. I have tested an XML export of of the subset of records selected by item type, but got the same results, an empty file. However, export all records with items attached does work in XML (whereas it doesn't in plain MARC). Part of the problems seems to be related to limiting by item type. I'm assuming this item type is the one stored in MARC21 942$c If it was pulling it from the item record that would explain why I get 0 records if I limit it by item type. I'm looking around on Bugzilla now to see if anything matches what we're experiencing. On Thu, Mar 20, 2014 at 12:16 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op wo 19-03-2014 om 23:40 [+]: No errors showed up in the logs. I can export the whole catalogue (minus the items) by selecting don't export items. Otherwise, all I get are empty files. I haven't tried exporting single items. Hmm, that contradicts and selecting 'Don't export items' but this resulted in another empty file. If it works without items, then it's possibly bug 11940. Have you tried exporting as XML, that tends to not have problems with overlarge records. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture
Re: [Koha] MARC export - not exporting everything?
That should help a lot. Thanks On Mon, Mar 31, 2014 at 5:01 PM, Nicole Engard neng...@gmail.com wrote: Manual updated with a note about this : http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ea69b89c05f316f8b39e1238d479f8f0212569f6 Nicole On Mon, Mar 24, 2014 at 7:19 PM, Elaine Bradtke e...@efdss.org wrote: Thank you again Bernardo. It is currently set to specific item. That explains at least some of the strange behaviour. I'll change it and test it tomorrow but I think this may solve the problem. On Mon, Mar 24, 2014 at 9:25 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Elaine, what's the value of your syspref item-level_itypes? (Admin System preferences Cataloguing) If it's set to 'specific item' then you won't get any results from the export unless there is a item on the bibliographic records. If you set it to 'biblio record' then you can export records without items. Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Mar 24, 2014 at 2:43 PM, Elaine Bradtke e...@efdss.org wrote: With a feeling of deja vu. . . it's a bug I filed two years ago http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7425 On Mon, Mar 24, 2014 at 4:43 PM, Elaine Bradtke e...@efdss.org wrote: l looked at bug 11940. Our records aren't usually very large, and my first attempt was for a subset of records that do not have any items attached. The problem reported in 11940 seems to be something that happens when there are too many items. I have tested an XML export of of the subset of records selected by item type, but got the same results, an empty file. However, export all records with items attached does work in XML (whereas it doesn't in plain MARC). Part of the problems seems to be related to limiting by item type. I'm assuming this item type is the one stored in MARC21 942$c If it was pulling it from the item record that would explain why I get 0 records if I limit it by item type. I'm looking around on Bugzilla now to see if anything matches what we're experiencing. On Thu, Mar 20, 2014 at 12:16 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op wo 19-03-2014 om 23:40 [+]: No errors showed up in the logs. I can export the whole catalogue (minus the items) by selecting don't export items. Otherwise, all I get are empty files. I haven't tried exporting single items. Hmm, that contradicts and selecting 'Don't export items' but this resulted in another empty file. If it works without items, then it's possibly bug 11940. Have you tried exporting as XML, that tends to not have problems with overlarge records. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site)
Re: [Koha] MARC export - not exporting everything?
l looked at bug 11940. Our records aren't usually very large, and my first attempt was for a subset of records that do not have any items attached. The problem reported in 11940 seems to be something that happens when there are too many items. I have tested an XML export of of the subset of records selected by item type, but got the same results, an empty file. However, export all records with items attached does work in XML (whereas it doesn't in plain MARC). Part of the problems seems to be related to limiting by item type. I'm assuming this item type is the one stored in MARC21 942$c If it was pulling it from the item record that would explain why I get 0 records if I limit it by item type. I'm looking around on Bugzilla now to see if anything matches what we're experiencing. On Thu, Mar 20, 2014 at 12:16 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op wo 19-03-2014 om 23:40 [+]: No errors showed up in the logs. I can export the whole catalogue (minus the items) by selecting don't export items. Otherwise, all I get are empty files. I haven't tried exporting single items. Hmm, that contradicts and selecting 'Don't export items' but this resulted in another empty file. If it works without items, then it's possibly bug 11940. Have you tried exporting as XML, that tends to not have problems with overlarge records. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC export - not exporting everything?
With a feeling of deja vu. . . it's a bug I filed two years ago http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7425 On Mon, Mar 24, 2014 at 4:43 PM, Elaine Bradtke e...@efdss.org wrote: l looked at bug 11940. Our records aren't usually very large, and my first attempt was for a subset of records that do not have any items attached. The problem reported in 11940 seems to be something that happens when there are too many items. I have tested an XML export of of the subset of records selected by item type, but got the same results, an empty file. However, export all records with items attached does work in XML (whereas it doesn't in plain MARC). Part of the problems seems to be related to limiting by item type. I'm assuming this item type is the one stored in MARC21 942$c If it was pulling it from the item record that would explain why I get 0 records if I limit it by item type. I'm looking around on Bugzilla now to see if anything matches what we're experiencing. On Thu, Mar 20, 2014 at 12:16 AM, Robin Sheat ro...@catalyst.net.nzwrote: Elaine Bradtke schreef op wo 19-03-2014 om 23:40 [+]: No errors showed up in the logs. I can export the whole catalogue (minus the items) by selecting don't export items. Otherwise, all I get are empty files. I haven't tried exporting single items. Hmm, that contradicts and selecting 'Don't export items' but this resulted in another empty file. If it works without items, then it's possibly bug 11940. Have you tried exporting as XML, that tends to not have problems with overlarge records. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC export - not exporting everything?
I also tried limiting it to the item type and selecting 'Don't export items' but this resulted in another empty file. On Wed, Mar 19, 2014 at 5:34 PM, Elaine Bradtke e...@efdss.org wrote: Koha 3.14.03 Several attempts were needed to export the entire catalogue - I really only wanted a certain item type that does not have item records. First I tried exporting only these records by choosing the appropriate item type. According to MARC edit, I had -11 records. Yes, a negative number. The MARC breaker failed to parse this file. Not surprising when I saw that it had 0 KB of data. Next I exported what I thought was the entire catalog - the only thing I selected was the library, everything else left blank. However the only records in the exported file are the ones with item records. Exactly the records I don't need! Finally, I exported the whole file again, this time selecting 'Don't export items'. And this, and only this configuration produced a full export of the biblios. Is this normal or expected behaviour? It seems counter-intuitive to me. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC export - not exporting everything?
Elaine Bradtke schreef op wo 19-03-2014 om 17:39 [+]: I also tried limiting it to the item type and selecting 'Don't export items' but this resulted in another empty file. What showed up in the error logs? Does exporting only one or two things work? -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MARC export - not exporting everything?
No errors showed up in the logs. I can export the whole catalogue (minus the items) by selecting don't export items. Otherwise, all I get are empty files. I haven't tried exporting single items. Meanwhile, I've fixed the problem records. Uploading and staging MARC records, and importing all seem to work as expected. On Wed, Mar 19, 2014 at 10:22 PM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op wo 19-03-2014 om 17:39 [+]: I also tried limiting it to the item type and selecting 'Don't export items' but this resulted in another empty file. What showed up in the error logs? Does exporting only one or two things work? -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha