[Koha] MRC file import for the second time

Fri Sep 30 06:46:02 NZDT 2016

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 at 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 at lists.katipo.co.nz] On Behalf Of Scott Owen
Sent: Thursday, September 29, 2016 12:18 PM
To: koha at 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 at 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 at lists.katipo.co.nz] On Behalf Of Scott
> Owen
> Sent: Wednesday, 28 September 2016 5:46 a.m.
> To: koha <koha at 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 at 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 at 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.