Category: ILS

Add vufind search form and koha search form in your Web site

Add these code to add vufind search form in your web site
<h2 style=”color: blue;”> Search here for Online Journals2px”>Search
</label>
10em;width:10em;”>
<option value=”AllFields”>All Fields</option>
<option value=”Title”>Title</option>
<option value=”Author”>Author</option>
<option value=”Subject”>Subject</option>
<option value=”CallNumber”>Call Number</option>
<option value=”ISN”>ISBN/ISSN</option>
<option value=”tag”>Tag</option>
</select>
<input id=”lookfr” name=”lookfor” type=”text” class=”left” style=”width: 25%; font-size: 111%;”/>
<select class=”left” id=”Format_front” name=”Format_front[]” value=””>
<option selected=”selected” value=””>Limit To</option>
<option value=”2″>Book</option>
<option value=”3″>eBook</option>
<option value=”4″>Digital Repository</option>
<option value=”5″>Electronic</option>
<option value=”6″>Journal/Periodical</option>
<!–  <option value=”7″>Microfilm</option>
<option value=”8″>Slide</option>
<option value=”9″>Software</option>
<option value=”10″>Unknown</option> –>
</select>
<select style=”display:none;position:absolute” class=”left” id=”Format” multiple=”multiple” name=”filter[]” value=””>
<option value=”format:”Book””>Book</option>
<option value=”format:”eBook””>eBook</option>
<option value=”format:”Digital Repository””>Digital Repository</option>
<option value=”format:”Electronic””>Electronic</option>
<option value=”format:”Journal/Periodical””>Journal/Periodical</option>
<!–  <option value=”format:”Microfilm””>Microfilm</option>
<option value=”format:”Slide””>Slide</option>
<option value=”format:”Software””>Software</option> –>
<!–  <option value=”format:”Unknown””>Unknown</option> –>
</select>
<input type=”submit” value=”Go” id=”searchsubmit” class=”left” />
20px;text-decoration:none;margin-top:2px” href=”http://localhost/vufind/Search/Advanced”>Advanced Search
</form>
<br />

50px;margin-bottom:8px;margin-top:4px;color:#000000;”>

<h6><span id=”Filter”>
</span></h6>
</div>
<br />
<br />

 

Add the following code to add koha search form in your web site

<form name="searchform" method="get" action="http://localhost/cgi-bin/koha/opac-search.pl" id="searchform">
<input id="transl1" name="q" type="text"><p>
<select name="idx" id="masthead_search">
<option value="">Keyword</option>
<option value="ti">Title</option>
<option value="au">Author</option>
<option value="su">Subject</option>
<option value="nb">ISBN</option>
<option value="se">Series</option>
<option value="callnum">Call Number</option>
</select>
<input value="Search" id="searchsubmit" type="submit">
</p></form>

OCLC services for Library

Classify

Classify books, videos, CDs and other materials based on identifier: ISBN or OCLC Number

Using the API

The Classify Web Service is an experimental web service from the OCLC Office of Research. The web services enables users to submit an identifier such as an ISBN, ISSN, OCLC Number, LCCN, or UPC and retrieve information about the classification of that work in Dewey and Library of Congress Classifications. The service also retrieves FAST headings. In addition to the web service, a web interface to Classify is also available.

Terminology Services

Machine-readable access to a suite of seven controlled vocabularies and thesauri
STATUS: Experimental

OpenURL Gateway

An OpenURL-resolving Web service that redirects Web-based applications to provide their end-users direct access to full-text articles and other online resources available from libraries. The OpenURL Gateway pulls OpenURL data from the WorldCat Registry—a global directory for libraries, consortia, archives and museums. (www.worldcat.org/registry/institutions/)
STATUS: Production
http://oclc.org/developer/services/openurlgateway

xISBN (Web service)

Use this Web service to map book-related identifiers (ISBN, LCCN, OCLC number), based on WorldCat information. Free and subscription versions are available.

xISBN Web service

The xISBN Web service supplies ISBNs and other information associated with an individual intellectual work that is represented in WorldCat. Submit an ISBN to this service, and it returns a list of related ISBNs and selected metadata. The service is based on WorldCat, the world’s largest network of library content and services. Current xISBN database covers 23,227,419 ISBNs.
We also support other books-related identifiers mapping, such as xOCLCNUM as part of xISBN service. 

http://xisbn.worldcat.org/xisbnadmin/index.htm

koha web customization

There are some ways for changing web interface of koha. For Adding top or header navigation in koha opac we can do in the following:

first add in koha system preference >opacheader

<div id=”navcontainer” class="clearfix">
<ul id=”navlist”>
<li id=”active”><a href=”#” id=”current”></a>Institutional Repository</li>
<li><a href=”#”>Library Home</a></li>
<li><a href=”#”>About Library</a></li>
<li><a href=”#”>Library Staff</a></li>
<li><a href=”#”>Library Services</a></li>
</ul>
</div> 

Then add in system preference>OPACUserCSS 

#navcontainer ul {
padding-left: 0;
margin-left: 0;
background-color: #036;
color: White;
float: left;
width: 100%;
font-family: arial, helvetica, sans-serif;
}

#navcontainer ul li { display: inline; }

#navcontainer ul li a {
padding: 0.2em 1em;
background-color: #036;
color: White;
text-decoration: none;
float: left;
border-right: 1px solid #fff;
}
#navcontainer ul li a:hover {
background-color: #369;
color: #fff;
}

http://www.myacpl.org/koha/?p=30
http://css.maxdesign.com.au/listamatic/
http://css.maxdesign.com.au/listamatic/horizontal03.htm
http://dosimple.ch/articles/Menus-dynamiques/
http://dosimple.ch/articles/Menus-dynamiques/menuHorizontal.html
http://openweb.eu.org/xhtml

koha report

 How to restore deleted marc record/items

You’ll need to know the biblionumbers you want to restore. And then you
need to move them out of the deleted tables and in to the original tables.
So if you want to restore biblionumber 100 you’d do something like this:insert into biblio (select * from deletedbiblio where biblionumber=100);
delete from deletedbiblio where biblionumber=100;
insert in to items (select * from deleteditems where biblionumber=100);
delete from deleteditems where biblionumber=100;
insert in to biblioitems (select * from deletedbiblioitems where
biblionumber=100);
delete from deletedbiblioitems where biblionumber=100;Of course you want to back up your database before doing anything like
that, but right now there is no way to restore records in the GUI, so you
have to do it in the DB.


Circulation report limited with date
If you’re putting it to the Koha reports tool you can use this:> SELECT issues.issuedate,items.barcode,biblio.title,
SQL statement for generating current checkouts


You can use this query if you want to see the title:SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumber,
borrowers.categorycode FROM issues LEFT JOIN borrowers ON
borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON
issues.itemnumber = items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber WHERE issues.issuedate = ‘yyyy-mm-dd’

If you don’t need the title, use this query:

SELECT issues.issuedate, items.barcode, borrowers.firstname,
borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues
LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT
JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate =
‘yyyy-mm-dd’


cheekOut report:
We recently went live and I’m now trying to run the monthly statistics
reports I’ve set up.  One of the reports is to total the number of
checkouts and renewals for the month listed by library and the other is
the same total number of checkouts and renewals but listed by the
borrower category code.  These two reports should equal but don’t.  When
I was trying to figure out what is going wrong, I found the following
two reports don’t give the same results but as near as I can tell, they
should.  Can anyone please, please tell me why I’m seeing different
results and which numbers are correct?  We’re on PTFS Koha.Thanks!

Report 1 totals for the first three libraries:
LIB1    4497
LIB2    10130
LIB3    1710

SQL for Report 1:
SELECT borrowers.branchcode AS ‘Library’, COUNT(statistics.itemnumber)
AS ‘Total CKO’
FROM statistics
JOIN borrowers ON (borrowers.borrowernumber = statistics.borrowernumber)
WHERE (statistics.datetime) >= ‘2011-04-15’ AND
DATE(statistics.datetime) <= ‘2011-04-30’
AND statistics.type IN (‘issue’,’renew’)
GROUP BY borrowers.branchcode

Report 2 totals for the first three libraries:
LIB1    4161
LIB2    9746
LIB3    1647

SQL for Report 2:
SELECT statistics.branch AS Library, COUNT(statistics.itemnumber) AS
‘Total CKO’
FROM statistics
WHERE DATE(statistics.datetime) >= ‘2011-04-15’ AND
DATE(statistics.datetime) <= ‘2011-04-30’
AND statistics.type IN (‘issue’,’renew’)
GROUP BY statistics.branch


How to include 952$x in a report
SELECT
ExtractValue(more_subfields_xml,
‘/collection/record/datafield[\@tag=\”999\”]/subfield[\@code=\”x\”]’), items.barcode, items.biblionumber,items.barcode,items.dateaccessioned
FROM items
LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)

ORDER BY items.biblionumber asc


Started with deleting the:

    WHERE biblionumber=14),

per mysql manual “The statement selects all rows if there is no WHERE
clause”, but still get error “can’t use undefined value as an ARRAY
reference” at guided_reports.pl line 618. After multiple trial/error
changes to punctuation, etc, here’s what I have, still non-functional:

