Re: [Koha] Report to find biblios without dates in 008 - needs work
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 USING (biblionumber) HAVING Date NOT REGEXP '[0-9]+' Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Jul 23, 2014 at 7:45 PM, Elaine Bradtke e...@efdss.org wrote: 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 like to limit the results to just the biblios with in the first date section of the 008 WHERE (Date = '') didn't work. NULL in place of '' doesn't work either. WHERE (ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,4) = '' also didn't work. I've exhausted my cut and paste abilities. . . . -- Elaine Bradtke (What I don't know about SQL would fill a few books) 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] [Koha-docs] Manual PDF Links Broken
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 Wed, Jul 23, 2014 at 11:43 AM, Nicole Engard neng...@gmail.com wrote: Hi all, It looks like the links to the PDFs on the documentation page are broken: http://koha-community.org/documentation/ Nicole ___ Koha-docs mailing list koha-d...@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-docs ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Change SIP Port
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 with the same result and I've tried this test on the server itself with the same result. Things that I've done to resolve this issue: 1. I've checked the sip-error.log but what I find there does not address the issue. 2. I've checked the firewall and then even uninstalled ufw and iptables-persistent. 3. I've checked and rechecked open and listening ports in case there is something blocking the port. 4. While checking the telnet response to try to find out why the connection was being closed telnet to 8023 started working and I could send and receive SIP packets. As soon as the server was rebooted, this behavior quit. my questions: 1. Is Koha itself hardwired to port 8023 or can I change the port to another one? 2. I've used netstat and nmp to check to see what is running or listening and on what port, is there any other suggestions on how to check this issue. 3. Any suggestions on how to troubleshoot the Connection drop further, has anyone else had this issue and resolved it? Thanks for any help because I apparently need it - smile. Phillip It was another darn good plan ruined by reality! - smile again. Date: Thu, 24 Jul 2014 08:36:14 -0700 Subject: Re: [Koha] Change SIP Port From: g...@esilibrary.com To: pponc...@live.com CC: koha@lists.katipo.co.nz Hi, On Wed, Jul 23, 2014 at 9:04 PM, Phillip Ponchot pponc...@live.com wrote: Is there anything else that needs to be changed or will the changes I made above be sufficent to change the SIP Service itself to port 6002? It's sufficient to edit /etc/koha/sites/$site/SIPconfig.xml and restart SIP. The /etc/koha/SIPconfig.xml file acts as a template that gets copied to the site directory when koha-enable-sip is run for the first time. 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] Building OAI sets - additional question
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.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha - creating OAI datasets
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 are on v3.16.02.000 Thanks Steve sow...@andrews.edu BTW: A should not be there record is at http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecordidentifier=SDAPI:1metadataPrefix=oai_dc A is and should be there is at http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecordidentifier=SDAPI:105000metadataPrefix=oai_dc ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help with ExportWithCsvProfile
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 checkouts as a CSV file? I will share your example in the manual. Thanks Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Patron search error
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/Class/Exception.pm line 55. Compilation failed in require at /koha/lib/Koha/Database.pm line 38. BEGIN failed--compilation aborted at /koha/lib/Koha/Database.pm line 38. Compilation failed in require at /koha/lib/Koha/List/Patron.pm line 32. BEGIN failed--compilation aborted at /koha/lib/Koha/List/Patron.pm line 32. Compilation failed in require at /koha/intranet/cgi-bin/members/member.pl line 35. BEGIN failed--compilation aborted at /koha/intranet/cgi-bin/members/member.pl line 35. we are using Koha 3.14.04 Linux koha 2.6.32-5-686-bigmem Perl 5.010001 Our technical support people are at a loss as to what to do. Could anyone throw some light on where we might look to solve our problem. Regards Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amur...@katikaticollege.school.nz ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
