Gestion des ressources électroniques

Le module de gestion des ressources électroniques (ERM) permet de suivre la sélection, l’acquisition, les licences, l’accès, la maintenance, l’utilisation, l’évaluation, la conservation et la désélection des ressources électroniques d’une bibliothèque. Ces ressources peuvent être des revues électroniques, des livres électroniques, des médias en streaming, des bases de données, des jeux de données et des logiciels.

Pour utiliser le module de gestion des ressources électroniques (ERM), vous devez activer la préférence système ERMModule.

Note

Seuls les professionnels ayant la permission Gestion du module ERM) auront accès à ce module.

Page d’accueil de la Gestion des ressources électroniques

Aller à : Plus > Gestion des ressources électroniques

E-Resource management module homepage

Contrats

Dans la terminologie de la gestion des ressources électroniques, les Contrats décrivent à quels abonnements vous avez accès tandis que les Licences précisent ce que vous pouvez faire avec ces ressources.

Note

Avant de commencer la création de nouveaux Contrats, assurez-vous que les bibliothécaires disposent bien des permissions et que vous avez configuré la valeur autorisée ERM selon vos besoins. Assurez-vous aussi d’avoir positionné la préférence système ERM.

Créer une notice de Contrat

A partir de la page d’accueil de la Gestion des ressources électroniques, cliquez sur le lien Contrat dans le menu à gauche.

Aller à : Plus > Gestion des ressources électroniques > Contrats

Utilisez le bouton + Nouveau Contrat au dessus du tableau des Contrats.

In the E-Resource management module Agreements section, the focus is on the 'New agreement' button.

Vous devez donner un nom, une description et un statut au Contrat. Le statut définit si le contrat est actif ou non. Tous les autres champs sont facultatifs.

Le contrat peut être rattaché (c’est facultatif) à un :ref:`fournisseur <vendors-label>`existant du module Acquisitions. Ceci vous permet de conserver une trace du fournisseur et de lui attacher des commandes.

Le champ Raison de fermeture restera grisé jusqu’à ce que vous donniez le statut « Fermé » au contrat; ce champ deviendra alors actif.

Le champ Licence peut être utilisée ici si vous ne souhaitez pas utiliser la rubrique Licence du module Gestion des ressources électroniques mais désirez tout de joindre au contrat des informations concernant la licence.

New agreement form

  • Périodes

    • Plusieurs périodes peuvent être rattachées à un Contrat.

    • La période décrit la durée du lien que vous entretenez avec le fournisseur. A chaque renouvellement de contrat, vous pouvez saisir une nouvelle période afin de tenir le compte du nombre de renouvellements passés. Vous pouvez aussi créer des périodes de contrat pour des dates à venir. Ainsi, par exemple, vous pouvez avoir une période en cours, des périodes révolues et une période à venir.

    • La date limite d’annulation peut servir à vous alerter de dates de fin à venir et donc, vous inciter à lancer le renouvellement avec le fournisseur.

Form for a new agreement period.

  • Utilisateurs

    • Dans ce contexte, un utilisateur est un membre du personnel impliqué d’une manière ou d’une autre dans le Contrat. Il peut s’agir d’un personnel chargé de l’acquisition de la ressource électronique, de la gestion des licences, d’un spécialiste du domaine, etc.

    • Vous pouvez rattacher plusieurs utilisateurs à un contrat.

    • In order to be attached to an agreement a staff user must have the erm permission (or the superlibrarian permission), otherwise they will not appear in the list when you try and select a user. This also keeps the list of patrons to a small, manageable, size by excluding your library patrons.

    • Quand vous rattachez un utilisateur, assignez-lui aussi un rôle à partir de la valeur autorisée ERM_USER_ROLES.

Form to add a user to the agreement. The Role dropdown is open, showing options for ERM librarian, Metadata librarian, Subject specialist.

  • Licences

    • Pour lier un Contrat à une Licence, utilisez le bouton « Ajouter nouvelle licence ». Un contrat peut être lié à une ou plusieurs licences.

    • Sélectionner le nom de la licence à partir du menu déroulant des licences préalablement créées et lui assigner un statut.

    • La localisation physique est le lieu où vous pouvez avoir stocké une version papier du document dans la bibliothèque.

    • Vous pouvez aussi ajouter des notes et une URI (si la licence est effectivement accessible en ligne).

Form to add a license to an agreement.

  • Related agreements

    • Un contrat en lien est tout contrat ayant une certaine relation à un contrat déjà présent. Par exemple, un contrat qui a remplacé un contrat existant.

    • Vous pouvez lier un contrat à un ou plusieurs contrats.

Form to upload a document to an agreement

  • Agreement documents

    • Vous pouvez attacher un ou plusieurs document à un contrat.

    • Ce n’est pas supposé être des documents de licence (qui sont rattachés aux notices de licences), mais d’autres types de correspondance avec un fournisseur, information sur les ressources, etc. Si vous décidez de ne créer que les information de contrat et pas les licences, alors vous pouvez bien sûr attacher les documents de licence.

    • La localisation physique est le lieu où toute version papier des documents est stockée dans le bibliothèque, et l’URI un lien vers toute copie en ligne.

Form to upload documents

Search and view an Agreement record

From the ERM home page, click on the Agreements link in the left-hand menu.

Get there: More > E-resource management > Agreements

Agreements page in the E-Resource management module, showing a table of existing agreements.

Une liste des contrats existants dans le système s’affiche, triée sur le nom du contrat.

  • Pour voir uniquement les contrats expirés, cocher “Filtrer par expiration” au-dessus du tableau. Saisir une date et cliquer “Filtrer”.

  • Pour voir uniquement les contrats liés au compte avec lequel vous êtes connecté, cocher “Afficher uniquement les miens” et cliquer “Filtrer”.

  • Vous pouvez aussi utiliser les filtres du tableau ou des colonnes et filtrer sur les données que vous recherchez (par exemple, tous les contrats avec le Statut : Clôturé).

Note

Vous pouvez personnaliser les colonnes de ce tableau en cliquant le bouton “Configurer”. Ceci renvoie vers le module Administration, spécifiquement vers la section “table id : agreements” du module Configuration des tableaux.

Clicking on the name of the agreement will take you through to the full view.

Full view of an agreement, with all the agreement's details.

La vue complète récapitule toutes les informations saisies lors de la création du contrat. Le fournisseur auquel il est rattaché (lien vers la fiche du fournisseur), le statut, chaque période du contrat, chaque utilisateur rattaché au contrat, chaque contrat en lien, et, important, ce que recouvre le contrat ; c’est à dire quels bouquets du fournisseur sont inclus dans le contrat. Le champ “Contrats en lien “ est également un lien hypertexte vers l’autre contrat et le lien est bidirectionnel. Le lien vers les bouquets est aussi hypertexte et amène à la section “Collections numériques”.

Un bouquet est une collection de titres numériques qui ont été regroupés ensemble pour la diffusion par un fournisseur/vendeur. Plutôt que vendre une licence pour un seul titre, un vendeur va proposer une sélection de ressources numériques regroupées ensemble dans un bouquet identifié (exemple Journal Archives). Celui-ci peut souvent contenir des dizaines ou des centaines de titres. Des bouquets personnalisés sont souvent négociés localement avec les fournisseurs dans les différentes parties du monde. L’intérêt d’acheter des bouquets est que la bibliothèque n’a pas besoin de négocier avec chaque éditeur individuellement pour des titres spécifiques, c’est fait par le fournisseur.

  • Agreement Filters At the top of the Agreements page you will notice a Filter box. The purpose of this is to allow you to quickly filter expired agreements or agreements which may have an upcoming renewal (and therefore might require action).

Agreements page. At the top, 'Filter by expired on' is ticked and a date has been entered.

Licences

Une licence explique ce que vous pouvez faire du contenu auquel vous avez souscrit. C’est, en effet, le contrat ou les conditions d’utilisation.

Get there: More > E-resource management > Licenses

Les licences accompagnent les contrats, ou, si vous préférez simplement enregistrer une liste de licences, ça peut fonctionner indépendamment.

Create a license record

From the ERM Home page click on the Licenses link in the left-hand menu.

Get there: More > E-resource management > Licenses

Use the “New license” button at the top of the Licenses table.

In the E-Resource management module Licenses section, the focus is on the 'New license' button.

Vous devez donner un Nom, une Description, un Type et un Statut à la licence. Le statut définit si le contrat est actif ou non. Tous les autres champs sont facultatifs.

La licence peut être, c’est facultatif, rattachée à un :ref:`fournisseur <vendors-label>`du module Acquisitions. Cela vous permet de conserver trace de à quel vendeur est liée la licence.

La Licence a une date de début et une date de fin, et ces dates peuvent être différentes de celles du Contrat.

New license form

  • Utilisateurs

    • Dans ce contexte, un utilisateur est un utilisateur professionnel qui est impliqué dans la gestion des licences. Il peut être impliqué dans la négociation ou la signature de la licence par exemple.

    • You can attach multiple users to a license.

    • In order to be attached to a license a staff user must have the erm permission (or the superlibrarian permission), otherwise they will not appear in the list when you try and select a user. This also keeps the list of patrons to a small, manageable, size by excluding your library patrons.

    • Quand vous rattachez un utilisateur, assignez-lui aussi un rôle à partir de la valeur autorisée ERM_USER_ROLES.

