Courses

Queues in Laravel

Why Queues? First Example - Email Notification with Queue

Download file

avatar
Jean A. Silva

Hi teacher, good night!

Hlep-me please?.

I'm trying to use the queue concept in one of my projects together with laravel-excel that they have in one of their classes, I can populate the table with the data contained in excel normally, so there are files with more than 5 thousand records, therefore being a sync process, it stops the other connections, so I decided to make queues according to their course, so I came across a problem, here I use oracle, I tested it in mysql and it works normally, when I try to call the queue and execute it, I have the following error below, I can save the job in the database so the work does not run and generates the error in the laravel log.

Controller

   public function store(StoreFileUploadRequest $request)
    {
        if ($request->hasFile('file')) {
            Excel::import(new FileUploadImport, $request->file('file'));
            return new FileUploadResource($request);
        } 
    }

Model/Class

class FileUploadImport implements ToModel, WithBatchInserts, ShouldQueue, WithChunkReading
{

    public function model(array $row)
    {
        return new FileUpload([
            'name'             => $row[0],
            'cpf'              => $row[1],
            'data_nascimento'  => $row[2],
        ]);
    }
 
    public function batchSize(): int
    {
        return 2000;
    }
 
    public function chunkSize(): int
    {
        return 2000;
    }

Error:

 local.ERROR: Array to string conversion {"exception":"[object] (ErrorException(code: 0): Array to string conversion at C:\\laragon\\www\\Back-end\\gateway-web-backend\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Stringable.php:32)
avatar
Jean A. Silva

I am try too, https://docs.laravel-excel.com/3.1/imports/queued.html.

I don´t sucess.

   public function store(StoreFileUploadRequest $request)
    {
        if ($request->hasFile('file')) {
            Excel::queueImport(new FileUploadImport, $request->file('file'));
            return new FileUploadResource($request);
        } 
    }
avatar
Povilas Korop

Interesting, it seems like there's error to convert something, could you try some other file to import? I'm pretty sure there's some invalid data in some column/row, or maybe empty row unnecessary?

avatar
Jean A. Silva

Hello teacher, I reduced the lines to the maximum and put only numbers, so I have the same problem, I have tried other types of extensions too, without success, something that is incompatible with oracle and I cannot determine through the debug or the logs, because I have just this error shown earlier to you. I'm clearly out of alternatives already, :(.

My date information in excel.

1 2 3

avatar
Povilas Korop

I don't use Oracle so can't really help in there. Maybe there are too few lines in your Excel? I've heard some "bug" or feature that Excel/CSV counts only with at least 3 lines. Not sure, just blind guess, sorry can't help with personal debugging, please post on Laracasts forum.

avatar
You can use Markdown
avatar
Muhsin Ahadi

Hi Mr. Povilas.

I was trying to access this course but the video did not show up because of this error The webpage at https://player.vimeo.com/video/732687827?h=061a2ca5c3&badge=0&loop=false&byline=false&portrait=false&title=false&speed=true&transparent=0&gesture=media might be temporarily down or it may have moved permanently to a new web address.

Can you help me so I can access it? Maybe migrate it to private Youtube playlist.

avatar
Modestas

Hello, sorry for a late reply, but this might be because Vimeo is blocked in your country. There is nothing we can do about this, sorry.

avatar
You can use Markdown
avatar
You can use Markdown