Laravel-excel: Using "withValidation" it stops insertion if any validation error occurs. I want it just ignore this validation and jumps to the next iteration

Created on 4 Mar 2019 · 24Comments · Source: Maatwebsite/Laravel-Excel

Prerequisites

Versions

PHP version:
Laravel version:
Package version:

Description

Additional Information

Any additional information, configuration or data that might be necessary to reproduce the issue.

Source

Yousaf3339

All 24 comments

My code

controller function:

public function import(Request $request) 
    {
        try {
            Excel::import(new UsersImport,request()->file('sheet_to_upload'));

            return redirect()->back()->with('success', 'Users Created Successfully!');
        } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
            $import = new UsersImport();
            $import->import(request()->file('sheet_to_upload'));

            foreach ($import->failures() as $failure) {
                 $failure->row(); // row that went wrong
                 $failure->attribute(); // either heading key (if using heading row concern) or column index
                 $failure->errors(); // Actual error messages from Laravel validator
                 $failure->values(); // The values of the row that has failed.
            }
        }
    }

Import class:

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

    public function model(array $row)
    {
            $subscription = SubscriptionTypes::select('id')->where('name',$row['subscription_plan'])->first();
            $client_type = ClientTypes::select('id')->where('name',$row['user_type'])->first();


            if($subscription != null && $client_type != null){
                $user = Users::create([
                    'is_admin'              => 0,
                    'client_type_id'        => $client_type->id,
                    'subscription_id'       => $subscription->id,
                    'user_name'             => $row['user_name'],
                    'email'                 => $row['user_e_mail'],
                    'is_blocked'            => 0,
                    'password'              => Hash::make($row['password']),
                    'first_name'            => $row['user_first_name'],
                    'last_name'             => $row['user_last_name'],
                    'phone'                 => $row['phone'],
                    'notes'                 => $row['notes_for_internal_use'],
                    'created_by'            => Auth::user()->id,
                    'updated_by'            => Auth::user()->id,
                    'created_at'            => '',
                    'updated_at'            => '',
                    'license'               => $row['licenseorganization'],
                    'owg_invoice'           => $row['owg_invoice'],
                    'self_notification'     => $row['multi_site_initiative'] == 'Yes' ? 1 : 0,
                    'is_group_admin'        => 0,
                    'renewal_notification'  => 0

                ]);

                $country = Countries::select('id')->where('name',$row['country'])->first();
                if($country != null){
                    Addresses::create([
                        'user_id'           => $user->id,
                        'country'           => $country->name,
                        'city'              => $row['city'],
                        'state'             => $row['state'],
                        'street'            => $row['street_address'],
                        'zip'               => $row['zipcode'],
                        'organization_name' => $row['schoolcenterorg_name']

                    ]);
                }


                GroupAdmins::create([
                    'first_name'   => $row['admincooridnator_first_name'],
                    'last_name'    => $row['admincooridnator_last_name'],
                    'phone_number' => $row['admincooridnator_phone'],
                    'email'        => $row['admincooridnator_e_mail_address']
                ]);

                Subscriptions::create([
                    'user_id'              => $user->id,
                    'subscription_type_id' => $subscription->id
                ]);

                return $user;
            }
    }

    public function rules(): array
    {
        $packages = SubscriptionTypes::pluck('name');
        return [
            '*.license'     => 'numeric',
            '*.user_name'  => 'required|unique:users',
            '*.user_e_mail' => 'required|email|unique:users,email',
            '*.phone' => 'numeric',
            '*.subscription_plan' => Rule::in($packages)
        ];
    }

    public function customValidationMessages()
    {
        return [
            'subscription_plan.in' => 'this subscription plan does not exist',
        ];
    }

Yousaf3339 on 4 Mar 2019

See the documentation about skipping failures: https://docs.laravel-excel.com/3.1/imports/validation.html#skipping-failures . You need to add the SkipsOnFailure concern.