Form to add a user to the license. The "Role" dropdown is open, showing options ERM librarian, Metadata librarian, Subject specialist.

  • License documents

    • You can attach one or more documents to a license record. From here you can attach PDF copies of license or terms of use.

    • The physical location is where any paper version of the correspondence is held in the library and the URI provides a link to any online copy.

Form to upload documents

Note

The file size of any uploaded documents for both licenses and agreements is limited to the value of the max_allowed_packet size in your MariaDB configuration file. If you exceed this size, you will get a file size warning. Speak to your system administrator to increase this value.

The Documents section is in the background. In the foreground, the error message 'File size exceeds maximum allowed: 16.00 MB' appears.

Search and view a license record

From the ERM Home page click on the Licenses link in the left-hand menu.

Get there: More > E-resource management > Licenses

Licenses page in the E-Resource management module, showing a table of existing licenses

You will be presented with a list of existing licenses in the system ordered by the license name. You can use the table or column filters to search and filter data you are looking for (for example, all licenses with the Status: expired).

Note

You can customize the columns of this table by clicking the “Configure” button. It will take you to the Administration module and specifically to the “table id: licenses” section of the Table settings.

Clicking on the name of the license will take you through to the full view.

Full view of a license, with all the license's details

The full view summarizes all the information you entered when you were creating the license. The vendor it is attached to (which is a hypertext link to the vendor record), the Status, Type, start and end dates, any users associated with the license and, importantly, the link to the license document(s).

Collections numériques

Définition des termes :

  • Resource

    • A resource is an instance of a title. Consequently a resource would have a separate resource ID for each occurrence of the title in a package.

    • For example: Teise / Law belongs in

      • DOAJ

      • Criminal Justice Abstracts with Full Text

      • etc.

  • Knowledge base (KB)

    • A knowledge base is an extensive database maintained by a knowledge base supplier (for example, EBSCO) that contains information about electronic resources such as title lists and coverage dates, etc. Knowledge bases typically organize the resources provided by a content provider into collections or databases that reflect specific content provider offerings, for example packages of e-journals, e-books, or other materials.

  • Providers

    • The provider of the e-resource, for example, the vendor, consortia or publisher.

  • Packages

    • A collection of e-resource titles bundled together and distributed by a provider.

  • Titles

    • The individual e-resources, for example a journal or e-book, usually contained within a package.

Aller à : Plus > Gestion des ressources électroniques

On the left-hand navigation menu, you will see links for each provider you have configured in the ERMProviders system preference.

E-Resource management module left-hand side navigation, showing configured providers EBSCO and Local under eHoldings.

EBSCO

The integration with the EBSCO global knowledge base is facilitated via their HoldingsIQ tool. This is a bidirectional API that allows you to update or read from EBSCO’s knowledge base of millions of titles. Your instance of the EBSCO knowledge base becomes searchable and manageable via Koha using your Customer ID in the configuration. Remember, the knowledge base always sits at EBSCO, you are just manipulating it through Koha in the same way you would if you were using EBSCOadmin. No content data is held locally in your Koha system.

Packs

Get there: More > E-resource management > EBSCO > Packages

On the Package home screen you will see a search box

EBSCO Packages page, showing blank search box at the top.

Koha acts as a “proxy” for the EBSCO HoldingsIQ service so any search you do here is done in real time against the EBSCO knowledge base (using your Customer ID in the ERMProviderEbscoCustomerID system preference). There are two filters:

  • Content type: This filter is provided by EBSCO as part of their HoldingsIQ API and allows you to narrow down your search to a particular content type (as defined by EBSCO).

  • Select status: This filter is provided by EBSCO as part of their HoldingsIQ API and allows you to narrow down your search to material that you may already have added to your holdings through EBSCOadmin. So, for example, you can search for packages that you have already subscribed to.

Any package which is already selected is indicated by a check mark on the right-hand side of the title.

EBSCO Packages page, showing 'Journal archives' in the Package name field of the search box and a list of results underneath.

Entre parenthèses, vous pouvez lire l’identifiant du pack EBSCO.

When you click on a package link, you will be taken to the full view of the package.

Full view of a package, showing its name, vendor, package type, content type, which agreement it is part of and a list of titles.

Some information displayed here is brought through from the HoldingsIQ API, you can see the Vendor (this is NOT the Koha vendor), the Content type and the Package type. You can also see from this screen that the package contains (in this case) 877 titles. As with the package list, you can see from here (by the check marks) which titles have been selected and which not.

