Imported data doesn't get to the database

[felixkwasisarpong]

The upload is suppose to throw errors and insert valid rows into the database,but it throws the errors without inserting the valid rows.

Environment

maatwebsite/excel verrsion:3.1
PHP Version: 8.0

Below is the model

<?php

namespace App\Imports;

use App\Customers;
use Auth;
use App\errors;
use App\Customer;
use App\histcustomer;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Support\Collection;
use Illuminate\Validation\Rule; 
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\RegistersEventListeners;
use Maatwebsite\Excel\Concerns\SkipsErrors;
use Maatwebsite\Excel\Concerns\SkipsFailures;
use Maatwebsite\Excel\Concerns\SkipsOnError;
use Maatwebsite\Excel\Concerns\SkipsOnFailure;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithBatchInserts;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Events\AfterImport;
use Maatwebsite\Excel\Validators\Failure;
use Throwable;
use Log;
use App\Export\FailuresExport;

class CustomersImport implements 
ToModel,
WithHeadingRow,
SkipsOnError,
WithValidation,
WithBatchInserts,
SkipsOnFailure,
WithChunkReading,
WithEvents

{

    use Importable,SkipsFailures, SkipsErrors,RegistersEventListeners;

    private $data = [];
    private $rows = 0;
    private $name="";
   

    
   

    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        ++$this->rows;
        $user=Auth::user();
       
           return new histcustomer([
                'maker_id'=>    $user->id,
                'cus_name'=>    $row['cus_name'],
                'cus_dob'=>     $row['cus_dob'],
                'cus_cat'=>     $row['cus_cat'],
                'cau_cat'=>     $row['cau_cat'],
                'ou'=>      $user->ou,
                'cus_idtype'=>  $row['cus_idtype'],
                'cus_idnum'=>   $row['cus_idnum'],
                'cus_type'   => $row['cus_type'],
                'listtype_id'=> $row['listtype_id'],
                'status'     =>          1,

            ]);
        
    } 

    public function getRowCount(): int
    {
        return $this->rows;
    }
    
    public function rules(): array
    {
        return [
      'cus_name' => 'bail|required|string|max:255',
      'cau_cat' => 'required|integer|max:4',
      'cus_cat' => 'nullable|integer|between:999,10000',
      'cus_idnum' =>  'required',
      'cus_idtype' => 'required|integer|max:16',
      'cus_type' => 'nullable|integer|max:4',
      'listtype_id' =>'required|integer|max:4',
      'cus_dob' => 'required|date|date_format:Y-m-d',
        ];
    }

    public function customValidationMessages()
{
    return [
        'cus_name' =>' Field is Required ',
        'cau_cat' => 'Caution Category must not be greater than 4',
        'cus_cat' => 'Customer Category must be between 999 and 4003',
        'cus_idnum' =>  'Field is Required',
        'cus_idtype' => ' Identification Type must be between 999 and 4003',
        'cus_type' => 'Customer Type must not be greater than 4',
        'listtype_id' =>'List Type must not be greater than 4',
        'cus_dob' => 'field must be in the format:Y-m-d',
    ];
}
    public function chunkSize(): int
    {
        return 1000;
    }

    public static function afterImport(AfterImport $event)
    {

      
    }

    public function batchSize(): int
    {
        return 1000;
    }
   
    // public function onFailure(Failure ...$failures) 
    // {
    //    return $failures;
    // }
    
    
}

The controller

 public function import(Request $request)
    {
        $msg = "";
        $data = [];
        $request->validate([
            'file' => "required|mimes:csv,txt",
        ]);

        $file = $request->file('file')->store('import');
        $import = new CustomersImport();
        $import->import($file);
        $done = $import->getRowCount();
        $failures = $import->failures();

        if (!count($failures)) {

            $msg = "Upload Completed Successfully.";
            emotify('success', $msg);
            return back();
        } else {
            foreach ($failures as $error) {
                foreach ($error->errors() as $item) {
                    $data[] = [
                        $error->row(),
                        $item,
                        $error->attribute(),
                        $error->values()[$error->attribute()],

                    ];
                }
            }
            $id = uniqid();
            $name = 'failure' . $id . '.xlsx';
            \Excel::store(new FailuresExport($data), $name, 'export');
            $msg = "Upload Completed,$done uploaded successfully.Click the download icon to download the errors";
            emotify('success', $msg);
            return back()->with('failures', $name);
        }

        // logger($name);

    }

The date format in excel is yyyy-mm-dd

[patrickbrouwers]

Please share your entire import class, the relevant parts are missing

[felixkwasisarpong]

Model updated

[patrickbrouwers]

Depends what the error is. If the error is that it can't insert the model into the database, then that's the reason why. Please check the import errors too if you are using SkipsErrors, as that's something different than skips failures (which is only validation errors)