Re: [Koha] Template toolkin and MARC field/subfields

[Josef Moravec]

Hello Mike,

I would try something like this:
https://gist.github.com/xmorave2/cd926ec245e34c4f42537de221016f5c

see especially this part (lines 6 to 10):

[% record = checkout.item.biblio.metadata.record %]
[% field787 = record.field('787') %]
[% IF field787 %].
[% field787.subfield('t') %] [% field787.subfield('g') %].
[% END %]

Best regards,

Josef

On Wed, Sep 22, 2021 at 9:39 PM Mike D.  wrote:

> Hello, community,
> does anyone have experience with using MARC fields in notices?
> Specifically, we would need to output the contents of some fields/sufields
> to text in e-mail notice using the template toolkit. For example, $t and $g
> in field 787. Is this possible? Does anyone have experience with this?
>
> Thanks
>
> Michal
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Josef Moravec
josef.mora...@gmail.com
___

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

Re: [Koha] No such column 'maxissueqty' Issue

[Josef Moravec]

No, Koha 18.11 does not have this bug

Josef

út 12. 3. 2019 v 14:19 odesílatel Andi Sugandi 
napsal:

> On Tue, Mar 12, 2019 at 7:36 PM Josef Moravec 
> wrote:
>
> Hello Josef,
>
> > it is known bug in master:
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22489
>
> Does it also happen in Koha 18.11?
>
> > currently being fixed
>
> Aha! Glad to hear it.
>
> Best regards,
> --
> Andi Sugandi.
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] No such column 'maxissueqty' Issue

[Josef Moravec]

Hello Andi,

it is known bug in master:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22489

currently being fixed

Josef

út 12. 3. 2019 v 10:56 odesílatel Andi Sugandi 
napsal:

> Hi all,
>
> I'm trying to install Koha via Git installation as instructed here[1]
> on Ubuntu 18.04. Install it in 'single' mode, and when run the
> web-installer, in the middle of the process, it tells in the log file:
>
> [Tue Mar 12 15:48:52.625068 2019] [cgi:error] [pid 1573] [client
> 36.72.125.235:57812] AH01215: [Tue Mar 12 15:48:52 2019]
> onboarding.pl: DBIx::Class::Row::store_column(): No such column
> 'maxissueqty' on Koha::Schema::Result::Issuingrule at
> /home/kanaya/koha/lib/Koha/Object.pm line 75:
> /home/kohaapps/koha/intranet/cgi-bin/installer/onboarding.pl, referer:
> http://kohaapps.example.com/cgi-bin/koha/installer/onboarding.pl
>
> and the page error is:
>
> Software error:
>
> DBIx::Class::Row::store_column(): No such column 'maxissueqty' on
> Koha::Schema::Result::Issuingrule at
> /home/kohaapps/koha/lib/Koha/Object.pm line 75
>
> For help, please send mail to the webmaster
> (ad...@kohaapps.example.com), giving this error message and the time
> and date of the error.
>
> What do you suggest?
>
> Thanks in advance.
>
> [1] https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git
>
> Best regards,
> --
> Andi Sugandi.
> ___
> 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] Error restoring Koha-Instance

[Josef Moravec]

I should work this way:

restore old db
ignore zebra errors
update database schema
rebuild zebra manually

Josef

pá 22. 2. 2019 v 18:30 odesílatel Alvaro Cornejo 
napsal:

> Hi
>
> It said there is a  Unknown column 'me.damaged_on' ... this usually means
> that your DB schema has changed. Probably when updated/upgarded your koha
> install.
>
> There is a koha command to upgrade the schema but I don't know if that will
> solve the issue on a restore.
>
> Regards
>
> Alvaro
>
>
>
>
> |-|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
> y GPRS online
>   Visitenos en www.perusms.com
>
>
> Le ven. 22 févr. 2019 à 11:31, Beda Szukics  a
> écrit :
>
> > Hi all
> >
> > I try to restore a koha-instance wiht koha-restore and I get the
> > following messages:
> >
> > error retrieving biblio 1669 at
> > /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
> > DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field
> > list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`,
> > `me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`,
> > `me`.`booksellerid`, `me`.`homebranch`, `me`.`price`,
> > `me`.`replacementprice`, `me`.`replacementpricedate`,
> > `me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`,
> > `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`,
> > `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`,
> > `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`,
> > `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`,
> > `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`paidfor`,
> > `me`.`timestamp`, `me`.`location`, `me`.`permanent_location`,
> > `me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`,
> > `me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`,
> > `me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`,
> > `me`.`new_status` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )"
> > with ParamValues: 0=2262] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm
> > line 1836.
> >
> > Maybe my dump is too old? The one I have is from Juni 2018. Koha is
> > 18.11.02.000.
> >
> > It shows:
> > System Maintenance
> >
> > The Koha online catalog is offline for system maintenance. We'll be back
> > soon! If you have any questions, please contact the site administrator
> >
> > What can I do?
> >
> > Beda
> > ___
> > 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] Adding menu links in navbar

[Josef Moravec]

Hi,

there is IntranetNav system preference, where you can write in some html to
add to navbar.

Josef

ne 15. 7. 2018 v 15:35 odesílatel drojup  napsal:

> Hi,
>
> Is there any way to add links in navbar (next to cart, lists)?
>
> Thank you
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> 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] Item circulation history not seen

[Josef Moravec]

Hello,

it is known bug, see
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20934


Josef


čt 14. 6. 2018 v 8:37 odesílatel Sahadeo Taware 
napsal:

> Dear Sir
>
> I am upgraded my koha software from 17.12 to 18.05
>
> Now the problem is that I am not able to see the circulation history of an
> item
> it shows that the items *has never been checked out.*
> it show for all items which is circulated previously
> --
> Sahadeo D. Taware
> Librarian, M.L.I.Sc., NET
> Thakur College of Science and Commerce
> Thakur Village, Kandivli(E), Mumbai 400101
> Mob. No 9324912816
> ___
> 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] GDPR IRC Meeting vol. 2

