kunicmarko/static-translations

This is a Symfony Bundle that helps you to generate translations for static/hardcoded strings from Excel files, thanks to the PHPExcel library

Symfony Static Translations Bundle

This bundle helps you generate translation for static strings in symfony application., _(*1)

, _(*2)

This bundle uses PHPOffice/PHPExcel bundle, _(*3)

PHPExcel bundle Requirements

• PHP version 5.2.0 or higher
• PHP extension php_zip enabled (required if you need PHPExcel to handle .xlsx .ods or .gnumeric files)
• PHP extension php_xml enabled
• PHP extension php_gd2 enabled (optional, but required for exact column width autocalculation)

Installation

1. Add to composer.json to the require key, _(*4)

composer require --dev kunicmarko/static-translations

2. Register the bundle in app/AppKernel.php, _(*5)

if (in_array($this->getEnvironment(), array('dev', 'test'), true)) {
    // ...
    $bundles[] =  new KunicMarko\StaticTranslationsBundle\StaticTranslationsBundle();
}

Command

php app/console generate:static:translations /path/to/excel/file languages, _(*6)

Command accepts 2 parameters, you can run it without parameters and then you get interactive console with help on how to use command, _(*7)

Parameters

1. Excel file, _(*8)

Provide path to your Excel file that has to end with .xlsx, _(*9)

Formating of Excel file ( can also be found here ):, _(*10)

We expect words for translation to start from line 3, _(*11)

You can add more languages, we only expect labels to be at last position, _(*12)

Labels are optional, there can be more than one label for same word, they just have to be divided by comma (,), _(*13)

If you add labels, label names will be used for source tags in xml, _(*14)

If you want to use default language word for source and use labels for same word, you can use reserved word default.language.source and add it in labels part, _(*15)

2. Languages, _(*16)

We expect array of language codes, divided by space e.g. en de fr, use same order as in your excel file., _(*17)

First language in array is source language and will be used for all source tags., _(*18)