[Koha] Creating New local fields in 952 tags

[R Sunil Kumar]

Dear All, 

 

We like to create some local holding information for a library. We do not
want to modify and use already existing 952 tags (0-9 and a-z) as most of
the tags is already used. Can anybody suggest us how to create local fields
in Koha especially in MARC local holding 952 series?

 

Thanks and Regards 

 

R Sunil Kumar

Library Technologist

Ecole Solutions Pvt Ltd

Level 15  Concorde Towers  UB City  1 Vittal Mallya Road  

Bangalore 560001,India

Mobile: +91 9686576695  Fax: +91 80 40300400

eMail: sunil.ku...@ecoleglobal.com  Web: www.ecoleglobal.com

 

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Installation errors in log - Koha 3.6

[piko]

Dear All, while installing 3.6 standard version on Debian 6 (squeeze) I
notice many errors logging in koha-error-log (examples shown below). I can't
find out reasons. In earlier versions of Koha (3.2.9, 3.2.10) everything was
right. What is worse in 3.6 version I can't install my preferred language
(pl-PL) in any way: before starting webinstaller (what was also impossible
in earlier versions) as well as after installation (what succeeded in the
case of 3.2.9, 3.2.10). I noticed the 3.6 version works fine but only in
english mode, despite logged errors. Any help is welcome.

[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] Auth.pm: DBD::mysql::db selectrow_array 
failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] Auth.pm: DBD::mysql::db selectrow_array 
failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] Auth_with_cas.pm: DBD::mysql::db selectr
ow_array failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::st execute fail
ed: Table 'koha.auth_types' doesn't exist at /usr/share/koha/lib/C4/Koha.pm
line 336.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::st fetchrow_has
href failed: fetch() without execute() at /usr/share/koha/lib/C4/Koha.pm
line 337.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::db selectrow_ar
ray failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::db selectrow_ar
ray failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::db selectrow_ar
ray failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: Use of uninitialized value 
in split at /usr/share/koha/lib/C4/Templates.pm line 277.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::db selectrow_ar
ray failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: Use of uninitialized value 
in split at /usr/share/koha/lib/C4/Templates.pm line 292.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: Use of uninitialized value 
in split at /usr/share/koha/lib/C4/Templates.pm line 277.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: Use of uninitialized value 
in split at /usr/share/koha/lib/C4/Templates.pm line 292.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: DBD::mysql::db selectrow_ar
ray failed: Table 'koha.systempreferences' doesn't exist at
/usr/share/koha/lib/C4/Context.pm line 480.
[Wed Nov 23 13:44:37 2011] [error] [client 192.168.3.151] [Wed Nov 23
13:44:37 2011] mainpage.pl: Use of uninitialized value 
in string eq at /usr/share/koha/lib/C4/Templates.pm line 237.

Regards, Piotr

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Installation-errors-in-log-Koha-3-6-tp5016606p5016606.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Subject headings in CAPS - convert to "proper"

[Hartman, David W. - GBTS Library]

Hello all!

   My original imported data had all of the subject headings in CAPITAL LETTERS 
and all of my new headings are "proper" (first letter is capitalized and that's 
it).  I know in EXCEL there is a PROPER command that converts ALL CAPS to the 
proper 'All caps'.

  Is there a command in SQL to convert my all CAPS subject heading to proper?  
Or Koha?  Thanks in advance for any help!

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] how to restore deleted marc record/items

[tanzeem]

Hi

I want to restore some of the already deleted records
I am currently tinkering with the koha database tables-
deletedbiblio,deleteditms,deletedbiblioitems
Can anyone guide me in the currect path to do the restore properly

thanks in advance

--
View this message in context: 
http://koha.1045719.n5.nabble.com/how-to-restore-deleted-marc-record-items-tp5015705p5015705.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Reading history concerns and opinions

[David Schuster]

This is a library question on policy and just curious how others are
handling it.

Reading history can be maintained in Koha - I understand that, and as a
policy we protect individuals freedom to read what they want.

