[Koha] How to use my customized feature in all versions of Koha
Hi, I will like to use my customized feature in all versions of Koha. So I have few questions regarding the same. 1) Whether I can add my feature as a plug-in to Koha Versions? 2) Does Koha has plug-in architecture like Eclipse? -Devendra Tapdia -- View this message in context: http://koha.1045719.n5.nabble.com/How-to-use-my-customized-feature-in-all-versions-of-Koha-tp4641505p4641505.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to use my customized feature in all versions of Koha
devendratapdia schreef op do 28-07-2011 om 00:10 [-0700]: I will like to use my customized feature in all versions of Koha. So I have few questions regarding the same. 1) Whether I can add my feature as a plug-in to Koha Versions? No. 2) Does Koha has plug-in architecture like Eclipse? No. Those are the short answers, anyway :) Your best bet is to allow it to be enabled/configured with system preferences, and send it upstream. That way, it ends up in all versions. Robin. signature.asc Description: This is a digitally signed message part ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Seeking Koha Newsletter Editor
Le 28/07/2011 01:49, Daniel Grobani a écrit : Hi, I volunteer to serve as newsletter editor. I don't know the qualifications but can offer these tidbits: Daniel, you made a big mistake: usually, when someone volunteers, he is welcomed. I met you at previous KohaCons, I know you'll do a great job, so you've my vote ! Friendly -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Seeking Koha Newsletter Editor
+1 from me too and thank you for volunteering! From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Joann Ransom Sent: Thursday, July 28, 2011 4:10 AM To: BWS Johnson Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Seeking Koha Newsletter Editor Go Daniel - he has my vote too - he'll be great :) On 28 July 2011 13:59, BWS Johnson abesottedphoe...@yahoo.com wrote: Kia ora! Daniel++ :D Thanks for stepping up! Cheers, Brooke I volunteer to serve as newsletter editor. I don't know the qualifications but can offer these tidbits: 1. I have experience editing newsletters and currently edit one for a community organization. 2. I've participated in the Koha community for two years, online and at two KohaCons. 3. I keep up on what's happening in the community--I read the main and developer lists regularly and subscribe to two dozen Koha-related RSS feeds. I plan to attend the IRC meeting on August 2 (well, August 1 here). ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help - Extracting XML
Daniel, That part I knew :) it was getting it in to the query (the joining) I was having trouble with :) Nicole On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani dgrob...@samuelmerritt.edu wrote: Nicole, This should give you the 520a: extractValue(biblioitems.marcxml, collection/record/datafield[@tag='520'][1]/subfield[@code='a']) Of course, you'll have to do a join on biblioitems. - Cheers, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel Merritt University -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604p4640701.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ 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] Seeking Koha Newsletter Editor
+1 here as well. 2011/7/28 Fischer, Katrin katrin.fisc...@bsz-bw.de: +1 from me too and thank you for volunteering! From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Joann Ransom Sent: Thursday, July 28, 2011 4:10 AM To: BWS Johnson Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Seeking Koha Newsletter Editor Go Daniel - he has my vote too - he'll be great :) On 28 July 2011 13:59, BWS Johnson abesottedphoe...@yahoo.com wrote: Kia ora! Daniel++ :D Thanks for stepping up! Cheers, Brooke I volunteer to serve as newsletter editor. I don't know the qualifications but can offer these tidbits: 1. I have experience editing newsletters and currently edit one for a community organization. 2. I've participated in the Koha community for two years, online and at two KohaCons. 3. I keep up on what's happening in the community--I read the main and developer lists regularly and subscribe to two dozen Koha-related RSS feeds. I plan to attend the IRC meeting on August 2 (well, August 1 here). ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust. ___ 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] Seeking Cosponsors for Bug 2720 - Fines that debar automatically, should undebar automatically when paid.
NEKLS is seeking cosponsors for the development to fix Bug 2720 - Fines that debar automatically, should undebar automatically when paid. We will be working with ByWater Solutions on the development, should we get adequate cosponsorship. If you are interested in helping us out, please contact either NEKLS at nexpressh...@nekls.org, or ByWater Solutions at st...@bywatersolutions.com to express your interest in cosponsoring. Be sure to put in your message interested in cosponsoring bug 2720 - fines that debar should undebar automatically when paid. Looking forward to working with you! Liz Rea l...@nekls.org inline: email_signature.jpeg ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Change of title/publication names of serials without losing history
Is it possible to change the title/publication names of serials without losing the issue history with old title/publisher names How is it? -- View this message in context: http://koha.1045719.n5.nabble.com/Change-of-title-publication-names-of-serials-without-losing-history-tp4638121p4638121.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Re: Quick Consensus
Dear Lee Philips, I am Remi Nedelec, company Aesis Conseil, France and we got a mail from Paul Poulain about your needs in terms of public computer management system. Our society provides such a solution called WebKiosk. WebKiosk offers your users a highly secure Internet access and tools which are adapted to your library. Here are the features : - a simple, pleasant and intuitive web-based control panel with users rights management - works as a stand-alone client or in conjunction with a print release terminal - works in conjunction with koha (full compatibility) - scheduled or immediate computer reservation - time allocation management - free third party Internet-filtering software SquidGuard - both Ubuntu 10.04 LTS Server and Desktop Edition - and more ! WebKiosk is not translated in us/english language yet. The translation file is easy to make though. Indeed, we split the language file from the application so we can easily add a language support. You should contact us at informati...@aesis-conseil.com to tell us more details about your needs. @Biblibre : thanks for the information ! Cordially, | Remi Nedelec | +(33) 9 63 46 97 15 | rnede...@aesis-conseil.com | http://www.aesis-conseil.com Message original Sujet: Re: [Koha] Quick Consensus Date : Thu, 28 Jul 2011 11:31:16 +0200 De :Paul Poulain paul.poul...@biblibre.com Pour : koha@lists.katipo.co.nz, lphill...@buttepubliclibrary.info Copie à : informati...@aesis-conseil.com, philippe.Chabanon_Biblibre.com philippe.chaba...@biblibre.com Le 27/07/2011 20:39, Lee Phillips a écrit : Hello all, Looking at a public computer management system- choices are Envisionware or Pharos. We run Koha and Unbuntu. Thoughts on best match and best support/service? Lee in Butte, Montana Hi Lee, Here in France, BibLibre is parterning with aesis-conseil, a company that has developped an OpenSource public computer management system. I don't know if they work in english though. Just FYI, i've cced them HTH (Aesis = I met Lee at KohaCon09 and 10, she's an awesome librarian ;-) ) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problems Column in Inventory
Can anyone tell me what the last column that shows on the shelf listing for the inventory tool is for? It is labeled as 'Problems' but I have never seen anything but 'None' under that - and I've tested on a lot of systems. What would a problem be? What is being reported by this column? Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems Column in Inventory
That's interesting because I did an upload of a file that had a barcode that was not in Koha and I didn't get that screen at all, what I got was a message saying that the barcode was not found and a confirmation that the date was updated on the other items in the file. That list only shows if you enter criteria in the form (not if you upload a text file). See here: http://screencast.com/t/XgGKtYGm Nicole On Thu, Jul 28, 2011 at 6:36 PM, Chris Cormack ch...@bigballofwax.co.nz wrote: On 29 July 2011 10:21, Nicole Engard neng...@gmail.com wrote: Can anyone tell me what the last column that shows on the shelf listing for the inventory tool is for? It is labeled as 'Problems' but I have never seen anything but 'None' under that - and I've tested on a lot of systems. What would a problem be? What is being reported by this column? The template tells me [% IF ( loo.notfoundbarcode ) %] p style=background: red;Not found among barcodes in barcodes file./p [% ELSIF ( loo.notfoundkoha ) %] p style=background: red;Not found in koha./p [% ELSE %] p style=background: green;None/p [% END %] So, 3 choices, none, or barcode not in Koha, or not in the file you uploaded. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help - Extracting XML
If you don't mind, put your two pieces in to my report in the right places - my problem is that I'm not sure the Join goes where I would normally put it. Nicole On Thu, Jul 28, 2011 at 12:45 PM, Grobani, Daniel dgrob...@samuelmerritt.edu wrote: How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = items.biblioitemnumber)? Daniel -Original Message- From: Nicole Engard [mailto:neng...@gmail.com] Sent: Thursday, July 28, 2011 4:36 AM To: Grobani, Daniel Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Report Help - Extracting XML Daniel, That part I knew :) it was getting it in to the query (the joining) I was having trouble with :) Nicole On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani dgrob...@samuelmerritt.edu wrote: Nicole, This should give you the 520a: extractValue(biblioitems.marcxml, collection/record/datafield[@tag='520'][1]/subfield[@code='a']) Of course, you'll have to do a join on biblioitems. - Cheers, Daniel Grobani Library Technology Specialist John A. Graziano Memorial Library Samuel Merritt University -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604 p4640701.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ___ 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] ILS open sources
hi i'm going to create a document about Integrated Library Systems in open sources , any one can helps me by official list of open sources ILS . thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help - Extracting XML
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
') AS URL,
biblio.author,
items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
FROMstatistics
JOINitems ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '-mm-dd' AND '-mm-dd'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BYbiblio.biblionumber
ORDER BYcircs DESC
LIMIT 10
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel Merritt University
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604p4644634.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] ILS open sources
2011/7/28 Jonson philip superjojo1...@gmail.com: hi i'm going to create a document about Integrated Library Systems in open sources , any one can helps me by official list of open sources ILS . This is the list of the Open Source Koha ILS. Regards To+ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] ILS open sources
Thank's Nicole :)) On Fri, Jul 29, 2011 at 1:49 AM, Nicole Engard neng...@gmail.com wrote: Jonson, I have an incomplete list bookmarked in Delicious: http://www.delicious.com/nengard/opensource+ils Nicole 2011/7/28 Jonson philip superjojo1...@gmail.com: hi i'm going to create a document about Integrated Library Systems in open sources , any one can helps me by official list of open sources ILS . thank's ___ 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 - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
href=\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'/a')
as URL, biblio.author, items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
FROMstatistics
JOINitems ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '2011-01-01' AND '2011-07-01'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BYbiblio.biblionumber
ORDER BYcircs DESC
LIMIT 10
Gets this:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ' statistics
JOIN items ON (items.itemnumber=statistic' at line 4
Also, a tip - those sections I had in there are runtime
parameters for Koha (a neat trick that is documented on the wiki and
in the manual - in case you removed them cause you didn't know what
they were).
On Thu, Jul 28, 2011 at 7:41 PM, Daniel Grobani
dgrob...@samuelmerritt.edu wrote:
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
') AS URL,
biblio.author,
items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
FROM statistics
JOIN items ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '-mm-dd' AND
'-mm-dd'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BY biblio.biblionumber
ORDER BY circs DESC
LIMIT 10
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel Merritt University
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604p4644634.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
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 - Extracting XML
Hmm, it works fine for me. It looks like it might have choked on the first
tab--try replacing all the tabs I introduced to spaces.
Thanks for your reminder about the and sorry I removed them. I remember
reading about that now, but because that works differently in our, um, flavor,
it didn't stick.
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
href=\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'/a')
as URL, biblio.author, items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
FROMstatistics
JOINitems ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '2011-01-01' AND '2011-07-01'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BYbiblio.biblionumber
ORDER BYcircs DESC
LIMIT 10
Gets this:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '
statistics JOIN items ON (items.itemnumber=statistic' at line 4
Also, a tip - those sections I had in there are runtime parameters for
Koha (a neat trick that is documented on the wiki and in the manual - in case
you removed them cause you didn't know what they were).
On Thu, Jul 28, 2011 at 7:41 PM, Daniel Grobani dgrob...@samuelmerritt.edu
wrote:
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
') AS URL,
biblio.author,
items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='52
0'][1]/subfield[@code='a'])
FROM statistics
JOIN items ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '-mm-dd' AND
'-mm-dd'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BY biblio.biblionumber
ORDER BY circs DESC
LIMIT 10
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel Merritt University
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604
p4644634.html Sent from the Koha - Discuss mailing list archive at
Nabble.com.
___
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] Seeking Koha Newsletter Editor
Daniel as new Koha Newsletter Editor! from the CALYX Team... and ... THANK YOU Nicole for a great job :-)! Irma On 28/07/11 19:37, Fischer, Katrin wrote: +1 from me too and thank you for volunteering! *From:*koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] *On Behalf Of *Joann Ransom *Sent:* Thursday, July 28, 2011 4:10 AM *To:* BWS Johnson *Cc:* koha@lists.katipo.co.nz *Subject:* Re: [Koha] Seeking Koha Newsletter Editor Go Daniel - he has my vote too - he'll be great :) On 28 July 2011 13:59, BWS Johnson abesottedphoe...@yahoo.com mailto:abesottedphoe...@yahoo.com wrote: Kia ora! Daniel++ :D Thanks for stepping up! Cheers, Brooke ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
