Laravel Livewire using Laravel Excel, when error not rolling back import.

[kgcusi]

I'm using the maatwebsite/Laravel-Excel package for importing, the problem I'm facing is the import is not rolling back when it receives an error.

For example

Column1 Column2
________________________
1      | Employee Code (Header)
2      | // Validated no error
3      | // Validated no error
4      | // Receives error

What happens is the import saves the row 2 and 3 into the database but it should be rolling back when it receives an error. I don't seem to understand but shouldn't it be default that when it receives an error it rollsback the import and doesn't save anything??

This is my import file.

class PayrollImportsImport implements ToModel, WithValidation, WithHeadingRow
{
    use Importable;

    /**
     * @param array $row
     *
     * @return PayrollImport|null
     */
    public function model(array $row)
    {   
        return new PayrollImport([
            //Normal Day
           'nd_lates'     => $row['nd_lates'],
           'nd_undertime'    => $row['nd_undertime'], 
           'nd_absent' => $row['nd_absent'],
           'nd_lwp' => $row['nd_lwp'],
           'nd_ot' => $row['nd_ot'],
           'nd_nsd' => $row['nd_nsd'],
           //Rest Day
           'rd_duration' => $row['rd_duration'],
           'rd_ot' => $row['rd_ot'],
           'rd_nsd' => $row['rd_nsd'],
           //Special Non-Working Day
           'snwd_duration' => $row['snwd_duration'],
           'snwd_ot' => $row['snwd_ot'],
           'snwd_nsd' => $row['snwd_nsd'],
           //Special Non-Working Day and Rest Day
           'snwd_rd_duration' => $row['snwd_rd_duration'],
           'snwd_rd_ot' => $row['snwd_rd_ot'],
           'snwd_rd_nsd' => $row['snwd_rd_nsd'],
           //Regular Holiday
           'rh_duration' => $row['rh_duration'],
           'rh_ot' => $row['rh_ot'],
           'rh_nsd' => $row['rh_nsd'],
           //Regular Holiday and Rest Day
           'rh_rd_duration' => $row['rh_rd_duration'],
           'rh_rd_ot' => $row['rh_rd_ot'],
           'rh_rd_nsd' => $row['rh_rd_nsd'],
           //Others
           'employee_number' => $row['employee_code'],
           'cutoff_id' => $row['cutoff_name'],
           'createdby_id' => Auth::id(),
           'company_id' => Auth::user()->company_id,
        ]);
    }

    public function rules(): array
    {
        return [
            '*.employee_code' => 'required|exists:employee_information,employee_number',
        ];
    }
}

I'm using CSV as my format on import.

[patrickbrouwers]

Do you have https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L278 still set to db?

[kgcusi]

Yes, I haven't changed anything, I changed my code to SkipsOnFailure to collect all the validation errors, is there still anyway to rollback if I used this since the documentation indicated that it doesnt rollback when using this.

[patrickbrouwers]

If you use SkipsOnFailure it won't rollback anything. You can always try to put your own transaction around it with DB::transaction

[kgcusi]

Okay, thank you very much.