[Evergreen-catalogers] Deleting Items from Copy Buckets

[Elizabeth Thomsen]

That's a helpful reminder, Mary, and I'll bet I'm not the only one saving
it for future reference!

-- 

Elizabeth Thomsen, Member Services Manager
NOBLE: North of Boston Library Exchange
26 Cherry Hill Drive
Danvers Massachusetts 01923
E-mail: et at noblenet.org

On Thu, July 19, 2012 9:16 pm, Mary Llewellyn wrote:
> Hi Sarah,
>
> I haven't heard of any of our libraries running into that, so thanks for
> the heads-up, but I wanted to suggest an option for restoring items if it
> should happen again. I don't know if you have access to the database and
> SQL, but you could scan the item barcodes into a list in a text file or
> csv file, and give them to your sys admin to "undelete" them. If they are
> still in the bucket, perhaps you can export them from Evergreen as a csv
> file.
>
> Nothing deleted really leaves the data table, it just has a flag for
> "deleted" being true or false, governing whether a bib or item can be
> seen.
>
> To change the flag, the query would be something like
>
> UPDATE asset.copy
> set deleted = 'f'
> where barcode in (3400988765,
> 34000987655,
> [etc.])
>
> Your list of barcodes goes in the parentheses, separated by commas, so
> that the query changes only those items.
>
> This is much less work than re-adding your accidental deletions.
>
> Mary
>
> Mary Llewellyn
> Database Manager
> Bibliomation
> Middlebury, CT
>
> Sent from my iPhone
>
> On Jul 19, 2012, at 6:21 PM, sarahc at zionsville.lib.in.us wrote:
>
>> Has anyone else had a run in with the Delete All from Catalog
>> button in Copy Buckets?
>>
>> If you click "Delete All from Catalog" in Copy Buckets, all the
>> items get deleted immediately. Poof. They're gone. You don't get
>> warning "Are you sure?" pop up like you do in Item Status or
>> Holdings Maintenance.  You don't even get an "Items have been
>> deleted" pop up afterward, so you could conceivably delete 100s of
>> items and not even notice.
>>
>> In my case it was only 18 items, and I had them on a cart right
>> next to me, so it was a bit of a hassle to re-add all the items,
>> but not a nightmare. However, I could see it being a much bigger
>> problem if it happened with a lot of more items, and/or if you
>> didn't get noticed when it occurred.
>>
>> From my perspective, that button serves no purpose anyway, since I
>> always mass delete from Item Status where I can delete volumes as
>> well as copies, but if it is useful to others, I'd at least like a
>> chance to back out if I ever accidentally click it again.
>>
>> I hadn't thought about it in a few months since I deleted those
>> items, but last week I was training staff how to use copy buckets
>> and they were freaked out by the button. Then, thanks to email
>> notification, it showed up in my inbox when the importance got
>> changed. https://bugs.launchpad.net/evergreen/+bug/969312
>>
>> It brought it on my radar again and made me wonder if any one else
>> has encountered this or is concerned about it?
>>
>>
>>
>> Sarah Childs
>> Senior Cataloger
>> Hussey-Mayfield Memorial Public Library
>> 250 North Fifth Street
>> Zionsville, IN 46077
>> 317-873-3149 x13330
>> sarahc at zionsville.lib.in.us
>>
>>
>> _______________________________________________
>> Evergreen-catalogers mailing list
>> Evergreen-catalogers at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
>
> _______________________________________________
> Evergreen-catalogers mailing list
> Evergreen-catalogers at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers
>