[Josef Moravec]

Hello community,

the second GDPR IRC meeting will be held on wednesday 18. 4. 2018, at:
14:00 UTC

The agenda will be here:
https://wiki.koha-community.org/wiki/GDPR_IRC_meeting_18_April_2018

regards

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

Re: [Koha] GDPR IRC meeting vol. 2

[Josef Moravec]

Hi Narcis,

last time, I used framadate, but it was a bit painful to setup poll
there... I haven't known the other alternatives, thank! I'll try them next
time and see ;)

Josef

st 4. 4. 2018 v 11:16 odesílatel Narcis Garcia <informat...@actiu.net>
napsal:

> Please, support and make us of open source services:
> https://dudle.inf.tu-dresden.de/
> https://dudle.lamardebits.org/
>
> Or alternatives:
> https://framadate.org/
> https://nuages.domainepublic.net/
>
>
> El 04/04/18 a les 11:06, Josef Moravec ha escrit:
> > Hello all interesteed in GDPR,
> >
> > we would like to have another meeting on this topic, but time and date is
> > not set yet. So please fill this poll if you are interested. Thanks.
> >
> > https://doodle.com/poll/q7s88vqnc5xtf9ev
> >
> > Josef
> > ___
> > 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] GDPR IRC meeting vol. 2

[Josef Moravec]

Hello all interesteed in GDPR,

we would like to have another meeting on this topic, but time and date is
not set yet. So please fill this poll if you are interested. Thanks.

https://doodle.com/poll/q7s88vqnc5xtf9ev

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

Re: [Koha] Can't delete line from "circulation and fine rules"

[Josef Moravec]

Hi Klass,

first of all: Which version of Koha are you using?

Generally speaking: It is definitely possible to define the rule without
item type - then it applies to all item types. Also it is possible to
change/remove a rule: the buttons for this are at the right  side of every
row - you just need to scroll to the right.

Could I ask you which features are you missing in Koha?

Hope that helps.

Josef


po 26. 3. 2018 v 13:26 odesílatel klas.blomb...@skovde.se <
klas.blomb...@skovde.se> napsal:

> Greetings!
> This is my first posting to this list, so let my introduce myself:
> I work at Bibliotek Mellansjö (Libraries between the lakes - sounds very
> weird in English, doesn't it?), a consortium of eight public libraries in
> Sweden, and we migrated to Koha in the middle of january this year. Before
> that I have been working as systems librarian in both public and academic
> libraries for eleven years, most of the time with SirsiDynix Symphony - and
> I have a wishlist with at least a dozen of features from that system I
> would like to see introduced in Koha..
>
> But, my problem today is more adjacent:
> Somehow we made some error when we set up our circulation and fine rules
> in Koha - so we have some lines in our circulation and fine rules that
> doesn't contain an item type. Yes, I know, that should not be possible, and
> I don't know how we made it!
> There seems to be no way to modify nor remove those unwanted lines from
> inside the staff "client", so how can I get rid of them?
>
> Klas Blomberg
> IT-bibliotekarie
>
> Stadsbiblioteket
> Skövde Kulturhus
> Skövde kommun
> 541 83 Skövde
> Direkttelefon 0500-49 85 18
> Kontaktcenter telefon 0500-49 80 00
>
> www.skovde.se
>
>
> ___
> 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] Biblios in reservoir

[Josef Moravec]

Hi,
use cleanup_database.pl script with parameter --import

Josef

út 20. 2. 2018 v 8:51 odesílatel Ma. Victoria H. Silva-Manuel <
mavicsi...@gmail.com> napsal:

> Hi.
> How do you delete biblios in reservoir?
> Thank you.
>
> --
> 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

[Koha] GDPR IRC meeting

[Josef Moravec]

Hello all,

based on the poll, I have chosen date and time of GDPR meeting to mondey
26. 2. 2018 19:00 UTC

The agenda will be here:
https://wiki.koha-community.org/wiki/GDPR_IRC_meeting_26_February_2018

Feel free to add your points.

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

[Koha] ***UNCHECKED*** GDPR IRC meeting proposal

[Josef Moravec]

Hello all,
it would be nice to have some meeting about the GDPR and data privacy in
Koha.

With GDPR going to take effect in May, there is not too much of time to
adapt our systems and proccesses.

The subject of meeting should be disscusion about things documented on Koha
wiki [1] and to share our experiences with GDPR implementation.

There is also omnibus bug report found at [2]

We just need to set up a date and time of the meeting, here is the poll:

https://framadate.org/ymtnis54CARuR4am

Cheers Josef

Sources:
[1]
https://wiki.koha-community.org/wiki/Improve_data_protection_and_patron_privacy
[2] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18081
___
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

[Josef Moravec]

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

Re: [Koha] Adding an independent branch

[Josef Moravec]

Hi Elaine,

maybe a report like this could be useful for you, it searches for
candidates to merging and have buttons to merge found records. Candidates
are grouped by author, title, part number and volume title:

SELECT GROUP_CONCAT(bi.isbn) as isbns, b.author,
CONCAT_WS(" ", ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="b"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="p"]'), ExtractValue(bm.metadata,
'//datafield[@tag="245"]/subfield[@code="n"]')) as title_norm,
CONCAT_WS("", ExtractValue(bm.metadata,
'//datafield[@tag="260"]/subfield[@code="c"]'), ExtractValue(bm.metadata,
'//datafield[@tag="264"]/subfield[@code="c"]')) as year_norm,
bi.place, bi.publishercode, b.copyrightdate, COUNT(*) as recordscount ,
CONCAT_WS("", " Search") as Search,
CONCAT_WS("", " Merge") AS Merge
FROM biblio b
JOIN biblioitems bi ON b.biblionumber = bi.biblionumber
JOIN biblio_metadata bm ON b.biblionumber = bm.biblionumber
GROUP BY title_norm, b.author, year_norm, frameworkcode
having recordscount > 1 AND year_norm != ""
order by isbns, b.author




Josef

po 9. 10. 2017 v 18:37 odesílatel Elaine Bradtke  napsal:

> We have a sister library with very similar content that would like to be
> added as an independent branch. I estimate the duplication rate of their
> material with ours is 95% or better.  But most of this material does not
> have an ISBN number. Their data, in its raw state is quite messy, and needs
> cleaning up, but much of this work could be avoided by linking to biblio
> records already in our catalogue.
>
> Given that they have a part time professional librarian on a limited
> contrantract (and I'm only part time on another limited contract) we're
> trying to work out the most efficient way to add their records as an
> independent branch.
>
> Plan A) I have uploaded their data into our test site, with the item
> records designated as their branch - If they did the linking and
> corrections in the test site, could I export only their branch's records
> (mostly item records, but perhaps some biblios) and import them into our
> main site? We use the 999c in record matching because so much of our
> material doesn't have ISBN.
>
> Plan B) Upload their data directly to the main site, but mark them all as
> Hide in OPAC until they can edit them. Simpler, but we're worried how much
> access we'll have to grant to our biblio records.
>
> Because we're keeping the branches very separate, would they be able to add
> items to our bib records if they are limited to editing records from their
> own branch? The problem is their cataloguing is done by volunteers and
> especially after the professional librarian's contract ends,  we want to
> very strictly limit what they can do to our records.
>
> What's the best way to add items belonging to another branch if you have to
> do it manually (because of no ISBN numbers?) Do you use the merge function?
> I think this will require a lot of experimentation, but I'd love to hear
> from anyone who's had experience with this process.
> Thanks!
>
> Elaine Bradtke
>
> 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 <+44%2020%207485%202206> (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@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] Unknown column 'metadata' in 'field list'

[Josef Moravec]

Hello Vimar,

you need to join the table biblio_metadata to your query

Best

Josef

st 9. 8. 2017 v 7:06 odesílatel Vimal Kumar V.  napsal:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> 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] Koha on Debian Stretch?

[Josef Moravec]

Hi Chris,

I have installed Koha 16.11 on Debian Stretch just few days ago and it have
worked as seamlessly as on Jessie.

Best

Josef

út 8. 8. 2017 v 12:22 odesílatel Chris Brown  napsal:

> Hello,
>
> Does anyone have any experience (good or bad) of installing Koha on Debian
> 9.1 ("Stretch")? Anything I need to watch out for?
>
> Thanks!
>
> Chris Brown
> ___
> 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] After Upgrade no biblio_metadata and mo marcxml

[Josef Moravec]

it should theoretically work, but i didn't try it... note, that in mysql
tables biblio and biblioitems aren't all data, which are normally in
Marcxml record... co the MARC will be incomplete! but if you do not have
backup, you don't have many options...

Josef

út 1. 8. 2017 v 11:26 odesílatel Gevork Grigorian <gelinger...@yandex.com>
napsal:

> The problem is that I have no backup :(( I mentioned
> that the only problem is this missing MARCXML. From that XML file most of
> the things are in normal mysql table exists. Am I right? Only the IDs and
> Location fields are not there.
>
> Am I right? If i write a script which will generate the XML from the
> existing data , and put in the biblio_metadata database, it will work?
>
> 01.08.2017, 10:48, "Josef Moravec" <josef.mora...@gmail.com>:
>
> Hello,
>
> just reload db from backup, then set mysql according to this guide:
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7
>
> then you can update your database structure and everything should be ok
>
> regards
> Josef
>
> út 1. 8. 2017 v 9:08 odesílatel gevos <gelinger...@yandex.com> napsal:
>
> Overyesterday We have updated ubuntu server and the koha was updated too.
> Apparently because of the mysql 5.7 the script somehow failed and we have
> landed to a point where only from 30.000 books only 2 books landed to the
> book_metadata.  and we don't have  now the original column marcxml in
> biblioitems  :(
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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] After Upgrade no biblio_metadata and mo marcxml

[Josef Moravec]

Hello,

just reload db from backup, then set mysql according to this guide:
https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7

then you can update your database structure and everything should be ok

regards
Josef

út 1. 8. 2017 v 9:08 odesílatel gevos  napsal:

> Overyesterday We have updated ubuntu server and the koha was updated too.
> Apparently because of the mysql 5.7 the script somehow failed and we have
> landed to a point where only from 30.000 books only 2 books landed to the
> book_metadata.  and we don't have  now the original column marcxml in
> biblioitems  :(
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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] Having two servers for Koha - Database and Application server

[Josef Moravec]

Hello Admire,

the only difference is in koha-create step:

https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-create

use request-db and populate-db parameters

regards

Josef

čt 23. 2. 2017 v 7:52 odesílatel Admire Mutsikiwa 
napsal:

> Hi
>
>
>
> I would like to enquire if it is possible to implement Koha on two servers
> ,
> with one server as the Database server running Mysql Database and another
> as
> the application server running Koha. I will appreciate any pointers on how
> to have such a setup/
>
>
>
> Kind Regards,
>
>
>
> Admire Mutsikiwa (Mr)
>
> ICT Manager
>
> Libraries
>
> University of Zimbabwe
>
> Tel:+263-4-303276 <+263%204%20303%20276>
>
> Mob:+26377111 <+263%2077%20111%20>
>
>
>
> "It is easy to dodge our responsibilities, but we cannot dodge the
> consequences of dodging our responsibilities."  Josiah Charles Stamp
> 
>
>
>
> ___
> 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] Storage engine type pending_offline_operations

[Josef Moravec]

Hello Barry,
there is only one mention on choosing the MyISAM engine as I know: in
kohastructure.sql

-- this table is MyISAM, InnoDB tables are growing only and this table is
filled/emptied/filled/emptied...
-- so MyISAM is better in this case

Regards

Josef Moravec



út 24. 1. 2017 v 14:55 odesílatel Barry Cannon <b...@interleaf.ie> napsal:

> Hi,
>  Does anyone have know why pending_offline_operations is using
> MyISAM as it's storage engine? It seems to be the only table left using
> it.
> It's a small concern when considering database backup procedures -
> table locking specifically. I see some old bugs relating to this table
> but nothing specifically discussing the storage engine.
>
> Thanks##SELECTION_END##
>
>
> --
> Regards
> Barry Cannon
> Interleaf Technology
> web: http://www.interleaf.ie
> ph: +35312865855 <+353%201%20286%205855>
> skype: bar.cannon
>
> ___
> 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] SQL help - Retrieve itemnumbers based on local subject keyword

