[Evergreen-catalogers] Deleting Items from Copy Buckets

[Mary Llewellyn]

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