- Koha - lists.katipo.co.nz

MRC file import for the second time
by Scott Owen 27 Sep '16

27 Sep '16

Hi all, It seems that one of my people has somehow managed to remove a number of books (items) from our collection. We now have a pile of books in which the barcode does not show up in any type of catalog search. The marc record for the item is still in the system, but the item seems to have been removed I have preformed an SQL export of the entire collection, and the barcodes don't show up there either..... It seems to be pretty random, and I am not seeing any type of pattern... I have no idea what the person using the system did..... (my best guess is that they somehow messed up a MRC record stage / import...) However.....luckily, this was a system upgrade that is only a few weeks old, so I have a MRC file that includes the entire collection (including the missing items / barcodes). They have only added a few items to the collection, so they should be able to (fairly) easily add those items back in.... My thoughts are to go into "staged marc record mgmt." and remove the initial MARC import.....the *should* remove every item from the collection.... Then... import the MRC file that includes the entire collection..... (including the missing items) back into the system. Unless there is a better way ?? Thank you, -Scott Owen

1 0

Best way to get to Hotel Paradis from Marseilles airport
by Joann Ransom 27 Sep '16

27 Sep '16

Hi all, Can anyone give advice on the best way to get to the Hotel Paradis from the airport on Sunday night before hackfest? Cheers Jo. Sent from Mail for Windows 10

3 2

Software error in memberentry.pl (Administrateur)
by Md. Mubassir Ahsan 27 Sep '16

27 Sep '16

