I'm trying to pull some data from the analytics tables rather than using the
datamart tables. Unlike aggregatedindicatorvalue table from the datamart it
seems like the indicators are not pre-calculated in the analytics tables. Is
that right?
If that is the case are the indicators calculated o
Hi Hannan,
I think you should try Kenneth’s java application. We created 40,000 users
(community health workers with their phone numbers and orgunit link) and
assigned them all passwords using the app. I think Kenneth has put in a User
interface that lets you specify the server address, DHIS-
We are using Chrome mostly and have noticed that if you are using an earlier
version some things don't display. For example in the GIS module users of the
earlier version did not see the menu option: "Legend". As soon as we upgraded
it reappeared... might be a problem of cache.
Randy
From: D
I have upgraded my 2.14 database using a (slightly edited script) and
upgraded to 2.15 build revision 15163.
I can now see all of my patient tracker data - using single event without
registration.
However when I run analytics in order to create event reports, it fails:
2014-07-05 08:16:24Process
Hi all,
I have a csv file that has 608,000 records that I'm trying to import into
DHIS-2. When I select the options and begin the upload the system seems to
go into a loop, importing 10 or 11% and then starting again at zero.
Does anyone know the number of records that the import CSV tool will
a
Hi all,
I thought I saw a posting on inserting periods into the DHIS-2 for earlier
periods in time, but can't seem to find it any longer.
I need ISO weekly periods going back to 2011. I also notice that there are
some instances where there are 53 ISO weeks in a year, but that does not
appear to b
ate2ISOweek(week.starts),0,8))
>>>
>>> sql<-paste0("INSERT INTO periods
>>> (periodid,periodtypeid,startdate,enddate)
>>> VALUES(nextval('hibernate_sequence'::regclass),2,","'",as.Date(week.starts),"','",as.
Not sure if anyone else has seen this issue, but the list of datasets
displayed when selecting reporting rates is not complete. I've cleared
cache and checked the completeness table for the period in question and all
of the datasets are in the analytics table. I wonder if the SQL statement
used t
We're setting up a tracker module to capture data from individual community
health workers using Multiple events with registration.
We have the program and stage as well as attributes and data elements -
using 3 different instances of DHIS-2.
When we try to create a new instance we fill in the fo
No. Just the standard section form. We're trying in version 2.17 because
this has always worked before.
Randy
On Tue, Mar 17, 2015 at 4:19 PM, Adebusoye Anifalaje
wrote:
> Hi Randy,
>
> Are you using a custom form by any chance?
>
> Busoye
>
> On 17 Mar 2015, at 1
you using the individual records module?
>
> Can you try tracker capture app?
>
> -
> Thank you,
> Abyot.
>
> (sent from mobile)
> On Mar 17, 2015 3:15 PM, "Wilson, Randy" wrote:
>
>> We're setting up a tracker module to capture data from
yot.
>
> (sent from mobile)
> On Mar 17, 2015 3:15 PM, "Wilson, Randy" wrote:
>
>> We're setting up a tracker module to capture data from individual
>> community health workers using Multiple events with registration.
>>
>> We have the program an
gt;
>>>>>>> I just had a quick look at the tracker app on one of the Rwanda
>>>>>>> dhis2 instances (it is running 2.17 built on 2015-01-21 02:05 -
>>>>>>> strange I don't see the build revision)
>>>>>>>
>>>&
We have been using the tracker module (multiple events with registration)
to store imported quarterly data reported by Community Health Workers
through rapidSMS. These CHWs are registered - and linked to the Health
Centers that supervise them - then each quarter new datavalues are added
counting t
Hi All,
We're trying to synch facility data between DHIS-2 and a new Provider
Registry linked to iHRIS using the API. I've created a SQL view that works
nicely to pull all of the data and I am able to filter for exact matches
(e.g.). (I can't seem to get the FRED API to work in version 2.20).
h
I've been struggling to get data from the web API into JasperStudio to
create standard iReports.
I've created a new datasource of type: XML document (remote)
I can pull data from sites that don't need authentication into the iReport,
such as this rss feed from bbc:
http://feeds.bbci.co.uk/news/rs
Hi all,
We have an big issue with several of Rwanda's event reporting systems that
have been set up using Tracker/Individual records. For some reason, users
are able to create duplicate records in the system through normal data
entry. It seems to happen when they enter a value for an attribute a
Regards
> Ant
>
> On 9 October 2015 at 10:22, Wilson, Randy wrote:
>
>> Hi all,
>>
>> We have an big issue with several of Rwanda's event reporting systems
>> that have been set up using Tracker/Individual records. For some reason,
>> users are able to
Hi Arthur,
If you haven't done this already, attached is an excel template that you
can use to transform your indicator list into fields that can be imported
into the DHIS-2 indicator table. I've left a couple of sample rows for you
to see what the content should be like. Note that after you ha
ffe
> wrote:
>
>> If you experience reasonably high latency (slow response times) it seems
>> quite likely you might well get duplicates. Probably related to
>>
>> https://bugs.launchpad.net/dhis2/+bug/1498505
>>
>> On 9 October 2015 at 15:40, Wilson, Randy wr
Not here unfortunately...just doing csv imports from DHS Excel files. Would
be useful for our data warehouse.
Randy
On Jan 29, 2016 2:59 PM, "Olav Poppe" wrote:
> Hi all,
> I wanted to hear if anyone has any experience with the DHS API (
> http://api.dhsprogram.com/#/index.html), and using it to
kettle and be pain
> resistant to a certain degree :-)
>
> I'd be interested to hear from other experiences ...
>
> Have a nice sunday,
>
> Uwe
>
> ---
>
> Am 29.01.2016 um 17:31 schrieb Wilson, Randy:
>
> Not here unfortunately...just doin
Has anyone else had an issue with updating the dataelement table on the
backend? I've cleaned up my data element names changing "# of" to "Nb of" and
browsed the table in pgadmin and it looks fine. When I start DHIS-2 live, it
initially displays the revised names, but as soon as I edit a data
-Original Message-
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Sunday, April 10, 2011 9:00 AM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Issue with updating Dataelement names through
Postgress backend
You might should try clearing your
MySQL - it
doesn’t move any of the orgunits or datavalues. I've also downloaded the
latest .jar file. Maybe my installation is damaged.
Randy
-Original Message-
From: Knut Staring [mailto:knu...@gmail.com]
Sent: Sunday, April 10, 2011 9:46 AM
To: Jason Pickering
Cc: Wilson,Ran
Thanks Lars,
That did the trick! I truncated the translation table and the data loaded fine
after a restart.
Mystery solved.
Randy Wilson
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Sunday, April 10, 2011 1:20 PM
To: Knut Staring
Cc: Wilson,Randy; dhis2-users
Thanks to all for your help. Now I have a different issue. I can’t create or
edit any of my charts. I can run them though.
For you Sunday DHIS community members, here is the error I get:
[+] Exception
(org.hibernate.InstantiationException): Cannot instantiate abstract class or
interface: org
e to check for things first.
Randy
-Original Message-
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Sunday, April 10, 2011 8:42 PM
To: Wilson,Randy
Cc: Knut Staring; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Issue with updating Dataelement names through
Thanks for the updates. I've installed 2.2 on our server and my local machine
without many issues.
In the GIS module some of our computers, there is a message that pops up saying
that Google Maps needs to get a different Google Maps API key. When the user
clicks on ok, the software loads fine
We've been setting up DHIS-2 as a health data warehouse and dashboard for
Rwanda. So far it has gone well, but I have found no useful documentation
about how to manage admin unit target populations ... crucial for any coverage
indicator calculations.
Ideally we'd like to store the populations
would be ideal if we could use one single record in the
database or perhaps one per year rather than having to create hundreds of
records with the same values.
Randy
From: samuel cheburet [mailto:samuelchebu...@gmail.com]
Sent: Wednesday, May 11, 2011 9:12 PM
To: Wilson,Randy
Cc: dhis2-
I haven't seen this requirement yet, but in Rwanda we are using DHIS-2 as the
national data warehouse and dashboard. I would like to see an option for
public users to be able to sign on and create their own username and passwords.
This would entitle them only to access the dashboard and GIS mo
I'm having serious problems getting the orgunit hierarchy and GIS modules to
work in 2.5. I downloaded the war file and replaced the DHIS folder in apache.
Is there something I missed? Should I have converted the data first?
Previous working platform was 2.4.
Is anyone else having the same
I'm not sure if anyone noticed this yet, but the data element selection dialog
for the chart module does not function correctly, it allows you to select data
elements, but it does not display category combinations. In our case FP_Oral
Contraceptives should display sub categories (New Users) or
from the data element category combo boxes in the Indicator
definition dialogs? Is this in a blueprint somewhere?
Randy Wilson
From: olati...@gmail.com [mailto:olati...@gmail.com] On Behalf Of Ola Hodne
Titlestad
Sent: Friday, November 18, 2011 10:55 AM
To: Wilson,Randy
Cc: dhis2-users
Subject
This is an interesting issue to Rwanda as well - we have similar requirements.
Just a quick thought, would it not be possible to use the DHIS-2 user's orgunit
access (as assigned when setting up the User by orgunit) to do this filtering?
How exactly could that be accessed in a view or report ta
I'm creating a user role called Helpdesk in DHIS 2.6 and their role is simply
to add accounts and reset user passwords.
I've assigned them every function with user in it (Add, list, delete) users,
user groups, user roles.
When I create a user and assign them to this role at the national level,
We're trying to rebuild our dashboards with charts produced with the data
visualizer in Version 2.6.
I'm trying to build charts using data elements. To ensure I see data, I'm
picking national level for the org unit and selecting this year as the time
period for which I clearly see data in the
Hi Mark,
This is exactly what we're doing in Rwanda. We've set up one instance of
DHIS-2 as our HMIS (for routine data entry by health facilities across the
country) and a second instance as a national data warehouse/dashboard - more
intended for program managers, implementing partners and don
Hi all,
The Rwanda team now has 3 months of data from over 400 sites in the DHIS-2.
We're impressed with how well it has worked even in low bandwidth conditions.
Congratulations to the team who built in the offline editing functionality.
Now we're on to reporting and find a number of immediat
m report? There is a quite good section in the
implementers manual on how to use iReport.
Best regards,
Jason
On Wed, Mar 21, 2012 at 9:14 AM, Wilson,Randy
mailto:rwil...@msh.org>> wrote:
> Hi all,
>
>
>
> The Rwanda team now has 3 months of data from over 400 sites in the DHIS-2
Thanks for the quick reply Lars. Yes we are talking about the data element and
other object translations... not the UI. It would be good to push the locales
into a table for future versions.
Now that we've convinced the system that Swahili "sw" is really Kinyarwanda and
I've added 3 rows for e
Has anyone used DHIS-2 to enter child death audit forms? We're working on this
in Rwanda and thought we would check on other country experiences first. We
planned to use the name-based data entry for individual records, but it seems
like calling deceased children 'beneficiaries' is a bit drole
ent: Friday, May 25, 2012 10:07 AM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] DHIS-2 for child death audit forms
Hi,
not aware of any child death audit forms, but in Uganda they are working on a
maternal death audit.
There are actually three separate supported u
I wonder if this report pulls data from the data mart. If so you will need to
run the data mart process before you will see any reports. Typically it is
scheduled to run at night, but if you want to see your data the same day you
need to run it from the Reports menu.
Randy Wilson
HMIS Advisor
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
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 b
I'm not sure if others have seen this problem with version 2.8. I'm getting an
error: duplicate declaration of parameter: REPORT_LOCALE when I click on
download JRXML template in the report tables module.
This makes it impossible to customize reports based on the system generated
report templa
Hi all,
We've created an anonymous event data entry screen for entering Child Death
Audit forms into DHIS-2 but have a couple of issues:
1. Once an event is entered and data entry completed, there appears to be
no way to retrieve it for corrections or further editing - say by supervisors
In Rwanda we are trying to use the DHIS-2 platform for a national data
warehouse and dashboard. This stores historical data on selected (key)
indicators going back for more than 10 years. Generally the exercise seems to
be working well, but we have just noticed an issue regarding the Data
Visu
Thanks for anticipating our needs so effectively. I look forward to the new
version.
Randy
From: Jan Henrik Øverland [mailto:janhenrik.overl...@gmail.com]
Sent: Monday, July 23, 2012 11:56 AM
To: Lars Helge Øverland
Cc: Wilson,Randy; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users
We've just upgraded one of our test instances of DHIS-2 to version 2.9. For
some reason the orgunit hierarchy has been flattened - only the lowest level is
displayed and there are no parents (see screen shot below). I have rebuilt the
resource tables and cleared the cache.
The parent units ar
I've just set up a new laptop and have not been able to find the correct
psqlodbc driver to use with DHIS-2 running Postgres 8.4.
The only drivers that install and show up in the ODBC drivers when I create a
new data source are the x64 drivers. The other drivers seem to install
correctly but d
he 32 bid postgres
driver is listed and you can create your data source as you like.
Randy Wilson
-Original Message-
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Wednesday, August 08, 2012 4:10 PM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [
Hi Jason,
Can you suggest a viewer to look at the .dia files? I couldn't find anything
that matches on google.
For the .neato files users can download the open source program graphviz at :
http://www.graphviz.org/Download_windows.php
Randy Wilson
From: dhis2-users-bounces+rwilson=msh@lis
I'm not sure if others have had this issue, but in Rwanda we have some of our
forms in both French and Kinyarwanda. We have translated all of the data
elements and are using section forms. In theory, when we use section forms
rather than custom forms, the data element names should change autom
__
From: dhis2-users-bounces+rwilson=msh@lists.launchpad.net
[dhis2-users-bounces+rwilson=msh@lists.launchpad.net] on behalf of
Wilson,Randy [rwil...@msh.org]
Sent: Friday, September 07, 2012 2:49 PM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Problem displaying
o all Chrome users because clearing cache is a common issue we spend a lot
of time on during training - and the built-in tools don't seem to work.
Randy
-Original Message-
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Monday, September 10, 2012 12:25 PM
To: Wilso
We have some data elements that have very specific data validation rules:
values can be either 0 or 5, but not any other number (including 1,2,3,4)
As a result, the Min-Max setting doesn’t work and I don’t see how one of the
validation rules can be set up with two options for the same dataelement.
We have created a variety of custom iReports that pull data from the
aggregateddatavalue, dataelement, organisationunit tables and a foreign table
that stores PBF tariffs (included in the same database). They run fine in
iReport preview and I can install them in the standard reports list, but w
This can get a lot more complicated if you have already begun making charts,
maps, report tables, etc and have saved favorites.
You should also make sure that the dataelementid is not used in any of the
following tables:
Dataelementgroupmembers
Mapview
Chartdataelements
Datadictionarydatael
In Rwanda we have found report tables and MyDatamart inadequate for the needs
of many of the central level health programs. What they want is a dump of all
the datavalues in specific dataelement and indicator groups along with the
related orgunit hierarchy. We originally were doing this using
f data and the pivot table drill-down/float-up
capabilities are very helpful. I'm not sure how we can get around the need to
drop and rebuild these tables.
Randy
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Thursday, December 20, 2012 10:51 PM
To: Jason Pickering
Cc: Wils
orgunits). As a result we need to
be able to create SQL views that include these foreign tables to be used as the
datasources for standard reports.
Randy
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Friday, December 21, 2012 12:05 PM
To: Lars Helge Øverland
Cc: Wilson,Randy
Thanks Jan, That did the trick. By the way when you save a facility map as a
favorite it only reloads the boundry layer, not the facilities.
Randy
From: Jan Henrik Øverland [mailto:janhenrik.overl...@gmail.com]
Sent: Friday, January 11, 2013 3:20 PM
To: Wilson,Randy
Cc: dhis2-users
Hi Martin,
Yes, we have done this quite a few times in Rwanda. I can send you the excel
template and the SQL queries needed to update the various user table. The only
thing we can't do is create the hashed password. Normally I send the
spreadsheet to Knut or Bob Jolliffe and they create the
Attached are some instructions and a template file that you can use to collect
the data in excel - I would test on a local copy of the database before using
on the production server.
Randy
From: dhis2-users-bounces+rwilson=msh@lists.launchpad.net
[mailto:dhis2-users-bounces+rwilson=msh
We've been trying to publish iReports in our DHIS-2 instance using custom
queries and parameters, but continue to receive errors. I was hoping to see
some examples on the demo site, but they are all based on report tables. Could
someone put some examples of iReports based on custom postgres que
hanks,
Randy
From: Olav Poppe [mailto:olav.po...@me.com]
Sent: Friday, February 15, 2013 9:49 AM
To: Wilson,Randy
Cc: DHIS Users
Subject: Re: [Dhis2-users] Example of iReport based on custom query on DHIS-2
demo site?
Hi,
below is an example of an ireport using custom SQL, with report parameters
Does anyone have suggestions for the optimal settings for JAVA_OPTS on a 4 gig
Windows 7 64 bit OS?
My computer hangs every time I try to run the DATAMART process.
Current settings are: SET JAVA_OPTS=-Xmx6000m -Xms3000m -XX:MaxPermSize=500m
-XX:PermSize=300m
Randy Wilson
_
Knut Staring [mailto:knu...@gmail.com]
Sent: Saturday, February 23, 2013 2:46 AM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Optimal settings for JAVA_OPTS on a 4 gig Windows 7
computer?
Hi Randy,
This is proobably not the solution, but just yesterday I had a pr
Thanks Saptarshi. These settings worked like a charm. I guess I still need to
add some more memory if I want to update our big dataset frequently.
Randy
From: Saptarshi Purkayastha [mailto:sun...@gmail.com]
Sent: Saturday, February 23, 2013 3:23 AM
To: Wilson,Randy
Cc: dhis2-users
Hi David,
You might be able to create a view of the tracker data that you can use for
analysis. I've done something similar in Rwanda for an infant death audit form
that we've developed using the individual records module. I'm not using
program stages - just single event without registration.
Hi Adedayo,
Sounds like it might be a cache problem. Have you tried to run the data entry
form in Chrome's incognito or Mozilla private browsing windows? If that works
then you should clear the browser cache as well as the cache under Data
administration in DHIS2.
Randy
From: dhis2-users-bo
Hi all,
I've just loaded version 2.11 - I like some of the new features, but I can't
seem to get the datamart process to start. I ran resource tables and have
scheduled the daily process to the level I want. But from within the Reports
menu when I try to run for the last year I see a progress
Hi all,
Our HIV team works with civil society organizations and local partners to track
a very simple list of services provided to persons living with HIV/Aids.
The data elements themselves are all numeric so it would be easy to do in a
regular data set, except that partners don't fit well in t
In Rwanda, we have tried to keep things simple by entering only total
population figures for province, district, sector and health facility levels
for each year.
We have then created indicators for each of the major target population groups
by using census breakdowns and multiplying the total p
We've been working some more with the patient records module as well and have
discovered that the category combinations don't render either.
For example we have data we're collecting on number of VCT tests by different
at risks groups (MARPS). I was trying to set up a data entry form with
cate
nship between a partner (or source) table and the
organisationunit table and make that part of datavalue table.
Randy
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: Wednesday, March 27, 2013 10:43 PM
To: Ola Hodne Titlestad
Cc: Wilson,Randy; dhis2-users@lists.launchpad.net; James
rsday, March 28, 2013 7:51 PM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Any suggestions for partner reporting in DHIS-2?
Hi Randy,
on this issue there are lots of opinions - my recommendation would be to stick
to the aggregate part of the system and leave ou
Perhaps this has been fixed in 2.11, but I can't seem to create or update
visualizer favorites to add to the dashboard anymore in our version 2.10 build
9057 on our production server. I've created several dozen charts that work
fine, but can't seem to do anything new. After saving I get the me
Hi Jim,
This is very similar to the data element that many countries use for family
planning users at the end of the month and you are right it is a bit of a pain
that DHIS-2 doesn’t support this sort of analysis right out of the box. We
have health facilities report this cumulative indicator
Just checked out the new data visualizer... great to be able to select category
option combinations now! It seems that none of my favorites from version 2.11
work. Error message when I load them is: "No filter dimensions specified".
We have created many charts for various dashboards. Is there
Hi Johannes,
I'm not sure how DHIS-2 automatically creates the entries in the period table,
but once they are created would one of the following options work?
· Pre-fill the period tables with weekly records for several years
forward, then hack the period table to reset the start/end d
We've just upgraded all of our instances to 2.12 and it seems that none of the
indicators of type number (i.e. with a denominator of one) are not calculating
correctly.
When I try to edit the numerators, I see that the expressions are well formed
and can save the denominator, but when I try to
[mailto:morte...@gmail.com]
Sent: Friday, July 12, 2013 4:53 AM
To: Adebusoye Anifalaje
Cc: Wilson,Randy; dhis2-users@lists.launchpad.net; DHIS 2 developers
(dhis2-d...@lists.launchpad.net)
Subject: Re: [Dhis2-users] DHIS-2 version 2.12 - bug with saving indicators
without denominators
Hi Randy
Just
Hi Knut,
I had a similar problem… when I changed form types from custom to section. In
the end I had to create a new dataset and it worked ok.
Randy
From: Dhis2-users
[mailto:dhis2-users-bounces+rwilson=msh@lists.launchpad.net] On Behalf Of
Knut Staring
Sent: Friday, July 26, 2013 1:35 P
Hi all,
Here is the standard hibernate file that works for me on a Windows localhost
instance of DHIS-2.
You should only have to change the varibles in bold.
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection
datavalue.periodtypeid= 4
and aggregateddatavalue.dataelementid in
(SELECT
dataelementid
FROM
public._dataelementgroupsetstructure where thematic_area='MARPS');
ALTER TABLE _view_healthfacilityhierarchy OWNER TO dhis;
Do you have any other suggestions?
Randy
From: Lars Helge Øverland [mailto:la
Hi all,
We’ve been asked to advise on software that the national level TB program can
use to track TB multi-drug resistant patients. They are not collecting a lot
of data, but want nominative lists to better follow outcomes.
Has anyone done something of this sort using DHIS-2 patient tracker m
Hi Jose,
I had the same problem as your image of problem 2. When adding a new entry,
the fields did not appear. The happened any time I changed the individual
records data set by adding or subtracting data elements. I was able to resolve
it by restarting the DHIS-2 instance. In the log we s
We're having trouble with population data aggregation in DHIS-2 version 2.12.
Our organizational unit hierarchy is the following:
National - no pop data entered
Provincial - no pop data entered
District - pop data exists (selected as an aggregation level)
Sub-district - no pop data entered
Secto
Hi John,
You also may need to clear your cache Or try to use a Chrome Incognito
window.
Randy
From: Dhis2-users
[mailto:dhis2-users-bounces+rwilson=msh@lists.launchpad.net] On Behalf Of
Dan Cocos
Sent: Wednesday, August 21, 2013 5:53 PM
To: John Ojo
Cc: dhis1-users; DHIS developers
Su
We're trying to extend our dataelement and indicator attributes with some
custom attributes so that we can store our entire metadata dictionary for
Rwanda. I have created the new fields and they display correctly, but I can't
find the table where the attributes and their values are stored. We
Hansen
Cc: Wilson,Randy; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Where are custom dataelement/indicator attributes
stored
Hi Randy, its interesting to hear that you are using DHIS 2 for data dictionary
purposes.
The tables related to data element attributes are:
attribute (you
Busoye is right. You need to make sure that the data elements are deleted from
all the tables where they may appear (below is a list of most of them):
Dataelementaggregationlevels
Dataelementaggributevalues
dataelementgroupmembers
dataelementoperand
datasetmembers
datavalue
datavalue_audit
datav
I think I may have seen something related to this before but can't seem to get
it to work. When I want to select all of the districts from the orgunit
hierarchy for a pivot table, I can select any that are visible, but the
remaining districts in Western province are not visible (off the screen)
idea.
Thanks,
Randy
From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Thursday, August 29, 2013 12:01 PM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem selecting all districts in orgunit hierarchy
in pivot table module
Hi Randy,
On Thu, A
We've had to make a special query to retrieve text fields from a dataset
developed in the aggregate data module.
It runs fine in iReport, but when I try to run it as a standard report within
DHIS-2 it get the following error. Does anyone have experience with this.
Do I need to change my settin
I believe those table are blocked to prevent non-system administrators from
viewing user data.
If you have Pgadmin access or have installed PHPpgadmin on the server, you can
run the queries there. SQL views in DHIS-2 are also problematic especially if
you refer to any of the resource tables be
1 - 100 of 144 matches
Mail list logo
