date:20171207

Re: [Koha] SQL - Library Books Investment by Collection Code

2017-12-07 Thread SATISH

Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with
MySQL -  mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (i686) using
readline 6.3 (from About Koha page)

Library Books investments by "Collection Code" for a single library/default
library.
-
SELECT
ccode AS 'Collection Code',
COUNT(DISTINCT items.biblionumber) AS 'No of Titles',
COUNT(itemnumber) AS 'No of Volumes',
SUM(price) AS 'Investment or total expenditure in Rs.'
FROM items
GROUP BY ccode

Output,

https://ibb.co/kyRueb

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

Re: [Koha] Unable to Check-In Error

2017-12-07 Thread SATISH

yeah, it's worked! for me. thank you so much. I am able to check-in books
for the said borrower. it was really a good fix!

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

[Koha] Book Cover

2017-12-07 Thread Manny Tamayao

Hi Ms. Victoria,

You need to add a CSS script on your OPAC system preferences.
Here's a link to the Koha Wiki page
https://wiki.koha-community.org/wiki/HTML_%26_CSS_Library#Hide_No_Image_Found
.

Manny Tamayao


> hi.
> is there a way to show only one book cover per record?
> i enable amazon and local cover images and in my opac search i can see the
> cover from amazon and "no cover image available"
> hope someone can help.
> thanks.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 3892
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Advanced search - Additional content types for books/printed materials

2017-12-07 Thread Dimitris Antonakis

Dear Andreas,

Thank you for your valuable input.
Thankfully it was easier to solve than expected. The default 008 values at
positions 24-27 - Nature of contents, was filled by a "| - Not attempt to
code". When I changed it to "# - No specified nature of contents"
everything worked like a charm.

Regards,
Dimitris


On Thu, Dec 7, 2017 at 11:11 AM Andreas Roussos 
wrote:

> Hi Dimitris,
>
> In your OPAC, if I choose 'Legal cases and case notes' in the Additional
> content types for books/printed materials drop-down menu, I don't get any
> results. From the "No results found!" page we can at least get the name
> of the Zebra index that was queried ('ctype').
>
> If you grep for "^melm 008" in your MARC21 record.abs file (normally at
> /etc/koha/zebradb/marc_defs/marc21/biblios/record.abs) what do you get?
>
> In my system, `grep "^melm 008" record.abs` yields this:
> melm 008 [...] ctype:w:range(data,24,4) [...]
> i.e. the 'ctype' index is built from characters 24-27 of the 008 field.
>
> Oddly enough, if I choose "Bibliographies" as a content type in your
> OPAC (i.e. ctype = 'b') I get one result (biblio 5080).
>
> This makes sense because looking at the MARC view for that biblio:
>
> http://87.203.234.185:8080/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=5080
> we see that field 008 = 171123m2017gr | b001 | gre d
> So, character 25 (within the 24-27 character range) is indeed a 'b'.
>
> However, you have at least 4 more biblios that should appear in the
> results for that search:
> 5082: 171124s2017gr | b||| 001 | gre d
> 5085: 171128s2017fr do2||| 000 | fre d
> 5086: 171130s2017gr | b||| 001 | gre d
> 5087: 171201s2016gr | b||| 001 | gre d
>
> Perhaps a full re-index is in order?
> (koha-rebuild-zebra -f -a -b -v )
>
> Kind regards,
> Andreas
> 
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to Check-In Error

2017-12-07 Thread Pedro Amorim

1) Copy the ID's under *Checkouts* from About Koha -> System Information

2) *Select * from old_issues where issue_id IN ()*
Confirm the listed rows are the ones you want to delete;

3) *Delete from old_issues where issue_id IN ();*

4) Check in items and be happy.

This should work.

Have a good one,

On 7 December 2017 at 05:27, SATISH  wrote:

> Hi,
>
> Please find the "System Information" screen capture here...
> https://ibb.co/mt3SEb
>
> since I have installed Koha from packages method, I am not clear about 
> memcached
> setup.
>
> I did an update to 16.05 during last week of Aug 2017. Whatever books
> issued between last week of aug and first week of septer 2017, I am facing
> problems now.
> few months back I updated to 16.11.11 and other functionalities are
> working fine.
>
> I am facing problem in check-in for borrowernumber=522, that is not
> listed in System Information Screen.
>
> I have an access to mysql and Is there anyway, I could fix the old_issues
> table without disturbing production system ?
>
> with thanks
> satish
>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Book Cover

2017-12-07 Thread Pedro Amorim

Hello Victoria,

Try pasting this into OPACUserJS *syspref*:

function remove_amazon_message() {
  $("span:contains('"+NO_AMAZON_IMAGE+"')").each(function(i){
$(this).hide();
  })
}

$(window).load(function() {
remove_amazon_message();
});

*--*

This is what I'm using and works for every language.

Have a good one,

Pedro Amorim

On 7 December 2017 at 01:18, Ma. Victoria H. Silva-Manuel <
mavicsi...@gmail.com> wrote:

