Expand the result set limit (CSV Export)
I currently run queries and need to export the 20,000+ results to csv.
Olivier Bouan
shared this idea
Thank you for your feedback.
You can export entire results of your query to a CSV file. In the current release of MongoChef (2.0.1) the values of limit and skip are not being used to limit the number of exported documents. The entire result set will be exported.
You’ll be able to apply the skip and limit values in an upcoming version of MongoChef.
-
Joseph
commented
I like this tool a lot. I would use it for work except i cannot export results from intellisence easily to CSV.
-
Marek Pepke
commented
@Tomasz Can this option also be added for IntelliShell results? Although results look like those from the Query Builder, I can only export the entire collection.
-
Anonymous
commented
would be nice to have a possibility to export before requesting a dataset (directly exporting a query), to save a second request when it comes to very big datasets
-
Dear Oliver,
Please do the following to export the results of your query to a CSV file:
1. Construct your Query with MongoChef, e.g. by using the Query Builder
2. Make sure the Tab with your results of your query is active, and then
3. Press the "Export" button on the toolbar
4. Select the "Current query result set" from the "Export" drop down list (please note that the "skip" and "limit" values will be ignored during the export)
5. Select "CSV" from the "Format" drop down list.
6. Specify using the "To" drop down list.
7. Finally, press the "Export" button.Cheers,
Tomasz -
Olivier Bouan
commented
Thanks @thomasz ... how can you export results of queries to csv?