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