# Using CodeIgniter to Develop an App for Importing Data from Excel to Databases
This repository contains a web application developed using the CodeIgniter PHP framework. The app allows users to import data from Excel spreadsheets into their databases seamlessly. The user interface is built using Bootstrap for a modern and user-friendly experience. The absoft.sql file is also included in the repository, containing the necessary database structure.
To run this application, ensure you have the following software installed on your system:
- PHP (version 7.2 or higher)
- MySQL (or any other compatible database)
- Web server (e.g., Apache, Nginx)
Follow these steps to set up the application on your local machine:
Clone the repository to your local environment:
git clone https://github.com/FREDVUNI/absoft.git
Navigate to the project folder:
cd absoft
Import the absoft.sql file into your MySQL database to create the necessary tables.
Rename the env.example file to .env and configure your database connection settings:
DB_HOST=localhost DB_USER=your_database_username DB_PASS=your_database_password DB_NAME=your_database_name
Install the required dependencies using Composer:
composer install
Start the development server:
php -S localhost:8000 -t public/
Access the application in your web browser at http://localhost:8000.
- Upload Excel File: On the main page, users can find an option to upload their Excel (.xls or .xlsx) files.
- Mapping Fields: After the file is uploaded, the application prompts users to map the columns in their Excel sheet to the corresponding fields in their database table. This ensures the imported data is correctly placed.
- Import Data: Once the field mapping is done, users can initiate the data import process by clicking the "Import" button. The application will read the Excel file, validate the data, and insert it into the database.
- View and Edit Imported Data: Users can view the imported data in a user-friendly interface. Additionally, you can integrate a feature to allow users to edit and update the data directly from the application.
- Export Data: If required, you can also include a feature to export data from the database to an Excel file for users to download.
We encourage contributions to enhance the functionality and user interface of this app. If you wish to contribute, please follow these steps:
Fork the repository.
Create a new branch for your feature/fix:
git checkout -b feature/your-feature-name
Make your changes and commit them:
git commit -m "Your detailed commit message"
Push the changes to your forked repository:
git push origin feature/your-feature-name
Create a pull request to the main repository, providing a detailed explanation of your changes.
This project is licensed under the MIT License, which allows you to use, modify, and distribute the code according to the terms of the license.
I would like to thank the CodeIgniter community and contributors for their valuable work. Special thanks to Bootstrap for providing a fantastic UI framework.
---