A Laravel package providing artisan commands to import and export language files from and to CSV.
Installs: 11 226
Open Issues: 0
- php: >=7
- illuminate/support: >=5
- phpoffice/phpspreadsheet: *
- ext-zip: zip exported files
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. In practice, CSV format is supper easy to work with for any translator in Fiverr or for any other freelancer. Personally, I have tried every other format such as php, yaml, docx, pod, txt and all of them has too complex syntax and requires custom software to work with (Not to mention all those problems with file encodings). CSV solves it all! (Now supports xls, xlsx, ods file types too!)
How It Works?
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.
composer require aidask/laravel-lang-import-export
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( /* ... */ 'LangImportExport\LangImportExportServiceProvider' )
The package currently provides two commands, one for exporting the files and one for importing them back:
php artisan lang:export --locale en php artisan lang:export --locale en --target fr,de,pt # export en translations only missing in fr,de,pt locales. Each in separate files php artisan lang:export -l fr,de,pt -z all.zip # archive all the files php artisan lang:export --locale en -g pagination,validation # export only cretain groups php artisan lang:export --locale en --exclude pagination,validation # export all files except pagination and validation php artisan lang:export --locale en --ext xls # supported extensions: Xls, Xlsx, Ods, Csv, Html, Tcpdf, Mpdf, Dompdf
php artisan lang:import es.csv # localed autodetected from file name php artisan lang:import espaniol.csv -l es php artisan lang:import espaniol.csv -l es -g pagination,validation # import only cretain groups php artisan lang:import es.csv -p --html # validate imported translations for missing placeholders and bad html (see below) php artisan lang:import es.xls -p --column-map A,B,D # import translations from different column. E.g. C column was left with base language
php artisan lang:validate ar -m --html -v # find missing keys, bad html and placeholders
You can export package config if you want to set defaults for the commands:
php artisan vendor:publish
- Added support to export to Xls, Xlsx, Ods, Csv, Html, Tcpdf, Mpdf, Dompdf file types
- You can now import translations from a zip file
- Validate HTML feature. Usually HTML tags are translated with random spaces such as "< /b>", which makes entire paragraph bold.
- Added support to import from xls, ods, xlsx, csv file types (PhpOffice integration)
- Validate placeholders feature
- refactor whole repository
- Laravel 5.7 support
- Create new directory, when not exists before
- Fix UTF-8 encoding
- Handling empty keys
- Laravel 5.6 support
- support Package Auto-Discovery
- resolve problems with PSR-4 autoloading
- improved import command
- improved Excel support
- support of LaravelLocalization routes files
- refactor whole repository
- add support for Excel
- add support for export and import all localization files
- any arguments are not required
This package was originally created by UFirst and is available here: Laravel-lang-import-export.
Currently is developed by Aidas Klimas, software house from Lithuania