sunarctech/excel-import

Import the database from a single excel file with the comfort of GUI interface!

Maintainers

Details

github.com/sunarc-technologies/advanced-excel-import

Homepage

Source

Issues

Installs: 6

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 1

Forks: 0

Open Issues: 0

v0.2 2022-02-03 06:16 UTC

Requires

Requires (Dev)

MIT 9862e5eb04cb2ede9d274def52c0e293cec4b853

  • SunArc Technologies <info.woop@sunarctechnologies.com>

advancedexcel-importsunarcsunarctechadvanced-import

This package is auto-updated.

Last update: 2024-05-16 21:45:28 UTC

README

image

Advance Excel Import 💯

GUI Interface to Import

Packagist License For PHP Scrutinizer Code Quality Github Issues Github Stars Github Forks Packagist Packagist Release Packagist Downloads

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

image

Start Import

image

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.

Version Laravel Version PHP Version Support
0.1 <=7.0 7.3 - 8.x All features

License

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