Duplicate value remove in excel import

[hirenpatel1903]

Hello Gys, i hope you're good
i've one question about this anyone idea about how to remove duplicate value in when import csv

Examplle :-

namespace App\Imports;

use App\Models\UploadNewsModule;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithValidation;

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

/**
* @param array $row
*
* @return \Illuminate\Database\Eloquent\Model|null
*/
public function model(array $row)
{
    return new UploadNewsModule([
        'program_name' => $row['program_name'],
        'genre' => $row['genre'],
        'date' => $row['date'],
        'time' => $row['time'],
        'duration' => $row['duration'],
        'description' => $row['description'],
        'episodeno' => $row['episodeno'],
        'show_wise_description' => $row['show_wise_description']
    ]);
}

public function rules(): array
{
    return [
        'program_name' => \Illuminate\Validation\Rule::unique('upload_news_module','program_name'),
    ];
}

}**

Thanks Advance, Anyone idea please share here.

[hirenpatel1903]

use str_slug , problem solved 👍👍👍👍👍👍

namespace App\Imports;

use App\Models\UploadNewsModule;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\Importable;

class ImportNewsUpload implements ToModel, WithHeadingRow
{
use Importable;

/**
* @param array $row
*
* @return \Illuminate\Database\Eloquent\Model|null
*/
public function model(array $data)
{
    foreach($data as $row) {
        $slug = str_slug($data['program_name']);
        $datas = UploadNewsModule::where('slug',$slug)->first();
        if (empty($datas)) {
            return new UploadNewsModule([
                'slug' => $slug,
                'program_name' => $data['program_name'],
                'genre' => $data['genre'],
                'date' => $data['date'],
                'time' => $data['time'],
                'duration' => $data['duration'],
                'description' => $data['description'],
                'episodeno' => $data['episodeno'],
                'show_wise_description' => $data['show_wise_description']
            ]);
        }
    }
}

}

[Pushkraj19]

This method will not work on batch and chunk