2/11/2023 0 Comments Robomongo download as excel![]() ![]() This extracts all fields into the json fileĭata on localhost (mongodb should be running on localhost) mongoexport -db DATABASE_NAME -collection COLLECTION -out OUTPUT. To only extract values of the column 'userId'ĭata 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 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įieldFile: helps to extract the desired columns, ex: 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 There is a high chance of finishing and including this feature in Robomongo 1.2 which will be planned soon after we release Robomongo 1.1 release with MongoDB 3.4 suport in a week. ![]() See also: mongoimport which provides the corresponding structured data import capability. Run mongoexport from the system command line, not the mongo shell. 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. mongoexport is a command-line tool that produces a JSON or CSV export of data stored in a MongoDB instance. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |