I. Introduction
- As the title of this article, this time I will show you how to do import csv via Laravel Excel
- This problem I encountered and took a few days, because when using this package, according to research, only set one encoding right (spicy), when setting this QA, use another to import, then to the customer … I told them they can only use one? So that’s not possible ….
- The excel.php config file of Laravel Excel has an attribute of
input_encoding, hereLaravel Excelhas the defaultUTF-8encoding.
- But in Japan they often use Shift-JIS (or also others like UJIS, ANSI …)
- As usual, of course, I also set SJIS to the above config, everything works fine for a few days, then the guests use files with other encoding. : v
II. Problem solving.
After a few times, I was too lucky to think that I would detect the encoding format, they would use Turkish, Greek … until teencode I could do it, too, through simple thought. And yet also found a way 
And here is my workaround
1 2 3 4 5 6 7 | function setInputEncoding($file) { $fileContent = file_get_contents($file->path()); $enc = mb_detect_encoding($fileContent, mb_list_encodings(), true); Config::set('excel.imports.csv.input_encoding', $enc); } |
Meaning:
- Line 1: function
file_get_contentswill read the contents of the file. - Line 2: function
mb_detect_encodingwill dectect encoding based on mb_list_encodings and return the encoding of the uploaded file - Line 3: will interfere with the config at that time – ie n will change r after performing the function will return to the same way (other than overwriting the file).
III. Upload the file
- I want to share what I find out so it looks a bit short ) so I will guide how to upload files as well.
- This package is very nice in that it has made chunk files for me, so it has also limited the reading of heavy files (You should use)
) so I will guide how to upload files as well.- Controller
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | public function upload(UploadRequest $request) { try { $inputs = $request->all(); setInputEncoding($inputs['file']); Excel::import(new ModelImport, $inputs['file']); return redirect()->back()->with('success', 'Upload File Thành Công'); } catch (MaatwebsiteExcelValidatorsValidationException $e) { $failures = $e->failures(); return redirect()->back()->with('failures', $failures); } } |
- The setInputEncoding function will be run before Excel’s Laravel can read the uploaded file.
- Here if you do not use the queue but want to display a validate error during import then do as you would the catche section.
- File Import
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | <?php namespace AppImports; use IlluminateContractsQueueShouldQueue; use MaatwebsiteExcelConcernsWithStartRow; use IlluminateSupportFacadesDB; use IlluminateSupportFacadesLog; use MaatwebsiteExcelConcernsToModel; use MaatwebsiteExcelConcernsImportable; use MaatwebsiteExcelConcernsWithChunkReading; use MaatwebsiteExcelConcernsWithValidation; use IlluminateSupportFacadesValidator; use AppModelsModel; class ModelImport implements ToModel, WithChunkReading, WithStartRow, WithValidation { use Importable; /** * @var row */ private $row = 1; public function model(array $row) { Model::create([ 'name' => $row[0], ]); } public function rules(): array { return [ '0' => [ 'required', 'string', ], ]; } public function chunkSize(): int { return 1000; } public function startRow(): int { return 2; } } |
- Here I do not use queue, but if you use queue then if validated error can be taken from database (queue database) …. or use other types of queue.
- The
chunkSizefunction I found very beneficial in this package, it is really necessary if any project saves k queue usage (like my project =))).
III. Finished
- Above is how I work when importing csv, with the encoding that is not really many users and popular. Hope to help you who are having problems like me
- Another small problem that can occur while uploading is that I use ubuntu when creating the csv file and sending it to the guest (using the window), it may fall into the case that the computer automatically changes the file’s extension (csv – > xls) so you can also note this problem when validating the bared file (lol)