Re: [Koha] How to leave null value in SQL Report

[Josef Moravec]

Hello Vimal,

add this statement just before ORDER line

HAVING AccoMaterial != ""

regards

Josef



út 8. 3. 2016 v 6:37 odesílatel Vimal Kumar V.  napsal:

> Dear Friends,
> Here is a report which list books with accompanying materials (field
> 300$e).
> How can I leave null values in 300$e and list only exact values?
>
>
> SELECT
> ExtractValue(marcxml,'//datafield[@tag="300"]/subfield[@code="e"]') AS
> AccoMaterial,
> DATE_FORMAT(items.dateaccessioned, "%d %b %Y %h:%i %p") AS
>
> Date_accessioned,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,ExtractValue(marcxml,'//datafield[@tag="654"]/subfield[@code="a"]')
> AS
>
> SUBJECT,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate
>
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> WHERE items.homebranch=<>
> AND biblioitems.itemtype = <>
> ORDER BY items.barcode ASC
>
>
> Regards,
> --
> Vimal Kumar V.
> Technical Assistant
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.info
> Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://moovandan.blogspot.in
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> ___
> 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] How to leave null value in SQL Report

[Vimal Kumar V.]

Dear Friends,
Here is a report which list books with accompanying materials (field 300$e).
How can I leave null values in 300$e and list only exact values?


SELECT
ExtractValue(marcxml,'//datafield[@tag="300"]/subfield[@code="e"]') AS
AccoMaterial,
DATE_FORMAT(items.dateaccessioned, "%d %b %Y %h:%i %p") AS
Date_accessioned,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,ExtractValue(marcxml,'//datafield[@tag="654"]/subfield[@code="a"]')
AS
SUBJECT,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate

FROM items
LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE items.homebranch=<>
AND biblioitems.itemtype = <>
ORDER BY items.barcode ASC


Regards,
-- 
Vimal Kumar V.
Technical Assistant
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
Web: http://www.vimalkumar.info
Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
http://moovandan.blogspot.in
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with Check expiration in Serials

[Liz Rea]

Hi,

Are you doing this with the database user logged in, or a regular user?

Cheers,
Liz

On 08/03/16 06:54, Elaine Bradtke wrote:
> ​We're running 3.20.7 and just getting around to testing out some of the
> features in the Serials module. We set up a dummy record to try things like
> notices, etc. and when I clicked on Check Expiration all I got was an error
> message.​
>
> Any idea what the following means?  I
> ​ get the gist of it - something's missing somewhere. I​
> can't find any system preferences that look remotely
> ​like they might address this. There really is only one 'branch' in our
> system.
> ​
> ​
> Global symbol "$branch" requires explicit package name at
> /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
> Global symbol "$branch" requires explicit package name at
> /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
> Execution of /home/koha/koha-test/intranet/cgi-bin/serials/
> checkexpiration.pl aborted due to compilation errors.

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7




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

Re: [Koha] Unable search Books in OPAC & Staff Interface

[Ganesha H]

Hi Sir,
thanks for the quick reply , sir am attaching the marc file sample .

On Mon, Mar 7, 2016 at 4:39 PM, vinod mishra  wrote:

> Can you post here one sample marc record which you have uploaded and pls
> check your zebra is running or not.
> On Mar 7, 2016 7:01 PM, "Ganesha H"  wrote:
>
>> Dear All,i am Ganesha working in as a Librarian in one company, i have
>> installed koha in our library,
>> Koha -3.22.03.000
>> Ubuntu : 12.04
>>
>> I have uploaded the data and done the Zebra Indexing Successfully, But am
>> Unable to Search books in OPAC and Staff Interface Both, but am able to
>> do
>> the Transaction , Like Circulation , Checkout, Checkin, Report Generation
>> Etc
>>
>> Please Help me come out of this Problem...
>>
>> --
>> Thanks & Regards
>>
>> Ganesha.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>


-- 
Regards

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

[Koha] Announcement of Koha-US March 2016 meeting

[Christopher Davis]

Dear Colleagues,

I would like to announce that the March 2016 meeting of the Koha-US
users' group is scheduled for 11:00 am Central Time on Wednesday, the
9th. Please join our meeting by visiting
. The agenda for this meeting
includes a report on NEKLS' upgrade to Koha 3.22 and a status report
on the planning for the 2016 annual Koha-US meeting (in Monterey,
California). Also, the meeting participants will vote on which logo
the group will use.

As always, Koha-US welcomes your agenda item ideas for this meeting;
please email rhastings at nekls dot org with you ideas. I hope to see
you at the meeting this Wednesday :-)

Truly,

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

[Koha] Problem with Check expiration in Serials

[Elaine Bradtke]

​We're running 3.20.7 and just getting around to testing out some of the
features in the Serials module. We set up a dummy record to try things like
notices, etc. and when I clicked on Check Expiration all I got was an error
message.​

Any idea what the following means?  I
​ get the gist of it - something's missing somewhere. I​
can't find any system preferences that look remotely
​like they might address this. There really is only one 'branch' in our
system.
​
​
Global symbol "$branch" requires explicit package name at
/home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
Global symbol "$branch" requires explicit package name at
/home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84.
Execution of /home/koha/koha-test/intranet/cgi-bin/serials/
checkexpiration.pl aborted due to compilation errors.
-- 
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

[Koha] Export 3.12 to 3.22

[Sergio Scotto]

 
Hi guys, i have a problem, i try to update koha from version 3.12 to 3.22
but my vm didnt support the upgrade (imposible to modifiy vm os or
hardware).
So i created a different vm with koha 3.22, but now i need to migrate
patrons and bibliographic records from the 3.12 to 3.22, is there a way to
do this?

Thx!
Sergio

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

Re: [Koha] Export 3.12 to 3.22

[vinod mishra]

Just take mysql backup and restore on new installed koha
On Mar 7, 2016 9:12 PM, "Sergio Scotto"  wrote:

>
> Hi guys, i have a problem, i try to update koha from version 3.12 to 3.22
> but my vm didnt support the upgrade (imposible to modifiy vm os or
> hardware).
> So i created a different vm with koha 3.22, but now i need to migrate
> patrons and bibliographic records from the 3.12 to 3.22, is there a way to
> do this?
>
> Thx!
> Sergio
>
> ___
> 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] Unable search Books in OPAC & Staff Interface

[vinod mishra]

Can you post here one sample marc record which you have uploaded and pls
check your zebra is running or not.
On Mar 7, 2016 7:01 PM, "Ganesha H"  wrote:

> Dear All,i am Ganesha working in as a Librarian in one company, i have
> installed koha in our library,
> Koha -3.22.03.000
> Ubuntu : 12.04
>
> I have uploaded the data and done the Zebra Indexing Successfully, But am
> Unable to Search books in OPAC and Staff Interface Both, but am able to  do
> the Transaction , Like Circulation , Checkout, Checkin, Report Generation
> Etc
>
> Please Help me come out of this Problem...
>
> --
> Thanks & Regards
>
> Ganesha.
> ___
> 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