- Koha - lists.katipo.co.nz

Looking for a bit of report help
by Nicole Engard 20 May '14

20 May '14

I'm looking for some help with reports that require more math than my brain can handle. #1: circulation by % coll code within a date range [50% of DVDs circulated] I have this one: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Percentage_of_circs… I'm not sure how to alter it to show the percentage of the DVDs in the collection instead of the percentage of all check outs. #2: DVDs circulating 50% of total DVDs where DVD is a collection code This might be the same as the above ... unless you all read it differently than me. Thanks in advance, Nicole

2 2

On the choice of MARC-format
by zolot 20 May '14

20 May '14

Hello all, "Koha 3.14. Manual (en)" considers "MARC", "MARC21" and "UNIMARC". What principle differences exist between these formats ? My database (i.e. isis-catalog, 100 000 records) has been created in accordance with Ukrainian standard "UKRMARC". What of the indicated formats must be chosen for preferences ? What criteria need to be followed for the choice of marc-format ? Thank you, Gennady

5 4

Password Encryption
by amutsikiwa＠uzlib.uz.ac.zw 20 May '14

20 May '14

Hi I have uploaded a number of patron records via a pup script. However, the password are not working. I have used md5 function. I would like to know which encryption method is used for passwords in Koha. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

2 1

KOHA group E-mail.
by Jerwyn Fernandez 20 May '14

20 May '14

Good day!.. Is there any problem regarding with our group email? Please respond if you were able to receive this mail. I'm just bothered no bother answering my query. If no body responded it means there's really a problem. Just to let you know I'm also confused with the email I received titled "***UNCHECKED*** Thank you, -- *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph*<http://library.southville.edu.ph>

2 1

Job Opening at Koha Library In Reno Nevada Deadline Extended
by Keener, Nancy 20 May '14

20 May '14

POSITION AVAILABLE INTERNET SERVICES LIBRARIAN WASHOE COUNTY LIBRARY SYSTEM RENO, NEVADA Deadline extended to May 27, 2014 The Internet Services Librarian manages the Washoe County Library System website, oversees a popular public Internet access service, helps resolve technical issues and takes part in system-wide planning. Applicants must have a Master's degree in Library Science from an ALA accredited program and two years of professional level library experience, , with an emphasis on managing technology, OR an equivalent combination of education and experience. The successful candidate will have working knowledge of XHTML, XML, XSLT, CSS, MYSQL, PHP, or other scripting languages. Some experience with image software such as Photoshop, Fireworks or Gimp is preferred. This position requires knowledge of Integrated Library Systems. Candidates must be able to prioritize work in a busy environment and have excellent interpersonal relationship skills, with the ability to communicate effectively with people of diverse backgrounds. Salary range $55,972 - $72,758. No state income tax; PERS retirement; with medical, dental, vision, life insurance benefits currently provided at no cost to employee; longevity pay; and voluntary deferred compensation supplementary retirement program available. Applicants must complete a Washoe County Employment Application. For more information and access to the application form see the Washoe County Human Resources Department web site at http://www.washoecounty.us/humanresources/careers/jobs For questions call Karen Jeffers, the Recruiting Analyst at (775) 328-2078 or email KJeffers(a)washoecounty.us Washoe County is located along the eastern slopes of the Sierra Nevada Mountains and is known as a great recreational area. The community has 12 physical library branches with locations in the areas of Reno, Sparks, Incline Village and Gerlach. Deadline for applying has been extended to May 27, 2014. Nancy Keener Systems Librarian I.T.O.S.C. Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

1 0

how many biblio was modified by each staff
by حسين رضوي 20 May '14

20 May '14

Hi, Is there any way to find out how many biblio was modified by each staff of our library? We want to get a reports showing to us the biblio and date to each employee separately. Mr Bernardo Help me and find something on http://wiki.koha-community.org/wiki/SQL_Reports_Library#Titles_added_by_cat… we need to know how many record was edited by each user. Many thanks Hussain A.

2 1

Re: [Koha] ***UNCHECKED*** KOHA users.
by Owen Leonard 20 May '14

20 May '14

> Our library was able to launch KOHA recently and I would like to include it > in the KOHA users around the world. If you are referring to the "Koha Users Worldwide" list on the Koha wiki (http://wiki.koha-community.org/wiki/Koha_Users_Worldwide -- note the spelling of 'Koha' please), the list is editable by any user who registers on the wiki. You can register here: http://wiki.koha-community.org/wiki/Special:RequestAccount -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Upgrade - 3.06 to 3.14
by Tom Hanstra 20 May '14

20 May '14

When upgrading my database between the 3.06.04 version to the 3.14.05 version, I'm getting a lot of database update errors. How do I best track down whether these are causing integrity problems with the data? I can provide a complete list of errors, but maybe I'm missing something more fundamental. Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 208 Hesburgh Library Email: hanstra(a)nd.edu Notre Dame, IN 46556 The nights are getting warmer, it won't be long. Won't be long 'til summer comes... Thin Lizzy -----------------------------------------------------------------------------

1 1

MySQL - Strict checking
by Tom Hanstra 20 May '14

20 May '14

Are there any recommendations regarding the use of strict checking and Koha? I'm upgrading from 3.06 to 3.14 and as part of that I'm moving to MySQL 5.6, which turns strict checking on by default. A lot of database upgrade errors are coming up related to data values which are in the database but don't pass some of the rule checks implemented. Should I be trying to clean that up? Or might future versions of the upgrade process do some of that for me later? Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 208 Hesburgh Library Email: hanstra(a)nd.edu Notre Dame, IN 46556 The nights are getting warmer, it won't be long. Won't be long 'til summer comes... Thin Lizzy -----------------------------------------------------------------------------

1 0

How to repair a table - Koha biblioitems
by Phillip Ponchot 19 May '14

19 May '14

Whenever I run a backup or try a dump, I get a message that contact with mysql has dropped at a particular record. I've tried deleting the record, but the issue just switches to another record. Apparently the table is corrupted. When I try to repair the table with mysqlcheck I get the message that the storage engine does not support repair. Does anyone know of a way to repair this table? I'm rather desperate as I can't get a full backup with this issue. Thanks for any help. Phillip

1 0