[Koha] Change SIP Port

2014-07-23 Thread Phillip Ponchot
I need to change the port that SIP to which SIP listens. The default port is 6001 and I need to change it to 6002 (with Koha still listening on port 8023 as defined in the SIPConfig.xml. I change the port to 6002 in /etc/koha/SIPConfig.xml but I realized that Koha moves this file to /etc/k

Re: [Koha] Koha live dvd 3.14.08

2014-07-23 Thread Vinod Kumar Mishra
No, how did you made live DVD now? if with remastersys than please confirm is it still working? because few day back i checked and found it does not work more now. On Thu, 24 Jul 2014 08:55:12 +0530 Quoc Uy wrote >I just updated from my old live dvd to latest oldstable version. Nothing >specia

Re: [Koha] Koha live dvd 3.14.08

2014-07-23 Thread Vinod Kumar Mishra
Dear Nguyen Quoc Uy, Are you able to make live DVD of latest version, if yes than please explain how? On Thu, 24 Jul 2014 06:36:04 +0530 Quoc Uy wrote >So this is second live dvd for version 3.14. Sorry all, i was so busy with my >work and can't make live dvd more frequently. You can download f

[Koha] Koha live dvd 3.14.08

2014-07-23 Thread Quoc Uy
So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can't make live dvd more frequently. You can download from here, don't forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net             koha-latest - Browse Files at SourceForge

Re: [Koha] Report help

2014-07-23 Thread BWS Johnson
Salvete! >SELECT >CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,2) >      WHEN '19' THEN 'XX' >      WHEN '20' THEN 'XXI' >      WHEN '18' THEN 'XVIII' >      WHEN '17' THEN 'XVII' >      ElSE 'OLDER' END >   AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m

[Koha] Koha 3.16.2 released

2014-07-23 Thread Galen Charlton
The Koha community is pleased to announce the release of version 3.16.2 of the Koha library automation system. Koha 3.16.2 is a bugfix release and can be downloaded from http://download.koha-community.org/ Debian packages of Koha 3.16.2 will be available shortly. Full release notes can be found

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

2014-07-23 Thread Elaine Bradtke
I'm halfway there: SELECT biblionumber, SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,4) as Date FROM biblioitems m LEFT JOIN biblio b USING (biblionumber) WHERE Date = '' Doesn't quite work. If I omit the last line, it spits out a list of all our biblios, and the date. I'd l

Re: [Koha] Report help

2014-07-23 Thread Elaine Bradtke
Ramiro That's very useful, thanks. I've expanded it a little to accommodate our date range (yes we have some old items) and changed it to say "Unknown" rather than older, because I suspect these are questionable dates or missing data. Quite a few dates are missing in the 008 field. One of the diff

Re: [Koha] Barcode generation in koha 2.2.9 Windows Version

2014-07-23 Thread xiaoyuandlg
Very impressive thread, I reckon that I've gained a lot from this. Actually, I happen to got stuck in reporting services barcode generation , don't know if you guys have related experience or not. I've had enough with

Re: [Koha] Report help

2014-07-23 Thread ramirouvia .
Elaine: I think you should use 008 date: SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' ElSE 'OLDER' END AS bibtype, count(DISTINCT biblionumber) AS

Re: [Koha] Report help

2014-07-23 Thread Elaine Bradtke
This is the basic report: SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) GROUP BY biblio.copyrightdate ORDER BY biblio.c

Re: [Koha] Cataloging questions

2014-07-23 Thread Elaine Bradtke
Oops, my bad I was in the serials framework when I answered your question. . . you were right make the changes in your default framework. Elaine On Wed, Jul 23, 2014 at 6:54 PM, Steve Sowder wrote: > Thanks. I was not aware of this area of Koha. > > We are on 3.16 and I did not see the SER fra

Re: [Koha] Cataloging questions

2014-07-23 Thread Steve Sowder
I had found the GetRecord format and tested it and got the list. (Your first example) but had not found for a specific record. Thanks i have also disco9vered "from" i.e. http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=ListRecordsfrom=2014-07-20&metadataPrefix=oai_dc But, it isn't fast. I have

Re: [Koha] Cataloging questions

2014-07-23 Thread Steve Sowder
Thanks. I was not aware of this area of Koha. We are on 3.16 and I did not see the SER framework structure. Instead, just click on default's "MARC Structure" to edit it. All is working now. Thanks again. Steve On 7/23/2014 12:26 PM, Elaine Bradtke wrote: Steve: Older versions of Koha may b

Re: [Koha] Cataloging questions

2014-07-23 Thread ramirouvia .
Hi Steve: I am not sure if this will help you, but just in case... http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=ListRecords&metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecord&identifier=SANDBOX:1&metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?ve

Re: [Koha] Cataloging questions

2014-07-23 Thread Elaine Bradtke
Steve: Older versions of Koha may be slightly different but the short answer is you need to modify the subfields in your framework so that it displays in the editor (the default for 590 is to not display, probably the same for 595). Home › Administration › MARC frameworks › SER framework structure

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

2014-07-23 Thread Bernardo Gonzalez Kriegel
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 Wed, Jul 23, 2014 at 11:43 AM, Nicole Engard wrote: > Hi all, > > It looks like the links to the PDFs on the documentation pa

[Koha] ldap and extended patron attributes

2014-07-23 Thread Heiko Weier
Hi all, we are testing Koha (3.16.01) with openldap and have an error with extended patron attributes. DBD::mysql::st execute failed: Unknown column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 320, line 522. 'preflang' is one of our extended attributes. Mapping

Re: [Koha] Cataloging questions

2014-07-23 Thread Steve Sowder
Responding with more data to my own question. The MARC tag 595 is not displayed anywhere in Koha. However, if the record is exported (buy bib number range) the 595 tags are present. So, question #1 is answered. They _are_ loaded. But, they are not displayed anywhere except when exporting. We

[Koha] Manual PDF Links Broken

2014-07-23 Thread Nicole Engard
Hi all, It looks like the links to the PDFs on the documentation page are broken: http://koha-community.org/documentation/ Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Cataloging questions

2014-07-23 Thread Steve Sowder
I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 n

Re: [Koha] jquery : barcode triggers submit

2014-07-23 Thread Jared Camins-Esakov
Chad, > A better solution is to remove this class : > $("tag_952_subfield_p_971027").removeClass("noEnterSubmit"); And, of course, you will need a valid selector. 971027 is a random number, and the "tag_952..." is an id and not a tag name. Something like $('input[id^="tag_952_subfield_p"]') mig