Re: [Koha] Display question

2015-11-01 Thread Robin Sheat 
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


signature.asc
Description: This is a digitally signed message part
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Display question

2015-10-30 Thread schnydszch 
How about for authorities? Are deleted authorities saved elsewhere? Or we can
do the same with authorities by setting matching rules. Will the new import
get the authid and controlfield '001' of the currently imported record? I'm
interested with this. Thanks!



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Display-question-tp5859291p5859352.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Display question

2015-10-29 Thread Tim Skeers 

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.ske...@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

Re: [Koha] Display question

2015-10-29 Thread Chris Cormack 
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  
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.ske...@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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Display question

2015-10-29 Thread Steve Sowder 

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 SowderSystems Librarian
sow...@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
 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.ske...@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

Re: [Koha] Display question

2015-10-29 Thread 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 SowderSystems Librarian
sow...@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  
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.ske...@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

Re: [Koha] Display question

2015-10-29 Thread Hernandez, Heather 
Hi, Tim--

It's not the normal view of the staff client, but a couple of times I
really wanted a printout of a record with everything, including the
biblionumber (for later overlaying from OCLC), so I printed the MARC view
from the public OPAC--it gives me the MARC record (with the record no.
prominently) and the item(s), too.

Hope this helps!
--h2
~~
Heather Hernandez
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
415-561-7032, heather_hernan...@nps.gov
http://www.nps.gov/safr/learn/historyculture/museum-collections.htm

"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Display question

2015-10-29 Thread Barton Chittenden 
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.
On Oct 29, 2015 3:41 PM, "Steve Sowder"  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 SowderSystems Librarian
>>> sow...@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
  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.ske...@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