I am using dhis2 version 2.7 for Bangladesh health ministry. With 2.7 version, I can create data visualize reports but I can not make favorite of this report because It shows “no data” errors. Before creating Data visualize report I update the Data mart. Actually I want to update the dashboard with chart. So, how can I add chart in dashboard from data visualize module.
We had a similar problem here in Rwanda with the option to create favorite charts in the data visualizer. Bob Jolliffe and checked the logs and it turned out that the charts table had a legacy column (title) which was redundant and should have been cleared in the system upgrade. We removed this column manually and the charts saving problem was resolved.
If you have access to the backend through PGadmin, you can browse the tables and modify the structure of the charts table – removing the title field if it exists.
I am using dhis2 version 2.7 for Bangladesh health ministry. With 2.7 version, I can create data visualize reports but I can not make favorite of this report because It shows “no data” errors. Before creating Data visualize report I update the Data mart. Actually I want to update the dashboard with chart. So, how can I add chart in dashboard from data visualize module.
Thanks you.
Fatema Uddin---------------------------------------- Computer Programmer HMIS
Priority Area Health.
Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh
Phone: +880 2 966 53 13
Fax: +880 2 966 53 14
We’re looking into using DHIS-2 to send SMS alerts to cell phones when monthly stock reports indicate that a facility is below a certain threshold. Is this supported by the mobile phone reporting module? Has anyone written code to do this from outside of DHIS-2? We thought it might be useful to build this into the chron job that refreshes the datamart each night.
This will be a good opportunity for the "GURUS’ of DHIS to use the mobile application and more so the SMS and the feedbacks. It will also address the surveillance issues and some of the areas that may be of high impact interventions in countries.
We’re looking into using DHIS-2 to send SMS alerts to cell phones when monthly stock reports indicate that a facility is below a certain threshold. Is this supported by the mobile phone reporting module? Has anyone written code to do this from outside of DHIS-2? We thought it might be useful to build this into the chron job that refreshes the datamart each night.
Hi Randy,
We are doing something similar to this, but have not go so far as to
actually send out the SMSes yet, although we will soon. I have
developed scripts using R which interface directly to the DHIS2
database and extract out which reports are missing. Currently, the
server will email a specially formatted text file to the designated
national programme officer, who will send out the SMSes in bulk though
the local Zambian network to remind people to report. We have tested
the functionality with the Clickatell API, and this also works, but as
I said, we have not put either method into actual practice yet.
I know of no way to do this through DHIS2 directly, although it might
be possible through the WebAPI. However, I am sure in order to
automate this, you would need some script to interface into the API,
effectively an alert system.
It is not particularly difficult using this approach I think, and I
guess R and/or Python would both be effective tools for this purpose.
Best regards,
Jason
···
On Wed, Jun 6, 2012 at 2:11 PM, Wilson,Randy <rwilson@msh.org> wrote:
Hi all,
We’re looking into using DHIS-2 to send SMS alerts to cell phones when
monthly stock reports indicate that a facility is below a certain
threshold. Is this supported by the mobile phone reporting module? Has
anyone written code to do this from outside of DHIS-2? We thought it might
be useful to build this into the chron job that refreshes the datamart each
night.
Thanks both of you. I follow your description Wilson. Just delete the Chart table column title and now it is working.
Thanks
Best Regards
Fatema Uddin
···
On Tue, Jun 5, 2012 at 8:51 PM, Wilson,Randy rwilson@msh.org wrote:
Hi Uddin,
We had a similar problem here in Rwanda with the option to create favorite charts in the data visualizer. Bob Jolliffe and checked the logs and it turned out that the charts table had a legacy column (title) which was redundant and should have been cleared in the system upgrade. We removed this column manually and the charts saving problem was resolved.
If you have access to the backend through PGadmin, you can browse the tables and modify the structure of the charts table – removing the title field if it exists.
Sent: Tuesday, June 05, 2012 8:03 AM To:dhis2-users@lists.launchpad.net Subject: [Dhis2-users] Data Visualizer favorites issue in 2.7
Dear All,
I am using dhis2 version 2.7 for Bangladesh health ministry. With 2.7 version, I can create data visualize reports but I can not make favorite of this report because It shows “no data” errors. Before creating Data visualize report I update the Data mart. Actually I want to update the dashboard with chart. So, how can I add chart in dashboard from data visualize module.
To the best of my knowledge, this is already being done in India, but I am not sure whether it is in the “mainstream” DHIS2 … sundeep or John *copied) should be able to help with details
We’re looking into using DHIS-2 to send SMS alerts to cell phones when monthly stock reports indicate that a facility is below a certain threshold. Is this supported by the mobile phone reporting module? Has anyone written code to do this from outside of DHIS-2? We thought it might be useful to build this into the chron job that refreshes the datamart each night.
*"HealthInformation Management - Making a World of Difference”