Posts

Koha Customized SQL Reports

-
Koha Customized SQL Reports Note: Some SQL queries customized in Koha's backend ensure the Koha supports or not.  Issue SELECT        staff.cardnumber AS 'Staff Card Number',     CONCAT(staff.firstname, ' ', staff.surname) AS 'Staff Name',     a.action AS 'Action',     a.timestamp AS 'Time',     c.barcode AS 'Acc. Number',     d.title AS 'Title',     CONCAT(k.firstname, ' ', k.surname) AS 'User Name',     k.cardnumber AS 'User ID',     ExtractValue(T5.more_subfields_xml, '//datafield[@tag="999"]/subfield[@code="A"]') AS 'Floor',     issues.date_due AS 'Due Date' FROM     action_logs a LEFT JOIN     borrowers staff ON a.user = staff.borrowernumber LEFT JOIN     items c ON a.info = c.itemnumber LEFT JOIN     biblio d ON c.biblionumber = d.biblionumber LEFT JOIN     borrowers k ON a.object = k.borrowernumber LEFT JOIN   ...
Post a Comment
Read more

Dspace Statistics Report Generate

-
 Dspace Statistics Report Generate Change the directory cd {dspace-DIR} /bin/ Ex. cd /dspace/bin Run the below commands one by one  ./dspace index-discovery -b ./dspace stat-initial ./dspace stat-report-initial ./dspace stat-general ./dspace stat-monthly ./dspace stat-report-monthly ./dspace stat-report-general Then log in to your dspace ( http://localhost:8080 ) go to statistics to view the all report.
Post a Comment
Read more

Basic HTML

-
Image
Important Dates Last date for Registration : 30 June 2024 Last date for Submission of Full Papers : 15 June 2024 Intimation of Acceptance : 30 June 2024 --------------- Publication Papers presented in the conference will be published in the Conference Proceedings with e-ISBN. ------------ Article Template Participation Only Registration for Presenters --------------------- Home About College Department Conference Call for Papers Submmission of Papers Article Template Paper Submission Registration Registration Fee Account Details Registration Form Committee Contact ------------- 1 / 3 2 / 3 3 / 3 ❮ ❯ ...
Post a Comment
Read more

Dspace 7.6 Installation Latest Version

-
Image
  Dspace 7.6 Installation We use Debian 11 (Bull Eye) Ubuntu 20.04 LTS and 22.04 LTS to install DSpace 7. Update the operating system. Apply the following commands one by one to receive new updates. It makes the system new. sudo apt update && sudo apt upgrade -y Create a DSpace user from the terminal after the installation. Here are the commands to create the  DSpace user; sudo useradd -m dspace sudo passwd dspace [enter a password for the new user dspace] Add dspace user to sudoers group sudo usermod -aG sudo dspace  Create the directory for the DSpace installation. sudo mkdir /dspace Change the dspace folder permission to the dspace user. sudo chown dspace /dspace Build the Installation Package Install packages to support the Dspace installation. sudo apt install wget curl git build-essential mousepad zip unzip -y Install Open JDK The JDK is a development environment for building applications, applets, and components using the Java programming language. JDK prep...
Post a Comment
Read more

Total views