Re: [Koha] Reindexing after switching from GRS1 to DOM
Hi Michal, We were running 3.16 and just upgraded to 3.18. As for the logs, I will have to check with our IT person, as I don't have access to that area. Unfortunately I'm not familiar with the operating system side of things. Thanks for the advice on koha-conf.xml and I will forward it to our IT person. Regards, Iming - Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: im...@translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Reindexing-after-switching-from-GRS1-to-DOM-tp5821489p5821706.html Sent from the Koha-general 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] MYSQL to SQL Sever
You could set-up the MySQL server containing coha as a linked server in MS SQL Server. You could then perform queries against it from within the MS SQL Server environment, update it - strongly NOT advisable - and/or copy its contents to a local (MSSQLSRV) DB. On Sunday, December 7, 2014, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz javascript:; 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] Catalogue - SQL Report Help
You have discovered one of the quirks of the system. For biblios with
multiple items it will produce the same information (title, etc.) for each
item. I don't know how to work around that. Maybe someone else does?
Elaine
On Wed, Dec 10, 2014 at 5:12 AM, SATISH lis4sat...@gmail.com wrote:
Hi,
I would like to have report for the entire library collections as
indicated below:
--
Biblio| Biblio Record (title) | Author | edition | publisher | ISBN
| Holdings ( no. of copies)
Number
count
--
example:
1 Brief history of timeHawkings.2nd ed.oxford(paper
back)10
2 Brief history of timeHawkings3rd ed.oxford (paper
back)5
3 Brief history of timeHawkings2nd ed.Oxford (hard
bound) 2
4 Complete reference- C++
50
5 Basic electrical engineering...
30
--
For example, One record is having 10 items, and when I tried to use guided
reports wizard, it fetches and display, 10 times the same records. I wanted
to get only one title on behalf of 10 items. I meant, non-repetative
records ( titles) from the entire library collections. (and exceptions for
change in edition, ISBN, different title).
And secondly,
the same report as per the collection code, which means,
list of unique records in each collection (isbn, change in edition, etc
are exceptions).
Thank you in advance.
Satish MV
Librarian
Govt. Engineering College, Hassan.
Karnataka.
INDIA.
+91-9449765737
On Mon, Dec 8, 2014 at 11:22 PM, Elaine Bradtke e...@efdss.org wrote:
More information may help.
all unique titles(biblio records)
Unique how? different ISBN? (do they all have ISBN?) Different title?
Same title different edition? Only one item record?
Exactly what information would you like to display in the report?
List of biblio numbers?
Sorted by collection code?
or Filtered to show only items with a specific collection code?
It may take a few attempts to make your request clear. I am not an expert
report writer, but once you question is better understood, we may be able
to help.
On Fri, Dec 5, 2014 at 6:20 AM, SATISH lis4sat...@gmail.com wrote:
Hi,
Unfortunately, I have not received any help for generating a report on
following subject and, re-described my problem.
I am looking for a report which has list of all unique titles(biblio
records) in a home library AND also by collection code.
When I tried for nearest relevant SQL examples given in wiki,
it gives me, whole list of items along with biblios records that is not
useful and I wanted to have information only on unique records (titles).
Please advice.
with thanks.
Satish MV
Librarian
Govt. Engineering College, Hassan.
Karnataka.
INDIA.
On Tue, Nov 25, 2014 at 4:58 PM, SATISH lis4sat...@gmail.com wrote:
Koha 3.16.00.000 installed via packages method, on ubuntu desktop.
On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar
vikramczadgaon...@gmail.com wrote:
Ok. Let me check. I will mail you SQL query.
Which koha version you are using?
Vikram Zadgaonkar
On Tue, Nov 25, 2014 at 4:20 PM, SATISH lis4sat...@gmail.com wrote:
The same is not available over there.
Many examples in the website, fetches for whole items in the library.
I need to have report on List of Unique titles available in the
library
( i.e., Records) and Total Number of books (i.e.,Items).
report should include list of {title,author,publisher,edition, price}
not just counts.
On Tue, Nov 25, 2014 at 1:40 PM, vikram zadgaonkar
vikramczadgaon...@gmail.com wrote:
Hi,
You can try following link
http://wiki.koha-community.org/wiki/SQL_Reports_Library
Vikram Zadgaonkar
On Tue, Nov 25, 2014 at 1:33 PM, satishamv lis4sat...@gmail.com
wrote:
Dear Friends,
I am looking for a report which has list of all unique
titles(biblio
records) in a home library AND also by collection code.
In my case, new record is created for - change in edition or
change in
item
type.
with thanks.
Satish MV
Librarian
Govt. Engineering College, Hassan.
Karnataka.
INDIA.
--
View this message in context:
http://koha.1045719.n5.nabble.com/Catalogue-SQL-Report-Help-tp5820185.html
Sent from the Koha-general 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] Search: Biblios not found after reindexing
Hallo I upgraded today to koha 3.18.1 using the debian packages. I noticed that the links between authority records and bibligraphic records weren't updated using koha-rebuild-zebra So I tried a full reindex: koha-rebuild-zebra -f kb I get: 16:41:54-10/12 zebraidx(4827) [warn] Couldn't open collection.abs [No such file or directory] 17:05:59-10/12 zebraidx(4827) [fatal] reckeys.c:214: Out of memory - malloc(364288000 bytes) Right now I can't search biblios any more. An authority search does fine, but the the used in-row shows allways 0 results. What shall I do? Beda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Potential XSS attack vector in opac
Could someone let us know what bug number this is? Thanks On Wed, Dec 10, 2014 at 5:01 AM, Robin Sheat ro...@catalyst.net.nz wrote: Chris Cormack schreef op wo 10-12-2014 om 12:46 [+1300]: I have reported the bug, and I am just uploading a couple of patches, (one for master/3.18 which is bootstrap) and one for 3.16 which has the change for bootstrap and prog Packages for 3.18.01 have been released to the 'squeeze' repository. The 'oldstable' repository will get 3.16 when an update for that have been released. Note that it currently contains 3.14.11, so this will also be an upgrade for that (which I'd rather didn't happen, but I was waiting for 3.16.05 anyway before updating it.) I expect this to happen tomorrow, though I'll be conferencing then so I can't promise exactly when it'll happen. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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 http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Potential XSS attack vector in opac
Hi Elaine It's in the 3.18.01 release notes http://koha-community.org/koha-3-18-01-security-release/ You won't be able to see it in bugzilla the bug is still private until a 3.16.x release is done but you can cherry pick the code from the 3.18.x branch in git Chris On 11 December 2014 6:33:33 am NZDT, Elaine Bradtke e...@efdss.org wrote: Could someone let us know what bug number this is? Thanks On Wed, Dec 10, 2014 at 5:01 AM, Robin Sheat ro...@catalyst.net.nz wrote: Chris Cormack schreef op wo 10-12-2014 om 12:46 [+1300]: I have reported the bug, and I am just uploading a couple of patches, (one for master/3.18 which is bootstrap) and one for 3.16 which has the change for bootstrap and prog Packages for 3.18.01 have been released to the 'squeeze' repository. The 'oldstable' repository will get 3.16 when an update for that have been released. Note that it currently contains 3.14.11, so this will also be an upgrade for that (which I'd rather didn't happen, but I was waiting for 3.16.05 anyway before updating it.) I expect this to happen tomorrow, though I'll be conferencing then so I can't promise exactly when it'll happen. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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 http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search: Biblios not found after reindexing
Hi Beda What version did you upgrade from. 3.18.x uses DOM not GRS1 for indexing, I suspect that is your problem I am going to be in a conference all day so hopefully someone else can help Chris On 11 December 2014 6:27:58 am NZDT, Beda Szukics b...@kollegium-sarnen.ch wrote: Hallo I upgraded today to koha 3.18.1 using the debian packages. I noticed that the links between authority records and bibligraphic records weren't updated using koha-rebuild-zebra So I tried a full reindex: koha-rebuild-zebra -f kb I get: 16:41:54-10/12 zebraidx(4827) [warn] Couldn't open collection.abs [No such file or directory] 17:05:59-10/12 zebraidx(4827) [fatal] reckeys.c:214: Out of memory - malloc(364288000 bytes) Right now I can't search biblios any more. An authority search does fine, but the the used in-row shows allways 0 results. What shall I do? Beda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help
I find the guided reports wizard, frankly, to be very unhelpful, especially since I work with 50 branch locations in our consortia. I usually write my own custom reports, as a result, for much more granular control. To get this kind of data you gave as an example, you have to query and join three tables together -- biblio table has the author and title info, the biblioitems table has the edition, publisher, and isbn (will return up to 30 characters; there's something different you have to use in your query if you want the full isbn), and then the total items count comes from also querying the items table. The SQL statement will look like this: SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber Does this statement give you what you are looking for? 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* On Wed, Dec 10, 2014 at 11:27 AM, Elaine Bradtke e...@efdss.org wrote: You have discovered one of the quirks of the system. For biblios with multiple items it will produce the same information (title, etc.) for each item. I don't know how to work around that. Maybe someone else does? Elaine On Wed, Dec 10, 2014 at 5:12 AM, SATISH lis4sat...@gmail.com wrote: Hi, I would like to have report for the entire library collections as indicated below: -- Biblio| Biblio Record (title) | Author | edition | publisher | ISBN | Holdings ( no. of copies) Number count -- example: 1 Brief history of timeHawkings.2nd ed.oxford(paper back)10 2 Brief history of timeHawkings3rd ed.oxford (paper back)5 3 Brief history of timeHawkings2nd ed.Oxford (hard bound) 2 4 Complete reference- C++ 50 5 Basic electrical engineering... 30 -- For example, One record is having 10 items, and when I tried to use guided reports wizard, it fetches and display, 10 times the same records. I wanted to get only one title on behalf of 10 items. I meant, non-repetative records ( titles) from the entire library collections. (and exceptions for change in edition, ISBN, different title). And secondly, the same report as per the collection code, which means, list of unique records in each collection (isbn, change in edition, etc are exceptions). Thank you in advance. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. +91-9449765737 On Mon, Dec 8, 2014 at 11:22 PM, Elaine Bradtke e...@efdss.org wrote: More information may help. all unique titles(biblio records) Unique how? different ISBN? (do they all have ISBN?) Different title? Same title different edition? Only one item record? Exactly what information would you like to display in the report? List of biblio numbers? Sorted by collection code? or Filtered to show only items with a specific collection code? It may take a few attempts to make your request clear. I am not an expert report writer, but once you question is better understood, we may be able to help. On Fri, Dec 5, 2014 at 6:20 AM, SATISH lis4sat...@gmail.com wrote: Hi, Unfortunately, I have not received any help for generating a report on following subject and, re-described my problem. I am looking for a report which has list of all unique titles(biblio records) in a home library AND also by collection code. When I tried for nearest relevant SQL examples given in wiki, it gives me, whole list of items along with biblios records that is not useful and I wanted to have information only on unique records (titles). Please advice. with thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. On Tue, Nov 25, 2014 at 4:58 PM, SATISH lis4sat...@gmail.com wrote: Koha 3.16.00.000 installed via packages method, on ubuntu desktop. On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Ok. Let me check. I will mail you SQL query. Which koha version you are using? Vikram Zadgaonkar On Tue, Nov 25, 2014 at 4:20 PM, SATISH lis4sat...@gmail.com wrote:
Re: [Koha] Cloud-based Koha vs locally hosted Koha
Our system is run in the cloud. We felt this was more secure/reliable than running it from our internal server. We recently shifted from one virtual machine to another, including a change in the version of Linux we run. Of all the online services we have, Koha was the easiest one to move, and had the fewest problems with the changes. On Tue, Dec 9, 2014 at 7:06 PM, Jesse Lambertson jlambert...@sqcc.org wrote: Thank you mark. We already do have a good plan for back-up. But with these other issues, your points are valid and jive with some other conversations I am having as we get ready to set this up (soonish). I will have to look at Brooke's other point about carefully picking the (external) hosting environment - one that gives me command-line access to update everything as needed. The idea in this thread here seems to be that hosting elsewhere means that it will not be as easy for me to update. But I have to imagine there is some host out there that has everything partitioned in a way so that I can manipulate my own data at will (maybe that is still just a dream). I will dig into that search next. Thank you everyone. Jesse On Tue, Dec 9, 2014 at 1:56 PM, Mark Tompsett mtomp...@hotmail.com wrote: Greetings, On 10 December 2014 7:06:37 am NZDT, BWS Johnson abesottedphoe...@yahoo.com wrote: [SNIP] The only difference I can spot might actually weigh as a positive in favour of cloud based service. When you have a physical server and suffer a local catastrophe, such as an earthquake, fire, sinkhole, et cetera, there goes your data. Actually another cost consideration is the hardware costs vs. hosting costs. Hardware dies over time and needs to be replaced. Budgets get cut, and a monthly hosting cost is less likely to be axed compared to a new server cost ever 4-5 years. So, in some sense, I think hosting externally and not on your own local hardware is better. And comparing costs, you may be able to find hosting that works well for a cost that when amortized over 4-5 years is actually cheaper. That is, $20/month (let's say) * 12 months * 4 years = $960 for 4 years. This is comparable to some cheaper machines which perfectly suffice, but I know I prefer to drool over the $2500+ machines. :) Sadly, you aren't likely to be continually upgrading components. After 4 years, a locally owned piece of hardware will have dropped from a middle class machine to low end machine, while the hosted environment may have progressed, because of hosting provider upgrades. :) And, you aren't having to do your own backups, if you hosting on the cloud. If you have locally hosted machine, you need to figure out how to back up elsewhere. A good backup plan has on-site same drive, on-site different drive, and off-site backups. A hosting provider tends to have these in place. Do you want the hassle of having that yourself? This is related to the point that BWS Johnson made. And what if your local machine dies? Sure you have a backup, but you actually have to spend the day rushing around buying a new server. With hosting, hardware failures like that are not your worry. No budget stresses, because you don't have the cash to go buy it now, and most service level agreements give you less than a hour downtime per year. GPML, Mark Tompsett -- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center 1100 16th St, NW Washington, DC 20036 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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 http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Cloud-based Koha vs locally hosted Koha
That's a very encouraging and affirmative recommendation. Thank you Elaine. On Wed, Dec 10, 2014 at 1:12 PM, Elaine Bradtke e...@efdss.org wrote: Our system is run in the cloud. We felt this was more secure/reliable than running it from our internal server. We recently shifted from one virtual machine to another, including a change in the version of Linux we run. Of all the online services we have, Koha was the easiest one to move, and had the fewest problems with the changes. On Tue, Dec 9, 2014 at 7:06 PM, Jesse Lambertson jlambert...@sqcc.org wrote: Thank you mark. We already do have a good plan for back-up. But with these other issues, your points are valid and jive with some other conversations I am having as we get ready to set this up (soonish). I will have to look at Brooke's other point about carefully picking the (external) hosting environment - one that gives me command-line access to update everything as needed. The idea in this thread here seems to be that hosting elsewhere means that it will not be as easy for me to update. But I have to imagine there is some host out there that has everything partitioned in a way so that I can manipulate my own data at will (maybe that is still just a dream). I will dig into that search next. Thank you everyone. Jesse On Tue, Dec 9, 2014 at 1:56 PM, Mark Tompsett mtomp...@hotmail.com wrote: Greetings, On 10 December 2014 7:06:37 am NZDT, BWS Johnson abesottedphoe...@yahoo.com wrote: [SNIP] The only difference I can spot might actually weigh as a positive in favour of cloud based service. When you have a physical server and suffer a local catastrophe, such as an earthquake, fire, sinkhole, et cetera, there goes your data. Actually another cost consideration is the hardware costs vs. hosting costs. Hardware dies over time and needs to be replaced. Budgets get cut, and a monthly hosting cost is less likely to be axed compared to a new server cost ever 4-5 years. So, in some sense, I think hosting externally and not on your own local hardware is better. And comparing costs, you may be able to find hosting that works well for a cost that when amortized over 4-5 years is actually cheaper. That is, $20/month (let's say) * 12 months * 4 years = $960 for 4 years. This is comparable to some cheaper machines which perfectly suffice, but I know I prefer to drool over the $2500+ machines. :) Sadly, you aren't likely to be continually upgrading components. After 4 years, a locally owned piece of hardware will have dropped from a middle class machine to low end machine, while the hosted environment may have progressed, because of hosting provider upgrades. :) And, you aren't having to do your own backups, if you hosting on the cloud. If you have locally hosted machine, you need to figure out how to back up elsewhere. A good backup plan has on-site same drive, on-site different drive, and off-site backups. A hosting provider tends to have these in place. Do you want the hassle of having that yourself? This is related to the point that BWS Johnson made. And what if your local machine dies? Sure you have a backup, but you actually have to spend the day rushing around buying a new server. With hosting, hardware failures like that are not your worry. No budget stresses, because you don't have the cash to go buy it now, and most service level agreements give you less than a hour downtime per year. GPML, Mark Tompsett -- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center 1100 16th St, NW Washington, DC 20036 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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) -- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center 1100 16th St, NW Washington, DC 20036 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help
Hi Heather Braum, The result is amazing. Thank you very very much, for the SQL and for your explain, this is what I was looking for. Here, I have one more related query, how to achieve for the same tables, for each collection ( as per collection code). Because, at various time intervals, library inspection team here is most interested in knowing how many unique titles and counts as a whole library and also by collection codes. Thank you again. Satish MV Librarian Govt. Engineering College, Hassan Karnataka INDIA. +91-9449765737 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] z39.50 in Koha
Hello How can we activate z39.50 in Koha In order to obtain records from the World catalog and other libraries ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help
Thank you both Heather and Paul, for helping me on sql report, This will help many librarians here. On Thu, Dec 11, 2014 at 12:43 AM, Paul A pau...@navalmarinearchive.com wrote: At 12:09 AM 12/11/2014 +0530, SATISH wrote: [snip] how to achieve for the same tables, for each collection ( as per collection code). Because, at various time intervals, library inspection team here is most interested in knowing how many unique titles and counts as a whole library and also by collection codes. SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=Enter collection code GROUP BY b.biblionumber; Paul ___ 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] z39.50 in Koha
How can we activate z39.50 in Koha In order to obtain records from the World catalog and other libraries You don't need to activate anything, you just need to have some Z39.50 servers added to Koha, which would normally have been done during the installation process. http://manual.koha-community.org/3.16/en/additionaladmin.html#z3950admin That manual entry also links to http://irspy.indexdata.com/ and http://www.loc.gov/z3950/ which are resources for finding Z39.50 servers you can add to Koha manually. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Add daemon mode to rebuild_zebra.pl on 3.18
Dear all, We have successfully upgraded to 3.18 and encountered a problem when tried to add daemon mode to rebuild_zebra.pl (bug# 6435, from 3.16). Our IT person has supplied the following: [9:50:24 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# ./rebuild_zebra.pl Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. [9:50:35 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# python -V Python 2.7.3 [9:51:03 AM] Alexey - Neo Universe: actually just this: [9:51:04 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# python -V Python 2.7.3 root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# ./rebuild_zebra.pl Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. Have we missed something? Iming - Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: im...@translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Add-daemon-mode-to-rebuild-zebra-pl-on-3-18-tp5821814.html Sent from the Koha-general 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] Zebra facets warning
Dear all, We have recently upgraded to 3.18 and I just noticed the following warning found in staff client under About System Information: The use_zebra_facets entry is missing in your configuration file. Falling back to legacy facet calculation. How do we resolve this issue? Thank you in advance for your help. Iming - Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: im...@translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Zebra-facets-warning-tp5821815.html Sent from the Koha-general 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] Usage Stats Library Type
In 3.18, there's a system preference under Administration for Sharing anonymous usage statistics. Unfortunately, we can't choose a library type because we are neither a public library under the usual definition or a university. We are a special or government library. How can we add that? Lenora ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help (Paul A)
Hi Paul Heather, The report you developed for Satish below is very helpful, but I'd like to tweak it a little differently - I've tried every variation I can think of with no luck (I don't have very much SQL experience)... how can I get it to select by branch, rather than collection code? SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=Enter collection code GROUP BY b.biblionumber Thanks so much for your sharing of this report. Kerrie Stevens Harvest Bible College Melbourne, Australia ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help (Paul A)
Kerrie, to select by homebranch, you just need to add a branch parameter, i.homebranch=choose branch|branches So the statement will now look like SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.homebranch=Choose branch|branches GROUP BY b.biblionumber In case anyone is interested in learning more, parameters are further explained on the Koha community wiki ( http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters). There's two basic kinds of parameters (that I at least use a lot with Koha report writing on my system) -- and you can add multiple parameters to your reports: 1. Add option to add text manually -- Examples: i.ccode=Enter collection code OR i.homebranch=Enter homebranch You then would type the corresponding branchcode or collection code into the text box when running the report (the two examples mentioned use branchcode or collection code, but this method works for lots of other fields in Koha, too) OR 2. Add option to Choose from dropdown list -- Examples: i.ccode=Choose collection code|CCODE OR i.homebranch=Choose homebranch|branches (what you use after the | character may vary a little bit, depending on what field you're setting up the parameter for). Hope this helps! 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* On Wed, Dec 10, 2014 at 7:19 PM, Kerrie Stevens kstev...@harvest.edu.au wrote: Hi Paul Heather, The report you developed for Satish below is very helpful, but I'd like to tweak it a little differently - I've tried every variation I can think of with no luck (I don't have very much SQL experience)... how can I get it to select by branch, rather than collection code? SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=Enter collection code GROUP BY b.biblionumber Thanks so much for your sharing of this report. Kerrie Stevens Harvest Bible College Melbourne, Australia ___ 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] Potential XSS attack vector in opac
Op 10/12/14 om 18:01 schreef Robin Sheat: I expect this to happen tomorrow, though I'll be conferencing then so I can't promise exactly when it'll happen. 3.16.05 packages are now available in the 'oldstable' repo. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search: Biblios not found after reindexing
Hi Chris Am 10.12.2014 18:57, schrieb Chris Cormack: Hi Beda What version did you upgrade from. 3.18.x uses DOM not GRS1 for indexing, I suspect that is your problem Mirko suggested to add: zebra_bib_index_modegrs1/zebra_bib_index_mode zebra_auth_index_modegrs1/zebra_auth_index_mode zebra_lockdir/var/lock/koha/__KOHASITE__/zebra_lockdir use_zebra_facets1/use_zebra_facets at the end of koha-conf.xml. After a new reindexing koha works as berfore. I upgraded from the latest 3.16. My use of koha is quite old. I started about 5 years ago and upgraded regulary. I guess that's why my koha still uses GRS1. Should I change to DOM? How? Thank you Beda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Usage Stats Library Type
Hi Lenora, I have filed bug 13436 to add more options to the list: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13436 Could you take a look and maybe add the options you think are missing in a comment? Thanks, Katrin Am 11.12.2014 um 01:41 schrieb Lenora Oftedahl: In 3.18, there's a system preference under Administration for Sharing anonymous usage statistics. Unfortunately, we can't choose a library type because we are neither a public library under the usual definition or a university. We are a special or government library. How can we add that? Lenora ___ 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] Search: Biblios not found after reindexing
Hi Beda, a similar problem was reported on Bugzilla: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13396 Hope this helps, Katrin Am 10.12.2014 um 18:57 schrieb Chris Cormack: Hi Beda What version did you upgrade from. 3.18.x uses DOM not GRS1 for indexing, I suspect that is your problem I am going to be in a conference all day so hopefully someone else can help Chris On 11 December 2014 6:27:58 am NZDT, Beda Szukics b...@kollegium-sarnen.ch wrote: Hallo I upgraded today to koha 3.18.1 using the debian packages. I noticed that the links between authority records and bibligraphic records weren't updated using koha-rebuild-zebra So I tried a full reindex: koha-rebuild-zebra -f kb I get: 16:41:54-10/12 zebraidx(4827) [warn] Couldn't open collection.abs [No such file or directory] 17:05:59-10/12 zebraidx(4827) [fatal] reckeys.c:214: Out of memory - malloc(364288000 bytes) Right now I can't search biblios any more. An authority search does fine, but the the used in-row shows allways 0 results. What shall I do? Beda ___ 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
