rifanid98/batch-insert-on-duplicate-update-example

An example of importing excel data to a database

An example of importing excel data to a database, with Express.js & MySQL.

📝 Table Of Content

• Prerequisites
• Installation
• Features
• Demo
• Built wtih
• Author
• License

Prerequisites

• NPM or Yarn as package manager.
• Node.js installed on the local machine.
• MySQL intalled on the local machine (ex. XAMPP)

Installation

1. Clone this repository: git clone https://github.com/rifanid98/batch-insert-on-duplicate-update-example
2. Start XAMPP
3. Database configuration:
   • Open http://localhost/phpmyadmin in the browser
   • Import database, select mahasiswa.sql file from project folder
4. Start the server:
   • Open root project folder with command line (terminal, linux. cmd, windows. etc.)
   • Type and run this command npm start to start the server.
   • Make sure there are no other processes that use port 3000
5. Run app with api testing tools like postman, etc. on http://localhost:3000/mahasiswa/api/v1/ or using local ip like http://192.168.43.88:3000/mahasiswa/api/v1/ as an example.
6. Don't forget to change .env variable value to your own config.

Features

• CRUD & Import data from excel file.
• CORS allowed

Demo

See the demo here

Built with

• Node.js - JavaScript runtime environment
• Express.js - Node.js framework
• MySQL Database

Author

Adnin Rifandi Sutanto Putra

• Adnin Rifandi

• Adnin Rifandi

• Adnin Rifandi

License

This project is licensed under the MIT License - see the LICENSE file for details