An attempt to write a program to import contacts from Excel Files having an extension CSV or XLSX format.
Sai Ashirwad Informatia (SAI) provides Software Solutions and Services to Small and Medium Business Globally. SAI is implementing a Web Based Application to manage its Sales Activity. Currently, its Sales Team uses free email accounts. SAI wants to import all the Contact(s) from Excel in CSV or XLSX format. Code a Program to import contacts from Excel Files having an extension CSV or XLSX format. The program should demonstrate the import and export of contact data.
This project is built using the Laravel framework, a popular PHP framework known for its elegant syntax, robust features, and developer-friendly tools. This project serves as a web application to maintain recordes of the contact(s) for the sales activity of Sai Ashirwad Informatia (SAI). Authentication is done with the help of jetstream and livewire.
● User Authentication ● Create a CRUD structure for the Contact Module ● Added Excel Import and Export mechanism ● Display Results with Navigation ( Go to First, Last, Previous and Next Records) ● Sorting of Results
Prerequisites Before you begin, ensure you have the following installed:
PHP : 8.2.9
Composer : 2.5.8
Node.js : v20.4.0.
MySQL : 8.0.32
Clone the repository:
$ git clone https://github.com/Hardikkk10/LaravelTest.git
cd LaravelTest
Install PHP dependencies:
composer install
Install dependencies:
npm install
In this project we used Maatebsite/excel library to import and export the CSV and Excel files, so run this command to get it for the project:
composer require maatwebsite/excel
For more details and installation follow:
https://docs.laravel-excel.com/3.1/getting-started/installation.html
Start the XAMPP server and connect project to your project Copy the .env.example file to .env and configure your environment settings:
cp .env.example .env
Run database migrations:
php artisan migrate
Start the development server:
php artisan serve