Clicking on the Show filters link will give you some additional filters to allow you to search within the package for a particular title or group of titles. This can be by Publication type, Selection status (titles already selected, or not, in EBSCOadmin) and a title search box.

Full view of a package. Under the details, there are additional filters for Title, Publication type, Selection status.

Add package to an Agreement

In the example above, you can see that this package has already been added to the existing Agreement record in Koha (called Journal Archives). A package can be added to multiple Agreement records. Clicking the hypertext link will take you to the agreement record.

Once you have made this connection, you will see the package listed on the agreement record.

Full view of an agreement. The section with links to two packages is highlighted.

To add to a new package, click on the “Add new agreement” button and you will be taken to a dialogue box with a list of agreements that can be filtered. Use the Select button to make the connection between the two records.

List of agreements; the Select button on the right-hand side is highlighted.

Use the “Delete” icon to remove a package from an agreement.

Show package view; on the right of the agreement name, the bin icon is highlighted.

If you try to add a package to the same agreement more than once, you will receive the following error message:

In the foreground of the list of titles, an error message says: 'This agreement is already linked with this package.'

Add/remove package from holdings

From the package view, you are also able to add or remove a complete package from your EBSCO holdings.

On the Show package view, the focus is on the 'Remove package from holdings' button.

This makes an API call via the HoldingsIQ service to add or remove the package from your EBSCO central holdings. Because this is a real-time call you should see your holdings updated in EBSCOadmin as well.

You can also click on a title link here and go into the detail of a specific title in a package.

Resource information view, showing the title, publisher name, package, vendor and other details.

The Resource # you can see at the top of the screen is the EBSCO resource ID. The metadata you see is also returned by the HoldingsIQ API from the EBSCO knowledge base. You can see the Publication title, name, Publication type, and print/online IDs and the coverage dates. Remember the coverage dates of a title may be different depending on the package that the title is included in. You can also see both the Vendor and the Package (which is a hypertext link back to the full package you have come from).

Add/remove title from package

You can add or remove a title from a package you are subscribed to.

Resource information view, with the focus on the 'Add title to holdings' button

Although you may subscribe to a complete package, there may be individual titles you wish to specifically include/exclude. Use the ‘Add/remove title to holdings’ button to do this.

Titres

Get there: More > E-resource management > EBSCO > Titles

On the Titles home screen, you will see a search box.

EBSCO Titles page, showing blank search box at the top.

Koha acts as a “proxy” for the EBSCO HoldingsIQ service so any search you do here is done in real time against the EBSCO knowledge base (using your Customer ID in the ERMProviderEbscoCustomerID system preference). There are two filters:

  • Publication type: This filter is provided by EBSCO as part of their HoldingsIQ API and allows you to narrow down your search to a particular publication type (as defined by EBSCO).

  • Select status: This filter is provided by EBSCO as part of their HoldingsIQ API and allows you to narrow down your search to titles that you may already have added to your holdings through EBSCOadmin. So, for example, you can search for titles that you have already subscribed to.

Any title which is already selected is indicated by a check mark on the right-hand side of the title.

EBSCO Titles page, showing 'tetrahedron' in the Publication title field of the search box and a list of results underneath.

You will also notice that this search also searches for Local titles in addition to EBSCO titles. Any local titles will be indicated above the title list and this is a hypertext link to take you through to the Local titles table.

EBSCO Titles page with search results; the focus is on the '2 titles found locally' link.

By clicking on a title, you can go into the full record view of it.

Full view of a title; showing details such as the publisher name, publication type and a list of packages it is in.

At the top you see the Title #. This is the EBSCO title reference. The rest of the metadata all comes from the HoldingsIQ API and includes things like IDs, publishers etc.

You can also see here every Package that this title is contained in. The check mark indicates that you are already subscribed to this package. So, in the example above, we have this title via the ScienceDirect package but not Scholars Portal.

If you click on the Package link, you will see the view of that resource within that package.

Resource information view, with the focus on the package name and vendor.

This includes the coverage provided by that provider.

If you want to selectively add or remove that title from your package holdings you can do that from this screen.

Resource information view, with the focus on the 'Remove title from holdings' button

You can also see the EBSCO resource ID on this screen. Remember that the resource ID represents the instance of a title within a package.

If you want to go back to the title record, you can click on the Title link.

On the Title page, you are also provided with filters to narrow down your search. You get to this by clicking on the Show/Hide filters link.

Full view of a title. Under Packages, there are additional filters for Package name and Selection status.

This is useful if you want to narrow down your query to a specific package or to packages that are already selected in your holdings.

Ressources locales

