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@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@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@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@lib.state.ia.us | (515) 725-0605
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@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>