Re: [Koha] SQL queries to delete records from the database?
Op 24-07-12 00:57, Sonia P. schreef: > OK, I guess it wasn't a good idea... I all messed up the indexes or I don't > know what (strange links in search results) and we need to restore the last > back-up. > No drama but very disappointed as it was my last idea. I am ready to resign > or commit harakiri. Did you run a full re-index? It's always very important to rebuild zebra after modifying the database directly. Very important. -- 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
[Koha] Kohacon13
Hi All (and especially the folks from Reno) Now that the vote is all in, and we have our winner (it was a very high voter turnout too, so should be a super big Kohacon) I wonder if some tentative dates have been thought of? Will it be October or September? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha error
Sir Iam using Koha (V.3.00.05.003) software in our library, present we are using only one ID & PW for all the modules(Like Acquision, Calalogue, Circulation etc), some times it creates problems, please guide me 1. How can we creat seperate ID & PW for each module. 2. How can we creat the ID & PW for Patrons, it helps themself can check their record and renew the borrowed documents. regards Pandu. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-error-tp5720900.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] SQL queries to delete records from the database?
Yes, I did. And actually it looks like I didn't mess anything with my deletions this morning. I thought it was strange, but after reloading the back-up it looks the same. I guess I just didn't pay attention what the search results look like (in the item column). Anyway, I didn't delete these records for fun, I thought it would help solve our problem with reindexing, and it didn't. Just after uploading the database, I run a reindex and then I created a new record and then waited for zebra to reindex (every 15 minutes on the cronjob). But it didn't. I didn't check if it has run at all or if it hasn't reached the last records. I thought these faulty records were preventing zebra from reaching the last records... So, after that I just put back the old database (as I thought my SQL things were messing up with the search results). Yes, Bob, I guess a professional would solve the problem... I am doing this as a voluntary job, but it's taking too much time for me now and I am no good. We are paying someone for the server, so he helps me with all the technical things, but he doesn't know Koha especially. Very disappointing situation for me... Especially because I pushed them (when I was working for them) to change from their old library software to Koha. I feel responsible, though I still believe in Koha of course. Our organisation used to work with a Koha support company, but that wasn't working greatly. That's when I took over... (you will know everything :)) Thanks for your help! Cheers, Sonia. > Date: Tue, 24 Jul 2012 10:26:58 +0200 > From: ro...@catalyst.net.nz > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] SQL queries to delete records from the database? > > Op 24-07-12 00:57, Sonia P. schreef: > > OK, I guess it wasn't a good idea... I all messed up the indexes or I > > don't know what (strange links in search results) and we need to restore > > the last back-up. > > No drama but very disappointed as it was my last idea. I am ready to > > resign or commit harakiri. > > Did you run a full re-index? It's always very important to rebuild zebra > after modifying the database directly. > > Very important. > > -- > 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Let's fix it together!
Daniel, I don't know if this is within the scope of the project, but as an > example of a search that doesn't work, last year I spent a lot of time > & effort failing to come up with a search query that would show all > new titles at a branch. > > I constructed a CCL query I thought would return biblios having at > least one item with both a given branch and an acquisition date in the > last 30 days. But among the search results was a biblio with two > items, one at the desired branch but acquired more than 30 days ago, > and one acquired in the last 30 days but at a different branch. > > Galen ultimately confirmed for me that you can't query for an item > that meets two conditions, as CCL queries extend across the whole > biblio--if one item in a biblio meets one of the conditions and > another item meets the other condition, the biblio is returned. > There are two issues going on with this search. The first is the indexing configuration which is not part of the proposal. The second is the query syntax. If we fixed the indexing (which wouldn't be too hard), writing a search that took advantage of the composed index would still be highly problematic. In fact, I think the only way to do it right now would be to use PQF to do a regular expression search to find all books added at a branch in the last two months. I'm making up a new composed index that consists of "branch|acquisition date," and may be putting some of the terms in the wrong order but here's an example of what I mean: pqf=@attr 3=1 @attr 5=102 @attr 2=3 @attr 1=9952 "branch|20120[67]" You could try the following, as well, though I wouldn't really recommend it: ccl=itemacq,regexp-1,first-in-field:branch|20120[67] I'm sure a similar search would be possible in Solr, as well, but it would not be portable. Once you figured how how to do the search in Zebra, you would have to start all over again if you decided to switch to Solr or vice versa. In contrast, if we parsed queries ourselves, that search could be: itemacq like "^branch|20120[67]" (and it would work in both search engines) You could also, of course, just use the PQF search and it would be translated into something that Solr could understand. Hope that helps clarify. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Change frequency of e-mail lists
Hello, I am Joyce Swope at the Crown College of the Bible. I am a new subscriber to the Koha lists. Currently I receive them daily, please change it so that I will be receiving it monthly. Thanks, Joyce ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Change frequency of e-mail lists
Op 24-07-12 14:36, Joyce Swope schreef: > Hello, > > I am Joyce Swope at the Crown College of the Bible. I am a new subscriber > to the Koha lists. Currently I receive them daily, please change it so that > I will be receiving it monthly. If you go an have a look at the mailing list settings for your subscription (see the bottom of any email from the list), then you can change some things there. However, I don't think it's possible to change the frequency of the digests. Additionally, monthly would mean in the order of 400 emails per digest, which is undoubtedly the same as not being subscribed at all. -- 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] Change frequency of e-mail lists
Hi Joyce. As far as I can see there is no option to get a monthly digest, only a daily one: http://lists.katipo.co.nz/mailman/listinfo/koha You have to change the settings yourself using the email address and password you registered with. David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 25 July 2012 00:36, Joyce Swope wrote: > Hello, > > I am Joyce Swope at the Crown College of the Bible. I am a new subscriber > to the Koha lists. Currently I receive them daily, please change it so that > I will be receiving it monthly. > > Thanks, > Joyce > ___ > 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] Change frequency of e-mail lists
Robin Sheat wrote am 24.07.2012 14:42: > Op 24-07-12 14:36, Joyce Swope schreef: >> Hello, >> >> I am Joyce Swope at the Crown College of the Bible. I am a new subscriber >> to the Koha lists. Currently I receive them daily, please change it so that >> I will be receiving it monthly. > > If you go an have a look at the mailing list settings for your > subscription (see the bottom of any email from the list), then you can > change some things there. However, I don't think it's possible to change > the frequency of the digests. Additionally, monthly would mean in the > order of 400 emails per digest, which is undoubtedly the same as not > being subscribed at all. > In addition to that, you may consider reading the list online then without being subscribed. The archives can be found here http://lists.katipo.co.nz/pipermail/koha/ and the mailing list in form of several forums can be found here http://koha-community.org/support/forums/ -- Mirko ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error while installing koha on development mode
Hi. I've never setup Koha from git so can't offer much help with doing that. You may find something that may help in the wiki: http://wiki.koha-community.org/wiki/Category:Development All the prerequisites need to be installed first though - see the install instructions: http://wiki.koha-community.org/wiki/Category:Installation Is there a reason you want to use a development version i.e. are you going to be doing development? Otherwise you may wish to use a stable release (now 3.8.3 and 3.6.7) either through a manual install or using the packages. David Nind On 21 July 2012 22:24, amit bondwal wrote: > Hi, > > Thanks for you reply. I am using koha version of koha-community. > And I downloaded the developer version of koha from git koha-community. > I want to install it in developer mode. > It shows the error when I run perl Makefile.PL. > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Kohacon13
Thanks for asking Chris. We are discussing that very subject today. Looks like the first week in October would be a good time for coming to Reno. Nancy Keener Systems Librarian I.T.O.S.C Chair Washoe County Library System Reno, Nevada 775 327-8347 nkee...@washoecounty.us -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Tuesday, July 24, 2012 2:40 AM To: koha-user Subject: [Koha] Kohacon13 Hi All (and especially the folks from Reno) Now that the vote is all in, and we have our winner (it was a very high voter turnout too, so should be a super big Kohacon) I wonder if some tentative dates have been thought of? Will it be October or September? Chris ___ 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 not working after upgrade
Our system uses 090 tags instead of the default 952 tags for items...could this be related to why my search is screwed up? If I choose administration->koha to MARC mapping these are the options that are set under items: Koha field Tag SubfieldLib itemnumber 090 g Koha biblioitemnumber (auto-generated) Edit barcode 090 e Piece designation (barcode) Edit homebranch 090 b School Code Edit itemcallnumber 090 a Koha full call number Edit ccode 090 f Collection Edit volumenumber090 d Volume Number Edit -- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182p5721006.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] Search not working after upgrade
Ryan, Our system uses 090 tags instead of the default 952 tags for items...could > this be related to why my search is screwed up? If I choose > administration->koha to MARC mapping these are the options that are set > under items: > > Koha field Tag SubfieldLib > itemnumber 090 g Koha biblioitemnumber (auto-generated) > Edit > barcode 090 e Piece designation (barcode) Edit > homebranch 090 b School Code Edit > itemcallnumber 090 a Koha full call number Edit > ccode 090 f Collection Edit > volumenumber090 d Volume Number Edit > This would be the problem, yes. Right now changing Koha to MARC mappings has no effect on searching. With search rewritten it would be fairly straightforward to respect the mappings for searches. Until that's done, though, you will need to change your mappings to use the standard 952 fields (and hope for the best). Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Solr
Does anyone know if switching from Zebra to Solr will let Koha libraries use a stopwords list? Also, will Solr have any effect on fuzzy searching defaults? Lastly, is there anyone sponsoring or working on a "did you mean..." opac response to zero retrieval searches? At our library, we'd probably choose a "did you mean..." spelling suggestion choice over the automatic fuzzy spelling assumptions that are currently in the system. I realize this would probably be listed in bugzilla, but I'm not sure exactly how to search for this. -- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.po...@manhattan.edu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Solr
On 25 July 2012 08:15, Stacy Pober wrote: > Does anyone know if switching from Zebra to Solr will let Koha > libraries use a stopwords list? > > Also, will Solr have any effect on fuzzy searching defaults? > > Lastly, is there anyone sponsoring or working on a "did you mean..." > opac response to zero retrieval searches? At our library, we'd > probably choose a "did you mean..." spelling suggestion choice over > the automatic fuzzy spelling assumptions that are currently in the > system. I realize this would probably be listed in bugzilla, but I'm > not sure exactly how to search for this. > Stacy Koha is not switching to Solr, but now (in master) you can choose between using Solr or Zebra. (YMMV with other software based originally on Koha). This is already working in the master branch. Also, in Koha itself using zebra (I don't know what the forks are doing) you can now use DOM indexing which is much more powerful than the old indexing methods. But we want to do much more than that, if you look at the thread starting here http://lists.katipo.co.nz/pipermail/koha/2012-July/033634.html You will see what the future plans are. (This does include did you mean). Hope this helps Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Kohacon13
On 25 July 2012 03:59, Keener, Nancy wrote: > Thanks for asking Chris. We are discussing that very subject today. Looks > like the first week in October would be a good time for coming to Reno. > Excellent, thank you That will help trying to figure out funding :) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Solr
Stacy, I'll address the points that are not answered in the proposal that Brooke linked to. Does anyone know if switching from Zebra to Solr will let Koha > libraries use a stopwords list? > Solr allows the use of stopwords (as would a decent query parser such as the one I propose writing). However, the Solr code in Koha right now does not make use of the stopwords feature. To my mind, that is a good thing. If we used stopwords, the poetry journal The would be unfindable (and yes, there is such a journal: I had a nightmare and a half trying to find the record when I had an issue to catalog at the NYPL; thankfully their catalog doesn't throw away stopwords anymore). And things would be even worse when searching for French books. Consider the case of the À thé and Le thé. In the US we would probably search for "a the" and "le the." If someone can > Also, will Solr have any effect on fuzzy searching defaults? > It will. Fuzzy searching has completely different semantics in Solr compared to Zebra. We briefly noted that fact in the proposal, along with a footnote identifying the algorithms that Solr uses for fuzzy searching (and, yes, I am aware that the second algorithm listed is generally used as an alternate name for the first... I have no explanation of why the Solr docs used the two names like they were different). Whether the "fuzzy" behavior is closer to what you want I could not say. My personal preference, like yours, is to not be fuzzy, and just suggest better searches. Lastly, is there anyone sponsoring or working on a "did you mean..." > opac response to zero retrieval searches? At our library, we'd > probably choose a "did you mean..." spelling suggestion choice over > the automatic fuzzy spelling assumptions that are currently in the > system. I realize this would probably be listed in bugzilla, but I'm > not sure exactly how to search for this. > We have not yet added bugs for the various parts of the search rewrite. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Solr
Stacy, > Solr allows the use of stopwords (as would a decent query parser such as > the one I propose writing). However, the Solr code in Koha right now does > not make use of the stopwords feature. To my mind, that is a good thing. If > we used stopwords, the poetry journal The would be unfindable (and yes, > there is such a journal: I had a nightmare and a half trying to find the > record when I had an issue to catalog at the NYPL; thankfully their catalog > doesn't throw away stopwords anymore). And things would be even worse when > searching for French books. Consider the case of the À thé and Le thé. In > the US we would probably search for "a the" and "le the." If someone can > Whoops, I accidentally deleted several sentences when I hit send. Picking up where I left off: If someone can make a compelling case for stopwords, we could, of course, add their use to the proposal as an optional feature. That said, it is my opinion that any catalog that requires stopwords in order to offer relevant results is broken. Relevance ranking should take into account that a given word in a query is statistically overrepresented in the results, and therefore should be considered less relevant than other words in the query. Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Neat participation / bug fixing dashboard from WikiHow
Salvete! Last meeting, I tried in vain to describe how cool the wikiHow Community Dashboard is. Hopefully this link is viewable without logging in. Let me know if you all can't see it, and I'll screenshot it and upload it to the wiki. http://www.wikihow.com/Special:CommunityDashboard Hopefully something like that tailored for us will lead to greater participation since it's such a great visualisation of what needs doing where. :D Cheers, Brooke ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Neat participation / bug fixing dashboard from WikiHow
On 25 July 2012 11:00, BWS Johnson wrote: > Salvete! > > Last meeting, I tried in vain to describe how cool the wikiHow Community > Dashboard is. Hopefully this link is viewable without logging in. Let me know > if you all can't see it, and I'll screenshot it and upload it to the wiki. > > http://www.wikihow.com/Special:CommunityDashboard That does look fantastic. > > There is a git repository for the Koha dashboard http://dashboard.koha-community.org/ That lives at https://gitorious.org/koha-dashboard (In the next bit I will be using you a lot, this refers to the collective you, or y'all :) not Brooke) If people wanted to extend it, they are more than welcome to work on it. I'm unlikely to get more free time to work on it in the near future. These project always run into the problem of not enough hours in the day. Which leads me to my next point, we need more people to get involved. Something like the dashboard is great, you won't/can't break Koha, no one will lose circulation statistics if you make a mistake. It needs things you might have skills in, design, css, html, javascript, wordsmithery (i just made that one up). It's a great intro into getting more involved, then you can move to signing off. http://blog.bigballofwax.co.nz/2012/07/09/do-some-signoffs-you-know-you-want-to/ Then let us know how you choose what to sign off. http://blog.bigballofwax.co.nz/2012/07/10/choosing-something-to-sign-off/ So it can help us encourage others to do some. You have a distinct advantage with Koha, you can have direct influence, and a small change you make, say highlighting the needs signoff section in a way that makes it stand out and thus get more people looking at it, may get 20 new features into Koha. Reading back, I sound like a bit of a idealistic/pompous fool, so I feel like I should end with "Hold your ground, hold your ground! Sons of Gondor, of Rohan, my brothers! I see in your eyes the same fear that would take the heart of me. A day may come when the courage of men fails, when we forsake our friends and break all bonds of fellowship, but it is not this day. An hour of woes and shattered shields, when the age of men comes crashing down! But it is not this day! This day we fight! By all that you hold dear on this good Earth, I bid you *stand, Men of the West!* " Thus I have Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 81, Issue 54
Well said, oh man from Middle Earth! Dianna Roberts Wellington, New Zealand -- Message: 3 Date: Wed, 25 Jul 2012 11:28:59 +1200 From: Chris Cormack To: BWS Johnson Cc: "koha@lists.katipo.co.nz" Subject: Re: [Koha] Neat participation / bug fixing dashboard from WikiHow Message-ID: Content-Type: text/plain; charset=UTF-8 On 25 July 2012 11:00, BWS Johnson wrote: > Salvete! > > Last meeting, I tried in vain to describe how cool the wikiHow Community Dashboard is. Hopefully this link is viewable without logging in. Let me know if you all can't see it, and I'll screenshot it and upload it to the wiki. > > http://www.wikihow.com/Special:CommunityDashboard That does look fantastic. > > There is a git repository for the Koha dashboard http://dashboard.koha-community.org/ That lives at https://gitorious.org/koha-dashboard (In the next bit I will be using you a lot, this refers to the collective you, or y'all :) not Brooke) If people wanted to extend it, they are more than welcome to work on it. I'm unlikely to get more free time to work on it in the near future. These project always run into the problem of not enough hours in the day. Which leads me to my next point, we need more people to get involved. Something like the dashboard is great, you won't/can't break Koha, no one will lose circulation statistics if you make a mistake. It needs things you might have skills in, design, css, html, javascript, wordsmithery (i just made that one up). It's a great intro into getting more involved, then you can move to signing off. http://blog.bigballofwax.co.nz/2012/07/09/do-some-signoffs-you-know-you-want -to/ Then let us know how you choose what to sign off. http://blog.bigballofwax.co.nz/2012/07/10/choosing-something-to-sign-off/ So it can help us encourage others to do some. You have a distinct advantage with Koha, you can have direct influence, and a small change you make, say highlighting the needs signoff section in a way that makes it stand out and thus get more people looking at it, may get 20 new features into Koha. Reading back, I sound like a bit of a idealistic/pompous fool, so I feel like I should end with "Hold your ground, hold your ground! Sons of Gondor, of Rohan, my brothers! I see in your eyes the same fear that would take the heart of me. A day may come when the courage of men fails, when we forsake our friends and break all bonds of fellowship, but it is not this day. An hour of woes and shattered shields, when the age of men comes crashing down! But it is not this day! This day we fight! By all that you hold dear on this good Earth, I bid you *stand, Men of the West!* " Thus I have Chris -- ___ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 81, Issue 54 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha