Access to the Utilities is restricted to the users with the role of openIMIS Administrator. The Utilities is the place for database administration. By having access to this page, it is possible to backup and restore the openIMIS operational database and also to execute SQL Scripts (patches provided for maintenance or update of the database). At the top of the page, the current “Backend” version is displayed for reference.
NavigationAll functionality for use with the administration of utilities can be found under the main menu Tools , sub menu Utilities ![](https://openimis.atlassian.net/wiki/download/thumbnails/3722379864/image211.png?version=1&modificationDate=1708033302649&cacheVersion=1&api=v2&width=576) Img. 288 Navigation Utilities
Clicking on the sub menu Utilities re-directs the current user to the Utilities Page. ![](https://openimis.atlassian.net/wiki/download/thumbnails/3722379864/image212.png?version=1&modificationDate=1708033302656&cacheVersion=1&api=v2&width=574) Img. 289 Utilities Page
BackupBackup utility can be found in the top panel of the Utilities Page. By default the path of the backup folder will be populated from the default table. User can change the path according to the requirement. Next to the textbox user can see one heck box called Save Path . If user wants to update the backup folder in default table then this check box should be in checked state. Otherwise system will take the backup on the folder assigned by the user but it will not be updated in database. So next time when user comes on the Utilities Page, the textbox will be populated with the original path. After the path has been entered user can just click on the Backup button to start the process and a progress bar will be appeared on the screen. Users are requested to be patient while the system performs the task. ![](https://openimis.atlassian.net/wiki/download/thumbnails/3722379864/image213.png?version=2&modificationDate=1708033302687&cacheVersion=1&api=v2&width=408) Img. 290 Backup is in progress
RestoreRestore utility can be found in the second panel of the Utilities Page. User will have to put the path of the backup file to be restored. After the path has been entered user can just click on the Restore button to start the process and a progress bar will be appeared on the screen. Users are requested to be patient while the system performs the task. ![](https://openimis.atlassian.net/wiki/download/thumbnails/3722379864/image213.png?version=2&modificationDate=1708033302687&cacheVersion=1&api=v2&width=340) Img. 291 Backup is in progress
Execute scripExecute script can be found in the third panel of the Utilities Page. User will have to choose the script by clicking on the browse button. User will have to select the file only with the .isf extension. After the file has been chosen, user can just click on the Execute button to run the script. Users are requested to be patient while the system is executing the script. After the script is executed successfully, backed version will be updated to the latest version. If user will try to run the lower or the equal version’s script then system will prompt the user with the appropriate message
|