Re: [Koha] Display question
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>
Paul A schreef op do 29-10-2015 om 18:10 [-0400]:
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.
It's easy. The simple but risky way is: insert into biblio (select * from deletedbiblio where biblionumber=2); insert into biblioitems (select * from deletedbiblioitems where biblionumber=2); delete from deletedbiblioitems where biblionumber=2; delete from deletedbiblio where biblionumber=2; This presupposes that the columns are identical in order between biblio(items) and deletedbiblio(items), which should be true but may not be. The better way is something like: insert into biblio (biblionumber, frameworkcode, author, ...) select biblionumber, frameworkcode, author, ... from deletedbiblio where biblionumber=2; filling out all the fields, and obviously '2' is the example biblionumber I'm using. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (2)
-
Paul A -
Robin Sheat