Export mongodb query result to csv

1. Create a file “exportwords.js” and add following code:

var today = new Date();
var year = today.getFullYear();
var month = today.getMonth();
var day = today.getDate();
var date = year + "-" + month + "-" + day;
print("Query");
db.searchwords.find({date: date}).forEach(function(sw){
   print (sw.query);
}) 

2. Run following command:

mongo databasename exportwords.js > exportwords.csv

SendEmail can’t load required libraries. (try installing Net::SSLeay and IO::Socket::SSL) on CentOS

To fixed this need to install following libraries:

sudo yum install ‘perl(Net::SSLeay)’
sudo yum install ‘perl(IO::Socket::SSL)’