how to receive failures on a chain job in queue

[farshadff]

hi all , i am trying to import a file in queue and validate the rows , on fails i want to capture the errors and email the rows to the user . when i use it out of queue like below :

      $import = new OrderFileImport($request->except('file'),Auth::user());
        $fileName = uniqid().'.xlsx';
        $request->file('file')->move(storage_path('/excels'),$fileName);
        $import->Sheets('Sheet1');
       Excel::Import($import,storage_path('excels/'.$fileName));
       dd($import->failures());

i can see and capture the failures() from import but when i place it in queue like below :

  ($import)->queue(storage_path('excels/'.$fileName))->chain([
        new NotifyUserOfErrorsImport(Auth::user(),$import->failures())
   ]);

the $import->failures() is always empty i tried like this too :

  ($import)->queue(storage_path('excels/'.$fileName));
   new NotifyUserOfErrorsImport(Auth::user(),$import->failures());

but again i get the same result and its empty .

[patrickbrouwers]

Because it's a queued job, you can't access the failures in the controller. You have to use the failed event, and stored it somewhere like a cache and then retrieve it in your chained job

[patrickbrouwers]

In which class did you add this event

[farshadff]

In which class did you add this event

in my firstSheetImport.php

[patrickbrouwers]

this event is only available on the import itself, not the sheet

[farshadff]

thanks alot for helping and answering quick in your github , the last question is that am i using the right class to capture the validation failures ? because i saw some ValidationException class too and tbh i tried with both and got no log . and if there is any documentation about that , that you can refer me i would be very thankful . thanks again for the help

[patrickbrouwers]

I believe ImportFailed event is always triggered as long as you don't use skipsonfailures