/hea-app

Primary LanguagePerlGNU General Public License v2.0GPL-2.0

hea-app

This website intends to display koha community usage statistics. Data are collected from installed koha if librarian wants anonymously or not.

External references

Install Hea locally

  • git clone https://github.com/biblibre/hea-app.git

  • git clone https://github.com/biblibre/hea-ws.git

  • Create a database whith the schema in hea-ws/sql/schema.sql

  • Optional : Import mock data (hea-app/sql/mock-data.sql)

  • copy hea-app/environments/config.yml to hea-app/environments/production.yml

  • In this production.yml file, replace all REPLACE_ME with the name of the database created above and a user/password

If it's not working, don't forget to see in hea-app/logs/production.log which Libraries are missing, and install them.

Install perl libraries

  • Libraries used: Dancer, Dancer::Plugin::Database, Template, Template::Plugin::Number::Format
  # one installation way
  root # curl -L http://cpanmin.us | perl - --sudo <lib_name>

Launch the app

hea-app$ ./bin/app.pl 

Database and sample data

  1. Some mocks data are available in sql/mock-data.sql
  2. Schema is in sql/schema.sql

Available data for rendering

  • Metrics available in volumetry table
+---------------+
| name          |
+---------------+
| biblio        |
| borrowers     |
| old_issues    |
| aqorders      |
| subscription  |
| auth_header   |
| old_reserves  |
| old_reserves  |
+---------------+
  • System preferences recorded: a lot, see the Koha code (or patches on the bug tracker)
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| library_id | varchar(32)  | NO   |     | NULL    |       |
| name       | varchar(255) | NO   |     | NULL    |       |
| value      | text         | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
  • Library table
+--------------------------+----------------------------+--------------------+--------------+---------+
| library_id               | name                       | url                | library_type | country |
+--------------------------+----------------------------+--------------------+--------------+---------+
| 'RcP73COKh93YWLmOLkLx5Q' | hea experimental library   | http://example.com | UNIVERSITY   | France  |
+--------------------------+----------------------------+--------------------+--------------+---------+