- Koha - lists.katipo.co.nz

Re: [Koha] A report for finding records with multiple items?
by Roberts, David 06 Feb '15

06 Feb '15

I haven't actually tried this, but there is a report in the Koha SQL Reports library that looks like it can be adapted to do what you want. The report is called "Records with item count". I reckon you just need to add a 'HAVING' clause which identifies records with more than one copy: *SELECT DISTINCT CONCAT('<a title="Search for all records sharing the title:',b.title,'" href="/cgi-bin/koha/catalogue/search.pl?q=ti%3A <http://search.pl?q=ti%3A>', REPLACE(REPLACE (b.title, ' ', '+'),'?',''),'">Search</a>') AS "Search for Title", b.biblionumber, CONCAT('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber= <http://detail.pl?biblionumber=>',b.biblionumber,'">',b.title,'</a>') AS "Item Title", b.author, t.editionstatement, t.publishercode, t.isbn, count(i.biblionumber) AS "Copies" FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber HAVING copies > 1 ORDER BY Copies ASC* Like I say, I haven't tested it, but I think it should work. Somebody else may have a better way. Cheers David > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 05 Feb 2015 21:17:40 +0100 > From: "andrea.furin(a)slacky.it" <andrea.furin(a)slacky.it> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] A report for finding records with multiple items? > Message-ID: <54D3CFE4.3060107(a)slacky.it> > Content-Type: text/plain; charset=windows-1252 > > Hi. > I'd need to write a report for finding records with multiple items in > them: any suggestions? > TIA > > Andrea Furin > > > ------------------------------ > -- David Roberts Customer Support Consultant. PTFS Europe Ltd. david.roberts(a)ptfs-europe.com Skype: david.roberts.2 http://www.ptfs-europe.com <http://t.sigopn04.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4QBdV-N3…>

1 0

Marc in spreadsheet
by andrea.furin＠slacky.it 06 Feb '15

06 Feb '15

Hi. I need a way to transform my marc file from koha in a spreadsheet file (excel or libreoffice): there is a way? Thanks in advance Andrea Furin

2 1

Post recently catalogued books to a Facebook page
by Witoszynskyj Stephan 05 Feb '15

05 Feb '15

Hi, I recently wrote on this list that I’m about to develop a script that posts recently catalogued books to a Facebook page. Well, I found some time faster then I thought, so here’s my simple script. I’ll run it using koha-foreach in a cronjob. It does nothing fancy it just posts a list of recently catalogued books in the form author: title http://yourlibrary.org/bib/number in the time line of a Facebook page. I also tried uploading cover images, but that didn’t work that well. Actually, the whole script is rather trivial. Figuring out how to get access tokens for Facebook having the correct permissions took much longer then developing the script. So, I tried to summarize the steps necessary to get the tokens in the script’s comments. I hope they are helpful. Cheers, Stephan #!/usr/bin/perl use utf8; use Modern::Perl; use C4::Context; use Facebook::Graph; # This program posts a list of recently catalogued books to Facebook "Page". # To be able to get the required access tokens you have to have administrator # rights for the page. # # 1. Register as developer on Facebook's developer site: # https://developers.facebook.com # 2. Add an app on Facebook's developer site. Use "advanced Setup", choose a # name and the category "Apps for pages". You'll get an app id and an app # secret # 3. get an user access token on https://developers.facebook.com/tools/explorer # by clicking "Get Access Token", set the "Extended Permissions" manage_pages and publish_actions (make sure that you do that for your app and not for Graph Explorer) # 4. extend the expiration date of the access token by submitting the following # GET request: # /oauth/access_token?grant_type=fb_exchange_token&client_id={app-id}&client_secret={app-secret}&fb_exchange_token={short-lived-token} # You can this using wget: # wget -O token "https://graph.facebook.com/wget -O token "https://graph.facebook.com/oauth/access_token?grant_type=fb_exchange_token&… # the file token will then contain your token # 5. determine your user id e.g. by http://graph.facebook.com/yourusername # 6. get the page access token by submitting the following GET request in # Graph API explorer: # /{user-id}/accounts # You will get a data structure containing a number of key # value pairs for each page you administrate. Get the page id and page # access token for the page you want to post to my $fb_access_token = „"; # your page access token goes here my $maxdays = 7; my $base_url = 'http://yourlibrary.org'; my $fb = Facebook::Graph->new; $fb->access_token($fb_access_token); my $tmpdir = File::Temp->newdir(); my $dirname = $tmpdir->dirname; my $dbh = C4::Context->dbh; my $query = "SELECT b.biblionumber,b.author,b.title,i.itemcallnumber FROM biblio b, items i WHERE b.biblionumber = i.biblionumber AND DATEDIFF(CURRENT_DATE,b.datecreated) < ? GROUP BY b.biblionumber,b.author,b.title,i.itemcallnumber ORDER BY i.itemcallnumber,b.author COLLATE utf8_unicode_ci"; my $sth = $dbh->prepare($query); $sth->execute($maxdays); my @data; my $message = "Recently catalogued books\n\n"; my $rows_returned = 0; while (@data = $sth->fetchrow_array()) { my $biblionumber = $data[0]; my $author = $data[1]; my $title = $data[2]; my $itemcallnumber = $data[3]; if ($author) { $message .= $author.": "; } $message .= $title."\n"; $message .= $base_url.'/bib/.$biblionumber."\n\n"; $rows_returned++; } if ($rows_returned) { my $response = $fb->add_post ->set_message($message) ->publish; # print $response->as_string()."\n"; # my $msg_id = $response->as_hashref()->{id}; }

