Download the PHP package ascentech/massive-csv-import without Composer
On this page you can find all versions of the php package ascentech/massive-csv-import. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download ascentech/massive-csv-import
More information about ascentech/massive-csv-import
Files in ascentech/massive-csv-import
Download ascentech/massive-csv-import
More information about ascentech/massive-csv-import
Files in ascentech/massive-csv-import
Vendor ascentech
Package massive-csv-import
Short Description This lightweight package helps developers to import csv files with millions of records efficiently using Laravel Queues.
License MIT
Package massive-csv-import
Short Description This lightweight package helps developers to import csv files with millions of records efficiently using Laravel Queues.
License MIT
Please rate this library. Is it a good library?
Informations about the package massive-csv-import
Massive CSV Import
- This lightweight package helps developers to import csv files with millions of records efficiently using Laravel Queues.
Prerequisites
- You must be using Laravel Queues and jobs table must exist in your database. If you are not using Queues, setup using this link.
- Write privileges on
storage
directory of your Laravel project. You can change this location from configuration file of this package as well. - By default, this package tries to search required Model class from
App\Models\
namespace. If you have placed Models in another directory, set its path in configuration file i.e.,vendor\ascentech\massive-csv-import\config\massive-csv-import.php
.
Installation
- composer require ascentech/massive-csv-import
- Add
Ascentech\MassiveCsvImport\MassiveCsvImportServiceProvider::class,
intoproviders
array of your project'sconfig\app.php
file.
Usage
- Prepare a large csv file (without headers) to import.
- Prepare a file upload interface in your project and write following two lines in your Controller code:
- use Ascentech\MassiveCsvImport\MassiveCsvImportFacade;
- $result = MassiveCsvImportFacade::import($path, $table_name, $columns);
$path
refers to temp path of uploaded csv file$table_name
is the database table name in which you want to import large csv file.$colums
is the array of columns for the particular table e.g., $columns = ['name','description','status'];- This package will create multiple smaller csv files from the large file and save these files into
storage\table_name\
directory. By default the chunk size is 1000, you can editcsv_chunk_size
variable's value in configuration file i.e.,vendor\ascentech\massive-csv-import\config\massive-csv-import.php
. - A separate job is created for each smaller csv file for processing in the background.
- You will need to run
php artisan queue:work
command for the jobs processing. - All processed files will be placed with
.csv-processed
extension in the samestorage\table_name\
directory. - Remember! If a particular record (from smaller csv file) fails to insert into the database, an error message will be written in laravel.log file, but the remaining job will keep processing without failing. A separate directory
storage\table_name\failed
is automatically created which will have csv files with the failed records only. You can fix these and import later on in a separate csv file.
License
- MIT
All versions of massive-csv-import with dependencies
PHP Build Version
Package Version
No informations.
The package ascentech/massive-csv-import contains the following files
Loading the files please wait ....