Attachment 149244 Details for Bug 33435 – Bug 33435: Add sample ERM data

[patch] Bug 33435: Add sample ERM data

Bug-33435-Add-sample-ERM-data.patch (text/plain), 13.96 KB, created by Pedro Amorim on 2023-04-06 16:48:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Pedro Amorim

Created: 2023-04-06 16:48:45 UTC

Size: 13.96 KB

patch

obsolete

>From f0fc6672ebf0ecbf722787c41f4403a60277e372 Mon Sep 17 00:00:00 2001
>From: Pedro Amorim <pedro.amorim@ptfs-europe.com>
>Date: Thu, 6 Apr 2023 16:45:13 +0000
>Subject: [PATCH] Bug 33435: Add sample ERM data
>
>Apply patch
>run reset_all
>Check ERM module and verify it has data in it
>---
> .../mysql/en/optional/sample_erm_data.yml     | 356 ++++++++++++++++++
> 1 file changed, 356 insertions(+)
> create mode 100644 installer/data/mysql/en/optional/sample_erm_data.yml
>
>diff --git a/installer/data/mysql/en/optional/sample_erm_data.yml b/installer/data/mysql/en/optional/sample_erm_data.yml
>new file mode 100644
>index 00000000000..07e3b1fb753
>--- /dev/null
>+++ b/installer/data/mysql/en/optional/sample_erm_data.yml
>@@ -0,0 +1,356 @@
>+---
>+#
>+#  Copyright 2023 Koha Development Team
>+#
>+#  This file is part of Koha.
>+#
>+# Koha is free software; you can redistribute it and/or modify it
>+# under the terms of the GNU General Public License as published by
>+# the Free Software Foundation; either version 3 of the License, or
>+# (at your option) any later version.
>+#
>+# Koha is distributed in the hope that it will be useful, but
>+# WITHOUT ANY WARRANTY; without even the implied warranty of
>+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
>+# GNU General Public License for more details.
>+#
>+# You should have received a copy of the GNU General Public License
>+# along with Koha; if not, see <http://www.gnu.org/licenses>.
>+
>+description:
>+  - "Sample ERM data"
>+
>+tables:
>+  - erm_agreements:
>+      translatable: [ ]
>+      multiline: [ description ]
>+      rows:
>+        - agreement_id: 1
>+          vendor_id: ~
>+          name: ACM Digital Library Journals Agreement 2021
>+          description:
>+            - "The ACM Digital Library is a comprehensive collection of full-text articles and bibliographic records covering the fields of computing and information technology. The full-text database includes the complete collection of ACM's publications, including journals, conference proceedings, magazines, newsletters and multimedia titles."
>+          status: active
>+          closure_reason: ~
>+          is_perpetual: 0
>+          renewal_priority: for_review
>+          license_info: Some general licence notes go here
>+
>+        - agreement_id: 2
>+          vendor_id: ~
>+          name: British Periodicals
>+          description:
>+            - "Continuing a tradition of comprehensive full-run coverage for popular periodicals that began with American Periodicals Series Online, this resource offers facsimile page images and searchable full text for nearly 500 British periodicals published from the seventeenth century through to the twentieth century."
>+          status: active
>+          closure_reason: ~
>+          is_perpetual: 1
>+          renewal_priority: renew
>+          license_info: ~
>+
>+        - agreement_id: 3
>+          vendor_id: ~
>+          name: ABI/INFORM Dateline
>+          description:
>+            - "ABI/INFORM Datelineâ¢ delivers over 280 journals, with more than 230 available in full text. It includes hard-to-find local and regional business publications with news about local companies, analysis, information on local markets, and more. ABI/INFORM Dateline allows users to research employment opportunities, compile data on benefits and compensation, learn about corporate strategies, and other topics from a local and regional perspective. ABI/INFORM Dateline includes major business tabloids, magazines, daily newspapers, wire services, and area business publications."
>+          status: closed
>+          closure_reason: cancelled
>+          is_perpetual: 0
>+          renewal_priority: for_review
>+          license_info: ~
>+
>+        - agreement_id: 4
>+          vendor_id: ~
>+          name: American Chemical Society Journals Agreement 2019-2021
>+          description:
>+            - "The American Chemical Society is a not-for-profit organisation chartered by the U.S. Congress. With more than 163,000 members, ACS is the world's largest scientific society and a global leader in providing access to chemistry-related research through its multiple databases, peer-reviewed journals, and scientific conferences. The ACS Web Editions collection will contain 58 journals in 2019. ACS also publishes around 35-40 e-books each year, also available via Jisc Collections (an updated offer is in preparation)."
>+          status: active
>+          closure_reason: ~
>+          is_perpetual: 1
>+          renewal_priority: renew
>+          license_info: ~
>+
>+        - agreement_id: 5
>+          vendor_id: ~
>+          name: Journal Archives
>+          description:
>+            - "Journal Archives brings together content from 8 major publishers: Brill, Institution of Civil Engineers, Institute of Physics, ProQuest, Oxford University Press, Cambridge University Press, the Royal Society of Chemistry and Taylor and Francis. Journal Archives can be searched by anyone, but access to view and download articles is only available to UK HE and FE Institutions and Research Councils via subscription."
>+          status: active
>+          closure_reason: ~
>+          is_perpetual: 1
>+          renewal_priority: renew
>+          license_info: ~
>+
>+  - erm_agreement_periods:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - agreement_period_id: 1
>+          agreement_id: 1
>+          started_on: "2022-04-01"
>+          ended_on: "2023-03-31"
>+          cancellation_deadline: "2023-03-31"
>+          notes: ~
>+
>+        - agreement_period_id: 2
>+          agreement_id: 1
>+          started_on: "2022-01-01"
>+          ended_on: "2023-03-31"
>+          cancellation_deadline: "2023-01-31"
>+          notes: ~
>+
>+        - agreement_period_id: 3
>+          agreement_id: 2
>+          started_on: "2021-01-01"
>+          ended_on: "2024-03-31"
>+          cancellation_deadline: ~
>+          notes: ~
>+
>+  - erm_agreement_relationships:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - agreement_id: 1
>+          related_agreement_id: 2
>+          relationship: is-superseded-by
>+          notes: ~
>+
>+        - agreement_id: 2
>+          related_agreement_id: 1
>+          relationship: supersedes
>+          notes: ~
>+
>+  - erm_licenses:
>+      translatable: [ ]
>+      multiline: [ description ]
>+      rows:
>+        - license_id: 1
>+          vendor_id: ~
>+          name: ACM Digital Library Licence
>+          description:
>+            - "ACM Digital Library Licence"
>+          type: local
>+          status: active
>+          started_on: "2022-01-01"
>+          ended_on: "2022-12-31"
>+
>+        - license_id: 2
>+          vendor_id: ~
>+          name: British Periodicals
>+          description:
>+            - "British Periodicals Licence"
>+          type: local
>+          status: active
>+          started_on: "2022-04-01"
>+          ended_on: "2022-03-31"
>+
>+        - license_id: 3
>+          vendor_id: ~
>+          name: OUP Oxford Academic Law Online Products 2021-2023
>+          description:
>+            - "The comprehensive coverage includes case reports, analytical commentaries, key copyrights, translations, reference works, constitutions and a host of other law materials which are easily cross-searchable and comparable. All Oxford law online subscription products cover e-books, primary and secondary sources as included on the sites below: Oxford Public International Law Oxford Constitutional Law Oxford Competition Law Investment Claims Oxford Legal Research Library The online resources have been bundled into collections according to type of resource. This allows for volume discounts to be applied as well as additional discounts according to Jisc Bands. The discounted rates are only available on the collections offered within the agreement."
>+          type: local
>+          status: active
>+          started_on: "2022-01-01"
>+          ended_on: "2022-12-31"
>+
>+  - erm_agreement_licenses:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - agreement_license_id: 1
>+          agreement_id: 1
>+          license_id: 1
>+          status: controlling
>+          physical_location: filing_cabinet
>+          notes: ~
>+          uri: ~
>+
>+        - agreement_license_id: 2
>+          agreement_id: 2
>+          license_id: 3
>+          status: controlling
>+          physical_location: filing_cabinet
>+          notes: ~
>+          uri: ~
>+
>+  - erm_eholdings_packages:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - package_id: 1
>+          vendor_id: ~
>+          name: Grove Online Packages
>+          external_id: ~
>+          provider: ~
>+          package_type: local
>+          content_type: OnlineReference
>+          notes: ~
>+          created_on: "2022-12-14 16:02:52"
>+
>+        - package_id: 2
>+          vendor_id: ~
>+          name: American Chemical Society (NESLi2)
>+          external_id: 37-7824
>+          provider: ebsco
>+          package_type: ~
>+          content_type: ~
>+          notes: ~
>+          created_on: "2022-12-14 15:46:25"
>+
>+        - package_id: 3
>+          vendor_id: ~
>+          name: British History
>+          external_id: ~
>+          provider: ~
>+          package_type: local
>+          content_type: MixedContent
>+          notes: A collection of local history titles, all coming from one supplier
>+          created_on: "2022-12-14 15:58:18"
>+
>+
>+
>+  - erm_eholdings_packages_agreements:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - package_id: 1
>+          agreement_id: 1
>+
>+        - package_id: 2
>+          agreement_id: 2
>+
>+  - erm_eholdings_titles:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - title_id: 1
>+          biblio_id: ~
>+          publication_title: Aftershocks Politics and Trauma in Britain, 1918-1931
>+          external_id: ~
>+          print_identifier: ~
>+          online_identifier: 9780230582002
>+          date_first_issue_online: ~
>+          num_first_vol_online: ~
>+          num_first_issue_online: ~
>+          date_last_issue_online: ~
>+          num_last_vol_online: ~
>+          num_last_issue_online: ~
>+          title_url: http://www.vlebooks.com/vleweb/product/openreader?id=NationalAr&isbn=9780230582002&uid=^u
>+          first_author: Kent, Susan Kingsley, 1952-
>+          embargo_info: ~
>+          coverage_depth: ~
>+          notes: Includes bibliographical references (p. 218-225) and index
>+          publisher_name: Palgrave MacMillan,
>+          publication_type: ebook
>+          date_monograph_published_print: ~
>+          date_monograph_published_online: ~
>+          monograph_volume: ~
>+          monograph_edition: ~
>+          first_editor: ~
>+          parent_publication_title_id: ~
>+          preceeding_publication_title_id: ~
>+          access_type: ~
>+
>+        - title_id: 2
>+          biblio_id: ~
>+          publication_title: An unconsidered people
>+          external_id: ~
>+          print_identifier: 9781848408227
>+          online_identifier: 9781848408227
>+          date_first_issue_online: ~
>+          num_first_vol_online: ~
>+          num_first_issue_online: ~
>+          date_last_issue_online: ~
>+          num_last_vol_online: ~
>+          num_last_issue_online: ~
>+          title_url: ~
>+          first_author: Dunne, Catherine,
>+          embargo_info: ~
>+          coverage_depth: print
>+          notes: ~
>+          publisher_name: ~
>+          publication_type: ~
>+          date_monograph_published_print: ~
>+          date_monograph_published_online: ~
>+          monograph_volume: ~
>+          monograph_edition: ~
>+          first_editor: ~
>+          parent_publication_title_id: ~
>+          preceeding_publication_title_id: ~
>+          access_type: ~
>+
>+        - title_id: 3
>+          biblio_id: ~
>+          publication_title: Bibliography of British and Irish History.
>+          external_id: ~
>+          print_identifier: ~
>+          online_identifier: ~
>+          date_first_issue_online: ~
>+          num_first_vol_online: ~
>+          num_first_issue_online: ~
>+          date_last_issue_online: ~
>+          num_last_vol_online: ~
>+          num_last_issue_online: ~
>+          title_url: ~
>+          first_author: ~
>+          embargo_info: ~
>+          coverage_depth: ~
>+          notes: ~
>+          publisher_name: Turnhout Brepolis, 1999-
>+          publication_type: database
>+          date_monograph_published_print: ~
>+          date_monograph_published_online: ~
>+          monograph_volume: ~
>+          monograph_edition: ~
>+          first_editor: ~
>+          parent_publication_title_id: ~
>+          preceeding_publication_title_id: ~
>+          access_type: ~
>+
>+  - erm_eholdings_resources:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - resource_id: 1
>+          title_id: 1
>+          package_id: 1
>+          vendor_id: ~
>+          started_on: "2022-01-01"
>+          ended_on: "2022-12-31"
>+          proxy: ~
>+
>+        - resource_id: 2
>+          title_id: 2
>+          package_id: 1
>+          vendor_id: ~
>+          started_on: ~
>+          ended_on: ~
>+          proxy: ~
>+
>+  - erm_documents:
>+      translatable: [ ]
>+      multiline: [ ]
>+      rows:
>+        - document_id: 1
>+          agreement_id: 1
>+          license_id: ~
>+          file_name: walter-de-gruyter-online-zeits-nutzungsbedingung.pdf
>+          file_type: application/pdf
>+          file_description: De Gruyter Licence
>+          file_content: file_content
>+          uploaded_on: "2022-12-14 15:54:54"
>+          physical_location: Old copies in filing cabinet
>+          uri: https://www.fad.stuba.sk/buxus/docs/kniznica/Slovak_Uni_Technology_Bratislava_GLA_App_1_eBooks_Licence.pdf
>+          notes: Fairly standard licence
>+
>+        - document_id: 2
>+          agreement_id: ~
>+          license_id: 1
>+          file_name: Slovak_Uni_Technology_Bratislava_GLA_App_1_eBooks_Licence.pdf
>+          file_type: application/pdf
>+          file_description: De Gruyter General Licence
>+          file_content: file_content
>+          uploaded_on: "2022-12-14 15:54:54"
>+          physical_location: ~
>+          uri: https://www.fad.stuba.sk/walter-de-gruyter-online-zeits-nutzungsbedingung.pdf
>+          notes: General licence
>\ No newline at end of file
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 33435: 149243 | 149244 | 149248