[Josef Moravec]

Or without subquery:

SELECT i.itemnumber
FROM items i
JOIN biblioitems bi ON i.biblionumber = bi.biblionumber
WHERE
ExtractValue(bi.marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]')
LIKE <>



pá 21. 10. 2016 v 19:26 odesílatel Craig Butosi 
napsal:

> Hi all,
>
> Call of the dogs. A kind soul has recommended the following, and it worked:
>
> SELECT itemnumber
> FROM items
> WHERE biblionumber IN (SELECT biblionumber FROM biblioitems WHERE
> ExtractValue(marcxml, '//datafield[@tag="690"]/subfield[@code>="a"]') LIKE
> <>)
>
> Thanks all,
>
> 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
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Craig
> Butosi
> Sent: October-21-16 12:54 PM
> To: koha@lists.katipo.co.nz
> Subject: [Koha] SQL help - Retrieve itemnumbers based on local subject
> keyword
>
> Hi all,
>
> Koha 16.05.03 on Ubuntu 14.04 LTS (package install)
>
>
> I need to batch modify a subset of records in our db. I have to use
> itemnumbers rather than barcodes to populate the list because not all of
> the records to be modified have a barcode. I've tried the following SQL to
> no avail:
>
> SELECT itemnumber
> FROM items
> WHERE (SELECT biblionumber,
> ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]')
> LIKE <>
>
> As you can see, I need to retrieve item numbers based on a keyword query
> from the 690$a field (MARC21).
>
> Would someone be so kind as to lend a hand?
>
> Much appreciated!
>
> C
>
> 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
>
>
>
> 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.
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> 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.
> ___
> 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] Staff activity report

[Josef Moravec]

Hello,

try this report:

https://wiki.koha-community.org/wiki/SQL_Reports_Library#Librarians_activity

Josef

pá 7. 10. 2016 v 4:22 odesílatel Ma. Victoria H. Silva-Manuel <
mavicsi...@gmail.com> napsal:

> Hi.
> I would like to know how to generate a report that includes each staff
> activities for certain dates.
> Thank you.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 0003892
> ___
> 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] NCIP protocal

[Josef Moravec]

Hello Vikram,

we are using implementation of NCIP based on xcnciptoolkit.

Josef

čt 11. 8. 2016 v 9:54 odesílatel vikram zadgaonkar <
vikramczadgaon...@gmail.com> napsal:

> Dear All,
> I am looking for help in integration of RFID through NCIP with koha, has
> any one did this?
> Vikram Zadgaonkar
> ___
> 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] How to leave null value in SQL Report

[Josef Moravec]

Hello Vimal,

add this statement just before ORDER line

HAVING AccoMaterial != ""

regards

Josef



út 8. 3. 2016 v 6:37 odesílatel Vimal Kumar V.  napsal:

> Dear Friends,
> Here is a report which list books with accompanying materials (field
> 300$e).
> How can I leave null values in 300$e and list only exact values?
>
>
> SELECT
> ExtractValue(marcxml,'//datafield[@tag="300"]/subfield[@code="e"]') AS
> AccoMaterial,
> DATE_FORMAT(items.dateaccessioned, "%d %b %Y %h:%i %p") AS
>
> Date_accessioned,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,ExtractValue(marcxml,'//datafield[@tag="654"]/subfield[@code="a"]')
> AS
>
> SUBJECT,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate
>
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> WHERE items.homebranch=<>
> AND biblioitems.itemtype = <>
> ORDER BY items.barcode ASC
>
>
> Regards,
> --
> Vimal Kumar V.
> Technical Assistant
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.info
> Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://moovandan.blogspot.in
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> 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] Patron Clearance Maintenance in Koha

[Josef Moravec]

Hello Mubasir
could "Discharge" funkcionality in Koha work for your? Did you try it?
It has to be enabled first in "useDischarge" system preference.

Best

Josef

ne 27. 12. 2015 v 3:06 odesílatel Mubassir Ahsan 
napsal:

> Dear Koha Community,
>
> I am working in a private university library where students enrolled for a
> academic session only. Their library enrollment is limited to 4-5 years.
> After this academic year, they have to take library clearance to get their
> certificate. After that time we normally delete their patron records to
> prevent using the library.Till now we are managing the library clearance in
> such way.
> *The problems I am facing is:*
> 1. If we want to generate a library clearance report in every month it is
> very difficult to generate. It is possible but not a clear one.
> 2. Information of Patron with his circulation history got cleared also.
>
> *I have checked following scenarios and possibilities but i didn't find any
> of them appropriate: *
> 1. If we make them *expired*, someone may click on renew to renew them.
> 2. If we *make a note* to their message, Someone may not see the message.
> 3. If we make them *restricted*, They may be unrestricted someone with
> permission.
> *In above cases staff training and maintaining is so much difficult.*
>
> .
> I just wondering if there is any system or menu link like in Patron Detail
> Page > More > *Clearance*. It will be nice.
>
> My application to you that, if that *Clearance *works as :
>
> a. Staff click on the *clearance *link
> b. A page with *clearance *will appear with following options
> 1. Account Summary [If any due, it will show the account link]
> 2. If check out(s) [Show the list of books to be submitted before
> *clearance*]
> 3. Date of expiration [Show the nearest date to be automatically expired]
> 4. *Clearance Button [Only *shown if 1-2 conditions were cleared
> *]*
>
>
> *Activity of clearance button should be: *
> 1. Create a new row in a new table named *clearance*.
> 2. Move all the remaining data from borrowers and activity table (i.e.
> circulation history, modification history) and pasted to the *clearance
> *table.
>
>
>
> It will be very helpful for us if you give me a suggestion regarding this
> simple problem. I am looking forward to your kind attention please.
>
>
>
>
>
>
>
>
> *Best wishes.Md. Mubassir Ahsan*
> BA & MA in ISLM (DU)
> MPhil Researcher (DU)
> *Library Officer (IT)*
> Daffodil International University
> Office Phone: 01811458818
> Email: mubas...@daffodilvarsity.edu.bd
> -
> Website:Sothik.com
>
> *-Mobile+Viber: 01916303060*
> Email: mahsa...@gmail.com
> Facebook: mmahsan 
> Skype: mahsandu
> Twitter: mahsandu
> *"Proud to be a LIS Professional*"
> *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
> Greenstone), N/W Admin, DBA.*
> ___
> 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] Koha 3.12 Installation

[Josef Moravec]

Hello Balaji,

It's because newer version of Koha prefer virtual host  before port based
configuration. If you still wan't/need to use ports, you'll have to edit
the /etc/koha/koha-sites.conf file and set set INTRAPORT to 8080

Josef

po 21. 12. 2015 v 9:38 odesílatel Balaji Ravichandran 
napsal:

> That doesn't work.I have problems while running it on 127.0.0.1:8080 .It
> says server not found
>
>
> On 21 December 2015 at 14:03, Chrispin Simasiku Sitali <
> libsit...@gmail.com>
> wrote:
>
> > Any particular reason you want to install 3.12? Follow these links for
> the
> > recommended way.
> >
> > http://wiki.koha-community.org/wiki/Koha_on_Debian
> >
> > and
> >
> > http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
> >
> > Cheers
> >
> >
> > On 21 December 2015 at 10:28, Balaji Ravichandran 
> > wrote:
> >
> >> Hi,
> >>
> >> Can anyone send the link on how to install Koha 3.12 in CentOS 6.6?
> >> Thank You
> >>
> >>
> >> --
> >> Regards,
> >> Balaji Ravichandran ( பாலாஜி ) ,
> >> Volunteer at Free Software Foundation - Tamilnadu,
> >> Mobile : 9790528505
> >> My Blog - balogic.wordpress.com
> >> ___
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> >
> >
> > --
> > Charles Lwanga College of Education,
> > P. O. Box 660193,
> > Monze,
> > ZAMBIA.
> >
> > Mobile: +26 0979 869471
> > +26 0966 869471
> > SKYPE: Libsitali
> >
>
>
>
> --
> Regards,
> Balaji Ravichandran ( பாலாஜி ) ,
> Volunteer at Free Software Foundation - Tamilnadu,
> Mobile : 9790528505
> My Blog - balogic.wordpress.com
> ___
> 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] Koha Digest, Vol 119, Issue 4

[Josef Moravec]

Helo Nihad,

it is possible, look at the itemBarcodeFallbackSearch system preference

Josef

út 8. 9. 2015 v 23:02 odesílatel NIHAD FAISAL  napsal:

> I am a fresher in Koha and just want to get a solution that, is there any
> option to search by title or author while check out a material? I can see
> only Barcode option for check out.
>
> On Wed, Sep 2, 2015 at 10:16 PM,  wrote:
>
> > Send Koha mailing list submissions to
> > koha@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-requ...@lists.katipo.co.nz
> >
> > You can reach the person managing the list at
> > koha-ow...@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. Translate vs Manual sites (Pablo Bianchi)
> >2. Re: Checkbox «Flagged» on subfield visibility framework
> >   setup (Pablo Bianchi)
> >3. Re: Checkbox «Flagged» on subfield visibility framework
> >   setup (Tomas Cohen Arazi)
> >4. Re: Checkbox «Flagged» on subfield visibility framework
> >   setup (Pablo Bianchi)
> >5. Re: Koha NA user's conference 2016 (Jesse Lambertson)
> >   (BRANNON, CHRISTOPHER)
> >6. Re: Koha NA user's conference 2016 (Jesse Lambertson)
> >   (Jesse Lambertson)
> >7. Re: Global Bug Squashing Day! November 15, 2013 (Kyle Hall)
> >8. Re: Global Bug Squashing Day! November 15, 2013
> >   (Tomas Cohen Arazi)
> >
> >
> > --
> >
> > Message: 1
> > Date: Wed, 2 Sep 2015 09:24:16 -0300
> > From: Pablo Bianchi 
> > To: Koha-org - List 
> > Subject: [Koha] Translate vs Manual sites
> > Message-ID:
> > <
> > cah2zftgxo3eycgikwwr58cogykrt6-td9swzog4ait7v16j...@mail.gmail.com>
> > Content-Type: text/plain; charset=UTF-8
> >
> > Trying luck on this list: ​On "Stable link to latest version of
> > manual" koha-docs
> > list nice people like Nicole, Bernardo and Larry Baerveldt help me and
> > create "current" symlink on manual site. But considering that
> > ​
> > - current/master version of manual are hosted on translate.k-c
> > - those versions are far nicer than manual.k-c ones
> > - when you type *manual koha somthingelse* on Google always retrieve
> > manual.k-c, and always very old versions,
> > So I:
> > - wonder why manual.k-c exists
> > - suggest to put a robots.txt on both sites to keep robots out of older
> > versions, or at least encourage the use of *master/current* versions.
> >
> > Regards!
> > Pabl
> > ​o
> >
> > PS: BTW, I wonder if serivces like readthedocs.org gitbook.com could
> make
> > all those tasks easyer.
> >
> >
> > On Thu, Mar 26, 2015 at 3:06 PM, Pablo Bianchi 
> > wrote:
> >
> > > 2015-03-26 13:06 GMT-03:00 Bernardo Gonzalez Kriegel <
> > bgkrie...@gmail.com>
> > > :
> > >
> > >> Current versions can be found at
> > >>
> > >> master
> > >> http://translate.koha-community.org/manual/master/en/
> > >> http://translate.koha-community.org/manual/master/en/html-desktop/
> > >>
> > >
> > > ​
> > > Would be really great having those much more pretty HTML versions of
> the
> > > manual on manual.koha-community.org!
> > > Even better would be if looked good on cellphones :P
> > >
> > >
> > >
> >
> >
> > --
> >
> > Message: 2
> > Date: Wed, 2 Sep 2015 09:54:57 -0300
> > From: Pablo Bianchi 
> > To: Tomas Cohen Arazi 
> > Cc: koha 
> > Subject: Re: [Koha] Checkbox «Flagged» on subfield visibility
> > framework setup
> > Message-ID:
> > 

