Bug 13897 - Use XML files for installer data
Summary: Use XML files for installer data
Status: In Discussion
Alias: None
Product: Koha
Classification: Unclassified
Component: I18N/L10N (show other bugs)
Version: master
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bernardo Gonzalez Kriegel
QA Contact: Testopia
URL:
Keywords:
Depends on: 7939 10963 13322
Blocks:
  Show dependency treegraph
 
Reported: 2015-03-24 00:40 UTC by Bernardo Gonzalez Kriegel
Modified: 2019-02-28 13:09 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 13897 Patchset (168.85 KB, application/x-bzip)
2015-03-24 01:46 UTC, Bernardo Gonzalez Kriegel
Details
Bug 13897: C4/Installer.pm - process XML files (2.20 KB, patch)
2018-06-08 17:08 UTC, Bernardo Gonzalez Kriegel
Details | Diff | Splinter Review
Bug 13897: Split auth framework into xml and sql files (38.90 KB, application/gzip)
2018-06-08 17:12 UTC, Bernardo Gonzalez Kriegel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bernardo Gonzalez Kriegel 2015-03-24 00:40:32 UTC
Installer data on main/marc21/unimarc SQL files is difficult to translate and is prone to get off-sync with english original

As a way to overcome this problem, I propose to use XML files from which corresponding SQL and TXT files could be created. 

XML files can be translated in the usual way, and all installer data can be created/translated before install time.

There will be no need to preserve language folders, except some particular cases (e.g. NORMARC)

An agreement will be needed for a superset of the all sample data on different language folders
Comment 1 Bernardo Gonzalez Kriegel 2015-03-24 00:51:50 UTC
I'll make this enh dependent on 7939 10963 13322.

Bug 7939 modifies LangInstaller.pm
Bug 10963 rewrites MARC21 sample bib frameworks, no need to translate them
Bug 13322 updates MARC21 default bib framework

All signed ATM
Comment 2 Bernardo Gonzalez Kriegel 2015-03-24 01:46:30 UTC
Created attachment 37165 [details]
Bug 13897 Patchset

Test implementation patchset
Only cover mysql mandatory/optional and marc21 mandatory, just as example
Comment 3 Zeno Tajoli 2015-03-25 09:55:26 UTC
Bernardo, can you describe 'the usual way' to transalte  XML files ?
Do you plan to use a .po file ?
Comment 4 Bernardo Gonzalez Kriegel 2015-03-25 13:09:13 UTC
(In reply to Zeno Tajoli from comment #3)
> Bernardo, can you describe 'the usual way' to transalte  XML files ?
> Do you plan to use a .po file ?

Yes, sorry, the plan is to use .po files-

In the patchset I introduce an XML file for each SQL one in common mandatory/optional and MARC21 mandatory, soon I'll provide for marc21 optional and hopefully UNIMARC.

I add mysql folders as targets to translation script, so new .po files are build from XML files, and when we use the translation script it copy all sql folders and rebuild sql and txt files from translated xml files, to allow an install with translated values.
Comment 5 Zeno Tajoli 2015-03-25 14:33:10 UTC
I suggest to put .po file in a different git server, to limit the growth of general git archive.
Comment 6 Bernardo Gonzalez Kriegel 2018-06-08 17:08:26 UTC
Created attachment 75930 [details] [review]
Bug 13897: C4/Installer.pm - process XML files

This patch modifies C4/Installer.pm to add support
for processing of XML files into database.
For MySQL only
Comment 7 Bernardo Gonzalez Kriegel 2018-06-08 17:12:40 UTC
Created attachment 75931 [details]
Bug 13897: Split auth framework into xml and sql files

Bug 13897: Split auth framework into xml and sql files
  
This patch split authorities_normal_marc21.sql contents
between three XML files and a remanent SQL file

GZIP file of patch, it's too large