> hi.
> is there a way to show only one book cover per record?
> i enable amazon and local cover images and in my opac search i can see the
> cover from amazon and "no cover image available"
> hope someone can help.
> thanks.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 3892
> ___
> 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] KOCT 0.4.5

2017-12-07 Thread Radek Šiman

Thanks both of you, Matthias and Josef. And yes, I plan to translate it 
ASAP ;-)


Radek

Dne 07.12.17 v 10:18 Matthias Meusburger napsal(a):

Yes, these instructions to translate are still up-to-date.

I'll gladly integrate any translation.

Le 07/12/2017 à 08:06, Josef Moravec a écrit :

Hi Radek,

see this mail:
http://lists.koha-community.org/pipermail/koha-devel/2017-October/044090.html 



are you going to make the translation? ;)

Josef

st 6. 12. 2017 v 22:13 odesílatel Radek Šiman 
napsal:


Great job, Matthias!

Is there a way how we can translate the tool into Czech? If yes, please
guide me... Some of our (mainly older) librarians have difficulties
while using it in English.
Thanks.

Radek

Dne 06.12.17 v 13:26 Matthias Meusburger napsal(a):

Hi everyone,

We had a "Ship it" day during this Biblibre winter camp, and I chose
to work on KOCT.

So here's what's new in v0.4.5:

  - Add a "configuration test" button which will check if koha host,
username and password are ok


  - Retrieve branchnames and branchcodes as a dropdown list

(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16497
is available, adresses
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19689 )


  - Cleaner error handling

(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19752
is available)


  - Add data export in Koc format

(see

https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format 


)


  - Add a button to jump to the configuration page.


This new version should be available at Mozilla's in a couple of days.

Enjoy :)
___
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

Re: [Koha] KOCT 0.4.5

2017-12-07 Thread Matthias Meusburger


Yes, these instructions to translate are still up-to-date.

I'll gladly integrate any translation.

Le 07/12/2017 à 08:06, Josef Moravec a écrit :

Hi Radek,

see this mail:
http://lists.koha-community.org/pipermail/koha-devel/2017-October/044090.html

are you going to make the translation? ;)

Josef

st 6. 12. 2017 v 22:13 odesílatel Radek Šiman 
napsal:


Great job, Matthias!

Is there a way how we can translate the tool into Czech? If yes, please
guide me... Some of our (mainly older) librarians have difficulties
while using it in English.
Thanks.

Radek

Dne 06.12.17 v 13:26 Matthias Meusburger napsal(a):

Hi everyone,

We had a "Ship it" day during this Biblibre winter camp, and I chose
to work on KOCT.

So here's what's new in v0.4.5:

  - Add a "configuration test" button which will check if koha host,
username and password are ok


  - Retrieve branchnames and branchcodes as a dropdown list

(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16497
is available, adresses
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19689 )


  - Cleaner error handling

(when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19752
is available)


  - Add data export in Koc format

(see


https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format

)


  - Add a button to jump to the configuration page.


This new version should be available at Mozilla's in a couple of days.

Enjoy :)
___
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] Advanced search - Additional content types for books/printed materials

2017-12-07 Thread Andreas Roussos

Hi Dimitris,

In your OPAC, if I choose 'Legal cases and case notes' in the Additional
content types for books/printed materials drop-down menu, I don't get any
results. From the "No results found!" page we can at least get the name
of the Zebra index that was queried ('ctype').

If you grep for "^melm 008" in your MARC21 record.abs file (normally at
/etc/koha/zebradb/marc_defs/marc21/biblios/record.abs) what do you get?

In my system, `grep "^melm 008" record.abs` yields this:
melm 008 [...] ctype:w:range(data,24,4) [...]
i.e. the 'ctype' index is built from characters 24-27 of the 008 field.

Oddly enough, if I choose "Bibliographies" as a content type in your
OPAC (i.e. ctype = 'b') I get one result (biblio 5080).

This makes sense because looking at the MARC view for that biblio:
http://87.203.234.185:8080/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=5080
we see that field 008 = 171123m2017gr | b001 | gre d
So, character 25 (within the 24-27 character range) is indeed a 'b'.

However, you have at least 4 more biblios that should appear in the
results for that search:
5082: 171124s2017gr | b||| 001 | gre d
5085: 171128s2017fr do2||| 000 | fre d
5086: 171130s2017gr | b||| 001 | gre d
5087: 171201s2016gr | b||| 001 | gre d

Perhaps a full re-index is in order?
(koha-rebuild-zebra -f -a -b -v )

Kind regards,
Andreas

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

Re: [Koha] SQL - Library Books Investment by Collection Code

Re: [Koha] Unable to Check-In Error

[Koha] Book Cover

Re: [Koha] Advanced search - Additional content types for books/printed materials

Re: [Koha] Unable to Check-In Error

Re: [Koha] Book Cover

Re: [Koha] KOCT 0.4.5

Re: [Koha] KOCT 0.4.5

Re: [Koha] Advanced search - Additional content types for books/printed materials

9 matches

Site Navigation

Mail list logo

Footer information