README

Advance Excel Import 💯

GUI Interface to Import

Advance Excel Import allows to import data without writing import script for each project, using this package you will be able to import data using a GUI interface withouth writing any script.

Installation

Via Composer

composer require sunarctech/excel-import

Instructions

Just install this package and make changes accordingly in configuration file

Features

• Import an excel file
• Maintain session lifetime for file to be saved on server via configuration
• Supports xls,xlsx.csv
• Choose table name and column on which excel data need to be imported

Available Configurations

Exclude Fields

Add the field which you wish should not be imported

Default

'fields_to_be_excluded' => [
    'id', 'created_at', 'updated_at', 'deleted_at'
],

File Path

Define the public path where to file should be uploaded, and read.

Default

'default_path' => 'assets/excel/global',

Import Session Life

Define the lifetime for a import session in minutes.

Default

'session_lifetime' => 10,

Publish Config file

php artisan vendor:publish --provider="Sunarc\ImportExcel\ImportExcel\ImportExcelServiceProvider" --tag="config"

Requirments

Required Packages

• doctrine/dbal
• illuminate/support
• maatwebsite/excel

PHP extension

• php_zip
• php_xml
• php_gd2
• php_iconv
• php_simplexml
• php_xmlreader
• php_zlib

Routes

Two routes been registered automatically which allows to import the file and choose the columns. Using import as prefix.

• youdomainname/import/file-upload
  • Using this route you can upload the file which will be saved into public storage.
• youdomainname/import/start-import
  • This will be used for selection and import process start.

Samples

Sample File - sampleimport.xlsx

Import File

Start Import

Created by SunArc Technologies

We are the leading Software Development Company providing end-to-end IT services & solutions to our esteemed customers in multiple industries and domains for the past 18+ years? Give us a call.

https://sunarctechnologies.com/
info@sunarctechnologies.com
+91-8764025209

🔧 Supported Versions

Versions supported.

License

The MIT Public License. Please see LICENSE for more information.