Hot answers tagged

3

You can find the answer in the following tutorial: https://www.dhis2.org/change-appearance-of-dhis2-login-screen A common challenge when you updated your installation of DHIS 2 is that custom changes to appearance (such as the login page) are overwritten when the application is updated. If you want customize the look of DHIS 2 with a Cascading Style ...


2

I used pgAdmin4 to execute SQL requests. I wanted to remove all the data I imported via the DHIS2 Import/Export tool (I imported the data on Oct 15 2018). First I selected the data to insure that, that's what I wanted to remove: SELECT * from public.datavalue WHERE created >= '2018-10-15'::date ORDER BY created DESC limit 5000; Then I removed the data:...


2

There is no such function currently for bulk deletion of data as of version 2.19. It has been considered to risky to do that through the UI. You can delete data records using SQL against the "datavalue" database table. When adding data elements to data sets the data entry form should automatically be updated. The data entry forms are cached locally in the ...


2

Yes. While DHIS2 was primarily designed for HIS use, its development has shifted towards a flexible meta-data approach. There's a beautiful guide available here: How to Set-up DHIS2 in a New Context? https://www.mn.uio.no/ifi/english/research/networks/hisp/integrated-health-information-architecture/ch-07.pdf


2

I assume you mean a root organisation unit? You can do that from the organisation unit app: Organisation Units app -> Organisation Unit -> Add new button in the upper right corner. The first organisation unit you create will be the root of the organisation unit tree. However I would recommend using the Sierra Leone demo database from https://www....


2

For this to work properly (currently) you need to generate an ID (/api/system/id) and then modify the payload like this: { "id": "generated-id", "firstName": "John", "surname": "Doe", "email": "johndoe@mail.com", "userCredentials": { "userInfo": { "id": "generated-id" }, "username": "johndoe", "password": "your-password-123", "...


2

You can use the CSV import format which is described in this section of the docs: https://docs.dhis2.org/master/en/developer/html/webapi_data_values.html#webapi_data_values_csv You can either upload the file through the user interface from Apps > Import / Export > Data import, then select CSV as format. You can also use the Web API to achieve the same, ...


2

I'm sure by now you've figured a way around this issue but please remember that your fixed [Number of "available" Beds] is in fact a semi-permanent number that can change at any time if one becomes damaged; You'll have much more flexibility by capturing two sets of values each month; you can also set up a custom entry form to make it simpler for users


2

One way to get closer would be to think of a period for which the "Available beds" is valid. E.g. if you decide it's good enough to update this value every year or every 6 months then put this data element in a data set with Yearly or Six-monthly period type. Make sure the aggregation operator for your "Available beds" data element is set to "Average (sum ...


2

If you want the same data elements in both data sets, but different disaggregations for those data elements, this can be done in version 2.25 and following. When assigning a data element to a data set, you can override the category combination as defined in the data element with a category combination that is specific to the data element as it is used in ...


2

DHIS 2 version 2.28 provides support for reCAPTCHA v2. Please upgrade to DHIS 2 version 2.28 or later. reCAPTCHA v1 is discontinued as of March 2018. You need to register an account with Google, register your site and retrieve a site key and secret key from https://www.google.com/recaptcha/. The site and secret key must be set up within DHIS 2 from Apps > ...


1

To achieve this I think you should use the "org unit group" selection mode. Under the organisation unit dimension section, click the gear icon and select "Select groups", then select the org unit group which contains the org units you would like to display. In the org unit tree you can leave the selected org unit at the national level if you would like to ...


1

To remove ALL tracker data from your DHIS2 database run the following sql commands in order: delete from trackedentitydatavalue; delete from programstageinstance; delete from programinstance; delete from trackedentityaudit; delete from trackedentityattributevalue; delete from trackedentityinstance; WARNING: This cannot be undone From https://www.npmjs.com/...


1

Yes that is the best way at the moment. We do have primitive support for logical operators (applies to entire query) so you could combine it like /api/indicators?filter=numerator:like:fbfJHSPpUQD&filter=denominator:like:fbfJHSPpUQD&rootJunction=OR


1

Yes you can achieve that using the option for overriding the category combination (disaggregation) for data elements based on their membership in a data set. This feature was introduced in version 2.25 so you will have to upgrade to 2.25 or later. Do this: Ensure that you have created all categories for the new dis-aggregation. Create a new data set using ...


1

You have an invalid value in the "dataelement" and/or "trackedentityattribute" tables for the valuetype column. The valid values are these: TEXT LONG_TEXT, LETTER, PHONE_NUMBER, EMAIL, BOOLEAN, TRUE_ONLY, DATE, DATETIME, TIME, NUMBER, UNIT_INTERVAL, PERCENTAGE, INTEGER, INTEGER_POSITIVE, INTEGER_NEGATIVE, INTEGER_ZERO_OR_POSITIVE, TRACKER_ASSOCIATE, ...


1

A data element can be part of multiple data sets. A DHIS2 data value is linked to data elements, not data sets. The implication is that if you have a data element being part of multiple data sets and enter a data value for the first data set, then the data value will show up pre-filled in the other data set when you open it. So there will not be duplication,...


1

DHIS2 allows for encryption of data. This however requires some extra setup. DHIS2 uses an encryption algorithm classified as strong and therefore requires the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files to be installed. These files can be installed through these steps: Download the JCE Unlimited Strength Jurisdiction ...


1

At the moment, we are not storing time-stamp only date. So the maximum we can do is sort by date - which we are doing currently. We have plan to handle time-stamp / timezone in the future.


1

Currently the approach to achieve this is to rely on the alphabetical ordering of SQL view names. For the scheduled tasks, the system first drops the SQL views in reversed alphabetical order. Finally, the system regenerates the SQL views in alphabetical order. So in your case where A depends on B, you should ensure that that the name of SQL view B comes ...


1

This means that someone has put the DHIS 2 analytics engine in maintenance mode. This is useful when you need to do maintenance on the database server as load will decrease. To disable the maintenance mode you can go to: Apps > Settings > General and uncheck the Put analytics in maintenance mode checkbox. Your favorites should now render normally ...


1

You will have to regenerate the analytics tables for this to take effect in the GIS module. This goes for all analysis apps in DHIS 2, such as pivot table and data visualizer. To generate analytics tables, go to Reports > Analytics. You can schedule the analytics tables to run periodically from Data administration > Scheduling.


1

You will have to create the hibernate.properties config file yourself. Note that after version 2.22 the file is called dhis.conf. You can place the configuration in whichever location you prefer. You must define an environment variable called DHIS2_HOME which points to the directory in which you placed the dhis.conf / hibernate.properties file. You can ...


1

This feature has been greatly improved in DHIS version 2.24. I recommend that you upgrade your DHIS version and try again. In 2.24 you can simply click the file icon next to each data entry input field and upload your file.


1

You can classify organisation units and later do analysis based on the classification through Organisation unit group sets. Go to the organisation units module. According to your example: Create organisation unit groups for each type of health facility you need, e.g. "Dispensary", "Clinic", "Facility". Make sure that you select the appropriate organisation ...


1

Events in tracker capture are displayed in a sorted manner. They are sorted using eventDate (or dueDate if the event is under schedule).


1

Please check your database server version with the version of dump you are going to import. Your dumped database server version mentioned above of the sample database dumped file Example: PostgreSQL database dump Dumped from database version 10.4 Dumped by pg_dump version 10.4 I have found the similar issues with Postgres 11 later downgrade of my ...


1

Assuming this is Windows only. Its a 4 step process: Download the demo database from the dhis download site. It's about 188 MB. Unzip it to get a 2.4GB sql file! Restore the demo database using psql. You may need to create a database and its user in pgAdmin, or CLI. use google here. Find psql somewhere in C:\...\PostgreSQL\bin. You can use Windows search. ...


Only top voted, non community-wiki answers of a minimum length are eligible