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