Exporting Excel of large amount of data

[Umar-Farooq-Shafi]

Hey, I've data about 40K when I try to export the file. The browser got stuck and didn't respond even when I tried to export using ->queue() and ->withChunkSize() and set the size from 100 to 20K but it didn't work.

ExportBulkAction::make()->exports([
   ExcelExport::make('table')
          ->queue()
          ->withChunkSize(20000)
           ->fromTable(),
])

[pxlrbt]

You shouldn't use a BulkAction with that many records, because the BulkAction needs to send all 40k ids of your records to the backend which is what's probably causing the browser to crash/get stuck.

Best to use a Table Header Action in this case.

[Umar-Farooq-Shafi]

@pxlrbt Thanks, it's working.

[Umar-Farooq-Shafi]

What is the best size withChunkSize?

[pxlrbt]

What is the best size withChunkSize?

I don't really now. I'd say something around 1000?

[Umar-Farooq-Shafi]

@pxlrbt The issue with the Table Header Action is that I have to filter out the record based on the date range but it's not applying on the Export. it's downloading all the records.

[pxlrbt]

You could use ->modifyQuery(fn ($livewire) -> ) to apply your filters. Haven't implemented that one yet apparently. But somebody else reported an issue with Depedency Injection into Closures. So for now there might be no solution to this

[Umar-Farooq-Shafi]

in the getQuery function I print out the $this->getLivewire(). Is there any way to get filters from this?

[pxlrbt]

->tableFilters should be what you are looking for. Depending on your version there should also be methods to get the table query.

[Umar-Farooq-Shafi]

$this->getLivewire()->tableFilters giving me null.

[Umar-Farooq-Shafi]

I'm using Filament v3

[Umar-Farooq-Shafi]

Solve by using cache.