can i use background job to generate rows in the Excel file and download it later?

caxlsx / caxlsx_rails

A Rails plugin to provide templates for the axlsx gem

MIT License

744 stars 84 forks source link

Closed vonchristian closed 5 years ago

vonchristian commented 5 years ago

Server times out because of large amounts of data being exported. I need help on how to use background job for exporting data to Excel. Thank you.

OpenCoderX commented 5 years ago

You can use Sidekiq, https://github.com/mperham/sidekiq, to manage the background jobs and Rails ActiveStorage to persist the files and genrate download links: https://guides.rubyonrails.org/active_storage_overview.html.

OpenCoderX commented 5 years ago

I'm closing this as it is not related to a problem with the gem.

straydogstudio commented 5 years ago

@vonchristian If you run into issues getting templates to work inside Sidekiq, see the readme for running the gem in scripts.