Re: [Koha] Running batchrebuildItemsTables.pl

[Magnus Enger]

> út 7. 2. 2017 v 19:34 odesílatel Luis Moises Rojas 
> napsal:
>
>> 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

If you installed using the Debian packages you can also use the
koha-shell command to set up the environment for you:

sudo koha-shell -c "perl batchrebuildItemsTables.pl" 

or do "sudo koha-shell" to get an interactive shell yuo can run commands in.

See "man koha-shell" for more details.

Best regards,
Magnus Enger
Libriotech
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to check a file's MIME type in KOHA

[Rejeesh K.Nair]

Hi Mark,

Your sample code meets my requirement. But I need to implement this for
each uploading file in KOHA code.

Regards,
Rejeesh K.Nair

On Tue, Feb 7, 2017 at 7:36 PM, Mark Alexander  wrote:

> Excerpts from Rejeesh K.Nair's message of 2017-02-07 15:49:42 +0530:
> > I have checked the MIME information of a specific file using its
> extension.
> > But actually I need details of exact file.
>
> I'm a newbie with the Koha source code.  But I'm wondering if there
> is some way you could use the external "file" program from within
> Koha to determine the file type.  This program is not fooled by
> file name extensions; it examines the file contents to determine
> the type.  Here is an example of a test I ran where I renamed a .pdf
> file with .jpg extension in an attempt to fool file:
>
>   $ cp koha-notes.pdf junk.jpg
>   $ file -i junk.jpg
>   junk.jpg: application/pdf; charset=binary
>



-- 
Thanks & Regards,

Rejeesh K.Nair
m: +91 (0) ​9495316906
e: rejeeshkn...@gmail.com
 


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

Re: [Koha] Koha Plugin System

[Liz Rea]

Hi Bob,

Probably you have a compile error in your plugin, see bug
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17461. It
turns out that if the plugin has some kind of syntax error, the plugin
entry won't turn up in the intranet, *and* won't give any errors either!

I'm going to take a guess that you have a use C4::Branches in your
plugin, as that seems quite common a thing for plugins to choke on since
all of the branches stuff was moved to Koha::Libraries in a recent version.

You could also try applying or editing your code to use the patch off of
the above bug, and see if you get more useful diagnostic information.

Sincerely,
Liz, who just spent much too long figuring out what the heck was going
on and now has a bruised forehead from banging her head on the wall.

