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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s