CSV Uploader

This is a simple Node.js package that facilitates the upload of CSV files to a Microsoft SQL Server (MS SQL) database. The package provides a user-friendly HTML interface for selecting and uploading CSV files through a web browser.

Documentation

Getting Started

Follow the steps below to set up the CSV Uploader in your project.

Prerequisites

Before you begin, ensure that you have the following:

Node.js installed on your machine.

An MS SQL Server instance with the necessary database and table set up.

Installation

Install the package using npm:

``bash
npm install @shamigondal/csv-uploader

`
Also install all these packages

`bash
npm i fs path multer bodyparser express
`

index.html:

Create the required HTML files:

`html







integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">

Upload CSV File to MS SQL

Choose a CSV file:

Upload

`

success.html

`html







integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">

File uploaded successfully!

Back to Upload

`

db.js

create db.js file to connect with the ms sql Server.
Remember to to first authenticaiton at ms sql server, then you will get user and password.

`node.js

const sql = require('mssql');

const config = {
server: 'localhost',
user: '', // Your MS SQL Server username
password: '', // Your MS SQL Server password
database: 'testing', // Your database name
pool: {
max: 10,
min: 0,
idleTimeoutMillis: 30000,
},
options: {
encrypt: true,
trustServerCertificate: true,
trustedConnection: true,
connectionTimeout: 30000,
},
};

const pool = new sql.ConnectionPool(config);

const connectToDatabase = async () => {
try {
await pool.connect();
console.log('Connected to the database!');
return pool;
} catch (error) {
console.error('Error connecting to the database:', error.message);
throw error;
}
};

module.exports = connectToDatabase;
`

app.js

creat app .js file first install the package

`bash

npm install @shamigondal/csv-uploader
`
Now write the following connectToDatabase

`node.js

const express = require('express')
const path = require('path')
const bodyparser = require('body-parser')
const multer = require('multer')
const {uploadCsv} = require('csv-uploader')
const connectToDatabase = require('./db');



const app = express();

app.use(bodyparser.urlencoded({ extended: false }))
app.use(bodyparser.json())

const PORT = 4000 || 3000;
const localhost = http://localhost:

const storage = multer.diskStorage({

destination: (req, file, callback) => {
callback(null, './uploads')
},
filename: (req, file, callback) => {
callback(null, file.fieldname + '-' + Date.now() + path.extname(file.originalname))
}
})

const uploads = multer({
storage: storage
})


app.get('/', (req, res) => {

res.sendFile(__dirname + '/index.html')
})

app.post('/post-Csv-file', uploads.single('file'), async (req, res) => {
try {
console.log(req.file.path);
const tableName = 'users'; // Replace with your table name
const columnNames = ['userId', 'userName', 'userEmail', 'userPass']; // Replace with your column names
await uploadCsv(path.join(__dirname, 'uploads', req.file.filename), tableName, columnNames, connectToDatabase);
res.sendFile(__dirname + '/success.html');
} catch (error) {
console.error('Error processing CSV file:', error);
res.status(500).send('Internal Server Error');
}
});


app.listen(PORT, (req, res) => {

console.log("CSV Faker listening at PORT " + localhost + PORT)
})

``

Authors

- @ShamiGondal

License

MIT