Local holdings are electronic holdings which are not contained in a global knowledge base but, instead (unlike EBSCO holdings) are stored in the local Koha database tables (erm_eholdings_titles).

Titres

Get there: More > E-resource management > eHoldings > Local > Titles

On the Local Titles home screen, you will see a list of currently created local titles.

eHoldings Local Titles homepage, showing a list of titles

You can use the table and column filters to narrow down your list to a selected title or group of titles.

Note

You can customize the columns of this table by clicking the “Configure” button. It will take you to the Administration module and specifically to the “table id: titles” section of the Table settings.

By clicking on a title, you can go to the full view of the record.

Full view of a title, showing details such as identifiers, publication title, first author and publication type. The focus is on the packages table where one package appears.

Ici, vous pouvez Modifier ou Supprimer la notice.

If the record belongs to a locally created package, you will see that information here.

Full view of a title, showing details such as identifiers, publication title, first author, publication type.

If the title is part of more than one package, you can use the table filters to restrict your search further. Clicking on the Package link will take you through to the package itself.

Create a new local title record

From the ERM Home page click on the Titles link in the left-hand menu under Local.

Get there: More > E-resource management > eHoldings > Local > Titles

Use the “New Title” button at the top of the Titles table.

In the eHoldings Local Titles section, the focus is on the 'New title' button.

You should see a metadata template. This template is based on KBART metadata.

New local title form

When you save the title, Koha will also automatically create a bibliographic record for you with as much of the metadata as possible. We map the KBART metadata to MARC21 in the following way:

  • publication_title = biblio.title

  • print_identifier = 020$a||020$z||022$a||022$y

  • online_identifier = 020$a||020$z||022$a||022$y

  • date_first_issue_online = 866$a (avant “-“)

  • date_last_issue_online = 866$a (après “-“)

  • num_first_vol_online = 863$a (avant “-“)

  • num_last_vol_online = 863$a (après “-“)

  • title_url = 856$u

  • first_author = biblio.first_author

  • coverage_depth = title_url ? “fulltext” : “print”

  • notes = $852$z

  • publisher_name = 260$b

When you save the record and look at the full view, you will see a link to the bibliographic record.

Full view of a title. The focus is on the link to 'Local bibliographic record'.

At the bottom of the creation/edit template, you will see the option to add the title to a local package.

Form to add a title to a package, showing fields for the package name, vendor, start and end dates.

The package record must already exist before you try to link to it from the dropdown menu. You can also specify the Vendor, start and end dates and a reference to a proxy server if one is required for this service (this is not currently used in Koha, for reference only).

A title can belong to multiple packages.

Import a new local title record from a List

If you want to quickly add multiple title records to your Local holdings, then you have the option to import from a Koha List.

In the eHoldings Local Titles section, the focus is on the 'Import from list' button.

First of all, create a Koha List (as described elsewhere in this manual) and add some bibliographic information to it (either by creating the record manually or by importing it via z39.50 or Stage MARC records). Once the list has been created, you will see it in the table selection.

Import from a list page. Under 'To the following package', Oxford Clinical Psychology is selected. Below is a table of Koha lists. The focus is on the 'Import' button on the line for one of the lists.

First select the package you want to add the titles to and then select the list from the selection in the table. Use the Import button to link them together.

You will see a message “import in progress” and the job should be completed in a few moments. You can click on the Job number if you want to view progress.

Page for a background job showing the job ID, status, progress, type, start and end dates and times. The Type field has the information 'Create eHoldings title'.

At this point you should see the titles in both the title list and also attached to your selected package.

Import a new local title record from a KBART file

Version

This component of ERM was introduced in version 24.05 of Koha.

If you want to quickly add multiple title records to your Local holdings, and your vendor can provide KBART records, then this is a quick way to get eholdings records into Koha.

First of all, create a Local package to attach the title records to.

Get there: More > E-resource management > eHoldings > Local > Packages

Once you have done that, go to your Local titles and use the button marked “Import from KBART file”.

In the eHoldings Local Titles section, the focus is on the 'Import from KBART file' button.

From here, use the File button to select a file of KBART files from your local device. Select the Package that you want to attach the titles to and, finally, select whether you want Koha to try and create basic bibliographic records from the data in the KBART file (this is optional).

Once the file is imported it will be sent to the background jobs for processing. You can check Background Jobs for progress but, once completed, the titles will appear in your Local title list.

In the eHoldings Local Titles section, showing the screen to select a KBART file and add to package.

Some useful resources:

KBART Standard NISO KBART Registry (good source for KBART files) Useful information on KBART format etc.

Note

The imported KBART file should be in TSV or CSV format

Packs

