[Koha-bugs] [Bug 5478] Automate MARC framework import/export

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

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

--- Comment #1 from Salva Zaragoza Rubio <salva at 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.