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": "^6.0"
    }

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

6.3.0

• Support Laravel 11.x

6.2.0

• Support Laravel 9.x and 10.x

6.1.0

• Support Laravel 7.x and 8.x

6.0.0

• Support Laravel 6.0

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.