koha web customization

Leave a comment

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

Leave a comment

 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?

Syn Item and biblio table

Leave a comment

As you’ve seen, items info are stored in two locations: ‘items’ table
and with the biblio records. If you load data the way you’ve done it,
you have to ‘copy’ data from items table to biblio records. There is
script that can do it automatically for you:

    misc/maintenance/sync_items_in_marc_bib.pl

The other option is to create directly items records during biblios
import. You have to put your item info into 952 tag for MARC21 records
(995 for UNIMARC).

koha self circulation

Leave a comment

Multiple koha on one server

Leave a comment

we can get our require information on the following site

http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha

kete

Leave a comment

Kete is a collaboration engine. It is open source software that you can use to create and share online. Write topics and upload images, audio, video, documents.


http://kete.net.nz/

Speed up mysql and postgresql database

Leave a comment

Older Entries

%d bloggers like this: