boing6002/dataimport

Excel Importer dependency for Laravel Enso

3.0.13 2019-01-22 11:49 UTC

README

Codacy Badge StyleCI License Total Downloads Latest Stable Version

Incredibly powerful, efficient, unlimited number of rows, queues based Excel importer dependency for Laravel Enso.

Watch the demo

click on the photo to view a short demo in compatible browsers

Screenshot

Features

  • allows the import of big files with the number of rows only limited by the xlsx file format, by splitting the data in chunks and handling them on multiple queues
  • uses JSON templates to configure xlsx file imports into the application, with minimum custom logic
  • import types are defined in the package configuration
  • each import type can be validated against required columns, sheets, data types and more
  • the Laravel validation is utilized for maximum reuse of existing mechanisms while custom validators can be added when necessary
  • an example import type is included by default in the package
  • uses Spout for reading the xlsx file
  • uses Laravel's queueing system and its auto-balancing features for efficient asynchronous, parallel processing
  • blocking file structure validation
  • non blocking file contents validation
  • content import issues are made available in the rejected rows summary, a downloadable xlsx file with the same structure as the import file, with an extra column (on each sheet) that will describe all the validation errors for each row
  • features real time import progress reporting in the UI
  • before and after hooks which are available during the importing process
  • comes with an utility ExcelSeeder class, that can be used to seed your tables using data from excel files

Configuration & Usage

Be sure to check out the full documentation for this package available at docs.laravel-enso.com

Contributions

are welcome. Pull requests are great, but issues are good too.

License

This package is released under the MIT license.