http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5478 --- Comment #1 from Salva Zaragoza Rubio <salva@masmedios.com> 2011-03-08 11:52:21 UTC --- Created attachment 3261 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3261 Importing/Exporting the marc structure of a specific framework to a spreadsheet Hi, In the attached patch I've added the possibility of importing/exporting the marc structure of a specific framework to a spreadsheet to be shared with other users, to be modified from the spreadsheet or in order to have a backup. The mysql tables exported are marc_tag_structure and marc_subfield_structure. The exporting spreadsheet formats available are XML and ODS (OpenDocument Spreadsheet). The XML format has an Excel 2003 spreadsheet structure, this format can also be opened with OpenOffice/LibreOffice. The first row of the spreadsheet contains the name of the columns of the mysql table, the next rows contain the data. The null values are exported as a # char and imported as a null string. The ODS format can be opened with OpenOffice/LibreOffice and with Excel if you have a plugin to read OpenDocument formats, see http://en.sourceforge.jp/projects/sfnet_odf-converter/. The structure of the rows is analogue to the Excel 2003 xml format. If you modify the spreadsheet and want to import to a framework you must save the spreadsheet as one of the format specified before. When you import the spreadsheet, all the new marc data structure will be inserted, the overlapped one will be updated and the remaining marc structure will be deleted. It uses perl module Archive::Zip or zip/unzip system command to process ODS files. This functionality is implemented in the intranet -> Administration -> MARC Frameworks. The files affected are: new file: C4/ImportExportFramework.pm new file: admin/import_export_framework.pl modified: koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css modified: koha-tmpl/intranet-tmpl/prog/en/modules/admin/biblio_framework.tmpl Let me know if you find it useful and possible modifications. 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.