[Evergreen-catalogers] Deleting Items from Copy Buckets

[sarahc at zionsville.lib.in.us]

Hi Mary,
Thanks for the suggestion. I don't personally have access, but if
it had been a very large group of items, I probably would have
filed a helpdesk ticket to have this done. We're such a large
consortium, that for just a few items the IT staff doesn't really
have time to handle this kind of thing.


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


> 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
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>