Get there: More > E-resource management > eHoldings > Local > Packages

On the Local Package home screen, you will see a list of currently created local packages.

The eHoldings Local Packages page, with a list of packages displayed in a table

Note

You can customize the columns of this table by clicking the “Configure” button. It will take you to the Administration module and specifically to the “table id: packages” section of the Table settings.

Clicking on a package name will take you through to the full view.

Full view of a package, showing details such as package name, vendor, package type, content type and a list of titles.

You can use the table filter to narrow down the titles if you need to.

Clicking on the title will take you to the title full view and clicking on the Vendor will take you through to the vendor record in acquisitions.

From this screen you can also use the Edit or Delete buttons.

When you edit a package, you have the option to attach it to an agreement you have already created.

Form to edit a package, showing details such as package name, vendor, package type, content type and notes. In the Agreements section at the bottom, the Agreement field dropdown is open, showing a list of existing agreements.

This package will then be viewable on the agreement record.

Create a new local package record

Get there: More > E-resource management > eHoldings > Local > Packages

Select the “New package” button.

In the eHoldings Local Packages section, the focus is on the 'New package' button.

The Package name is a required field. You must have already created your agreement prior to attaching it to a package.

New local package form

Les champs Fournisseur, Type, Type de contenu et Notes sont facultatifs.

Remove a local title from a package record

Get there: More > E-resource management > eHoldings > Local > Titles

Search for the title you want to remove from the Local titles list.

In the eHoldings Local Titles section, the term 'uncons' has been typed into the search box in the Title column. Results displayed all have the title 'An unconsidered people'

Click through to the title detail and use the “Edit” button.

At the bottom of the screen use the “Remove from this package” link.

In the title edit screen, the focus is on the Packages section and the button 'Package 1 - Remove from this package'

Fournisseur de données

Version

This component of ERM was introduced in version 23.11 of Koha.

Data Providers (or Data Platforms) are the organizations who provide usage statistics for your electronic resources. This could be a vendor or a platform provider. The data provider record contains information about SUSHI credentials and any COUNTER data which has been harvested from the provider.

Definitions:

  • SUSHI (Standardized Usage Statistics Harvesting Initiative) is an ANSI/NISO standard that defines the model for harvesting e-resource usage data. It is designed to work with COUNTER.

  • COUNTER provides the standard that enables the knowledge community to count the use of electronic resources. Known as the Code of Practice, the standard ensures vendors and publishers can provide their library customers with consistent, credible and comparable usage data. Koha currently only supports version 5 of the COUNTER standard.

Note

Before you start to create new Data provider records, ensure your staff users have the erm permission (or the superlibrarian permission) and that you have reviewed the ERM authorized values to suit your needs. Also, ensure you have reviewed the ERM system preferences.

Create a Data Provider record

From the ERM Home page click on the Data providers link in the left-hand menu.

Get there: More > E-resource management > Data providers

Use the “New data provider” button at the top of the Data Providers table.

The Data providers page in the eUsage section, with the following message showing: 'There are no usage data providers defined.'

You are required to give the Data provider a name and list of report type(s). Koha, by default, will search the Project Counter Registry and add the provider details automatically for you unless you select the “Create manually” button.

Start typing in the Data provider name box to see a list of providers registered on the Project Counter Registry.

In the Add data provider screen, the Data provider name has 'wi' typed in the search box. A dropdown menu is open underneath, with the options 'University of Wisconsin Press' and 'Wiley Online Library'.

By setting the Harvester status to “Active” it will be picked up by the background harvesting cronjob (erm_run_harvester.pl).

Report types is a required field and this defines which report type data is harvested from the provider. If you have created the provider from the Project Counter Registry then the report types supported will be automatically pulled through to the report types list and you can choose to select from that list or Select All. For more information about the report types, see here. If you are unsure which report types your provider supports, and you are creating your provider manually, check the Project Counter Registry and search for the provider.

Page for Wiley Online Library on the Counter Registry website. The section Supported reports is highlighted.

In the Add data provider screen, the Report types dropdown list is open. The options for 'TR - Title master report' and 'TR_J1 - Journal requests (excluding OA_Gold)' are already selected.

If you do not create the provider manually, the SUSHI credentials will be completed with information from the Registry. The “Credentials information” is also pulled through to assist you with the information you need to request from the provider. This may include a Customer Id, Requester Id or API key. You may also be required to provide a requester name and email.

The SUSHI credentials section of the Add data provider screen, showing four fields as being required: service URL, report release, customer ID, requestor ID.

You can toggle between the “Create manually” and “Create from registry” buttons depending on whether you want to input the information yourself or take it from the registry. You can also take the information from the registry and then toggle to “Create manually” if you want to update things like the name.

