View | Details | Raw Unified | Return to bug 33435
Collapse All | Expand All

(-)a/installer/data/mysql/en/optional/sample_erm_data.yml (-1 / +356 lines)
Line 0 Link Here
0
- 
1
---
2
#
3
#  Copyright 2023 Koha Development Team
4
#
5
#  This file is part of Koha.
6
#
7
# Koha is free software; you can redistribute it and/or modify it
8
# under the terms of the GNU General Public License as published by
9
# the Free Software Foundation; either version 3 of the License, or
10
# (at your option) any later version.
11
#
12
# Koha is distributed in the hope that it will be useful, but
13
# WITHOUT ANY WARRANTY; without even the implied warranty of
14
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15
# GNU General Public License for more details.
16
#
17
# You should have received a copy of the GNU General Public License
18
# along with Koha; if not, see <http://www.gnu.org/licenses>.
19
20
description:
21
  - "Sample ERM data"
22
23
tables:
24
  - erm_agreements:
25
      translatable: [ ]
26
      multiline: [ description ]
27
      rows:
28
        - agreement_id: 1
29
          vendor_id: ~
30
          name: ACM Digital Library Journals Agreement 2021
31
          description:
32
            - "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."
33
          status: active
34
          closure_reason: ~
35
          is_perpetual: 0
36
          renewal_priority: for_review
37
          license_info: Some general licence notes go here
38
39
        - agreement_id: 2
40
          vendor_id: ~
41
          name: British Periodicals
42
          description:
43
            - "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."
44
          status: active
45
          closure_reason: ~
46
          is_perpetual: 1
47
          renewal_priority: renew
48
          license_info: ~
49
50
        - agreement_id: 3
51
          vendor_id: ~
52
          name: ABI/INFORM Dateline
53
          description:
54
            - "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."
55
          status: closed
56
          closure_reason: cancelled
57
          is_perpetual: 0
58
          renewal_priority: for_review
59
          license_info: ~
60
61
        - agreement_id: 4
62
          vendor_id: ~
63
          name: American Chemical Society Journals Agreement 2019-2021
64
          description:
65
            - "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)."
66
          status: active
67
          closure_reason: ~
68
          is_perpetual: 1
69
          renewal_priority: renew
70
          license_info: ~
71
72
        - agreement_id: 5
73
          vendor_id: ~
74
          name: Journal Archives
75
          description:
76
            - "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."
77
          status: active
78
          closure_reason: ~
79
          is_perpetual: 1
80
          renewal_priority: renew
81
          license_info: ~
82
83
  - erm_agreement_periods:
84
      translatable: [ ]
85
      multiline: [ ]
86
      rows:
87
        - agreement_period_id: 1
88
          agreement_id: 1
89
          started_on: "2022-04-01"
90
          ended_on: "2023-03-31"
91
          cancellation_deadline: "2023-03-31"
92
          notes: ~
93
94
        - agreement_period_id: 2
95
          agreement_id: 1
96
          started_on: "2022-01-01"
97
          ended_on: "2023-03-31"
98
          cancellation_deadline: "2023-01-31"
99
          notes: ~
100
101
        - agreement_period_id: 3
102
          agreement_id: 2
103
          started_on: "2021-01-01"
104
          ended_on: "2024-03-31"
105
          cancellation_deadline: ~
106
          notes: ~
107
108
  - erm_agreement_relationships:
109
      translatable: [ ]
110
      multiline: [ ]
111
      rows:
112
        - agreement_id: 1
113
          related_agreement_id: 2
114
          relationship: is-superseded-by
115
          notes: ~
116
117
        - agreement_id: 2
118
          related_agreement_id: 1
119
          relationship: supersedes
120
          notes: ~
121
122
  - erm_licenses:
123
      translatable: [ ]
124
      multiline: [ description ]
125
      rows:
126
        - license_id: 1
127
          vendor_id: ~
128
          name: ACM Digital Library Licence
129
          description:
130
            - "ACM Digital Library Licence"
131
          type: local
132
          status: active
133
          started_on: "2022-01-01"
134
          ended_on: "2022-12-31"
135
136
        - license_id: 2
137
          vendor_id: ~
138
          name: British Periodicals
139
          description:
140
            - "British Periodicals Licence"
141
          type: local
142
          status: active
143
          started_on: "2022-04-01"
144
          ended_on: "2022-03-31"
145
146
        - license_id: 3
147
          vendor_id: ~
148
          name: OUP Oxford Academic Law Online Products 2021-2023
149
          description:
150
            - "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."
151
          type: local
152
          status: active
153
          started_on: "2022-01-01"
154
          ended_on: "2022-12-31"
155
156
  - erm_agreement_licenses:
157
      translatable: [ ]
158
      multiline: [ ]
159
      rows:
160
        - agreement_license_id: 1
161
          agreement_id: 1
162
          license_id: 1
163
          status: controlling
164
          physical_location: filing_cabinet
165
          notes: ~
166
          uri: ~
167
168
        - agreement_license_id: 2
169
          agreement_id: 2
170
          license_id: 3
171
          status: controlling
172
          physical_location: filing_cabinet
173
          notes: ~
174
          uri: ~
175
176
  - erm_eholdings_packages:
177
      translatable: [ ]
178
      multiline: [ ]
179
      rows:
180
        - package_id: 1
181
          vendor_id: ~
182
          name: Grove Online Packages
183
          external_id: ~
184
          provider: ~
185
          package_type: local
186
          content_type: OnlineReference
187
          notes: ~
188
          created_on: "2022-12-14 16:02:52"
189
190
        - package_id: 2
191
          vendor_id: ~
192
          name: American Chemical Society (NESLi2)
193
          external_id: 37-7824
