exporting bibliographic records
I have koha 3.10.5 installed in debian 6.0 64bit. I'm trying to export my book item bibliographic holdings, with no option in from biblionumber and to biblionumber, item type books, library: all, and all others not ticked. I'm exporting it into marc. Only 5,000 plus were imported when in fact when I search my OPAC with itemtype books I get 8,000 plus. How come there were bibliographic records not imported. Thanks and good day! -- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557.... Sent from the Koha-general mailing list archive at Nabble.com.
Hi, records do not grow mysteriously, so someone needs to have added them. You could run a report to find when those records have been created, try SELECT title, author, datecreated FROM biblio ORDER BY datecreated DESC; Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkriegel@gmail.com On Sat, May 4, 2013 at 1:41 AM, schnydszch <eugenegf@yahoo.com> wrote:
I have koha 3.10.5 installed in debian 6.0 64bit. I'm trying to export my book item bibliographic holdings, with no option in from biblionumber and to biblionumber, item type books, library: all, and all others not ticked. I'm exporting it into marc. Only 5,000 plus were imported when in fact when I search my OPAC with itemtype books I get 8,000 plus. How come there were bibliographic records not imported. Thanks and good day!
-- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557.... 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
My concern is to export everything supposedly but it only gives me 5,273 imported marc records and when I run your mysql query it gives me 56,962. I have many item types and this includes newspaper articles aside from books. First concern is why I only get exported 5,273 records. Second, when I import by item type and tried it with books again ticking only item type books and library all, I get in my export 5,261 out of 8,091 (8,091 is what I get when I search the OPAC for itemtype books). I reviewed the MARC records through Marcedit and get into the very last record, get its biblionumber and painstakingly go to that record in OPAC results (in this example, I get biblionumber 49087 and the next record 49089). So I export again now putting 49089 in From biblionumber and nothing in To biblio number: ) and I get 746 records. Adding up 5261 and 746 does not give me all book item type. So that's 6007 and I went again in my opac result, went to record no. 6007, compare the Marcedit from the OPAC search result and I have the same record in search result # 6007 which is biblionumber 49851. And so I export again now putting 49851 in From biblionumber and nothing in To biblionumber: I get 1,978 records so adding it up in previous count of 6,007, I get 7985, 106 records short. And repeat the process until I get to my desired MARC records. So, how come it did not export the MARC records in first time export? Could this be a bug or something? Thanks and have a nice day! -- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... Sent from the Koha-general mailing list archive at Nabble.com.
I'm running a slightly older version 3.10.02 in my test system I searched for everything with item type books - 5351 records I exported everything from biblio number 000000 to biblio number 999999, Item type books, Library: all and got 5339 records. The export is not doing what I expect it to do, based on the search results. Why? How? I don't know what is causing the discrepancy, but I am confirming that the results don't match. Do both processes search for information in the same fields? If not, that could be the problem. Elaine On Mon, May 6, 2013 at 3:15 AM, schnydszch <eugenegf@yahoo.com> wrote:
My concern is to export everything supposedly but it only gives me 5,273 imported marc records and when I run your mysql query it gives me 56,962. I have many item types and this includes newspaper articles aside from books. First concern is why I only get exported 5,273 records. Second, when I import by item type and tried it with books again ticking only item type books and library all, I get in my export 5,261 out of 8,091 (8,091 is what I get when I search the OPAC for itemtype books). I reviewed the MARC records through Marcedit and get into the very last record, get its biblionumber and painstakingly go to that record in OPAC results (in this example, I get biblionumber 49087 and the next record 49089). So I export again now putting 49089 in From biblionumber and nothing in To biblio number: ) and I get 746 records. Adding up 5261 and 746 does not give me all book item type. So that's 6007 and I went again in my opac result, went to record no. 6007, compare the Marcedit from the OPAC search result and I have the same record in search result # 6007 which is biblionumber 49851. And so I export again now putting 49851 in From biblionumber and nothing in To biblionumber: I get 1,978 records so adding it up in previous count of 6,007, I get 7985, 106 records short. And repeat the process until I get to my desired MARC records. So, how come it did not export the MARC records in first time export? Could this be a bug or something? Thanks and have a nice day!
-- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... 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
-- 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)
I've actually tried that Elaine a day before I tried to troubleshoot marc export with what I have posted above from: 000000 to: 999999. And yes I did not get what I expected. I have actually other item types other than books but did not get the same results with books. Should we file a bug regarding this? And still regarding this problem, I actually exported from 3.8.x months ago because I have to mass edit our marc records. Other koha users using koha 3.10.5 could you please try exporting records. Thanks and have a nice day! -- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... Sent from the Koha-general mailing list archive at Nabble.com.
It seems like a bug to me.But it would be nice if someone else could confirm the same problem. Elaine On Tue, May 7, 2013 at 1:50 AM, schnydszch <eugenegf@yahoo.com> wrote:
I've actually tried that Elaine a day before I tried to troubleshoot marc export with what I have posted above from: 000000 to: 999999. And yes I did not get what I expected. I have actually other item types other than books but did not get the same results with books. Should we file a bug regarding this? And still regarding this problem, I actually exported from 3.8.x months ago because I have to mass edit our marc records. Other koha users using koha 3.10.5 could you please try exporting records. Thanks and have a nice day!
-- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... 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
-- 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)
I think I've figured this one out. I had problems with my bibliographic records then. When I ran zebra index -b -a -r -x, there were four records not properly indexed. So this is where the problems occurred, such that when I export biblio records in tools, it stop in the problematic record. Remember the instance that I have to get the last biblio record I got during export and start to the next record (by +1 in biblionumber) and then it stops to a certain biblionumber, that was because of malformed/problematic biblio records. So when I deleted this records and re-run the zebra index and got no errors, I was able to export all of my records. -- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... Sent from the Koha-general mailing list archive at Nabble.com.
That's useful information. I'll run some checks on our data as well. We had some unexpected difficulties with the last upload, there may be some bad records lurking in there. On Mon, May 20, 2013 at 1:53 AM, schnydszch <eugenegf@yahoo.com> wrote:
I think I've figured this one out. I had problems with my bibliographic records then. When I ran zebra index -b -a -r -x, there were four records not properly indexed. So this is where the problems occurred, such that when I export biblio records in tools, it stop in the problematic record. Remember the instance that I have to get the last biblio record I got during export and start to the next record (by +1 in biblionumber) and then it stops to a certain biblionumber, that was because of malformed/problematic biblio records. So when I deleted this records and re-run the zebra index and got no errors, I was able to export all of my records.
-- View this message in context: http://koha.1045719.n5.nabble.com/exporting-bibliographic-records-tp5753557p... 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
-- 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)
participants (3)
-
Bernardo Gonzalez Kriegel -
Elaine Bradtke -
schnydszch