Online Library of Knowledge

1. Online Library of Knowledge Juro4C

2. Available Modules Common Tasks in forms Import Consolidation Usage reports Outline

3. Available modules

4. Available modules

6. Import usage statistics • 3 types of data import • Manual • Batch • Sushi • Support for counter and non counter publishers • Manual adjust in some providers

7. Manual Import • Files are located in local computer and upload to server • 2 Log files (global and file specific) • Backup file without changes for preservation

8. Batch Import • Files are located in the server • File specific name : institution_id.csv (ex: 500.csv) • 2 Log files (global and file specific) • Backup file without changes for preservation

9. Sushi Import (1/2) • Publishers don’t have yet this feature. • Mandatory to define : • Provider (url) • Institution (username, password, sushi ID) • Can be run as : • batch mode • Cron job • Keeps a state of the last result (OK, Not OK) • Only imports data from the last successful run • 2 log files

10. Sushi Import (2/2) B-on has already made some tests with Elsevier cd /juro4c/runBatch . /batchSushi.sh

11. Consolidation (1/2) • Process of passing imported data into the data warehouse • The data warehouse contains 2 fact and 6 dimensions tables • Time consuming process

12. Consolidation (2/2) • Logs are written to main file • Desirable to Clean temporary tables after process • In case of browser timeout, the process continues to run in the server

13. Usage Reports Available reports

14. E-journal Full Text access JR1 • Presents matrix with Provider x Month • User see his institution

15. Average Usage • Number Downloads / nr Titles • Group by year and provider

16. Total usage by platform • Grouped by Provider, Year

17. Top 10/50/100 Journals • Grouping is done by ISSN

18. Number of titles per platform • Grouped by platform and title

19. Low usage report • Journals with less than 5 downloads • Presents the first 100 Journals • Grouped by platform and provider

20. Zero Usage report • Presents the first 100 journals with zero downloads in a period • Grouped by platform and publisher

21. Average usage per title • Number of downloads / Nr titles • Grouped by Provider

22. Average Use per FTE • Nr Downloads / Nr FTE • Grouped by year

23. Batch overlap matrix (1/2) • Run in batch mode • Overlap is made with the ISSN • Produces 1 html file with: • Matrix with the titles common between providers • List of titles that are overlap • Recommendations • Overlap between Provider and Aggregator should not as much importance • The overlap does not check if the title has changed publisher in a time period

24. Batch overlap matrix (2/2)

25. Thank you!