- Koha - lists.katipo.co.nz

Re: [Koha] Catalogue - SQL Report Help (Paul A)
by Kerrie Stevens 11 Dec '14

11 Dec '14

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

2 1

Zebra facets warning
by Iming Chan 11 Dec '14

11 Dec '14

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: iming(a)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.

1 0

z39.50 in Koha
by Nisreen Qabbani 10 Dec '14

10 Dec '14

Hello How can we activate z39.50 in Koha In order to obtain records from the World catalog and other libraries

2 1

Catalogue - SQL Report Help
by satishamv 10 Dec '14

10 Dec '14

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.

5 10

Cloud-based Koha vs locally hosted Koha
by Jesse Lambertson 10 Dec '14

10 Dec '14

Happy Tuesday everyone, I have a question about installation of Koha. Relative to hosting Koha in the cloud as opposed to on our own local servers on our domain (which I assume most people do), what is the thinking about the ease of installing and updating if it is hosted "externally" versus on our own servers? What steps might drastically change if we install Koha in the cloud? Are there any security issues I should be concerned about in either case? Thank you in advance for your thoughts. Jesse -- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center 1100 16th St, NW Washington, DC 20036

6 7

MYSQL to SQL Sever
by Sina Stewart 10 Dec '14

10 Dec '14

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

7 9

Reindexing after switching from GRS1 to DOM
by Iming Chan 10 Dec '14

10 Dec '14

Dear all, We have changed our indexing method from GRS1 to DOM on last Sunday and as I write (Tuesday), the reindexing of bib records still going and no sign of finishing soon. We only have just over 6,000 bib. records. According to our IT person, reindexing is definitely continuing, but there is no indication how far it has done and no much more to go! Anyone encountered similar experience on the speed of reindexing? Kind 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: iming(a)translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Reindexing-after-switching-from-GRS1-to-D… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Showing the last item checked out with AJAX circulation
by Owen Leonard 09 Dec '14

09 Dec '14

One of the issues we're having with the new AJAX circulation feature is that we can't take advantage of the speed gains obtained by not showing checkouts by default because we need confirmation that the last item we scanned was successfully checked out. Kyle has offered a patch for Bug 13315, " Add feedback for last item checked out to circulation.pl" which updates the display so that a message shows with information about the last item scanned. Here's a screenshot: http://www.screencast.com/t/qNw2U3hwz I think this is an important improvement, but I'm inclined to do something less obtrusive: http://www.screencast.com/t/1gsa2prF ...on the assumption that the visual aspect of checking out was working fine before AJAX circ, and fixes to AJAX circ should look to returning things to a proven-functional state. However, always assuming that it was better before would prevent us from making improvements, so I'd love to hear others' opinions -- especially from anyone who is running this feature in production. Thanks, -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

4 4

FOSS Conference - Call for Papers
by glaws 09 Dec '14

09 Dec '14

http://www.kansaslinuxfest.us/pages/call-for-papers.html FOSS conference March 2015 in Lawrence, KS, USA. Call for papers. Koha anyone? -- Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506

1 0

how to install koha in my website (linux hosting with cpanel)
by pratikpt 09 Dec '14

09 Dec '14

Hello,any one can suggest or guide me on koha installation in my website.i have linux webhosting and use via cpanel.Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/how-to-install-koha-in-my-website-linux-h… Sent from the Koha-general mailing list archive at Nabble.com.

4 4