How i can set custom headers in import function

[PhHitachi]

Hi,

i want to ask a question if we're possible to add headers and pass on model,

as you can see, the CSV file haven't headers by default. I tried headings() function but not working on import function, I want to add headers on this to use rules function.

<?php

namespace App\Imports;

use Thorwable;
use App\User;
use Illuminate\Support\Collection;
use Illuminate\Validation\Rule;
use Maatwebsite\Excel\Concerns\{
	ToModel,
	Importable,
	ToCollection,
	SkipsOnError,
	WithHeadings,
	WithHeadingRow,
	WithValidation,
};

class UsersImport implements ToModel, WithHeadings//, WithHeadingRow//, WithValidation
{
	public $user;

	use Importable;

    public function __construct()
    {
    	$this->user =  new User;
    }

    public function getAll($data = null)
    {
        if(count($data) == 5) 
        {
            return [
                'id'    => $data[0],
                'lname' => $data[1],
                'fname' => $data[2],
                'mname' => $data[3],
                'bday'  => $data[4],
            ];

        }else{
            if (!notify::hasMessages()) {
                notify::danger('Please, make sure your file is correct');
            }
        }
    }

    public function headings(): array
	{
        return [
            'id',
            'lname',
            'fname',
            'mname',
            'bday',
        ];
    }

    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        dd($row['id']);
    }

    /*public function collection(Collection $rows)
    {
        foreach ($rows as $row) 
        {
        	$data = $this->getAll($row);
        	
        	User::firstOrCrate([
        		'id' => $data['id']
        	],[
	            'lname' => $data['lname'],
	            'fname' => $data['fname'],
	            'mname' => $data['mname'],
	            'bday' =>  $data['bday'],
	            'password' =>  $this->makePassword($data),
	        ]);

        }
    }*/

    public function rules(): array
    {
        return [
        	'id'  => 'required|string|max:10',
        	'lname' => 'required|string|max:20',
        	'fname' => 'required|string|max:20',
        	'mname' => 'string|max:20',
        	'bday'  => 'required|string|max:10',
        ];
    }

    public function onError(Thorwable $error)
    {
        //
    }

    public function getFistLetter($str)
    {
        $str = preg_replace('/\s/', '', $str);
        return ucfirst($str[0]);
    }

    public function getDate($date)
    {   
        $time = strtotime($date);
        $date = date('m/d/Y', $time);
        $data = explode('/', $date);
        $year = substr($data[2], -2);
        $bday = [$data[0], $data[1], $year];
        return join("", $bday);
    }

    public function makePassword($data)
    {
        $bday  = $this->getDate($data['bday']        ?? $this->bday);
        $fname = $this->getFistLetter($data['fname'] ?? $this->fname);
        $lname = $this->getFistLetter($data['lname'] ?? $this->lname);
        
        return bcrypt(join("", [$bday, $fname, $lname]));
    }
}

[patrickbrouwers]

That's not possible. However you can just use the array indices (0,1,2) in rules as well.

[PhHitachi]

Hi @patrickbrouwers

i read WithMappedCells and now trying add validation on my code but the process is working even da data have null value.

i was hoping that WithMappedCells support by rules? if not, i'm hoping that you can add as features for make better coding and make code shorter and look like cleans like on the code below:

<?php

namespace App\Imports;

use App\User;
use Maatwebsite\Excel\Concerns\{
    ToModel,
    Importable,
    WithMappedCells,
    WithValidation,
};

class TestUser implements WithMappedCells, ToModel, WithValidation
{
    use Importable;

    public function mapping(): array
    {
        return [
            'id'  => 'A1',
            'lname'  => 'B1',
            'fname'  => 'C1',
            'mname'  => 'D1',
            'bday' => 'E1',
        ];
    }
    
    public function model(array $row)
    {
        User::firstOrCreate($row);
    }

    public function rules(): array
    {
        return [
            'id'    => 'required|max:10',
            'lname' => 'required|max:20',
            'fname' => 'required|max:20',
            'mname' => 'required|max:20',
            'bday'  => 'required|max:10',
        ];
    }

    public function customValidationAttributes()
    {
        return [
            'id' => 'E-Code',
            'lname' => 'Last Name',
            'fname' => 'First Name',
            'mname' => 'Middile Name',
            'bday' => 'Birth Date',
        ];
    }
}

[patrickbrouwers]

mappedcells is not the same as mapped columns. with mapped cells you map exactly 1 cell, not the entire column

as said before just use '0' => 'required'

[PhHitachi]

ok, i understand.

all i want is, my code make it shorter and easy to read but if have no solution for that it's ok i will use '0' => 'required'

Thanks for fast reply.

[patrickbrouwers]

I would be open for a WithColumnMapping concern via PR