[Koha-bugs] [Bug 10963] Simplified creation of MARC21 sample frameworks

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10963

--- Comment #68 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
(In reply to Jonathan Druart from comment #67)
> 
> There is a lof of changes, is it expected?

Yes.
The purpose of the patch is to have a the same number of fields/subfields on
all frameworks. I'm only updating MARC21 default, and cait always asks what to
do with the others.

Before patch we have

select a.frameworkcode, a.tag, b.subfield  from (select frameworkcode, count(*)
as tag from marc_tag_structure group by frameworkcode) a left join (select
frameworkcode, count(*) as subfield from marc_subfield_structure group by
frameworkcode) b on a.frameworkcode = b.frameworkcode;
+---------------+-----+----------+
| frameworkcode | tag | subfield |
+---------------+-----+----------+
|               | 340 |     3978 |
| AR            | 313 |     3620 |
| BKS           | 313 |     3620 |
| CF            | 313 |     3620 |
| FA            |  17 |      118 |
| IR            | 313 |     3619 |
| KT            | 313 |     3620 |
| SER           | 313 |     3619 |
| SR            | 313 |     3620 |
| VR            | 313 |     3620 |
+---------------+-----+----------+
(There is a 'bug' on simple fw file, fixed here, 
on line 10399, fw code is incorrect 'SF' -> 'SR')

After patch
+---------------+-----+----------+
| frameworkcode | tag | subfield |
+---------------+-----+----------+
|               | 340 |     3978 |
| AR            | 340 |     3978 |
| BKS           | 340 |     3978 |
| CF            | 340 |     3978 |
| FA            |  18 |      173 |
| IR            | 340 |     3978 |
| KT            | 340 |     3978 |
| SER           | 340 |     3978 |
| SR            | 340 |     3978 |
| VR            | 340 |     3978 |
+---------------+-----+----------+

So yes, you will see differences.
All new (by me) fields/subfields have hidden = -6, they don't show on 'new' fw.

-- 
You are receiving this mail because:
You are watching all bug changes.