Re: [Koha] How to import loans data into Koha?

[Mark Alexander]

Excerpts from Mark Alexander's message of 2017-08-15 19:03:46 -0400:
> Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100:
> > [...] but I was wondering if
> > there is a way to import data on current issues (loans)?  All we really
> > need to import is the item ID, the patron ID and the due-back date.
> 
> I did this by writing a script to convert the loan list generated by
> our our old library system (Mandarin) into a KOC file (Koha Offline
> Circulation File), and then importing that. [...]

I forgot to mention that each row in the the KOC file has a date, but
it is the issue date, not the due-back date.  When Koha imports the
file, it will calculate the due-back dates using the circulation rules
that you should have already defined.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to import loans data into Koha?

[Mark Alexander]

Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100:
> We are migrating records from a few small community libraries (currently
> held as a fancy spreadsheet) into Koha 17.05. I have figured out how to
> migrate the biblio records, items and patron data but I was wondering if
> there is a way to import data on current issues (loans)?  All we really
> need to import is the item ID, the patron ID and the due-back date.

I did this by writing a script to convert the loan list generated by
our our old library system (Mandarin) into a KOC file (Koha Offline
Circulation File), and then importing that.  The KOC file format is
defined here:

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

[Koha] Call for News: August 2017 Newsletter

[kohanews]

I'm collecting news for the August newsletter. Send anything noteworthy to:

k o h a news AT gmail dot com

News criteria:
---

** For events **:
   - Please include dates for past events. If I can't find dates I may 
not add it.
   - Announcements for future events with dates T.B.A. are fine ...Eg., 
Kohacon

   - For past events ,  one month back is the cut-off  .

* News items can be of any length.
* Images are fine
* Anything and everything Koha.
* Submit by the 26th of the month.

If you are working on an interesting project or development related to
Koha, please let me know and I'll include it in the development section.

Thank you!

--
Chad Roseburg
Editor, Koha Community Newsletter

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

Re: [Koha] Search for "see also" records shows NO RESULTS FOUND

[Katrin Fischer]

I have tested the feature and can't get it to work on master. I have 
filed a bug:


*Bug 19122* 
 - 
IncludeSeeFromInSearches is broken

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19122


On 03.08.2017 12:48, Tomas Cohen Arazi wrote:

Did the EmbedSeeFromInSearches syspref get changed?

El jue., 3 de ago. de 2017 1:21 AM, Michael Kuhn 
escribió:


Hi

After an update from Koha 3.20.4 we work on a new host with Debian
GNU/Linux 8 and Koha 17.05.1.

Our catalog contains authority records with "see also" records. For
example the subject "Buchkultur" has a "see also" record "Lesekultur".

On Koha 3.20 it was possible to search the OPAC for subject "Lesekultur"
and thus finding the records with subject "Buchkultur".

In Koha 17.05 it will only find the main authority records, but not the
"see also" records. Thus an OPAC search for "Lesekultur" will find NO
RESULTS here.

Why is that so? We have tried to relink all authorities (using script
"link_bibs_to_authorities.pl"). We have also tried to rebuild the Zebra
index for the authorities, but to no avail.

Are we missing something?

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

Re: [Koha] Restrict access

[fjcosta]

Creating different hierarchies for the cataloged material and assigning each
user permission to access and query (in the case of downloading material of
the digital type) may not make much sense in public libraries. However, it
is very common in business libraries. Would anyone know a way to implement
this functionality to Koha? Thank you in advance for your attention.
FJCosta



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Restrict-access-tp5943311p5943575.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] How to import loans data into Koha?

[Chris Brown]

Gentle Reader,

We are migrating records from a few small community libraries (currently
held as a fancy spreadsheet) into Koha 17.05. I have figured out how to
migrate the biblio records, items and patron data but I was wondering if
there is a way to import data on current issues (loans)?  All we really
need to import is the item ID, the patron ID and the due-back date.

Is there a tool to do this? Or is it a question of populating the issues
table directly? If so, does anyone have a script to do this?

Any pointers gratefully received ...

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

Re: [Koha] batch forgive fines

[Katrin Fischer]

Hi Scott,

at the moment there is no feature for batch editing fines available and 
it would be a tricky one I think.


What you could do: Write a report that gives you all patrons that have 
2.50 and less and include a link directly to the fines tab that opens in 
a new tab/window. Then you can quickly work through the list, quicker 
than using the search function and with less clicks. It will also allow 
you to review each account before waiving the fine to see if there are 
cases that you want to exclude from the list.


Hope this helps,

Katrin


On 15.08.2017 17:21, Scott Owen wrote:

Hi all,

One of my people asked ...

"Can we batch forgive fines $2.50 and less? (Anything larger is a lost book
fee, and I want those to stay) That way everyone will start out at $0.  (If
it's something I can do, I'm happy to, I didn't see it when I was snooping
around)

I saw where I could batch modify an item. I'm going to try that for the
books I've pulled, to mark them as "withdrawn"."


So...is there an easy way to forgive fines under $2.50 for a group of users
??

Thanks ,

-S
___
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] batch forgive fines

[Scott Owen]

Hi all,

One of my people asked ...

"Can we batch forgive fines $2.50 and less? (Anything larger is a lost book
fee, and I want those to stay) That way everyone will start out at $0.  (If
it's something I can do, I'm happy to, I didn't see it when I was snooping
around)

I saw where I could batch modify an item. I'm going to try that for the
books I've pulled, to mark them as "withdrawn"."


So...is there an easy way to forgive fines under $2.50 for a group of users
??

Thanks ,

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

Re: [Koha] Import holds?

[Ian Bays]

Just to add a +1 to your idea of doing it manually if you don't have many.
Not only do you need to construct the holds but get them in the right 
order and handle copies that have been chosen to satisfy a hold but not 
picked up.


On 15/08/2017 13:55, Mark Alexander wrote:

Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:

holds information is stored differently in every ILS and at the moment
there exists no generic tool to import holds into Koha. For a migration
you could try to map the data you get out of Mandarin to the columns in
Koha's reserves table and then use a script or SQL to fill it. It can be
useful to place a few different holds in Koha first to see what data is
required/set by Koha itself.

Thank you.  That makes sense, and I was already thinking of doing
something like this.  But there aren't a large number of holds, and it
might be less time-consuming to enter them manually than to study the
database tables and write the script.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


---
This email has been checked for viruses by AVG.
http://www.avg.com



--
Ian Bays
Director of Projects, PTFS Europe Limited
Content Management and Library Solutions

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

Re: [Koha] Import holds?

[Katrin Fischer]

If you don't have a lot of holds reentering might be the best solution. 
Hope your migration goes well!


Katrin


On 15.08.2017 14:55, Mark Alexander wrote:

Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:

holds information is stored differently in every ILS and at the moment
there exists no generic tool to import holds into Koha. For a migration
you could try to map the data you get out of Mandarin to the columns in
Koha's reserves table and then use a script or SQL to fill it. It can be
useful to place a few different holds in Koha first to see what data is
required/set by Koha itself.

Thank you.  That makes sense, and I was already thinking of doing
something like this.  But there aren't a large number of holds, and it
might be less time-consuming to enter them manually than to study the
database tables and write the script.


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

Re: [Koha] Koha Perl script for re-indexing

[Katrin Fischer]

Hi Admire,

I think you could maybe write a plugin to achieve this, but at the same 
time I would strongly recommend figuring out the source of your problem 
as this should not be necessary. Could it be that the permissions on the 
index files are not correct? I notice you are using the rebulid_zebra.pl 
script instead of using the package command

koha-rebuld-zebra -f 

Hope that helps,

Katrin

On 12.08.2017 07:32, Mr Mutsikiwa Admire wrote:

Hi

I have three instances of Koha system  that have been upgraded to Koha 
17.05 that are giving issues with re-indexing and have to manually run 
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -v -b -x -r  to 
recreate a full index.


 I am thinking of having a script that will be accessible to 
superlibrarian via a link in the Koha staff interface that when 
clicked will run the command above. Any pointers on what  I may have 
to do to achieve that would be greatly appreciated.




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

Re: [Koha] Import holds?

[Mark Alexander]

Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:
> holds information is stored differently in every ILS and at the moment 
> there exists no generic tool to import holds into Koha. For a migration 
> you could try to map the data you get out of Mandarin to the columns in 
> Koha's reserves table and then use a script or SQL to fill it. It can be 
> useful to place a few different holds in Koha first to see what data is 
> required/set by Koha itself.

Thank you.  That makes sense, and I was already thinking of doing
something like this.  But there aren't a large number of holds, and it
might be less time-consuming to enter them manually than to study the
database tables and write the script.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Restrict access

[Tomas Cohen Arazi]

I wouldn't propose such a thing!
What I meant is a permissions checking layer for UploadedFile(s), be it
borrower category-wise or similar.

El mar., 15 ago. 2017 a las 9:20, Marcel de Rooy ()
escribió:

> Not sure if muffling AgeRestriction into UploadedFiles is a good idea. A
> solution to restrict access to uploads for selected users should be broader
> than that imo.
>
> Marcel
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Restrict access

[Tomas Cohen Arazi]

That'd be an interesting feature for someone to sponsor.

It would require doing permission checks in Koha::UploadedFile(s).

El mar., 15 de ago. de 2017 7:26 AM, Katrin 
escribió:

> Hi,
>
> using Agerestriction is a good idea, but at the moment it will only
> prevent Circulation. Koha doesn't have a mechanism to control access to
> linked files. As Eric pointed out there are several problems to consider
> there and it will require an external solution to Koha.
>
> Hope that helps,
>
> Katrin
>
>
> On 14.08.2017 16:29, Lennon Mazonde wrote:
> > Hi,
> >
> > As Eric said, i don't know if you can filter out search results for
> > certain patrons in the OPAC.
> >
> > What if you try enabling the AgeRestrictionMarker
> > <
> http://translate.koha-community.org/manual/sphinx-branch/en/html/02_administration.html?highlight=agerestriction#AgeRestrictionMarker
> >system
> > preference under Home › Administration › System preferences >
> > Circulation Preferences > Checkout Policy? You can then place an age
> > restriction in field 521$a (Audience note) for each item that you plan
> > on setting age restrictions. Does that stop patrons from being able to
> > download the files?
> >
> > Kind regards,
> >
> > Lennon
> >
> >
> > On 13/08/2017 22:03, fjcosta wrote:
> >> Thank you Lennon.
> >> I did as you told: three types of patrons and three kinds of items, and
> >> under Circulation and Fine rules I manage to restric each type of
> >> patron to
> >> its item permission (basic to basic, intermediate to
> >> basic+intermediate, and
> >> advanced to all).
> >> But when a reader under patron type basic makes a search in OPAC, all
> >> material (basic, intermediate and advanced) is visible and, if is a PDF
> >> files, he can download and read it.
> >> Would you please consider help me in this issue?
> >>
> >>
> >>
> >>
> >> --
> >> View this message in context:
> >>
> http://koha.1045719.n5.nabble.com/Restrict-access-tp5943311p5943320.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
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Import holds?

[Katrin Fischer]

Hi Mark,

holds information is stored differently in every ILS and at the moment 
there exists no generic tool to import holds into Koha. For a migration 
you could try to map the data you get out of Mandarin to the columns in 
Koha's reserves table and then use a script or SQL to fill it. It can be 
useful to place a few different holds in Koha first to see what data is 
required/set by Koha itself.


Hope this helps,

Katrin


On 11.08.2017 16:23, Mark Alexander wrote:

Our little (24K items) library has successfully moved from Mandarin to
Koha as of Tuesday.  I was able to import the catalog, patrons, and
checkouts (issues) from Mandarin by writing scripts to convert
Mandarin-generated data to Koha-compatible data.

The one missing thing is holds (reserves).  I'm still looking for a
way to generate a holds report in Mandarin, but assuming I can
generate such a report, I don't see a way to import hold information
into Koha.  I was able to use KOC files to import issues, but the KOC
file format doesn't support holds.  I was wondering if there is some
other way to import holds programmatically, or if anyone else has had
to deal with this problem when migrating to 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] Restrict access

[Katrin]

Hi,

using Agerestriction is a good idea, but at the moment it will only 
prevent Circulation. Koha doesn't have a mechanism to control access to 
linked files. As Eric pointed out there are several problems to consider 
there and it will require an external solution to Koha.


Hope that helps,

Katrin


On 14.08.2017 16:29, Lennon Mazonde wrote:

Hi,

As Eric said, i don't know if you can filter out search results for 
certain patrons in the OPAC.


What if you try enabling the AgeRestrictionMarker 
system 
preference under Home › Administration › System preferences > 
Circulation Preferences > Checkout Policy? You can then place an age 
restriction in field 521$a (Audience note) for each item that you plan 
on setting age restrictions. Does that stop patrons from being able to 
download the files?


Kind regards,

Lennon


On 13/08/2017 22:03, fjcosta wrote:

Thank you Lennon.
I did as you told: three types of patrons and three kinds of items, and
under Circulation and Fine rules I manage to restric each type of 
patron to
its item permission (basic to basic, intermediate to 
basic+intermediate, and

advanced to all).
But when a reader under patron type basic makes a search in OPAC, all
material (basic, intermediate and advanced) is visible and, if is a PDF
files, he can download and read it.
Would you please consider help me in this issue?




--
View this message in context: 
http://koha.1045719.n5.nabble.com/Restrict-access-tp5943311p5943320.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


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