Import tools

Some templates were created to import data into openIMIS; these can be useful when gathering data from external systems in order to initialise openIMIS.

The templates can be found in here.

Instructions:

  • 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
  • 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