Re: [Koha] Report for titles with all copies checked out

[Josef Moravec]

Hello Caitlin,

I've just tried to write an SQL which meets your needs and I think
something like this should work for you:

select b.biblionumber, b.title, b.author, SUM(IF(i.onloan is null, 1, 0))
as available
FROM biblio b
JOIN items i
ON b.biblionumber = i.biblionumber
GROUP BY b.biblionumber
HAVING available = 0

Josef

ne 23. 8. 2015 v 14:12 odesílatel Caitlin Kleinpaste kleinpas...@xenos.org
napsal:

 I've seen the report that gives you all checked out books, but I then have
 to go through each title and see if we have any copies that are not checked
 out.

 I've also seen the one that tells you books with copies on hold, but our
 patrons tend to do a lot of dropping in to see if we have something rather
 than placing holds.

 I'm just wondering if someone has written a report that is not on the SQL
 Reports Library that finds titles with every copy checked out.  If not, I
 may try writing one, but I've never written a report before so I thought
 I'd try this first.

 Thanks,
 Caitlin Kleinpaste


 On Fri, Aug 21, 2015 at 7:38 PM, Indranil Das Gupta indr...@gmail.com
 wrote:

  Hi Caitlin,
 
  On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste
  kleinpas...@xenos.org wrote:
   We're trying to get an idea of books that we might need more copies of,
  and
   so want to get a list of all the titles we have that all copies are
  checked
   out.
  
   Has anyone written a report like this?  If so, could you send it to me?
 
 
 
 http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_Checked_Out_Books
 
  And while you are at it, also take a look at the other reports :-)
 
  hope this helps,
  -Indranil
 
 
  --
  Indranil Das Gupta
  L2C2 Technologies
 
  Phone : +91-98300-20971
  Blog: http://indradg.randomink.org/blog
  IRC  : indradg on irc://irc.freenode.net
  Twitter : indradg
 
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
  Please exchange editable Office documents only in ODF Format. No other
  format is acceptable. Support Open Standards.
 
  For a free editor supporting ODF, please visit LibreOffice -
  http://www.documentfoundation.org
 
 ___
 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] VuFind and Koha

[Josef Moravec]

Hello Riley, Agnes and all,

we are using VuFind with on the top of Koha.

Riley: do you have configured the ILS driver in VuFind? Thats the place
where statuses are transfered from Koha to VuFind.
We don´t use oai to transfer biblio data, we have just simple script which
uses Koha export.pl, but we use OAI in Koha for other purposes, so we can
make an assistance for you, what is the exact problem?

Agnes: Koha Opac is very good (I really like the user account, for example)
but VuFind gives more flexibility in customizing the catalog, so we can
easily attach external local services (we are in Czech Republic and most
external sources of information does not work for us) - like issuing
ebooks, and using czech cover image database, and so on.

Regards

josef



st 12. 8. 2015 v 23:23 odesílatel Agnes Rivers-Moore a...@hanover.ca
napsal:

 Hi Riley

 If you look here
 https://vufind.org/wiki/installation_status
 you can find other Koha libraries using VuFind.
 Perhaps a direct approach to one of them would get you some help!

 That said, I am curious to know what VuFind offers that would be nice to
 have in Koha?

 Regards,
 Agnes

 On 8/10/15 12:31 AM, Riley Childs wrote:

 There is little documentation on using Koha with VuFind, I am curious if
 anyone is currently using VuFind with Koha and if they can give me some
 guidance. I am currently having issues with VuFind not reflecting holdings
 status. In addition I am struggling to setup the OAI connector for
 automated updates.

 Thanks for your help!

 //Riley


 --

 Riley Childs

 Alumni

 Charlotte United Christian Academy

 Library Services Administrator

 new email: m...@rileychilds.memailto:m...@rileychilds.me

 mobile: +1 (704) 497-2086

 web: http://www.rileychilds.mehttp://www.rileychilds.me/
 http://www.rileychilds.me/

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


 --
 Agnes Rivers-Moore
 CEO / Chief Librarian
 Hanover Public Library
 451 10th Ave,
 Hanover, ON, N4N 2P1

 Tel: 519.364.1420 | Fax: 519.364.1747
 Email: a...@hanover.camailto:a...@hanover.ca | Web: www.hanoverlibrary.ca
 http://www.hanoverlibrary.ca

 Please consider the environment before printing this message or
 attachments.
 Support your library! Could you make a donation, volunteer, or remember us
 in your will?
 ___
 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] Odd check in behaviour, if not checked out items are scanned in.

[Josef Moravec]

Hello,

the check in page is also for activating new items which has the PROC
status and for receiving transfers, so this behavior is feature, not bug I
think.

Josef

pá 3. 7. 2015 v 9:39 odesílatel Indranil Das Gupta indr...@gmail.com
napsal:

 Hi all,

 On the Check In page, it is possible to scan the barcode of a book
 that is NOT checked out to begin with. However, what happens next is a
 little puzzling, the dialog alert div shows - Not checked out
 *but* in the table below of Checked-in items, an entry for the
 scanned item is pushed in. Is this behaviour a bug or there is some
 explanation for this behaviour?

 thanks

 --
 Indranil Das Gupta

 Phone : +91-98300-20971
 Blog: http://indradg.randomink.org/blog
 IRC  : indradg on irc://irc.freenode.net
 Twitter : indradg

 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
 Please exchange editable Office documents only in ODF Format. No other
 format is acceptable. Support Open Standards.

 For a free editor supporting ODF, please visit LibreOffice -
 http://www.documentfoundation.org
 ___
 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] Koha on ubuntu - git

[Josef Moravec]

Yes, thats the right syntax if you want to use 3.16.x.

Regards

Josef




st 1. 7. 2015 v 7:56 odesílatel ubuntu christer.s...@kouvola.fi napsal:

 Thanks for the quick answer. As I am a Koha newbie I would like to study
 Koha
 git in a local demo server. As I have little experience with Git there's a
 lot to learn. If I want to select the 3.16.x branch is this the correct
 syntax: git checkout -b mywork_3.16.x origin/3.16.x





 --
 View this message in context:
 http://koha.1045719.n5.nabble.com/Koha-on-ubuntu-git-tp5845989p5846060.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 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] Koha on ubuntu - git

[Josef Moravec]

What do you need it for?

If you are going to install Koha on production server, you should follow
these instructions http://wiki.koha-community.org/wiki/Koha_on_Debian
Which guides you to install stable 3.20 or oldstable 3.18 version. It does
not make much sense for me to install 3.16 for new production server.

If you are going to install development server, you can install as
mentioned on http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git
and after installation is done, you can use branch 3.16.x in git.

Hope that helps

Josef

út 30. 6. 2015 v 22:25 odesílatel ubuntu christer.s...@kouvola.fi napsal:

 Hi, a simple question (or so I hope). Following the installation
 instructions
 http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git I get the latest
 Koha version 3.21. But is it possible to install Koha 3.16.x version? How
 is
 this achieved? I'm using Ubuntu LXC conainer.



 --
 View this message in context:
 http://koha.1045719.n5.nabble.com/Koha-on-ubuntu-git-tp5845989.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 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] [Koha-devel] [CROSS-POST] does the language sw[itcher really need that much screen real estate?

[Josef Moravec]

The bottom bar is still the best approach, in case it doesn't break
anything...

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14252#c18

best

Josef

On Sun, May 24, 2015 at 5:40 PM, Irma Birchall i...@calyx.net.au wrote:

 Hi Indranil ++

 We vote for b) we switch to the new position on the masthead using the
 patch from 14252
 Nice improvement.

 Thank you.


 With best regards,
 Irma
 --
 Irma Birchall
 CEO  Founder : CALYX information essentials
 Koha LMS and Omeka implementations and professional services
 T: +61 (2) 9437 4848 ~ M: +61 (0) 413 510 717
 i...@calyx.net.au ~ www.calyx.net.au ~ http://koha-community.org/
 For Koha-oz User Group communications join e-list:
 http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-oz

 On 24 May 2015 at 22:35, Indranil Das Gupta indr...@gmail.com wrote:

  Kia ora
 
  On Mon, May 18, 2015 at 11:04 PM, Indranil Das Gupta indr...@gmail.com
  wrote:
   Hi,
  
   The language switcher takes up a lot of space at the bottom. it also
   had issues of being not always visible
   (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11057).
  
   Is there a specific design / UX issue (that I may be unaware of) why
   it is not implemented as a simple drop down from the masthead toolbar?
 
  There is now a new patch which positions the lang chooser at the
  masthead. Users' are being requested to offer their inputs whether:
 
  a) we stick to the way it is currently (at the bottom of the page and
  with UX issues unless the patch from 11057 is applied)
 
  (Reference -
  http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11057)
 
  OR
 
  b) we switch to the new position on the masthead using the patch from
  14252?
 
  (Reference -
  http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14252)
 
  View on 1366x768 pixel resolution -
  http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=39369
 
  View on small mobile device resolution -
  http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=39434
 
  thanks :-)
 
  --
  Indranil Das Gupta
 
  Phone : +91-98300-20971
  Blog: http://indradg.randomink.org/blog
  IRC  : indradg on irc://irc.freenode.net
  Twitter : indradg
 
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
  Please exchange editable Office documents only in ODF Format. No other
  format is acceptable. Support Open Standards.
 
  For a free editor supporting ODF, please visit LibreOffice -
  http://www.documentfoundation.org
  ___
  Koha-devel mailing list
  koha-de...@lists.koha-community.org
  http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
  website : http://www.koha-community.org/
  git : http://git.koha-community.org/
  bugs : http://bugs.koha-community.org/
 
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Barcode generator

[Josef Moravec]

Hello Mary,

we are using gLabels - http://glabels.sourceforge.net/

it's simple, but good enogh for us

If you are using Debian or Ubuntu, you can install it from standard
distribution repository (It's part of Gnome)

Josef

On Tue, May 26, 2015 at 9:08 AM, Mary W. Maina mmaina...@gmail.com wrote:

 Hi good people,

 Am using KOHA v.3.14.I am not very conversant  with the label creator
 module.

 What other open source software would you recommend  to use to generate
 barcodes simply.

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




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need an sql report to count notices

[Josef Moravec]

Hello Saira,

did you check the SQL Reportsd library? Could this report work for you?
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Overdue_Notices_Sent

Josef

On Thu, Mar 12, 2015 at 7:15 AM, Saira Asghar saira.asgha...@gmail.com
wrote:

 Dear All

 Is there any sql report that can count how many notices are being sent in a
 specific period of time?


 --
 *Regards*

 Saira Asghar
 Librarian
 Namal College,
 30-Kilometer Talagang Road,
 Mianwali, Pakistan.
 E-mail: saira.asg...@namal.edu.pk
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] exporting MARC records on mysql conditions

[Josef Moravec]

If you have installed Koha by debian packages, you can use koha-mysql
instance command in linux shell script like this:

biblionumbers = $(echo select biblionumber from biblio where [your
condition] | koha-mysql)

and than you can work variable $biblionumbers, save it in some temporary
file and use it as list for export.pl. There should be a parameter to set
file with biblionumbers as base for export I think...

Josef



On Sat, Jan 31, 2015 at 7:25 AM, Giuseppe Angilella 
giuseppe.angile...@ct.infn.it wrote:

 Hi,

 the online export tool for bibliographic records allows to select records
 in a given range of either biblio number, or item call number, or accession
 date.

 Would it be possible (perhaps via an off-line script) to select records
 fulfilling other constraints? (Say, a full mysql where... condition.)

 If not, would it be possible to extract (single) MARC records by off-line
 invoking export.pl on (single) biblio numbers? (One could have saved a
 list thereof in an auxiliary file, and then iteratively call export.pl
 via some script.)

 Many thanks in advance.

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




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] XML configuration file

[Josef Moravec]

Hello Lal,

you can resolve this issue in your koha-conf (/etc/koha/sites/your
instance/koha-conf.xml)

just insert this line:

use_zebra_facets1/use_zebra_facets

before this line:

/config

at the end of that config file

best regards

Josef Moravec


On Wed, Jan 14, 2015 at 6:48 AM, Lal S lal...@gmail.com wrote:

 We have recently upgraded to 3.18.02.000 and I just noticed the following
 warning found in staff client under About  System Information:

 The use_zebra_facets entry is missing in your configuration file. Falling
 back to legacy facet calculation.

 How to resolve this issue



 *Lal.S B.A ,M.L.I.S.  *
 *Librarian*


 *AIT,Aryanet Institute of TecchnologyVellikad,Mundur,Palakkad-678592.
 *

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




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Digest, Vol 110, Issue 29

[Josef Moravec]

: Digest Footer
 
  ___
  Koha mailing list
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 
 
  --
 
  End of Koha Digest, Vol 110, Issue 29
  *
 
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha



-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] AllowOfflineCirculation question

[Josef Moravec]

Hello Nicole,

as I know, that is for built-in offline circulation client, which can be
accessed from link
http://your-koha-staff-client/cgi-bin/koha/circ/offline.pl

the link is also presented on main page of circulation module


Best regards
Josef Moravec





On Mon, Mar 3, 2014 at 11:36 PM, Nicole Engard neng...@gmail.com wrote:

 Documentation question:

 If I have AllowOfflineCirculation set to allow, then when I go offline
 what URL do I go to to circulate? Or is it the regular URL I always
 used for check in / check out?

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




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] page link problem

[Josef Moravec]

Hello Dan,

have you tried this?
ttp://wiki.koha-community.org/wiki/Koha_as_a_CMShttp://wiki.koha-community.org/wiki/Koha_as_a_CMS

Joseph


On Thu, Oct 24, 2013 at 9:59 AM, Dan danielag...@yahoo.co.uk wrote:

 Hi,

 I am trying to create afew pages for koha library but having some trouble
 with which links to use. Tutorial sites say
 http://test32.intersearch.com.au/cgi-bin/koha/opac-showpage.pl?pageid=FAQ
 
 format while the manual says
 http://YOUR-OPAC/cgi-bin/koha/pages.pl?p=PAGENAME;.

 My problem is, when i use both, it still leads me back to my main opac page
 (page content is not displayed). Using koha 3.12

 Thanks

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




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha themes CCSR and PROG

[Josef Moravec]

Hello Ngueyn,

we are runnig Koha 3.10.4 and the CCSR theme in OPAC and both header and
footer work fine for us. Just to be sure that we all think about the same
thing - we use opaccredits and opacheader system preferences.

Josef Moravec




On Sat, Mar 30, 2013 at 5:13 AM, Quoc Uy nguyenquocuy_1...@yahoo.comwrote:

 I'm checking Opac Koha 3.10 and 3.12 beta2. I found out that, if we use
 theme CCSR (mobile theme, i think), we can't include header and footer (it
 has some CSS error- need fix). So if we want to have header and footer in
 Opac, we must use PROG theme, right? Did anyone try to bring header and
 footer to CCSR theme?


 Best regards!
 Nguyen Quoc Uy
 Admin http://dreamlib.vn  http://vietnamlib.net
 Phone: +79525768182
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha themes CCSR and PROG

[Josef Moravec]

I didn't make any changes, if I remember. You can see it in action here:
http://xmorave2.vserver.cz/

Did you install Koha from Deb packages, or from tarball?


On Sat, Mar 30, 2013 at 8:40 AM, Josef Moravec josef.mora...@gmail.comwrote:


 I didn't make any changes, if I remember. You can see it in action here:
 http://xmorave2.vserver.cz/

 Screenshot from administration is attached.

 Did you install Koha from Deb packages, or from tarball?



 On Sat, Mar 30, 2013 at 8:28 AM, Quoc Uy nguyenquocuy_1...@yahoo.comwrote:

 Did you make some change or import another css code? My opaccredit and
 opacheader work fine with prog, but with ccsr, it doesn't. Can you send me
 your link or images for cheking? Thanks!


 Best regards!
 Nguyen Quoc Uy

 On 30.03.2013, at 11:10, Josef Moravec josef.mora...@gmail.com wrote:


 Hello Ngueyn,

 we are runnig Koha 3.10.4 and the CCSR theme in OPAC and both header and
 footer work fine for us. Just to be sure that we all think about the same
 thing - we use opaccredits and opacheader system preferences.

 Josef Moravec




 On Sat, Mar 30, 2013 at 5:13 AM, Quoc Uy nguyenquocuy_1...@yahoo.comwrote:

 I'm checking Opac Koha 3.10 and 3.12 beta2. I found out that, if we use
 theme CCSR (mobile theme, i think), we can't include header and footer (it
 has some CSS error- need fix). So if we want to have header and footer in
 Opac, we must use PROG theme, right? Did anyone try to bring header and
 footer to CCSR theme?


 Best regards!
 Nguyen Quoc Uy
 Admin http://dreamlib.vn  http://vietnamlib.net
 Phone: +79525768182
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha




 --
 Josef Moravec
 josef.mora...@gmail.com




 --
 Josef Moravec
 josef.mora...@gmail.com




-- 
Josef Moravec
josef.mora...@gmail.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha