[Koha] Patron search error

2014-07-24 Thread library
Kia ora koutou Since upgrading to 3.14 I have been unable to search for patrons using the patron search. I can lookup patrons using circulation but now I need the patron module to work. The error message reads Undefined subroutine &DBIx::Class::Exception::blessed called at /usr/share/perl5/DBIx/C

[Koha] Help with ExportWithCsvProfile

2014-07-24 Thread Nicole Engard
I created a CSV Profile (that obviously isn't right) http://screencast.com/t/49bnF9SY1 , named it 'checkouts, and then set the ExportWithCsvProfile preference to 'checkouts'. When I exported I got a blank CSV file. Can someone tell me how to use this preference to get a list of the patron's checkou

[Koha] Koha - creating OAI datasets

2014-07-24 Thread Steve Sowder
I have defined an OAI Data set. In my set mapping I have "595s matches SDAPI" (but in the nomenclature of Koha) After running the program to build the set, the resulting OAI file has _all_ records the database. Not just the ones that matches the map. What am I not doing correctly? Note: We ar

[Koha] Building OAI sets - additional question

2014-07-24 Thread Steve Sowder
Does the program build_oai_sets.pl need to know which setname to build? Without a setname does it build an OAI-PMH file with the entire database as content? Steve sow...@andrews.edu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.c

Re: [Koha] Change SIP Port

2014-07-24 Thread Phillip Ponchot
I did as you said and I'm now seeing SIP responding and Koha listening on port 8023. Running a telnet test, I see that I attach to port 8023 I connect then the connection drops. Connecting to 65.100.74.75 ... Connected to 65.100.74.75 Connection closed I've tried this also inside the network

Re: [Koha] [Koha-docs] Manual PDF Links Broken

2014-07-24 Thread Nicole Engard
Thanks!! On Wed, Jul 23, 2014 at 11:05 AM, Bernardo Gonzalez Kriegel < bgkrie...@gmail.com> wrote: > Hi, > there was a problem on the local copy of manual's repository. > > Now is fixed, please check. > > Regards, > Bernardo > > > > -- > Bernardo Gonzalez Kriegel > bgkrie...@gmail.com > > > On W

Re: [Koha] Report to find biblios without dates in 008 - needs work

2014-07-24 Thread Bernardo Gonzalez Kriegel
Hi Elaine, First, the query must use HAVING instead of WHERE, Date is not a column but an alias to some result. Second, better to check that Date is not a number SELECT biblionumber, SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,4) as Date FROM biblioitems m LEFT JOIN biblio b US