SELECT items.biblionumber,items.barcode,items.dateaccessioned
FROM items;

SELECT ExtractValue(marcxml,’//datafield[@tag=”952″]/subfield[@code>=”x”]’)
AS ITEM
FROM biblioitems

LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)

ORDER BY items.biblionumber asc

Removing the “SELECT ExtractValue …” and preceding semi-colon works fine,
I’m just totally flummoxed on getting the 952$x part to function.  Is
another LEFT JOIN required?

koha tools

Koha-Tools is a related but separate project with many helpful tools to be used with Koha.
http://millruntech.com/koha
http://kylehall.info/

Libki is a Computer Kiosk Management system. Libki is used to allow time limited access to computers on a network.
Libki is ideally suited for use in locations where a controlled computing environment is paramount such as public access systems, libraries, school computer laboratories and more!
It consists of two parts, the Libki Server, and the Libki Client.

It has integration with koha

http://wiki.libki.org/doku.php
http://libki.org

Installation Koha-3.2.2 on (Fresh) Debian Squeeze

Step-1: log in as root user or go root
sudo su
In squeeze no need to add index data repository.
Dabian packages for koha
This is an APT package repository for Debian packages of Koha, and those of its dependencies that are missing from Debian. The Debian squeeze release is supported; older versions of Debian are not supported.
Add the line in /etc/apt/sources.list
deb http://debian.koha-community.org/koha squeeze main

Add the key in gpg.asc to your APT trusted keys: 
wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -
apt-get update

Step-2:
(now you can install koha by using:
apt-get install koha
less /usr/share/doc/koha/README.Debian
 
 These procedure is not the best) 

OR you can install koha's dependencies by using 
apt-get install koha 
then delete koha folder from different locations and skip step-2)
Install apache2 and related package:
apt-get install apache2 apache2-doc apache2-src daemon
apt-get install libapache2-mod-perl2 libapache2-mod-perl2-dev libapache2-mod-python
Install mysql server and other related package:
apt-get install mysql-server mysql-admin libmysqlclient16 libmysqlclient16-dev
Install yaz packages
apt-get install yaz yaz-doc libyaz3 libyaz3-dev
Install zebra packages
apt-get install idzebra-2.0 idzebra-2.0-common idzebra-2.0-doc idzebra-2.0-utils libidzebra-2.0-0 libidzebra-2.0-dev libidzebra-2.0-mod-alvis libidzebra-2.0-mod-grs-marc libidzebra-2.0-mod-grs-regx libidzebra-2.0-mod-grs-xml libidzebra-2.0-mod-text libidzebra-2.0-modules
Install perl packages and some others:
apt-get install libopenal1 liblingua-stem-snowball-perl libdatetime-format-mail-perl
libnet-daemon-perl libmime-types-perl libnet-ldap-perl libgraphicsmagick3 libxml-sax-perl
libmarc-record-perl libunistring0 liblingua-pt-stemmer-perl libcache-memcached-perl libnumber-format-perl libdublincore-record-perl libxml-sax-expat-perl libdata-ical-perl libdate-leapyear-perl libxml-dumper-perl libsms-send-perl esound-clients libpdf-reuse-perl libauthen-cas-client-perl libgd-gd2-noxpm-perl libyaml-syck-perl libsub-name-perl
liblingua-stem-perl libglew1.5 libsnowball-swedish-perl libtext-vfile-asdata-perl
libclass-factory-util-perl libdbi-perl libstring-crc32-perl libdevel-stacktrace-perl libjson-xs-perl libtext-csv-encoded-perl libdate-manip-perl libclass-accessor-chained-perl libemail-abstract-perl dbconfig-common libjson-perl libxml-namespacesupport-perl
libhtml-template-perl libxml-libxml-perl libmemoize-memcached-perl
libxml-filter-buffertext-perl autopoint libfont-ttf-perl libdatetime-timezone-perl
libdatetime-format-w3cdtf-perl libtext-pdf-perl libdevkit-power-gobject1
libalut0 libnet-cidr-perl gettext libpoe-perl libhttp-oai-perl tinymce2 libhtml-scrubber-perl libxml-simple-perl libemail-date-perl libparams-util-perl libxml-rss-perl
libparams-validate-perl git libtext-csv-perl libglc0 libconvert-asn1-perl
libmarc-crosswalk-dublincore-perl libclass-returnvalue-perl libnet-server-perl
libschedule-at-perl libclass-adapter-perl rsync libdbd-mysql-perl libmarc-charset-perl libdatetime-perl liblocale-po-perl libdate-calc-perl libgraphics-magick-perl
ghostscript-x liberror-perl libdatetime-locale-perl libjs-yui libfilter-perl libcarp-clan-perl
tix libuniversal-require-perl libemail-date-format-perl libplrpc-perl libhtml-template-pro-perl libalgorithm-checkdigits-perl wwwconfig-common libtext-csv-xs-perl libxml-libxslt-perl tk8.4
libpdf-reuse-barcode-perl libbusiness-isbn-perl libdate-ical-perl libbarcode-code128-perl
rss-glx liblingua-stem-snowball-da-perl libpdf-api2-perl libdbd-sqlite2-perl libio-multiplex-perl libbiblio-endnotestyle-perl libmarc-xml-perl liblist-moreutils-perl libclass-accessor-perl libcommon-sense-perl libbusiness-isbn-data-perl libtext-german-perl libmail-sendmail-perl libjs-jquery libcgi-session-perl libglewmx1.5 libpdf-api2-simple-perl libxml-sax-writer-perl liblocale-currency-format-perl libcgi-session-serialize-yaml-perl libmime-lite-perl
libsys-hostname-long-perl libemail-simple-perllibclass-singleton-perl javascript-common libsnowball-norwegian-perl libpdf-table-perl libgd-barcode-perl libbit-vector-perl
libnet-z3950-zoom-perl libyaml-perl
Step-3: Add koha user:

Get Koha

 

adduser koha
Extract koha:
Create koha environment:
gedit /etc/profile
and add the following lines
export PERL5LIB=/usr/share/koha/lib
export KOHA_CONF=/etc/koha/koha-conf.xml

Add Listen post in /etc/apache2/ports.conf
gedit /etc/apache2/ports.conf

Listen 8080

Create Koha database and assign require privileges:

mysql -u root -p 
create database koha;
grant all privileges on koha.* to 'root'@'localhost' identified by 'your_root_password';

Step-4:Install koha by using the following command
perl Makefile.PL

After running the above command you have to answer some questions.

You can choose the following options:
Installation mode (dev, single, standard) [standard] = standard 
Base installation directory [/usr/share/koha] = /usr/share/koha 
User account [koha] = koha 
Group [koha] = koha 
DBMS to use (Pg, mysql) [mysql] = mysql 
Database server [localhost] = localhost 
Please specify the port used to connect to the DMBS [3306] = 3306 
Please specify the name of the database to be used by Koha [koha] = koha
Please specify the user that owns the database to be used by Koha [kohaadmin] root
NOTE:This user (kohaadmin) and password are both the MySQL login/pwd and the web 
admin interface login/pwd. 
Please specify the password of the user that owns the database to be used by Koha 
[your_mysql_root_password] 
Install the Zebra configuration files? (no, yes) [yes] = yes 
MARC format for Zebra indexing (marc21, unimarc) [marc21] = marc21 
Primary language for Zebra indexing (en, fr) [en] 
Authorities indexing mode (dom, grs1) [grs1] = grs 
Please specify Zebra database user [kohauser] = root
Please specify the Zebra database password [zebrastripes] = zebrastripes [you can select 
your own password here] 
Install the SRU configuration files? (no, yes) [yes] = yes 
SRU Database host? [localhost] = localhost 
SRU port for bibliographic data? [9998] = 9998 
SRU port for authority data? [9999] = 9999 
Install the PazPar2 configuration files? [no] = no 
Would you like to run the database-dependent test suite? (no, yes) [no] = no 

Compile koha by running the commands:

make 
make test
make install 

Create symbolic link of koha with apache 
ln -s /etc/koha/koha-httpd.conf /etc/apache2/sites-available/koha 

a2enmod rewrite 
a2ensite koha

To enable new configuration reload apache
/etc/init.d/apache2 reload

Configure zebra
ln -s /usr/share/koha/bin/koha-zebra-ctl.sh /etc/init.d/koha-zebra- daemon 
update-rc.d koha-zebra-daemon defaults
ln -s /usr/share/koha/bin/koha-zebraqueue-ctl.sh /etc/init.d/koha- zebraqueue-daemon 
update-rc.d koha-zebraqueue-daemon defaults 


Add the following lines here, 
#Environment 
PERL5LIB=/usr/share/koha/lib 
KOHA_CONF=/etc/koha/koha-conf.xml 
#Some additional variables 
KOHA_CRON_PATH=/usr/share/koha/bin/cronjobs

Then run web koha installer by pointing the address in browser

http://localhost:8080

And update database: 

Quick index and rebuild zebra index to enable searching:
export PERL5LIB=/usr/share/koha/lib
cd /usr/share/koha/bin/migration_tools
./rebuil_zebra.PL -b -w
./rebuild_zebra.PL -b -a -z