Koha CoverFlow (New Arrivals)

-

 Koha CoverFlow (New Arrivals)


Create a SQL public Report

Create a report and please note down the report id (here is SQL statement for New Arrivals)

Reports › Create from SQL

Copy and paste the following line

SELECT b.biblionumber, i.Barcode, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title 

 FROM items i

  LEFT JOIN biblioitems m USING (biblioitemnumber)

  LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)

  WHERE DATE_SUB(CURDATE(),INTERVAL 15 DAY) <= i.dateaccessioned AND m.isbn IS NOT NULL AND m.isbn != ''

  GROUP BY biblionumber

  HAVING isbn != ""

  LIMIT 30


Plugin: https://github.com/bywatersolutions/koha-plugin-coverflow

Download: https://github.com/bywatersolutions/koha-plugin-coverflow/releases

Enable koha plugin in terminal if not enabled

Terminal

sudo su

sudo leafpad /etc/koha/sites/library/koha-conf.xml


(find)    <pluginsdir>/var/lib/koha/library/plugins</pluginsdir>

<enable>_plugins>0</enable_plugins> (Change 0 to 1) like this below

<enable>_plugins>1</enable_plugins>

save it

Restart Apache,

/etc/init.d/apache2 restart

Then Global System Preferences

UseKohaPlugins (Enable)


go to Tools > Tools Plugins 

Upload Plugin

Go to Administration > Manage plugins > Upload a plugin > Choose > koha-coverflow-plugin-v2.4.0.kpz and upload

Once the Koha coverflow plugin was install click on Configure

In the Image options Section

     Limit image size (height in pixels) 250

     Limit title length (width in pixels) 150

In the mapping Section following line copy and paste

---

- id: 27

  selector: "#coverflow"

  options: 

  style: coverflow

- id: 27

  selector: ".coverflow_class"

  options:

  buttons: true

  autoplay: 3000

  style: wheel


NOTE: Where id: 20 is the report id please write your SQL report id


Web Server Configuration

Open Applications > System Tools > Terminal

Apply the following command

sudo su (Enter the mysql password)

sudo leafpad /etc/apache2/sites-enabled/library.conf


Add the following line at the bottom of the file. replace the library with your koha instance name


ScriptAlias /coverflow.pl "/var/lib/koha/library/plugins/Koha/Plugin/Com/ByWaterSolutions/CoverFlow/coverflow.pl"

Alias /plugin/ "/var/lib/koha/library/plugins/"

# The stanza below is needed for Apache 2.4+

<Directory /var/lib/koha/library/plugins/>

      Options Indexes FollowSymLinks

      AllowOverride None

      Require all granted

</Directory>


Restart memcached: 

sudo service memcached restart


Restart your webserver: 

sudo service apache2 restart


OPAC Config

Now go to Administrator > global system preferences > OpacMainUserBlock

Put the following line in the system preference OpacMainUserBlock:


<b><h2><center><u><font color="purple">New Arrivals</font></h2></b></u>

<span id="coverflow">Loading...</span></center>


Other one method for New Arrivals 

sudo gedit /etc/koha/sites/library/koha-conf.xml


1. In the xml file Change <enable_plugins>0<enable_plugins> to

                                     <enable_plugins>1</enable_plugins>


2.Download the Carousel Plugin kpz file.

3.Go to: Koha Home › Tools › Plugins › Upload Plugin (Carrousel.kpz)

4. Go to: Koha Home › Lists › New Lists › Create 'New Arrivals' Public list

    Add the New Arrivals items Barcodes: For example barcode 22300, 22301, 22302

5.Go to: Plugin Carrousel Click Actions 'Configure' (Select New Arrivals and change Bg color Etc..)

6.Go to: Plugin Carrousel Click Actions 'Run tool'

7. Generate carrousel ( Select New Arrivals ) and Click Generate

Comments

Post a Comment

Popular posts from this blog

Install Dspace 7.2 on Ubuntu 22.04 LTS

-
Image
  Install Dspace 7.2 on Ubuntu 22.04 LTS Install Dspace 7.2 on Ubuntu 22.04 LTS Prerequisite software : i) Java JDK ii) Apache Maven iii) Apache Ant iv) Apache Tomcat v) PostgreSQL vi) Solr vii) Dspace 7.2 – backend viii) Dspace-angular 7.2 – frontend ix) Node.js x) Node Version Manager (NVM) xi) Yarn xii) gedit (text editor software) Note: It is highly recommended to install Dspace7 on fresh installed Linux-based operating system. It may not be compatible with the Virtual box platform. (Note the red mark lines are the commands that need to be executed on the terminal) Open the terminal by pressing (Ctrl+Alt+T) or go to Applications > Accessories > Terminal and select it for executing the below command. First update and upgrade your package system sudo apt update && sudo apt upgrade -y Install gedit for text editing sudo apt-get install gedit Create a Dspace user with password sudo useradd -m dspace sudo passwd d...
Read more

How to delete library data in koha using the command line

-
 How to delete library data in koha using the command line Sometimes you need to empty the all data (e.g. bibliographic, borrowers, and transaction details)  from your Koha LMS without losing the configuration settings and authorized values, e.g. libraries, item types, patron categories, locations, etc. Let us know how to delete data from the Koha instance/library. Delete Koha's bibliographic data NB: I would recommend taking a backup of the database before applying the following commands. Login as a root user sudo su Log into MySQL database mysql -uroot -p Enter MySQL root password use koha_library; Disable foreign key constraints when you truncate the tables SET FOREIGN_KEY_CHECKS=0; Delete all bibliographic details TRUNCATE items;  TRUNCATE biblioitems;  TRUNCATE biblio;  TRUNCATE deletedbiblioitems; TRUNCATE deletedbiblio;  TRUNCATE biblio_metadata; Delete all transactions  TRUNCATE old_issues;  TRUNCATE issues;  Delete borrowers details ...
Read more

Koha INSTALLATION

-
Image
   Koha INSTALLATION After installation of ubuntu 20.4 (Focal Fossa), right click on the mouse choose open terminal. past the following comments in terminal. Update Ubuntu using apt   sudo apt update sudo apt upgrade -y if the system asks for update make it "Remind me later" it may confuse the process Clear the apt-get packager manager cache sudo apt clean Install MariaDB-server dependence sudo apt install -y mariadb-server Provide MySQL/MariaDB root password (If the password asks during the installation process, enter the password in the window. Apply the following command, if the password window did not appear during the installation secure it) Securing MariaDB Run this command to improve the security of the MariaDB installation:   sudo mysql_secure_installation   (The script will prompt you to set up the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test d...
Read more

Total views