http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10963
--- Comment #26 from Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> --- Created attachment 23345 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23345&action=edit Bug 10963 - [10] Simplified creation of MARC21 sample frameworks This patch revert original hidden values to the situation before rewriting simple and fast SQL files. Also adds missing 082 fields and subfields to fastadd fw! To test the complete package: (before applying the patch) 1) Delete biblio fw delete from marc_subfield_structure; delete from marc_tag_structure; delete from biblio_framework; 2) Load default and simple fw 3) Search for different hidden values executing this query and save the result on a file (ej. simple-old) "update marc_subfield_structure set frameworkcode = 'AAA' where frameworkcode = ''; select * from (select tagfield,tagsubfield,hidden,group_concat(frameworkcode order by frameworkcode) as fws from marc_subfield_structure group by concat(tagfield,tagsubfield,hidden) having fws <> 'AAA,AR,BKS,CF,IR,KT,SER,SR,VR') as a where fws not like 'AAA%';" 4) Delete biblio fw as in 1) 5) Load default and fastadd 6) Search for different hidden values executing this query and save the result on a file (ej. fast-old) "update marc_subfield_structure set frameworkcode = 'AAA' where frameworkcode = ''; select * from (select tagfield,tagsubfield,hidden,group_concat(frameworkcode order by frameworkcode) as fws from marc_subfield_structure group by concat(tagfield,tagsubfield,hidden) having fws <> 'AAA,FA') as a where fws not like 'AAA%';" 7) Apply the patch (it takes some time, it's large) 8) Repeat 1-2-3) but save on a new file (ej. simple-new) 9) Repeat 4-5-6) but save on a new file (ej. fast-new) 10) Check that que we get the same results diff simple-old simple-new => no lines diff fast-old fast-new => no lines That's all -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
