- Koha - lists.katipo.co.nz

analytics
by Haik Zargaryan 09 Jul '13

09 Jul '13

Dear friends, I want to activate Analytics feature in our system. So, I have set the system preference UseControlNumber to Use. Then, I have edited the Child record (i.e. made the host item entries in the field 773) and it worked. However, when I passed to the Parent record, something went wrong. I have filled the 774 field (child's control number in w and title in t). As a result, Analytics: Show Analytics appeared on the record, But when I follow the link, no result is found. In the search box I have the query "rcn:000502577 and (bib-level:a or bib-level:b)". Any suggestions? regards, haik.

1 0

Koha Reports and Info
by Phillip Ponchot 09 Jul '13

09 Jul '13

As a tech, I have some background in SQL but I'm trying to get a handle on Koha's database and report system. I currently have two reports which are SQL created as far as I can tell. (I've tried to duplicate it via the Report Generator and it didn't work out for me). The SQL is: Today: SELECT distinctrow date(datetime) as Date, type as Type, count(*) as Count FROM statistics, borrowers WHERE (statistics.borrowernumber=borrowers.borrowernumber) AND datetime is not null AND date(datetime) = date(now()) group by type order by datetime Yesterday: SELECT distinctrow date(datetime) as Date, type as Type, count(*) as Count FROM statistics, borrowers WHERE (statistics.borrowernumber=borrowers.borrowernumber) AND datetime is not null AND date(datetime) = date(subdate(now(), interval 1 day)) group by type order by datetime I'm trying to add to this report the following: 1. A count of the number of new patron cards issued. 2. A count of the number of patron cards renewed. If anyone could give me a push in the right direction, I would appreciate it as I am lost right now.

1 0

Help Re: Journal Articles
by Alice Esguerra 09 Jul '13

09 Jul '13

Hello everyone, We are new with Koha, we started 2 years ago with Koha 2.9 and recently migrated to Koha 3.12 (May of this year). My concern is about our periodical indexes. We have manually encoded about 1000 records of indexes to journal and magazine articles. I'd like to create a MARC framework for this. Can somebody please help us as to what MARC tags to use for the framework? I have seen the discussion about "Analytics" but I don't think this is applicable to us because we only prepared records for the "component articles" while the "parent or host item" (for journals) were not recorded in our OPAC. Our objective is to make a simple framework that is searchable and wouldn't have any conflict with the MARC rules. We really hope to hear from you. Thank you in advance! alice -- Alicia C. Esguerra Associate Professor I/ Librarian Bulacan State University City of Malolos, Bulacan 3000 Philippines +63 044 7961417 www.bulsu.edu.ph

3 2

Migrate Oliver data
by clint.deckard 09 Jul '13

09 Jul '13

Greetings, If anyone has any experience migrating from Softlink Oliver to Koha I would appreciate it if you would share any tips or tricks you have. Many thanks, Clint.

2 1

Magazines - Counting Issues
by Maxine Murphy 09 Jul '13

09 Jul '13

Hi, I am wanting to produce a report, if possible that shows the following information. * Title of magazine * Number of issues per title * In a given Date period cheers Maxine Murphy Technical Services and Systems Administrator Waitaki District Libraries

1 0

Re: [Koha] Help Re: Journal Articles
by Paul 08 Jul '13

08 Jul '13

At 09:43 AM 7/8/2013 -0400, King, Fred wrote: >Hello Alice, and everyone, > >Funny you should bring this up. I was planning to bring it up myself a >while later after we got our system running smoothly, but this seems like >a good time since we're not the only ones interested in this kind of a project. We're also interested in serial indexing in Koha. At the moment, we are using our "old" web indexing from a direct 856u and 856z link in Koha (see example at <http://opac.navalmarinearchive.com/cgi-bin/koha/opac-detail.pl?biblionumber…>) but given that we hold about half a million journals and periodicals, this is not the most elegant solution, and requires substantial manual intervention for ongoing subscriptions. I would be quite prepared to put some time and effort into a "Koha solution." Best - Paul >A few years ago, we started Authors' Day, a celebration of Hospital Center >associates who have written articles, book chapters, etc. Last year, we >started tracking the articles in Reference Manager so we could analyze the >data a bit more, and include subject headings, etc., in the citations. The >next step is to put the data into Koha to make it widely and easily >accessible to anyone on the hospital network. Who knows? Someday we might >be able to make it available outside our firewall as well. > >My idea is to install a second instance of Koha on our server (I did it >already on a test system, so that's not a major problem) and use it >exclusively for local authors. Just about everything our associates >publish is in Medline, so one of the things we're pondering is how to >convert MeSH to MARC. Like Alice, we've looked at analytics and we don't >think that's the solution. > >Some of the other things we're considering include: >* We're only interested in indexing local authors, but we ought to include >the non-local co-authors in the record. >* We want to differentiate between journal article, book, chapter, etc. >Maybe Item Types? >* There's also the consideration of what kind of journal article--case >report, letter, randomized controlled trial, etc. Maybe Collection Code? >* Right now we're indexing articles from three MedStar divisions, but >eventually we'd consider adding other hospitals. Different branches? >* We also want to include departmental affiliation. > >So I guess my question is, has anyone else done something like this? Can >anyone offer any pointers? > >BTW, the actual conversion of one set of tags to another is not all that >difficult. I found a program called Replace Text that you can set up to >look for every instance of xxx and convert it to yyy, for multiple values >of xxx and yyy. I'm sure there are others. > >Cheers, > >Fred King >Medical Librarian, MedStar Washington Hospital Center >fred.king(a)medstar.net >202-877-6221 > >---------------------------- Original Message ---------------------------- >Subject: [Koha] Help Re: Journal Articles >From: "Alice Esguerra" <kaces08(a)gmail.com> >Date: Mon, July 8, 2013 12:33 am >To: koha(a)lists.katipo.co.nz >-------------------------------------------------------------------------- > >Hello everyone, > >We are new with Koha, we started 2 years ago with Koha 2.9 and recently >migrated to Koha 3.12 (May of this year). > >My concern is about our periodical indexes. We have manually encoded about >1000 records of indexes to journal and magazine articles. I'd like to >create a MARC framework for this. Can somebody please help us as to what >MARC tags to use for the framework? I have seen the discussion about >"Analytics" but I don't think this is applicable to us because we only >prepared records for the "component articles" while the "parent or host >item" (for journals) were not recorded in our OPAC. Our objective is to >make a simple framework that is searchable and wouldn't have any conflict >with the MARC rules. > >We really hope to hear from you. Thank you in advance! > >alice > > >-- >Alicia C. Esguerra >Associate Professor I/ Librarian >Bulacan State University >City of Malolos, Bulacan 3000 >Philippines >+63 044 7961417 >www.bulsu.edu.ph >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha > > >CONFIDENTIAL: The information contained in this communication, >including its attachments, may contain confidential information and >is intended only for the individual(s) or entity(ies) to whom it is >addressed. The information contained in this communication may also >be protected by legal privilege, federal law or other applicable >law. If you are not the intended recipient of this communication, >you are hereby notified that any distribution, dissemination or >duplication of this communication is strictly prohibited. If you >have received this communication in error, please immediately >delete and destroy all copies of this message and please >immediately notify us of the error by separate communication. Thank >you. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

autoBarcode number start from
by gm3.bappy 08 Jul '13

08 Jul '13

Hello, I want to use auto generated Barcode number. I want to set an offset. Like- It will start from 2000. How can i do this? Any kind of help is appreciable. -- View this message in context: http://koha.1045719.n5.nabble.com/autoBarcode-number-start-from-tp5760040.h… Sent from the Koha-general mailing list archive at Nabble.com.

2 4

Patron Modification log problem
by gm3.bappy 08 Jul '13

08 Jul '13

Hello, I am using KOHA 3.10. I am facing a problem in 'Modification log' option under Patron infomration. The Modification Log shows me when changes were made to the patron record. But in 'Info' column, it shows wrong barcode where every column shows exact information. Please someone help me. <http://koha.1045719.n5.nabble.com/file/n5760529/KOha_Barcode.jpg> -- View this message in context: http://koha.1045719.n5.nabble.com/Patron-Modification-log-problem-tp5760529… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Koha Docker image
by John Fink 05 Jul '13

05 Jul '13

Hey folks, Spent some time today whipping up a Docker (http://docker.io) image for Koha for a talk I'm going to be giving about Docker later this year. If anybody on-list would like to see how it stands up, you can pull it from Docker's index with docker pull jbfink/koha . Note that I am by no means a Koha expert and this is my first time messing with Koha since... oh... 2002 or so, so there may be things with my Koha install which are broken or boneheaded in some way. jf

1 0

Re: [Koha] Koha 3.12.00.000 and stopwords
by Paul 05 Jul '13

05 Jul '13

At 11:18 AM 7/5/2013 -0300, Tomas Cohen Arazi wrote: [snip] >Currently, stopwords are handled in the > /etc/koha/zebradb/lang_defs/<language>/sort-string-utf.chr (find it >somewhere in the zebradb dir if tarball install). > >You will find lines like this: > >map (^The\s) @ > >This example weights "nothing" to the word "The" (followed by space) if it >occurs at the beggining of a sentence. Hence, it won't appear in search >results as desired. Why only at the beginning of a string? Or am I missing something? Best - Paul

3 3