[Koha] Display question

[Paul A]

At 04:29 PM 10/29/2015 -0400, Barton Chittenden wrote:
>Off hand, I would say that you would run into errors if and when you
>deleted the bib record a second time... Koha will want to copy the data
>from biblio to deleted_biblio then remove the bib record, but it will get a
>referential integrity check if it tries. My guess is that you would have to
>remove the record via the database.

I seem to remember (but can't easily find my notes -- previous sandbox, 
can't remember which version) that it just overwrites.

But this brings up the question "how to restore a deleted biblio?" It's 
been mentioned a couple of times on this list, with people trying to use 
MySQL INSERT statements and failing without using MarcEdit as an intermediary.

Is there any simple way to restore one? If not, why do we save them? Our 
experience is that we delete duplicates (which occasionally happen despite 
Koha trying to warn cataloguers), and twice in the last five years I've 
just wiped them from the db to save space in the back-up dumps.

Best -- Paul

>On Oct 29, 2015 3:41 PM, "Steve Sowder" <sowder at andrews.edu> wrote:
>
> > What kind of problems?
> >
> > Steve
> >
> > On 10/29/2015 3:23 PM, Katrin Fischer wrote:
> >
> >> The biblionumber is the unique database assigned key for Koha, but as
> >> Chris has pointed out it is useless in another context and outside of
> >> Koha.
> >>
> >> I'd argue that reusing a deleted biblionumber like how you described
> >> sounds like a bug - it should not be possible to do that. One of the
> >> reasons being that then you'd have the same biblionumber in biblio and
> >> deletedbiblio and that would create problems.
> >>
> >> Katrin
> >>
> >> Am 29.10.2015 um 19:52 schrieb Steve:
> >>
> >>> The biblionumber can be used to match on if reloading records. I have
> >>> exported MARC records, made some mass changes, and then reloaded the
> >>> changed records by matching on the biblionumber. (Match points 10, if
> >>> points > 5 then go.) Worked well.
> >>>
> >>> I have even loaded new records by assigning a biblionumber that I know
> >>> had been deleted in Koha.
> >>> They loaded fine and assumed the biblionumber that I assigned.
> >>>
> >>>
> >>> Steve Sowder                            Systems Librarian
> >>> sowder at andrews.edu          Andrews University
> >>>
> >>>
> >>> On 10/29/2015 2:15 PM, Chris Cormack wrote:
> >>>
> >>>> Hi Tim
> >>>>
> >>>> You could edit either the .tt file or make a custom XSLT file to do
> >>>> that.
> >>>>
> >>>> But please do not make the mistake that was made with MARC and give a
> >>>> machine used value any human significance. The biblionumber is the
> >>>> primary key on a database row to allow Koha to identify a biblio.
> >>>> It should not be given any human significance, accession numbers,
> >>>> control numbers etc play that role for humans.
> >>>>
> >>>> Hope this helps
> >>>>
> >>>> Chris
> >>>>
> >>>>
> >>>>
> >>>> On 30 October 2015 7:05:55 am NZDT, Tim Skeers
> >>>> <tim.skeers at lib.state.ia.us> wrote:
> >>>>
> >>>>> Is there an easy way to get the biblionumber of a record to display
> >>>>> somewhere on the "normal" view for a record in the staff interface? Or
> >>>>> would it require an actual programming change?
> >>>>>
> >>>>> As it is, it displays in the URL in the browser navigation window, but
> >>>>> I would like to be able to print out a record with it showing on the
> >>>>> printout.
> >>>>>
> >>>>> Thanks,
> >>>>>
> >>>>> Tim
> >>>>>
> >>>>>
> >>>>> Timothy Skeers | Cataloger | Iowa Library Services/State Library of
> >>>>> Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 |
> >>>>> tim.skeers at lib.state.ia.us | (515) 725-0605
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> _______________________________________________
> >>>>> Koha mailing list  http://koha-community.org
> >>>>> Koha at lists.katipo.co.nz
> >>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>>>>
> >>>> _______________________________________________
> >>> Koha mailing list  http://koha-community.org
> >>> Koha at lists.katipo.co.nz
> >>> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>>
> >> _______________________________________________
> >> Koha mailing list  http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >>
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>