Skip to content

Instantly share code, notes, and snippets.

@evandocarmo
Created August 26, 2017 00:09
Show Gist options
  • Save evandocarmo/2addab538cb496ad43c72f79d0efdf7b to your computer and use it in GitHub Desktop.
Save evandocarmo/2addab538cb496ad43c72f79d0efdf7b to your computer and use it in GitHub Desktop.
How to read, parse and save csv objects to mongo database
const mongoose = require('mongoose');
const connection = mongoose.connect(process.env.MONGO_URL);
const Model = require('./models/model');
//read csv file and save to database
const csv = require('csv');
const fs = require('fs');
let file = './objects.csv';
let parser = csv.parse({delimiter: ','},(err, data)=>{
for(let row of data){
let object = new Model({
propertyOne:row[0],
propertyTwo:row[1]
});
object.save((err)=>{console.log(err)});
}
});
fs.createReadStream(file).pipe(parser).on('done',()=>{
console.log('done');
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment