WA6.2 Use the Database Import Tool

Implementation-related information can be configured in different ways: through bulk upload/download, through the Web Application user interface. In this page, we explain how to use the openIMIS Database Import Tool to manually import the information directly into the database. 

openIMIS Database Import Tool

The openIMIS Database Import Tool is a spreadsheet that allows Implementers to define the list of medical items, medical services, diagnoses and health facilities. With the help of a Database Manager, the lists can be then imported directly into the database by executing the generated SQL scripts.

The openIMIS Database Import Tool can be downloaded from Github openIMIS Database repository.

How to use the Database Import Tool

• Open the Registers_init.ods

• Each tab corresponds to a register e.g. tblHF for Health Facilities

• Delete the sample data from the template

• Insert the data to be imported into openIMIS (the comments allows to understand how the data should be codded)

• SQL insert statements are generated in the same worksheet as data is typed in

• Copy those statement in the database manager (e.g. SQL Server management studio) and run them