Laravel-Lang-Import-Export

This package provides artisan commands to import and export language files from and to CSV. This can be used to send translations to agencies that normally work with Excel-like files.

It turns some navigation.php file...

<?php

return array (
  'commands' =>
  array (
    'next' => 'Next',
    'prev' => 'Previous',
    'play' => 'Play',
  ),
  'tips' =>
  array (
    'next' => 'Navigate to the next item',
    'prev' => 'Navigate to the previous item',
    'play' => 'Autoplay the slide show',
  ),
);

...to the following CSV...

navigation.commands.next,Next
navigation.commands.prev,Previous
navigation.commands.play,Play
navigation.tips.next,"Navigate to the next item"
navigation.tips.prev,"Navigate to the previous item"
navigation.tips.play,"Autoplay the slide show"

...and vice versa.

Installation

Add the following line to the require section of your Laravel webapp's composer.json file:

    "require": {
        "HighSolutions/laravel-lang-import-export": "5.4.*"
    }

Run composer update to install the package.

This package uses Laravel 5.5 Package Auto-Discovery. For previous versions of Laravel, you need to update config/app.php by adding an entry for the service provider:

    'providers' => array(
        /* ... */
        'HighSolutions\LangImportExport\LangImportExportServiceProvider'
    )

Usage

The package currently provides two commands, one for exporting the files and one for importing them back:

Export

php artisan lang:export
php artisan lang:export en * path/to/export
php artisan lang:export en auth -A -X

When you call command without parameters, export file will be generated for all localization files within default locale. But you can define locale explicitly. You can also export only one file (second parameter - group) and define where to store file (you can provide name with and without .csv extension). When you use output argument, default path is base_path() -> catalog of your whole project. But there is few more useful parameters:

| name of parameter | description | is required? | default value | |-------------------|-----------------------------------------|--------------|------------------------------------| | locale | The locale to be exported | NO | default lang of application | | group | The name of translation file to export | NO | * - all files | | output | Filename of exported translation files | NO | storage/app/lang-import-export.csv | | -A / --append | Append name of group to the name of file | NO | empty | | -X / --excel | Set file encoding (UTF-16) for Excel | NO | UTF-8 | | -D / --delimiter | Field delimiter | NO | , | | -E / --enclosure | Field enclosure | NO | " |

Import

php artisan lang:import
php artisan lang:import en * path/to/import
php artisan lang:import en auth -X

When you call command without parameters - it will try to read default file of export command without parameters for default locale and all localization files. You can of course specify all parameters (locale, group, input) and there is few more options:

| name of parameter | description | is required? | default value | |-------------------|----------------------------------------------|--------------|------------------------------------| | locale | The locale to be imported | NO | default lang of application | | group | The name of translation file to import | NO | * - all files | | output | Filename of translation files to be imported | NO | storage/app/lang-import-export.csv | | -X / --excel | Set file encoding from Excel | NO | UTF-8 | | -D / --delimiter | Field delimiter | NO | , | | -E / --enclosure | Field enclosure | NO | " | | -C / --escape | Field escape | NO | \ |

Changelog

5.4.10

• Laravel 5.7 support

5.4.9

• Create new directory, when not exists before

5.4.8

• Fix UTF-8 encoding

5.4.7

• Handling empty keys

5.4.6

• Laravel 5.6 support

5.4.3

• support Package Auto-Discovery

5.4.2

• resolve problems with PSR-4 autoloading

5.4.1

• improved import command
• improved Excel support
• support of LaravelLocalization routes files

5.4.0

• refactor whole repository
• add support for Excel
• add support for export and import all localization files
• any arguments are not required

Roadmap

• Removing tabs from text
• Option for deleting export file after importing.
• Option for excluding certain files (and system ones).
• Unit tests!

Credits

This package was originally created by UFirst and is available here: Laravel-lang-import-export.

Currently is developed by HighSolutions, software house from Poland in love in Laravel.