194
          provider: ebsco
195
          package_type: ~
196
          content_type: ~
197
          notes: 
198
          created_on: "2022-12-14 15:46:25"
199
200
        - package_id: 3
201
          vendor_id: ~
202
          name: British History
203
          external_id: ~
204
          provider: ~
205
          package_type: local
206
          content_type: MixedContent
207
          notes: A collection of local history titles, all coming from one supplier
208
          created_on: "2022-12-14 15:58:18"
209
210
211
212
  - erm_eholdings_packages_agreements:
213
      translatable: [ ]
214
      multiline: [ ]
215
      rows:
216
        - package_id: 1
217
          agreement_id: 1
218
219
        - package_id: 2
220
          agreement_id: 2
221
222
  - erm_eholdings_titles:
223
      translatable: [ ]
224
      multiline: [ ]
225
      rows:
226
        - title_id: 1
227
          biblio_id: ~
228
          publication_title: Aftershocks Politics and Trauma in Britain, 1918-1931
229
          external_id: ~
230
          print_identifier: ~
231
          online_identifier: 9780230582002
232
          date_first_issue_online: ~
233
          num_first_vol_online: ~
234
          num_first_issue_online: ~
235
          date_last_issue_online: ~
236
          num_last_vol_online: ~
237
          num_last_issue_online: ~
238
          title_url: http://www.vlebooks.com/vleweb/product/openreader?id=NationalAr&isbn=9780230582002&uid=^u
239
          first_author: Kent, Susan Kingsley, 1952-
240
          embargo_info: ~
241
          coverage_depth: ~
242
          notes: Includes bibliographical references (p. 218-225) and index
243
          publisher_name: Palgrave MacMillan,
244
          publication_type: ebook
245
          date_monograph_published_print: ~
246
          date_monograph_published_online: ~
247
          monograph_volume: ~
248
          monograph_edition: ~
249
          first_editor: ~
250
          parent_publication_title_id: ~
251
          preceeding_publication_title_id: ~
252
          access_type: ~
253
254
        - title_id: 2
255
          biblio_id: ~
256
          publication_title: An unconsidered people
257
          external_id: ~
258
          print_identifier: 9781848408227
259
          online_identifier: 9781848408227
260
          date_first_issue_online: ~
261
          num_first_vol_online: ~
262
          num_first_issue_online: ~
263
          date_last_issue_online: ~
264
          num_last_vol_online: ~
265
          num_last_issue_online: ~
266
          title_url: ~
267
          first_author: Dunne, Catherine,
268
          embargo_info: ~
269
          coverage_depth: print
270
          notes: ~
271
          publisher_name: ~
272
          publication_type: ~
273
          date_monograph_published_print: ~
274
          date_monograph_published_online: ~
275
          monograph_volume: ~
276
          monograph_edition: ~
277
          first_editor: ~
278
          parent_publication_title_id: ~
279
          preceeding_publication_title_id: ~
280
          access_type: ~
281
282
        - title_id: 3
283
          biblio_id: ~
284
          publication_title: Bibliography of British and Irish History.
285
          external_id: ~
286
          print_identifier: ~
287
          online_identifier: ~
288
          date_first_issue_online: ~
289
          num_first_vol_online: ~
290
          num_first_issue_online: ~
291
          date_last_issue_online: ~
292
          num_last_vol_online: ~
293
          num_last_issue_online: ~
294
          title_url: ~
295
          first_author: ~
296
          embargo_info: ~
297
          coverage_depth: ~
298
          notes: ~
299
          publisher_name: Turnhout Brepolis, 1999-
300
          publication_type: database
301
          date_monograph_published_print: ~
302
          date_monograph_published_online: ~
303
          monograph_volume: ~
304
          monograph_edition: ~
305
          first_editor: ~
306
          parent_publication_title_id: ~
307
          preceeding_publication_title_id: ~
308
          access_type: ~
309
310
  - erm_eholdings_resources:
311
      translatable: [ ]
312
      multiline: [ ]
313
      rows:
314
        - resource_id: 1
315
          title_id: 1
316
          package_id: 1
317
          vendor_id: ~
318
          started_on: "2022-01-01"
319
          ended_on: "2022-12-31"
320
          proxy: ~
321
322
        - resource_id: 2
323
          title_id: 2
324
          package_id: 1
325
          vendor_id: ~
326
          started_on: ~
327
          ended_on: ~
328
          proxy: ~
329
330
  - erm_documents:
331
      translatable: [ ]
332
      multiline: [ ]
333
      rows:
334
        - document_id: 1
335
          agreement_id: 1
336
          license_id: ~
337
          file_name: walter-de-gruyter-online-zeits-nutzungsbedingung.pdf
338
          file_type: application/pdf
339
          file_description: De Gruyter Licence
340
          file_content: file_content
341
          uploaded_on: "2022-12-14 15:54:54"
342
          physical_location: Old copies in filing cabinet
343
          uri: https://www.fad.stuba.sk/buxus/docs/kniznica/Slovak_Uni_Technology_Bratislava_GLA_App_1_eBooks_Licence.pdf
344
          notes: Fairly standard licence
345
346
        - document_id: 2
347
          agreement_id: ~
348
          license_id: 1
349
          file_name: Slovak_Uni_Technology_Bratislava_GLA_App_1_eBooks_Licence.pdf
350
          file_type: application/pdf
351
          file_description: De Gruyter General Licence
352
          file_content: file_content
353
          uploaded_on: "2022-12-14 15:54:54"
354
          physical_location: ~
355
          uri: https://www.fad.stuba.sk/walter-de-gruyter-online-zeits-nutzungsbedingung.pdf
356
          notes: General licence

Return to bug 33435