Download the PHP package cbytedigital/laravel-bi-data-export without Composer
On this page you can find all versions of the php package cbytedigital/laravel-bi-data-export. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download cbytedigital/laravel-bi-data-export
More information about cbytedigital/laravel-bi-data-export
Files in cbytedigital/laravel-bi-data-export
Package laravel-bi-data-export
Short Description Laravel package for easily and periodically exporting data for BI purposes. Built in functionality for excluding or redacting columns and exporting to CSV on a Laravel filesystem disk.
License MIT
Informations about the package laravel-bi-data-export
Laravel BI Data Export
A Laravel package which can be used for easily and periodically exporting large datasets for BI purposes. Includes built in functionality for excluding or redacting columns and exporting to CSV on a Laravel filesystem disk.
The package uses database cursors and streaming to support working with large datasets and keep memory usage to a minimum for poor little webservers.
Installation
Use composer to install this package:
Optional: The service provider will automatically get registered. Or you may manually add the service provider in your config/app.php file:
You should publish the config with:
Usage
Currently, only exporting to .CSV is supported. Which is the most usual method of exporting large datasets. Lucky, you can write your own implemention of a export job and reference the class in the config.
The export can be used directly in requests (sync), but it is recommended to use background workers and queueing.
To include your models for the export, configure your models to use the trait.
If desired define the selected and/or hidden fields in your model as follows (optional):
If you require to export for example a pivot table, which does usually not have a dedicated model, you can manually add the table and required columns/config for exporting to the configuration file.
Add the command for exporting on a schedule:
Or call it manually:
Testing
Run the tests with:
Support
Version | Laravel Version | PHP Version |
---|---|---|
1.x | >= 8.x | >=8.0 |
Postcardware
This package is completely free to use. If it makes it to your production environment we would highly appreciate you sending us a postcard from your hometown! 👏🏼
Our address is: CBYTE Software B.V., Heuvelkamp 2a, 6658DE Beneden-Leeuwen, Netherlands.
License
The MIT License (MIT). Please see License File for more information.