I had this error. But after migrating to 16.05.04 it is gone. So my advise is to migrate immediately. On Tue, Sep 27, 2016 at 2:05 AM <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Software error in memberentry.pl (Administrateur) > 2. Koha Staff page Arabic Interface Change Issue > (Farasat Shafi ullah) > 3. Software error (vinod kumar) > 4. Re: Software error in memberentry.pl (Michał Dudzik) > 5. Re: Error thrown when updating items (andresdelosreyes) > 6. sql Query solved! (Martin House) > 7. Superscript? (Elaine Bradtke) > 8. Re: Superscript? (Chris Cormack) > 9. Re: Koha Staff page Arabic Interface Change Issue (Katrin Fischer) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 26 Sep 2016 12:12:58 +0200 > From: Administrateur <admin(a)ibnogent.org> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Software error in memberentry.pl > Message-ID: <57E8F4AA.30500(a)ibnogent.org> > Content-Type: text/plain; charset=utf-8 > > Hello, > > When I'm logged as a standard user and access to the > /cgi-bin/koha/opac-memberentry.pl > I have a software error : > > Global symbol "$borrower" requires explicit package name at > /usr/share/koha/opac/cgi-bin/opac/opac-memberentry.pl line 190. > Execution of /usr/share/koha/opac/cgi-bin/opac/opac-memberentry.pl > aborted due to compilation errors. > > The concerned line : > # Send back the data to the template > %borrower = ( %$borrower, %borrower ); > > I'm not familiar with perl so I don't really know what to do. > > The problem doesn't appear when I log as the administrator and try to > modify user information with this command : > > /cgi-bin/koha/members/ > memberentry.pl?op=modify&destination=circ&borrowernumber=...&categorycode=. > .. > (but it isn't the same script so I guess that's why) > > I use the latest Koha package from the apt. > > The thing is that all my members are imported from a CSV file. I thought > it could be a problem but I have the same error even when I create a new > patron from scratch. > > I use debian 8 stable all packages up to date. > > Thanks. > > -- > > Fraternellement. > > Joël M. > Administrateur Réseaux/Système. > Institut Biblique de Nogent-sur-marne. > > > ------------------------------ > > Message: 2 > Date: Mon, 26 Sep 2016 15:41:58 +0300 > From: Farasat Shafi ullah <farasat.shafi(a)gmail.com> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Koha Staff page Arabic Interface Change Issue > Message-ID: > < > CAJQkM7LOJQ09MksHNSWLgVjpU+MSt2RD+a+-exdfbo3YPds1Zg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Dear Community Members > > Hi, > > > One of our friend installed Koha 3.16x on ubuntu LTS and enabled Arabic > Language. now when he logged as staff and go to cataloging, all fields > headers are not showing up in Arabic. If you point cursor on Tag title then > it shows in Arabic ? > Any help in this regard that when language is switched all menu's and their > titles changed in that language > > > > -- > > *Regards* > > *----------------------------------* > > *Farasat Shafi ULLAH* *|Director University Central Library* > > MS(UK), CKM(USA), AMC-UIUC (USA) > > Office CISCO # (00966333)32819, (00966)548241733 > > Post Box. No. 1982, University of Dammam, KSA > e-mail: fsullah(a)uod.edu.sa <fsullah(a)ud.edu.sa>, http://library.uod.edu.sa > <http://library.ud.edu.sa/>, > > > ------------------------------ > > Message: 3 > Date: Mon, 26 Sep 2016 18:51:31 +0530 > From: vinod kumar <vinod.kumar.trf(a)gmail.com> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Software error > Message-ID: > <CALkr8= > Kymu5khnRruOVPyMX0YazkzeKOccwoA-uNqKDAoViC6w(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Dear Koha Team, > > > I have installed Koha based on tar file. It is working fine, with version > 16.06 > > Now, I want to migrate it to Git based server which has Koha version > 16.06.23 > > When I do the migrate the old DB (of the tar based installation) to the Git > based installation, and create the Patrons, I do not see the categories of > the Patrons and I get the following error : " Can't call method > "get_expiry_date" on an undefined value at > /var/koha_all/aimt/intranet/cgi-bin/members/memberentry.pl line 375. " > > On the other hand, if I take a Git based Koha (older version) to the Git > based new server, everything works fine. > > I am surely missing something. Can anyone help in resolving the issue. > > > ------------------------------ > > Message: 4 > Date: Mon, 26 Sep 2016 05:15:19 -0700 (MST) > From: Michał Dudzik <dudzikmichal(a)wp.pl> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Software error in memberentry.pl > Message-ID: <1474892119360-5904893.post(a)n5.nabble.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, look bug > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16996 > > Regards > Michał Dudzik > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Software-error-in-memberentry-pl-tp590488… > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 5 > Date: Mon, 26 Sep 2016 10:05:43 -0700 (MST) > From: andresdelosreyes <andres.delosreyes(a)ucuenca.edu.ec> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Error thrown when updating items > Message-ID: <1474909543628-5904912.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I am having the same problem and YES I did edit my marc framework, how > could > this be the cause of this problem? > > Thanks in advanced > > Andres > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Error-thrown-when-updating-items-tp588633… > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 6 > Date: Mon, 26 Sep 2016 15:28:40 -0400 > From: Martin House <martin.house(a)gmail.com> > To: KOHA <koha(a)lists.katipo.co.nz> > Subject: [Koha] sql Query solved! > Message-ID: > <CAHJvf= > 2GCChuVbdr03amzqDFwis0T3a0QTTRSstjJ-u_LmXfGQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > I posted a question that I think has not been posted to the list yet, as it > is awaiting moderator approval. That said, in case it is posted, I wanted > to share my solution. > > Question: How to list all students and their matching teachers? > Problem: Table(borrowers) has patron info, Table(borrower_attribute) has > teacher name and column code "Teacher." > > I solved the problem by using mysqlWorkbench and running the following sql > query: > > SELECT * > FROM `koha_library`.`borrower_attributes`, `koha_library`.`borrowers` > WHERE `borrowers`.`borrowernumber`= `borrower_attributes`.`borrowernumber` > > > > Martin House > martin.house(a)gmail.com > www.martindhouse.com > 704-996-0297 > "An unexamined life is not worth living." > > > ------------------------------ > > Message: 7 > Date: Mon, 26 Sep 2016 20:38:11 +0100 > From: Elaine Bradtke <eb(a)efdss.org> > To: koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Superscript? > Message-ID: > <CAPdfUuxk+01+VRSX544qArc4Ag+Tmxy4LW_9qbws4= > CC53pwVw(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > One of my colleagues has asked if it's possible to type a superscript in > Koha > > "Otherwise, essay2 (a record label) becomes essay2." > > I have tried a number of variations of holding down and pressing keys in > the cataloguing mode in Koha but haven't successfully managed to do > anything useful. Creating the text in a text editor and copying and > pasting didn't work either > > It may be complicated by the fact that I'm running Windows on an emulator > on my Mac. . . > The rest of the staff uses fairly recent Windows if that makes any > difference. > > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > > ------------------------------ > > Message: 8 > Date: Tue, 27 Sep 2016 08:44:07 +1300 > From: Chris Cormack <chrisc(a)catalyst.net.nz> > To: Elaine Bradtke <eb(a)efdss.org> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Superscript? > Message-ID: > <20160926194407.y3mqiqzzpuzwzzkn(a)rorohiko.wgtn.cat-it.co.nz> > Content-Type: text/plain; charset="utf-8" > > * Elaine Bradtke (eb(a)efdss.org) wrote: > > One of my colleagues has asked if it's possible to type a superscript in > > Koha > > > > "Otherwise, essay2 (a record label) becomes essay2." > > Yes it is, > > As long as it is a utf8 character. > > http://demo.mykoha.co.nz/cgi-bin/koha/opac-detail.pl?biblionumber=30727 > > (This record will disapear at 6am tomorrow NZ time (in 22 hours or so) but > you > can take a look before then > > Chris > > > > > > I have tried a number of variations of holding down and pressing keys in > > the cataloguing mode in Koha but haven't successfully managed to do > > anything useful. Creating the text in a text editor and copying and > > pasting didn't work either > > > > It may be complicated by the fact that I'm running Windows on an > emulator > > on my Mac. . . > > The rest of the staff uses fairly recent Windows if that makes any > > difference. > > > > -- > > Elaine Bradtke > > Data Wrangler > > VWML > > English Folk Dance and Song Society | http://www.efdss.org > > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance > and > > Song Society in London, England. If you wish to phone me personally, send > > an e-mail first. I work off site) > > > -------------------------------------------------------------------------- > > Registered Company No. 297142 > > Charity Registered in England and Wales No. 305999 > > > --------------------------------------------------------------------------- > > "Writing about music is like dancing about architecture" > > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Chris Cormack > Catalyst IT Ltd. > +64 4 803 2238 > PO Box 11-053, Manners St, Wellington 6142, New Zealand >

1 0

Superscript?
by Elaine Bradtke 27 Sep '16

27 Sep '16

One of my colleagues has asked if it's possible to type a superscript in Koha "Otherwise, essay2 (a record label) becomes essay2." I have tried a number of variations of holding down and pressing keys in the cataloguing mode in Koha but haven't successfully managed to do anything useful. Creating the text in a text editor and copying and pasting didn't work either It may be complicated by the fact that I'm running Windows on an emulator on my Mac. . . The rest of the staff uses fairly recent Windows if that makes any difference. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

3 4

Software error
by vinod kumar 26 Sep '16

26 Sep '16

Dear Koha Team, I have installed Koha based on tar file. It is working fine, with version 16.06 Now, I want to migrate it to Git based server which has Koha version 16.06.23 When I do the migrate the old DB (of the tar based installation) to the Git based installation, and create the Patrons, I do not see the categories of the Patrons and I get the following error : " Can't call method "get_expiry_date" on an undefined value at /var/koha_all/aimt/intranet/cgi-bin/members/memberentry.pl line 375. " On the other hand, if I take a Git based Koha (older version) to the Git based new server, everything works fine. I am surely missing something. Can anyone help in resolving the issue.

2 1

Koha Staff page Arabic Interface Change Issue
by Farasat Shafi ullah 26 Sep '16

26 Sep '16

Dear Community Members Hi, One of our friend installed Koha 3.16x on ubuntu LTS and enabled Arabic Language. now when he logged as staff and go to cataloging, all fields headers are not showing up in Arabic. If you point cursor on Tag title then it shows in Arabic ? Any help in this regard that when language is switched all menu's and their titles changed in that language -- *Regards* *----------------------------------* *Farasat Shafi ULLAH* *|Director University Central Library* MS(UK), CKM(USA), AMC-UIUC (USA) Office CISCO # (00966333)32819, (00966)548241733 Post Box. No. 1982, University of Dammam, KSA e-mail: fsullah(a)uod.edu.sa <fsullah(a)ud.edu.sa>, http://library.uod.edu.sa <http://library.ud.edu.sa/>,