Data providers home screen

The Data providers home screen provides you with a list of your current data providers. You can see at a glance whether they are active or inactive and when the last harvest of that platform took place. Use the table filters to search for a specific Data provider. The four action buttons work as follows:

  • Test

    • The “Test now” button will access the SUSHI endpoint you have configured and test your credentials to ensure they are valid. If the Data provider is inactive, you will receive a warning that the test cannot be completed.

Data providers screen with the yellow alert message: 'This data provider is inactive - connection testing is not possible'.

  • If the Data provider is active, you will receive a success or failure message.

Data providers screen with the message: 'Harvester connection was successful for usage data provider ABC-CLIO'.

  • Run now

    • This will trigger an immediate harvest of the source. Run now also prompts you to provide a start and end harvest date.

Astuce

Instead of manually clicking “Run now” for every provider when you need to check new usage statistics, you can set up the harvesting cron job on your server. The erm_run_harvester.pl script will harvest the SUSHI data for all active usage data providers at regular intervals.

Data providers screen with the yellow alert message: 'Are you sure you want to run the harvester for this data provider? ABC-CLIO'. Begin date and end date are required fields.

You will also see a link to the background job. There is one background job per report type.

Data providers screen with the messages: 'Job for report type TR_J1 has been queued, click here to check its progress.' and 'Job for report type TR_J2 has been queued, click here to check its progress.'

The summary page will give you a list of the report rows processed from the incoming COUNTER file and the number of provider title records imported into Koha. In addition it shows the amount of usage statistic counts that have been added to the data provider title tables. Each successfully added new title will have a check mark next to it to indicate it has been newly added.

A view of the harvesting job summary, with a table saying 922 titles were added. A section underneath called Detailed messages has information such as "ANZ Journal of surgery successfully added".

If the title already exists in Koha then you will see an alert that it exists but any counts have been updated.

A view of the harvesting job summary, with a table saying 50 titles were added. A section underneath called Detailed messages has information such as "AORN Journal already exists in this data provider and was not created. New usage statistics were verified anyway".

  • Edit

    • To edit an existing Data Provider

  • Delete

    • To delete a Data Provider

Data provider summary

Next to the “New data provider” button, you will see a link to the Data provider summary. This gives you an at-a-glance view of all your Data providers, and the earliest and most recent data you have for each report type.

Data providers summary, with columns for title reports, platform reports, database reports and item reports. All columns have subdivisions for start and end dates.

Search and view a Data Provider record

From the ERM Home page click on the Data providers link in the left-hand menu.

Get there: More > E-resource management > Data providers

You will be presented with a list of existing Data providers in the system. You can use the table or column filters to search and filter data you are looking for (for example, all Data providers with the Status: Active).

Clicking on the Name of the Data providers will take you through to the full view.

From here you can see a summary of the report types and SUSHI credentials but also some tabs which contain harvested data for Titles (TR), Platforms (PR), Items (IR) and Database (DR) reports.

Full view of a data provider Detail tab, showing the information about the provider and SUSHI credentials.

If we look at Titles, as an example, you can see a list of all harvested titles from this platform along with identifiers from the COUNTER report. Use the search boxes to narrow down your results.

View of a data provider Titles tab. In the table of titles, there is information such as publisher, DOI, print and online ISSN, URI.

The Import logs tab gives an audit trail of all harvests including the import date and time. You will also see a “Download” button which allows you to download the original COUNTER 5 file if you want to use it in another application or import it into a spreadsheet. You can also Delete the file from here along with the log entry.

View of a data provider Import logs tab. The table contains information on the name of the imported file, the import date and how it was imported (e.g., by cronjob).

The Manual upload tab allows you to manually upload a COUNTER 5 file from your desktop. Use this for providers who don’t provide a SUSHI endpoint but can provide you with COUNTER compatible files via email or some other mechanism.

View of a data provider Manual upload tab. There is a button to select a file to upload.

Rapports

From the ERM Home page click on the Reports link in the left-hand menu.

Get there: More > E-resource management > Reports

Click the “Create Report” tab to create a new report.

On the Reports home page, you will see a list of any “Saved reports” and also the ability to “Create report”.

Usage statistics reports open on the Saved reports tab, with the message: "You have not saved any reports yet, please create a report."

Create report

Usage statistics reports are located under the ERM module rather than the general Koha reporting module because of the unique nature of the statistical data.

Usage statistics reports open on the Create report tab. There are multiple parameters available: data display ('by month' is selected), data provider, report, metric type, access type, start year, start month, end year, end month, keyword, report columns, date display method.

Select report data

  • Data display (Required)

    • Depending on the nature of the data you are looking at, you have a number of data displays: both monthly and annual counts, with or without totals; counts by metric type, Total or Unique item requests. You can also use data provider totals to get a single overall count.

In the Create report form, the Data display field has a dropdown with the options: by month, by month with period total, by year, by metric type, by data provider totals.

  • Choose data provider

    • You can specifically look at data for a single Data Provider (platform) by selecting the data provider from the dropdown list.

In the Create report form, the Choose data provided field is highlighted. The provider Proquest has already been selected.

  • Choose report (Required)

    • Once you have selected a data provider, you can only select a report type that is in use in the data provider record. So, if the data provider supports TR_J1 and TR_J2 for example, these are the only report types you will see listed.

    • If you select the report type before the provider, this will limit the drop-down list of providers to those who support that report type.

In the Create report form, the Choose report field has a dropdown with the options: "TR_J1 - Journal requests (excluding OA_Gold)" and "TR_J2 - Journal access denied"

  • Choisir un type de mesure

    • The metric types which display depend on the report type you have selected. Some metric types only apply to certain report types. For example, TR_J1 supports Total Item Requests and Unique Item Requests whereas PR_P1 will give you Searches platform.

    • Si vous ne choisissez pas un type de mesure, tous les types de mesures seront affichés dans votre rapport.

In the Create report form, the Choose metric type field has a dropdown with the options: Total item requests, Unique item requests.

  • Choisir un type d’accès

    • For some very specific reports (e.g. TR_J3 and TR_B3) the data is broken down further into access types. When you select one of these reports, you will see that the access type field becomes active and offers an option of Controlled and OA_Gold.

  • Start year (Required)

    • You must provide a start year for your report data.

  • Mois de départ

    • Vous pouvez (facultativement) préciser un mois si vous souhaitez visualiser les données d’une période précise.

  • End year (Required)

    • You must provide an end year for your report data.

  • Mois de fin

    • Vous pouvez (facultativement) préciser un mois si vous souhaitez visualiser les données d’une période précise.

In the Create report form, the focus is on the date fields: Start year, Start month, End year, End month.

  • Mot-clef

    • Once you have selected a specific data provider, you can use the Keyword option to search for a specific title. This allows you to see statistics for a particular publication.

In the Create report form, the term "anim" has been typed in the Keyword field. A dropdown list of results appears underneath, with the options "Animal Conservation", "Animal Genetics" and "Animal Science Journal".

Sélectionner les colonnes du rapport

By default, the Provider name is output to your report but you can also include additional data which is included in your COUNTER report such as Publisher, DOI, etc.

In the Create report form, the Select report columns section has checkboxes for Provider name, Publisher, Platform, Publisher ID, Online ISSN, Print ISSN, DOI, URI.

Check the COUNTER documentation for information about all the COUNTER reports.

Select date display method

When set to Yes, the data will always be listed by a 12-month period from January to December. This is to make the report readable on the screen. On the report output, you will have the option to toggle by year if you have selected data for more than one year.

When set to No, you will have one column for every month selected. Obviously, if you have many months selected you may be required to use your scrollbar to navigate the results on the page.

You can save your report by entering a name and selecting “Save report”.

In the Create report form, the focus is on the 'Save report' button. In the text box next to it, the words 'Wiley monthly statistics for 2023' have been entered.

Saved reports

Once you have created a report, it will appear on the “Saved reports” tab for future use.

On the Usage statistics Saved reports tab, the Choose report dropdown list is open. 'Wiley monthly statistics for 2023' is the first option.

In order to Delete a saved report, use the Delete button on the Saved reports page once you have selected the report you would like to delete.

On the Usage statistics Saved reports tab, the report 'Wiley monthly statistics for 2023' is selected. The focus is on the Delete report button underneath.

Once your report is set up select Submit to run the query. A report with data display set to Yes will look like this

Report results view. At the top is an option to 'Display by year' set to 2023. The table of results has the following columns: Title, Data provider, DOI, Metric; plus a column for each month from January to December.

Take note of the “Display by year” toggle at the top. If there is more than one year, you can use this to update the table with data from previous years.

When you select No, you will be offered a list of months to select/deselect.

In the Create report form, the focus is on the Date display method. The option ticked is 'No - table will include one column for each month of data selected'. A section called 'Select months to display' appears underneath, with some months ticked.

Because of the number of months selected the report may scroll off to the right of your page.

Astuce

Make sure you have harvested the latest data from your provider before you run the report. You can either do this manually by clicking “Run now” in the data provider home screen, or you can use the harvesting cron job to automatically harvest data at regular intervals.