Topics with Author CSV export example - DemocracyOS | Runs with `NODE_PATH=. node tocsv.js`

tocsv.js

var fs = require('fs')
var json2csv = require('json2csv')
var models = require('lib/models')

models()

var Topic = models.Topic

Topic
  .find({deletedAt: null})
  .populate('author')
  .exec(function (err, data) {
    if (err) throw err

    json2csv({
      data: data,
      fields: [
        '_id',
        'mediaTitle',
        'author._id',
        'author.fullName',
      ]
    }, function (err, csv) {
      if (err) throw err

      fs.writeFile('export.csv', csv, function(err) {
        if (err) throw err

        console.log('· done.')
        process.exit(0)
      })
    })
  })