[Koha-devel] Please assist: auth values

[Joy Nelson]

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 at 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 at 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?