Import excel file data in database with maatwebsite using queue in laravel

Question

I am trying to import excel file to db using maatiswebsite. For that I am using queue because it would take some time to import file. I want to show user a quick message that "your file is being imported. we will inform you once it is done." But not able to do it.

QUEUE_DRIVER = database

Here is what I did so far -
Controller -

public function import(Request $request) 
{
    Excel::filter('chunk')->load($request->file('import_file')
            ->getRealPath())->chunk(250, function($reader)
    {
        ImportDistributor::dispatch(new ImportDistributor($reader->toArray()));
    });

    dd('your file is being imported. we will inform you once it is done.');

}

Job -

public function handle()
{
    if(isset($this->data) && !empty($this->data))
    {
        foreach($this->data as $data)
        {
            DB::table('user_details')->insert($data);
        }
    }
}

Model -

<?php

namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class UserDetailsModel extends Model
{
    protected $table = 'user_details';
}

I am not able to store data in user_details.

@JigneshJoisar Not getting any error, it's storing data to jobs table but not storing in user_details table. — amM
– amM, Commented Oct 10, 2018 at 11:02

Lakhwinder Singh · Accepted Answer · 2018-10-10 11:11:46Z

1

You need to add $fillable property in your model and add all the fields which you want to save to your database

<?php

namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class UserDetailsModel extends Model
{
    protected $table = 'user_details';
    protected $fillable = ["name", "etc", "etc1"];
}

And in Job, change code to this.

use App\UserDetailsModel;

public function handle()
{
    if(isset($this->data) && !empty($this->data))
    {
        foreach($this->data as $data)
        {
            UserDetailsModel::insert($data);
        }
    }
}

Try this. I think this will solve your problem.

answered Oct 10, 2018 at 11:11

Lakhwinder Singh

5,5825 gold badges30 silver badges52 bronze badges

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

2 Comments

amM Over a year ago

Thanks for the answer but nothing gets change.

amM Over a year ago

if i change QUEUE_DRIVER to sync, it stores data in database table user_details

Rachid · Accepted Answer · 2018-11-22 14:03:43Z

1

If the import works fine when you use sync drive, that means you need to run the queue worker:

php artisan queue:work

answered Nov 22, 2018 at 14:03

Rachid

2161 silver badge3 bronze badges

Collectives™ on Stack Overflow

Import excel file data in database with maatwebsite using queue in laravel

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related