How do I get the row number on import using queue reading?

[igor-tv]

I am importing an excel file into a database table which is a cache to do some complex validation. My import class implements the ToModel, WithChunkReading, ShouldQueue interfaces.

In the model() method, I need to get the number of the processed row of the excel file so that when validation errors occur, I can tell the user on which line of the file to fix the error.

How can this be implemented without additional queries to the database with a selection of already imported rows?

public function model(array $row)
{
    return new ImportExcelRowCache(
        [
            'row_number' => '???',
            // ...
        ]
    );
}

[patrickbrouwers]

Do a number increment in a cache store like file, redis, ...

[igor-tv]

Thank you for your advice!

[igor-tv]

Although this solution is not very reliable. If the cache is flushed during the execution of work, I will receive incorrect data. It would be nice if the library had a method that allows you to get the number of the line being processed.

[patrickbrouwers]

Have you tried: https://docs.laravel-excel.com/3.1/imports/chunk-reading.html#keep-track-of-the-row-number

[igor-tv]

Oh god, how I did not see it. Thank you, this is what I need :)