Styjun

Four ships at the ocean with the same distance

Category-theoretic treatment of diffs, patches and merging?

Movie featuring a De Lorean - NOT Back to the Future

What does "spinning upon the shoals" mean?

Why did Robert F. Kennedy loathe Lyndon B. Johnson?

What is the Taylor series of a square root?

How should I ask for a "pint" in countries that use metric?

Quotients of a ring of integers

I don't want to be introduced as a "Minority Novelist"

What was the significance of Spider-Man: Far From Home being an MCU Phase 3 film instead of a Phase 4 film?

I'm feeling like my character doesn't fit the campaign

Need a non-volatile memory IC with near unlimited read/write operations capability

What are the consequences for a developed nation to not accept any refugees?

Tesco's Burger Relish Best Before End date number

What are some bad ways to subvert tropes?

How do resistors generate different heat if we make the current fixed and changed the voltage and resistance? Notice the flow of charge is constant

Does the Wild Magic sorcerer's Tides of Chaos feature grant advantage on all attacks, or just the first one?

Can you create a free-floating MASYU puzzle?

Taking my Ph.D. advisor out for dinner after graduation

Was the 45.9°C temperature in France in June 2019 the highest ever recorded in France?

How to say "is going" in Russian in "this game is going to perish"

What is the highest level of accuracy in motion control a Victorian society could achieve?

As a supervisor, what feedback would you expect from a PhD who quits?

What factors could lead to bishops establishing monastic armies?

Catching exceptions while importing an excel file using Maatwebsite

laravel excel get headers and maatwebsitehow to import excel file with laravel maatwebsite?Laravel maatwebsite/excel Corrupted file when download itCall to undefined method MaatwebsiteExcelExcel::load()Laravel Maatwebsite/ExcelError importing excel file in laravelMaatwebsite excel exportSymfony Component Debug Exception FatalThrowableError (E_PARSE) syntax error, unexpected '$validate' (T_VARIABLE)Fail storing uploaded file after MaatwebsiteExcel import in Laravel 5.7

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am using maatwebsite to import the excel file and save the records in the database.

I was able to import them but I also want to add validations such as required|email and also want to catch the sql exceptions raised in between.

Below is my controller code.

public function import(Request $request)
 
 $validateData = $request->validate([
 'class_id' => 'required'
 ]);
 try 
 $import->import(request()->file('usersExcel'), null , MaatwebsiteExcelExcel::XLSX);
 catch (MaatwebsiteExcelValidatorsValidationException $e) 
 $failures = $e->failures();
 $errormessage = "";
 dd($failures);
 foreach ($failures as $failure) 
 $errormess = "";
 foreach($failure->errors() as $error)
 
 $errormess = $errormess.$error;
 
 $errormessage = $errormessage." ,n At Row ".$failure->row().", ".$errormess."<br>";
 
 return redirect('/create_users')->with('error', $errormessage);

 

 

Here is the import code:

use Importable, SkipsErrors;
 private $classid = 0;
 public function __construct(int $classid)
 
 $this->classid = $classid;
 

 public function model(array $row)
 

 return new User([
 'name' => $row['name'],
 'email' => $row['email'],
 'password' => Hash::make('password')
 ]);
 

 public function rules(): array
 
 return [
 'name' => 'required',
 'email' => 'required',
 'password' => 'required',
 ];
 

My roadblocks here are, i can catch the row validations and send that to the view through the controller but not sure whether this is right code. And I am not able to handle the queryExceptions that i get if i insert duplicate record.

Can you guys help me figuring it out.

laravel-5 maatwebsite-excel

share|improve this question

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

add a comment | 

0

I am using maatwebsite to import the excel file and save the records in the database.

I was able to import them but I also want to add validations such as required|email and also want to catch the sql exceptions raised in between.

Below is my controller code.

public function import(Request $request)
 
 $validateData = $request->validate([
 'class_id' => 'required'
 ]);
 try 
 $import->import(request()->file('usersExcel'), null , MaatwebsiteExcelExcel::XLSX);
 catch (MaatwebsiteExcelValidatorsValidationException $e) 
 $failures = $e->failures();
 $errormessage = "";
 dd($failures);
 foreach ($failures as $failure) 
 $errormess = "";
 foreach($failure->errors() as $error)
 
 $errormess = $errormess.$error;
 
 $errormessage = $errormessage." ,n At Row ".$failure->row().", ".$errormess."<br>";
 
 return redirect('/create_users')->with('error', $errormessage);

 

 

Here is the import code:

use Importable, SkipsErrors;
 private $classid = 0;
 public function __construct(int $classid)
 
 $this->classid = $classid;
 

 public function model(array $row)
 

 return new User([
 'name' => $row['name'],
 'email' => $row['email'],
 'password' => Hash::make('password')
 ]);
 

 public function rules(): array
 
 return [
 'name' => 'required',
 'email' => 'required',
 'password' => 'required',
 ];
 

My roadblocks here are, i can catch the row validations and send that to the view through the controller but not sure whether this is right code. And I am not able to handle the queryExceptions that i get if i insert duplicate record.

Can you guys help me figuring it out.

laravel-5 maatwebsite-excel

share|improve this question

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

add a comment | 

I am using maatwebsite to import the excel file and save the records in the database.

I was able to import them but I also want to add validations such as required|email and also want to catch the sql exceptions raised in between.

Below is my controller code.

public function import(Request $request)
 
 $validateData = $request->validate([
 'class_id' => 'required'
 ]);
 try 
 $import->import(request()->file('usersExcel'), null , MaatwebsiteExcelExcel::XLSX);
 catch (MaatwebsiteExcelValidatorsValidationException $e) 
 $failures = $e->failures();
 $errormessage = "";
 dd($failures);
 foreach ($failures as $failure) 
 $errormess = "";
 foreach($failure->errors() as $error)
 
 $errormess = $errormess.$error;
 
 $errormessage = $errormessage." ,n At Row ".$failure->row().", ".$errormess."<br>";
 
 return redirect('/create_users')->with('error', $errormessage);

 

 

Here is the import code:

use Importable, SkipsErrors;
 private $classid = 0;
 public function __construct(int $classid)
 
 $this->classid = $classid;
 

 public function model(array $row)
 

 return new User([
 'name' => $row['name'],
 'email' => $row['email'],
 'password' => Hash::make('password')
 ]);
 

 public function rules(): array
 
 return [
 'name' => 'required',
 'email' => 'required',
 'password' => 'required',
 ];
 

My roadblocks here are, i can catch the row validations and send that to the view through the controller but not sure whether this is right code. And I am not able to handle the queryExceptions that i get if i insert duplicate record.

Can you guys help me figuring it out.

laravel-5 maatwebsite-excel

share|improve this question

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

public function import(Request $request)
 
 $validateData = $request->validate([
 'class_id' => 'required'
 ]);
 try 
 $import->import(request()->file('usersExcel'), null , MaatwebsiteExcelExcel::XLSX);
 catch (MaatwebsiteExcelValidatorsValidationException $e) 
 $failures = $e->failures();
 $errormessage = "";
 dd($failures);
 foreach ($failures as $failure) 
 $errormess = "";
 foreach($failure->errors() as $error)
 
 $errormess = $errormess.$error;
 
 $errormessage = $errormessage." ,n At Row ".$failure->row().", ".$errormess."<br>";
 
 return redirect('/create_users')->with('error', $errormessage);

 

 

use Importable, SkipsErrors;
 private $classid = 0;
 public function __construct(int $classid)
 
 $this->classid = $classid;
 

 public function model(array $row)
 

 return new User([
 'name' => $row['name'],
 'email' => $row['email'],
 'password' => Hash::make('password')
 ]);
 

 public function rules(): array
 
 return [
 'name' => 'required',
 'email' => 'required',
 'password' => 'required',
 ];
 

share|improve this question

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

share|improve this question

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges

asked Mar 25 at 21:40

Gouse FerozGouse Feroz

855 bronze badges