Re: [Koha] Kohacon16 - live streaming and videos

[Heather Braum (NEKLS)]

Yes, thank you for sharing this information!

-Heather
On Mon, May 30, 2016 at 8:36 PM Decka David 
wrote:

> Thank you for sharing this information
>
> Decka David
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of David
> Nind
> Sent: Tuesday, May 31, 2016 7:03 AM
> To: koha@lists.katipo.co.nz
> Subject: [Koha] Kohacon16 - live streaming and videos
>
> A really BIG thank you to the kohacon16 team in Thessaloniki, Greece for
> providing live streaming and videos of the conference.
>
> To watch the live streaming (when the conference is in session):
> http://kohacon2016.lib.auth.gr/
>
> The programme:
> http://kohacon2016.lib.auth.gr/?page_id=2417
>
> To see the videos available (Day 1 videos are now available):
> http://www.livemedia.com/kohacon16
>
> Twitter search #kohacon16:
> https://twitter.com/hashtag/kohacon16?f=tweets=default=hash
>
> Blogs from Chris Cormack:
> http://blog.bigballofwax.co.nz/
>
>
> David Nind | david.n...@gmail.com
> PO Box 12367, Thorndon, Wellington, New Zealand 6144 m. +64 21 0537 847 |
> w. +64 4 8906 098 ___
> 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
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] NEKLS Job opportunity for NExpress Coordinator and ILS Systems Manager

[Heather Braum (NEKLS)]

Last call for applicants. NEKLS will begin reviewing applications after
April 15.

The Northeast Kansas Library System  (NEKLS) in
Lawrence,
KS , has an opening and we’re looking for a
diplomatic applicant with lots of energy, enthusiasm, and excellent custom
service skills to come work with us!

*NExpress Coordinator and ILS Systems Manager*: Opportunity for a creative
librarian who will enjoy the challenge of managing a large regional shared
consortia catalog, with 42 public libraries and 1 school district (public
catalog ). The system runs on the Koha
ILS , an open source ILS used all over the
world.

Responsibilities include:

   - Providing overall management, support, and coordination of the
   NExpress ILS and consortia, including balancing needs of consortia with
   local library needs
   - Coordinating operations of NExpress team
   - Maintaining data quality of NExpress records and database
   - Coordinating with participating libraries and ILS support vendor
   regarding system features and bugs, migrations, upgrades, and software
   developments
   - Providing NExpress training to participating libraries, including
   planning & leading quarterly NExpress users group meetings
   - Participating in the international Koha community

Qualified candidates will meet the following:

   - MLS degree preferred and 3 or more years of prior library experience
   is required.
   - Experience with integrated library automation system software is
   required.
   - Knowledge of cataloging best practices, database management (MySQL),
   web languages (HTML, CSS, JQuery), web CMS platforms (WordPress and
   LibGuides) is highly preferred.

See the full job description, including qualification list
,
for more information (
http://nekls.org/wp-content/uploads/2016/03/NExpress-Coordinator-Job-Description.pdf
).

Excellent salary ($50,000-$53,000) and benefits package, including complete
health, dental, and vision coverage (single and family), short-term and
long-term disability insurance, and retirement options. Position is open
until filled.

Evaluation of applications will begin on April 15, 2016 and will continue
until position is filled. Estimated start date is on or around July 1, 2016.

For questions, please contact Laura DeBaun, NEKLS Director, at
ldeb...@nekls.org.

Apply with cover letter, resume and references list by emailing Carolyn
Little, Courier Coordinator, at clit...@nekls.org. Please use the subject
line NExpress Coordinator Job Application. NEKLS is an equal opportunity
employer.
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] Kylie Brice Hall

[Heather Braum (NEKLS)]

Congratulations Kyle, Chelsea, and Daria and and welcome Kylie!!!
On Fri, Mar 18, 2016 at 11:53 AM Nick Clemens 
wrote:

> Amazing!
>
> On Fri, Mar 18, 2016, 12:19 PM Todd Goatley <
> todd.goat...@bywatersolutions.com> wrote:
>
>> So awesome Kyle! He's a beauty!
>>
>> Todd
>>
>>
>> On Fri, Mar 18, 2016 at 6:34 AM, Kyle Hall 
>> wrote:
>>
>>> Sent from my phone. Please excuse my brevity.
>>> On Mar 18, 2016 9:31 AM, "Kyle Hall"  wrote:
>>>
 Kylie Brice Hall was born at 8:41 am in Erie, Pennsylvania. Weight of 9
 pounds 11 ounces.

 Sent from my phone. Please excuse my brevity.

>>>
>> ___
> 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/

-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL report help

[Heather Braum (NEKLS)]

Kerrie,

Are you just wanting count of items per collection code at a set branch?
And no other information displayed? If so, try

SELECT items.ccode, count(items.itemnumber)
FROM items
WHERE items.homebranch=<>
GROUP BY items.ccode

That should get you what you are you looking for, if I'm understanding what
you're after correctly. Here's a quick breakdown of above report, if you're
interested:
SELECT line = the data columns you're going to display in the report.
(ccode, counting something)
FROM = the table where the data is going to come from (items)
WHERE = your criteria (limiting to a branch parameter)
GROUP BY = How your data is grouped (in this case by collection code)

Hope that helps.



Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*




On Wed, Mar 9, 2016 at 11:46 PM, Kerrie Stevens 
wrote:

> I'm trying to get a report to show the number of items in each collection
> code according to the branch selected. I've looked in the reports library
> but can't find anything that is exactly right. I've tried to mix'n'match
> bits from a few reports but I keep getting an error message about syntax.
>
> This is what I have so far:
> SELECT
> items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title,
> biblio.copyrightdate
> COUNT( i.barcode ) AS  "Count"
> FROM items
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> WHERE items.homebranch=<>
> ORDER BY items.dateaccessioned DESC
>
> Any help, much appreciated.
> Thank you
>
> Kerrie
> Harvest Bible College
> ___
> 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] Report includes renewals?

[Heather Braum (NEKLS)]

It does -- see in the WHERE clause:
 WHERE s.type IN ('issue','renew')

-Heather

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*




On Wed, Mar 9, 2016 at 9:19 AM, Christopher Davis 
wrote:

> Dear Colleagues,
>
> I need to know whether or not the "Circulation numbers in a time frame
> for all itemtypes, per branch" report found at
> <
> https://wiki.koha-community.org/wiki/SQL_Reports_Library#Circulation_numbers_in_a_time_frame_for_all_itemtypes.2C_per_branch
> >
> includes renewals. Will someone please confirm this either way for me?
>
> TIA,
>
> Christopher Davis, MLS
> Systems & E-Services Librarian
> Uintah County Library
> cgda...@uintah.utah.gov
> (435) 789-0091 ext.261
> uintahlibrary.org
> basinlibraries.org
> facebook.com/uintahcountylibrary
> ___
> 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] NEKLS Job posting for NExpress Coordinator and ILS Systems Manager

[Heather Braum (NEKLS)]

The Northeast Kansas Library System  (NEKLS) in
Lawrence,
KS , has an opening and we’re looking for a
diplomatic applicant with lots of energy, enthusiasm, and excellent custom
service skills to come work with us!

*NExpress Coordinator and ILS Systems Manager*: Opportunity for a creative
librarian who will enjoy the challenge of managing a large regional shared
consortia catalog, with 42 public libraries and 1 school district (public
catalog ). The system runs on the Koha
ILS , an open source ILS used all over the
world.

Responsibilities include:

   - Providing overall management, support, and coordination of the
   NExpress ILS and consortia, including balancing needs of consortia with
   local library needs
   - Coordinating operations of NExpress team
   - Maintaining data quality of NExpress records and database
   - Coordinating with participating libraries and ILS support vendor
   regarding system features and bugs, migrations, upgrades, and software
   developments
   - Providing NExpress training to participating libraries, including
   planning & leading quarterly NExpress users group meetings
   - Participating in the international Koha community

Qualified candidates will meet the following:

   - MLS degree preferred and 3 or more years of prior library experience
   is required.
   - Experience with integrated library automation system software is
   required.
   - Knowledge of cataloging best practices, database management (MySQL),
   web languages (HTML, CSS, JQuery), web CMS platforms (WordPress and
   LibGuides) is highly preferred.

See the full job description, including qualification list
,
for more information (
http://nekls.org/wp-content/uploads/2016/03/NExpress-Coordinator-Job-Description.pdf
).

Excellent salary ($50,000-$53,000) and benefits package, including complete
health, dental, and vision coverage (single and family), short-term and
long-term disability insurance, and retirement options. Position is open
until filled.

Evaluation of applications will begin on April 15, 2016 and will continue
until position is filled. Estimated start date is on or around July 1, 2016.

For questions, please contact Laura DeBaun, NEKLS Director, at
ldeb...@nekls.org.

Apply with cover letter, resume and references list by emailing Carolyn
Little, Courier Coordinator, at clit...@nekls.org. Please use the subject
line NExpress Coordinator Job Application. NEKLS is an equal opportunity
employer.
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Bibliocommons + Koha?

[Heather Braum (NEKLS)]

Rebecca, I've had a couple of conversations with someone at Bibliocommons
over the past couple of years, as several of the large urban libraries in
our region have implemented Bibliocommons. The response has always been (so
far) that Bibliocommons doesn't yet work with Koha, and we would have to
fund a connector to make that happen. (Which has been cost prohibitive...)

So unless something has changed since October 2015, Bibliocommons still
doesn't work with Koha.

On Mon, Jan 25, 2016 at 1:10 PM Rebecca Crago 
wrote:

> Hi all,
>
> Are any of you using Bibliocommons with Koha for discovery? I am curious
> to know how implementation worked and what your overall satisfaction is
> with the results.
>
> Cheers,
>
> Rebecca Crago
> Website Librarian | Westbank Library
> ☏ 512.381.1407
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Holds Queue Idea for Patrons

[Heather Braum (NEKLS)]

Has anything like this idea ever been proposed for Koha? A Netflix-like
holds queue that patrons can set up?

https://alissadale.wordpress.com/2011/10/03/i-want-a-library-book-queue/

It was suggested on our statewide Tech group, and I was intrigued enough by
the idea that I thought I'd inquire...

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Expiring soon borrower notice?

[Heather Braum (NEKLS)]

Agnes, I think this would be a great idea! Would you post a bug number when
you get it filed? We are running into this in our consortia with people who
only use the computers and authenticate against the database for computer
access, as well as digital content.

-Heather

On Wed, Dec 2, 2015 at 2:36 PM Agnes Rivers-Moore  wrote:

> Dear Koha users and developers
>
> We have a number of members (patrons) who only borrow e-books.
> This means staff do not see them and they do not get reminded that their
> membership will expire - until they call to complain that their downloads
> stop working.
>
> I would like Koha to generate a notice to let them know that they will
> need to renew soon - similar to the book is due soon notice but based on
> expiry of the borrower account.
>
> That would allow us to tell them whet they need to do to renew their
> account before their service is affected, and also tell them about new
> services/reasons to renew.
>
> Has anyone found a way to do that - or is anyone thinking of developing a
> new notice for this?
> If not, I will add a new item to Bugzilla - watch there if you want to
> follow developments.
>
> Many thanks,
> Agnes
>
> --
> 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.ca | Web: www.hanoverlibrary.ca<
> http://www.hanoverlibrary.ca>
> Facebook Hanover Public Library | Twitter @HanoverLibrary
>
> Support your library! Could you volunteer, make a donation, or remember us
> in your will?
> The Hanover Library uses email to communicate service messages to members
> who provide an address during registration or who contact us by email.
> Please contact the library to change your email preferences.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Few general Koha questions

[Heather Braum (NEKLS)]

I can help on #3 -- you can write a custom SQL report through the reports
module that returns all bibs and then has a column that has a link directly
to the item editor...

This should work -- it will return all records that don't have items
attached and include a direct link to the add item editor that opens in a
new tab; every time you rerun the report, any record that has an item
attached will not be returned.

SELECT biblio.biblionumber, CONCAT(''"add
item"'') as "add item" FROM biblio LEFT JOIN items USING(biblionumber)
WHERE items.itemnumber IS NULL LIMIT 5000

By the way, that 5000 limit number can be whatever you want it to be -- the
default screen return is 20 rows, although there's dropdown options to set
it up to 1000 rows returned at a time.

Good luck.

On Wed, Dec 2, 2015 at 1:20 PM Aparrish  wrote:

> Hello all,
>
> Busy configuring a new Koha installation and I'm just going to list a bunch
> of questions I have. I am struggling a bit with the manual and I haven't
> had
> any luck searching the archives. Pick a topic!
>
> 1. When patron self-registration is enabled, there are a number of
> necessary
> fields I can't get to show up, namely, userid, password, and cardnumber
> (The
> project I am working on requires people to fill out their own card number -
> they will be unique.) These fields are however accessible from the same
> patron template when an account is created on the staff side by
> superlibrarian. Any thoughts?
>
> 2. Is there any way, after having imported a batch of records, to
> auto-generate an item for each record in the batch? I do not have time to
> search, by name, for each record in a 5000+ item library and create an item
> for it.
>
> 3. Following on question 2, is there any way to force the staff interface
> to
> just display every record in the catalog so that if I do have to add each
> item manually I can at least do it faster?
>
> Cheers. Thanks for your help.
> Andrew
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Few-general-Koha-questions-tp5863627.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
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Expiring soon borrower notice?

[Heather Braum (NEKLS)]

Katrin -- thank you! I haven't had a chance to look through the release
notes yet. Good to know.

On Wed, Dec 2, 2015 at 2:52 PM Katrin Fischer <katrin.fischer...@web.de>
wrote:

> Hi Heather and Agnes,
>
> good news - a new feature to send membership expiry notices was released
> with Koha 3.22 :)
>
> Bug 6810 - Send membership expiry reminder notices
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6810
>
> Hope this helps,
>
> Katrin
>
>
> Am 02.12.2015 um 21:43 schrieb Heather Braum (NEKLS):
> > Agnes, I think this would be a great idea! Would you post a bug number
> when
> > you get it filed? We are running into this in our consortia with people
> who
> > only use the computers and authenticate against the database for computer
> > access, as well as digital content.
> >
> > -Heather
> >
> > On Wed, Dec 2, 2015 at 2:36 PM Agnes Rivers-Moore <a...@hanover.ca>
> wrote:
> >
> >> Dear Koha users and developers
> >>
> >> We have a number of members (patrons) who only borrow e-books.
> >> This means staff do not see them and they do not get reminded that their
> >> membership will expire - until they call to complain that their
> downloads
> >> stop working.
> >>
> >> I would like Koha to generate a notice to let them know that they will
> >> need to renew soon - similar to the book is due soon notice but based on
> >> expiry of the borrower account.
> >>
> >> That would allow us to tell them whet they need to do to renew their
> >> account before their service is affected, and also tell them about new
> >> services/reasons to renew.
> >>
> >> Has anyone found a way to do that - or is anyone thinking of developing
> a
> >> new notice for this?
> >> If not, I will add a new item to Bugzilla - watch there if you want to
> >> follow developments.
> >>
> >> Many thanks,
> >> Agnes
> >>
> >> --
> >> 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.ca<mailto:a...@hanover.ca> | Web:
> www.hanoverlibrary.ca<
> >> http://www.hanoverlibrary.ca>
> >> Facebook Hanover Public Library | Twitter @HanoverLibrary
> >>
> >> Support your library! Could you volunteer, make a donation, or remember
> us
> >> in your will?
> >> The Hanover Library uses email to communicate service messages to
> members
> >> who provide an address during registration or who contact us by email.
> >> Please contact the library to change your email preferences.
> >> ___
> >> 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
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Using Koha to manage equipment loans

[Heather Braum (NEKLS)]

Elaine, you could setup a collection code that all the equipment is housed
under, and then use the OpacHiddenItems sys pref to hide that collection
code. That's a possible easy solution... You could also set up a separate
branch and hide it from the public using the same sys pref.

-Heather


On Mon, Sep 28, 2015 at 1:12 PM Elaine Bradtke  wrote:

> We have several laptops, cameras and recording equipment that various
> members of staff use, take off site, etc. The current method of keeping
> track of them is inadequate, and I proposed that we use Koha for checking
> them in and out, placing holds,  tracking use, etc;  all functions Koha can
> do.
>
> We don't want the equipment to appear in the public catalogue, and I don't
> want non-library staff poking around in the nether regions of the library
> catalogue. But I also don't want the library staff to be burdened with
> keeping track of equipment that belongs to and is generally used by another
> department.
>
> I'd like to hear how other libraries have handled this.
>
>  I am considering setting up another branch, just for equipment.  Would it
> be easy to limit access to one branch but keep the main collection open for
> all? Or would I have to set up a completely different Koha installation?
> Our test site for instance is completely separate, limited to a couple of
> IP addresses, and the OPAC requires a login - something like that would
> work for equipment.
>
> --
> Elaine Bradtke
> Data Wrangler
> 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 (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
>
-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Can I limit the opac to see only the main library?

[Heather Braum (NEKLS)]

Tim, you can use the  OpacHiddenItems sys pref to hide items that match a
specific setting you set up.

I've used it to hide items from entire branches during the summer, while
schools are closed, to hide items with specific item types or collection
codes, or to hide items matching other fields.

Examples:

ccode: [ILL]
homebranch: [PHWAC]

The wiki has more info on this sys pref:
http://wiki.koha-community.org/wiki/OpacHiddenItems

That way you can hide by itype, homebranch, or however else you want to
hide these specific items from your OPAC. If you ever decide you want these
items to be seen again, you just remove the setting line in the sys pref.

Hope that helps!

-Heather


On Fri, Sep 11, 2015 at 9:52 AM Tim Koop  wrote:

> We have a group of books that only certain people are allowed to check out.
>
> At first we were thinking of giving these books a different Item Type, but
> maybe
> they should exist in their own new Library. I think making a new library
> is a
> better plan.
>
> But what about the opac? We don't want them showing up there at all,
> because
> regular patrons won't be able to sign them out.
>
> Is it possible to limit the opac to see only the main library?
>
> Thanks.
>
> --
> Tim
> ___
> 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] Record matching rules setup for the 024

[Heather Braum (NEKLS)]

Cecil, For the search index, try Identifier-standard instead of
identifier-other and see if that works. Also, I didn't use a normalization
rule.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Mon, Dec 15, 2014 at 4:40 PM, Hillyard, Cecil chilly...@washoecounty.us
wrote:

 Hello,
 I've been trying to set up record matching rules for the 024  using the
 following :
 Match point 1
 1. Search index: Identifier-other
 2. Score: 1000
 Matchpoint components
 1. Tag: 024
 2. Subfields: a
 3. Offset: 0
 4. Length: 0
 5. Normalization rule: Identifier-other

 However, it does not work.  Records I am importing do not find matches and
 I know that some of the records in the small batch of records I am trying
 to import do have the same 024s.

 We are on Koha 3.16.03
 _
 Cecil Hillyard
 Technical Services-- Cataloger
 Washoe County Library
 Reno, NV  89501
 https://library.washoecounty.ushttps://library.washoecounty.us/


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

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

