- Koha - lists.katipo.co.nz

Koha 16.05 - SQL Report on Koha Control Numbers - Finding blank 001s
by Craig Butosi 08 Feb '17

08 Feb '17

Hi all, Koha 16.05 o Ubuntu 14.04 LTS Package install Would a kind soul help me with a basic SQL report which compiles a list of all bibliographic records that have a blank 001, but which have a biblionumber? Columns selected for the report = biblionumber, title, author. I have tried a number of queries but can't seem to get the syntax correct. Many thanks! Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

2 3

Courtesy reminder: Koha-US mtg this morn
by Christopher Davis 08 Feb '17

08 Feb '17

Greetings Koha users, I just wanted to remind you about today's Koha-US meeting scheduled for 10:30 am Central Time held at https://kslib.zoom.us/j/450230564. The *updated* agenda for this meeting can be found at http://koha-us.net/index.php/Minutes2017-02-08. See you there. Regards, Christopher Davis Secretary, Koha-US cgdavis(a)uintah.utah.gov

1 0

Running batchrebuildItemsTables.pl
by Luis Moises Rojas 08 Feb '17

08 Feb '17

How could i execute this file, cos when i try to run using ./batchrebuildItemsTables.pl i got at lot of error: Can not locate c4/context,pm in... adn more if i run it with perl batchrebuildItemsTables.pl -- *Luis Moisés Rojas P.*

3 2

Koha Plugin System
by Bortel, Gary 08 Feb '17

08 Feb '17

The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha 3.20.07... I'm trying to enable the Plugin system using the instructions in the manual (http://manual.koha-community.org/3.20/en/pluginsystem.html) and here (https://github.com/bywatersolutions/koha-plugin-coverflow) - Changed koha-conf.xml <enable_plugins> to 1 - Ensured <pluginsdir> exists and is writeable by the koha user (755) - Restarted both services apache2 and koha-common. - Changed the UseKohaPlugins system preference to Enabled But when I click on the Tool Plugins link under Tools, I get the message... Plugins disabled! To enable Koha plugins, the system preference UseKohaPlugins must be enabled, and the flag enable_plugins must be set in the Koha configuration file Suggestions? gcb ______________________

4 9

Debugging Plugins
by Bob Ewart 07 Feb '17

07 Feb '17

I did get ByWater Solutions kitchensink plugin to loadand run. So I must have it setup properly. I still can't get my DonorApp to load. I was missing some perl modules. They're now installed. I've set the DebugLevel to "lots of". When I do the uploadit comes back to the tools plugin page and does not show it as aplugin. The files are in placein /var/lib/koha/stonewall/plugins/Koha/Bobsown/DonorAppnext to ../ByWaterSolutions/KitchenSink. There are noerror messages. How do I tell it to let me know what's wrong? I'm running Koha 16.05.09 (oldStable) on Debian 8 My running system is Koha 3.22.05 on openSUSE 13.2 Thanks -- Bob

6 8

Name in the Database
by Luis Moises Rojas 07 Feb '17

07 Feb '17

Hi, I want to know the name of this fields on the table. 260a I mean, if you see the fields 651a the name is place on biblioitems table. Any help? -- *Luis Moisés Rojas P.*

2 1

Re: [Koha] To hide empty biblio records in OPAC
by Joy Nelson 07 Feb '17

07 Feb '17

Lukasz - You need access to the server command line in order to reindex. I'm not positive about that command you pasted. My knowledge is more database centered. Perhaps someone else on the list can assist with the reindexing command. joy On Tue, Feb 7, 2017 at 6:56 AM, <lukasz.mesek(a)alingsas.se> wrote: > Hello Joy, > > Unfortunatelly we in the library have no access to database, or I do not > know how to get into it. > All the IT job was done for us by the IT who has a private company. > Do I need deep IT knowledge to do reindexing? > I have found a sequence of reindexing in KOHA manual: > > $ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init > > but do not know where to paste it. > > Med vänlig hälsning > Lukasz Mesek > Vuxenbibliotekarie > Alingsås bibliotek > lukasz.mesek(a)alingsas.se > > > -----Joy Nelson <joy(a)bywatersolutions.com> skrev: ----- > Till: lukasz.mesek(a)alingsas.se, Koha <Koha(a)lists.katipo.co.nz> > Från: Joy Nelson <joy(a)bywatersolutions.com> > Datum: 2017-02-06 15:42 > Ärende: Re: Re: [Koha] To hide empty biblio records in OPAC > > Lukasz- > OpacHiddenItems will not help you here. That system preference will only > work when you have items attached to the bibliographic record and the > bibliographic record exists in the system (not deleted). > > It definitely sounds like you need to reindex your system. Once you have > that done, make sure that the indexer is running on the server as well. > > joy > > > On Mon, Feb 6, 2017 at 3:41 AM, <lukasz.mesek(a)alingsas.se> wrote: > >> Hello Joy, >> >> Yes, I've deleted them in staff client and there they still appear, so in >> OPAC as well. >> In staff client it is just information: The record you requested does not >> exist (19653). In OPAC it is 404 error. >> I have hoped that using OpacHiddenItems to supress these in the OPAC >> helps but I'm not really sure what command should I use. >> >> Med vänlig hälsning >> Lukasz Mesek >> Vuxenbibliotekarie >> Alingsås bibliotek >> lukasz.mesek(a)alingsas.se >> >> >> -----Joy Nelson <joy(a)bywatersolutions.com> skrev: ----- >> Till: lukasz.mesek(a)alingsas.se >> Från: Joy Nelson <joy(a)bywatersolutions.com> >> Datum: 2017-02-03 15:04 >> Ärende: Re: [Koha] To hide empty biblio records in OPAC >> >> Lukasz - >> If you deleted them in the staff client and they still appear in the >> Opac, they are probably 'broken' links, yes? When you click on them do you >> see information? Or do you get a message that record couldn't be found? >> If so, then you will need a reindex to clean up the search results. >> >> -joy >> >> On Fri, Feb 3, 2017 at 4:40 AM, <lukasz.mesek(a)alingsas.se> wrote: >> >>> Hi, >>> >>> >>> >>> I have deleted quite a lot of empty biblio records lately, but they >>> still appear in database. >>> >>> Till moment we do restart of index I would like to hide them at least in >>> OPAC. >>> >>> Is it any way in Koha administration to do this or in any other place? >>> >>> >>> >>> >>> Med vänlig hälsning >>> Lukasz Mesek >>> Vuxenbibliotekarie >>> Alingsås bibliotek >>> lukasz.mesek(a)alingsas.se >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >> >> >> -- >> Joy Nelson >> Director of Migrations >> >> ByWater Solutions <http://bywatersolutions.com> >> Support and Consulting for Open Source Software >> Office: Fort Worth, TX >> Phone/Fax (888)900-8944 >> What is Koha? <http://bywatersolutions.com/what-is-koha/> >> >> > > > -- > Joy Nelson > Director of Migrations > > ByWater Solutions <http://bywatersolutions.com> > Support and Consulting for Open Source Software > Office: Fort Worth, TX > Phone/Fax (888)900-8944 > What is Koha? <http://bywatersolutions.com/what-is-koha/> > > -- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

2 1

Koha development meeting reminder
by Nick Clemens 07 Feb '17

07 Feb '17

Hi All, The next Koha development meeting is on IRC tomorrow 08 February 2017 at 20:00 UTC You can see what that is in your local time here: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… Agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_8_February_2017 Please make sure to add any topics you wish to discuss. See you all soon!

1 0

Re: [Koha] Name on the table Biblioitem
by Joy Nelson 07 Feb '17

07 Feb '17

Luis- When you say "When user select the 260a fields" are you talking about cataloging an item or searching for an item? joy On Mon, Feb 6, 2017 at 2:14 PM, Luis Moises Rojas <lmoisesrojas(a)gmail.com> wrote: > Yes, more o less > > The 651a field is the biblioitems.place on the table > But, the 260a i can not find a fields on the table. > > This is 'cos we want to have this: > When user select the 260a fields, that field must be 651a and have to be > saved in the biblioitem,place field on the table > > On Mon, Feb 6, 2017 at 4:07 PM, Joy Nelson <joy(a)bywatersolutions.com> > wrote: > >> If I'm understanding you correctly Luis, you want the value in the 651a >> to be found in the biblio.place field. >> >> You could adjust your Koha keyword mapping and/or frameworks to map the >> 651a to the biblio.place field. >> >> On Mon, Feb 6, 2017 at 2:03 PM, Luis Moises Rojas <lmoisesrojas(a)gmail.com >> > wrote: >> >>> Hi, >>> I want to know the name of this fields on the table. >>> >>> 260a >>> >>> I mean, if you see the fields 651a the name is place on biblioitems >>> table. >>> >>> This is because we want make something like this >>> >>> 260a=651a >>> >>> So when a user select the Place of publication, have to be the geographic >>> name. >>> >>> Any help? >>> >>> -- >>> *Luis Moisés Rojas P.* >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >> >> >> -- >> Joy Nelson >> Director of Migrations >> >> ByWater Solutions <http://bywatersolutions.com> >> Support and Consulting for Open Source Software >> Office: Fort Worth, TX >> Phone/Fax (888)900-8944 >> What is Koha? <http://bywatersolutions.com/what-is-koha/> >> >> > > > -- > *Luis Moisés Rojas P.* > > -- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

3 2

Name on the table Biblioitem
by Luis Moises Rojas 06 Feb '17

06 Feb '17

Hi, I want to know the name of this fields on the table. 260a I mean, if you see the fields 651a the name is place on biblioitems table. This is because we want make something like this 260a=651a So when a user select the Place of publication, have to be the geographic name. Any help? -- *Luis Moisés Rojas P.*

2 2