http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4888 --- Comment #6 from Salva Zaragoza Rubio <salva@masmedios.com> 2011-02-09 16:04:23 UTC --- Created attachment 3113 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3113 Patches compressed on zip format Hi, I want to inform that the patches for this bug are ready to be sent and tested. There are two patches, the first one to deal with the change of version (from 3.0300018 to 3.03.00.019, I will have to adjust it as time goes by and the versions change before this patch is applied) and the install/upgrade of the database; the second one to add the functionality through "pm", "pl", "tmpl" and "js" files. As I have to incorporate the values for the indicators as defined on http://www.loc.gov/marc/bibliographic/ecbdhome.html for MARC 21 to each framework given on the installation, there's a considerable amount of data in the first patch (1257 KB). I would like to know whether I have to send the patch to the koha-patches list on raw format or I could send it compressed as zip. I don't know how you have dealt with this situation before and the correct way to proceed. Anyway I attach them as a zip to this bug. There's a link to a pdf showing a demo of the functionality on a former comment in this bug. Tables added in mysql: marc_indicators (id of a indicator on a framework and field) , marc_indicators_values (values allowed for the indicators), marc_indicators_value (values of the indicators for a field), marc_indicators_desc (description of a value for a language) The files added/changed (* => changed , + => added): Patch: 0001-Bug-4888-Add-funtionality-for-indicators-Databas.patch * kohaversion.pl: as there are changes in the database an upgrade of version is needed. * installer/data/mysql/updatedatabase.pl: making the upgrade in the database. The normal procedure is execute the "do" method of the database conex object, but with the amount of data involved to store in the database I think it's more optimum to make a dump form the file marc21_indicators.sql to the database through command shell. * installer/data/mysql/kohastructure.sql: added structure for the indicators on a new installation. * installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql: added data for the indicators on a new installation. + installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_indicators.sql: a sql file with all the changes in the database, is called from installer/data/mysql/updatedatabase.pl. * installer/data/mysql/en/mandatory/sysprefs.sql: add two new system preferences to control the display of plugin indicators and to check the validity of its values. Patch 0002-Bug-4888-Add-funtionality-for-indicators-Intrane.patch + C4/Indicators.pm: It includes all the methods for accessing the data from the database and utility functions. * admin/marctagstructure.pl: to clone indicators from a framework to another one and to delete them. + admin/marc_indicators_structure.pl: to add/edit/delete indicators belonging to a marc field. * cataloguing/addbiblio.pl: to check validity of indicators and add them to a record. + cataloguing/indicators_ajax.pl: to ask for the indicators values of a framework and send them through a xml stream. + cataloguing/marc21_indicators.pl: plugin functionality, show and check indicators for a marc field. + koha-tmpl/intranet-tmpl/prog/en/js/indicators.js: all javascript functionality: ajax, checking... + koha-tmpl/intranet-tmpl/prog/en/modules/admin/marc_indicators_structure.tmpl: template for marc_indicators_structure.pl * koha-tmpl/intranet-tmpl/prog/en/modules/admin/marctagstructure.tmpl: template for marctagstructure.pl * koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref: add system preferences * koha-tmpl/intranet-tmpl/prog/en/modules/admin/addbiblio.tmpl: template for addbiblio.pl + koha-tmpl/intranet-tmpl/prog/en/modules/admin/marc21_indicators.tmpl: template for marc21_indicators.pl Regards Salva -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.