CronJob in Nodejs to convert .xls file to .csv and load the data to the database
- Run
npm install
- Create
.env
file in the project root folder for the database connection. Example:DB_HOST=0.0.0.0 DB_USER=root DB_PORT=3306 DB_PASSWORD=12345 DB_DATABASE=aog_development
- Set
EXCELPATH
andLOGPATH
in theglobals.js
file - Load
script/tableMaintenixCreation.sql
into your database - Run
node job.js