As a School district - we often get the request from teachers and parents
"I need a list of what Susie has read this semester"...  Currently we have
not been providing access to even the students so it is easy for us to say
"Sorry we don't keep that information"...  I know we could say "Sorry that
is private student information and I can't share it", Teachers could
probably be thwarted with that, but not so much Parents...

Then the whole "FBI" coming for reading history is another issue...  As we
build these features that allow "staring" and "if you read X you might
enjoy Y" or "people who read X also read Y" - what is our best avenue for
defending our clients reading history, yet making these features available
to them.

Just pondering...

-- 
David Schuster
Plano ISD
Library Technology Coordinator
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plea for help from Horowhenua Library Trust re: Koha

[Cary Gordon]

I don't think that is silly at all.

You should definitely contact the EFF, if you haven't already, and
also the Free Software Foundation . You might
also want to talk to the Software Freedom Law Center
. While they might not be able to
help you directly, they might be able to give you some advice and/or a
referral.

Thanks,

Cary

On Tue, Nov 22, 2011 at 5:42 PM, Jason Sherman  wrote:
> This may be a silly question, but have you considered contacting the
> Electronic Frontier Foundation to ask for assistance?
>
> https://www.eff.org/pages/legal-assistance
>
> 2011/11/21 Joann Ransom :
>> As I am sure most of you are aware, Horowhenua Library Trust is the birth
>> place of Koha and the longest serving member of the Koha community. Back in
>> 1999 when we were working on Koha, the idea that 12 years later we would be
>> having to write an email like this never crossed our minds. It is with
>> tremendous sadness that we must write this plea for help to you, the other
>> members of the Koha community.
>>
>> The situation we find ourselves in, is that after over a year of battling
>> against it, PTFS/Liblime have managed to have their application for a
>> Trademark on Koha in New Zealand accepted. We now have 3 months to object,
>> but to do so involves lawyers and money. We are a small semi rural Library
>> in New Zealand and have no cash spare in our operational budget to afford
>> this, but we do feel it is something we must fight.
>>
>> For the library that invented Koha to now have to have a legal battle to
>> prevent a US company trademarking the word in NZ seems bizarre, but it is at
>> this point that we find ourselves.
>>
>> So, we ask you, the users and developers of Koha, from the birth place of
>> Koha, please if you can help in anyway, let us know.
>>
>> Regards,
>>
>> Jo.
>>
>> --
>> Joann Ransom RLIANZA
>> Head of Libraries,
>> Horowhenua Library Trust.
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
>
>
> --
> Jason Sherman
> Systems Librarian
> University of Science and Arts of Oklahoma
> 405.574.1340
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Cary Gordon
The Cherry Hill Company
http://chillco.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plea for help from Horowhenua Library Trust re: Koha

[Jared Camins-Esakov]

Welcome to the community! One of the great things about the
community--possibly the greatest--is how supportive and welcoming it is.

Speaking as an American business owner, I hope that you do not take this as
indicative of the "American Way." As most of you probably know, I am in the
business of preserving cultural heritage, not co-opting it. About a year
ago I shared my feelings on the importance of openness and community, and I
still stand by what I said. Koha is a gift from Horowhenua Library Trust,
and I, for one, am very grateful for it. I am very sorry that not everyone
recognizes that, and that this absurd trademark application is an issue at
all.

Regards,
Jared
On Nov 22, 2011 9:56 PM, "Kathryn Tyree"  wrote:

> Hi Paul and all,
>
> In reply to Paul's mention of Catalyst below - yes Don Christie
> (Catalyst Director) is planning to contribute - we are keeping in touch
> with the wider Koha community and planning the best way to use our
> resources to help.
>
> I confess  I've been following your messages quietly without introducing
> myself so far :) I'm Kathryn, the fairly new Project Manager for the
> Koha team at Catalyst in NZ. This is my first post to this list.
>
> It's been awesome to read all your messages over the past day.
>
> Kathryn
>
> >
> > == point 3 ==
> > I'm sure Catalyst have lawyers and Don will throw his hat in the game.
> > In fact, Catalyst is probably the first one that could/would be annoyed
> > by this trademark...
> >
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha routing list or routing slip question

[Hartman, David W. - GBTS Library]

Hello!

  I am using the serials module for Koha and was wondering how to change the 
default wording "Please return this item" for the note on the routing slip. 
 It currently reads:

"Notes: Please return this item promptly as others are waiting for it."

Is there a way to remove this?  I can add to this note but this phrase "Please 
return this item.." seems to be hardcoded and unable to edit/remove. I'd 
like to remove that wording.
David W. Hartman
Global Business Technology Strategy Library
Team Disney 336N
407 828 4250 (8-222)
FAX 407 828 4868

FOLLOW MY RESEARCH on Backlot  &   
Yammer!
Learn about our research partners in the 2011 IT Research Competency Center 

GBTS CAST can click to request AV 
Equipment, 
Books,  & 
Research
WATCH the GBTS Library (Video) Update !
CLICK for the GBTS VIRTUAL LIBRARYportal 
site!!
"This communication is confidential, intended only for the named recipients 
above and may contain trade secrets or other information that is exempt from 
disclosure under applicable law. Any use, dissemination, distribution or 
copying of this communication by anyone other than the named recipients is 
strictly prohibited. If you have received this communication in error, please 
immediately notify us by calling (407) 828-4250. Thank you."
[cid:image001.gif@01CCA9EE.3BC441D0]Please consider your environmental 
responsibility before printing this e-mail [cid:image001.gif@01CCA9EE.3BC441D0]
Think Environmentality!  Reduce!  Reuse!  Recycle!


<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha routing list or routing slip question

[Owen Leonard]

> Is there a way to remove this?  I can add to this note but this phrase 
> “Please return this
> item……” seems to be hardcoded and unable to edit/remove.

It is indeed hard-coded in the template. At this point your only
option may be to edit the template. An idea for future development
would be to bring this slip into the work being done on Bug 7001:

User Configurable Slips
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7001

  -- Owen

--
Web Developer
Athens County Public Libraries
http://www.myacpl.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plea for help from Horowhenua Library Trust re: Koha

[Buster]

2011/11/22 Lori Bowen Ayre 

> There has already been plenty of outrage expressed by the Koha community
> and clearly it hasn't made a difference.
>

Oh, I don't know about that. We investigated Koha and Evergreen for a year
and recently decided to go with community Koha using ByWater Solutions as a
vendor rather than LibLime largely because of LibLime's position within (or
rather, without) the community. That, and the fact its product has
basically become a proprietary system with all the weaknesses and pitfalls
of such systems. While investigating, we did visit a couple of LibLime
clients who are jumping ship as soon as they are legally able, for many of
the same reasons we eschewed it from the git-go.

So, I think it has, in fact, made a difference. People who care do pay
attention.

--Jim Maroon

-- 

==
"The man, who, by his own and his family's labour, can provide a
sufficiency of food and raiment and a comfortable dwelling place, is not a
poor man." --William Cobbett, *Cottage Economy*, 1826.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha routing list or routing slip question

[Hartman, David W. - GBTS Library]

Hello!

  I am using the serials module for Koha and was wondering how to change the 
default wording "Please return this item" for the note on the routing slip. 
 It currently reads:

"Notes: Please return this item promptly as others are waiting for it."

Is there a way to remove this?  I can add to this note but this phrase "Please 
return this item.." seems to be hardcoded and unable to edit/remove. I'd 
like to remove that wording.
David W. Hartman
Global Business Technology Strategy Library
Team Disney 336N
407 828 4250 (8-222)
FAX 407 828 4868

FOLLOW MY RESEARCH on Backlot  &   
Yammer!
Learn about our research partners in the 2011 IT Research Competency Center 

GBTS CAST can click to request AV 
Equipment, 
Books,  & 
Research
WATCH the GBTS Library (Video) Update !
CLICK for the GBTS VIRTUAL LIBRARYportal 
site!!
"This communication is confidential, intended only for the named recipients 
above and may contain trade secrets or other information that is exempt from 
disclosure under applicable law. Any use, dissemination, distribution or 
copying of this communication by anyone other than the named recipients is 
strictly prohibited. If you have received this communication in error, please 
immediately notify us by calling (407) 828-4250. Thank you."
[cid:image001.gif@01CCA9EE.3BC441D0]Please consider your environmental 
responsibility before printing this e-mail [cid:image001.gif@01CCA9EE.3BC441D0]
Think Environmentality!  Reduce!  Reuse!  Recycle!


<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plea for help from Horowhenua Library Trust re: Koha

[Chris Cormack]

2011/11/24 Buster 

>
>
> 2011/11/22 Lori Bowen Ayre 
>
>> There has already been plenty of outrage expressed by the Koha community
>> and clearly it hasn't made a difference.
>>
>
> Oh, I don't know about that. We investigated Koha and Evergreen for a year
> and recently decided to go with community Koha using ByWater Solutions as a
> vendor rather than LibLime largely because of LibLime's position within (or
> rather, without) the community. That, and the fact its product has
> basically become a proprietary system with all the weaknesses and pitfalls
> of such systems. While investigating, we did visit a couple of LibLime
> clients who are jumping ship as soon as they are legally able, for many of
> the same reasons we eschewed it from the git-go.
>
> So, I think it has, in fact, made a difference. People who care do pay
> attention.
>
> Some very interesting news.


http://diligentroom.wordpress.com/2011/11/22/the-exemplar-of-stupid-koha-vs-liblime-trademark/#comment-1761

>From Liblime:
"Here’s PTFS/LibLime’s press release about the matter:
http://www.liblime.com/ptfsliblime-granted-provisional-use-of-koha-trademark-in-new-zealand

The TL;DR is: this was inherited—by surprise—from the previous owners. We
don’t know their intentions then, but we know ours now. We’ll hand the NZ
trademark off to a non-profit (including HLT) who agrees to continue our
practice of protecting non-exclusive use of the name."

Which sounds great to me, HLT makes that promise (as they are the community
elected body to hold community property and a registered non profit Trust)
and PTFS/Liblime can sign over the application. This could all be resolved
in a couple of days time.

I really hope this is true and the application is signed over to HLT as
soon as possible so we can put this all behind us.

Chris
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Address or location on Koha routing list

[Hartman, David W. - GBTS Library]

Hello!

  I am using the Koha serials module and was wondering if there was any way to 
add a location or address next to the patron name?  I'd love to be able to put 
a floor number/location next to it, if possible.

  As always, thanks to you all!!!
David W. Hartman
Global Business Technology Strategy Library
Team Disney 336N
407 828 4250 (8-222)
FAX 407 828 4868

FOLLOW MY RESEARCH on Backlot  &   
Yammer!
Learn about our research partners in the 2011 IT Research Competency Center 

GBTS CAST can click to request AV 
Equipment, 
Books,  & 
Research
WATCH the GBTS Library (Video) Update !
CLICK for the GBTS VIRTUAL LIBRARYportal 
site!!
"This communication is confidential, intended only for the named recipients 
above and may contain trade secrets or other information that is exempt from 
disclosure under applicable law. Any use, dissemination, distribution or 
copying of this communication by anyone other than the named recipients is 
strictly prohibited. If you have received this communication in error, please 
immediately notify us by calling (407) 828-4250. Thank you."
[cid:image001.gif@01CCA9EE.3BC441D0]Please consider your environmental 
responsibility before printing this e-mail [cid:image001.gif@01CCA9EE.3BC441D0]
Think Environmentality!  Reduce!  Reuse!  Recycle!


<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Subject headings in CAPS - convert to "proper"

[Robin Sheat]

Hartman, David W. - GBTS Library schreef op wo 23-11-2011 om 10:07
[-0500]:
>   Is there a command in SQL to convert my all CAPS subject heading to
> proper?  Or Koha?  Thanks in advance for any help!

There is 'lower' and 'upper', but I'm not aware of anything in MySQL
which does the equivalent of 'proper'.

Also, I think the subjects are in MARC rather than a database table, in
which case it'd be hard to do from plain sql anyway. It might be
necessary to write a small perl script to do it.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D


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