1 1

OPAC OpacMainUserBlock error
by midhunlskoha 05 Feb '15

05 Feb '15

<http://koha.1045719.n5.nabble.com/file/n5827264/error1.png> hi all, i tried to edit *OpacMainUserBlock* for adding New arrivals of books with their image. after saving this is wot i got <http://koha.1045719.n5.nabble.com/file/n5827264/error2.png> all the things @ OPAC nav bar and Opac bottom Nav was in a disordered manner, opac nav went downwards. * what could be reason ??* CSS code i used in OPav main user block: -- View this message in context: http://koha.1045719.n5.nabble.com/OPAC-OpacMainUserBlock-error-tp5827264.ht… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Patron Batch Import - Help Request.
by SATISH 05 Feb '15

05 Feb '15

Hi, Koha (3.16) has been installed from packages method on ubuntu 12.4 LTS. Now I am trying to batch import of patron with the help of CSV template given in Koha. I just did copy and paste 1 patron related information to CSV for testing. I do not have any borrowernumber information. For me only, card number is primarily required.All other mandatory fields, such as Branch Code and Category Code has been cross verified and inserted in to CSV. After upload, finally thrown with following errors. - Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). 4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016 - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016 - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016 - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). 4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016 - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). 4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016 Is all the fields in CSV file are mandatory? or partially I can fill whatever is mandated. What is the reason for getting above said error ? I believe, this is repetitive question but, I did not get solution from other answers in forum or video tutorials. Therefore posted a fresh question. Please advice to proceed further for batch import of patrons. Thank You Satish MV Librarian Govt. Eng. College, Hassan. Karnataka.

2 1

catalog search question
by Tim Skeers 05 Feb '15

05 Feb '15

Is there any way to "promote" a particular bib record so that it shows up first in a search results list? My specific example is "code of iowa." Even as a title phrase search, it comes up as no. 45 is a list of 192 results. For the average public user, it might as well not even be in the catalog. I hope that they would ask a librarian, but I'm wondering if there is some way to push it into at least the first 10 results. Thanks, Tim Timothy Skeers | Cataloger | Iowa Library Services/State Library of Iowa | 1112 E. Grand Avenue | Des Moines, Iowa | 50319 | tim.skeers(a)lib.state.ia.us | (515) 725-0605

2 1

Unable to manage lists even as superlibrarian
by Pete Edwards 04 Feb '15

04 Feb '15

I am trying to manage some lists created by another user. I need to be able to delete some of them, rename some and then add/delete items. It seems there is no permission that will allow a superlibrarian access to public lists which seems odd. Is the only solution to directly modify the owner of the lists in the database in order to take control of them? I'm using 3.18.

2 2

Please add us as new Paid Support for Asia - Philippines
by Manuel Tamayao 04 Feb '15

04 Feb '15

Good day Koha Community, Please add us as a new paid support for Philippines Company Name: Tulong Aklatan Contact Person: Manuel Tamayao Contact email: tulongaklatan(a)gmail.com Home: Pinagkaisahan, Makati City, Philippines Website: www.tulongaklatan.ph Short description of your services: We offer training, installation, support, migration, and hosting solutions for Koha. Salamat po, Manny Tamayao

1 0

Re: [Koha] Help! Can't restore database after koha update
by Gwyan Rhabyt 04 Feb '15

04 Feb '15

