laravel excel import validation not giving the result

Question

I tried to validate excel rows by using Validator inside Laravel Excel's import class following this laravel excel documentation But it seems the validation result not giving the results

The Controller : (i'm using livewire btw)

public function save()

{
    $this->validate();
    
    try {
        $import = new OutputImport();
        $import->import($this->excel);
    } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
        $failures = $e->failures();

        dd($failures);
    }
}

The Import class :

class OutputImport implements ToCollection, WithStartRow, SkipsEmptyRows
{
    use Importable;

    protected $outputs;
    protected $outputIds;

    public function __construct()
    {
        $this->outputs = Output::where('status',1)->get();
        $this->outputIds = $this->outputs->pluck('id')->toArray();
    }

    public function collection(Collection $rows)
    {
        Validator::make($rows->toArray(), [
            '*.0' => ['required', function(string $attribute, mixed $value, Closure $fail) {
                if (!in_array($value, $this->outputIds))
                    $fail('Periksa dan pastikan kembali ID yang diinput.');     
            }],
            '*.5' => 'required',
            '*.6' => 'required|min:0',
            '*.7' => 'required|min:0',
        ])->validate();
    }

    public function startRow(): int
    {
        return 2;
    }
}

The excel data is there but After the validation execution it giving me no response at all How can i get the validation results ?

dont forget to add use Maatwebsite\Excel\Validators\Failure; — Herrys Aghista Rachman
– Herrys Aghista Rachman, Commented Oct 1, 2023 at 15:39
I suggest reading the docs again: docs.laravel-excel.com/3.1/imports/…. no where on the docs a manual validator instance is created — kris gjika
– kris gjika, Commented Oct 2, 2023 at 9:36
@HerrysAghistaRachman i think it's not a Trait, so its not possible to add "use" in front of the class, if you meant the namespace, i already added it — owf
– owf, Commented Oct 2, 2023 at 11:40
@krisgjika i refer this docs docs.laravel-excel.com/3.1/imports/… section "Row Validation without ToModel" , it says we can use Validator instance — owf
– owf, Commented Oct 2, 2023 at 11:41
@owf do you want the import to fail if a single row fails the validation? or do you want to import only the valid rows? — kris gjika
– kris gjika, Commented Oct 2, 2023 at 12:24

kris gjika · Accepted Answer · 2023-10-03 09:26:29Z

1

Create a validator instance and validate manually without throwing exceptions, via:

$validator = \Illuminate\Support\Facades\Validator::make($rows->toArray(), $rules);
        
if ($validator->fails()) {
  // save messages wherever to access them later from your controller  
  $messages = $validator->errors();
} else {
  // handle your import ...
}

however you can't really "return" these errors from your import, especially if the import in queued. I would recommend storing these errors in a table, or cache depending on how long you intent to store them for, and display them to the user. You could create an Import model to keep track of your imports, if you do many, with fields such as status and errors.

edited Oct 3, 2023 at 9:26

answered Oct 3, 2023 at 8:50

kris gjika

1,5961 gold badge7 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel excel import validation not giving the result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related