On 04/02/17 17:50, Bob Ewart wrote:
> I just installed Debian-live-8.7.1-amd64-kde-desktop.iso on a virtual
> machine and Koha 16.11.03 from the Debian packages, and mysql 5.5.  I
> reloaded my koha.sql data from the old system 3.22.05.
>
> The upgrade went with a few errors:
>
> [Fri Feb 3 22:08:01 2017] updatedatabase.pl: At least one
> authorised value has an icon defined (imageurl)
> [Fri Feb 3 22:08:01 2017] updatedatabase.pl: The system preference
> AuthorisedValueImages or StaffAuthorisedValueImages could be turned
> off if you are not aware of this feature
> [Fri Feb 3 22:08:30 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (495) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:32 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (1632) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:32 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (658) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: item-level_itypes set
> but no itype defined for item (20337) at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13447.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: DBD::mysql::db do
> failed: Can't DROP 'isbn'; check that column/key exists [for Statement
> "ALTER TABLE biblioitems DROP INDEX isbn"] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13734.
> [Fri Feb 3 22:08:34 2017] updatedatabase.pl: DBD::mysql::db do
> failed: Can't DROP 'issn'; check that column/key exists [for Statement
> "ALTER TABLE biblioitems DROP INDEX issn"] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 13735.
>
> I followed the wiki and Kyle's additions to set up plugins.
>
> I tried to install my DonorApp plugin.  It put the plugin in the
> proper place but no plugins showed up on the Tools Plugins page. I
> tried ByWater's kitchen-sink-v1.kpz with the same result.
>
>
> On 01/29/2016 02:30 PM, Kyle Hall wrote:
>> Glad to help!
>>
>> Kyle
>>
>> http://www.kylehall.info
>> ByWater Solutions ( http://bywatersolutions.com )
>> Meadville Public Library ( http://www.meadvillelibrary.org )
>> Crawford County Federated Library System ( http://www.ccfls.org )
>> Mill Run Technology Solutions ( http://millruntech.com )
>>
>> On Fri, Jan 29, 2016 at 1:14 PM, Bortel, Gary 
>> wrote:
>>
>>> Perfect, Kyle!
>>>
>>> Thanks for adding the updates to the instructions at
>>> https://github.com/bywatersolutions/koha-plugin-coverflow
>>>
>>>
>>> gcb
>>> __
>>>
>>> From: Kyle Hall [mailto:kyle.m.h...@gmail.com]
>>> Sent: Friday, January 29, 2016 3:17 AM
>>> To: Bortel, Gary 
>>> Cc: koha@lists.katipo.co.nz
>>> Subject: Re: [Koha] Koha Plugin System
>>>
>>> Add this as well:
>>>
>>> 
>>>Options Indexes FollowSymLinks
>>>AllowOverride None
>>>Require all granted
>>> 
>>>
>>> http://www.kylehall.info
>>> ByWater Solutions ( http://bywatersolutions.com )
>>> Meadville Public Library ( http://www.meadvillelibrary.org )
>>> Crawford County Federated Library System ( http://www.ccfls.org )
>>> Mill Run Technology Solutions ( http://millruntech.com )
>>>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Debugging Plugins

[Bob Ewart]

Thanks Magnus,

That patch works on 16.11 not on 16.05.  That patch points me to the 
line where the problem was but doesn't say why.


I had a 'use C4::Branches;' in my code (not sure why).  That doesn't 
exist in 16.11.  That's why ByWater Solutions Kitchensink plugin fails 
to load in 16.11.


I also discovered that the GetPatronImage subroutine is no longer in 
C4:Members.


Anyhow, it's working on Debian from repositories on 16.05 and 16.11.
16.05 is also working on openSUSE.  I'm about to try 16.11

Bob



On 02/07/2017 03:57 AM, Magnus Enger wrote:

On 6 February 2017 at 21:02, Bob Ewart  wrote:

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?

Maybe this bug/patch could be of interest?
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17461

Best regards,
Magnus Enger
Libriotech
___
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] Name in the Database

[Eric Phetteplace]

Hi Luis,

This is actually configurable; the field that MARC 260$a is mapped into
varies depending on how you've set up Koha. You can view your settings here:

{{your Koha server}}/cgi-bin/koha/admin/koha2marclinks.pl

For mine, it was set to biblioitems.place. I assume this is the default
setting and likely the same for you.

Best,
Eric Phetteplace
Systems Librarian
California College of the Arts
libraries.cca.edu | vault.cca.edu
510.594.3660
2>/dev/null

On Mon, Feb 6, 2017 at 11:59 AM, Luis Moises Rojas 
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.
>
> Any help?
>
> --
> *Luis Moisés Rojas P.*
> ___
> 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] Running batchrebuildItemsTables.pl

[Josef Moravec]

Hello Luis,
for running cli script you need to set env variables PERL5LIB and
KOHA_CONF, did you set them?

Josef

út 7. 2. 2017 v 19:34 odesílatel Luis Moises Rojas 
napsal:

> 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.*
> ___
> 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] Multiple OPAC interfaces

[Michael Kuhn]

Hi Chris and Jonathan


This won't work with Plack, because the environment variables set in
Apache are not passed through to Plack.
This still works fine without Plack as the env variables are set for the
scripts running under the apache user.


Thanks for the clarification! I stopped and disabled Plack - and yes, 
immediately the variable worked as expected which is great!



Someone needs to work on a way to pass the variables to plack.
Environment ones won't work, because plack is persistent, they will need
to be set in config or something.

If you want to discuss ideas for doing this, we could move it to the
koha-devel list.


In my particular case Plack is not absolutely necessary because the 
database is quite small. The problem seems already solved, as Jonathan 
just wrote:


> For Plack you can have a look at bug 16520, it is in 16.11.

Still, in my case the situation actually occurred on an installation of 
Koha 16.11.0 - but as said the variables work like a charm when Plack is 
deactivated.


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Running batchrebuildItemsTables.pl

[Luis Moises Rojas]

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.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Multiple OPAC interfaces

[Jonathan Druart]

For Plack you can have a look at bug 16520, it is in 16.11.

On Tue, 7 Feb 2017 at 18:51 Chris Cormack  wrote:

> Hi Michael
>
> This won't work with Plack, because the environment variables set in
> Apache are not passed through to Plack.
> This still works fine without Plack as the env variables are set for the
> scripts running under the apache user.
>
> Someone needs to work on a way to pass the variables to plack.
> Environment ones won't work, because plack is persistent, they will need
> to be set in config or something.
>
> If you want to discuss ideas for doing this, we could move it to the
> koha-devel list.
>
> Chris
>
> On 08/02/17 05:50, Michael Kuhn wrote:
> > Hi Zeno
> >
> >>> Is it possible to have just one Koha database but more than one OPAC
> >>> interface that is accessing the data?
> >>
> >> in my opinion the best option is many OPAC Virtual Hosts with different
> >> DNS CNAME each.
> >> In every VH setup you can insert different values for system preferences
> >> and you can hve different css, js, etc.
> >
> > Thanks for your suggestion! I tried to find some information about
> > different values for system preferences in virtual hosts, via Google I
> > found some Bugzilla issues (10325, 16068) and some other hints, but no
> > official description (except one hint in chapter 2.1 of the manual).
> > There seem to exist variables like OPAC_CSS_OVERRIDE etc and also
> > OVERRIDE_SYSPREF_* which seemingly can be extended like
> > OVERRIDE_SYSPREF_opacbookbag for example.
> >
> > I then configured a new virtual host in my Apache HTTP Server using the
> > standard OPAC configuration for port 80, but changing the port to 1080.
> > After that my OPAC is actually accessible via port 80 as well as 1080.
> >
> > Then (as an example) I added the variable OVERRIDE_SYSPREF_opacbookbag,
> > so the configuration of the virtual host now looks as follows
> >
> > 
> >   = 2.4>
> >Define instance "svk"
> >   
> >Include /etc/koha/apache-shared.conf
> >Include /etc/koha/apache-shared-opac-plack.conf
> >Include /etc/koha/apache-shared-opac.conf
> >
> >ServerName svk
> >SetEnv KOHA_CONF "/etc/koha/sites/svk/koha-conf.xml"
> >SetEnv MEMCACHED_SERVERS ""
> >SetEnv MEMCACHED_NAMESPACE ""
> >AssignUserID svk-koha svk-koha
> >
> >SetEnv OVERRIDE_SYSPREF_opacbookbag 0
> >
> >ErrorLog/var/log/koha/svk/opac-error.log
> > 
> >
> > I then restarted the Apache HTTP Server and also Plack - but there was
> > no visible change in the new OPAC (usually "opacbookbag" should hide or
> > show the Cart symbol). In fact I made many more experiments, but I guess
> > one example is enough here.
> >
> > I'm not sure if I'm doing the right thing anyway... Can you maybe point
> > me to some documentation about the correct changing of values for system
> > preferences?
> >
> > Best wishes: Michael
> > --
> > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> > T 0041 (0)61 261 55 61 <+41%2061%20261%2055%2061> · E m...@adminkuhn.ch
> · W www.adminkuhn.ch
> > ___
> > 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] Multiple OPAC interfaces

[Chris Cormack]

Hi Michael

This won't work with Plack, because the environment variables set in
Apache are not passed through to Plack.
This still works fine without Plack as the env variables are set for the
scripts running under the apache user.

Someone needs to work on a way to pass the variables to plack.
Environment ones won't work, because plack is persistent, they will need
to be set in config or something.

If you want to discuss ideas for doing this, we could move it to the
koha-devel list.

Chris

On 08/02/17 05:50, Michael Kuhn wrote:
> Hi Zeno
> 
>>> Is it possible to have just one Koha database but more than one OPAC
>>> interface that is accessing the data?
>>
>> in my opinion the best option is many OPAC Virtual Hosts with different
>> DNS CNAME each.
>> In every VH setup you can insert different values for system preferences
>> and you can hve different css, js, etc.
> 
> Thanks for your suggestion! I tried to find some information about
> different values for system preferences in virtual hosts, via Google I
> found some Bugzilla issues (10325, 16068) and some other hints, but no
> official description (except one hint in chapter 2.1 of the manual).
> There seem to exist variables like OPAC_CSS_OVERRIDE etc and also
> OVERRIDE_SYSPREF_* which seemingly can be extended like
> OVERRIDE_SYSPREF_opacbookbag for example.
> 
> I then configured a new virtual host in my Apache HTTP Server using the
> standard OPAC configuration for port 80, but changing the port to 1080.
> After that my OPAC is actually accessible via port 80 as well as 1080.
> 
> Then (as an example) I added the variable OVERRIDE_SYSPREF_opacbookbag,
> so the configuration of the virtual host now looks as follows
> 
> 
>   = 2.4>
>Define instance "svk"
>   
>Include /etc/koha/apache-shared.conf
>Include /etc/koha/apache-shared-opac-plack.conf
>Include /etc/koha/apache-shared-opac.conf
> 
>ServerName svk
>SetEnv KOHA_CONF "/etc/koha/sites/svk/koha-conf.xml"
>SetEnv MEMCACHED_SERVERS ""
>SetEnv MEMCACHED_NAMESPACE ""
>AssignUserID svk-koha svk-koha
> 
>SetEnv OVERRIDE_SYSPREF_opacbookbag 0
> 
>ErrorLog/var/log/koha/svk/opac-error.log
> 
> 
> I then restarted the Apache HTTP Server and also Plack - but there was
> no visible change in the new OPAC (usually "opacbookbag" should hide or
> show the Cart symbol). In fact I made many more experiments, but I guess
> one example is enough here.
> 
> I'm not sure if I'm doing the right thing anyway... Can you maybe point
> me to some documentation about the correct changing of values for system
> preferences?
> 
> Best wishes: Michael
> -- 
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Multiple OPAC interfaces

[Michael Kuhn]

Hi Zeno


Is it possible to have just one Koha database but more than one OPAC
interface that is accessing the data?


in my opinion the best option is many OPAC Virtual Hosts with different
DNS CNAME each.
In every VH setup you can insert different values for system preferences
and you can hve different css, js, etc.


Thanks for your suggestion! I tried to find some information about 
different values for system preferences in virtual hosts, via Google I 
found some Bugzilla issues (10325, 16068) and some other hints, but no 
official description (except one hint in chapter 2.1 of the manual). 
There seem to exist variables like OPAC_CSS_OVERRIDE etc and also 
OVERRIDE_SYSPREF_* which seemingly can be extended like 
OVERRIDE_SYSPREF_opacbookbag for example.


I then configured a new virtual host in my Apache HTTP Server using the 
standard OPAC configuration for port 80, but changing the port to 1080. 
After that my OPAC is actually accessible via port 80 as well as 1080.


Then (as an example) I added the variable OVERRIDE_SYSPREF_opacbookbag, 
so the configuration of the virtual host now looks as follows



  = 2.4>
   Define instance "svk"
  
   Include /etc/koha/apache-shared.conf
   Include /etc/koha/apache-shared-opac-plack.conf
   Include /etc/koha/apache-shared-opac.conf

   ServerName svk
   SetEnv KOHA_CONF "/etc/koha/sites/svk/koha-conf.xml"
   SetEnv MEMCACHED_SERVERS ""
   SetEnv MEMCACHED_NAMESPACE ""
   AssignUserID svk-koha svk-koha

   SetEnv OVERRIDE_SYSPREF_opacbookbag 0

   ErrorLog/var/log/koha/svk/opac-error.log


I then restarted the Apache HTTP Server and also Plack - but there was 
no visible change in the new OPAC (usually "opacbookbag" should hide or 
show the Cart symbol). In fact I made many more experiments, but I guess 
one example is enough here.


I'm not sure if I'm doing the right thing anyway... Can you maybe point 
me to some documentation about the correct changing of values for system 
preferences?


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] To hide empty biblio records in OPAC

[Pedro Amorim]

Hello lukasz,

If you have indeed deleted the records, and they still appear on search
results then the following must be happening:
- When you click on a record from the search results, a page with "the
requested record does not exist".

If that is indeed happening, it means the record is no longer in the
database but it is still indexed.

If the record is still indexed, it means the database and the index are no
longer in sync, and that happens when the indexer is not running.

You didn't provide your koha version, but if you're running Debian package *>=
16.05* you need to access the server (ssh) and run, at any directory:

*koha-indexer --start *

If running an older version or zebra is not running, run:

*koha-start-zebra *

If you don't know your instance name, run:

*koha-list*

If the above was successful, but the records still show, you'll have to
full reindex:

*koha-rebuild-zebra -v -f *

Hope this helps, good luck!

Pedro Amorim


2017-02-07 13:38 GMT-01:00 Joy Nelson :

> 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,  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.me...@alingsas.se
> >
> >
> > -Joy Nelson  skrev: -
> > Till: lukasz.me...@alingsas.se, Koha 
> > Från: Joy Nelson 
> > 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,  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.me...@alingsas.se
> >>
> >>
> >> -Joy Nelson  skrev: -
> >> Till: lukasz.me...@alingsas.se
> >> Från: Joy Nelson 
> >> 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,  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.me...@alingsas.se
> >>> ___
> >>> Koha mailing list  http://koha-community.org
> >>> Koha@lists.katipo.co.nz
> >>> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>>
> >>
> >>
> >>
> >> --
> >> Joy Nelson
> >> Director of Migrations
> >>
> >> ByWater Solutions 
> >> Support and Consulting for Open Source Software
> >> Office: Fort Worth, TX
> >> Phone/Fax (888)900-8944
> >> What is Koha? 
> >>
> >>
> >
> >
> > --
> > Joy Nelson
> > Director of Migrations
> >
> > ByWater Solutions 
> > Support and Consulting for Open Source Software
> > Office: Fort 

Re: [Koha] To hide empty biblio records in OPAC

[Joy Nelson]

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,  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.me...@alingsas.se
>
>
> -Joy Nelson  skrev: -
> Till: lukasz.me...@alingsas.se, Koha 
> Från: Joy Nelson 
> 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,  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.me...@alingsas.se
>>
>>
>> -Joy Nelson  skrev: -
>> Till: lukasz.me...@alingsas.se
>> Från: Joy Nelson 
>> 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,  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.me...@alingsas.se
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>>
>> --
>> Joy Nelson
>> Director of Migrations
>>
>> ByWater Solutions 
>> Support and Consulting for Open Source Software
>> Office: Fort Worth, TX
>> Phone/Fax (888)900-8944
>> What is Koha? 
>>
>>
>
>
> --
> Joy Nelson
> Director of Migrations
>
> ByWater Solutions 
> Support and Consulting for Open Source Software
> Office: Fort Worth, TX
> Phone/Fax (888)900-8944
> What is Koha? 
>
>


-- 
Joy Nelson
Director of Migrations

ByWater Solutions 
Support and Consulting for Open Source Software
Office: Fort Worth, TX
Phone/Fax (888)900-8944
What is Koha? 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to check a file's MIME type in KOHA

[Mark Alexander]

Excerpts from Rejeesh K.Nair's message of 2017-02-07 15:49:42 +0530:
> I have checked the MIME information of a specific file using its extension.
> But actually I need details of exact file.

I'm a newbie with the Koha source code.  But I'm wondering if there
is some way you could use the external "file" program from within
Koha to determine the file type.  This program is not fooled by
file name extensions; it examines the file contents to determine
the type.  Here is an example of a test I ran where I renamed a .pdf
file with .jpg extension in an attempt to fool file:

  $ cp koha-notes.pdf junk.jpg
  $ file -i junk.jpg
  junk.jpg: application/pdf; charset=binary
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Multiple OPAC interfaces

[Tajoli Zeno]

Hi,

Il 07/02/2017 14:24, Michael Kuhn ha scritto:


Is it possible to have just one Koha database but more than one OPAC
interface that is accessing the data?


in my opinion the best option is many OPAC Virtual Hosts with different 
DNS CNAME each.
In every VH setup you can insert different values for system preferences 
and you can hve different css, js, etc.


Bye
Zeno Tajoli

--
Zeno Tajoli
/SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche
Email: z.taj...@cineca.it Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha development meeting reminder

[Nick Clemens]

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+IRC+Meeting=20170208T20

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!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Multiple OPAC interfaces

[Michael Kuhn]

Hi

Is it possible to have just one Koha database but more than one OPAC 
interface that is accessing the data?


The Koha database contains very specific reference data (without items) 
that is interesting for more than one institution. The owner of the 
database would like to allow different institutions to have their own 
OPAC interface (with own logo, own colors etc, but no user logins) to 
access the data. Having just one interface with several logos etc is no 
option.


So my idea is to have more than one Koha instance. The first instance 
would contain the "master" database - from this the tables "biblio", 
"items" and "biblioitems" would be unloaded every night and loaded into 
the databases of the other instances, followed by a reindexing. This 
would cause some cost for scripting and testing, but it would be 
relatively easy to update the instances.


Still I'm wondering if there is maybe a better solution to this problem?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to check a file's MIME type in KOHA

[Rejeesh K.Nair]

Hi All,

I have checked the MIME information of a specific file using its extension.
But actually I need details of exact file.
Say, I have a file like test.jpg , somebody renamed its extension as
test.pdf. If we checked the MIME information of test.pdf, it should display
the output as image/jpeg.

For implementing this , I am trying to integrate *File::MMagic::XS* into
KOHA with the following steps.

   1. Download *File::MMagic::XS* from http://search.cpan.org/~dmaki/
   File-MMagic-XS-0.09008/lib/File/MMagic/XS.pm
   

   .
   2. Extract the tar file and put the extracted file into
   usr/share/koha/lib/C4.
   3. Take command  prompt and Use command : cd /usr/share/koha/lib/C4/File-
   MMagic/
   4. Use command: perl Makefile.PL
   5. Use command: make
   6. Use command: make install

After that ,

call *use C4::File-MMagic::lib::File::MMagic::XS;*



*my $m = File::MMagic::XS->new();$m = File::MMagic::XS->new('/etc/magic');
# use external magic filemy $mime = $m->get_mime($source);*

into the  specific page and upload a jpeg file.But I got the MIME type as
*text/plain*

Can someone help on this issue?
Regards,
Rejeesh K.Nair


> On Wed, Feb 1, 2017 at 2:51 PM, Indranil Das Gupta 
> wrote:
>
>> Hi,
>>
>> You need to look into /usr/share/koha/lib/Koha/Upload.pm
>> and /usr/share/koha/intranet/cgi-bin/tools/upload.pl files.
>>
>> The perl module file is place where you need to write up the new function
>> to handle the mimetype and then call that function from upload.pl script.
>>
>> hope this helps
>> -idg
>>
>> --
>> Indranil Das Gupta
>> L2C2 Technologies
>>
>> Phone : +91-98300-20971 <098300%2020971>
>> WWW  : http://www.l2c2.co.in
>> Blog: http://blog.l2c2.co.in
>> IRC : indradg on irc://irc.freenode.net
>> Twitter : indradg
>>
>> On Tue, Jan 31, 2017 at 10:48 AM, Rejeesh K.Nair 
>> wrote:
>>
>>> Hi Indranil,
>>>
>>> Thank you for your quick reply.
>>>
>>> Could you please help me, how to integrate the code to check the MIME
>>> type in KOHA?
>>>
>>> Regards,
>>> Rejeesh K Nair
>>>
>>> On Mon, Jan 30, 2017 at 3:14 PM, Indranil Das Gupta 
>>> wrote:
>>>
 Hi Rajeesh,

 On Mon, Jan 30, 2017 at 10:52 AM, Rejeesh K.Nair <
 rejeeshkn...@gmail.com> wrote:


> I need to check the MIME type of each uploaded file for security
> purposes.
>
> Some search results from Google suggest that we can do it with the
> help of
> the File::MimeInfo Perl
> module.
>
> How can we install the File::MimeInfo module in KOHA and check the MIME
> types, or is there some better way?
>

 IIRC, that sort of generic mimetype detection functionality does not
 exist in Koha. From the top of my head, the only place where we actively
 check for mimetype is the image upload option using GD which is basically
 restricted to a few image formats like PNG, JPEG, XPM etc.

 Short answer: To implement this on the server side, you have to write
 the necessary code. As a stop gap, you *could* use the Javascript
 FileReader object to check the mimetype on the client side. but that is not
 a fool proof  solution.

 hope this helps.
 --
 Indranil Das Gupta
 L2C2 Technologies

 Phone : +91-98300-20971 <098300%2020971>
 WWW  : http://www.l2c2.co.in
 Blog: http://blog.l2c2.co.in
 IRC : indradg on irc://irc.freenode.net
 Twitter : indradg

>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>>
>>> Rejeesh K.Nair
>>> m: +91 (0) ​9495316906 <+91%2094953%2016906>
>>> e: rejeeshkn...@gmail.com
>>> 
>>> 
>>> 
>>> 
>>>
>>>
>>
>
>
> --
> Thanks & Regards,
>
> Rejeesh K.Nair
> m: +91 (0) ​9495316906 <094953%2016906>
> e: rejeeshkn...@gmail.com
>  
> 
> 
>
>


-- 
Thanks & Regards,

Rejeesh K.Nair
m: +91 (0) ​9495316906
e: rejeeshkn...@gmail.com
 


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

Re: [Koha] Debugging Plugins

[Magnus Enger]

On 6 February 2017 at 21:02, Bob Ewart  wrote:
> 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?

Maybe this bug/patch could be of interest?
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17461

Best regards,
Magnus Enger
Libriotech
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha