Please assist: auth values
Please can one of you assist? We are in the middle of shelving several hundred boxes of books, and seven volunteer cataloguers have spent the day editing items to change the auth value "loc" from "box_xyz" to the proper shelf/stack. At the end of the day, an enthusiastic volunteer instead of deleting an empty box from the "loc" values, accidentally deleted our "rare book room" (my fault, I gave him superlibrarian credentials instead of doing the job myself.) A search still finds: "628 result(s) found for 'mc-loc=2fl_rare' in NMA Catalog" but this is (I think) coming from somewhere other than items.location. An sql query [SELECT * FROM authorised_values WHERE category='loc'] still finds the auth value: ... 1834 loc fl2_rare 2nd floor rare 2nd floor rare ... so I can't "re-enter" the auth value which is no longer available for admin editing; so "editing" these 628 items is impossible. The OPAC is no longer showing the location at all. The "catastrophe level" is that even if I revert to last nights backup, the volunteers tell me they have no way to pull them all (about 3,000 books) out and start over again. Can anyone, pretty please, suggest a course of action? Many thanks -- Paul
Golly Paul! When you say that the volunteer deleted a loc value of rare book room, are you referring to the authorised value of rare book room? If so, then you should be able to simply re-add a location of rare book room to the authorised value list and be ok. When an authorised value is deleted, it does not delete the data in the items table (items.location) I'm not sure what you mean when you say "so I can't "re-enter" the auth value which is no longer available for admin editing" This is not been my experience with the authorised_values list. Are you finding data on a query like this? select barcode from items where location =<enter the code you used for rarebooks> or select distinct(location) from items -which will show you all the location values in use in the database. -joy On Wed, Feb 19, 2014 at 5:21 PM, Paul A <paul.a@navalmarinearchive.com> wrote:
Please can one of you assist?
We are in the middle of shelving several hundred boxes of books, and seven volunteer cataloguers have spent the day editing items to change the auth value "loc" from "box_xyz" to the proper shelf/stack.
At the end of the day, an enthusiastic volunteer instead of deleting an empty box from the "loc" values, accidentally deleted our "rare book room" (my fault, I gave him superlibrarian credentials instead of doing the job myself.)
A search still finds: "628 result(s) found for 'mc-loc=2fl_rare' in NMA Catalog" but this is (I think) coming from somewhere other than items.location.
An sql query [SELECT * FROM authorised_values WHERE category='loc'] still finds the auth value: ... 1834 loc fl2_rare 2nd floor rare 2nd floor rare ... so I can't "re-enter" the auth value which is no longer available for admin editing; so "editing" these 628 items is impossible. The OPAC is no longer showing the location at all.
The "catastrophe level" is that even if I revert to last nights backup, the volunteers tell me they have no way to pull them all (about 3,000 books) out and start over again.
Can anyone, pretty please, suggest a course of action?
Many thanks -- Paul
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Joy Nelson Director of Migrations ByWater Solutions Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha?
Paul A schreef op wo 19-02-2014 om 18:21 [-0500]:
At the end of the day, an enthusiastic volunteer instead of deleting an empty box from the "loc" values, accidentally deleted our "rare book room" (my fault, I gave him superlibrarian credentials instead of doing the job myself.)
Can you clarify? Because if I understand you right, this isn't a big problem. You had a loc authorised value corresponding to a box, and that was to be deleted, but instead the authorised value corresponding to a room was deleted? The link to the authorised value is stored in the "location" field in the items table. All that deleting the authorised value will do will cause those items to show with the code rather than the full name. The one thing that's confusing me is why you can see the authorised value still in the table. It's either there or not there, it shouldn't be in the table but not visible in the user interface. Can you explain the actual symptoms of what you're seeing, that might help. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (3)
-
Joy Nelson -
Paul A -
Robin Sheat