hea-app

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

Data collected is available under the CC-BY-SA 4.0 License

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

Some mocks data are available in sql/mock-data.sql
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  |
+--------------------------+----------------------------+--------------------+--------------+---------+