Just an update. I solved this one. It turned out that the mysql dump wasn't restoring to the database name that I thought it would. Prior to update the koha database was called kohadata. I decided to change the name to avoid confusion with a possible future database. I thought that mysql -uroot -p koha_paclibrary < jan11dump.sql would make sure the restored database was called koha_paclibrary, but I didn't realize that there were multiple instructions in the header of the jan11dump.sql file that also needed to be changed. Once I changed them, it was restored to koha_paclibrary like I wanted. So now the database is restored and we can see patrons and books. There are still some problems, but I hope to fix them by rebuilding the zebra files. Date: Fri, 23 Jan 2015 14:29:05 +1300 From: Chris Cormack <chris(a)bigballofwax.co.nz> To: Gwyan Rhabyt <gwyan.rhabyt(a)csueastbay.edu> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Help! Can't restore database after koha update Message-ID: <CA+95qVSoj_wrVCgJPe6LJ1xrE_J=VywE_oVWQ8tQAFyLjus=Wg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 On 23 January 2015 at 08:02, Gwyan Rhabyt <gwyan.rhabyt(a)csueastbay.edu> wrote: > Our small school district library server needed updating (it was running > Ubuntu 11.10 which was having problems and was no longer supported). So I > upgraded to Ubuntu 14.04LTS and decided to upgrade Koha at the same time > (from 3.06 to 3.18). > The OS upgrade went smoothly. > > For the Koha upgrade, I did a mysqldump of the library database (I also > backed up the complete user folder as a secondary fallback). > I then upgraded Koha which went fine (there were a couple of fiddles on > getting Apache2 happy, but they were documented in this group or on the > wiki). > > The problem has been that I can't seem to properly restore the library > database. > Before the restore,Koha runs but has no books or patrons. When I looked in > the /var/lib/mysql/koha_paclibrary folder (paclibrary is our database), I > saw about 150 files, nearly all .frm files with a size of 12 blocks each. > I followed the instructions at > > http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%2… > and > did the following: > sudo su > mysql -uroot -p > > drop database koha_paclibrary; (response was Query OK, 178 rows > affected) > > create database koha_paclibrary; (response was Query OK, 1 row affected) > > quit; > mysql -uroot -p koha_paclibrary < jan11dump.sql (which took a few minutes, > but returned to the prompt with no errors) > > Now at this point I again looked in the folder > /var/lib/mysql/koha_paclibrary and there is only one file (db.opt) with a > size of 4 blocks. > I thought at first that the dump was wrong or small, but I checked and > jan11dump.sql is 81800 blocks and looks like it has all our info inside. > > I tried running koha at this point on the web interface and it only gave me > the installer, as though koha had not been installed at all. > > Are you sure it wasn't trying to upgrade your DB, when you logged into the web installer, what did it say next? And what message are you getting at the OPAC, the library is in maintenance mode? Also, if you do mysql -uroot -p koha_paclibrary You will be in mysql what does show tables; show you? Try select * from items limit 10; Do you get results? Chris ________________________________________________ Gwyan Rhabyt Director, Multimedia Graduate Program Professor, Art Department California State University East Bay and President of the Board of Trustees, Pacific Elementary School District

1 0

Re: [Koha] Fwd: Facets missing on fresh dev install of 3.18.3
by Paul A 03 Feb '15

03 Feb '15

At 01:25 PM 2/3/2015 -0500, Cindy Murdock Ames wrote: >Yep, with use_zebra_facets=0 I can see author facets: >http://imgur.com/lj7v0Uw > >And thanks Katrin, I'm sorry you're having the same problem but it makes me >feel a bit better knowing that it's not just me! For what it's worth, here's my notes on "facet results." Note that I stop/start memcached for every change in sysprefs and koha-conf-xml (I get completely inconsistent results without that) and Zebra. Note also that I'm starting Zebra (v. 2.0.44) with ZEBRAOPTIONS="-T -v none,fatal,warn" I also have two ZOOM.pm files at /usr/lib/perl5/ZOOM.pm (1110 lines) and /usr/lib/perl5/Net/Z3950/ZOOM.pm (194 lines) -- could you pls confirm that this is normal? Facets [Koha 3.18.3 tarball] ====== 1. Behaviour (OPAC) -- using catalogue search term "lubbock" giving 30 results a) <use_zebra_facets>0</use_zebra_facets> - sysprefs: show, holding library, 20,20,20, ', ' ==> Availability, Authors, Item types, Locations, Series, Places, Topics, Show more "Show more" is functional, but appears (from timing) to repeat the complete search - sysprefs: show, holding library, 20,100,100, ', ' use search 'navy' (3998 results) ==> Availability, Authors, Item types, Locations, Series, Places, Topics, Show more "Show more" is fully functional (gives 100 Authors), but definitely (from timing) repeats the complete search - sysprefs: don't show, holding library, 0,0,0, ' ' ==> NO FACETS whatsoever (blank column) b) <use_zebra_facets>1</use_zebra_facets> - sysprefs: show, holding library, 20,20,20, ', ' ==> Availability, Authors, Item types, Locations, Series, Places, Topics, Show more "Show more" is functional, but appears (from timing) to repeat the complete search [c.f. 3.08 ==> Availability, Authors, Places, Topics, 5 results each] - sysprefs: show, holding library, 20,5,50, ', ' [simulate 3.08?] ==> Availability, Authors, Item types, Locations, Series, Places, Topics "Show more" does *not* appear -- FacetMaxCount must be >5 - sysprefs: don't show, holding library, 0,0,0, ' ' ==> Availability, Authors, Item types, Locations, Series, Places, Topics, No "Show more" and single result, but result appears relevant --- 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