Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@magician11
Last active August 2, 2017 21:36
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save magician11/94e7e900b9b390fb4a53b1d32cc38476 to your computer and use it in GitHub Desktop.
Save magician11/94e7e900b9b390fb4a53b1d32cc38476 to your computer and use it in GitHub Desktop.
How To Use jQuery To Post A CSV File To A Node.js Server
// using jQuery
$("#2020data").submit(function(e) {
$.ajax({
url: "https://e0d92634.ngrok.io/test",
type: "POST",
data: new FormData(this),
processData: false,
contentType: false
});
return false;
});
<form id="2020data">
<input type="file" name="csvFile">
<button type="submit" class="btn btn-default">Upload CSV File</button>
</form>
const express = require('express');
const multer = require('multer');
const app = express();
const upload = multer();
app.post('/test', upload.single('csvFile'), async (req, res) => {
try {
const csvFile = req.file.buffer.toString();
const rows = csvFile.split('\n');
for (let row of rows) {
const columns = row.replace(/"/g, '').split(',');
console.log(columns);
}
res.sendStatus(200);
} catch (err) {
console.log(err);
res.sendStatus(400);
}
});
app.listen(3000, function() {
console.log(`Server started at ${new Date().toString()}`);
});
@magician11
Copy link
Author

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment