Another possibility might be to run a report of biblios/biblionumbers without items attached: SELECT biblio.biblionumber, biblio.title FROM biblio WHERE biblionumber NOT IN (SELECT biblionumber FROM items) In our case I have to take out the e-books that have links, not barcodes, but it's still good for tracking down books with problems I need to check on. Fred King Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 I refuse to answer that question on the grounds that I don't know the answer. --Douglas Adams -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Scott Owen Sent: Thursday, September 29, 2016 12:18 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] MRC file import for the second time Hi Gunilla, I did find some info regarding this.... I pulled up "tools" then logs, under modules i selected "catalog" (with "all" actions selected) and then ran the report for the suspected date range.... what I found was some modifications of approx 70 items.... they all had an "info" section something like : Catalog Modify Item 12718 item $VAR1 = { 'biblioitemnumber' => '3514', 'holdingbranch' => 'PINE', 'reserves' => undef, 'itemnotes' => undef, 'uri' => undef, 'itype' => 'BK', 'price' => '17.51', 'renewals' => undef, 'stocknumber' => undef, 'dateaccessioned' => '2016-09-26', 'itemcallnumber' => 'KIB', 'itemnotes_nonpublic' => undef, 'cn_sort' => 'KIB', 'materials' => undef, 'location' => 'FIC', 'biblionumber' => '3514', 'ccode' => 'FIC', 'copynumber' => '3', 'more_subfields_xml' => undef, 'stack' => undef, 'datelastseen' => '2016-09-26', 'booksellerid' => undef, 'withdrawn_on' => undef, 'items.cn_sort' => 'KIB', 'itemlost_on' => undef, 'notforloan' => '0', 'replacementprice' => undef, 'homebranch' => 'PINE', 'onloan' => undef, 'issues' => undef, 'itemlost' => '0', 'damaged' => '0', 'restricted' => undef, 'paidfor' => undef, 'cn_source' => 'ddc', 'barcode' => '75082', 'enumchron' => undef, 'permanent_location' => 'FIC', 'itemnumber' => '12718', 'datelastborrowed' => undef, 'coded_location_qualifier' => undef, 'withdrawn' => '0', 'replacementpricedate' => '2016-09-26' }; I haven't had a chance to check every one of the barcodes...but I'm guessing that these may be my "missing" items....if so...that makes life much easier...at least I know what titles / barcodes are "missing" ...then I just need to fix them. On Tue, Sep 27, 2016 at 4:26 PM, Gunilla Jensen <Gunilla.Jensen@niwa.co.nz> wrote:
Hi Scott
Here at the NIWA library we've also had some strange things happening with the barcodes. For two of our journal records, barcodes have disappeared and we don't know why. The bibliographic record and all other item details remain, but the barcodes are gone. We are three staff members and none of us would batch delete barcodes by mistake. The missing barcodes for the National Business Review are most strange because two of the recent issues are on loan, so they will have had barcodes when checked in and issued, and the barcode will then have been deleted afterwards. I'm not sure if our problem is the same as yours or if ours is linked to the MARC import, but I would be very interested in hearing more of what you find.
Kind regards, Gunilla
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Scott Owen Sent: Wednesday, 28 September 2016 5:46 a.m. To: koha <koha@lists.katipo.co.nz> Subject: [Koha] MRC file import for the second time
Hi all,
It seems that one of my people has somehow managed to remove a number of books (items) from our collection.
We now have a pile of books in which the barcode does not show up in any type of catalog search. The marc record for the item is still in the system, but the item seems to have been removed
I have preformed an SQL export of the entire collection, and the barcodes don't show up there either.....
It seems to be pretty random, and I am not seeing any type of pattern... I have no idea what the person using the system did..... (my best guess is that they somehow messed up a MRC record stage / import...)
However.....luckily, this was a system upgrade that is only a few weeks old, so I have a MRC file that includes the entire collection (including the missing items / barcodes). They have only added a few items to the collection, so they should be able to (fairly) easily add those items back in....
My thoughts are to go into "staged marc record mgmt." and remove the initial MARC import.....the *should* remove every item from the collection....
Then... import the MRC file that includes the entire collection..... (including the missing items) back into the system.
Unless there is a better way ??
Thank you,
-Scott Owen _______________________________________________ Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DQIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=G1Jk1sFSM3qOML2skLsh7k6k278lO5oG8X31C-Pwzus&s=flLgW99xzzA5IPbuUGXyWoZT0dZA-nessjqUAFBCf2k&e= Koha@lists.katipo.co.nz https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DQIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=G1Jk1sFSM3qOML2skLsh7k6k278lO5oG8X31C-Pwzus&s=HgtmtwRO8i6TdTfXdqCvsH-MqjWRHw9CODwVacZyvtI&e=
_______________________________________________ Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DQIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=G1Jk1sFSM3qOML2skLsh7k6k278lO5oG8X31C-Pwzus&s=flLgW99xzzA5IPbuUGXyWoZT0dZA-nessjqUAFBCf2k&e= Koha@lists.katipo.co.nz https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DQIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=G1Jk1sFSM3qOML2skLsh7k6k278lO5oG8X31C-Pwzus&s=HgtmtwRO8i6TdTfXdqCvsH-MqjWRHw9CODwVacZyvtI&e= ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.