Bug 24274

Summary: New installations should not contain field 01e Coded field error (RLIN)
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: MARC Bibliographic data supportAssignee: Marcel de Rooy <m.de.rooy>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: 1joynelson, lucas, magnus, tomascohen
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21172
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
20.05.00, 19.11.02
Bug Depends on:    
Bug Blocks: 34847    
Attachments: Bug 24274: Remove field 01e from sql installer files
Bug 24274: Remove field 01e from sql installer files
Bug 24274: Remove field 01e from sql installer files
Bug 24274: Remove field 01e from sql installer files

Description Marcel de Rooy 2019-12-19 10:35:58 UTC
Field 01e comes from the RLIN utility. It is not a standard MARC21 field.
Previously, it triggered the warning (in addbiblio.pl)
  Argument "01e" isn't numeric in numeric ne (!=)
This warning was addressed on bug 21172.
It is the only non-numeric field tag in Koha; and it does not belong there. We should remove it.

This report only deals with new installations. So it fixes the SQL installer files. It does NOT include a database revision for existing installations. You never know if someone used the field somehow ;)

See also (question of Magnus in 2009! goto 09:55 hours):
http://irc.koha-community.org/koha/2009-06-18
Comment 1 Marcel de Rooy 2019-12-19 10:39:25 UTC Comment hidden (obsolete)
Comment 2 Marcel de Rooy 2019-12-19 10:56:04 UTC
Created attachment 96481 [details] [review]
Bug 24274: Remove field 01e from sql installer files

Field 01e comes from an older utility (RLIN) and does not belong here.
Note: It is the only non-numeric field tag in Koha. And it seems to be
an violation of the MARC standard.

Test plan:
Run a new install and check the bibliographic frameworks.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 3 Tomás Cohen Arazi 2019-12-19 12:46:56 UTC
Created attachment 96483 [details] [review]
Bug 24274: Remove field 01e from sql installer files

Field 01e comes from an older utility (RLIN) and does not belong here.
Note: It is the only non-numeric field tag in Koha. And it seems to be
an violation of the MARC standard.

Test plan:
Run a new install and check the bibliographic frameworks.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Comment 4 Katrin Fischer 2019-12-22 12:06:27 UTC
Created attachment 96568 [details] [review]
Bug 24274: Remove field 01e from sql installer files

Field 01e comes from an older utility (RLIN) and does not belong here.
Note: It is the only non-numeric field tag in Koha. And it seems to be
an violation of the MARC standard.

Test plan:
Run a new install and check the bibliographic frameworks.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Comment 5 Martin Renvoize 2019-12-23 12:09:36 UTC
Nice work everyone!

Pushed to master for 20.05
Comment 6 Joy Nelson 2020-01-12 19:04:12 UTC
Pushed to 19.11.x branch for 19.11.02
Comment 7 Lucas Gass 2020-01-13 23:16:28 UTC
backported to 19.05.x for 19.05.07