#MONGODB COMPASS GROUP BY HOW TO#
#MONGODB COMPASS GROUP BY PATCH#
#MONGODB COMPASS GROUP BY PROFESSIONAL#

json file through Notepad ++, this make easier to identify and delete the data: We need to delete the standard data so that it doesnвЂ™t get duplicated after the import. Note: As mentioned earlier the exported files contains all the data from their respective function even the standard data which comes automatically after the Sage X3 installation.

#MONGODB COMPASS GROUP BY PATCH#

json files to the new server where there is already Sage X3 is installed with same version and patch level.

#MONGODB COMPASS GROUP BY HOW TO#

Here we will see how to restore the exported. In a same way you can export rest of the data. This file has all the roles available in Sage X3.

Once finished go back to the selected path you will see a.

In the above image we have named the file as Roles.json.

Click on Browse and select the path where you want to store the data and name the file with.

Click on the export button it will take to the following screen Export-Roles In which this symbol is the export button through data gets extracted. Once clicked it will take you to the below screen. In Sage X3 currently we have 57 roles out of which 3 вЂњPurchase, Sales, FinanceвЂќ are the ones manually created rest all are the standard ones. This file has all the groups available in Sage X3.

In the above image we have named the file as Groups.json. Click on the export button it will take to the following screen. In Sage X3 currently we have 4 groups out of which 1 вЂњSuper AdministratorвЂќ is the standard group which comes with the Sage X3 installation.

(As per requirement this is just an example.)Д«elow are the steps to extract data from the function through MongoDB compass. ДЇrom the above list user can extract data of below mentioned function.

Below we will see exporting the MongoDB data.

Out of all the functions the one can decide which all functions data needs to be extracted from one server and restore it in another server.

After clicking on the syracuse database it will take you to Administration.

In the above screenshot you can see the вЂњ syracuseвЂќ is the one in which Sage X3 saves all the data of Administration module.

After the successful connection application will take you to the home page which will show the database.

Enter the connection string as вЂњ mongodb://127.0.0.1:27017 вЂќ and click on CONNECT button to connect to the link.

Run the Application file with the name вЂњвЂќMongoDBCompassвЂќ from the downloaded folder.

Download the stable version MongoDb Compass as per the platforms you use.

from where the data of MongoDB will be extracted and to where it will be restored.Д«elow are the steps needs to be followed to export and import data from MongoDB from one server to another:

Both the server needs to have MongoDB Compass downloaded i.e.

Sage X3 needs to be installed on the server with same version and patch level.

To take the backup first need to check below pre-requisite.

#MONGODB COMPASS GROUP BY PROFESSIONAL#

New Stuff:- Top 3 Benefits of Greytrix Professional Services In this blog we will see how to take a backup of MongoDB and how to restore the procedure. Just like Microsoft SQL and Oracle DB Mongo DB also needs to be backed up. It also acts as part of the first layer of security alongside the Syracuse Component. Sage X3 uses Mongo DB as a storage database for the Administration Module.

Mongodb compass group by