Re: [Koha] Catalogue - SQL Report Help

[Heather Braum (NEKLS)]

I find the guided reports wizard, frankly, to be very unhelpful, especially
since I work with 50 branch locations in our consortia. I usually write my
own custom reports, as a result, for much more granular control.

To get this kind of data you gave as an example, you have to query and join
three tables together -- biblio table has the author and title info, the
biblioitems table has the edition, publisher, and isbn (will return up to
30 characters; there's something different you have to use in your query if
you want the full isbn), and then the total items count comes from also
querying the items table.

The SQL statement will look like this:

SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement,
t.publishercode, t.isbn, count(i.itemnumber) FROM biblio b LEFT JOIN
biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber)
GROUP BY b.biblionumber

Does this statement give you what you are looking for?

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Wed, Dec 10, 2014 at 11:27 AM, Elaine Bradtke e...@efdss.org wrote:

 You have discovered one of the quirks of the system. For biblios with
 multiple items it will produce the same information (title, etc.) for each
 item.  I don't know how to work around that. Maybe someone else does?

 Elaine

 On Wed, Dec 10, 2014 at 5:12 AM, SATISH lis4sat...@gmail.com wrote:

  Hi,
 
  I would like to have report for the entire library collections as
  indicated below:
 
 
 --
  Biblio| Biblio  Record (title) | Author | edition | publisher | ISBN
  | Holdings ( no. of copies)
  Number
  count
 
 
 --
 
  example:
 
  1  Brief history of timeHawkings.2nd ed.oxford(paper
  back)10
  2  Brief history of timeHawkings3rd ed.oxford  (paper
  back)5
  3  Brief history of timeHawkings2nd ed.Oxford  (hard
  bound)  2
  4  Complete reference- C++
50
  5  Basic electrical engineering...
 30
 
 
 
 --
 
  For example, One record is having 10 items, and when I tried to use
 guided
  reports wizard, it fetches and display, 10 times the same records. I
 wanted
  to get only one title on behalf of 10 items. I meant, non-repetative
  records ( titles) from the entire library collections. (and exceptions
 for
  change in edition, ISBN, different title).
 
 
  And secondly,
  the same report as per the collection code, which means,
  list of unique records in each collection (isbn, change in edition, etc
  are exceptions).
 
  Thank you in advance.
 
  Satish MV
  Librarian
  Govt. Engineering College, Hassan.
  Karnataka.
  INDIA.
  +91-9449765737
 
 
 
 
  On Mon, Dec 8, 2014 at 11:22 PM, Elaine Bradtke e...@efdss.org wrote:
 
  More information may help.
 
  all unique titles(biblio records)
  Unique how? different ISBN?  (do they all have ISBN?) Different title?
  Same title different edition?  Only one item record?
 
  Exactly what information would you like to display in the report?
  List of biblio numbers?
  Sorted by collection code?
  or Filtered to show only items with a specific collection code?
 
  It may take a few attempts to make your request clear. I am not an
 expert
  report writer, but once you question is better understood, we may be
 able
  to help.
 
 
  On Fri, Dec 5, 2014 at 6:20 AM, SATISH lis4sat...@gmail.com wrote:
 
  Hi,
 
  Unfortunately, I have not received any help for generating a report on
  following subject and, re-described my problem.
 
  I am looking for a report which has list of all unique titles(biblio
  records) in a home library AND also by collection code.
  When I tried for nearest relevant SQL examples given in wiki,
  it gives me, whole list of items along with biblios records that is not
  useful and I wanted to have information only on unique records
 (titles).
 
  Please advice.
 
  with thanks.
  Satish MV
  Librarian
  Govt. Engineering College, Hassan.
  Karnataka.
  INDIA.
 
  On Tue, Nov 25, 2014 at 4:58 PM, SATISH lis4sat...@gmail.com wrote:
 
   Koha 3.16.00.000 installed via packages method, on ubuntu desktop.
  
   On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar 
   vikramczadgaon...@gmail.com wrote:
  
   Ok. Let me check. I will mail you SQL query.
   Which koha version you are using?
  
   Vikram Zadgaonkar
  
   On Tue, Nov 25, 2014 at 4:20 PM, SATISH lis4sat...@gmail.com
 wrote:
  

Re: [Koha] Catalogue - SQL Report Help (Paul A)

[Heather Braum (NEKLS)]

Kerrie, to select by homebranch, you just need to add a branch parameter,
i.homebranch=choose branch|branches

So the statement will now look like

SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement,
t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT
JOIN
biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber)
WHERE i.homebranch=Choose branch|branches GROUP BY b.biblionumber

In case anyone is interested in learning more, parameters are further
explained on the Koha community wiki (
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters).
There's two basic kinds of parameters (that I at least use a lot with Koha
report writing on my system) -- and you can add multiple parameters to your
reports:

1. Add option to add text manually -- Examples: i.ccode=Enter collection
code OR i.homebranch=Enter homebranch

You then would type the corresponding branchcode or collection code into
the text box when running the report (the two examples mentioned use
branchcode or collection code, but this method works for lots of other
fields in Koha, too)

OR

2. Add option to Choose from dropdown list -- Examples: i.ccode=Choose
collection code|CCODE OR i.homebranch=Choose homebranch|branches
(what you use after the | character may vary a little bit, depending on
what field you're setting up the parameter for).

Hope this helps!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Wed, Dec 10, 2014 at 7:19 PM, Kerrie Stevens kstev...@harvest.edu.au
wrote:

 Hi Paul  Heather,

 The report you developed for Satish below is very helpful, but I'd like to
 tweak it a little differently -  I've tried every variation I can think of
 with no luck (I don't have very much SQL experience)... how can I get it to
 select by branch, rather than collection code?

 SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement,
 t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT
 JOIN
 biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber)
 WHERE i.ccode=Enter collection code GROUP BY b.biblionumber

 Thanks so much for your sharing of this report.

 Kerrie Stevens
 Harvest Bible College
 Melbourne, Australia
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Koha vs Liblime Koha

[Heather Braum (NEKLS)]

Jesse, I don't think anyone intended to come across as rude. There are
still -- and always will be -- very hard feelings over the fork of Koha
several years ago and everything that happened around that time.

Good luck on your install and on your library using Koha.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Thu, Dec 4, 2014 at 3:19 PM, Jesse Lambertson jlambert...@sqcc.org
wrote:

 I am not asking to be rude or that I have any skepticism about anything in
 the community or the current package, this is merely a technical question
 for info's sake. This forum is so helpful to me as I prepare to install.

 I am sorry if I offended anyone.
 I did not mean to do that.

 Thank you,

 Jesse

 On Thu, Dec 4, 2014 at 4:12 PM, Marcel de Rooy m.de.r...@rijksmuseum.nl
 wrote:

   But I was looking at the LibLime version of Koha and wondered, out of
   curiosity, what problems I might run into if I installed their version
   instead of the current stable version as hosted on the community wiki.
 
  You are asking this on the community list?
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 



 --
 Jesse A Lambertson
 Librarian
 Sultan Qaboos Cultural Center
 1100 16th St, NW
 Washington, DC 20036
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Report help needed

[Heather Braum (NEKLS)]

Elaine, try the below. It looks like you were missing some commas -- that
was what was causing the syntax errors; you can then name the columns like
I did below or however you want using as ___ single-word (as 780t) or as
two or more words (as 780w field_).

Make sure every column of data in the select statement has a comma after
it, except for the last on before the from statement.

Hope that helps!  -- it ran on my system.

SELECT
biblio.biblionumber,biblio.title,biblio.notes,biblioitems.publishercode,biblioitems.itemtype,

ExtractValue(biblioitems.marcxml,
'//datafield[@tag=780]/subfield[@code=t]') as 780t,
ExtractValue(biblioitems.marcxml,
'//datafield[@tag=780]/subfield[@code=w]') as 780w field,
ExtractValue(biblioitems.marcxml,
'//datafield[@tag=866]/subfield[@code=a]') as 866a,
ExtractValue(biblioitems.marcxml,
'//datafield[@tag=866]/subfield[@code=z]') as 866z
FROM biblioitems LEFT JOIN biblio USING (biblionumber)
WHERE biblioitems.itemtype='CR'

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Mon, Nov 17, 2014 at 5:38 PM, Elaine Bradtke e...@efdss.org wrote:

 I have a request for a report that is beyond my paltry abilities and that
 of the report builder.


 I have this, and it works (thanks Liz!):
 SELECT

  
 biblio.biblionumber,biblio.title,biblio.notes,biblioitems.publishercode,biblioitems.itemtype
 FROM biblioitems LEFT JOIN biblio USING (biblionumber)   WHERE
 biblioitems.itemtype='CR'

 But I need to add in more columns that involve the MARC XML

 Specifically
 780 t (previous title)
 780 w (previous control no.)
 866 a (holdings)
 866 z (note)
 867 e (source)

 When I try to add in:
   Extract value ExtractValue(marcxml,
 '//datafield[@tag=780]/subfield[@code=t]')
 I manage to break the above query and it complains of syntax errors.
 Does it matter where this Extract phrase comes in?
 How do you handle multiple subfields (780 t and w for instance)
 For that matter, how do you handle multiple fields?  And how can I label
 the columns

 The following (and a few variations on the theme) did not work:

 SELECT

  
 biblio.biblionumber,biblio.title,biblio.notes,biblioitems.publishercode,biblioitems.itemtype
 ExtractValue(marcxml, '//datafield[@tag=780]/subfield[@code=t]')
 ExtractValue(marcxml, '//datafield[@tag=780]/subfield[@code=w]')
 ExtractValue(marcxml, '//datafield[@tag=866]/subfield[@code=a]')
 ExtractValue(marcxml, '//datafield[@tag=866]/subfield[@code=z]')
 FROM biblioitems LEFT JOIN biblio USING (biblionumber)   WHERE
 biblioitems.itemtype='CR'


 As always I am very, very grateful for whatever help you can give.
 Thanks
 --
 Elaine Bradtke
 Data Wrangler
 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 (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
 http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Z39.50 server for children's books

[Heather Braum (NEKLS)]

Paul, take a look at this z39.50 target list on the Koha wiki. I know my
consortia (NEKLS) and the SEKLS consortia may have the kinds
of records you're looking for.

I believe the Koha manual may have more Z39.50 targets in it as well. Look
for public library targets -- those would have the DVD and Christian
fiction records for sure.

http://wiki.koha-community.org/wiki/Koha_Open_Z39.50_Sources

On Friday, October 24, 2014, CTS-Programmer 3 (Paul Dokken) 
cts-pr...@sil.org.pg wrote:

 Does anybody know of a Z39.50 server that would have Scholastic books, and
 lesser known Christian books?  I've seen the directory at
 http://irspy.indexdata.com but this does not help.  Also, what server
 would have DVDs in them?  We are not finding any of our DVDs in any
 server.  We are currently using British Library, Columbia University,
 Metro-Boston Library Network, Smithsonian Institution Libraries, Library of
 Congress.

 Thanks, Paul



 Paul Dokken
 Software Developer
 SIL PNG Communication and Technology Services
 Ukarumpa EHP 444 | Papua New Guinea
 cts-pr...@sil.org.pg javascript:;
 +675-537-3544 x4404 {Telecom}
 +675-7081-8666 {Digicel}



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



-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
Sent from Gmail Mobile
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report help

[Heather Braum (NEKLS)]

Kerrie,

You need to add the parameter of b.branchcode=choose branch|branches in
the WHERE part of your SQL statement, like I did below. The {choose branch}
part is actually arbitrary and can be whatever you want. Try this:

SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber)
AS checkouts
FROM statistics s
LEFT JOIN borrowers b
USING (borrowernumber)
WHERE b.branchcode=chopse branch|branchces AND s.datetime BETWEEN Top
checkouts BETWEEN (-mm-dd)|date AND and (-mm-dd)|date
GROUP BY s.borrowernumber
ORDER BY count(s.borrowernumber) DESC
LIMIT 20

Hope it helps and works!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those who cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*




On Mon, Oct 13, 2014 at 11:29 PM, Kerrie Stevens kstev...@harvest.edu.au
wrote:

 Hi Everyone,
 I've been using the report 'Patrons with most checkouts in date range'
 with success, but when I try to modify it to allow me to select which
 campus library the patrons are from so I can get a top 20 list for any of
 our campus libraries, I can't get it to work - can anyone help me with this?
 SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber)
 AS checkouts
 FROM statistics s
 LEFT JOIN borrowers b
 USING (borrowernumber)
 WHERE s.datetime BETWEEN Top checkouts BETWEEN (-mm-dd)|date AND
 and (-mm-dd)|date
 GROUP BY s.borrowernumber
 ORDER BY count(s.borrowernumber) DESC
 LIMIT 20
 Thank you!
 Kerrie Stevens
 COLLEGE LIBRARIAN
 Harvest Bible College
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

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

[Koha] 2014 Koha NA Users Group Meeting Summary

[Heather Braum (NEKLS)]

I attended the 2014 North American Koha Users Group meeting in beautiful
Wenatchee, WA last week. Most of the week's notes ended up my hands, so I
get to send out the email summarizing the week, I guess! :)

Attendees spent 2 days discussing various parts of Koha, as well as getting
this North American Koha group off the ground. Friday, a dozen of us
learned how to setup Koha virtual machines and set up git to do our own
testing of Koha, instead of relying on the sandboxes.

Several goals were developed for the group during the week:


   - Purpose: The purpose of this group is to communicate, educate, and
   collaborate amongst North American users of the Koha software and
   strengthen involvement with the global Koha community.
   - Wiki setup: Bare bones wiki already set up: www.koha-na.org. The
   Northeast Kansas Library System (NEKLS) volunteered to set this up and
   sponsor the domain name and provide the server space. This wiki will
   host information, including community participation tips and public
   development ideas and money raised for developments. Specific dollar
   amounts and who's contributing will be behind a password-protected wall (as
   some organizations can't share this info publicly), but the rest of the
   info will be public. We haven't figured out the development part yet, but
   hopefully will soon.


   - Communicate on the Koha-NA listserv more
   - Planning committee for next year's face-to-face conference in a TBD
   location (Include planning for live video/webcasting, for remote
   participation)
   - Online monthly meetings TBD; NEKLS finding out licensing info for
   Collaborate platform
   - Planning committee for the group: Chad Roseburg (NCRL), Joel Sasse
   (Plum Creek), Chris Rohde (Roseville PL), Nick Clemens (VOKAL), Heather
   Braum (NEKLS). Any other volunteers who weren't at the conference, please
   let us know if you're interested in helping lead the direction of this
   group and next year's face-to-face meeting.
   - Membership list on the wiki -- what are areas of experience? IRC
   nicknames.
   - Future goals: nonprofit status, and grant writing


Full discussion notes here:
http://koha-na.org/index.php/Future_of_NA_Koha_Users_Group_discussion

The Wiki that was launched, www.koha-na.org, anyone can register and start
adding content.

All the notes from the event will be available sometime this week on the
new wiki for this group. If any of you attended last week's conference, and
have content to add, please feel free to do so.

Thanks,

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Sandboxes

[Heather Braum (NEKLS)]

Fridolin, I know I couldn't get the Biblibre Sandbox 2 upgraded to master
yesterday. The staff side login was stuck at the web installer screen, even
though I received a sandbox ready email message. In the middle of the email
message, there was this text:

Upgrade to 3.15.00.048 done (Bug 10195: Records hidden with OpacSuppression
can still be accessed)
DBD::mysql::db do failed: BLOB/TEXT column 'issn' used in key specification
without a key length at /home/koha/src/installer/data/mysql/
updatedatabase.pl line 8420.
DBD::mysql::db do failed: Incorrect prefix key; the used key part isn't a
string, the used length is longer than the key part, or the storage engine
doesn't support unique prefix keys at /home/koha/src/installer/data/mysql/
updatedatabase.pl line 8424.
Upgrade to 3.15.00.049 done (Bug 11268 - Biblioitems URL field is too small
for some URLs)

It looks like part of the upgrade failed.

That's the one Biblibre Sandbox I was trying to use. (And yes I was setting
it up with UNIMARC)

Hope that helps!

-Heather

On Friday, August 8, 2014, Fridolin SOMERS fridolin.som...@biblibre.com
javascript:_e(%7B%7D,'cvml','fridolin.som...@biblibre.com'); wrote:

 Hie,

 Tell me which sandox as which problem please.

 Regards,

 Le 08/08/2014 00:06, Nicole Engard a écrit :

 Hi all,

 Tomorrow the Koha North American Users Group will be testing a lot of
 patches (we hope). Today when we gave lessons on how to use them we hit a
 few snags. Many people never got an email and a few sandboxes kept showing
 the installer even though that wasn't chosen.

 Would folks at BibLibre please give the sandboxes a look over before
 tomorrow so we don't cause major breakage :)

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


 --
 Fridolin SOMERS
 Biblibre - Pôles support et système
 fridolin.som...@biblibre.com
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha



-- 
Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
Sent from Gmail Mobile
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Http Bad request error messages

[Heather Braum (NEKLS)]

Joel,

We had this crop up repeatedly on our consortia system after we moved to
3.14.3 in back in February. This bug was filed and the patch
written/applied, and fixed our issue:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11369. That patch
looks like it was added to the 3.16 release and was added to master for
3.14.7 release at the end of May.

Hope that helps.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Tue, Jun 24, 2014 at 2:38 PM, Coehoorn, Joel jcoeho...@york.edu wrote:

 It's bug 10952:

 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10952

 The notes on that bug say this was fixed in March as of 3.14.4. However,
 we're running 3.14.4 here, and I have a librarian who still hits this at
 least once per week. Even so, if your version of Koha is less than 3.14.4,
 you should update first and report back whether that fixed it for you.


   Joel Coehoorn
 Director of Information Technology
 York College, Nebraska
 402.363.5603
 jcoeho...@york.edu



  *The mission of York College is to transform lives through
 Christ-centered education and to equip students for lifelong service to
 God, family, and society*



 On Tue, Jun 24, 2014 at 1:55 PM, Pablo Bianchi pablo.bian...@gmail.com
 wrote:

  Hi!
 
  Librarians complains about a very annoying issue (perhaps a bug): Once
 in a
  while they get this error:
 
  * Bad Request*
Your browser sent a request that this server could not understand.
Size of a request header field exceeds server limit.
 
  This happened with Firefox (v23 to v30, either Windows and Linux
 clients),
  from Koha 3.14 to current (for us) 3.16.
  I notice Owen Leonard already had this problem (bug #10857
  http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10857). The
  workaround is pretty simple: Just delete all browser cookies (or just
 Koha
  ones).
 
  I tried to reproduce the error, cleaning cookies and doing some big
  searches. Even Koha documentation says they use three cookies (
  http://koha-community.org/faqs/cookies-koha-use/) I ended up with this 6
  cookies that all share this info:
  *Host**myCatalogURL*
  *Path*/
  *Send for*Any type of connection
  *Expires*At end of session
 
  But different name and content (copied at the end).
 
  Cookies seems to exceeds the facto limit of 4093 bytes per domain (
  http://browsercookielimits.x64.me/) but no the RFC2109 (
  http://www.ietf.org/rfc/rfc2109.txt) so this shouldn't be a problem... I
  tried increasing Apache LimitRequestFieldSize directive without luck.
 
  Regards,
  Pablo
 
  NameHc2AHbPF
  Content38871 or BC=38870 or BC=38859 or BC=38863 or BC=38858 or
  BC=38869 or BC=38854 or BC=38865 or BC=38868 or BC=38866 or BC=38856 or
  BC=38875 or BC=38874 or BC=38853 or BC=38872 or BC=38873 or BC=38867 or
  BC=38839 or BC=38880 or BC=38840 or BC=38885 or BC=38886 or BC=38882 or
  BC=38886 or BC=38887 or BC=38890 or BC=38891 or BC=38879 or BC=38878 or
  BC=38877 or BC=38864 or BC=38855 or BC=38852 or BC=38847 or BC=38846 or
  BC=38845 or BC=38843 or BC=38841 or BC=38838 or BC=38837 or BC=38910
  NameLkvXIj08
  Content
 
 
 %7B%22offset%22%3A1%2C%22query%22%3A%22q%253Dccl%253DBC%25253D%25252238871%252522%252520or%252520BC%25253D%25252238870%252522%252520or%252520BC%25253D%25252238859%252522%252520or%252520BC%25253D%25252238863%252522%252520or%252520BC%25253D%25252238858%252522%252520or%252520BC%25253D%25252238869%252522%252520or%252520BC%25253D%25252238854%252522%252520or%252520BC%25253D%25252238865%252522%252520or%252520BC%25253D%25252238868%252522%252520or%252520BC%25253D%25252238866%252522%252520or%252520BC%25253D%25252238856%252522%252520or%252520BC%25253D%25252238875%252522%252520or%252520BC%25253D%25252238874%252522%252520or%252520BC%25253D%25252238853%252522%252520or%252520BC%25253D%25252238872%252522%252520or%252520BC%25253D%25252238873%252522%252520or%252520BC%25253D%25252238867%252522%252520or%252520BC%25253D%25252238839%252522%252520or%252520BC%25253D%25252238880%252522%252520or%252520BC%25253D%25252238840%252522%252520or%252520BC%25253D%25252238885%252522%252520or%252520BC%25253D%252522388
  86
 
 
  
 

Re: [Koha] User tagging

[Heather Braum (NEKLS)]

Our consortia has had this feature turned on now for 6 years. We have
moderation turned on, but almost always allow the tag to go through,
regardless of what it is. A few staff and and a few patrons in our
consortia use the feature, but not many.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Thu, Jun 12, 2014 at 4:02 PM, George Williams geor...@latahlibrary.org
wrote:

 Galen,

 We have the tagging turned on for our consortium of 50 libraries.  We have
 the moderation turned on and there is at least one staff member at each
 library that has the ability to moderate tags.

 What we find is that nobody adds tags.  Not patrons, not staff, not no
 one.  The same is true for comments.  Nobody even seems to know they exist.

 George



 -Original Message-
 From: Galen Charlton [mailto:g...@esilibrary.com]
 Sent: Wednesday, June 11, 2014 12:15 PM
 To: Koha-List
 Subject: [Koha] User tagging

 Hi,

 Following up on a discussion I had with some folks on Twitter, I'm curious
 about the use of the user tagging feature in Koha.
 Specifically, if you're a library that has enabled the user tagging
 feature, particularly if you've done so for a long time, do you also use
 the tag moderation feature?

 Are the tags adding to the usability of your catalog?  Why or why not?

 Regards,

 Galen
 --
 Galen Charlton
 Manager of Implementation
 Equinox Software, Inc. / The Open Source Experts
 email:  g...@esilibrary.com
 direct: +1 770-709-5581
 cell:   +1 404-984-4366
 skype:  gmcharlt
 web:http://www.esilibrary.com/
 Supporting Koha and Evergreen: http://koha-community.org 
 http://evergreen-ils.org



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

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

[Koha] Permissions questions

[Heather Braum (NEKLS)]

I'm doing an audit of the permissions of our staff accounts in our system,
and have several questions about certain permissions.

I have already looked at the manual section on permissions and the granular
section, too, but it didn't give enough information (
http://manual.koha-community.org/3.14/en/patronpermissions.html#patronpermsdefined
)

Is there any other online documentation that explains each permission and
what it turns/off or what it may depend upon?

Here's the permissions I have questions about:

*circulate* *group*
1. circulate_remaining_permissions vs the other granular circulate
permissions -- what's the difference?
2. manage_courses/put_coursereserves/remove_coursereserves -- should these
even be in *circulate? *I filed a bug about these (
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11981)

*catalogue vs staffaccess*
1. what's the difference between the *catalogue* permission and the
*staffaccess* permission?


*reserveforothers group*
1. edit_holds: how does one edit holds? What's this permission mean?
2. place_holds vs add_holds: what's the difference between these two
permissions?
3. modify_holds_priority vs. reorder_holds -- what's the difference between
these two permissions?


*edit_catalogue/tools groups *
1. edit_catalogue/batch_edit_items vs tools/batch_edit_items -- what's the
difference between the two permissions?

Thanks!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [ByWater Partners] Development for 'On Demand' Printouts of Overdue Bills

[Heather Braum (NEKLS)]

Lisa,

Our NExpress consortia would be interested in being a partner on this
development.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Tue, Mar 25, 2014 at 11:46 AM, Lisa Gugliotti l...@hchlibrary.orgwrote:

 Hi Koha Community,



We are a small public library that is very interested in having the
 ability

 to print out overdue notices on demand for patrons who don't have
 email, or

 who don't want to share their email accounts with us.   We'd like them
 in

 letter format so we can snail mail them out.



 We've tried Mail Merge from a Koha report, but it's difficult and
 tedious to

 get patrons with more than one item overdue to work correctly on a
 single

 bill.



 Would any other entities be interested in funding a development that
 would

 allow Koha to print individual overdue bills on demand?



 Thank you,



 Lisa Gugliotti

 Reference Librarian

 The Henry Carter Hull Library

 10 Killingworth Turnpike

 Clinton, CT 06413

 860-669-2342

 l...@hchlibrary.org

 www.hchlibrary.org



 ___
 Partners mailing list
 partn...@lists.bywatersolutions.com
 http://lists.bywatersolutions.com/mailman/listinfo/partners


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

Re: [Koha] New patron restrictions data

[Heather Braum (NEKLS)]

If it's the old restrictions data (from before the library upgraded to
3.14) the data is located in the borrowers table, in the borrowers.debarred
and borrowers.debarred comment fields.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard neng...@gmail.com wrote:

 Hi all,

 I'm wondering where in the DB the new restrictions data is stored for
 patrons.  I have a patron with 2 restrictions on her account and when
 I look at borrowers.debarred I only see 1 of them. The other shows
 when I view the record in the staff client so the data has to be
 somewhere ... where is it? :)

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

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

Re: [Koha] New patron restrictions data

[Heather Braum (NEKLS)]

Thank you Jonathan for correcting me. I completely misread Nicole's
question as the data she had was in the borrower_debarments table and she
was asking where was the other data was. :) I need much more coffee this
morning!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart 
jonathan.dru...@biblibre.com wrote:

 Hello Nicole,

 It is in the borrower_debarments table.

 Regards,
 Jonathan

 2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com:
  Hi all,
 
  I'm wondering where in the DB the new restrictions data is stored for
  patrons.  I have a patron with 2 restrictions on her account and when
  I look at borrowers.debarred I only see 1 of them. The other shows
  when I view the record in the staff client so the data has to be
  somewhere ... where is it? :)
 
  Thanks
  Nicole
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

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

Re: [Koha] Looking to Query Indicators

[Heather Braum (NEKLS)]

Nicole, We have a report on our system that looks for 490 tags with the 1
indicator first.

Here's the SQL statement:

select b.biblionumber, b.title, b.author from biblio b join biblioitems i
using (biblionumber) where i.marcxml like  '%datafield tag=490 ind1=1%'

Maybe work with that statement idea, and see what that gets you? (I'm on a
flight to Kohacon, and don't want to try waiting on querying our database
too much on slower wifi). Good luck!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking the Future*





On Tue, Oct 15, 2013 at 12:20 PM, Nicole Engard neng...@gmail.com wrote:

 Hi all,

 Anyone know if there is a way to query a marc field based on the indicator
 value.

 I have this report (which works):

 select b.title, b.author,
 ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]') AS
 lexile from biblio b left join biblioitems m using (biblionumber) where
 ExtractValue(m.marcxml,'//datafield[@tag=521]/subfield[@code=a]')
 between Lexile between and and

 But I want to only query 521s that have a 8# in the indicators.  My report
 will find all of the below:

 521 2# - TARGET AUDIENCE NOTE
 Target audience note 4-8.
 521 0# - TARGET AUDIENCE NOTE
 Target audience note 8.8.
 521 8# - TARGET AUDIENCE NOTE
 Target audience note 1150

 But I only want the last one.

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

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

Re: [Koha] Follett to Koha 3 Migration

[Heather Braum (NEKLS)]

We have migrated several libraries into our Koha consortia from the old
Follett Circulation Plus software over the last five years. The biggest
helper was purchasing the ODBC Driver from Follett (I believe it's still
available, if your paid support contract is current). That software allowed
us to read the proprietary Follett data files and import them all into an
Access database and then export out into Excel and turn over to our
migration support. We've worked with different support vendors over the
last five years and the migrations all went smoothly.

There are a lot of fields and it can get tricky keeping them straight, but
it's definitely doable to migrate from Follett to Koha.

Heather Braum
Digital and Technical Services Librarian
Northeast Kansas Library System
hbr...@nekls.org

4317 W. 6th St.
Lawrence, KS 66049
Office: (785) 838-4090
Fax: (785) 838-3989

 http://www.nekls.org/ | http://www.nexpresslibrary.org/

My guess is (it will be) about 300 years until computers are as good as,
say, your local reference library in search. ~Craig Silverstein, director
of technology, Google.com

The illiterate of the 21st century will not be those cannot read and
write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler,
*Rethinking
the Future*





On Mon, Mar 25, 2013 at 4:59 AM, Jolanta Kaun jk...@lcc.lt wrote:

 Hi,

 We have migrated from Follett to Koha (DOS version) in 2008.
 Liblime (now PTFS) company was hired for a job. The process was quick and
 smooth!
 We had to dump all data from Follett and instruct how to move it from
 field to field. When it was moved, during a trial period we have changed a
 few details yet. But nothing got lost. It was very well done! Did not take
 a month...
 I guess, it is a simple process for a specialist to rearrange the data. If
 you could afford that, I would recommend hiring a company.

 Wishes,

 Jolanta Kaun
 LCC Library/biblioteka


 -Original Message-
 From: koha-boun...@lists.katipo.co.nz [mailto:
 koha-boun...@lists.katipo.co.nz] On Behalf Of Hager Braham
 Sent: Monday, March 25, 2013 9:38
 To: koha@lists.katipo.co.nz
 Subject: [Koha] Follett to Koha 3 Migration

 Hi,

 I am looking for information in order to make a decision about our a new
 library system.

 I saw you were migrating from Follet to Koha. How was it the data transfer
 ? Which is Follet's product you want to change for Koha ?

 I am really interested to know it works now with you.

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

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

[Koha] ResourceMate migration?

[Heather Braum (NEKLS)]

Has anyone ever tried to get MARC data out of a ResourceMate system
before? We've got several questions, starting with how do you get MARC
records out of it? Thanks in advance!

Heather Braum
Digital and Technical Services Librarian
Northeast Kansas Library System
hbr...@nekls.org

4317 W. 6th St.
Lawrence, KS 66049
Office: (785) 838-4090
Fax: (785) 838-3989

 http://www.nekls.org/ | http://www.nexpresslibrary.org/

My guess is (it will be) about 300 years until computers are as good as,
say, your local reference library in search. ~Craig Silverstein, director
of technology, Google.com

The illiterate of the 21st century will not be those cannot read and
write, but those who cannot learn, unlearn, and relearn. ~Alvin
Toffler, *Rethinking
the Future*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha