ExportAllOperation

Current version 0.0.2 This version use maatwebsite/excel for exports.

Installation

Add the package into your structure. (no composer package yet)

php artisan vendor:publish --provider="Backpack\ExportAllOperation\ExportOperationServiceProvider"

Todo

• Export configuration publication

Features

• Trait that add a button into you list view
• Creates URI endpoint to export all the model entries into a file.
  • CSV (in plain php)
  • CSV with a lib (same as excel to DRY things)
  • Excel (XLS)
  • Excel XLSX (Needed ?)
  • [] PDF (Started)
  • HTML (Maybe soon)
• Implements author configation.

Next features

Nice or idea to develop

• Add new permission precisely for this operation
• Add async call to avoid navigating outside of the current exportable view.
• Choose which columns to show in the export
  • use DataTable UX ?
• (maybe) reorder the columns in the export
  • Use the Backpack for laravel reordering feature ?
• Choose what you export
  • All rows (124.141 entries)
  • Filtered rows (45.133 entries)
  • Currently visible rows (25 rows) (this DT have it covered I think)
  • Currently selected rows (5 rows) (this DT have it covered I think)
• Add a download btn with the format choices

Origin story

The features Originally posted by tabacitu April 13, 2020

https://github.com/Laravel-Backpack/CRUD/issues/3860

Instead of using DataTable's magic to export rows, we should create an Export operation. That way:

we could even customize how it's done, add different export formats, etc;
it would fix the problem of having to see all entries that are exported (known limitation of the DataTables export when using AJAX);

The way I see it:

the operation adds a single "Export" button to the bottom stack;
click the button and it opens a modal; in that modal, you can
    choose which columns to show in the export;
    (maybe) reorder the columns in the export;
    choose the export format (XLS, CSV, PDF);
    choose to export:
        All rows (124.141 entries)
        Filtered rows (45.133 entries)
        Currently visible rows (25 rows)
        Currently selected rows (5 rows)
    click "Download" and you get the file you want; the file itself is generated using PHP generators, so that you can export even millions of rows;