Laravel-Excel returns required error with all rows
up vote
0
down vote
favorite
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 AppImports;
use AppModelsDataEventResult;
use MaatwebsiteExcelConcernsImportable;
use MaatwebsiteExcelConcernsToModel;
use MaatwebsiteExcelConcernsWithHeadingRow;
use MaatwebsiteExcelConcernsWithValidation;
use MaatwebsiteExcelImportsHeadingRowFormatter;
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
laravel laravel-excel
asked Nov 21 at 23:47
Mike Ross
1,23222155
add a comment |
up vote
0
down vote
favorite
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 AppImports;
use AppModelsDataEventResult;
use MaatwebsiteExcelConcernsImportable;
use MaatwebsiteExcelConcernsToModel;
use MaatwebsiteExcelConcernsWithHeadingRow;
use MaatwebsiteExcelConcernsWithValidation;
use MaatwebsiteExcelImportsHeadingRowFormatter;
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
laravel laravel-excel
asked Nov 21 at 23:47
Mike Ross
1,23222155
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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 AppImports;
use AppModelsDataEventResult;
use MaatwebsiteExcelConcernsImportable;
use MaatwebsiteExcelConcernsToModel;
use MaatwebsiteExcelConcernsWithHeadingRow;
use MaatwebsiteExcelConcernsWithValidation;
use MaatwebsiteExcelImportsHeadingRowFormatter;
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
laravel laravel-excel
asked Nov 21 at 23:47
Mike Ross
1,23222155
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 AppImports;
use AppModelsDataEventResult;
use MaatwebsiteExcelConcernsImportable;
use MaatwebsiteExcelConcernsToModel;
use MaatwebsiteExcelConcernsWithHeadingRow;
use MaatwebsiteExcelConcernsWithValidation;
use MaatwebsiteExcelImportsHeadingRowFormatter;
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
laravel laravel-excel
laravel laravel-excel
asked Nov 21 at 23:47
Mike Ross
1,23222155
asked Nov 21 at 23:47
Mike Ross
1,23222155
asked Nov 21 at 23:47
Mike Ross
1,23222155
asked Nov 21 at 23:47
Mike Ross
1,23222155
asked Nov 21 at 23:47
Mike Ross
1,23222155
1,23222155
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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],
]);
}
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
|
show 2 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53422023%2flaravel-excel-returns-required-error-with-all-rows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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],
]);
}
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
|
show 2 more comments
up vote
0
down vote
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],
]);
}
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
|
show 2 more comments
up vote
0
down vote
up vote
0
down vote
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],
]);
}
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
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],
]);
}
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
edited Nov 22 at 0:04
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
answered Nov 21 at 23:56
Arthur Samarcos
2,3251420
2,3251420
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
|
show 2 more comments
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
I have tried that as well.
– Mike Ross
Nov 21 at 23:58
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.
– Arthur Samarcos
Nov 22 at 0:01
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.
– Arthur Samarcos
Nov 22 at 0:01
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
I think you are right. How do i skip emptyrow from validating?
– Mike Ross
Nov 22 at 0:02
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
that skips the whole row if the first cell is blank.
– Mike Ross
Nov 22 at 0:08
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
Well... You are the one saying the first cell is required. :P
– Arthur Samarcos
Nov 22 at 0:09
|
show 2 more comments
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53422023%2flaravel-excel-returns-required-error-with-all-rows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
