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 [email protected] 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:[email protected]] On Behalf Of Scott Owen Sent: Thursday, September 29, 2016 12:18 PM To: [email protected] 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 <[email protected]> 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:[email protected]] On Behalf Of Scott > Owen > Sent: Wednesday, 28 September 2016 5:46 a.m. > To: koha <[email protected]> > 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= > [email protected] > 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= [email protected] 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. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