2 1

sql Query solved!
by Martin House 26 Sep '16

26 Sep '16

I posted a question that I think has not been posted to the list yet, as it is awaiting moderator approval. That said, in case it is posted, I wanted to share my solution. Question: How to list all students and their matching teachers? Problem: Table(borrowers) has patron info, Table(borrower_attribute) has teacher name and column code "Teacher." I solved the problem by using mysqlWorkbench and running the following sql query: SELECT * FROM `koha_library`.`borrower_attributes`, `koha_library`.`borrowers` WHERE `borrowers`.`borrowernumber`= `borrower_attributes`.`borrowernumber` Martin House martin.house(a)gmail.com www.martindhouse.com 704-996-0297 "An unexamined life is not worth living."

1 0

Error thrown when updating items
by wildness 26 Sep '16

26 Sep '16

Hi, I'm running Koha 3.18.12.000 and I can this error when I try to update items for a record: :21: parser error : Opening and ending tag mismatch: record line 6 and datafield </datafield> ^ :22: parser error : Opening and ending tag mismatch: collection line 2 and record </record> ^ :23: parser error : Extra content at the end of the document </collection> the url pattern is something like this: ../cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=''&itemnumber=''#edititem When I edit one of the fields on this screen it throughs the error above. It seems like a xml error, but after some internet sleuthing I came up with nothing. Can anyone help me out? Thanks! -- View this message in context: http://koha.1045719.n5.nabble.com/Error-thrown-when-updating-items-tp588633… Sent from the Koha-general mailing list archive at Nabble.com.

3 4

Software error in memberentry.pl
by Administrateur 26 Sep '16

26 Sep '16

Hello, When I'm logged as a standard user and access to the /cgi-bin/koha/opac-memberentry.pl I have a software error : Global symbol "$borrower" requires explicit package name at /usr/share/koha/opac/cgi-bin/opac/opac-memberentry.pl line 190. Execution of /usr/share/koha/opac/cgi-bin/opac/opac-memberentry.pl aborted due to compilation errors. The concerned line : # Send back the data to the template %borrower = ( %$borrower, %borrower ); I'm not familiar with perl so I don't really know what to do. The problem doesn't appear when I log as the administrator and try to modify user information with this command : /cgi-bin/koha/members/memberentry.pl?op=modify&destination=circ&borrowernumber=...&categorycode=... (but it isn't the same script so I guess that's why) I use the latest Koha package from the apt. The thing is that all my members are imported from a CSV file. I thought it could be a problem but I have the same error even when I create a new patron from scratch. I use debian 8 stable all packages up to date. Thanks. -- Fraternellement. Joël M. Administrateur Réseaux/Système. Institut Biblique de Nogent-sur-marne.

2 1

Can't locate Koha/Cache.pm
by Arayik Manukyan 23 Sep '16

23 Sep '16

Hi list. We have installed koha3.22.10Tarball version on Ubuntu 14.04 version Now when we tray to install additional language we have such error ****************************************************************** root@host-93-94-220-102:/usr/share/koha/misc/translator# sudo perl translate install hy-Armn Can't locate Koha/Cache.pm in @INC (you may need to install the Koha::Cache module) (@INC contains: /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl .) at /etc/perl/C4/Context.pm line 112. BEGIN failed--compilation aborted at /etc/perl/C4/Context.pm line 112. Compilation failed in require at LangInstaller.pm line 22. BEGIN failed--compilation aborted at LangInstaller.pm line 22. Compilation failed in require at translate line 25. BEGIN failed--compilation aborted at translate line 25. ******************************************************************** we tried such command cp -a /usr/share/koha/lib/C4/ /etc/perl/ but we had the same error and we tried via cpan install Koha::Cache and reaceved error *************************** Warning: Cannot install Koha::Cache, don't know what it is. ***************************** Now how we can solve this problem?

3 2