Laravel-Excel returns required error with all rows

Question

I am implementing Laravel-Excel into my project and could not figure out the validation.

I try to upload the xlsx file with one row of data in it but still, the import throws required error.

Following is my EventResultImport code

namespace App\Imports;

use App\Models\Data\EventResult;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Imports\HeadingRowFormatter;

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

    public function model(array $row)
    {
        HeadingRowFormatter::default('none');

        return new EventResult([
            'event_id' => $row[0],
            'event_name' => $row[1],
        ]);
    }

    public function rules(): array
    {
        return [
            //'EventId' => 'required|numeric', Tried this
            //'*.EventId' => 'required|numeric', Tried this
            '0' => 'required|numeric'

        ];
    }
}

I get error on second-row event if there is numeric data in column EventId.

Thank you

Arthur Samarcos · Accepted Answer · 2018-11-22 00:04:41Z

1

You are implementing WithHeadingRow, so the attributes must match:

public function rules(): array
{
    return [
        'event_id' => 'required|numeric'
    ];
}

To skip nulls:

public function model(array $row)
{
    if (!isset($row[0])) {
        return null;
    }

    return new User([
        'name' => $row[0],
    ]);
}

edited Nov 22, 2018 at 0:04

answered Nov 21, 2018 at 23:56

Arthur Samarcos

3,29924 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Arthur Samarcos Over a year ago

Message says you are missing an ID on row 2 and you said your file has only one row, so maybe your file has leftover data on row 2.

Mike Ross Over a year ago

I think you are right. How do i skip emptyrow from validating?

Mike Ross Over a year ago

that skips the whole row if the first cell is blank.

Arthur Samarcos Over a year ago

Well... You are the one saying the first cell is required. :P

Mike Ross Over a year ago

first cell is required but there are other cells in the row and if the first is empty it will always skip the whole row and not validate.

|

Collectives™ on Stack Overflow

Laravel-Excel returns required error with all rows

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related