save query results in a text file?

[Aleksei T]

I guess its one of those days, can't seem to find an easy answer to a question.  If I need to output query results from MongoDB to a flat file (to use in excel or whatever), what would I use?  mongodump doesn't seem like the right tool (or does it?) - I think it outputs bson data, not text-viewable. 

[Aleksei T]

and I guess it's mongoexport :)  false alarm, thanks!!

[shashank sharma]

Group by queries create problem with mongoexport,......mongoexport can done only simple queries...i am still trying to find another way

[James Tan]

There are many ways to do this, the easiest probably being a one-liner like the following in the terminal:

  mongo --quiet --eval "cursor = db.test.find(); printjson(cursor.toArray())" > output.txt

Which will output the contents of the "test" collection in the "test" database, in JSON format to the file output.txt.

For details, refer to http://docs.mongodb.org/manual/tutorial/write-scripts-for-the-mongo-shell/.

[Regis Maicon]

Thanks! :)