How to export JSON from MongoDB using Robomongo

Question

So I do not know much about MongoDB  I have RoboMongo using which I connect to a MongoDB  What I need to do is this - there is a collection in that MongoDB  I want to export the data from that collection so that I can save it into a file   I used the interface to open the data from the collection as text and did a Ctrl   A and pasted into a text file  However  I found that not all data is copied and also that there were many comments in the text data which naturally breaks the JSON   I am wondering if RoboMongo has a Export As JSON facility so that I can do a clean export    Any pointers are appreciated

User · Answer

Solution   mongoexport --db test --collection traffic --out traffic json lt br gt  lt br gt      Where  database -  mock-server collection name -  api defs output file name -  childChoreRequest json

User · Answer

Robomongo s shell functionality will solve the problem  In my case I needed couple of columns as CSV format    var cursor   db getCollection  Member details   find  Category   CUST    CustomerId  1 Name  1  id 0    while  cursor hasNext          var record   cursor next           print record CustomerID         record Name     Output   -------  334  Harison 433  Rechard 453  Michel 533  Pal

User · Answer

A Quick and dirty way  Just write your query as db getCollection  collection   find     toArray   and right click Copy JSON  Paste the data in the editor of your choice

User · Answer

you say  export to file  as in a spreadsheet  like to a  csv   IMO this is the EASIEST way to do this in Robo 3T  formerly robomongo     In the top right of the Robo 3T GUI there is a  View Results in text mode  button  click it and copy everything paste everything into this website  https   json-csv com  click the download button and now you have it in a spreadsheet    hope this helps someone  as I wish Robo 3T had export capabilities

User · Answer

Don t run this command on shell  enter this script at a command prompt with your database name  collection name  and file name  all replacing the placeholders    mongoexport --db  Database name  --collection  Collection Name  --out  File name  json   It works for me

User · Answer

You can use tojson to convert each record to JSON in a MongoDB shell script   Run this script in RoboMongo   var cursor   db getCollection  foo   find          while cursor hasNext          print tojson cursor next         This prints all results as a JSON-like array   The result is not really JSON  Some types  such as dates and object IDs  are printed as JavaScript function calls  e g   ISODate  2016-03-03T12 15 49 996Z     Might not be very efficient for large result sets  but you can limit the query  Alternatively  you can use mongoexport

User · Answer

If you want to use mongoimport  you ll want to export this way   db getCollection  tables      find   id   q3hrnnoKu2mnCL7kE       forEach function x  printjsononeline x

User · Answer

I had this same issue  and running script in robomongo  Robo 3T 1 1 1  also doesn t allow to copy values and there was no export option either   The best way I could achieve this is to use mongoexport  if mongodb is installed on your local  you can use mongoexport to connect to database on any server and extract data  To connect to Data on remote server  and csv output file  run the following mongoexport in your command line  mongoexport --host HOSTNAME --port PORT --username USERNAME --password  PASSWORD  --collection COLLECTION NAME --db DATABASE NAME --out OUTPUTFILE csv --type csv --fieldFile fields txt   fieldFile  helps to extract the desired columns  ex  contents of fields txt can be just      userId   to only extract values of the column  userId   Data on remote server  json output file   mongoexport --host HOST NAME --port PORT --username USERNAME --password  PASSWORD  --collection COLECTION NAME --db DATABASE NAME --out OUTPUT json   this extracts all fields into the json file  data on localhost  mongodb should be running on localhost   mongoexport --db DATABASE NAME --collection COLLECTION --out OUTPUT json   Reference  https   docs mongodb com manual reference program mongoexport  use

User · Answer

There are a few MongoDB GUIs out there  some of them have built-in support for data exporting  You ll find a comprehensive list of MongoDB GUIs at http   mongodb-tools com  You ve asked about exporting the results of your query  and not about exporting entire collections  Give 3T MongoChef MongoDB GUI a try  this tool has support for your specific use case

User · Answer

Using a robomongo shell script     on the same db var cursor   db collectionname find     while  cursor hasNext          var record   cursor next           db new collectionname save record       Using mongodb s export and import command  You can add the --jsonArray parameter   flag to your mongoexport command  this exports the result as single json array    Then just specify the --jsonArray flag again when importing    Or remove the starting and ending array brackets    in the file  then your modified  amp  exported file will import with the mongoimport command without the --jsonArray flag   More on Export here  https   docs mongodb org manual reference program mongoexport  cmdoption--jsonArray  Import here  https   docs mongodb org manual reference program mongoimport  cmdoption--jsonArray

User · Answer

make your search push button view results in JSON mode  copy te result to word print the result from word

User · Answer

Expanding on Anish s answer  I wanted something I can apply to any query to automatically output all fields vs  having to define them within the print statement  It can probably be simplified but this was something quick  amp  dirty that works great   var cursor   db getCollection  foo   find      bar  1  baz  1  created at  1  updated at  1   sort  created at  -1  updated at  -1     while  cursor hasNext          var record   cursor next        var output           for  var i in record          output    record i                    output   output substring 0  output length - 1       print output

User · Answer

I don t think robomongo have such a feature  So you better use mongodb function as mongoexport for a specific Collection      http   docs mongodb org manual reference program mongoexport  export-in-json-format   But if you are looking for a backup solution is better to use  mongodump   mongorestore

User · Answer

An extension to Florian Winter answer for people looking to generate ready to execute query    drop and insertMany query using cursor            collection name     var collection name    foo           query     var cursor   db getCollection collection name  find              drop collection and insert script     print  db     collection name     drop           print  db     collection name     insertMany              print documents     while cursor hasNext              print tojson cursor next               if  cursor hasNext       add trailing     if not last item             print                     end script     print             Its output will be like   db foo drop    db foo insertMany           id    ObjectId  abc         name     foo              id    ObjectId  xyz         name     bar

[mongodb] How to export JSON from MongoDB using Robomongo

Examples related to mongodb

Examples related to robo3t