vitorccs / laravel-csv Goto Github PK

Thanks, this package looks great!

I can't figure out how to use the FromCollection feature. It's the only one without any examples.
I'm trying this:

public function collection()
{
    return Post::all();
}

But I'm getting this:

Declaration of App\Exports\PostsFromCollection::collection() must be compatible with Vitorccs\LaravelCsv\Concerns\FromCollection::collection(): Illuminate\Support\Collection

Ideas? Thank you!

I need to set the UTF-8 BOM, for example as seen in the league/csv docs

$csv->setOutputBOM(Reader::BOM_UTF8);

Can I somehow get hold of that $csv add that somewhere?

Edit: If I read correctly this isn't even using league/csv, so that doesn't really helps.

But in my case I just would need to prepend $utf8_bom = "\xEF\xBB\xBF"; (the BOM for UTF-8) to the returned CSV.

@vitorccs would you consider restoring support for PHP 7.4?

this package is a massive speed increase compare to excel packages. so thanks.

but we are still hitting issues with large exports for timeouts and memory issues. eg +50000 rows via FromQuery

do yo have a way to append to csv sheet and off load memory consumption with each batch attempts?

thanks in advance

Illuminate\Queue\MaxAttemptsExceededException: Vitorccs\LaravelCsv\Jobs\CreateCsv has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/v2/laravel/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:648

I know increasing the timeout and memory is an option but we need to set a limit.

Hi, I would be open to submitting a PR for this to add ->stream() to the exportable, this can just return getStream() from ExportableService.php I think...?

Use case is for when we are building csv files on the fly and sending them via email, we do not need to store them to disk and creates additional unrequired steps.